(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [Paul] Format for GT::SQL::Condition: Edit Log

Here is the list of edits for this post
Sep 10, 2002, 7:16 AM
webmaster33
Veteran (2312 posts)
Sep 10, 2002, 7:16 AM
Views: 7555
Re: [Paul] Format for GT::SQL::Condition
I know "" is interpolated and '' is not.

Docs says for select:
Quote:
All arguments in the where clause are automatically quoted. If you don't want quotes, you should pass in a scalar reference as in:


my $sth = $obj->select ( { Col => \"NOW()" } );

which turns into ``SELECT * FROM Table WHERE Col = NOW()''.
So I think my solution should work, as posted (although I did not try it out)

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Last edited by:

webmaster33: Sep 10, 2002, 7:19 AM

Edit Log: