I can't see the difference either, and I also wonder why he's using the val() function.
On 12/20/06, Peterson, Chris <[EMAIL PROTECTED]> wrote: > > Just curious... Why are you doing #val(arguments.MemberID)# instead of > just #arguments.MemberID# ? > > Chris > > -----Original Message----- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 20, 2006 9:04 AM > To: CF-Talk > Subject: Bug? > > Do not know if this is a bug or something normal, but if I have my query > like so...I get the following error. Notice where the <cfqueryparam> is. > I hunted for hours trying to figure out where this was coming from. Can > someone confirm this? > > > > [Macromedia][SQLServer JDBC Driver]Value can not be converted to > requested type. > > > > <CFQUERY name="MemberDetails" datasource="#APPLICATION.DB#" > username="#APPLICATION.UN#" password="#APPLICATION.PW#"> > SELECT * > FROM #APPLICATION.DBPRE#MemberProfile > WHERE #APPLICATION.DBPRE#MemberProfile.MemberID = > <CFQUERYPARAM cfsqltype="CF_SQL_BIGINT" > value="#Val(ARGUMENTS.MemberID)#"> > </CFQUERY> > > > > > But if I have it like so, everything works fine > > <CFQUERY name="MemberDetails" datasource="#APPLICATION.DB#" > username="#APPLICATION.UN#" password="#APPLICATION.PW#"> > SELECT * > FROM #APPLICATION.DBPRE#MemberProfile > WHERE #APPLICATION.DBPRE#MemberProfile.MemberID =<CFQUERYPARAM > cfsqltype="CF_SQL_BIGINT" value="#Val(ARGUMENTS.MemberID)#"> > </CFQUERY> > > > > Doug B. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264555 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
