RE: escaping characters

2005-10-12 Thread Keith.Watson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:perl- > [EMAIL PROTECTED] On Behalf Of Hsu, David > Sent: Wednesday, October 12, 2005 09:18 > To: $Bill Luebkert > Cc: perl-win32-users@listserv.ActiveState.com > Subject: RE: escaping characters > > I us

RE: escaping characters

2005-10-12 Thread Hsu, David
Ticket)='$sessionID') AND ((PrintSamples.PrintCopyID)='$sampleID') AND ((Measurements.msmTag)='<tag>') AND ((Targets.TargetID)=187) AND ((ParameterValues.ParameterID)=31))"; -Original Message- From: $Bill Luebkert [mailto:[EMAIL PROTECTED] Sent: Tuesd

RE: escaping characters

2005-10-12 Thread Hsu, David
ECTED] Sent: Tuesday, October 11, 2005 9:32 PM To: Hsu, David Cc: perl-win32-users@listserv.ActiveState.com Subject: Re: escaping characters Hsu, David wrote: > Hi all, > I'm having trouble formatting a SQL statement. > Here's what I have: > $SQL = " ... >

Re: escaping characters

2005-10-11 Thread $Bill Luebkert
Hsu, David wrote: > Hi all, > I'm having trouble formatting a SQL statement. > Here's what I have: > $SQL = " ... > ((Measurements.msmTag)=\'\') > AND(Targets.TargetID)=187) ..."; "\'" is the same as "'". > When I do a screen print I get: > ... ((Measurements.msmTag)='<>') .

Re: escaping characters

2005-10-11 Thread Luke Bakken
> Hi all, > I'm having trouble formatting a SQL statement. > Here's what I have: > $SQL = " ... > ((Measurements.msmTag)=\'\') > AND(Targets.TargetID)=187) ..."; > > When I do a screen print I get: > ... ((Measurements.msmTag)='<>') ... > > If I escape the <> > $SQL = " ...

escaping characters

2005-10-11 Thread Hsu, David
Hi all, I'm having trouble formatting a SQL statement. Here's what I have: $SQL = " ... ((Measurements.msmTag)=\'\') AND(Targets.TargetID)=187) ..."; When I do a screen print I get: ... ((Measurements.msmTag)='<>') ... If I escape the <> $SQL = " ...