Well, the syntax is correct, so if url.record_id and form.record_id both exist and are not null it should work.
Have you tried dumping the variables to see what they contain? On Mon, Jun 20, 2011 at 1:33 AM, John Barrett <[email protected]> wrote: > > no in the deletet.cfm I have SELECT * FROM references WHERE record_id = > #URL.record_id# > > should this be int he delete_action.cfm file, there I have > <cfquery name="DeleteReference" datasource="#REQUEST.dataSource#"> > DELETE FROM reference > WHERE record_id = #Form.record_id# > </cfquery> > <cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5307 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
