Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_beginners thread: passing bookmarks through querystring and query back by SQL statement


Message #1 by "Mike Misconin" <michael.misconin@n...> on Fri, 7 Feb 2003 16:02:36
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

  Return to Index