Updating information to database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

navin - 28 Sep 2007 16:56 GMT

Hi All,

i have page which shows supplier information in a table format, this
used internally in our company. In order to change or update
information for the supplier, i want to display supplier name in the
table cell as a link.

so if user clicks on the link with the supplier, it should take the
user to another page where user can change information and update it
into database.

but i dont know how to display supplier names as link, as there are
more than one supplier in the table.

If anybody has any other idea to update the information in database,
please share.

Appreciate any ideas on this.

thanks,
Navin

Reply to this Message

McKirahan - 28 Sep 2007 17:10 GMT

> Hi All,
>
[quoted text clipped - 9 lines]
> but i dont know how to display supplier names as link, as there are
> more than one supplier in the table.

I gather that you are looping through the table of suppliers and
generating new rows in an HTML table and that one of the columns
is the supplier name. Just make the supplier name a hyperlink passing
the Supplier's unique ID (autonumber?) in the querystring; for example:

Dim strCOL
strCOL = "<td><a href='Supplier.asp?id=" _
& objRST.Fields("SupplierID").Value _
& "'>" & objRST.Fields("SupplierName").Value & "</a></td>"
Response.Write(strCOL)

> If anybody has any other idea to update the information in database,
> please share.

Reply to this Message

Webmaster Forum / ASP / Database Access / September 2007

Updating information to database