Insert statment problems

[fluxdemon]

My webpage platform is sun one asp/mySql and I am having a problem with the following insert statement. The statement works in the query analyzer and I get a generic error page.

(id is a timestamp field)
insert into cv_archive
select * from cv
where id = 20040730134934

set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
connString="DRIVER={MySQL};...
conn.open connString
sql = "insert into cv_archive
sql = sql & select * from cv
sql = sql & where id = 20040730134934
conn.execute(sql)
conn.close
set conn=nothing

 

[sleipnir214]

I don't know all that much about ASP, but doesn't this:

conn.open connString
sql = "insert into cv_archive
sql = sql & select * from cv
sql = sql & where id = 20040730134934

have a decided lack of necessary quotes?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[fluxdemon]

I forgot to add those when I deconstructed the actual functions to show I had all necessary items to use the statement. I am asking about the sql statement.

 

[sleipnir214]

Does the query actually do something, or does it just not throw an error?

I think that if you don't put your timestamp value in quotes, MySQL will treat it as an integer.


Want the best answers? Ask the best questions!

TANSTAAFL!!