-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

        Hi Brendan

        I found that this part of the coapiSchema.cfm file causes my
issue:

SELECT  ut.TABLE_NAME AS TableName, 
                                        uc.COLUMN_NAME AS ColumnName,
                                        uc.DATA_LENGTH AS length,
                                        uc.NULLABLE AS isnullable,
                                        uc.DATA_TYPE AS Type
                        FROM           
#application.dbowner#USER_TABLES ut
                        INNER JOIN USER_TAB_COLUMNS uc  ON     
(ut.TABLE_NAME = uc.TABLE_NAME)
                        GROUP BY        ut.TABLE_NAME,
                                                uc.COLUMN_NAME,
                                        uc.DATA_LENGTH,
                                        uc.NULLABLE,
                                        uc.DATA_TYPE


All I did was change:

FROM            #application.dbowner#USER_TABLES ut

To:

FROM            USER_TABLES ut



        And all is now working, I can see the tables listed including
the
new ones I had added.

        However I now have another issue. I have added the Photo TAB to
the
structure but when I click on it I am getting an error stating"

Unknown tag: misc:cachecontrol
        Anyone know what may have gone wrong here?





Dean Brandt 
Clever Thinking Consulting 
Network/Systems Integration, 
Application Design 
Internet Presence Supplier/Hosting Specialists 
Melbourne, Australia 
Ph:   03-97492747
Mob: 0418488885 
...smart networks for smart business 

PGP Public Key: http://pgp.cleverthinking.net//DeanBrandt.asc


 



-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.2

iQA/AwUBP52vYbtxbk0Vy5cMEQLVFwCgq2snbzghZJ/agVTz8rhc6rvpelcAn2ZH
9m1f+EZ4O9yN0Uj9mciODFtg
=01xv
-----END PGP SIGNATURE-----


---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to