This is to both Jason and Azad. Can I use a self generated ID for renaming the
files instead of the function createuuid? TIA
You don't want to use the '' inside the CFFILE tag. Try this, assuming
#dest# is a variable holding a full file folder path ending with '\':
cfif structKeyExists(form,
Hi Mark,
I only mentioned cfexecute because of the permissions set on our
specific case. Your info seems most likely. I did notice that there
was a cfm file created with a call to cfexecute on the webroot so this
should be a check as well.
best regards
Donnie
On 4/13/09, Nick Gleason
Absolutely.
cfset myCustomVar = whateverABC1299X /
...
cffile ... destination=#dest##myCustomVar#.#cffile.serverFileExt# /
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free
Good Day,
Can't come up with a better title, so here is what I want to do.
I have two servers, one DB and one web. My DB server is having MASSIVE issues
at the moment. CPUs blowing up, and the server shutting down randomly, at
night. I would like to use the webserver (with CF8) to monitor
This isn't a CF kind of way to do what you are asking, but it might be
what you are looking for.
We have used Nagios to monitor, log and troubleshoot servers in both
of our datacenters and it can be very useful if you just can't sit in
front of a machine 24/7.
http://www.nagios.org/
How long til we get CFML on there?
http://jeffgladnick.instantspot.com/blog
FWIW there's been a discussion on the Open BlueDragon list about running a
modified version of OpenBD on the Google App Engine for Java.
Hi - you dono't say what db you are running - I am guessing SQL
Server? I can think of a couple of ways from the CF point of view:
1.Create a cfm file that connects to an instance on your db server.
E-mail the results of SELECT GETDATE() AS [CurrentDateTime] to you.
Set this up as a scheduled
If your goal is to diagnose a mystery database issue that is a
definite problem, I would use a database monitoring tool, such as MS
SQL Profiler. Are you aware of the professional database monitoring
tools, such as the ones Quest and Idera make? Where Web site
monitoring of the database helps is
Oops. You did mention that you run CF8. Have you explored the
monitoring feature built into CF8 yet?
-Mike Chabot
On Tue, Apr 14, 2009 at 10:04 AM, Mike Chabot mcha...@gmail.com wrote:
If your goal is to diagnose a mystery database issue that is a
definite problem, I would use a database
I second Nagios. You can monitor the port required and get alerts by
email or sms (if available)
On 4/14/09, Mike Chabot mcha...@gmail.com wrote:
Oops. You did mention that you run CF8. Have you explored the
monitoring feature built into CF8 yet?
-Mike Chabot
On Tue, Apr 14, 2009 at 10:04
Thank you Paul
If anyone is interested:
A bit dirty but this worked for me..:
cfset
codedstring==?utf-8?B?W1ZpZGVyZXNlbmR0IGZyYSBXUyBTdXBwb3J0XSBQYXlFeCDDuG5za2VyIGRl?=
=?utf-8?B?ZyBnb2QgcMOlc2tl?=
cfset cleanstring =
cfset a=#replacenocase(codedstring, '=?utf-8?B?','', 'all')#
thank chow-lee, kinda interesting. im a framework-less kinda guy, but i have my
own system i use, and its all cfc's and im interested in this one.
tw
On Mon, Apr 13, 2009 at 10:30 PM, Jake Pilgrim jpilg...@snapfitness.com wrote:
Yes! Thanks!
I'd love to hear a writeup, or even a few sentence review of your experience
with this one Jake. It looks really interesting.
-Original Message-
From: Ras Tafari [mailto:rastaf...@gmail.com]
Sent: Tuesday, April 14, 2009 10:26 AM
To: cf-talk
Subject: Re: coldfusion framework - i forget
this sounds like a good idea. when a hack is taking place would the home page
not be available? is this because they are running multiple scripts which takes
all the resources?
can you explain this a little more as i feel like it is a good idea, and would
like to understand how to implement
this sounds like a good idea. when a hack is taking place would the home page
not be
available? is this because they are running multiple scripts which takes all
the resources?
Many automated attacks deface your existing pages, or append
additional content to those pages. Not all do, of
Here's my test:
cfquery name=test datasource=dsn timeout=1
select top 2 *
from table
/cfquery
cfoutput#cfquery.ExecutionTime#/cfoutput
I'm getting 3000+ for this value. This shouldn't be, right? Because I have
the timeout parameter set for a second? The driver I'm using
thanks for the info
this sounds like a good idea. when a hack is taking place would the
home page not be
available? is this because they are running multiple scripts which
takes all the resources?
Many automated attacks deface your existing pages, or append
additional content to
Hi
we have a relational database and one task is taking far too long but we cannot
see any way to improve it, although i do feel there is a way to massively
improve it... so would like some expert help on this
we have a normal table which has a One-to-Many table coming off of it...
table 1
What DB are you using? If it's MySQL, you can use this:
select client.name, group_concat(clientphone.number) as phone numbers
from client
left outer join clientphone on client.id = clientphone.clientId
group by client.name
If it's MS SQL Server you can use a subquery with FOR XML PATH and
The easiest way is use a JOIN to get a query that will have a phone number
on each row, then use the 'group' attribute of cfoutput to display them
correctly.
On Tue, Apr 14, 2009 at 3:38 PM, Richard White rich...@j7is.co.uk wrote:
Hi
we have a relational database and one task is taking far
Have you looked into StoredProcs? Push the load off the web server onto the
SQL Server (or Oracle whichever)
On Tue, Apr 14, 2009 at 3:38 PM, Richard White rich...@j7is.co.uk wrote:
Hi
we have a relational database and one task is taking far too long but we
cannot see any way to improve
There isn't really an efficient way to get a comma separated list in
one column with your DB query. However, there is a far more efficient
method that uses a single query and groups the output:
cfquery name=qryClients datasource=myDsn
SELECT c.clientId, c.firstname, c.lastname, t.number
FROM
thanks for all your replies.
barney, yes we are using mysql and didnt even know about the qroup_concat. it
works like a dream and where this task was taking 23 seconds to complete it is
now taking a matter of milliseconds :)
fantastic and thanks once again for all your replies :)
What DB
Nice. So group_concat works sort of like ColdFusion's valuelist method. Very
nice indeed!
-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent: Tuesday, April 14, 2009 2:59 PM
To: cf-talk
Subject: Re: expert sql challenge
thanks for all your replies.
barney, yes
cf.Objective is Giving Away (2)Two CF 8 Standard Licenses to New Registrants
If you register* between April 13 to the start of the conference you will be
entered to win one of two licenses that are being given away only for these
last minute registrants. Jason Delmore has donated these
Is there a MSSQL version of that puppy?
On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com wrote:
Nice. So group_concat works sort of like ColdFusion's valuelist method. Very
nice indeed!
-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent:
Actually, I was wrong -- even cfsetting requesttimeout=1
enablecfoutputonly=No doesn't work, because it still waits for the cfquery
to finish before it outputs the timeout error. Is there any solution for this?
The database we're relying on is unstable and we need to be able to kill the
how about adding WITH (NOLOCK)
If your queries are just selecting data, i'd use WITH (NOLOCK)
that way you don't need to wait for transactions to finish if that table
gets heavy inserts
cfquery name=test datasource=dsn timeout=1
select top 2 * WITH (NOLOCK)
from table
Here is an Oracle UDF (for lack of a better description) that I just found.
create or replace function join
(
p_cursor sys_refcursor,
p_del varchar2 := ','
) return varchar2
is
l_value varchar2(32767);
l_result varchar2(32767);
begin
loop
fetch p_cursor into l_value;
exit when
Here you go. Note that they're not really semantically equivalent,
they just happen to return the same results. The approach for
obtaining the result is completely different, and the MS SQL one,
while less direct for the actual comma separate list creation, is far
more expressive for what
Hi Casey,
What happened today is that the SQL server basically locked up. CF kept
waiting for the request to come back, but it never did because it just hung
infinititely. It seems as if CF waits forever in a case like this, so it's
vital that I can kill the connection from the CFQUERY.
Mark,
I can confirm that there has been FTP related 'sploits going around.
I received a message from a hosting company warning that:
There is a potential security exploit within the FTP software that we use
on your account.
Just a 411
G!
On Mon, Apr 13, 2009 at 1:13 PM, Mark Kruger
Barney, that TSQL is brilliant. I've never used the Stuff function and
had only used FOR XML PATH when generating xml. I had to go look at
the books online and sure enough they have an example turning results
into a value list in the same way that you are although they do the
select as data().
Hey All,
WowLONG time no post! ;-)
We've got a large client with MANY (over 100) data sources (including
spreadsheets on PCsyou know the story).
They want to have a central catalog of what data can be found where.
Of course it's not just basic details like payroll data can be accessed
Thanks... I'll add that to my list.
I have a pretty hefty blog post coming out on this tomorrow (or hopefully
tomorrow :).
-mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Gerald Guido
I don't know about the data function. I try to avoid SQL Server when
I can. ;) We use it for some projects with MySQL's query language
wasn't rich enough to express certain types of queries, but in general
I use MySQL when possible.
Did they have an example of a query equivalent to mine that
On Tue, Apr 14, 2009 at 3:47 PM, Barney Boisvert bboisv...@gmail.com wrote:
Did they have an example of a query equivalent to mine that uses the
data function? Because it seems like that'd probably be more
efficient than going through an XML process.
MSDN actually used almost exactly what
No - if you are hacked, the home page is available, but it includes a
javascript that does bad things to the visitors.
The most common way is a sql injection attack, where they insert the
javascript into some fields in the database, (in my case, they
appended the javascript to all vchar fields
thanks for the info, at least we know what to look for now. we will also try to
setup something similar, thanks again
No - if you are hacked, the home page is available, but it includes a
javascript that does bad things to the visitors.
The most common way is a sql injection attack, where they
39 matches
Mail list logo
