This topic is locked

What's wrong in Inser Into

3/14/2007 6:45:30 AM
ASPRunnerPro General questions
M
marcove author

Hi,

Could you suggest me what's wrong in this code?
'** Save new data in another table ****

strSQLSave = "INSERT INTO _ProtocolloAmm (IDPro, InOut, Azienda,TipoDoc, DataPro, MittenteDestinatario, DataDoc, NumDoc, ImportoDoc, CentrodiCosto, DataOut, DataIn, NumPro, FagQuery) values ("

'strSQLSave = "INSERT INTO _ProtocolloAmm (Azienda) values ("
'strSQLSave = strSQLSave & "3000" & ","

strSQLSave = strSQLSave & "" & ","

strSQLSave = strSQLSave & dict(keys(1)) & ","

strSQLSave = strSQLSave & dict(keys(0)) & ","

strSQLSave = strSQLSave & dict(keys(2)) & ","

strSQLSave = strSQLSave & dict(keys(3)) & ","

strSQLSave = strSQLSave & dict(keys(4)) & ","

strSQLSave = strSQLSave & dict(keys(5)) & ","

strSQLSave = strSQLSave & dict(keys(6)) & ","

strSQLSave = strSQLSave & dict(keys(7)) & ","

strSQLSave = strSQLSave & dict(keys(8)) & ","

strSQLSave = strSQLSave & dict(keys(9)) & ","

strSQLSave = strSQLSave & dict(keys(10))

strSQLSave = strSQLSave & ")"
response.write(strSQLSave)
dbConnection.Execute strSQLSave
thank you

Marcos

J
Jane 3/14/2007

Marcos,
you need to debug your SQL. Comment executing of this query, print it and then execute in the database directly.
Also I recommend you to check number of fields and inserted values in your query.