That's a recent addition, but tinyint wasn't exactly a hindrance or anything. :-)
On Wed, May 16, 2012 at 9:03 AM, Jason King <[email protected]> wrote: > oh wow.. I didn't even realize the bit datatype wasn't a norm in mySQL. > > On Wed, May 16, 2012 at 11:03 AM, Matthew Woodward > <[email protected]>wrote: > >> Yeah you'll find some slight differences like that. >> >> And I see they added a bit datatype to MySQL as of 5.0.3. Nice! No more >> using enumerators or tinyint instead. >> >> On Wed, May 16, 2012 at 9:00 AM, Jason King <[email protected]>wrote: >> >>> Woohoo! Yea, it's working. I was able to insert and select some data. >>> >>> in my MS-SQL based sql code, I was able to simply insert values of '0' >>> and '1' for a bit data type. I could also use cfqueryparam without defining >>> a bit type. >>> >>> Using mySQL, it was throwing an error if I didn't define the 'type' in >>> cfqueryparam. So I just had to add type="cf_sql_bit" to the cfqueryparam to >>> get it to work. >>> >>> >>> >>> >>> >>> On Wed, May 16, 2012 at 10:03 AM, Jason King <[email protected]>wrote: >>> >>>> Yea, it makes sense to me now since mySQL isn't a Microsoft product. IP >>>> is fine with since it's straight to the point and doesn't require any >>>> further resolution. >>>> >>>> >>>> >>>> On Wed, May 16, 2012 at 10:02 AM, Matthew Woodward < >>>> [email protected]> wrote: >>>> >>>>> DNS works too, you just might have to add an entry to your hosts file >>>>> on the OpenBD machine if there's no "real" dns entry (either externally or >>>>> on your internal dns if you have any) to the machine. >>>>> >>>>> AFAIK netbios doesn't mean anything to anything but windows. >>>>> >>>>> On Wed, May 16, 2012 at 7:47 AM, Jason King <[email protected]>wrote: >>>>> >>>>>> Ok, well I think I figured it out. >>>>>> >>>>>> For ServerName, I was putting the NetBios name I gave the computer.. >>>>>> It works for the MS SQL driver.. >>>>>> >>>>>> I used the server's IP instead and it worked. >>>>>> >>>>>> -- >>>>>> online documentation: http://openbd.org/manual/ >>>>>> google+ hints/tips: https://plus.google.com/115990347459711259462 >>>>>> http://groups.google.com/group/openbd?hl=en >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Matthew Woodward >>>>> [email protected] >>>>> >>>>> http://blog.mattwoodward.com >>>>> identi.ca / Twitter: @mpwoodward >>>>> >>>>> Please do not send me proprietary file formats such as Word, >>>>> PowerPoint, etc. as attachments. >>>>> http://www.gnu.org/philosophy/no-word-attachments.html >>>>> >>>>> -- >>>>> online documentation: http://openbd.org/manual/ >>>>> google+ hints/tips: https://plus.google.com/115990347459711259462 >>>>> http://groups.google.com/group/openbd?hl=en >>>>> >>>> >>>> >>> -- >>> online documentation: http://openbd.org/manual/ >>> google+ hints/tips: https://plus.google.com/115990347459711259462 >>> http://groups.google.com/group/openbd?hl=en >>> >> >> >> >> -- >> Matthew Woodward >> [email protected] >> http://blog.mattwoodward.com >> identi.ca / Twitter: @mpwoodward >> >> Please do not send me proprietary file formats such as Word, PowerPoint, >> etc. as attachments. >> http://www.gnu.org/philosophy/no-word-attachments.html >> >> -- >> online documentation: http://openbd.org/manual/ >> google+ hints/tips: https://plus.google.com/115990347459711259462 >> http://groups.google.com/group/openbd?hl=en >> > > -- > online documentation: http://openbd.org/manual/ > google+ hints/tips: https://plus.google.com/115990347459711259462 > http://groups.google.com/group/openbd?hl=en > -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
