DB Connection

[Shrikrishna Sathe]

The following .asp code sinppet gives error. 
 
    Dim rs
    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open "printjob",objConn, adOpenForwardOnly, adLockOptimistic  , adCmdTable
    rs.AddNew 

       rs("jobid") = Request.Form("jobno")
       rs("closesize") = Request.Form("closize")
       rs("opensize") = Request.Form("opsize")  
         
       rs.Update
       rs.Close
       Set rs = Nothing

Is this AddNew call doesn't work in mysql ?
The Insert into statement works well but it is very cumbersome while adding >25 
fields. 

please guide.

Thanks & Regards
Shrikrishna