Xataface using SET field types?

[sophistry]

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]

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]

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]

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]

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.