insert query 1

[andreas57]

i've got a html page with a couple of input fields and i send it with "form action..." to a asp page which should write the information into the db.

the command is:

Set rs = musikc.execute("insert into anmeldung (name, vorname, geburtsdatum, klasse, auswahl, eltern, strasse, plzort, telefon, email, dauer) values ('"&name&"', '"&vorname&"', '"&geburtsdatum&"', '"&klasse&"', '"&auswahl&"', '"&eltern&"', '"&strasse&"', '"&plzort&"', '"&telefon&"', '"&email&"', '"&dauer&"')&quot

the error is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Field 'anmeldung.Vorname' cannot be a zero-length string.

could somebody please help me?
andreas owen
aowen@arcade.ch

 

[link9]

Well, I hate to state the obvious, but it appears that you have a zero length string for the variable, 'vorname' ;-)

You have two avenues:
(1)
response.write the value to the screen BEFORE you try to do the update, so you can see what's in there... and that will get you on the right track running down what's going on.
(2)
post the code here where you set the variable in question, so we can see what you're doing.

Although, here's my guess -- you have probably misspelled the form element when you ask for it in the request.form("elementName&quot portion of your code, and so there is no value in the thing you have asked for... hence, the zero length string...

If you can't track it down, then post more code here.


Paul Prewett