[garf]

thanks.

So what's the difference between PK and a unique index which is not PK?

And anoter question (didn't know where to put it):

I used this code to add a record to table 'adItems' when I used access.

once I added the record, I pulled the new id of it (just after it was created).

[codebox]

Set rs = Server.CreateObject(“ADODB.Recordset”)

rs.open “select * from adItems”,conn,3,3

rs.AddNew

rs(“catId”) = catId

rs(“expiry”) = expiry

rs(“adTitle”) = adTitle

rs.Update

newid = rs(“id”)

rs.close[/codebox]

now, that I moved to MySql, newid remains blank. why is that? Any idea?

Thanks again

[Author]

Posts