$Bill,
The attempt is to get a to this string:
$SQL = "SELECT ParameterValues.ParameterValue
FROM Targets INNER JOIN (PrintSamples INNER JOIN
((DigitalImages INNER JOIN
PrintSampleAnalyses ON DigitalImages.ImageID =
PrintSampleAnalyses.ImageID) INNER JOIN
(Measurements INNER JOIN ParameterValues ON
Measurements.MeasurementID = ParameterValues.MeasurementID)
ON PrintSampleAnalyses.psaID =
Measurements.psaID) ON PrintSamples.PrintSampleID =
DigitalImages.PrintSampleID)
ON Targets.TargetID = Measurements.TargetID
WHERE (((PrintSampleAnalyses.psaTicket)='CGL')
AND ((PrintSamples.PrintCopyID)='05115501_18') AND
((Measurements.msmTag)='<tag>') AND
((Targets.TargetID)=187) AND ((ParameterValues.ParameterID)=31))";
Below were the attempts that I have tried and the results. Strangely,
by using the \t the 'tag' string showed, but I'm still at a loss on the
syntax to just show '<tag>'.
Thanks
-----Original Message-----
From: $Bill Luebkert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 11, 2005 9:32 PM
To: Hsu, David
Cc: [email protected]
Subject: Re: escaping characters
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
