Change to:
<cfquery name="works" datasource="project" dbtype="ODBC">
SELECT * FROM job
where cyv_id = '#FORM.cyv_id#' and job_close is null
</cfquery>
Also run it in Query Analyzer to make sure you actually have records.
NAT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
