Hi Thadeus,

I do not understand what you mean with

> Web2py is actually guilty of performing this same operation, however instead
> of commas, we use the pipe char '|'

where does this kind of thing happen with web2py? Could you please
specify what exactly are you writing about here? Does this mean the
web2py database abstraction layer produces this kind of hackery
instead of intersection tables on a many-2-many relation?

Of course I will check this out for myself sometime this week maybe...
I can not believe it!

>From (not only) my POV this kind of "trick" brings many problems...
one of the problems is that it is nearly impossible to access the data
with standard reporting tools, frameworks, database management
software... I think it is a good think not to hide data behind a
"trick".

> Is it possible for you to run an update query on the table, and wrap every
> record with a beginning and ending comma?

No, it is not possible atm to change anything. The original developers
also had the idea of using a "trick", and if I change anything the
original application will break. Yes, I can copy the database, but I
am not asking for a workaround here, I would like to know if there is
a good way to handle this kind of problem with web2py. I am also
researching this for other frameworks.

Thank you very much for your attention!

Reply via email to