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

Reply via email to