update specific record

[davmold]

hello,

I came across a script for a guest book, This guest book script has an update_select.asp page that builds a link where you can click and it will redirect you to the specified record.

example [URL unfurl="true"]http://myserver/update_form?id=123[/URL]

this works well I was wondering if I could redirect it to

[URL unfurl="true"]http://myserver/update_form?id=123[/URL] and ?id2=001

 

[monksnake]

It would be written like this:

[URL unfurl="true"]http://myserver/update_form?id=123&id2=001[/URL]

<.

 

[davmold]

I was looking at my sql statement and it looks something like this

Dim lngRecordNo			'Holds the record number to be updated


'Read in the record number to be updated
lngRecordNo = CLng(Request.Form("ID_no"))



'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblComments.* FROM tblComments WHERE ID_no=" & lngRecordNo

so I added

Dim lngRecordNo			'Holds the record number to be updated
Dim IngOrderNo			'Holds the work order number to be updated

'Read in the record number to be updated
lngRecordNo = CLng(Request.Form("ID_no"))
ingOrderNo  = CLng(Request.Form("monumber"))



'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblComments.* FROM tblComments WHERE ID_no=" & lngRecordNo and monumber=" & IngOrderNo

 

[monksnake]

You're missing a little bit:

strSQL = "SELECT tblComments.* FROM tblComments WHERE ID_no=" & lngRecordNo [!]& "[/!] and monumber=" & IngOrderNo

Other than that, assuming your connection string and record sets are defined correctly, what you have should work.

<.

 

[davmold]

back to the link, I tried your first reply but it did not work, the statement that builds the link looks like this

Response.Write ("<a href=""update_form.asp?ID=" & rsGuestbook("LORD") & """>")

I am not sure how to add the

&id2=001

 

[bslintx]

make sure when you are requesting the form values the variable names are correct...get into the habit of assigning to variables..gets less confusing...also note you can use response.write shortcut in the html...some find this easier to read and create

also, is the model number always a number...or alphanumeric?...i used as string...change as needed

also, you have the hungarian prefix as ilg not lng for monumber...(again..make sure the vars match(request and sql in this situation)

also...the link is a querystring...not form...use request.querystring(foo)

<%
  '...if not rsGuestbook.eof then

  lngIDno = rsGuestbook("LORD") 
  strMonumber = "001" 'hardcoded...perhaps rs goes here
%>


  <a href="update_form.asp?ID_no=<%=lngIDno%>&monumber=<%=strMonumber%>">Update</a>

<%
  ' ... close statements
%>