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
