> 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 output.
Your query is probably not returning any records. You can output the
variable qry_checkMilForStatus.RecordCount to find out, or turn debugging
output on and see.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
