I appreciate your help.
I have used your suggestions but I still must be missing something.
Let me post what I have:
controllers/test_controller.php
--------------------------------
<?php
class TestController extends AppController
{
var $name = 'Test';
}
?>
models/test.php
---------------
<?php
class Test extends AppModel
{
var $name = 'Test';
var $useDbConfig = 'gm_east'; // this has the MS-SQL connection info
var $primaryKey = 'ACCOUNTNO';
var $useTable = 'CONTACT1';
var $displayField = 'ACCOUNTNO';
function displayAll()
{
$ret = $this->query("SELECT * FROM CONTACT1");
$account = $ret[0]['ACCOUNTNO'];
return $account;
}
}
?>
databases.php
-------------
var $gm_east = array('driver' => 'mssql',
'connect' => 'mssql',
'host' => '123.123.12.12',
'login' => 'testing',
'password' => 'testing123',
'database' => 'goldmine',
'prefix' => '');
I continue to get:
Missing Database Table
No Database table for model Test (expected "tests"), create it first.
I don't really understand why it still wants a "tests" table.
What's even stranger is that sometimes, BUT NOT ALWAYS, when I refresh
the page, I get these errors:
Warning: mssql_select_db() [function.mssql-select-db]: Write to SQL
Server failed. (severity 9) in
cake/libs/model/dbo/dbo_mssql.php on line 142
Warning: mssql_select_db() [function.mssql-select-db]: Unable to
select database: goldmine in
cake/libs/model/dbo/dbo_mssql.php on line 142
I'm not sure if there's some caching going on here or what.
Thanks,
DC
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
