RE: UPS - XML Rates: Connection Failure

[Adrian Lynch]

Test another URL to check it's not a network problem.

Adrian

> -Original Message-
> From: Deanna Schwint [mailto:dea...@vimm.com]
> Sent: 13 February 2009 04:15
> To: cf-talk
> Subject: UPS - XML Rates: Connection Failure
> 
> 
> In the past two days, I have encountered a connection error on a
> production server with the following cfhttp call:
> 
> CFHTTP URL="https://www.ups.com/ups.app/xml/Rate"; METHOD="Post"
> RESOLVEURL="false" TIMEOUT="#attributes.timeout#">
>   
> /CFHTTP>
> 
> 
> 
> It works fine on the development server but I receive a 'Connection
> Failure' response each time I try on the production server.
> 
> Any suggestions for troubleshooting??? Thanks in advance!


~|
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:319268
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: (ot) Setting IIS 6 Content-Type HTTP header

[Azadi Saryev]

it's under "Mime Types", not "File Types"...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Jim McAtee wrote:
> Thanks, but it appears to be completely wrong for IIS 6.  There is no 
> "HTTP Headers" => "File Types..." that I can see. 
>
>
>   

~|
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:319267
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfdocument pdf generation

[Daniel .]

thanks everyone

I will look into that 

~|
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:319266
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

UPS - XML Rates: Connection Failure

[Deanna Schwint]

In the past two days, I have encountered a connection error on a production 
server with the following cfhttp call:

CFHTTP URL="https://www.ups.com/ups.app/xml/Rate"; METHOD="Post" 
RESOLVEURL="false" TIMEOUT="#attributes.timeout#">
 
/CFHTTP>



It works fine on the development server but I receive a 'Connection Failure' 
response each time I try on the production server.

Any suggestions for troubleshooting??? Thanks in advance! 

~|
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:319265
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfdocument pdf generation

[Paul Hastings]

Daniel wrote:
> the real question: can I update iText with a more recent version ? if so,

sure but cfdocument will probably stop working (though give it a try).

> implementation, is there a easy way to convert html to pdf using an external
> iText implementation called by CreateObject ?

it will be harder for sure (you can't really appreciate what cfdocument does 
for 
you until you try to do it yourself) but certainly possible (iText is what many 
of us have been using pre-cfdocument & still do for some requirements). you'll 
have to use mark's javaloader to get at the iText jar as the cf one will still 
load ahead of your version (or i guess you could refactor it). these days the 
mysterious cfsearching is probably the best iText & cf resource:

http://cfsearching.blogspot.com/search/label/iText


there's also some stuff scattered around the cf forums:

http://www.adobe.com/cfusion/webforums/forum/index.cfm?forumid=1


if you do go w/"low-level" iText buy bruno's book, worth every penny i paid for 
it:

http://www.manning.com/lowagie/


~|
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:319264
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfdocument pdf generation

[James Holmes]

You can very likely use JavaLoader to load into CF any version of
iText you need and instantiate it with createObject().

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/


2009/2/13 Daniel :
>
> I have a tough question.
>
> I am trying to use cfdocument to generate a huge PDF file with 5000+ images
>
> after failing (even with CF64bits and 8GB of RAM), I was analyzing the PDF
> generated by iText (the lib used by coldfusion), and it seams every image
> included in the PDF is using the FlateDecode encoding, instead of the
> DCTDecode for jpeg images
>
> with the FlateDecode, images get 10x bigger, as FlateDecode is a zlib
> compression
>
> also, iText tries to use the memory buffer for the cache of the document
>
> The only way to this document generation to be feasable is if I can change
> iText to use DCTDecode on the images, and use a disk based buffer instead of
> a memory based buffer
>
> the real question: can I update iText with a more recent version ? if so,
> does this fix this issue? If I can't update the internal iText
> implementation, is there a easy way to convert html to pdf using an external
> iText implementation called by CreateObject ?
>
> answers suggesting me to use something else than coldfusion won't be very
> helpful, since I already know that, but I want to use coldfusion to generate
> those PDFs Comparing with other PHP and ASP.NET  based
> solutions, coldfusion pdf generation is bloated and slow and I am trying to
> fix that

~|
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:319263
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: More SQL Profiler questions

[brad]

I need to partially retract part of my comment below.  The
master.dbo.syscacheobjects table is not specific to any one instance of
a prepared statement (prepared statements are specific to a connection).
 While prepared statements WILL make use of the compiled execution plans
found in that table, the objid does not correspond with the prepared
statement's handle.  The connection-specific handle (integer) is
returned by sp_prepexec and as far as I can tell is only stored in
memory, not any system tables.  Note: from what I can tell, two
different connections to the database both with two different prepared
statements, could both be sharing the execution plan found in
syscacheobjects.

~Brad

 Original Message 
Subject: Re: More SQL Profiler questions
From: Brad Wood 
Date: Thu, February 12, 2009 4:43 pm
To: cf-talk 


The objid column should correspond with the id you see in your trace.



~|
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:319262
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: HTML email appearing blank in thunderbird

