Yes, I am currently doing the large files manually. And like I said I have
transferred 100M + files via the command line ftp syntax posted.
I'm not really getting any errors when using cfexecute, just nothing is
happening or transferring.
Greg
On Fri, May 14, 2010 at 5:00 PM, Paul Alkema wrote
> Well .. either way, you will have to change to something if
> the CASE values are not static. Be it a table, or a SQL
> query.
... or your CF code.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/
> In theory, I could add a new database table to the site in
> question, and populate it every X number of hours on a schedule, but
> that's not exactly how this is set up to function.
Well .. either way, you will have to change to something if the CASE values are
not static. Be it a table, or
hedule, but that's not
exactly how this is set up to function. It's something I'm looking into
though.
Thanks!
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5115 (20100514) __
The message was checked by ESET
> Checking my syntax, but doesn't seem to work for a query of
> queries..
QoQ's are very limited. They do not support CASE statements, AFAIK.
If you are using a database query as the source of this information, add a CASE
statement to your base database query to generate a column called "SortN
In addition to the other good suggestions so far, check your datasource
settings. It is often the case that datasources are allowed to have a
huge number (or even infinite) connections to the database, and there
are often excessive timeout values with each datasource as well. If CF
sits pati
7; THEN 8
ELSE 100 END )
ERROR: Query Of Queries syntax error.
Encountered "(. Incorrect ORDER BY column reference [(].
Only simple column reference, alias name, and integer column id are
allowed.
__ Information from ESET NOD32 Antivirus, version of virus signature
databas
The first thing I look at when people say they have a memory leak is
the session variables. More than once I've identified the cause of a
clients problems in a few minutes by looking at how much data they put
into session variables, how long the timeout is, and how often they
are hit by bots.
Thin
Ironically, I'd double-check to make sure that you have the built in CF
server monitor turned off. It can bring a production server to its knees,
and we had a ton of crashing and burning that we couldn't figure out until
we finally discovered that someone had turned the server monitor on by
mistak
Hi,
I am new to ColdFusion server monitoring, so I am trying to get some ideas
here to get me move in the right direction.
We have a situation where our production ColdFusion applications are using
more and more memory until they bring the server to a halt. I was informed
(I am new here) that ou
Have you tried seeing if it's possible to upload some of these big files
manually? It's not uncommon for FTP servers to have a max files size
restriction.
What's the error that your receiving?
Paul Alkema
http://paulalkema.com/
-Original Message-
From: Greg Luce [mailto:luce...@gmail.c
I have a remote server with some transaction logs I would like to automate
the ftp retrieval of. I have a scheduled task that uses cfftp to do so, but
it seems no matter how long I set the timeouts in the CF Admin for the task,
or in the cfftp tag, it fails for files larger than ~ 30-40M.
I can g
Hi there,
We have recently upgraded our database from Sybase 6 to Sybase 11. We are also
hoping to move from ColdFusion MX 6.1 to ColdFusion 9 in the near future. In
both environments, the ColdFusion ODBC Server enters a state where it is hung
and the ColdFusion Application Server needs to re
> Also, run some traces to see if your updates are causing
> row locks or are
> escalating to table locks. I think that might be what
> Leigh was getting at.
Yep. But I think that is secondary to the main issue everyone has mentioned:
too much non-related processing within the transaction.
-
>
> Store the data in a temporary structure in memory and then write it to the
> DB once the uploads are finished.
>
+1
Store the data in a struct or array and wait until you have all the data to
open your transaction. Do this and your problem with disappear.
Also, in the places you are readi
Posting here, because I do a lot of ColdFusion development.
Anyone have space or recommend an executive suite in particular? I'll be living
in the Platt Park neighborhood. Would really be interested in space with an
existing IT shop. Any leads are appreciated. Drop me a line at m dot lesko at
> Is there a way to do an arbitrary sort order on a specific
> cell?
What do you mean by "cell"? A query, grid, etcetera ...? In general terms, you
could assign a "sort number" to each color (red=1, blue=2, ecetera). Then sort
by that value.
le values:
> 1. blue
> 2. cyan
> 3. green
> 4. orange
> 5. red
> 6. silver
>
> I want to sort on this cell, BUT, I want the order to show all
>
> red first
> blue second
> green third
> ... blah ...
>
>
> __ Information from ESET NOD32 Antiv
Just FYI - I highly recommend using Google Analytics to track who is visiting
your site. It is a free tool and not only tells you where people are visiting
your site from, it also lets you know what kinds of browers they are using,
whether they are using mobile devices, if their browsers are j
hird
... blah ...
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5115 (20100514) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
~|
Order the Adobe Coldfusio
. But also somewhat confused! What's the point of
the row number in QuerySetCell if you have to tell it to add a new row
to start with? OK, if you're UPDATING and existing row maybe, but ... ??
Hmmm...
__ Information from ESET NOD32 Antivirus, version of virus signature
database
number and everything.
Running the above though, I get an error message:
The row number 1 is out of bounds.
Suggestions?
>>
>>
>>
>>
>>
>>
>>
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5115 (20100514) ___
Did you see any problems with the code above?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com
> Could it be DNS (change not getting there yet) or permissions
> (automatic Windows domain authorisation, for instance, or saved credentials
> in
> your browser).
> Testing directly on the server or locally with something like 'wget'
> is normally the best path forwards.
I can't test direct
On Friday 14 May 2010 15:34:46 you wrote:
> Dave, I'm still not able to get this cfschedule working. When I say "run
> it separately", it means that instead of cfschedule activating the cf code
> that I have (which then sends email) that I instead bring up the url on my
> own browser to have i
>Logging is your friend. :-) Create a log file for your scheduled task.
>
>Does this page sit in an application that requires authentication? If so,
>make sure to specify the username and password.
Qing,
I'm not having much luck logging either. jeez. and no, there's no username
and password
> When you say you "run the URL separately" are you doing this from the
> server console? If not, the server may not be able to resolve the
> FQDN.
Dave, I'm still not able to get this cfschedule working. When I say "run it
separately", it means that instead of cfschedule activating the cf code
You should never include file uploading or photo processing within
a transaction. It won't scale. It might work well on your test
system, but when 20 people try to upload photos at the same time, and
even if 1 has a slow connection, your system will crash and burn.
Perhaps another way is to
I definitely prefer BlogCFC.
;)
On Thu, May 13, 2010 at 4:07 PM, Will Swain wrote:
>
> Are people generally preferring Mango to Ray's BlogCFC nowadays? I've done a
> few blogs with blogCFC, but haven't tried Mango yet.
>
> -Original Message-
> From: Christopher Stowell [mailto:christoph
Store the data in a temporary structure in memory and then write it to the
DB once the uploads are finished.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
On 14 May 2010 17:23, Paolo Broccardo wrote:
>
> >i would start by taking the file upload/processing out
>> i would start by taking the file upload/processing out of
>> transaction if you have it there.
>> leave only db insert/update in the transaction.
>
>Yes. With transactions, the shorter the better.
>
>Also, do you have any indexes on the album table?
Hi Leigh
Thanks for the input. At this po
>i would start by taking the file upload/processing out of transaction
>if you have it there.
>leave only db insert/update in the transaction.
>
>Azadi
>
>On 14/05/2010 13:20, Paolo Broccardo wrote:
>>
Hi Azadi - thanks for the feedback. I really like your idea of not having the
uploading in the
32 matches
Mail list logo