Re: He3

2004-05-05 Thread Matt Liotta
All the attendees of CFUN-04 will receive a CD containing the first beta version of He3. Additionally, the beta will be available to the general public from our web site after the conference is over. Clearly, if you want to be one of the first people to use He3 then you should attend CFUN-04,

OT? pull text between tags

2004-05-05 Thread Doug James
I am trying to get a print out of all of the queries used in my application. Anyone know of a quick and easy way to pull all of the text between cfquery ... and /cfquery in all of my files? perl script? cf function? Ultimately, I would like to be able to point whatever at a directory and get a

RE: RESOLVED - FYI : Oracle 9i and cfqueryparam problems

2004-05-05 Thread Jason.Gulledge
It was my understanding (and I could be wrong) that if you were using hints in your select statements to force oracle to use whatever indexes (or whatever) you wanted, using bind variables should be okay.I've been able to test this using the plan table, then tracing active sessions using Bind

RE: RESOLVED - FYI : Oracle 9i and cfqueryparam problems

2004-05-05 Thread Stacy Young
I'd imagine that would help...but in our case we rely heavily on Oracle's optimizer. We've tried to 'beat it' in the past...and there were just to many variances on how these reporting queries could be executed. In the end we were a touch faster in a few areas...much worse in many others. Cheers,

RE: add a column in oracle

2004-05-05 Thread Jason.Gulledge
Here's a bit of a detailed explanation of Dave means.Something to note about using where rownum 4 in Oracle is that it doesn't pull back the TOP type records.It'll simply pull back the first 3 rows that exist first in the database, and not any specialized order you want. However, there is a

Re: He3

2004-05-05 Thread Cutter (CF-Talk)
I'd love to go Matt, but anybody around here who's been to my boss's place would understand why I could never go to a conference between 1 May and 31 October. (The webcams are showing are annual tree planting right now. Should have a timelapse vid up in the next half hour.) Cutter Matt Liotta

World Wide Web Publishing Service

2004-05-05 Thread Casey C Cook
I installed my Macromedia Coldfusion MX on my local machine yesterday after IIS. (Windows 2000 professional)The coldfusion administrator worked fine yesterday and when I logged in today the administrator quit working.A co-worker of mine suggested I make the service World Wide Web Publishing

Re: add a column in oracle

2004-05-05 Thread daniel kessler
Thanks everyone who replied.I have it working now. As for adding the column.It was the quotes that helped.yay! I'm trying to add a column in my DB in Oracle.I'm doing: ALTER TABLE whatsnew ADD (imagevarchar2(100)); I also tried: ALTER TABLE whatsnew ADD column imagevarchar2(100); but I get the

RE: OT? pull text between tags

2004-05-05 Thread Steve Nelson
How about something like this? cfdirectory ... name=adirectory cfloop query=adirectory cffile action="" file=directory\#name# variable=afile cfset currentchar=1 cfloop condition=true cfset findopencfquery=refindnocase(cfquery[^]*,afile,currentchar,true) cfif not findcfquery.pos[1] cfbreak

RE: World Wide Web Publishing Service

2004-05-05 Thread Paul Kenney
What sometimes happens is that CF restarts (crashes?) and IIS is still running but cannot connect to the newly restared CF server.This might be a problem with the ISAPI filter, but you have to restart IIS to re-establish the connection to the CF server. It happens on my computer all the time and I

404 Trapping in CF

2004-05-05 Thread gfuller
I would like to send 404 errors from Apache 2 to a cfm template, and know the URL that the user entered.The first part works - I just put the following in httpd.conf: ErrorDocument 404 /test/router.cfm The ColdFusion template router.cfm is executed, but I can't get a handle on the URL that the

Serialize a series of tag calls?

2004-05-05 Thread Matt Robertson
I have four calls to a particular tag.Call it cf_foo.I want to run it like so from a calling template: cf_foo run=1st cf_foo run=2nd cf_foo run=3rd cf_foo run=4th Each instance of the tag makes a db entry as to its time of completion.I want thes entries to always be in the same sequence; one

RE: Serialize a series of tag calls?

2004-05-05 Thread Barney Boisvert
A given page request always runs serially, so you don't have to worry about forcing to run that way. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 4:07 PM To: CF-Talk Subject: Serialize a series of tag calls? I

RE: Serialize a series of tag calls?

2004-05-05 Thread Paul Kenney
Matt, The code is run sequencially from top to bottom anyways.Your locking really does nothing for you except disallow concurrent access by multiple requests. This does the same thing: cf_foo run=1ST cf_foo run=2ND cf_foo run=3RD cf_foo run=4TH Now, is this just one template that is called

