Duplicate datetime column code for MSSQL

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?

1. Generate CFCs for a MSSQL table with a datetime column.

What is the expected output? What do you see instead?

You expect to see the datetime column listed once in the generated
components however code for any date time columns is generated twice.

What version of the product are you using? On what operating system?

cfcGenerator revision 19 running on CFMX 7.0.2, Windows XP Pro, and MSSQL 2000.

Please provide any additional information below.

It seems the query in the setTableMetadata method of the mssql.cfc is
returning duplicate rows for datetime columns. The attached patch has an
updated query which fixes this issue.

Original issue reported on code.google.com by nmis...@gmail.com on 19 Aug 2006 at 6:09

Attachments:

mssql.diff

GoogleCodeExporter commented 9 years ago

Thse fix for this has been committed. Added Distinct to query.

Original comment by brian.ri...@gmail.com on 8 Sep 2006 at 4:08

GoogleCodeExporter commented 9 years ago

Original comment by brian.ri...@gmail.com on 8 Sep 2006 at 6:55

Changed state: Fixed

deanlaw / cfcgenerator

Duplicate datetime column code for MSSQL #3