[Cutter (CFRelated)]

Is it well formed html? Opening and closing html, head, and body tags? 
I've found if the doc is incomplete it won't display in Thunderbird.

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of "Learning Ext JS"
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com

Mike Little wrote:
> hi guys,
> 
> sending out an html email using cfmail, working fine for apple mail, outlook, 
> hotmail, gmail - but appears completely blank for mozilla thunderbird clients.
> 
> has anyone else struck this?
> 
> mike 
> 
> 

~|
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:319261
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfdocument pdf generation

[Daniel]

I have a tough question.

I am trying to use cfdocument to generate a huge PDF file with 5000+ images

after failing (even with CF64bits and 8GB of RAM), I was analyzing the PDF
generated by iText (the lib used by coldfusion), and it seams every image
included in the PDF is using the FlateDecode encoding, instead of the
DCTDecode for jpeg images

with the FlateDecode, images get 10x bigger, as FlateDecode is a zlib
compression

also, iText tries to use the memory buffer for the cache of the document

The only way to this document generation to be feasable is if I can change
iText to use DCTDecode on the images, and use a disk based buffer instead of
a memory based buffer

the real question: can I update iText with a more recent version ? if so,
does this fix this issue? If I can't update the internal iText
implementation, is there a easy way to convert html to pdf using an external
iText implementation called by CreateObject ?

answers suggesting me to use something else than coldfusion won't be very
helpful, since I already know that, but I want to use coldfusion to generate
those PDFs Comparing with other PHP and ASP.NET  based
solutions, coldfusion pdf generation is bloated and slow and I am trying to
fix that


~|
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:319260
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

HTML email appearing blank in thunderbird

[Mike Little]

hi guys,

sending out an html email using cfmail, working fine for apple mail, outlook, 
hotmail, gmail - but appears completely blank for mozilla thunderbird clients.

has anyone else struck this?

mike 

~|
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:319259
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: More SQL Profiler questions

[Brad Wood]

>In case anyone else comes across this via google...
>
>Once a query is compiled with sp_prepare, it is stored in a system
>table however only the first 128 characters of the SQL are stored in a
>visible form in SQL 2000

To be more specific, the name of the table in question is 
master.dbo.syscacheobjects.
This select will give you a list of all the cached prepared statements:
select c.*
from master.dbo.syscacheobjects c
inner join master.dbo.sysdatabases d on c.dbid = d.dbid
where objtype = 'Prepared'
and cacheobjtype = 'Compiled Plan'
and d.name = 'database_name'

The objid column should correspond with the id you see in your trace.

Looking at this table and ordering by usecounts can actually give you a pretty 
good feel for the cached plans which are getting used the most.

Also, the docs say 128 charactesrs, but I'm looking at the contents of this 
table on a sql server 2000 database and I'm getting WAY more than 128 chars.  
The longest sql entry in the table is 3,900 characters long so I'm not sure how 
the 128 character thing comes into play.  
http://msdn.microsoft.com/en-us/library/aa260394(SQL.80).aspx 

~|
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:319258
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: (ot) Setting IIS 6 Content-Type HTTP header

[Robbie Byrd]

The only thing I was able to find was in IIS's metabase... The 
HttpCustomHeaders property.

http://technet.microsoft.com/en-us/library/cc784298.aspx

But when it gets into editing the metabase, I got no clue. :)

Although in IIS, if you right click on a site and go to HTTP Headers, there's a 
section to add/edit Custom HTTP Headers there... Would that be the same thing? 

>>> Does anyone know how to redifine the Content-Type HTTP header that is 
>
>
>Thanks, but it appears to be completely wrong for IIS 6.  There is no 
>"HTTP Headers" => "File Types..." that I can see. 

~|
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:319257
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Binary output in CFContent ?

[Robbie Byrd]

Do you even need the HTML at all? I bet that's what is causing the problem. If 
you're sending a binary file straight to the browser, the HTML won't do any 
good, and is probably causing ColdFusion to override your cfheader tag.

Correct me if I'm wrong, but I'd try it just like this:




-Robbie

>Hi
>
>I am using the following code to display a word document, but in the
>browser all that is displayed is binary code?
>
>snippet
>Untitled Document
>value="attachment;filename=testdoc.doc">
>
>
>
>
>file="#ExpandPath(".")#\testdoc.doc" deletefile="yes">
>
>--
>Any ideas on why this is happening, I am using CFMX 7 on Windows 

~|
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:319256
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Setting row colors dynamically with cfgrid AJAX

[Robbie Byrd]

Hi there,

I'm pulling my hair out trying to figure out how to set a row color based on a 
CFC returning either a specific CSS class. I'm not a big javascript guy, and 
I've found on the Ext forums how to set row colors using an override, but I'm 
not exactly sure where to place the code.

Anyone else have any experience with this?

Thanks!

-Robbie 

~|
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:319255
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: form post getting cut off at 32,000

[Jason Fisher]

