[thelist] Shouldn't this work?

[Matt Warden]

Dena,

> For these request variables:
> (there can be n sets of dev_location1,dev_subtype1,dev_condition1.
> dev_comments is a comma delimited string of n length where n=the number of
> sets above.)
...
> for i=0 to ubound(arrDevComments)
>  sQuery = sQueryStartString & Request.form("dev_type") & "', '" &
> Request.form("dev_subtype" & i) & "', '"  & ..etc. & "');"
>  response.write sQuery & "<BR>"
>  next
> 
> I come up with query strings like the one below.
> INSERT INTO development (dev_type, dev_subtype, dev_condition, dev_comments,
> dev_location) VALUES ('Wells', '', '', 'test1', '');
> 
> Any ideas?

>From your description, there is no dev_type0, yet your first iteration
is dev_type0, etc.

Run this somewhere on the page. It will help you see what fields are available:

<ul>
For Each item in Request.Form
    Response.Write "<li>" & item & ": " & Request.Form(item) & ".</li>"
Next
</ul>

-- 
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.