I would suggest using that within the query then:
<cfquery name="works" datasource="project" dbtype="ODBC">
SELECT *
FROM job
WHERE cyv_id = '#FORM.cyv_id#'
AND job_close IS NULL
</cfquery>
Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com: (703) 805-1095
DSN: (703) 655-1095
-----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