A bit OT, but I would strongly recommend NOT changing to "text".  If you ever 
have an entry expecting a Unicode character outside of the low/high ASCII 
(0-255 character entries), text will foobar it for you but ntext will handle 
correctly.



~|
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:319254
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: form post getting cut off at 32,000

[Mik Muller]

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:



// 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();



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:ad...@montaguema.net] 
>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

RE: form post getting cut off at 32,000

[Dawson, Michael]

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:ad...@montaguema.net] 
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:319252
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: form post getting cut off at 32,000

[Mik Muller]

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:319251
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Hosts

[Charlie Griefer]

hey, it's cool that you did.  especially since you work for the
"competition" :)
I was just pointing out the ads... altho I'm not sure if the ads are present
in the 'development' setup they also offer.  either way, wanted the OP to be
aware of the potential gotcha.

On Thu, Feb 12, 2009 at 11:44 AM, Jordan Michaels wrote:

>
> Well, if it's just a preview, it might be alright. I suppose it's up to
> the original poster eh? Just throwing the suggestion out there. ;)
>
> Warm regards,
> Jordan Michaels
> Vivio Technologies
> http://www.viviotech.net/
> Open BlueDragon Steering Committee
> Adobe Solution Provider
>
>
> Charlie Griefer wrote:
> > was under the impression they put ads on the sites...
> > if he's looking to show a "finished product" to a client, the client may
> not
> > want to see ads :)
> >
> > On Thu, Feb 12, 2009 at 9:07 AM, Jordan Michaels  >wrote:
> >
> >> How about free?
> >>
> >> http://www.freecoldfusionhosting.com/
> >>
> >> They offer a sandbox environment specifically for testing like what
> >> you're wanting to do, and offer a MS SQL Server database.
> >>
> >> HTH!
> >>
> >> Warm regards,
> >> Jordan Michaels
> >> Vivio Technologies
> >> http://www.viviotech.net/
> >> Open BlueDragon Steering Committee
> >> Adobe Solution Provider
> >>
> >>
> >> Robert Bailey wrote:
> >>> I am trying to find a decent CF8 hosting company that offers SQL
> Server.
> >>> The company I am working with now (remotely) does not have a dev
> server,
> >>> so I am looking for something that is going to have very little
> traffic,
> >>> simply just allowing him to review. No email is needed, etc
> >>>
> >>> Thanks!
> >>>
> >>>
> >>
> >
> >
>
> 

~|
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:319250
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: form post getting cut off at 32,000

[Matthew Williams]

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

~|
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:319249
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion Hosts

[Jordan Michaels]

Well, if it's just a preview, it might be alright. I suppose it's up to 
the original poster eh? Just throwing the suggestion out there. ;)

Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Open BlueDragon Steering Committee
Adobe Solution Provider


Charlie Griefer wrote:
> was under the impression they put ads on the sites...
> if he's looking to show a "finished product" to a client, the client may not
> want to see ads :)
> 
> On Thu, Feb 12, 2009 at 9:07 AM, Jordan Michaels wrote:
> 
>> How about free?
>>
>> http://www.freecoldfusionhosting.com/
>>
>> They offer a sandbox environment specifically for testing like what
>> you're wanting to do, and offer a MS SQL Server database.
>>
>> HTH!
>>
>> Warm regards,
>> Jordan Michaels
>> Vivio Technologies
>> http://www.viviotech.net/
>> Open BlueDragon Steering Committee
>> Adobe Solution Provider
>>
>>
>> Robert Bailey wrote:
>>> I am trying to find a decent CF8 hosting company that offers SQL Server.
>>> The company I am working with now (remotely) does not have a dev server,
>>> so I am looking for something that is going to have very little traffic,
>>> simply just allowing him to review. No email is needed, etc
>>>
>>> Thanks!
>>>
>>>
>>
> 
> 

~|
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:319248
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: form post getting cut off at 32,000

[Azadi Saryev]

what's the setting for Long Text Buffer in Advanced Settings for your
dsn in cf admin? do you have clob/blob retrieval enabled there as well?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mik Muller wrote:
> Hey all,
>
> Bizarre. I have a message board application and a new user is posting 130,000 
> character long newsletter-like posts that are getting cut off at 31,999 
> characters in the database, but not in the email that is sent after the sql 
> insert.
>
>
> o There are only two text fields being posted in the form, one is a title 
> (only 50 chars or so) and the other is called form.message coming from a 
> textarea. I'm not using a wysiwyg editor.
>
> o The db field "message" is an ntext of size 2,147,483,646, which should be 
> enough.
>
> o The CF Admin setting "Maximum size of post data" is set to 100 MB
>
> o I'm using this to insert the form data:   cfsqltype="CF_SQL_LONGVARCHAR" value="#form.message#">
>
> o While debugging I added the maxlength attribute and set it to "99". No 
> change.
>
> o I'm using SQL Server and CF8
>
> o The email that is generated after the insert contains the whole text, so 
> the stripping must not be happening in the form post, but in the database 
> insert itself.
>
>
> What am I missing here?
>
> Thanks,
>
> Mik
>
>
>
>
> 
> 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:319247
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Hosts

