James, you got it! Var'ing the query seems to have solved it. Thanks!

Tavs


>I'll bet you didn't var the query as well:
>
><cfset var GetRecord = "">
><cfquery name="GetRecord" datasource="#Application.AppDatasource#">
>SELECT RecordID,RecordTitle FROM Records
>WHERE RecordID = <cfqueryparam value="#arguments.RecordID#"
>cfsqltype="CF_SQL_NUMERIC">
></cfquery>
>
>Using the local scope (as others have said) makes this less of a pain.
>
>
><cfquery name="local.GetRecord" ...
>
>--
>Shu Ha Ri: Agile and .NET blog
>http://www.bifrost.com.au/
>
>
>On 15 October 2011 23:46, Tavs Dalaa <[email protected]> wrote: 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348190
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to