Below is a bit of code that is causing me some headache. I am trying to
split entry into a textbox with a ";" and upload each split to a new row in a
database.

The error I get is "Type name is invalid. "

If I input a text string (e.g. "abc" in place of the variable
"strPropaguleType2" I don't get the error. What am I doing wrong with
strPropaguleType2?

strPropaguleType2 = Split(Request.Form("txtPropaguleComment"), ";")
for each field in strpropaguleType2
Set rsPropaguleType = server.createobject("adodb.recordset")
conn.webqry_InsertDateOfIntroduction_PropaguleType strtrtnumber, strtaxon,
strPropaguleType2, strRandomNumber
next

RICK schrieb:

> Below is a bit of code that is causing me some headache. I am trying to
> split entry into a textbox with a ";" and upload each split to a new row in a
> database.
>
> The error I get is "Type name is invalid. "
>
> If I input a text string (e.g. "abc" in place of the variable
> "strPropaguleType2" I don't get the error. What am I doing wrong with
> strPropaguleType2?
>
> strPropaguleType2 = Split(Request.Form("txtPropaguleComment"), ";")
> for each field in strpropaguleType2
> Set rsPropaguleType = server.createobject("adodb.recordset")
> conn.webqry_InsertDateOfIntroduction_PropaguleType strtrtnumber, strtaxon,
> strPropaguleType2, strRandomNumber
> next
>

Despite your misleading type prefix "str", after

strPropaguleType2 = Split(Request.Form("txtPropaguleComment"), ";")

strPropaguleType2 will hold an array (returned by Split()). So check if
your webqry_InsertDateOfIntroduction_PropaguleType really expects an array
as third parameter. Perhaps you want to pass field (another not so good
variable name, btw) instead?