[Mik Muller]

I have three CF servers with Enterhost. The price is right for collecting all 
your work onto one box and setting up as many dev sites as you need. Comes w/ 
SQL Server and all the SmarterTools you could want.

They also have decent individual site packages.

Mik


At 10:47 PM 2/11/2009, you wrote:

>I am trying to find a decent CF8 hosting company that offers SQL Server.
>The company I am working with now (remotely) does not have a dev server, 
>so I am looking for something that is going to have very little traffic, 
>simply just allowing him to review. No email is needed, etc


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:319246
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: form post getting cut off at 32,000

[Barney Boisvert]

My guess is you need to go change the buffer size in the DSN settings
in the CF Admin.

cheers,
barneyb

On Thu, Feb 12, 2009 at 11:07 AM, Mik Muller  wrote:
>
> Hey all,
>
> Bizarre. I have a message board application and a new user is posting 130,000 
> character long newsletter-like posts that are getting cut off at 31,999 
> characters in the database, but not in the email that is sent after the sql 
> insert.
>
>
> o There are only two text fields being posted in the form, one is a title 
> (only 50 chars or so) and the other is called form.message coming from a 
> textarea. I'm not using a wysiwyg editor.
>
> o The db field "message" is an ntext of size 2,147,483,646, which should be 
> enough.
>
> o The CF Admin setting "Maximum size of post data" is set to 100 MB
>
> o I'm using this to insert the form data:   cfsqltype="CF_SQL_LONGVARCHAR" value="#form.message#">
>
> o While debugging I added the maxlength attribute and set it to "99". No 
> change.
>
> o I'm using SQL Server and CF8
>
> o The email that is generated after the insert contains the whole text, so 
> the stripping must not be happening in the form post, but in the database 
> insert itself.
>
>
> What am I missing here?
>
> Thanks,
>
> Mik
>
>
>
>
> 
> 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:319245
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

form post getting cut off at 32,000

[Mik Muller]

Hey all,

Bizarre. I have a message board application and a new user is posting 130,000 
character long newsletter-like posts that are getting cut off at 31,999 
characters in the database, but not in the email that is sent after the sql 
insert.


o There are only two text fields being posted in the form, one is a title (only 
50 chars or so) and the other is called form.message coming from a textarea. 
I'm not using a wysiwyg editor.

o The db field "message" is an ntext of size 2,147,483,646, which should be 
enough.

o The CF Admin setting "Maximum size of post data" is set to 100 MB

o I'm using this to insert the form data:  

o While debugging I added the maxlength attribute and set it to "99". No 
change.

o I'm using SQL Server and CF8

o The email that is generated after the insert contains the whole text, so the 
stripping must not be happening in the form post, but in the database insert 
itself.


What am I missing here?

Thanks,

Mik





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:319244
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Hosts

[Gerald Guido]

If you have a high speed connection you can always poke a hole in your
routers fire wall, forward the port to your dev box and host it at home. If
you do it that way you can use use Dynamic DNS in lieu of an IP
(dyndns.orgis good). Most routers I have seen lately have a Dynamic
DNS update client
built in.

HTH

G!

On Wed, Feb 11, 2009 at 10:47 PM, Robert Bailey wrote:

>
> I am trying to find a decent CF8 hosting company that offers SQL Server.
> The company I am working with now (remotely) does not have a dev server,
> so I am looking for something that is going to have very little traffic,
> simply just allowing him to review. No email is needed, etc
>
> Thanks!
>
> 

~|
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:319243
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Hosts

[Gerald Guido]

Opps... misread the OP... never mind.


>
> On Wed, Feb 11, 2009 at 10:47 PM, Robert Bailey 
> wrote:
>
>>
>> I am trying to find a decent CF8 hosting company that offers SQL Server.
>> The company I am working with now (remotely) does not have a dev server,
>> so I am looking for something that is going to have very little traffic,
>> simply just allowing him to review. No email is needed, etc
>>
>> Thanks!
>>
>> 

~|
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:319242
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Coldfusion Scrolling Text

[Adrian Lynch]

If it doesn't need to get the news anew, change the static text to dynamic:

var news = ["News", "More news", "Some more news", "No more news"];

becomes:

var news = [#QuotedValueList(myNewQuery.title)#];

That should do it.

Adrian

> -Original Message-
> From: Anthony Doherty [mailto:a.dohe...@advancesystems.co.uk]
> Sent: 12 February 2009 17:08
> To: cf-talk
> Subject: Coldfusion Scrolling Text
> 
> 
> Hi i was wondering if anyone could help me!
> 
> im trying to create a scrolling news section on our home page, the code
> needs to read the news headline from the database though and it will
> vertically move the news items up and if the user clicks on an item it
> will take them to the detail page.  when the scroller is finished it
> would need to start automatically.
> 
> i seem to find ones that are all static text within the javascript
> function.
> 
> Thanks in advance
> 
> 

~|
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:319241
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Hosts

[Charlie Griefer]

was under the impression they put ads on the sites...
if he's looking to show a "finished product" to a client, the client may not
want to see ads :)

