Doug, Sorry for the delay, a major issue made me forgot about this ( we defeated England ;) ), here is the a script to create a dumb table. If you remove the default value it generates well the object (as usual) but as soon I set that default value, I got the error back again.
Regards, João Fernandes Dep. Informática - Área de Desenvolvimento Cofina media Avenida João Crisóstomo, Nº 72 . 1069-043 Lisboa PORTUGAL Tel (+351) 213 185 200 . Fax (+351) 213 540 370 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of João Fernandes Sent: sábado, 1 de Julho de 2006 0:19 To: [email protected] Subject: RE: [Reactor for CF] Bug with MSSQL 2005? Doug, I'll try to connect remotely tomorrow and generate a script for you and a config file. João Fernandes -----Original Message----- From: [EMAIL PROTECTED] on behalf of Doug Hughes Sent: Fri 30-Jun-06 6:42 PM To: [email protected] Subject: RE: [Reactor for CF] Bug with MSSQL 2005? Can you please provide an example in the bug? I can't reproduce. Doug _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of João Fernandes Sent: Friday, June 30, 2006 12:42 PM To: [email protected] Subject: RE: [Reactor for CF] Bug with MSSQL 2005? Done. Ticket #35. João Fernandes Dep. Informática - Área de Desenvolvimento Cofina media Avenida João Crisóstomo, Nº 72 . 1069-043 Lisboa PORTUGAL Tel (+351) 213 185 200 . Fax (+351) 213 540 370 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: sexta-feira, 30 de Junho de 2006 17:28 To: [email protected] Subject: RE: [Reactor for CF] Bug with MSSQL 2005? This is probably not a bug with 2005, but with the latest code. I removed the field cfc and replaced it with a struct to help performance and memory issues. This is probably a side effect of that. Please log as a bug in trac. Doug _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of João Fernandes Sent: Friday, June 30, 2006 11:45 AM To: [email protected] Subject: [Reactor for CF] Bug with MSSQL 2005? Hi there, I'm using reactorFactory.getxml() to build my custom plugins but reactor is failing on a specific table where I have a default value. I debugged it and the problem is on the ObjectDao when calling <cfset Field.default = getDefault(qFields.default, Field.cfDataType, Field.nullable) /> Which if I dump at the end the Field Object I have for default value: [undefined struct element] The query in readFields function returns for that field the default value ('PT') but It's translated in SQL when inserting new records as PT. This issue existed previously with the newId() as default value for string type. Can anyone confirm this behavior so it can be logged as a bug? Thanks, João Fernandes Dep. Informática - Área de Desenvolvimento Cofina media Avenida João Crisóstomo, Nº 72 . 1069-043 Lisboa PORTUGAL Tel (+351) 213 185 200 . Fax (+351) 213 540 370 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
sql2005ReactorBug.sql
Description: sql2005ReactorBug.sql
