Skip to main content
March 16, 2007
Question

Record_ID in repeat region

  • March 16, 2007
  • 1 reply
  • 244 views
Hello,

I am working in DreamWeaver 8, ASP and Access. I have a page with a recordset that displays a three fields froma table in a repeated region (ID, Name, Office). I have a second form that is a detail form showing all the fields int he table for editing purposes. If I put a link on any of the three fields on the first page that includes a call to the details page with a URL variable for the ID field everything works just fine (the link code is: Officer_Update.asp?record=<%=rsOfficer("LbsOf_ID")%>).

My problem is that instead of linking the fields I would like to insert another column in the table, put a button there called "Edit", and have the button call the detail page. But when I do that and paste in the exact same code in the link I get an undefined variable error. What do I need to do so the a button in the same row as the rest of the record data knows what record it is on so it can pass the recordID onto another form?

Thanks,
Mark
This topic has been closed for replies.

1 reply

Inspiring
March 17, 2007
Hi mark,

Assuming I'm understanding you correctly:

<a href="Officer_Update.asp?record=<%=rsOfficer("LbsOf_ID")%>"><img
src="image.gif"></a>

HTH.
Nath.

"bixmark" <webforumsuser@macromedia.com> wrote in message
news:eteetu$kab$1@forums.macromedia.com...
> Hello,
>
> I am working in DreamWeaver 8, ASP and Access. I have a page with a
> recordset
> that displays a three fields froma table in a repeated region (ID, Name,
> Office). I have a second form that is a detail form showing all the
> fields int
> he table for editing purposes. If I put a link on any of the three fields
> on
> the first page that includes a call to the details page with a URL
> variable for
> the ID field everything works just fine (the link code is:
> Officer_Update.asp?record=<%=rsOfficer("LbsOf_ID")%>).
>
> My problem is that instead of linking the fields I would like to insert
> another column in the table, put a button there called "Edit", and have
> the
> button call the detail page. But when I do that and paste in the exact
> same
> code in the link I get an undefined variable error. What do I need to do
> so
> the a button in the same row as the rest of the record data knows what
> record
> it is on so it can pass the recordID onto another form?
>
> Thanks,
> Mark
>