link to a sql record. 1

[jeellison]

Good day all,

I have a table of results listed from a sql db. Now is there a way of making one on the fields (ID) a link which when clicked will then take it to that record with all the details to edit it?

Ive looked everywhere for this and am amzed I cant find any tutorials?

Any ideas please?

Thanks
James

 

[BigRed1212]

I have seen a couple of tutorials that might be helpful to you and were helpful to me starting out. I will look for them and post them later because I can't remember where they are right now.

Perhaps in the meantime you could provide some more information about what you are doing and want to do? How many records will be in the recordset you want to edit? How many fields in the records? Is this for a live Web app?
A little background?

 

[jeellison]

Thanks BigRed.

Basically it is a program to manage jobs. At the moment I have a page where the admin can create a job, so it has a unique jobnumber, customer name, details, assigned to, created by etc.

Then there is a link to display all records which are all displayed neatly in a table. So what I want is a link on each row to go to that individual record so it can be edited, ie change the details or change from a open status to a closed status.

Hope this helps
Thanks
James

 

[wvdba]

you have to build a table with a <href> on the key.
try this on an html page see if this is what you want.

sample table 
<table name="table1" border="4">
<tr> 
<td> 
<a href="your_program.asp?email=me@dot.net&model=model_t">email_addr</a> 
   </td> 
   <td>cell2</td>
   <td>cell3</td>
   <td>cell4</td>

</tr> 
</table>

this displays a table with 4 boxes, the first box has a link to a program called "your_program.asp". when you click it, it will take you there with email and model being sent with it.

 

[BigRed1212]

jeellison:

Go take a look at these and see if they are helpful-

http://www.stardeveloper.com/articles/display.html?article=2000040101&page=1

http://www.codefixer.com/tutorials/news_management_system_part1.asp

They helped me.

 

[jeellison]

Hi BigRed,

Part 7 did the trick.

http://www.codefixer.com/tutorials/news_management_system_part7.asp

Thank you very much.

James