CDO Mail and using asp code in htmlBody

[smanCometh]

I have a form that inserts into a database and then generates an email to me with a link. I need that link to be a url parameter back to the record based on record ID. The url will be something like http://www.website.com/web_request_edit.asp?ID=101. Currently the line of code I have been struggling with is:
oMail.HTMLBody = "http://ocfs.state.nyen et/web_request_edi t.asp?ID=&web_r equests.fields. item('id').valu e&"

Can someone give me the correct syntax?

[jhardman]

oMail.HTMLBody = "http://ocfs.state.nyenet/web_request_edit.asp?ID=" & request("id")

Jared

[smanCometh]

That didn't work. That only gave me:
http://ocfs.state.nyenet/web_request_edit.asp?ID.

I need http://ocfs.state.nyenet/web_request_edit.asp?ID=102. Any ideas?

Thanks

[jhardman]

if that didn't work then you don't have a field "id" in your request object. Where does the id number come from?

Jared

[smanCometh]

It's an autonumber field in my sql table <%=(web_request s.Fields.Item(" ID").Value)%>

[jhardman]

oMail.HTMLBody = "http://ocfs.state.nyenet/web_request_edit.asp?ID=" & web_requests.Fields.Item("ID").Value

does this work?

Jared

[smanCometh]

Yes!...that did the trick at last I have my functionality!. ..thank you Jared.