Re: Can not connect Cake to a Mssql db
The solution: You need to make a default instance of the SQL DB . On Mon, Feb 8, 2010 at 10:04 AM, Trandaburu Tiberiu Andrei < birli...@gmail.com> wrote: > did somebody connected ? > > > On Sun, Feb 7, 2010 at 5:16 PM, seamaster wrote: > >> Hi, >> >> i try to connect cakephp and after 2 days of trying i get only the >> yellow box with "Cakephp can not connect to the database" >> >> the database si reachable because it works connecting from an external >> php !!! >> >> The database and wamp where cake is installed are on a vmware machine >> thats having microsoft server !!! >> >> The DB is Microsoft Sql Server 2008 >> >> My config looks like this: >> >> var $default = array( 'driver' => 'mssql', >> >> 'host' => '\', >> >> 'login' => 'test', >> >> 'password' => 'test', >> >>'database' => 'my_db', >> >> 'prefix' => ''); >> >> Please i don`t want questions like "you have a mssql driver." yes >> i have because it works connecting outside cake >> >> All i want is answers from people who did make the connection , or >> experienced ones. Lets try to make a post that will help others >> because on the internet is not something well explained. >> >> Thanks and i`m waiting your posts > > > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: Can not connect Cake to a Mssql db
did somebody connected ? On Sun, Feb 7, 2010 at 5:16 PM, seamaster wrote: > Hi, > > i try to connect cakephp and after 2 days of trying i get only the > yellow box with "Cakephp can not connect to the database" > > the database si reachable because it works connecting from an external > php !!! > > The database and wamp where cake is installed are on a vmware machine > thats having microsoft server !!! > > The DB is Microsoft Sql Server 2008 > > My config looks like this: > > var $default = array( 'driver' => 'mssql', > > 'host' => '\', > > 'login' => 'test', > > 'password' => 'test', > >'database' => 'my_db', > > 'prefix' => ''); > > Please i don`t want questions like "you have a mssql driver." yes > i have because it works connecting outside cake > > All i want is answers from people who did make the connection , or > experienced ones. Lets try to make a post that will help others > because on the internet is not something well explained. > > Thanks and i`m waiting your posts Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
updateAll gets a Left join sql
hi , when i trie to update a model i get : Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@yahoo.comArray WHERE 1 = 1' at line 1 my model looks like that class User extends AppModel { var $name = 'User'; var $belongsTo = array('Group'); var $hasOne = 'Userinformation'; var $actsAs = array('Acl' => array('requester')); and th edit function : function edit($id = null) { if (empty($this->data)){ $this->User->id = $id; $this->data = $this->User->read(); } else { $this->User->id = $id; if($this->User->updateAll( array('User.email' => $this->data['User']['email']. array('User.id' => $this->User->id)) )){ $this->redirect(array('action'=>'index')); } } } how can o get over the warning? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
controler problem
hi , i need some informations about how cake works, i have 2 models ,2 controls and 2 view pages with a form on both pages , when submit on first page i will go on the second page, i wrote in the controller : $this->redirect('page2controller/actionpage2',null, true); , but it still asks me if i created the function actionpage2 in the page1controller how can i make to use the controller function of second page? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---