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:1228
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
