I thought this was the DSN being changed, not the database itself. I was
thinking this would be a cf adminObj thing, like this code I use to create the
DBs now:
<cfscript>
// Login is always required. This example uses two lines of code.
adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login("#request.app.cfadmin#");
// Instantiate the data source object.
dbObj = createObject("component","cfide.adminapi.datasource");
// Create a DSN.
dbObj.setMSSQL(
driver="MSSQLServer",
name="#theDBName#",
host = "localhost",
port = "1433",
selectmethod = "cursor",
database = "#theDBName#",
username = "#theUName#",
password = "#thePWord#"
);
adminObj.logout();
</cfscript>
I have already updated all the existing databases. Now I want to make sure all
future databases created with this script have the right settings.
Mik
At 03:43 PM 2/12/2009, you wrote:
>Sure, it's scriptable. Google "sql alter table" and the particular
>platform of DB you are using.
>
>Thanks,
>Mike
>
>-----Original Message-----
>From: Mik Muller [mailto:[email protected]]
>Sent: Thursday, February 12, 2009 2:08 PM
>To: cf-talk
>Subject: Re: form post getting cut off at 32,000
>
>
>Yes, that was it. I had Long Text Buffer (chr) set to 64000 and the
>CLOB checkbox off.
>
>I suppose that the field being "ntext" cut the 64000 in half to 32000.
>Perhaps I should change the field to just "text".
>
>Now to update a few dozen databases. Sigh. Anyone know how to script
>that kind of change? Is that even possible?
>
>Thanks to everyone for writing back.
>
>Mik
>
>
>At 02:42 PM 2/12/2009, Matthew Williams wrote:
>
>>Yeah... this just bit me too. You need to adjust either your clob/blob
>
>>size for the DSN. The default cuts off at 32k. Even if the clob/blob
>>options are not checked, that seems to be the cutoff. I'm reasonably
>>sure that clob is the one you're looking to change.
>>
>>Matthew Williams
>>Geodesic GraFX
>
>--------
>Michael Muller
>Admin, MontagueMA.net Website
>office (413) 863-6455
>mobile (413) 320-5336
>skype: michaelBmuller
>http://www.MontagueMA.net
>
>Eschew Obfuscation
>
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319253
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
