Member Avatar for grabit

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:

<cfoutput>#getspecial.category#</cfoutput>

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
Grabit

Read more: http://www.easycfm.com/coldfusion/forums/viewmessages.cfm?Forum=12&Topic=15163#ixzz1Oj4yo4LE

Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by cfwebdeveloper
Member Avatar for cfwebdeveloper

However when i try asnd use this variable in a url link back to another page:

Queries do not go from page to page. If you need information to be passed to another page set the variables as session variables or pass the unique id as the URL variable and query the database where id = #url.id#.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.