need and job_close is null
----- Original Message -----
From: "Redd Liao" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 12:05 PM
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
