contains "Query" perhaps? But I'd bet you're fine and can probably
ignore it.
-----Original Message-----
From: Steve Hanzelman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 11:40
To: CF-Server
Subject: Code Analyzer Question
We upgraded our test server from CF 5 to MX 6.1.
I ran the Code Analyzer and was fairly pleased to see that we have
relatively few changes to make.
I did note that several of the "info" style items that appeared were in
regards to Query of Query statements. The message was that the query
included reserved words.
Here is an example that I created just to test....
<cfquery name="query1" datasource="#request.hris#">
select *
from emppers
</cfquery>
<cfquery name="query2" dbtype="query">
select eepnamelast, eepnamefirst
from query1
where eepnamelast like 'Han%'
</cfquery>
Should I just ignore the message since it is an "info" level and not an
"error" level? If not, what should I correct in my query?
Thanks,
Steve Hanzelman
Milton Hershey School
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
