I'd pass it as a hidden field in the form, and then check at the top of the page for it in the url or form scope, throw it in a variables.ProdID, and use that in the query:
<cfif StructKeyExists(form,"ProdID")> <cfset variables.ProdID = form.ProdID> <cfelseif StructKeyExists(URL,"ProdID")> <cfset variables.ProdID = url.ProdID> <cfelse> <cfset variables.ProdID = ""> </cfif> On Tue, Jul 1, 2008 at 1:52 PM, Rick King <[EMAIL PROTECTED]> wrote: > You're correct...how would I carry over URL.ProdID? I'm drawing a blank. > > >Looks like you're posting the form to itself, but not carrying over the > >URL.ProdID used in the where clause of the query in the form, so the > second > >time through, nothing is returned by the query. > > > > > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