On Thu, Feb 12, 2009 at 9:07 AM, Jordan Michaels wrote:

>
> How about free?
>
> http://www.freecoldfusionhosting.com/
>
> They offer a sandbox environment specifically for testing like what
> you're wanting to do, and offer a MS SQL Server database.
>
> HTH!
>
> Warm regards,
> Jordan Michaels
> Vivio Technologies
> http://www.viviotech.net/
> Open BlueDragon Steering Committee
> Adobe Solution Provider
>
>
> Robert Bailey wrote:
> > I am trying to find a decent CF8 hosting company that offers SQL Server.
> > The company I am working with now (remotely) does not have a dev server,
> > so I am looking for something that is going to have very little traffic,
> > simply just allowing him to review. No email is needed, etc
> >
> > Thanks!
> >
> >
>
> 

~|
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:319240
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Coldfusion Scrolling Text

[Anthony Doherty]

Hi i was wondering if anyone could help me!

im trying to create a scrolling news section on our home page, the code needs 
to read the news headline from the database though and it will vertically move 
the news items up and if the user clicks on an item it will take them to the 
detail page.  when the scroller is finished it would need to start 
automatically.

i seem to find ones that are all static text within the javascript function.

Thanks in advance 

~|
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:319239
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Hosts

[Jordan Michaels]

How about free?

http://www.freecoldfusionhosting.com/

They offer a sandbox environment specifically for testing like what 
you're wanting to do, and offer a MS SQL Server database.

HTH!

Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Open BlueDragon Steering Committee
Adobe Solution Provider


Robert Bailey wrote:
> I am trying to find a decent CF8 hosting company that offers SQL Server.
> The company I am working with now (remotely) does not have a dev server, 
> so I am looking for something that is going to have very little traffic, 
> simply just allowing him to review. No email is needed, etc
> 
> Thanks!
> 
> 

~|
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:319238
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: (ot) More SQL Profiler questions

[Gaulin, Mark]

Hi Gert 
Getting the SQL from the front-end side is nice, but not sufficient for 
profiling.
The trick is getting the original query text through the JDBC layer and into 
SQL Server, where the profiler can see it.  I was thinking that maybe SQL could 
be captured as a comment, along with the "exec sp_execute 162, 5909, 1973" 
stuff.

Thanks
Mark

-Original Message-
From: Gert Franz [mailto:gert.fr...@railo.ch] 
Sent: Thursday, February 12, 2009 10:58 AM
To: cf-talk
Subject: AW: (ot) More SQL Profiler questions


Well in Railo in the debugging info you always get the queries without any 
Questionmarks... Even if you use CFQUERYPARAM.

Gert

-Ursprüngliche Nachricht-
Von: Gaulin, Mark [mailto:mgau...@globalspec.com]
Gesendet: Donnerstag, 12. Februar 2009 15:26
An: cf-talk
Betreff: RE: (ot) More SQL Profiler questions


...and now you know why I don't like cfqueryparam...

As far as I can tell there is no way for you to translate that "162"
into the actual sql that it corresponds to since the id "162" is
specific to the database connection. (You can look around at prepared
statements by querying syscacheobjects, but it will hard to know for
sure which item it is. Check out
http://www.megasolutions.net/Sqlserver/How-can-I-find-out-what-command-s
p_execute-is-running-(without-using-Profiler)-1687.aspx for more ideas.)

I've submitted several ideas for enhancements to Adobe/macromedia on how
they could help this situation, for whatever good that has done. (None,
I suppose.)  

Thanks
Mark

-Original Message-
From: Rick Root [mailto:rick.r...@webworksllc.com] 
Sent: Wednesday, February 11, 2009 5:57 PM
To: cf-talk
Subject: (ot) More SQL Profiler questions


Alright so now that I'm back to using the regular SQL Server JDBC
driver, my queries are flying.  Most of them.  Problem is, there are
some that don't.

Watching in SQL Provider, all I see is stuff like this:

exec sp_execute 162, 5909, 1973

That took 956ms of cpu... did over 180,000 reads, and took nearly 10
seconds to run.

And I have NO idea what the query is or how to find out what it was.
I wasn't running the trace when the statement was prepared so all I know
is that the "ID" of the prepared statement is "162"

Anyone dealt with this before?

--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark







~|
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:319237
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Maybe I need a SQL Service Consultant...

[Brad Wood]

> resolving the way my database driver was configured
> helped clear up a lot of problems by reducing the # of reads we were
> doing.

@Rick, can you provide any specifics on the above change?  What did he 
change?  How did it reduce reads?

Thanks.

~Brad 


~|
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:319236
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Binary output in CFContent ?

[Ian Vaughan]

Hi

I am using the following code to display a word document, but in the
browser all that is displayed is binary code?

snippet
Untitled Document







--
Any ideas on why this is happening, I am using CFMX 7 on Windows



~|
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:319235
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

AW: (ot) More SQL Profiler questions

[Gert Franz]

