I need to link from pages not created with ASPRunner into the view.asp & edit.asp pages. I stuck some code at the top of one of the view.asp pages to retrieve the Request.Forms collection variables while entering via the list.asp page with the following result:
DISPLAY REQUEST.FORM COLLECTION
editid - 225-132A
editid2 -
todo - readonly
masterkey -
editid3 -
NeedQuotesITMItemNo - True
NeedQuotes - ,
TargetPageNumber - 1
SQL - select [ITM_ItemNo], [ITM_Desc], [ITM_ListPrice], [ITM_RplCost], [ITM_Active], [ITM_XRef] From [Items] order by [ITM_ItemNo] asc
I then created the following form in an attempt to open the view.asp page using the same form variables list.asp appears to pass:
<form method="post" action="items_view.asp" name="editform">
<input type="hidden" name="targetpagenumber" value="1">
<input type="hidden" name="todo" value="readonly">
<input type="hidden" name="SQL" value="select [ITM_ItemNo], [ITM_Desc], [ITM_ListPrice], [ITM_RplCost], [ITM_Active], [ITM_XRef] From [Items] order by [ITM_ItemNo] asc
">
<input type="hidden" name="editid" value="225-132A">
<input type="hidden" name="editid2" value="">
<input type="hidden" name="editid3" value="">
<input type="hidden" name="NeedQuotesITMItemNo" value="True">
<input type="hidden" name="NeedQuotes" value=",">
<input type="hidden" name="masterkey" value="">
<a href="#" onClick="java script:document.forms.editform.submit(); return false;">View Item 225-132A</a>
</form>
I receive error -2147217900 Syntax error (missing operator) when attempting to link to the view page from my non-ASPRunner page. Interestingly, this error occurs until you access the view.asp page via the ASPRunner created list.asp page for the first time in each session. After that the link works correctly.
Thanks for your help!