Re: BlueDragon 7 problem with Text datatype

2007-09-02 Thread Pete Ruckelshaus
In the free version of BD, there are no BD-specific DSN settings, since the DSN's need to be set at the OS level. I realized, however, that I was using cfqueryparam in that query; I always use cfqueryparam for a number of very valid reasons. When I changed that cfqueryparam cfsqltype value from

BlueDragon 7 problem with Text datatype

2007-09-01 Thread Pete Ruckelshaus
I have a CFMX7 application that I am trying to get to work with BlueDragon Server 7 (the free edition for now). Server is running Windows 2003 Server with IIS. Database is MS SQL Server 2005 Standard Edition. With the exception of one very important issue, everything's working pretty well. The

Re: BlueDragon 7 problem with Text datatype

2007-09-01 Thread Paul Hastings
Pete Ruckelshaus wrote: With a smaller chunk of text, both insert and update queries work just fine. does BD have an enable CLOB option and/or Long Text Buffer (chr) size in it's dsn admin bits? if so turn those on and/or increase the size. also wondering about the ODBC driver you're using,