- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 6:09 PM
Subject: Re: Qoute
> >$group is a newsgroup name; all queries go fine, except one that has
At 16:52 + 5/10/02, [EMAIL PROTECTED] wrote:
>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).
There really are no tricky quote-on-quote things, except when peop
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 ca
Maybe I'm misreading what you did, but $dbh->quote($group) adds the single
quotes around the string, so using it followed by "...WHERE
newsgroup='$group'" gets you
WHERE newsgroup=''name.of.group''
Also, your example sets $newsgroup using quote, but uses $group in the
query, which is a problem
- 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
At 17:49 +0200 5/10/02, Mark wrote:
> > This is too weird; I can quote until I see blew in the face, but I cannot
>> seem to make MySQL understand that the name 'group-name' is valid to
>> select. It keeps blabbing "You have an error in your SQL syntax". I mean,
>> what is the purpose of its o
- Original Message -
From: "Philip Molter" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 6:01 PM
Subject: Re: Qoute
> Try:
>
> $sth = $dbh->prepare( 'SELECT expiration FROM
On Fri, May 10, 2002 at 05:49:12PM +0200, Mark wrote:
: > This is too weird; I can quote until I see blew in the face, but I cannot
: > seem to make MySQL understand that the name 'group-name' is valid to
: > select. It keeps blabbing "You have an error in your SQL syntax". I mean,
: > what is the
[snip]
$sth = $dbh -> prepare ("SELECT expiration from newsgroups WHERE
newsgroup='$group'");
$sth -> execute;
$group is a newsgroup name; all queries go fine, except one that has a dash
in it. I have tried quoting $group, like:
$newsgroup = $dbh -> quote ($group);
$group, btw, where it goes wr
> This is too weird; I can quote until I see blew in the face, but I cannot
> seem to make MySQL understand that the name 'group-name' is valid to
> select. It keeps blabbing "You have an error in your SQL syntax". I mean,
> what is the purpose of its own quote function if it can not even quote
>
At 17:26 +0200 5/10/02, Mark wrote:
>This is too weird; I can quote until I see blew in the face, but I cannot
>seem to make MySQL understand that the name 'group-name' is valid to select.
>It keeps blabbing "You have an error in your SQL syntax". I mean, what is
>the purpose of its own quote func
[snip]
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to select.
It keeps blabbing "You have an error in your SQL syntax". I mean, what is
the purpose of its own quote function if it can not even quote pro
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to select.
It keeps blabbing "You have an error in your SQL syntax". I mean, what is
the purpose of its own quote function if it can not even quote properly?
13 matches
Mail list logo
