Hi everybody!

I´m very new to MySQL and my question is hopefully easy to answer for those of
you who have more experience.

In my MySQL database I have a table with a column named "firstname". firstname
is declared as varchar(30). In an ASP page I use VBscript to get data from the
user with the help of a web form (FORM METHOD="post"...). In the VBscript I
place the user input in a variable called fname. Then I set up a connection to
the DB and try to insert the data. At this point I always get an error message
saying:

"Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value,
if available. No work was done."

In the error message there´s also a reference to the row in the script code
where I try to execute the insertion into the "firstname"-field. Here´s an
extract from the script:

------------------------------------ fname=Request.Form("firstname") Set MinCon=Server.CreateObject("ADODB.Connection") Set rs=Server.CreateObject("ADODB.Recordset") MinCon.Open "webbutiken"

SQL="SELECT * FROM kund WHERE 1=2;" rs.Open SQL, MinCon, 1, 2

rs.AddNew rs("firstname")=fname 'here´s the row where the error occurs rs.Update rs.Close MinCon.Close ------------------------------

I use the following versions of the programs:

MySQL 3.23.49-max-debug MyODBC 2.50.39.00 The webbserver I use is Microsoft Personal Webserver.

Please help me if there´s anyone who can see what I´m doing wrong!!

Regards