I used the html syntax: '<' for <,
But used just '>' and it produced the results that I was looking for:
'<tag>'
Using '>' for '>' also works. ????
$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)='$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: 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
