PERL & Databases

[zebrasteve]

I have been tasked to put together a database interface in PERL. I plan on using both the DBI and CGI modules. This system must have the ability for the user to search the DB make some changes to a record then update the database.

My question is: Once I have the data posted back to the browser (in a HTML table) how do I grab the primary key of the table so I can perform the UPDATE SQL?

Obviously I do not want to display this returned field in a textbox so the user can adjust it (which would cause the UPDATE not to function correctly).

Some example code would be appreciated.

Thanks!

[moltar]

store it in a hidden value?

<input [b]type="hidden"[/b] name="id" value="123" />