aspx_beginners thread: passing bookmarks through querystring and query back by SQL statement
Can anyone help. I have a form which is sectioned off into several entry
forms which allow a user to enter information and pass's the filled in
info to a process page which saves the info in a SQL table and in turn
redirects back to the origional form and displays the info the was saved
back. The problem I have is I would like to add bookmarks to the
origional form so when the users submits wach section the origional form
will display that section.
The process page uses: After inserting the data with SQL queries then
Response.Redirect "http://testdomain/AppInfo.asp?AppId=" & AppID
back to the origional page.
The AppInfo.asp (origional) pages uses:
AppID = Request.QueryString("AppID")
Session("AppID") = AppID
SQL = "SELECT * from AppDB where AppDb.AppId = '" & AppID & "'"
When querying back the info.
If I hard code a bookmark like a hyperlink like this:
http://testdomain/AppInfo.asp?AppId=152#access then it will work but if I
try to pass the bookmark as a variable through a querysting then SQL send
back an error message on the AppInfo page: "Syntax error converting the
varchar value '152#access' to a column of data type int."
Any Ideas.
Mike