I’m not sure if this is possible or if I need to do a MySQL query (which I’ll need help with!!). I have a video weblog that allows the users to either upload a video or provide a url to a video on another server. There is another page (the home page) that queries that weblog for the most recent entry and displays it on screen. Is it possible to limit the weblog:entries tag to whether or not the {video_url} tag exists? it would be something like this:
{exp:weblog:entries weblog="videos" dynamic="on" limit="1" WHERE video_url=="blank"}
or, alternately
{exp:weblog:entries weblog="videos" dynamic="on" limit="1" WHERE video_flv!="blank"}
but would be real and work???
thanks!