Updating information to database

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

Re: Updating information to database

"navin" wrote in message
news:1190994968.687000.96100@o80g2000hse.googlegroups.com...
> 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.

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 = "" & objRST.Fields("SupplierName").Value & ""
Response.Write(strCOL)

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