Hey all,

Thanks for the previous help.

I need to provide a record set sql display with edit/delete buttons (links).

ie

field1 field 2 field 3 edit/del

where the edit del takes to page specific for that record.

Any helpful extensions on this?

Thanks

Where you've got edit/delete you could simply make them links to a page with some ASP that carries out the action you want.
e.g. <a href="delete.asp?recordID=<%=myRecordset("recordID"%>">delete</a>
and
<a href="edit.asp?recordID=<%=myRecordset("recordID"%>">edit</a>

For delete.asp set up a command that deletes the record you want
For edit just pick up the ID and filter your recordset and pre-populate the form for the user to edit

Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]

Thanks simon - after 5 hours i now have a really nifty little scenario running

a bit of php hand code with a nice table extension for mouse colour changes from www.technocurve.co.uk

thanks for help