Re: Trouble making set_sql work...

[prev] [thread] [next] [Date index for 2004/07/13]

From: Stuart Johnston
Subject: Re: Trouble making set_sql work...
Date: 16:50 on 13 Jul 2004

Andy Harrison wrote:
> On Tue, 13 Jul 2004 11:04:54 -0400, Jesse Sheidlower <jester@xxxxx.xxx> wrote:
> 
> Thanx everyone.  I've been able to get this functioning now.
> 
> However, Colm is right, you can't do 'LIMIT ?'.
> 
> Could anyone offer suggestion on how I could do this?  I was just
> hoping to make it dynamic so that I could easily generate a top
> 10-20-100-whatever list.
> 

What DB are you using?  I have found that PostgreSQL (at least 7.2) does 
support LIMIT placeholders as long as you use an older DBD::Pg (1.22 
works).  You also have to be sure that the value you pass will be 
interpreted as an integer (int helps).

You other option would be to use %s, sprintf style substitution:

http://groups.kasei.com/mail/arc/cdbi-talk/2004-06/msg00068.html

Stuart Johnston
http://VaultraNet.com

(message missing)

Trouble making set_sql work...
Andy Harrison 14:28 on 13 Jul 2004

Re: Trouble making set_sql work...
colm-cdbi 14:54 on 13 Jul 2004

Re: Trouble making set_sql work...
colm-cdbi 15:10 on 13 Jul 2004

Re: Trouble making set_sql work...
Andy Harrison 14:58 on 13 Jul 2004

Re: Trouble making set_sql work...
Jesse Sheidlower 15:04 on 13 Jul 2004

Re: Trouble making set_sql work...
Andy Harrison 16:36 on 13 Jul 2004

Re: Trouble making set_sql work...
John Beppu 16:46 on 13 Jul 2004

Re: Trouble making set_sql work...
Stuart Johnston 16:50 on 13 Jul 2004

Re: Trouble making set_sql work...
Andy Harrison 17:32 on 13 Jul 2004

Re: Trouble making set_sql work...
colm-cdbi 18:38 on 13 Jul 2004

Re: Trouble making set_sql work...
Andy Harrison 19:33 on 13 Jul 2004

Re: Trouble making set_sql work...
Drew Taylor 19:44 on 13 Jul 2004

Re: Trouble making set_sql work...
colm-cdbi 20:08 on 13 Jul 2004

Re: Trouble making set_sql work...
Andy Harrison 20:52 on 13 Jul 2004

Re: Trouble making set_sql work...
colm-cdbi 18:57 on 13 Jul 2004

Re: Trouble making set_sql work...
Jay Strauss 15:10 on 13 Jul 2004

Re: Trouble making set_sql work...
Perrin Harkins 17:51 on 13 Jul 2004

Re: Trouble making set_sql work...
Andy Harrison 18:23 on 13 Jul 2004

Re: Trouble making set_sql work...
Stuart Johnston 19:44 on 13 Jul 2004

Generated at 11:34 on 01 Dec 2004 by mariachi v0.52