Hi CF People
I have a query:
<cfquery name="getspecial" datasource="#dsn#"> SELECT ID, category, product, special FROM products WHERE special = 'Yes' </cfquery>
If i do a cfdump of this query it shows that ??? is the category.
However when i try asnd use this variable in a url link back to another page:
I gat an error; that Element CATEGORY is undefined in GETSPECIAL.
How can this be if the category is selected in the query how come i cant then use it as a link variable
any help would be appreciated
cheers and thanks in advance