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
