Help!!! Please!!!
OK..I'm new at this, so be kind...
I have a pulldown menu, that returns a URL like:
marketplace.cfm?request=cat
marketplace.cfm?request=twn or
marketplace.cfm?request=alpha
Then, in marketplace.cfm, I am trying to ORDER BY the variable above, like
<CFQUERY NAME="GetResults" DATASOURCE="Reminder">
SELECT * FROM customer
<cfif request = cat>order by category</cfif>
<cfif request = twn>order by town</cfif>
<cfif request = alpha>order by busname</cfif>
</CFQUERY>
Of course, this blows up! (CAT is Undefined...), even though debugging tell
me URL parameters request=cat. How am I supposed to pass a variable from a
url to my sql query???
Thanks in advance!
Jeffrey
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
