ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

limit entries by content - weblog query question

November 01, 2007 2:20pm

Subscribe [2]
  • #1 / Nov 01, 2007 2:20pm

    julie p

    282 posts

    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!

  • #2 / Nov 01, 2007 4:10pm

    Lisa Wess

    20502 posts

    There is an extension by Mark Huot that will allow you to do this; otherwise you would need a direct query. I forget the name of the extension, but you can find it in our extensions forum. =)

  • #3 / Nov 01, 2007 5:14pm

    Mark Bowen

    12637 posts

    I think you perhaps mean this one?

    Custom Field Limiter 😊

    Also you can find links to all his extensions for EE here at : http://docs.markhuot.com

    Hope you get it working the way you want.

    Best wishes,

    Mark

  • #4 / Nov 01, 2007 5:16pm

    julie p

    282 posts

    Thanks - I was just perusing the extensions and couldn’t find it.  I’ll give it a go.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases