Hi all, I am having problem inserting the auto_increment id (FID) of table "TOPIC" to FTopicID of Table Msgs, I am using mysql as databse.The code works fine with MS Access Databse.Could any body help me.My codes are as follows:-

Dim rsTopic
set rsTopic = Server.CreateObject("ADODB.Recordset")
rsTopic.Open "Topic", objconn, adOpenForwardOnly, adLockOptimistic, adCmdTable

rsTopic.AddNew

If Request.Cookies("PMBVisit")("UserName") = "" Then
rsTopic("FGuest") = Request.Form("FName")
rsTopic("FTProfile") = False
Else
rsTopic("FName") = Request.Cookies("PMBVisit")("UserID")
rsTopic("FTProfile") = True
End If

rsTopic("FForumJoinID") = Request.Querystring("ForumID")
rsTopic("FSubject") = Request.Form("FSubject")
'the problem is here
Session("FTopicID") = rsTopic("FID")

rsTopic("FIcon") = Request.Form("TopicIcon")

rsTopic.Update
rsTopic.Close
set rsTopic = Nothing


Dim rsMsgs
set rsMsgs = Server.CreateObject("ADODB.Recordset")
rsMsgs.Open "Msgs", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable

rsMsgs.AddNew

If Request.Cookies("PMBVisit")("UserName") = "" Then
rsMsgs("FMsgGuest") = Request.Form("FName")
rsMsgs("FMsgEmail") = Request.Form("FEmail")
rsMsgs("FMsgProfile") = False
Else
rsMsgs("FMsgName") = Request.Cookies("PMBVisit")("UserID")
rsMsgs("FMsgEmail") = Request.Cookies("PMBVisit")("Email")
rsMsgs("FMsgProfile") = True
End If

rsMsgs("FMsg") = Request.Form("FMsg")

rsMsgs("FTopicID") = Session("FTopicID")
rsMsgs("FMsgForumID") = Request.QueryString("ForumID")
rsMsgs("FMsgIP") = Request.ServerVariables("LOCAL_ADDR")

rsMsgs.Update
rsMsgs.Close
set rsMsgs = Nothing

What is the error or result your getting?

Isa Paine
Software Developer

There is no error, but the field which I wanted to update with "FtopicDI" in table [u]msg</u>s is null, I should be equal to the autoincrement "FID" which is in table Topic. rest are working fine.

I've had nothing but trouble with the AddNew method in Classic ASP. Executing a SQL statement to update works much better.

Set rsConn = Server.CreateObject("ADODB.Connection")
rsConn.Open "[Connection String]"
SQL = "UPDATE msgs SET Ftopic = '" & [variable] & "';"
rsConn.Execute(SQL)
rsConn.Close
Set rsConn = Nothing

First, this is a cross post: http://p2p.wrox.com/topic.asp?TOPIC_ID=53196 and I answered the question there, however, I assumed that the table you were trying to insert data into that the column fTopic was also an auto inc field.

What happens if you do:

INSERT INTO msgs(Ftopic)Values(" & [variable] &");"

Do you get an error?

Also, are you sure the variable you are trying to reference actually contains a value? Step through your code.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature