Zeoslib Portal

Amazingly I got it all working lol, I started noticing some odd behaviors from some of my jedi components and thought it might be something b0rked within my delphi setup itself. I removed all traces of delphi (except my sources of course, and my cvs) and reinstalled. Everything worked marvelously an...

I tried using stuff like:

ZQuery1.SQL.Text := 'SELECT COUNT(*) FROM `users` WHERE ostatus = "Offline";';

I'll play around with all of that thanks, however I'm having some difficulty getting the return value, it turns out whatever I was doing was going to return 1 no matter what lol. I don't even remember what I had, I had so much tried and commented out I just started the test project over. :oops: I'll...

ZQuery1.SQL.Text := 'SELECT COUNT(*) FROM `users` WHERE ostatus = ("Offline");'; Blah, that was a stupid copy/paste error. it isn't in my code my code is: ZQuery1.SQL.Text := 'SELECT COUNT(*) FROM `users` WHERE ostatus = "Offline";'; I copy/pasted after trying a few things people...

Hi, I'm pretty new to both delphi and MySQL so if this is something retarded ... well sorry. If I run: SELECT COUNT(*) FROM `users` WHERE ostatus = "Offline"; in mysql query browser it works perfectly, but if I try to use: ZQuery1.SQL.Text := 'SELECT COUNT(*) FROM `users` WHERE ostatus = (...