I cannot see how to do the following, although I am sure it is very easy
and I'm being stupid.
Hope someone can help
I have this query:
<cfquery name="get_NTS" datasource="ABC_1" dbtype="ODBC">
SELECT tblProduct.ID, tblProduct.ProductDesc, tblProduct.SalePrice,
tblProduct.NTS
FROM tblProduct
WHERE tblProduct.NTS='#FORM.NTS#'
</cfquery>
I want an admin person to be able to set the where value ie FORM.NTS from
their browser
I can see how to do it with a form quite easily - but I want the admin
person to set the value, then that value get used by the query until admin
changes it again.
But I just can't get my brain around how to do it
Any help gratefully accepted
Many thanks
Seamus
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
