Has anyone come a accross a weird one like this,
I have a query like so
<cfquery name="qry_checkMilforStatus" datasource="#application.dsn#"
username="#application.gateway#" password="#application.key#" maxrows="1">
SELECT dt, messageType
FROM dbo.milford
WHERE status > = 4 or status < = 6 and datediff(day
, dt , getdate() ) = 0
</cfquery>
but when I output the query like so
<cfoutput query="qry_checkMilforStatus">#messageType#</cfoutput>
I get nothing, even if I pre-append like so
<cfoutput query="qry_checkMilforStatus"> test #messageType#</cfoutput>
still I do not get an out put.
Much thanx in advance...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
