Welcome Guest, Not a member yet? Register   Sign In
Deletes are not allowed unless they contain a "where" or "like" clause.
#4

(This post was last modified: 03-13-2020, 07:01 AM by neuron.)

I am sorry Smile, I don't why I did not have look to your code, before answering.

I never did delete with using QB, so I am not sure your code produces the right SQL code. 
try running

Code:
echo $this->db->get_compiled_delete('eventi_partecipanti_accompagnatori');
and check the SQL code it generates

(03-13-2020, 06:53 AM)neuron Wrote: I am sorry Smile, I don't why I did not have look to your code, before answering.

I never did delete with using QB, so I am not sure your code produces the right SQL code. 
try running

Code:
echo $this->db->get_compiled_delete('eventi_partecipanti_accompagnatori');
and check the SQL code it generates

Also I see you can remove 'left' arguments from you joins, as where clause will eventually filter those NULL fields.
Reply


Messages In This Thread
RE: Deletes are not allowed unless they contain a "where" or "like" clause. - by neuron - 03-13-2020, 06:53 AM



Theme © iAndrew 2016 - Forum software by © MyBB