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: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Captivate from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=52 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1210 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
