Incorrect record being selected for editing [SOLVED]

Talk about Sorting & Paging problems, issues etc.

Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako

stevenp
Newbie
Newbie
Posts: 7
Joined: Mar 19th, '10, 22:36

Incorrect record being selected for editing [SOLVED]

Postby stevenp » Apr 27th, '10, 17:55

Hello,

Please help me get this issue figured out. The datagrid is displaying the wrong record when I make a selection for editing i.e., I select record X for editing and the program displays record B instead. It does not happen in all cases, but it is of course undesirable. As a hands-on example, please have a look at this http://www.ambientmediasystems.com/voters/datagrid/voters_main.php. In the search window at the top of the datagrid, select EDEN LODGE from the DISTRICT drop-down field. Then scroll to the bottom of the table and click on the the pencil to edit the record for MAYFIELD PIPE (2216). I keep getting the record for ROSLYN HAYNES instead. I've turned on the debugging tag so that it displays the MYSQL code (HTH).

PLEASE HELP!

administrator
Site Admin
Site Admin
Posts: 5959
Joined: Jan 7th, '09, 23:18
Contact:

Re: Incorrect record being selected for editing

Postby administrator » Apr 28th, '10, 06:33

Please define Primary Key auto-incremented integer and use it for datagrid.
Right now it seems you work with some string value.

Also, post here please your SELECT for View mode and definitions for edit mode.

stevenp
Newbie
Newbie
Posts: 7
Joined: Mar 19th, '10, 22:36

Re: Incorrect record being selected for editing

Postby stevenp » Apr 28th, '10, 18:29

Thanks so much for your help. I think it worked. I just needed to turn off the UNSIGNED AUTOFILL option for the PRIMARY id field and it seems to have done the trick.

Much appreciated.


Return to “Settings: Sorting & Paging”