Forums

ASP

This topic is locked

Help!

Posted 22 Sep 2006 16:18:33
1
has voted
22 Sep 2006 16:18:33 John Strubel posted:
Hi:

I have set up an admin panel for my database. Whever I click the "edit" button to access individual records, I only get the first record on the list, not the requested record. You can see it here:

www.csuniv.edu/db_list_edit.asp

NOTE: When you mouse over any of the edit buttons you can see different ID's but the button sends me to the first record. Any suggestions?

Thanks ... John

John Strubel

Replies

Replied 23 Sep 2006 17:28:06
23 Sep 2006 17:28:06 lou castro replied:
i have had similar problems in the past...
I resolved mine by recreating the recordset in the detail page. Just make sure it says Filter=ID url parameter.

Hope this helps
Replied 25 Sep 2006 04:31:12
25 Sep 2006 04:31:12 Wim Conix replied:
Hello,

Seems like he's sending the correct parameter to the edit page.
So problem lies in the recordset there.

Must be something like :

SELECT *
FROM YourTable
WHERE YourTable.ID = MMColParam

Make sure to create this MMColParam with numeric, default=1 and value Request.Querystring("ID"

This way it should work without problem...

Hope this helps,

Wim

Wim Conix
www.image-belle.com

Reply to this topic