Well in Railo in the debugging info you always get the queries without any
Questionmarks... Even if you use CFQUERYPARAM.

Gert

-Ursprüngliche Nachricht-
Von: Gaulin, Mark [mailto:mgau...@globalspec.com] 
Gesendet: Donnerstag, 12. Februar 2009 15:26
An: cf-talk
Betreff: RE: (ot) More SQL Profiler questions


...and now you know why I don't like cfqueryparam...

As far as I can tell there is no way for you to translate that "162"
into the actual sql that it corresponds to since the id "162" is
specific to the database connection. (You can look around at prepared
statements by querying syscacheobjects, but it will hard to know for
sure which item it is. Check out
http://www.megasolutions.net/Sqlserver/How-can-I-find-out-what-command-s
p_execute-is-running-(without-using-Profiler)-1687.aspx for more ideas.)

I've submitted several ideas for enhancements to Adobe/macromedia on how
they could help this situation, for whatever good that has done. (None,
I suppose.)  

Thanks
Mark

-Original Message-
From: Rick Root [mailto:rick.r...@webworksllc.com] 
Sent: Wednesday, February 11, 2009 5:57 PM
To: cf-talk
Subject: (ot) More SQL Profiler questions


Alright so now that I'm back to using the regular SQL Server JDBC
driver, my queries are flying.  Most of them.  Problem is, there are
some that don't.

Watching in SQL Provider, all I see is stuff like this:

exec sp_execute 162, 5909, 1973

That took 956ms of cpu... did over 180,000 reads, and took nearly 10
seconds to run.

And I have NO idea what the query is or how to find out what it was.
I wasn't running the trace when the statement was prepared so all I know
is that the "ID" of the prepared statement is "162"

Anyone dealt with this before?

--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark





~|
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:319234
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: tools for creating DAO, Gateway, Bean, etc CFCs

[Gerald Guido]

I just ran into this list of code generators:

http://www.carehart.org/cf411/#cfcodegen




On Thu, Feb 12, 2009 at 1:12 AM, Mike Soultanian  wrote:

>
> So I've been reading a bunch of stuff about CFCs and I read in a few
> blog posts where people said something like "...if you're still writing
> your DAO CFC by hand...", implying that there was a tool to do this for
> you.  Are there tools that help in writing CFCs?  Just like how
> FuseBuilder is a godsend for FuseBox, I'd feel like a fool if I was
> writing this stuff by hand when there were tools out there to do this.
>
> Thanks!
> Mike
>
> 

~|
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:319233
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT: More SQL Profiler questions

[Gaulin, Mark]

Hi Rick
That's a good trick with MaxPooledStatements...

Say, what was the deal with going "back to using the regular SQL Server
JDBC" and "my queries are flying"? 

Thanks
Mark


-Original Message-
From: Rick Root [mailto:rick.r...@webworksllc.com] 
Sent: Thursday, February 12, 2009 10:04 AM
To: cf-talk
Subject: Re: OT: More SQL Profiler questions


In case anyone else comes across this via google...

Once a query is compiled with sp_prepare, it is stored in a system table
however only the first 128 characters of the SQL are stored in a visible
form in SQL 2000

The easiest way to handle this was to set MaxPooledStatements to 0 while
running SQL Profiler.  On my system, it did cause a very slight
degradation in performance due to having to prepare every statement..
but helped me to actually see the query being run and allowed me to
debug the ones with large amounts of reads, high duration, high cpu,
etc.

Rick

On Wed, Feb 11, 2009 at 5:57 PM, Rick Root 
wrote:
> Alright so now that I'm back to using the regular SQL Server JDBC 
> driver, my queries are flying.  Most of them.  Problem is, there are 
> some that don't.
>
> Watching in SQL Provider, all I see is stuff like this:
>
> exec sp_execute 162, 5909, 1973
>
> That took 956ms of cpu... did over 180,000 reads, and took nearly 10 
> seconds to run.
>
> And I have NO idea what the query is or how to find out what it was.
> I wasn't running the trace when the statement was prepared so all I 
> know is that the "ID" of the prepared statement is "162"
>
> Anyone dealt with this before?


--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark



~|
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:319232
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Maybe I need a SQL Service Consultant...

[Rick Root]

Final update on this issue for future generations

Our SQL expert helped pinpoint some query issues and updated a few
indexes for us... resolving the way my database driver was configured
helped clear up a lot of problems by reducing the # of reads we were
doing.  HOWEVER, the server slowdowns still occurred for the same
duration but they were less noticable because more of the queries were
runnign without reading from disk during these times.

There are, apparently, two solutions to performance issues caused by
checkpointing.

#1 - add more disks to your drive array.  Apparently, a 6 disk array
is less likely to have these kind of read/write blockages than a 3
disk array.  This isn't an option for us right now though.

#2 - force checkpointing more often.  This was our solution.  The
system was checkpointing every 10-20 minutes depending on activity,
and we are forcing it now to do checkpoints every minute now through a
SQL Agent task.  The spikes are still there, but they won't really
affect our users anymore.

