Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Checkbox fields

Quote Reply
Checkbox fields
2.05
I have columns with checkboxes. When I try to modify a record the checkbox-fields are not marked with the selected values. All checkboxes are blank.

At the user pages the values are shown. How to make them visible at modify form?

Michael

--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] Checkbox fields In reply to
I found out that the it has only effect to the imported data, 2.03 >> 2.05

The checkbox-values of the new added records are shown.

Michael


--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] Checkbox fields In reply to
Hi,

Enter this in SQL monitor:

UPDATE Links SET Column = REPLACE(Column, CHAR(0), "\n");

where Links = your table, may need to be prefixed, Column = a column with checkboxes.

Links SQL 2.0.3 used \0 to separate values, 2.0.5 uses \n (as \0 caused problems on non mysql databases).

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Checkbox fields In reply to
I changed "Column" to the columns name and runned the query,
without success.

I checked the columns with mysqlman

The old data have # between the values, at the new added data there is no sign to see which does separate the values.

The columns with the checkboxes have column-type TEXT

Michael

--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] Checkbox fields In reply to
Alex,

remember that I also have the problems with query-search after I have added new records to the backuped-data from 2.03 into 2.05

Michael

--
Michael Skaide

http://www.cycle24.de