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]
