try running the query in sql analyzer ... Jenny Gavin-Wear Fast Track eCommerce +44 (0) 1262 602013 http://www.ftol-ecommerce.com/
>>-----Original Message----- >>From: John Barrett [mailto:[email protected]] >>Sent: 20 June 2011 09:33 >>To: cf-newbie >>Subject: Re: delete page >> >> >> >>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:5308 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
