Larry White wrote:
> Try This:
>
> pa_list is the list of UUID's
>
> <cfset pa_list = ListQualify(pa_List,"'")>
>
> Then in the query:
>
> Where att_id IN (#PreserveSingleQuotes(pa_list)#)
Jezz, this has got me pulling out my hair. If I set it up exactly like
you have it above, I'm *still* getting the "Error converting data type
varchar to numeric".
What the hell is it trying to convert to numeric?
Full error message copied below:
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
varchar to numeric.
The error occurred in
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 88
Called from
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 1
Called from
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 88
Called from
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 1
87 : FROM atty
88 : WHERE atty_id IN (#PreserveSingleQuotes(pa_list)#)</cfif>
89 : ORDER BY last_name, first_name ASC
90 : </cfquery>
--------------------------------------------------------------------------------
SQL SELECT * FROM NONatty WHERE atty_id <> 8787445854777 AND atty_id
IN
('25','17','375','480','546','346','121','506','132','439','437','35','435','1','76','632','1200','1200','1200','1201','1202','1203','560','110','A6059FCB-BCD2-35D3-DD69BDA7A81553CF','A6081455-BCD2-35D3-DD69BDA7A81553CF','A606B37D-BCD2-35D3-DD7136154C60D051')
ORDER BY last_name, first_name ASC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191625
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
