Forums
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
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
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