URGENT: INSERT Statement errors..... 1

[rjn2001]

Below is the Insert statement:

strSQL = "insert into tblUsers (UserID, First_Name, Last_Name, Password,  Sec_ques, Sec_Ans, Birth_Year, Address, Post_Code, e_mail, www, Gender, County, Country, Nationality, Required, OtherPermit, DistributionLogistics, ManOps, StratDev, AccountCon, CorpFin, ITDeploy, ITDesign, ITOther, Marketing, HumanResources, Sales, Purchasing, Automotive, ECommerce, Energy, FinServices, ITIndustry, LeisureIndustry, HealthIndustry, ManufacturingEngineering, NotForProfit, Publishing, Retail, TeleComs, TransportationIndustry, UtilityIndustry, Other) values ('hometime', '" & First_Name& "', '" & Last_Name& "', '" & Password& "' , '" & Sec_ques& "', '" & Sec_Ans& "', '" & Birth_Year& "', '" & Address& "', '" & Post_Code& "', '" & e_mail& "', '" & www& "', '" & Gender& "', '" &County & "', '" &Country & "', '" &Nationality & "','" &Required & "','" & OtherPermit& "','" & DistributionLogistics& "','" & ManOps& "','" & StratDev& "','" & AccountCon& "','" & CorpFin& "','" & ITDeploy& "','" & ITDesign& "','" & ITOther& "','" & Marketing& "','" & HumanResources& "','" & Sales& "','" & Purchasing& "','" & Automotive& "','" & ECommerce& "','" & Energy& "','" & FinServices& "','" & ITIndustry& "','" & LeisureIndustry& "','" & HealthIndustry& "','" & ManufacturingEngineering& "','" & NotForProfit& "','" & Publishing& "','" & Retail& "','" & TeleComs& "','" & TransportationIndustry& "','" & UtilityIndustry& "','" & Other& "');"

Below is the response.write(strSQL) and page error

estrytyuitgwhjygtuhnjkmRequiredinsert into tblUsers (UserID, First_Name, Last_Name, Password, Sec_ques, Sec_Ans, Birth_Year, Address, Post_Code, e_mail, www, Gender, County, Country, Nationality, Required, OtherPermit, DistributionLogistics, ManOps, StratDev, AccountCon, CorpFin, ITDeploy, ITDesign, ITOther, Marketing, HumanResources, Sales, Purchasing, Automotive, ECommerce, Energy, FinServices, ITIndustry, LeisureIndustry, HealthIndustry, ManufacturingEngineering, NotForProfit, Publishing, Retail, TeleComs, TransportationIndustry, UtilityIndustry, Other) values ('hometime', 'tgwhj', 'ygtuhnjkm', 'Nk9100' , 'What is your Pet Name?', 'fred', '1955', 'drtfyghhjk', 'rfugyhjk', '', '[URL unfurl="true"]http://',[/URL] 'Female', '', 'United Kingdom', '','Required','','','ManOps','','','CorpFin','','','','','','','','','','','','','','','','','','Retail','','','','sxrdxctfvgbh'); 
Microsoft JET Database Engine error '80040e14' 

Syntax error in INSERT INTO statement. 

/verify_insert.asp, line 171

Can ANYBODY point out what is wrong?!

I have been through Access SQL thing with it, and it works, but it wont work from the page.

My boss needs this yesterday!!, please help!!!

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[Lothario]

wrap UserID in []...

[UserID]

-L

 

[Lothario]

even wrap the Password as [Password] because they are key words..

-L

 

[rjn2001]

got this coming up now:

Syntax error (missing operator) in query expression '' 'helllllooooowor', 'richard', 'noon', 'noon01' , 'What is your Pet Name?', 'fred', '1957', 'rwou4yt2i34uytiwhrg', 'jhkgiuy', '', '[URL unfurl="true"]http://',[/URL] 'Male', '', 'Haiti', '','Required','','','ManOps','','AccountCon','CorpFin','','','','','','','','Automotive','EC'

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[Lothario]

what is this '' 'helllllooooowor',

are we mising a comma...between these two fields...

-L

 

[rjn2001]

no, that is the beginning of the 'error code' it has supplied me with
The code for the page

hellllloooooworrichardnoonRequiredinsert into tblUsers ([UserID], First_Name, Last_Name, [Password], Sec_ques, Sec_Ans, Birth_Year, Address, Post_Code, e_mail, www, Gender, County, Country, Nationality, Required, OtherPermit, DistributionLogistics, ManOps, StratDev, AccountCon, CorpFin, ITDeploy, ITDesign, ITOther, Marketing, HumanResources, Sales, Purchasing, Automotive, ECommerce, Energy, FinServices, ITIndustry, LeisureIndustry, HealthIndustry, ManufacturingEngineering, NotForProfit, Publishing, Retail, TeleComs, TransportationIndustry, UtilityIndustry, Other) values (' 'helllllooooowor', 'richard', 'noon', 'noon01' , 'What is your Pet Name?', 'fred', '1957', 'rwou4yt2i34uytiwhrg', 'jhkgiuy', '', '[URL unfurl="true"]http://',[/URL] 'Male', '', 'Haiti', '','Required','','','ManOps','','AccountCon','CorpFin','','','','','','','','Automotive','ECommerce','Energy','','','','','','','','','','','','xx'); 
Microsoft JET Database Engine error '80040e14' 

Syntax error (missing operator) in query expression '' 'helllllooooowor', 'richard', 'noon', 'noon01' , 'What is your Pet Name?', 'fred', '1957', 'rwou4yt2i34uytiwhrg', 'jhkgiuy', '', '[URL unfurl="true"]http://',[/URL] 'Male', '', 'Haiti', '','Required','','','ManOps','','AccountCon','CorpFin','','','','','','','','Automotive','EC'. 

/verify_insert.asp, line 170

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[Sheco]

I'm confused... hellllloooooworrichardnoonRequired is not part of the SQL right?

/boggle

 

[Lothario]

Wrap the fields with SERVER.HTMLENCODE where ever you have some special characters...

for example..
'What is your Pet Name?'

if that field name is blah then....do

'"&Server.htmlencode("blah")&"'

-L

 

[rjn2001]

Thanks for your help!,

Got it working..

Cheers once again.

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[Lothario]

I am glad i could be of help...

-L