Thread: ' syntax

' syntax

From
amarof
Date:
i got your answers about the syntax, it works with the strings, but when
etat takes a variable value, it gives a parser error. example : select *
from table where field like $txt
the error occurs when txt takes the value (doctortat d'etat).
thanks




Re: [GENERAL] ' syntax

From
"Brett W. McCoy"
Date:
On Sat, 5 Jun 1999, amarof wrote:

> i got your answers about the syntax, it works with the strings, but when
> etat takes a variable value, it gives a parser error. example : select *
> from table where field like $txt
> the error occurs when txt takes the value (doctortat d'etat).

Is this in Perl or PHP3?  You should be doing it like:

"select * from table where field like '$txt';"

It's especially important that your query string be delimited by double
quotes in Perl, or it won't interpolate your variable.  If unsure, use
the generic quote facility:

qw(select * from table where field like '$txt';)

where the parentheses are functioning as quote characters.

Brett W. McCoy
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
It's not enough to be Hungarian; you must have talent too.
        -- Alexander Korda