EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   mysql use of AND statement question (https://www.eqemulator.org/forums/showthread.php?t=22156)

lolzownz 12-23-2006 08:07 AM

mysql use of AND statement question
 
I'm using Diablo like loot maker ver 1.3.2 from http://66.159.225.58/eqemu/eq.html and I

RangerDown 12-23-2006 01:00 PM

Check to see if it's a known bug for the version of mysql you're using. (mysql forums or googling might get you that answer) I have been witness to a bug in mysql's logic once before so it's not totally out of the question that this is just a bug too.

GeorgeS 12-24-2006 07:06 AM

I looked at this in more detail - using AND's and OR's...

I added brackets when using OR's so they take precedence over AND's. I added this to the recent code and it's available for download now.

Thanks for pointing this out.

btw - when using sql using or's and and's use
(a=1 OR a=2) AND b=3 AND b=4

GeorgeS


All times are GMT -4. The time now is 06:24 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.