Updating MySQL Database using .asp

[powerlock2005]

All,
I would like to update my MySQL database from a field called: regID, which is an auto_increment field, using a .asp page.

This is the code I have that connects and adds to the database:

<%

ConnString = "Driver={MySQL};SERVER=localhost;DATABASE=gsgevents;UID=name;PASSWORD=password"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnString

mySQL = "INSERT INTO tbl_registration (dateEntered,salutation,first_lastName,company,mailingAddress,city,state,zipCode,telephoneNo,faxNo,email,xMeal,hotelYesNo,arrivalDate,departureDate,roomType,bedSize,sharingRoomYesNo,roomMate,totalInRoom,creditCardType,creditCardNo,cardHoldersName,expDate)"
mySQL = mySQL & " VALUES ('" & request.form("dateEntered") & "','" & request.form("salutation") & "','" & request.form("first_lastName") & "','" & request.form("company") & "','" & request.form("mailingAddress") & "','" & request.form("city") & "','" & request.form("state") & "','" & request.form("zipCode") & "','" & request.form("telephoneNo") & "','" & request.form("faxNo") & "','" & request.form("email") & "','" & request.form("xMeal") & "','" & request.form("hotelYesNo") & "','" & request.form("arrivalDate") & "','" & request.form("departureDate") & "','" & request.form("roomType") & "','" & request.form("bedSize") & "','" & request.form("sharingRoomYesNo") & "','" & request.form("roomMate") & "','" & request.form("totalInRoom") & "','" & request.form("creditCardType") & "','" & request.form("creditCardNo") & "','" & request.form("cardHoldersName") & "','" & request.form("expDate") & "')"
'make sure to change the word "demoConn"
'below to the name of your connection
Conn.execute(mySQL)

How can I implement a way to update the table with .asp using the regID field?

Please help someone.

Thanks in advance,

 

[ChrisHirst]

just use a SQL update statement instead of an insert statement.



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[ChrisHirst]

whoops hit submit instead of preview.


mySQL = "UPDATE table SET column = value, [column = value] WHERE column = value;"

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.