Thanks I just printed them all out, checked them againt the db (for correct types) and the only question I had was for the now()...so let me work on that...maybe that's it
>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> > > > >-- >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:1231 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
