Hey Ray, thanks for sticking in...
I'll have an unknown number of values loaded from the .CSV, but no more
than 10. There will also be a fixed number of variables to assign them
to. If there is only 7 loaded the rest will be set to "".
The .csv might have user user_email, first_name, last_name so they would
map those to the fixed values email, fname, lname.
The SQL string is a very simple insert:
insert into tbl_test (email, fname, lname)
values ('"&user_email&"','"&first_name&"','"&last_name&"')
This is the basic idea:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"
http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="300">
<tr>
<td>Fixed List</td>
<td>CSV List</td>
</tr>
<tr>
<td>Email</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>First Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>Last Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
</table>
</body>
</html>