You'll have to create a separate table for the administration information.
Then where you have FORM.NTS in your query, it will be replaced with the
value from the database.
HTH,
Steve
"Seamus Campbell" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