Apparently, there is option #3 - which is "Upgrade to SQL Server 2008"
which in and of itself would improve checkpointing performance, but
also apparently SQL 2000 can only use 1.5gb of RAM, so we're
underutilizing our server in terms of physical memory (it has 4gb
total)

Rick


On Wed, Feb 11, 2009 at 9:13 AM, Rick Root  wrote:
> Well, using perfmon I was able to see significant amounts of disk read
> and write on the SQL Box during these times... but I still didn't
> really know what that meant.
>
> We've contracted a 4 hour block of time from a sql server tuning
> expoert and in conversations with him, just based on that information
> about, he suggested that we might have a problem with checkpoints, and
> it certainly seems to be that.  I finally figured out how to enable
> the sql server counters in perfmon (we're running 32bit sql server
> 2000 on 64 bit windows server 2003 so the counters didn't appear in
> the 64 bit perfmon)... it does look like a checkpoint problem.  I'll
> let the expert help us figure out the best way to resolve it but the
> solution may involve changing the server's recovery interval.
>
> Turns out that the physical hardware was ordered based on
> recommendations from seefusion.  I'm surprised they'd recommend having
> the OS and Data on the same physical set of disks (maybe they didn't
> and the hosting company just misinterpreted their recommendations) but
> at least we have the transaction logs on their own set of disks.
>
> Anyway, as I get a complete answer from our consultant I'll report
> back here in case anyone googles similar issues or if anyone is just
> curious.
>
> Rick
>



-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
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:319231
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: tools for creating DAO, Gateway, Bean, etc CFCs

[Eric Cobb]

I you want to use Stored Procedures, don't forget to check out SquidHead.

http://squidhead.riaforge.org/

Thanks,

Eric Cobb
http://www.cfgears.com


Gerald Guido wrote:
> There are tons of them. Go here and search for "generator" or "code".
> 
> http://www.riaforge.org/index.cfm?event=page.search
> 
> I am a big fan of Illudium. You can customize it to build all sorts of
> stuff. I have hacked the crap out of it using some mods that I found on
> Chris Phillips site.
> 
> http://www.cfchris.com/cfchris/index.cfm/Database-Abstraction
> 
> G!
> 
> On Thu, Feb 12, 2009 at 1:12 AM, Mike Soultanian  wrote:
> 
>> So I've been reading a bunch of stuff about CFCs and I read in a few
>> blog posts where people said something like "...if you're still writing
>> your DAO CFC by hand...", implying that there was a tool to do this for
>> you.  Are there tools that help in writing CFCs?  Just like how
>> FuseBuilder is a godsend for FuseBox, I'd feel like a fool if I was
>> writing this stuff by hand when there were tools out there to do this.
>>
>> Thanks!
>> Mike
>>
>>
> 
> 

~|
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:319230
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: More SQL Profiler questions

[Rick Root]

In case anyone else comes across this via google...

Once a query is compiled with sp_prepare, it is stored in a system
table however only the first 128 characters of the SQL are stored in a
visible form in SQL 2000

The easiest way to handle this was to set MaxPooledStatements to 0
while running SQL Profiler.  On my system, it did cause a very slight
degradation in performance due to having to prepare every statement..
but helped me to actually see the query being run and allowed me to
debug the ones with large amounts of reads, high duration, high cpu,
etc.

Rick

On Wed, Feb 11, 2009 at 5:57 PM, Rick Root  wrote:
> Alright so now that I'm back to using the regular SQL Server JDBC
> driver, my queries are flying.  Most of them.  Problem is, there are
> some that don't.
>
> Watching in SQL Provider, all I see is stuff like this:
>
> exec sp_execute 162, 5909, 1973
>
> That took 956ms of cpu... did over 180,000 reads, and took nearly 10
> seconds to run.
>
> And I have NO idea what the query is or how to find out what it was.
> I wasn't running the trace when the statement was prepared so all I
> know is that the "ID" of the prepared statement is "162"
>
> Anyone dealt with this before?


-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
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:319229
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: tools for creating DAO, Gateway, Bean, etc CFCs

[Gerald Guido]

There are tons of them. Go here and search for "generator" or "code".

http://www.riaforge.org/index.cfm?event=page.search

I am a big fan of Illudium. You can customize it to build all sorts of
stuff. I have hacked the crap out of it using some mods that I found on
Chris Phillips site.

http://www.cfchris.com/cfchris/index.cfm/Database-Abstraction

G!

On Thu, Feb 12, 2009 at 1:12 AM, Mike Soultanian  wrote:

>
> So I've been reading a bunch of stuff about CFCs and I read in a few
> blog posts where people said something like "...if you're still writing
> your DAO CFC by hand...", implying that there was a tool to do this for
> you.  Are there tools that help in writing CFCs?  Just like how
> FuseBuilder is a godsend for FuseBox, I'd feel like a fool if I was
> writing this stuff by hand when there were tools out there to do this.
>
> Thanks!
> Mike
>
> 

~|
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:319228
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: (ot) More SQL Profiler questions

