This isn't my day - I've got a two part application form. Once the user completes part 1, it inserts into a database table where I've got an auto-number applicant_id field.
My question is this - I want the applicant_id to carry over to the next page and insert into the next database table. This is what I've tried:
And to insert, I'm using this as a hidden field in my form:
That unfortunately inserts just a 0 and not the actual applicant_id number.
Any suggestions as to what I'm doing wrong?
Thanks in advance.
Michelle
My question is this - I want the applicant_id to carry over to the next page and insert into the next database table. This is what I've tried:
Code:
<%
dim applicant_id
applicant_id = session("applicant_id")
%>
And to insert, I'm using this as a hidden field in my form:
Code:
<input type="hidden" name="applicant_id" value="<%=applicant_id%>">
That unfortunately inserts just a 0 and not the actual applicant_id number.
Any suggestions as to what I'm doing wrong?
Thanks in advance.
Michelle