The first thing i'd do is check to make sure the query is returning results.
Have you downloaded cf_dump or cf_objectdump from the taggallery yet? if
not, go there and find them... download ... then use them to check the
output of the query.
Seeing as you're dynamically passing in a username and password I'd really
bet that's the problem. If the recordcount is 0, then the cfoutput loop
will never run... hence even your static word "test" won't display onto the
screen.
|-----Original Message-----
|From: John McCosker [mailto:[EMAIL PROTECTED]]
|Sent: Wednesday, March 07, 2001 12:46 PM
|To: CF-Talk
|Subject: cfoutput
|
|
|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
