From: Sara MG (saramg@uclink.berkeley.edu)
Date: Wed Dec 19 2001 - 10:15:50 PST
your URL should read: "test.cfm?order_id=#order_id#&editOrder=True"
"?" is used to separate the filename from the parameter list
"&" is used to separate individual parameters
((unless I'm misunderstanding your problem))
-----Original Message-----
From: owner-micronet-list@uclink4.berkeley.edu
[mailto:owner-micronet-list@uclink4.berkeley.edu]On Behalf Of David JL
Rieger
Sent: Wednesday, December 19, 2001 9:46 AM
To: micronet-list@uclink4.berkeley.edu
Cc: unix-sysadmin@uclink4.berkeley.edu
Subject: [Micronet] ColdFusion Query and URL
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/>.
------------------------------------------------------------------------
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/>.
This archive was generated by hypermail 2b29 : Wed Dec 19 2001 - 10:19:58 PST