Well... This seems to be a typical tricky-goute-on-qoute thing...
I recommend you to test your query in mysql client directly
(if you havn't already done that).
And THEN take the battle with perls quoting mechanism...
Another tip is to just print the query before executing
so You can see exactly how perl is handling with quotes.
Propably You need to espace quotes to hide them from perl.
I think this is quote... eh.. I mean quite common way to
track down this kind of problems but I say it 'just in case'
You haven't try it yet...
good luck :-)
=d0Mi=
From: Mark <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Qoute
> ----- Original Message -----
> From: "Jay Blanchard" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 10, 2002 6:01 PM
> Subject: RE: Qoute
>
> > Have you tried double-quotes? '"$group"' ?
> > Jay
>
>
> I do not see how that can be done; when I do that, Perl complains of a dozen
> of syntax errors because the first double quote is seen as closing the,
>
> $sth = $dbh -> prepare ("SELECT expiration ...
>
> Query.
>
> - Mark
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
