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
