search

deanlaw / cfcgenerator

Automatically exported from code.google.com/p/cfcgenerator
8 stars 6 forks source link

DAO attempts to insert into auto-generated MSSQL GUID UniqueIdentifier column #28

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I'm currently using cfcgenerator_build_4_2007-03-11 with MS SQL 2K.

The problem I'm having is that inserts fail because the DAO attempts to
write to a GUID column that has a new(id) default. 

To reproduce the problem, create a MS SQL table with an auto-gen GUID and
try to save a record to table using the generated Service/DAO.

Other than that, I love this tool! Thanks for all the work you do, Brian!

Glenn

Original issue reported on code.google.com by rabidgad...@gmail.com on 20 Mar 2007 at 1:40

GoogleCodeExporter commented 9 years ago

Original comment by brian.ri...@gmail.com on 24 Apr 2007 at 2:00

GoogleCodeExporter commented 9 years ago 
Could you try modifying the query in 
http://code.google.com/p/cfcgenerator/source/browse/trunk/cfcgenerator/com/cf/mo
del/datasource/mssql.cfc setTableMetadata() (to exclude column totally) and/or 
setPrimaryKeyList() (to exclude from setting) ?
If so, please let us have the modified version...

Original comment by tom.chiv...@gmail.com on 13 Oct 2010 at 2:49