WHERE CLAUSE

Thank you very much for the advice.

Gunner George

<CFquery name="PART" datasource="GTRACK2">
Select *
From PARTNR
WHERE id = #id# AND PNSTATUS = "ACTIVE"
ORDER BY ID
</cfquery>

I hear very good thing about "Teach Yourself SQL in 10 minutes" by Ben
Forta.

Wrong Quotes. SQL uses single quotes only for string literals.

<CFquery name="PART" datasource="GTRACK2">
Select *
From PARTNR
WHERE id = #id# AND PNSTATUS = 'ACTIVE'
ORDER BY ID
</cfquery>

Also 'Select *' is not a very good practice. It will often mean
selecting more data, sometimes much more data, then is required. And in
some cases could cause problems with ColdFusion. CF will cache the
table layout when 'Select *' is used and not always recognize the table
has changed when columns are added or removed.

Try this:

<CFquery name="PART" datasource="GTRACK2">
Select *
From PARTNR
WHERE id = '#id#' AND PNSTATUS = "ACTIVE"
ORDER BY ID
</cfquery>