Xataface using SET field types?
Archived from the Xataface Users forum.
sophistry — Wed Jun 11, 2008 8:00 pm
Hi steve and friends,
My first time posting here, so I have to give you props for creating such an intuitive frontend for mysql browsing/editing.
I’m creating a database here, and one thing I noticed was the problem handling SET field types. Selecting one item in the set works fine, but whenever I select multiple entries via combobox (or checkbox, I suppose), it will not save multiple entries to the database. Either it is saved blank, or just one entry. I’m assuming this is because it isn’t saving the string with correct formation?
I know Xataface can use fields.ini & valuelists.ini with a TEXT field type to create a similar desired effect, but I’d rather do it with SET type in the mysql database.
The server is running mysql 5.0.45, and php 5.2.5 on a web host (no shell access).
On another database, I’m having issues installing on IIS, but I’ll save that for another topic…
Thanks again,
sophistry
sophistry — Fri Jun 13, 2008 7:29 am
I did notice a line in one of the tutorials recently, that mentioned SET type management wasn’t supported yet. I’m running the latest beta, what’s the status of this functionality?
In the meantime, I suppose I will hide the SET fields and create new TEXT fields duplicating the functionality.
shannah — Mon Jun 16, 2008 2:27 pm
Hi Sophistry,
SET support is unfortunately still lacking (because I haven’t been using these types of fields, and neither has anyone else that has been contributing to this point). It would not be difficult to add support. Perhaps add it as a feature request in the issue tracker and we can try to get to it for a future version.
-Steve
shannah — Mon Jun 16, 2008 2:27 pm
If you want to dig through the code, I believe that the only place that would really need to have code changes would be the Dataface/Serializer.php file….
-Steve
sophistry — Mon Jun 16, 2008 2:37 pm
Thanks a lot for the reply, Steve. I might be able to take a look at it, at some point.
It’s not that big of an issue for the time being. The functionality exists with TEXT types, so I’m using that.
Great work, and I hope I can contribute in some way.