the datatype in the MSSQL DB is BIGINT
here is my code...
<cfset request.ipAddressNumber = "223073026">
<cfquery name="GetVehicleName" datasource="myDataSource">
select *
from thisTable v
inner join thatTable c on c.companyIdNumber = v.companyIdNumber
where v.ipAddressNumber = <cfqueryparam
value="#trim(request.ipAddressNumber)#" cfsqltype="CF_SQL_BIGINT">
</cfquery>
ERROR in CFMX 6.1
(BUT NOT IN B****ST**)
ANY IDEAS WHY?
WHY?
--
tony
Tony Weeg
macromedia certified coldfusion mx developer
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
cool tool: http://www.antiwrap.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182862
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
