ASP ADO/SQL Problem

[SimonFinn]

Hi Guys,

I am executing this SQL statement from ASP, when i copy it into MS Access it runs fine, but when i use ADO i get the error "Error in insert statement".

I thought it was the Yes/No fields so i tried 0/1 for them with no success.

Has anyone got any ideas,

Thanks Si

INSERT INTO tblCandidate_IT
([CV Received], Email, Password, FileEnd, Availability, CurrWorkType, Title, [First Name], [Last Name], Visa, InMailShot, Mobile
) VALUES (#24/10/2003#, 'simonf', 'simonf', '.Doc', #01/07/1981#, 'Contract', 'Mr', 'simonf', 'simonf', 0, 1, '000000000000')

 

[PatrickIRL]

Is it possible for you to post the actual SQL statement that you pass in??

Patrick

 

[mwolf00]

title and password may be reserved - try brackets arounf them...

INSERT INTO tblCandidate_IT
([CV Received], Email, [Password], FileEnd, Availability, CurrWorkType, [Title], [First Name], [Last Name], Visa, InMailShot, Mobile
) VALUES (#24/10/2003#, 'simonf', 'simonf', '.Doc', #01/07/1981#, 'Contract', 'Mr', 'simonf', 'simonf', 0, 1, '000000000000')

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[SimonFinn]

Thanks, thats perfect!!

Now im annoyed with myself, I have a note i made yesterday to remind me to change that

Thanks again,

Si

 

[PatrickIRL]

mwolf00, wouldn't that throw an error in Access anyway???

 

[PatrickIRL]

Ok, forget my last post, back to basics for me I think

 

[shaddow]

Also this will work if you use Microsoft.Jet.OLEDB.X.X driver.

________
George, M