ColdFusion Query and URL

Date view Thread view Subject view Author view

From: David JL Rieger (drieger@olac.berkeley.edu)
Date: Wed Dec 19 2001 - 09:46:15 PST

Good day folks,

I'm sure there is a simple way but I don't have the ability to see it:

I have a situation where I'm passing an order_id variable through an
URL. Along with this variable, I want to add a parameter to that url to
denote from which part the user is coming from.

For example.

..."test.cfm?order_id=#order_id#?editOrder=True"

Then I want to take that order_id and use it in a query

SELECT XYZ
FROM XYZ
WHERE order_id = #url.order_id#

My Question:

Would anyone know how to take out the paramater editOrder before the
application hits the SQL? It is causing the database to complain.

Thanks,

david rieger

------------------------------------------------------------------------
The following was automatically added to this message by the list server:

For information about Micronet, its meetings and events, and its
mailing list, including information on subscribing and unsubscribing,
see the Micronet Web site at <http://wss.berkeley.edu/micronet/>.

Date view Thread view Subject view Author view

This archive was generated by hypermail 2b29 : Wed Dec 19 2001 - 09:49:27 PST