Torrent Girl wrote: >Error Executing Database Query. >[Macromedia][SQLServer JDBC Driver][SQLServer]Line 140: Incorrect syntax near >','. > >The error occurred in D:\INETPUB\wifenetwork\memberAppProc.cfm: line 450 > >448 : '#reference2Phone#', >449 : '#reference2Years#', >450 : '#referralID#' >451 : ) >452 : </cfquery> > > TG
You need to scope all references to variables, so if these are form variables you need to put form. in front of them. The error strikes me as being a problem either with the insert inside the cfquery or something in the data that is tripping up the query. Can you give us the full CFQUERY code? Also, looking at the SQL that you have given us from the error message, I would suggest taking a look at the email I wrote for Dan B ([EMAIL PROTECTED]) regarding designing database structures. Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Contribute 3 from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=53 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
