On 07.02.2001 10:30:15 russ wrote: > Many thanks to all for the help on this issue. > I've come to the conclusion the simplest way for me to implement this is to use > the ENUM type with two possible values 'True' and 'False'. > I will convert the VB BOOLEAN type to a string before I enter it. > > Thankfully when returning a value from mySQL, ASP detects the string is "True" > and it evaluates succesfully ("true" = True) As I said - dunno about ASP, but if it is like in PHP, "true" evaluates to TRUE, because it is a non-empty string. IOW: In PHP everything that is not empty or not zero ("yes", "true", "this sentence also evaluates to true", "false", "no", "worng", 42, -1) is TRUE; or the other way around, just blank or zero is FALSE ("", 0, or a unset variable). Maybe it's the same in ASP? Please try and tell me, I'd be a little bit interested to know... --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php