Hi, i'm wondering how i can set hidden form fields to an array from a record set, this is what i have so far, am i on the right track?
Code:
For i = 0 To UBound(garrResult, 2)
mycount=mycount+1
<input type="hidden" name="ID" value="<% = garrMember(0, i) %>">
<input type="hidden" name="LastName" value="<% = garrMember(1, i) %>">
<input type="hidden" name="FirstName" value="<% = garrMember(2, i) %>">
<input type="hidden" name="Email" value="<% = garrMember(3, i) %>">
<input type="hidden" name="Fax" value="<% = garrMember(4, i) %>">
<input type="hidden" name="Province" value="<% = garrMember(5, i) %>">
<input type="hidden" name="RegistrationURL" value="<% = garrMember(9, i) %>">
<input type="hidden" name="UnsubscribeURL" value="<% = garrMember(10, i) %>">
<input type="hidden" name="AccessCode" value="<% = garrMember(11, i) %>">
<input type="hidden" name="Specialty" value="<% = garrMember(8, i) %>">
<input type="hidden" name="Profession" value="<% = garrMember(13, i) %>">
<input type="hidden" name="SurveyName" value="<% = gstrSessionSurveyName %>">
<input type="hidden" name="SurveyID" value="<% = gstrSessionSurveyID %>">
Next
and i'm also wonder how i can insert these records into a table uning insert, statically i would use this:
Code:
strSql = "INSERT INTO recruitmentLists (SurveyID, SurveyName, ID, LastName, FirstName, Email, Fax, Province, RegistrationURL, UnsubscribeURL, AccessCode, Specialty, Profession, creator, creatorDate) VALUES ('"&Request.Form("SurveyID")&"','"&Request.Form("SurveyName")&"','"&Request.Form("ID")&"','"&Request.Form("LastName")&"','"&Request.Form("FirstName")&"','"&Request.Form("Email")&"','"&Request.Form("Fax")&"','"&Request.Form("Province")&"','"&Request.Form("RegistrationURL")&"','"&Request.Form("UnsubscribeURL")&"','"&Request.Form("AccessCode")&"','"&Request.Form("Specialty")&"','"&Request.Form("Profession")&"','"&Session("uzor")&"',GetDate())"