SELECT vs SET for creating variables

2005-08-10 Thread Bill Dodson
enter, CONCAT(@neededStep, ' <= ', @startOfCenter), CONCAT(@neededStep, ' > ', @startOfCenter) ); It would seem that SET is a better way to create variables from constant values, but I would like to understand why. Does anybody know what is happening here? Thanks for y

Re: Hijackers?

2005-12-13 Thread Bill Dodson
me fields I also use the HTML conversion functions to convert " to " etc. I found this helpful: http://www.unixwiz.net/techtips/sql-injection.html -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113 x149 fax: 304-586-3842 email: [EMAIL PROTECTED] Email Disc

Re: temporary table issue

2006-01-10 Thread Bill Dodson
anks in advance. Xiaobo -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113 x149 fax: 304-586-3842 email: [EMAIL PROTECTED] Email Disclaimer The information in any email is confidential and may be legally privileged. It is intended solely for the addressee. Access to the e

Re: Converting decimal to binary

2006-01-10 Thread Bill Dodson
inary and have the result be returned as a separate field for each bit? For example, what I'd like to do is, Select ConvertToBin(245); And have a result that looked like this +---+---+---+---+---+---+---+---+ | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | +---+---+---+---+---+---+---+---+ | 1 | 1 | 1 | 1 |

the new Connector J

2005-03-09 Thread Bill Dodson
First off, sorry if this is going to the wrong list. I installed the new Connector J (mysql-connector-java-3.1.7-bin.jar). Now some of my code does not work. It seems that when I do a ResultSet.getObject() on a Date field with the value -00-00 (the default value) I get an SQLException. Whi