statements.
======================================
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
======================================
----- Original Message -----
From: Steve Hanzelman
To: CF-Server
Sent: Wednesday, July 14, 2004 11:39 AM
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]
