Re: problems with place holders

2003-12-09 Thread Jeffrey . Seger
Seger/Corporate/[EMAIL PROTECTED] cc: perl dbi <[EMAIL PROTECTED]> Subject:Re: problems with place holders On Tue, 9 Dec 2003 08:40:45 -0500 [EMAIL PROTECTED] wrote: > When using qq style quoting, you have to use a character that is not > contained within yo

Re: problems with place holders

2003-12-09 Thread Michael A Chase
On Tue, 9 Dec 2003 08:40:45 -0500 [EMAIL PROTECTED] wrote: > When using qq style quoting, you have to use a character that is not > contained within your string. Try qq{ } instead of qq( ). If it's even > compiling, I don't know why. As long as the parenthesis are balanced they may be include

Re: problems with place holders

2003-12-09 Thread Jeffrey . Seger
When using qq style quoting, you have to use a character that is not contained within your string. Try qq{ } instead of qq( ). If it's even compiling, I don't know why. Also, the ; within the string is superfluous. I seem to recall that some DBD drivers will parse it out and some will choke

RE: problems with place holders

2003-12-08 Thread Fox, Michael
Chad, You seem to have 4 bind variables but only need 3. Did you check the status of the execute call (or have RaiseError set to 1)? Michael Fox -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 9:04 AM To: perl dbi Subject: problems with

Re: problems with place holders

2003-12-08 Thread Ronald J Kimball
On Mon, Dec 08, 2003 at 05:03:59PM -0500, chad kellerman wrote: > Hello everyone, > >Trying to run a select statement but getting errors. I know it's > something stupid but just can't put my finger on it: > > > $addr_slct= qq( >SELECT SUBSTRING_INDEX(IP, '.',2) AS addr, COUNT(*)