oH right - ( handy :) ) AFAIK there is no direct int type for double in mssql - however I do note In the past when porting mysql to access ( and then upsizing to mssql a few days later ) I had to alter the mysql double - to double float Before access could take the hint .
-----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 16:53 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Hmmmm, I'm not sure I have that sort of controll over it. The Oregano server has an xml config file that you get to specify what datatypes map to: <tinyint dbType="TINYINT"/> <integer dbType="INTEGER"/> <bigint dbType="BIGINT"/> <double dbType=""/> <timestamp dbType="DATETIME"/> <varchar dbType="VARCHAR(255)"/> <longvarchar dbType="TEXT"/> so in Oregano timestamp maps to DATETIME in the DB. On boot up of the server, a temp table is created and it's metadata compared to the above values. So far double is the one that is playing up. In the mean time I'm gonna get it up and running with MySQL, see if that works ok. Thanks anyway :O) Ade -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 16:13 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Ah wait one .. * I think you can convert the mysql DOUBLE to DOUBLE FLOAT .. and then use that to update sql float * try with caution tho I haven’t tried it myself :) -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 15:51 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Hmm float should have been your man .. Try double precision -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 15:47 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Does anyone know the SQL Server datatype that maps closest to a DOUBLE in MySQL? I'm trying to set up Oregano Server for a chat room and the config files are based on MySQL so some changes are in order. I have tried FLOAT, REAL, NUMERIC, DECIMAL and MONEY but no joy with any of them. Also, has anyone ran Oregano live? Thanks Ade ------------------------------------------------------------------ Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency ------------------------------------------------------------------ <http://www.thoughtbubble.com> Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
