Morning Guys and Girls,
I'm running ColdFusion 8 Standard and SQL Server 2005 Workgroup edition. I'm
using The standard SQL Server driver that comes with CF8.
I'm having a strange performance issue with a particular query. When running
the query from SSMS it returns the dataset in less than a
Azadi, thanks for your help - sorry i havent responded earlier - been
away from my keyboard for the weekend - first time in nearly a year!
Anyway, the maxsize of post data is set to 100MB so it isnt that.
Any other thoughts?
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced
To make sure it's not the display/debugging causing the issue, remove it
all. A dump of a large query in Firefox with Firebug will take a while (I'm
not saying 8 minutes, but a while!).
Post the query too.
Adrian
-Original Message-
From: Robert Rawlins
There was a post a short while ago about the file name length being a
problem on Windows. The magic number was 255 I seem to remember.
Does the same file renamed go up ok?
Adrian
-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: 16 January 2009 05:53
To:
Morning Adrian, thanks for getting back to me.
This is definitely not caused by the output/dump of the queries, even when all
those are removed it takes the same amount of time to return the page. This is
not a large query to return, simply a single row containing 2 columns. The
query looks as
Thanks Adrian, that was my first thought too. So i renamed the file
to test.jpg and it still died. Resizing the file and keeping the
original name, it went up.
Yet, the max upload size is 100MB to that cant be the problem either.
I dont have a problem telling my client she has to change the
Can you get it to fail every time with a given file?
Can you post it somewhere for us to try?
Adrian
-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: 19 January 2009 11:14
To: cf-talk
Subject: Re: Limits on images being uploaded using CFFILE?
Thanks
Try running this query by itself on a cf page, to
see if maybe one of the other querries on the page is somehow blocking it
At 06:03 AM 1/19/2009, you wrote:
Morning Adrian, thanks for getting back to me.
This is definitely not caused by the output/dump
of the queries, even when all those
Another thing to try: put the query in a sproc and call it with
cfstoredproc. Theoretically, modern SQL Server has made it so that cfquery
(ad-hoc) is as fast as cfstoredproc...but...maybe...
Let us know...
On Mon, Jan 19, 2009 at 7:17 AM, Al Musella, DPM
muse...@virtualtrials.comwrote:
Try
Hello Guys,
Thank you all for your ideas. After speaking with [Justice] over on the IRC
channel I removed the cfqueryparam / and found it ran smooth as silk. Seems
that there was some form of datatype mismatch going on, after changing the
cf_sql_type on the queryparam we've got it running at
Guys,
I've got a cfchart which sits inside a cfdocument. In development on my local
machine this works perfectly, however, when moved to production we just get a
red [X] where the chart should be sat. I've had this problem for as long as I
can remember but have only got around to tackling it
What the heck?! Never would have guessed that. You changed cf_sql_type on
which queryparam from what to what?
On Mon, Jan 19, 2009 at 7:55 AM, Robert Rawlins
robert.rawl...@thinkbluemedia.co.uk wrote:
Hello Guys,
Thank you all for your ideas. After speaking with [Justice] over on the IRC
If you do it without the cfdocument so that the chart would appear in the
browser, does it still show as a broken image? If so, can you right-click
the broken image and pull up the image location? That'll (at least) tell
you where that page *thinks* the chart should be...
On Mon, Jan 19, 2009
Can I use case statements within a QoQ?
~|
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:
If you're referring to something like the following, then sure:
cfquery dbtype=query
select stuff
from stuff
where
cfswitch expression=#var#
cfcase value=7
things = 2
/cfcase
cfdefaultcase
things = 1
/cfdefaultcase
/cfswitch
/cfquery
On Mon, Jan 19, 2009 at 8:19 AM, Torrent Girl
If you mean SQL case statements, no.
On Mon, Jan 19, 2009 at 9:19 AM, Torrent Girl torrentg...@gmail.com wrote:
Can I use case statements within a QoQ?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
John,
Thanks for the reply. chchart outside of the cfdocument works just fine, no
problems at all, its only when placing it inside that it doesn't work :-(
Rob
If you do it without the cfdocument so that the chart would appear in the
browser, does it still show as a broken image? If so, can
I don't believe you can use T-SQL case statements in a QofQ.
-Original Message-
From: Torrent Girl [mailto:torrentg...@gmail.com]
Sent: Monday, January 19, 2009 8:19 AM
To: cf-talk
Subject: SQL CASE STATEMENTS
Can I use case statements within a QoQ?
I'm getting errors when i attempt to upload images to a site using an
image upload form I've done. But I'm not sure why.
What does your file processing code look like?
Will
~|
Adobe® ColdFusion® 8 software 8 is the most
If storing all Web site content in a single column within a single
database table is a specific requirement of the client then you should
do what they want, especially if you are getting paid by the hour. I
wouldn't question it unless this is a site that has a lot of content
and gets a lot of
CASE is part of core SQL, not an MS extension in T-SQL. But not
supported by QofQ either way. Write to your local Adobe rep today!!
cheers,
barneyb
On 1/19/09, Andy Matthews li...@commadelimited.com wrote:
I don't believe you can use T-SQL case statements in a QofQ.
-Original
Thank you all for your ideas. After speaking with [Justice] over on the IRC
channel I
removed the cfqueryparam / and found it ran smooth as silk. Seems that
there was
some form of datatype mismatch going on, after changing the cf_sql_type on the
queryparam we've got it running at proper
I've got a cfchart which sits inside a cfdocument. In development on my local
machine this
works perfectly, however, when moved to production we just get a red [X]
where the chart
should be sat. I've had this problem for as long as I can remember but have
only got
around to tackling it
Is it true that the SQL will perform better if you cfqp any static values
too? So:
WHERE cfqp value=1
over:
WHERE id = 1
Adrian
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: 19 January 2009 16:31
To: cf-talk
Subject: Re: Coldfusion killed my query?
I assume you mean the NAME attribute, which will save the chart bits
to a variable. You could then use fileWrite() or cffile to save it to
a file.
On Mon, Jan 19, 2009 at 10:32 AM, Dave Watts dwa...@figleaf.com wrote:
Save the chart to a file, then build an image tag that points to the
file.
The process swsoc.exe (CF ODBC Server) keeps taking over my computer with CPU
utilization frequently over 80%. I'll notice my computer running slowly, check
task manager, see swsoc taking up a lot of CPU time, restart the CF ODBC Server
and things will be fine for a while.
I'm running
I am trying to output a video name dynamicly with coldfusion with JW FLV Player
http://www.longtailvideo.com/players/jw-flv-player/ but keep getting a
404:Error 2032.
I have the same file in the body tag when it loads and that works just fine.
But then if i try on the dynamic link which just
I have this problem when connecting to FoxPro tables... in the process of
moving those over to SQL server
-Original Message-
From: Sean Sekora [mailto:seansek...@gmail.com]
Sent: Monday, January 19, 2009 8:47 AM
To: cf-talk
Subject: swsoc.exe CPU Spike
The process swsoc.exe (CF ODBC
Make sure your webserver can server up .flv files. IIS doesn't (not sure if
things have changed for the latest one) by default.
Browse to where you think the flv is and see if it's being served up.
If it is, try playing it in a regular video player, does it work?
Adrian
-Original
Is it true that the SQL will perform better if you cfqp any static values
too? So:
WHERE cfqp value=1
over:
WHERE id = 1
I don't think so, generally. But query performance can be all over the
map - there are a lot of contributing factors. So I wouldn't be
entirely surprised if it did
I assume you mean the NAME attribute, which will save the chart bits
to a variable
Yes, I guess so!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
I'm trying to learn to set up a mySQL database. Does CF have to be on the same
machine/server for it to talk to the mySQL database? I'm also not sure if I
have to set up a web server for anything to talk to the database or can I just
give it an IP that the database is on, somehow.
Finally,
CF can connect to a database on a remote box - that's the way pretty
much everything is set up, except on shared hosting where you usually
have a single box filling both roles. With separate boxes you can
scale the two halves separately, which is quite important as your
resource needs grow,
When you set up the CF DSN one of
the fields is for the DB server, just add the IP (or name if you have
one) of the server and the port number (probably 3306) and you should
be good to go.
okay. I see. In my case, I'm in a shared hosting environment where CF and
Oracle are given to me. I
Yeah, if you don't have the DSN config available to you, you're kind
of stuck. You can sort of fake it by manually doing your own JDBC
connections, but that's a disaster waiting to happen. If you've got
the ability to do it locally on your own hardware, I'd highly
recommend that approach.
Those are good points. Thank you very much.
It's way past time I learned the management side of CF anyway. I'm sure it'll
be good for me.
thanks for taking the time to respond.
daniel
~|
Adobe® ColdFusion® 8 software 8 is
Has anyone ever created an outline in a pdf dynamically using ColdFusion?
If so, how do you do it?
Thanks,
Chuck
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Can you explain what you mean? Are you outlining some other data and
_rendering_ it in PDF? Or are you creating an outline from PDF
content? And if so, is that outline itself in PDF, or just in some
CFML structure that you can do with what you want?
On Mon, Jan 19, 2009 at 1:11 PM, Chuck
Let me explain what I'm looking for.
Sometimes when you open a PDF you will get an outline or maybe you might
call it a page jump on the left hand side of the PDF when viewing it in
Acrobat Reader. This is the section that you can click on and it will take
you to that particular section in the
We're facing a rebuild of every CF8 server in our fleet here - if
anyone has any ideas, please, please chime in. So far I've built a new
cf8.01 server with the same patches, the same FusionReactor, the same
JVM and the same settings on the same OS and I can't duplicate the
problem, yet every
If it helps anyone, I think I've found the class that's failing:
cfset myFeedTag =
createobject(java,coldfusion.syndication.FeedDateParser).getInstance()
This works on the Windows box and on the new SLES box; it fails on our
main boxes with
java.lang.NoClassDefFoundError at
Just wanted to take a minute to announce a new project I worked on over the
weekend. It's a small library which wraps the API functionality of multiple URL
shorteners into one codebase. One method to call, returns a string, couldn't be
easier.
I'd love to get some feedback from any of you on
James,
Why are you using the 1.5 series of the JVM?
Since the reinstall works, try installing the new 1.6.0_11 JVM and see
if that fixes the issue?
If for some reason you absolutely can not use the 1.6 version then
install a second copy of the JVM you have and switch to that one.
To me it
Hi Andy,
Looks nice, but why wouldn't you just create the short URL using
your own domain? I do that, and it allows me to count how many
people click each short link, and also lets me put links back to my
website all over the web, instead of links to the short url websites?
Al
The 1.6 JVM breaks the SSL for the internal JRun Webserver, which we
use for administration. As an aside, if anyone can tell us how to make
JWS with SSL work with Java 6 we'd be very happy. Regardless, I
actually did try going back to the default CF8.01 JVM with the same
results.
For
i have a page that has 2 iframes...
iframe1 is a form pstpg.cfm that posts to itself and writes to table...
when a visitor submits form in iframe1 need it to tell dsppg.cfm in
iframe2 to refresh.
i know not a cf issue but driving me nuts
- note
You know, you might want to try copying the tools.jar file from the
{currentjre}/lib folder to the /cfusion/lib folder. Until I did this,
my webservice calls were all shot to hell. This may only be a problem
for those that install in multiserver mode though. Maybe standalone
copies the
see if any of these can help you:
http://bytes.com/groups/javascript/148043-refreshing-one-iframe-another
http://www.tek-tips.com/viewthread.cfm?qid=1281918page=6
http://www.daniweb.com/forums/thread130202.html
but, as was wisely suggested in of the other links i found:
DON'T use iframes - use
Yeah, we do that as part of every standard install when we change the
JVM - it's a good tip for anyone reading though.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/1/20 Matthew Williams mai...@geodesicgrafx.com:
You know, you might want to try copying the
Not sure, but it may be worth checking out - it MAY create the outline
from h1 , h3 , h3 elements in your document.
I could be wrong tho, but its worth a shot.
Mark
On Tue, Jan 20, 2009 at 12:25 PM, Chuck h...@coldfusionguru.com wrote:
Let me explain what I'm looking for.
Sometimes when you
Right, I have the solution.
We have sandboxing turned on; while just about everything works as you
would expect without it, it appears that for some functionality
(including cffeed) the path to [coldfusion
instance]/WEB-INF/cfusion/lib needs to be added to the sandbox. After
adding the
51 matches
Mail list logo