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

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: 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

Re: SQL? Why

2007-09-21 Thread deepc
] 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 the data which you want to send in the email in the send() method? I

Re: HABTM Delete only join table

2007-09-06 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

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

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

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