Hi all, I've a section of query I'm trying to run, I've tried lots of different ways to write it but have had no success yet
Does anyone know how this query should be written: [code] <cfquery name="breadcrumb" datasource="#REQUEST.theDatabase#"> <!---SELECT the values for the Deleted level into variables---> DECLARE DeletedAreaName VARCHAR(50); DECLARE DeletedLft INTEGER; DECLARE DeletedRgt INTEGER; SELECT SiteAreaName, Lft, Rgt INTO DeletedAreaName, DeletedLft, DeletedRgt FROM directoryLinks WHERE SiteAreaName = '#ARGUMENTS.SiteAreaName#' </cfquery> [/code] Thanks, Richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244615 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
