Dear Michael, I have set the schema attribute of my datasource to mysql.xml (which I have written myself). In this file I can only set datatype mappings. I can't tell Orion what are the literals for True or False.
tnx, Roozbeh/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Michael Simons Sent: Monday, October 01, 2001 11:14 AM To: Orion-Interest Subject: Re: Problems with CMP/MySQL Roozbeh Ghaffari wrote: > Hi All, > > > > We use Orion CMP features with MySQL. We had problems with boolean and > char fields. > > I used P6Spy (www.provision6.com <http://www.provision6.com>) to see > SQL commands generated by Orion. > > Orion says: > > update table_name set boolean_field = 'true' > > but MySQL expects > > update table_name set boolean_field = '1' > > > > How can I ask Orion to generate the expected SQL? > > > > But in case of character field we have a bigger problem. > > I try to set a character field to 'F' or 'M' > > Orion says: > > update table_name set char_field = 0 > > !!! > > I don't understand what is happening! > > > > Thank you in advance, > > Roozbeh/ > Sounds like You're missing $ORION_HOME/config/database-schemas/mysql.xml michael -- Dipl.-Math. (fh) Michael Simons UNIOPT AG // unique logistic optimization Maximilianstr. 29; D-93047 Regensburg phone: ++49(0)941/59578-0 http://www.uniopt.net/ _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
