Hsu, David wrote: > Hi all, > I'm having trouble formatting a SQL statement. > Here's what I have: > $SQL = " ... > ((Measurements.msmTag)=\'<tag>\') > AND(Targets.TargetID)=187) ...";
"\'" is the same as "'". > When I do a screen print I get: > ... ((Measurements.msmTag)='<>') ... > > If I escape the <> > $SQL = " ... > ((Measurements.msmTag)=\'\<tag\>\') > AND(Targets.TargetID)=187) ..."; Same with <>. > When I do a screen print I still get: > ... ((Measurements.msmTag)='<>') ... > > I tried this: > $SQL = " ... > ((Measurements.msmTag)=\'\<\ttag\>\') > AND(Targets.TargetID)=187) ..."; > > When I do a screen print I get: > ... ((Measurements.msmTag)='< tag>') ... You added a tab in there. > Any insights would be appreciated. You stated a few observations, but what are you trying to do ? If you want a \ in there, just double it up "\\". _______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
