I noticed in your message the error is saying it can't resolve "Stat.date" but in your CFOUTPUT you have "Stats.date" listed. Perhaps you mistyped it in the actual code and typed it correctly in your message below? -----Original Message----- From: Phillip Duba [mailto:[EMAIL PROTECTED]] Sent: Friday, November 17, 2000 2:36 PM To: Fusebox Subject: OT: CFExpress Query I know this is a little OT, but my CFDJ email got sent back, so I figured I'd try this route also. Here goes: I have a query that is accessing a Microsoft ODBC text driver file. The query is nothing spectacular: <cfquery datasourc="stats" name="Stats"> SELECT * from stats.log </cfquery> However, when I outputed the data using the CF server that comes with Studio, I got the results I expected, but when using CFExpress, it tells me that it cannot resolver parameter Stat.date. Here's my <cfoutput> <cfoutput query="Stats"> #Stats.date# #stats.time# #stats.device# #stats.RTT# </cfoutpu> Any ideas as to why this might be happening? Thanks, Phil -- Phil Duba Software Developer IDE Applications Lockheed Martin NE&SS - Surface Systems (856) 787-3657 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
