Re: Problems with a Quote in Select

2002-09-12 Thread Paul DuBois
>FYI - >Be careful using dbh->quote with inserts and updates. If you feed dbh->quote a >variable that has >no value, it will return '' (tick tick). If the column is a date the >value will >be set to -00-00 and >if the column is numeric it will be set to 0 instead of NULL . You can either >ch

Re: Problems with a Quote in Select

2002-09-12 Thread walt
Gerald Clark wrote: > in perl you would do > my $qselcat=$dbh->quote($selcat); > $whichpart = "AND key1=$qselcat"; > > René Fournier wrote: > > > Hello everyone, > > > > I'm trying to Select on a field that contains a doublequote, and can't > > figure out how to pass it throught the Select statem

Re: Problems with a Quote in Select

2002-09-12 Thread Gerald Clark
in perl you would do my $qselcat=$dbh->quote($selcat); $whichpart = "AND key1=$qselcat"; René Fournier wrote: > Hello everyone, > > I'm trying to Select on a field that contains a doublequote, and can't > figure out how to pass it throught the Select statement (couldn't find > anything in the