Re: Loop Trigger

2006-04-19 Thread Lucas Vendramin
mysql returns: "Can't update table 't1' in stored function/trigger because it is already used by statement which invoked this stored function/trigger" Why I cant make a trigger that update the some table that invoke the trigger??? How can I build it? Thanks. Lucas Vendr

Loop Trigger

2006-04-19 Thread Lucas Vendramin
t is already used by statement which invoked this stored function/trigger" Why I cant make a trigger that update the some table that invoke the trigger??? How can I build it? Thanks. Lucas Vendramin

Re: Comparing x.x.x.x strings

2006-03-27 Thread Lucas Vendramin
a function that will convert x.x.x.x to an int and then you just put that int into a field in your database and then use the INET_ATON function in MySQL to select the ips you want. SELECT INET_ATON('3.2.0.13') > INET_ATON('3.2.0.2') That should return TRUE. :) Hope that

Comparing x.x.x.x strings

2006-03-24 Thread Lucas Vendramin
Hi all. I have a problem: When I compare two strings in mask (x.x.x.x) the comparation is not true (for my question :D)... look: select '3.2.0.13' > '3.2.0.2'-> FALSE I want this command return TRUE, but it is returning FALSE. But, if I put a space first into the smaller string the ca