Have you outputted those values? instead of using a <cfquery> use <cfoutput> wrapped around your query. That should give you what the database will get. Try copying that and pasting it into whatever SQL tool you have (we use Toad for Oracle) and see if you get the same error.
On 6/24/05, Torrent Girl <[EMAIL PROTECTED]> 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> > > > > -------------------------------------------------------------------------------- > > SQL INSERT INTO members ( dateJoined, memberLevel, memberStatus, userName, > password, maritalStatus, wedDate, lengthOfSeperation, seperationExplanation, > lengthOfDivorce, divorceExplanation, memberTitle, fName, mName, lName, DOB, > ethnic, address, address2, city, state, zip, county, phone, fax, email, > spouseTitle, spouseFName, spouseMName, spouseLName, spouseDOB, children, > child1Name, child1DOB, child2Name, child2DOB, child3Name, child3DOB, > child4Name, child4DOB, workStatus, companyName, companyDept, companyPosition, > yearsEmployed, busAddress, busSuite, busCity, busState, busZip, busCountry, > busPhone, busFax, busEmail, preferredContact, degree1Study, degree1Year, > degree1School, licenseCertField, licenseCertYear, otherLicenseCertStudy, > otherLicenseCertYear, currentStudy, currentCompletion, currentSchool, > obdList, barterList, wnBizDev, spouseList, bornAgain, localChurchName, > localChurchCity, localChurchState, localChurchLengthOfMembership, otherOrgs1, > otherOrgs2, otherOrgs3, otherOrgs4, felony, felonyExplanation, > whatMemberExpects, reference1Name, reference1Address, reference1Phone, > reference1Years, reference2Name, reference2Address, reference2Phone, > reference2Years, referralID > > > > > >what error? show examples > > > >On 6/24/05, Torrent Girl <[EMAIL PROTECTED]> wrote: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1211 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
