[CDBI] Use Literal SQL in part of a WHERE clause

[prev] [thread] [next] [Date index for 2006/02/02]

--===============0036556301==
Content-Type: multipart/alternative; 
	boundary="----=_Part_4289_11689634.1138909780381"

------=_Part_4289_11689634.1138909780381
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Is there any way to use a where clause like this using CDBI::Sweet (without
using set_sql)?

WHERE TO_DAYS(now()) - TO_DAYS(created) < 2

Is there some way to insert literal SQL for an entire expression and not
simply the right hand side of one?  That is, I know you can do this:

    my $inn =3D 'is Not Null';
    my %where =3D (
        priority =3D> { '<', 2 },
        requestor =3D> \$inn
    );

but I'd like to use literal SQL for an entire expression.

TIA.
--
Dave Mabe
http://www.stocktickr.com/ - social stock trading

------=_Part_4289_11689634.1138909780381
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Is there any way to use a where clause like this using CDBI::Sweet (without=
 using set_sql)?<br><br>WHERE TO_DAYS(now()) - TO_DAYS(created) &lt; 2<br c=
lear=3D"all"><br>Is there some way to insert literal SQL for an entire expr=
ession and not simply the right hand side of one?&nbsp; That is, I know you=
 can do this:
<br><br><pre>    my $inn =3D 'is Not Null';<br>    my %where =3D (<br>     =
   priority =3D&gt; { '&lt;', 2 },<br>        requestor =3D&gt; \$inn<br>  =
  );</pre>but I'd like to use literal SQL for an entire expression.<br><br>=
TIA.
<br>-- <br>Dave Mabe<br><a href=3D"http://www.stocktickr.com/">http://www.s=
tocktickr.com/</a> - social stock trading

------=_Part_4289_11689634.1138909780381--


--===============0036556301==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

--===============0036556301==--