Thank for the link. You make a good point. I think I'll stick with the 1 and 0 like I use in MS SQL though. That way if I move the code to a different server with MS SQL, I can just change the database table, not the rest of the code.
===== Russel Madere Senior Software Engineer Turbo Squid, Inc. http://www.turbosquid.com Is your head tag nested within your body tag? > -----Original Message----- > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 12, 2002 10:06 AM > To: CF-Community > Subject: RE: MySQL help needed > > > > Sorry for the technical post but I need some help with > > creating a table in > > MySQL. Does anyone know if there is an equivilent datatype > > to the MS SQL > > bit data type? I need to store true or false data in my database. > > http://www.onlamp.com/pub/a/onlamp/2001/09/13/aboutSQL.html > > mySQL doesn't have a boolean data type > > Why not use one character and just put "Y" or "N" into it? > > Philip Arnold > Technical Director > Certified ColdFusion Developer > ASP Multimedia Limited > T: +44 (0)20 8680 1133 > F: +44 (0)20 8686 7911 > > An ISO9001 registered company. > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > ********************************************************************** > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
