Lots of systems have reserved folder names. If you're running windows, just
try to create a PRN or CON folder. :D
Just noticed it myself. Amazing that in 2008 that this is an issue.
http://forums.crystaltech.com/index.php/topic,33421.0.html
I've not see it, but CrystalTech uses the Serv-U
Hi All,
I'm wondering if anyone has any experience with the jTDS driver
(http://jtds.sourceforge.net) and Coldfusion 8. I'm running this on Win2003
box (32 bit), Cf 8.0 and sql server 2005.
I've set up the driver, and can use it to successfully fetch queries with a
substantial speed
Hi All,
I'm trying to make a XML-RPC call using CFHTTP that only allows SSLV3
connections. The webservice provider told me that there is problem with the
way my certificate is being processed.
After running Ethereal, I noticed that during the 'Client hello', CFHTTP using
the SSLv2
I was also receiving the very cryptic 500 NULL error; in circumstances very
similar to the above. I ended up tracking this down to
java.lang.String.URLDecode(), which throws a java.lang.IllegalArgumentException
if a '%' character is not followed by a valid 2-digit hexadecimal number. So,
for
Can you post the query execution plan? It sounds like you forgot to add an
index.
I have anice getdistance function that calcs the distance between two zip
codes.
**snip**
However, that is very slow. It's very fast if I pass in the lat and long.
Can you post the query execution plan? It sounds like you forgot to add an
index. That or the you're killing the optimizer with the SELECT *; bookmark
lookups can kill a DB.
I've got my zip code database proximity thing all figured out. I have a
nice getdistance function that calcs the
I should have seen the solution eariler, or followed Nick's advice.
The easy way to track long winded queries is the set the SQL profiler filter to
include 'declare%' in the TextData field. The original query will be
displayed, under the sp_prepexec, and then executed. So this query will
This is not an SP per se, it is just how SQL handles these dynamic SQL
strings.
Upon further research this is a SP.
I pulled the following from Ray Camden's blog.
So this:
cfquery name=getUser datasource=#dsn#
SELECTname, Email, userId
FROM users
WHERE username
I'm running SQL Server 2000. The SP is dynamically compiled, and is stored in
memory on the DB. The dynamic SP is accessed by handlers instead of actually
calling the SP from disk (aka The true way). But tomato, tomato. (:) that
doesn't type well does it?)
For the filter, I'm limiting my
Hello All,
I'm trying to track some slow running queries with MS SQL profiler. If I use
cfqueryparam Coldfusion will automatically convert the query to a stored
procedure.
For example:
cfquery name=test datasource=MSSQL
SELECT
id, user
FROM
userTable
Thanks.
But how do you track by this dynamic SQL string to the orignal parent query?
This is not an SP per se, it is just how SQL handles these dynamic SQL
strings.
-Original Message-
From: Billy Jamme [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Mon Jul 17 20:44:40
Just one filter. Reads is greater than or equal to 1.
What do you mean by trace file setup? I'm just running Profiler from the
default tools in the MS SQL install. I connect to the DB analyze the
queries in real-time.
Can I track the sp_exec handler in SQL?
What filters are you
Hello All,
I'm having some DB issues and I'm wondering if I could get some help with it.
I'm running CFMX7, and MSSQL2k. On this specific task, I'm using the IN or NOT
IN clauses in sql to grab a set of records.
The problem occurs when I attempt to use cfqueryparam to fetch a 2100+ item
list
Hey Scott,
I ran into this exact issue last week.
Check out:
http://www.glub.com/products/secureftp/
It's a java package that runs quite nicely in a command line. As an added
bouns it has batch scripting.
The way I implemented it was to dynamically generate a batch file using cffile,
So by that rational only unindexed and non-sequential columns, such as a text
field, is where QoQs would offer performance increases?
I'm not too surprised in this case. The original query just pulls
everything from the table. The QoQ has to go through that whole
recordset and find the matching
Hi all,
I'm wondering if someone can explain to me how to properly utilize Query of
Queries (QoQ) to gain the maximum amount of performance.
Here's a code example..
cfquery datasource=test name=Query
Select ID, name
From TempTable
/cfquery
cfset start = GetTickCount()
cfloop
So for simple queries QoQs actually degrade performance?
If your initial Query query was very complicated then using QoQ to
extract subsets would probably perform better.
-Original Message-
From: Billy Jamme [mailto:[EMAIL PROTECTED]
Sent: Friday, 25 November 2005 4:16 p.m.
To: CF
I'm looking for the ATAN2 function in CFMX, but it appears that there isn't
one. (unless I'm looking in the place)
I've seen the ATN function, but it's not really what I'm looking for.
I know Javascript has this function using the Math.atan2(y,x) function. Has
anyone used wrote a simlar
Thanks for the pointer Isaac. Unfortunately they only have the Atanh function.
Anyone have any other suggestions?
There's probably one of those on http://www.cflib.org
~|
Discover CFTicket - The leading ColdFusion Help Desk
Swet!!!
I love you Rick. After Damien's suggestion I was trying to use the
java.lang.math, class (note the lower m), and getting no results.
I'll whip this up into a function, write the documentation post it to cflib.
Damien McKenna wrote:
-Original Message-
From: Billy
Crediting you, of course.
Swet!!!
I love you Rick. After Damien's suggestion I was trying to use the
java.lang.math, class (note the lower m), and getting no results.
I'll whip this up into a function, write the documentation post it
to cflib.
Hi All,
I'm thinking of building a Flash upload file progress bar.
I'm wondering if:
1) Is possible.
2) Has anyone done it before.
My idea was to compare temp file sizes (in the wwwroot-tmp dir) between 2 time
points to determine speed, but how do you determine overall file size to begin
The remoting calls wouldn't be real-time, I'd fake it a bit.
As for CGI.CONTENT_LENGTH, I thought that only gave a result after the file was
uploaded. Am I mistaken?
Well I can tell you right now that its not going to be easy at all. The
amount of remoting calls you'd make would be high.
I'm attempting to build an array from .txt file. What I'd like to do is create
a new element in the array with every new line in the text file.
Now I'm reading the file like this:
cfdirectory directory=H:\cfdev\ action=list name=dirs
cfloop query=dirs
!--- Read that file. ---
How are you scheduling this task ?
Here's an odd one that I can't get my head round. - cfmx61
I've got a scheduled task to run at 9:40 every day and then repeat
every three hours until 19:40.
At 9:40 the task runs but then in the scheduler log file it
reschedules itself for 10:40. At 10:40 it
Thanks for the prompt reply.
I assume you don't want to skip empty lines in the file...
That's correct.
At this point you've made at least one mistake that will prevent you
from getting the result you want... which is, you're looping from 1 to
the number of files in the directory -- which
Thanks for the prompt reply.
I truncated my code a bit, consquently removing the cfquery. In this example,
envision that the oringal example adhered to rule 1; however rule 2 is wee bit
of a conundrum. The macromedia site states:
---Start clip---
I don't know, are you sure your application is run by CFMX ?
Yes, I'm running CFMX 6.1.
I still write applications compatible with CF 5, because I like to reuse
my code anywhere, and I still have customers under CF 5, so I always use the
first form in the samples you gave.
I appreciate your
I'm having an issue with the PreserveSingleQuotes function. I'm running CFMX
6.1 on a Win2k box.
Here's a code sample:
---Start---
cfset testa = arraynew(1)
cfloop from=1 to=5 index=go
cfset testa[go] = ' go '
/cfloop
cfoutput#preservesinglequotes(testa[1])#/cfoutput
---End---
29 matches
Mail list logo