RE: Serialize a series of tag calls?

2004-05-05 Thread Matt Robertson
Barney Boisvert wrote: A given page request always runs serially, so you don't have to worry about forcing to run that way. One thing I should have mentioned:Each tag call spawns a process that pings another server in a variety of ways (I'm working on a revision to my server monitor).So I'm

RE: Serialize a series of tag calls?

2004-05-05 Thread Matt Robertson
As I mentioned to Barney a moment ago, this is a task that is going to get an answer back from another server at varying times (a few seconds apart, at the *most*).Specifically, I am running a server monitor that is, in five separate calls, using cfhttp to test http, https and web mail (port 8383)

RE: Serialize a series of tag calls?

2004-05-05 Thread Barney Boisvert
I'm not real familiar with those tag's specific execution patterns, but I'm pretty sure that if you specify a timeout, the thread will block until the operation completes (either success or error), so you should still be safe. If that's not the case, then I don't know what the solution is.Locking

Re: Securing CF Apps against SQL Injection Cross Site Scripting

2004-05-05 Thread Andrew Grosset
I would like to emphasise reading Understanding the cause and effect of CSS (XSS) Vulnerabilities at http://www.technicalinfo.net/papers/CSS.html as recommended previously by Dave Watts. If you weren't paranoid about XSS before reading this article you might be after! Besides the obvious dangers

RE: ColdFusion Developer Edition

2004-05-05 Thread Vince Bonfanti
Some people consider PostgreSQL to be superior to SQL Server for some applications, even on their live box. Sorry, couldn't resist.;-) Vince -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 8:54 AM To: CF-Talk Subject: Re: ColdFusion

Re: Securing CF Apps against SQL Injection Cross Site Scripting

2004-05-05 Thread Andrew Grosset
I would like to emphasise reading Understanding the cause and effect of CSS (XSS) Vulnerabilities at http://www.technicalinfo.net/papers/CSS.html as recommended previously by Dave Watts. If you weren't paranoid about XSS before reading this article you might be after! Besides the obvious dangers

Re: Securing CF Apps against SQL Injection Cross Site Scripting

2004-05-05 Thread Matt Robertson
CodeCleaner is an absolutely fantastic tag.Runs like lightning.I use cfqueryparam but nonetheless I still scrub form inputs with it. What did you need to modify in CodeCleaner to make it scrub urls?I glanced at it very quickly and it seems like it'll take whatever you feed it. --

RE: Serialize a series of tag calls?

2004-05-05 Thread Matt Robertson
I think I may have found the source of my out of place db entries. I was sorting my report on time of completion, but the timestamp field I was using only has precision down to the 10th of a second.If I include the pk (numeric ID) field in the report and sort on that descending everything orders

Re: Securing CF Apps against SQL Injection Cross Site Scripting

2004-05-05 Thread Andrew Grosset
I'm checking to see whether the original input (attributes.input) is the same as the scrubbed result (tmp). If caller.check GT 0 then I email myself the details and throw them out to google! My theory being is if somebody is playing with the urls I don't want to show them the scrubbed result (in

RE: ColdFusion Developer Edition

2004-05-05 Thread Dave Watts
Some people consider PostgreSQL to be superior to SQL Server for some applications, even on their live box. Sure, but they're different things, and neither is a completely acceptable substitute for the other. Sorry, couldn't resist.;-) Neither could I, apparently. Dave Watts, CTO, Fig Leaf

RE: Serialize a series of tag calls?

2004-05-05 Thread Dave Watts
One thing I should have mentioned:Each tag call spawns a process that pings another server in a variety of ways (I'm working on a revision to my server monitor).So I'm using cfhttp for http and https operations, cfpop for pop3 tests and running a function that uses the service factory to

RE: Serialize a series of tag calls?

2004-05-05 Thread Paul Vernon
Matt, In the case of CF, the page request runs on a thread and all items in that page run within that thread therefore they are always sequential. However if you have a java or C++ extension that is in itself multi-threaded and can launch processes the whole thing becomes great fun but CF

Re: ColdFusion Developer Edition

2004-05-05 Thread Doug White
You can compare the features of each type of database at http://www.clickdoug.com/compare/featurecomparisons.htm == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions

What causes this error?

2004-05-05 Thread Jeff
I can't add a SQL datasource, and I'm doing everything *exactly* like I do at work...it's just my home machine, and I'm trying to get a datasource up and running. I've updated CFMX, the works...but for some reason, I get the following error...anything look familiar here that's just a quick fix?

<    1   2