Actually, now that I think about it for more than 5 seconds (*grin*) if all
you really want is the recordcount, you should just let the Database do the
counting rather than making it fetch all the rows, send them to CF, and then
making CF count the rows. If you *really* don't need the data, then try
this:
SELECT count(*) FROM job
where cyv_id = '#FORM.cyv_id#' and job_close is null
-Chris Gilbert, Fodors.com
-----Original Message-----
From: Redd Liao [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 15, 2001 12:05 PM
To: CF-Server
Subject: What's wrong? (urgent)
I use MS SQL and CF 4.5.
<cfquery name="works" datasource="project" dbtype="ODBC">
SELECT * FROM job
where cyv_id = '#FORM.cyv_id#' and job_close = ''
</cfquery>
I wanna get works.recordcount in which job_close is null,
but i always get 0. Is there anything wrong in cfquery?
Thanks.
R
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
