2. ASPRunnerPro General questions
  3. [SOLVED]  Here's a bizarre hyperlink problem
This topic is locked
[SOLVED]

 Here's a bizarre hyperlink problem

 		3/22/2006 10:02:26 PM
ASPRunnerPro General questions
H
 heets author

I have a field set to display as a hyperlink to the edit screen of another table. The other table has a key that is made up of 3 fields. When I go in and test this link by clicking on it I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/dances6/NAMES_edit.asp, line 1246
Interestingly, if I navigate the edit page of the Names table through the menu structure first then go back and test the hyperlink it works fine. The only time I get this error message appears to be the first time the edit page is loaded.
Any ideas on how to fix this?
Thanks,

Bruce
Oops a little misinformation. The table I am hyperlinking to has a single field as a key but the table I am linking from has 3 fields that make up the key.
Bruce
Sergey Kornilov admin 3/23/2006

Bruce,
your hyperlink should like as Names.asp?editid=... and therefore type Names.asp?editid= in URL prefix box on the View format dialog on the Formatting Tab.
H
 		heets author 3/23/2006

Bruce,

your hyperlink should like as Names.asp?editid=... and therefore type Names.asp?editid= in URL prefix box on the View format dialog on the Formatting Tab.


Hi Sergey,
That is what I have in the URL prefix box. (actually Names_edit.asp?editid=) since I want to go to the Names_edit.asp page.
It works perfectly if I go to the Names_edit.asp page first then go back to the page where the hyperlink is and click on the link. The only time it doesn't work is when I first open the application and go straight to the page with the hyperlink.
Bruce