Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

Search: Do vs Query

Oct 15, 1999, 9:35 AM
pugdog
Veteran / Moderator (6956 posts)
Oct 15, 1999, 9:35 AM
Post #1 of 3
Views: 1799
Shortcut
Quote Reply
Search: Do vs Query
Alex,

I need to pass in a query like:

Code:
SELECT * FROM Table WHERE (SendDate<=Current_date()) AND (Sent!='True');

Can I pass that through a $db->query or do I have to use a '$db->do' construct?
Oct 14, 1999, 9:23 PM
pugdog
Veteran / Moderator (6956 posts)
Oct 14, 1999, 9:23 PM
Post #2 of 3
Views: 1721
Shortcut
Quote Reply
Re: Search: Do vs Query In reply to
Ok,

I think I get it... I can send a test along with the 'value' parameter in the hash. The 'value' is evaluated for operators before it's inserted into the 'key' request.

Oct 15, 1999, 7:08 AM
Alex
Administrator (9387 posts)
Oct 15, 1999, 7:08 AM
Post #3 of 3
Views: 1723
Shortcut
Quote Reply
Re: Search: Do vs Query In reply to
If you are using query, you can't use Current_Date() (do you mean NOW()?). Also, you can't do a not equal, however if the values are true or false you could do:

$today = $db->get_date();
$hits = $db->query ( { SendDate => "<$today", Sent => 'False', ww => 1 } );

which should work.

Hope that helps,

Alex