I am using a URL Parameter to pass a value from page ONE on to page TWO from
a link (category_id) and I know it works because page TWO is created based
on the value (category_id).
Also on Page TWO I have a form to add a record to the database. But the
record when added must contain a category_id that is not supplied by the
user. Since the ID is already being passed I decided to use it again when
Inserting a record. After filling in the form and pressing SUBMIT the page
automatically refreshes and should show the new entry in the list. The new
entry is not there. If I go and check the database the entry is there but
the category number assigned is "0" instead of, in this case, 1.
So in order to troubleshoot this I wanted to see this number on the screen.
I tried using
<% =Request.QueryS tring ("category_i d") %> but is shows nothing. I would
have thought that it would show the same number as in the database "0".
I am passing the string from page ONE using this:
<A
HREF="books.asp ?category_id=<% =(rsCategories. Fields.Item("ca tegory_id").Val u
e)%>"><%=(rsCat egories.Fields. Item("category" ).Value)%></A>
Any ideas how to troubleshoot this or am I doing something completely wrong?
Houston
a link (category_id) and I know it works because page TWO is created based
on the value (category_id).
Also on Page TWO I have a form to add a record to the database. But the
record when added must contain a category_id that is not supplied by the
user. Since the ID is already being passed I decided to use it again when
Inserting a record. After filling in the form and pressing SUBMIT the page
automatically refreshes and should show the new entry in the list. The new
entry is not there. If I go and check the database the entry is there but
the category number assigned is "0" instead of, in this case, 1.
So in order to troubleshoot this I wanted to see this number on the screen.
I tried using
<% =Request.QueryS tring ("category_i d") %> but is shows nothing. I would
have thought that it would show the same number as in the database "0".
I am passing the string from page ONE using this:
<A
HREF="books.asp ?category_id=<% =(rsCategories. Fields.Item("ca tegory_id").Val u
e)%>"><%=(rsCat egories.Fields. Item("category" ).Value)%></A>
Any ideas how to troubleshoot this or am I doing something completely wrong?
Houston