Wrong result with sql query

2010-07-13 Thread deepc
I have a sql query that works when i run it in phpmyadmin: $result = $this->ImportBackup->query("DELETE t1 FROM import_backups t1, backups t2 WHERE t1.name=t2.name AND t1.drive_id=t2.drive_id;"); This line should delete every record, where name and drive_id are identival. It works as long as the

How to create a link in a component

2007-09-27 Thread deepc
Hello, i need to create a link to a controller for sending by email in a component. how can i do it? Is there a var where the url of the site is provided? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" g

Re: SQL? Why

2007-09-21 Thread deepc
AIL PROTECTED]> wrote: > On 9/21/07, deepc <[EMAIL PROTECTED]> wrote: > > > OK, i see. > > if i move it to the model, is it still posible to access other models. > > for example i have to get some data from my users table. > > let me guess - you are getting t

Re: SQL? Why

2007-09-21 Thread deepc
OK, i see. if i move it to the model, is it still posible to access other models. for example i have to get some data from my users table. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to

SQL? Why

2007-09-21 Thread deepc
Hello, I have following models: Email Message and controllers emails_controller messages_controller In my emails_controller is a function send() which should handle what type of email should be send. If i call it from messags $this->Email->send(); i got: Warning: SQL Error: 1064: You have

Re: HABTM Delete only join table

2007-09-05 Thread deepc
Thanks, looks good. is it possible to use it with cake 1.1? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this g

HABTM Delete only join table

2007-09-05 Thread deepc
Hello, i have a table abos and a table categories connected with habtm. is it possible to delete only the content of the join table without deleting an abo or category? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

Re: habtm with different roles

2007-08-26 Thread deepc
you are right, it's better this way. Thanks. But i still haven'f found out how to define the 2 assocs I tried with two belongsTo, but i only get the last one (in that case recipient). Is it posible to do them both? --~--~-~--~~~---~--~~ You received this message b

habtm with different roles

2007-08-21 Thread deepc
A question to habtm. I have an object message and user A message could be a sent or an received message and belongs to an user. Is it possible to model such different roles between the same object in cake? --~--~-~--~~~---~--~~ You received this message because yo