search

deanlaw / cfcgenerator

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

dtproperties showing in tables list for MSSQL database #29

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
files: com.cf.model.datasource.mssql.cfc

the dtproperties tables is showing in the table list for MSSQL database.
There needs to be a filter onthe qAllTables query in the getTables function
to prevent this. Below is the code that I use to filter.

select
    table_name as table_name,
    'Table' AS table_type
from
    information_schema.tables 
where
    table_type = 'BASE TABLE'
    and table_name <> 'dtproperties'

Original issue reported on code.google.com by tpetru...@gmail.com on 26 Mar 2007 at 6:07

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago 
What's wrong with showing dtproperties ?

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

GoogleCodeExporter commented 9 years ago 
you can closed this ticket.

Original comment by tpetru...@gmail.com on 13 Oct 2010 at 4:09

GoogleCodeExporter commented 9 years ago

Original comment by tom.chiv...@gmail.com on 28 Oct 2010 at 9:00