[Gaulin, Mark]

...and now you know why I don't like cfqueryparam...

As far as I can tell there is no way for you to translate that "162"
into the actual sql that it corresponds to since the id "162" is
specific to the database connection. (You can look around at prepared
statements by querying syscacheobjects, but it will hard to know for
sure which item it is. Check out
http://www.megasolutions.net/Sqlserver/How-can-I-find-out-what-command-s
p_execute-is-running-(without-using-Profiler)-1687.aspx for more ideas.)

I've submitted several ideas for enhancements to Adobe/macromedia on how
they could help this situation, for whatever good that has done. (None,
I suppose.)  

Thanks
Mark

-Original Message-
From: Rick Root [mailto:rick.r...@webworksllc.com] 
Sent: Wednesday, February 11, 2009 5:57 PM
To: cf-talk
Subject: (ot) More SQL Profiler questions


Alright so now that I'm back to using the regular SQL Server JDBC
driver, my queries are flying.  Most of them.  Problem is, there are
some that don't.

Watching in SQL Provider, all I see is stuff like this:

exec sp_execute 162, 5909, 1973

That took 956ms of cpu... did over 180,000 reads, and took nearly 10
seconds to run.

And I have NO idea what the query is or how to find out what it was.
I wasn't running the trace when the statement was prepared so all I know
is that the "ID" of the prepared statement is "162"

Anyone dealt with this before?

--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark



~|
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:319227
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Hosting

[Jason Fisher]

I have been with CrystalTech (www.crystaltech.com) for a few years now and 
really like them, inexpensive and solid service for CF7 or CF8, SQL 2000 or SQL 
2005. 

~|
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:319226
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Quick Address System - "Click System Web Service" in ColdFusion MX7

[James Buckingham]

Hi there,

We're trying to upgrade our version of Quick Address (www.qas.com) just now. 

Originally this was done through a COM object call but we're now moving to a 
"Charge by Click" Web Service. QAS no longer provides a ColdFusion example for 
us to use so we're trying to work through this ourselves.

The application is running correctly on the server. If we put in the URL to the 
service in our browser we're getting the SOAP structure fine but when we invoke 
it in ColdFusion like so:

http://mydomain.com:/proweb.wsdl" />

I get the following area:
Web service operation doGetLicenceInfo with parameters {} cannot be found. 

This happens for any method I call whether I pass arguments or not 
(doGetLicenseInfo doesn't require any). We've had a look at this through the 
JRun TCP Monitor and everything seems to be running fine until the result comes 
back to CF. At that point it seems to be having a problem.

Does anyone have any suggestions on how we can solve this? I'm not finding much 
on the "blogsphere".

Cheers,
James 

~|
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:319225
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Quantum Gateway CDG Commerce

[Maya MacDonald]

Hi,

I am currently trying to integrate the same Quantum Gateway application.  Did 
anyone ever get this to work?

--

> Hi,
> 
> Having a difficult time integrating to CDG Commerce's Quantum Gateway 
> with CF 8. Making a CFHTTP call to their gateway URL https://secure.
> quantumgateway.com/cgi/tqgwdbe.php but CF returns "peer not 
> authenticated".
> 
> Have gone through and imported the root certificate with keytool, both 
> the certificate saved using IE, and when that didn't work, a download 
> of the root cert from entrust.net.
> 
> I can't figure out why the heck this doesn't work. A basic example:
> 
> https://secure.quantumgateway.com/cgi/tqgwdbe.php"; 
> resolveurl="no">
> 
> 
> 
.. 
> just doesn't work. Any ideas?
> 


~|
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:319224
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

AW: (ot) More SQL Profiler questions

[Gert Franz]

Rick,

I guess this is exactly what you are looking for:

http://www.petefreitag.com/item/674.cfm

Greetings from Switzerland
Gert Franz
Railo Technologies GmbH
gert.fr...@railo.ch
www.railo.ch

Join our Mailing List
german: http://de.groups.yahoo.com/group/railo/
english:http://groups.yahoo.com/group/railo_talk/
linked in:  http://www.linkedin.com/e/gis/71368/0CF7D323BBC1
Bug tracker:http://jira.jboss.org/jira/browse/RAILO
Railo Blog: http://www.railo-technologies.com/blog


-Ursprüngliche Nachricht-
Von: Rick Root [mailto:rick.r...@webworksllc.com] 
Gesendet: Mittwoch, 11. Februar 2009 23:57
An: cf-talk
Betreff: (ot) More SQL Profiler questions


Alright so now that I'm back to using the regular SQL Server JDBC
driver, my queries are flying.  Most of them.  Problem is, there are
some that don't.

Watching in SQL Provider, all I see is stuff like this:

exec sp_execute 162, 5909, 1973

That took 956ms of cpu... did over 180,000 reads, and took nearly 10
seconds to run.

And I have NO idea what the query is or how to find out what it was.
I wasn't running the trace when the statement was prepared so all I
know is that the "ID" of the prepared statement is "162"

Anyone dealt with this before?

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark



~|
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:319223
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4