- 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 people
try to mess aro
t;[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
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
12 matches
Mail list logo
