Gossamer Forum
Home : Products : Others : MySQLMan :

Editing Records

Quote Reply
Editing Records
I am wanting to use MySQLMan to do backend editing of our MySQL database (which we use with WonderDesk (dbMan). The problem (v1.07) I am having is;

I list the Tables in the database and then I browse a table, it shows all the records etc. within it just fine, however, only the last table in the database adds on the ability to Edit or Delete the records at the end of the row.

Just to be clear on this, database with 5 tables;
Calls, Customers, WD_FAQ, WD_session, WD_users

I can browse all of them, but only the last table (WD_users) alllows me the choice to edit the individual records within the table.

If I use the line;

http://URL/cgi-bin/mysql/mysql.cgi?do=modify&data_source=DBI:mysql:cms20&table=WD_FAQ&page=1&sort_index=id&fields=*&where=&example=&action=edit_record&record_modify=id+=+'11'&browse_action=browse

And change the sort_index and record_modify I can force the edit for a record, but thats a pain, is there a fix for this problem that I can edit into the .cgi?

Thanks,

=Dave



Quote Reply
Re: Editing Records In reply to
Hi,

Only tables with primary key's are editable. You must define a primary key for the table before the edit/delete links appear.

Cheers,

Alex

--
Gossamer Threads Inc.