Right, so check each one. You have a bunch of strings going into that table, if you try and insert an empty string into a numeric type column you'll get an error.
You might also want to make sure that the dateJoined column is ok with being passed #Now()# from CF. If that is the problem try formatting the date. Ade -----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: 25 June 2005 14:30 To: CF-Newbie Subject: RE: Need help - deadline 5pm Here is my insert statement <cfquery name="enterMember" datasource="#datesource#" username="#datesourceUserName#" password="#datesourceUserPassword#"> 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 ) VALUES ( #now()#, '#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#') </cfquery> >Check you're passing in the correct values for the right columns. Are you >trying to insert an empty string into a numeric type column? > >Ade > >-----Original Message----- >From: Torrent Girl [mailto:[EMAIL PROTECTED] >Sent: 25 June 2005 00:55 >To: CF-Newbie >Subject: RE: Need help - deadline 5pm > > >My problem is that I paramed them all but I get an error on the insert -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1230 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
