Re: Including App.cfc in App.cfc

Will... In your first application.cfc you're going to create application.dsn, right? Along with this.name , yes? So your second application.cfc is going to have this.name as well, yes? And if it's the same string as the name in the first application.cfc, it's

Re: XML xmlText or Attributes

When it comes to using things like XSLT, XPath, and other things, using attributes becomes important. Really, in general you want attributes to describe the data that the xmlText contains, and you want to use your attributes to help you sort, filter, and extract your data. For instance, in an X

Re: Including App.cfc in App.cfc

>So your second application.cfc is going to have this.name >as well, yes? And if it's the same string as the >name in the first >application.cfc, it's going to be looking at the same application space as >the first one. A yes! I THOUGHT that might be a possibility, but hav

Re: Noob: getting a total from some CFOUTPUTted fields

Here's another way to do it: total: #arraysum(yourqueryname["order_value"])# Remember that query columns can be treated as arrays and you can use any array function on them. On 7/7/05, Chris Kavanagh <[EMAIL PROTECTED]> wrote: > Hey list! > > How's it going? My first app is running now. I cou

RE: Including App.cfc in App.cfc

>> -Original Message- >> From: Will Tomlinson [mailto:[EMAIL PROTECTED] >> Sent: Thursday, July 07, 2005 10:44 PM >> To: CF-Talk >> Subject: Including App.cfc in App.cfc >> >> If I have an Application.cfc in the site root, and it >> contains an >> APPLICATION.DSN variable, and there's an ad

Re: Including App.cfc in App.cfc

The Application.cfc in the nested directory will omit the Application.cfc code in the parent directory... this means that much of the code to set these variables would need to be duplicated in both cfc's. What I read (and I could be misinterpreting) is that he wanted a way to eliminate the need to

RE: Coldfusion Crashing!

Thanks a lot for all your help guys. After struggling two days/nights and done all the audit etc. I sort of gave up and upgraded to MX6.1. It hasn't really fixed the problem as such but the number of crashes has been significantly reduced. I've found out in the application, some third party calls t

RE: XML xmlText or Attributes

Thanks. This is consistent with how I've seen XML formed. Andy -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 4:40 PM To: CF-Talk Subject: RE: XML xmlText or Attributes I read an Eric Meyer, of CSS fame, quote on this that makes some sense

Re: OT: SQL count of rows from a union query

>>I just solved it using an ugly workaround. Indeed, unless you really need the count to occur in the query, it should be more efficient to make two separate queries and just add their record counts in CF. -- ___ REUSE CODE! Use custom tags; See http://www.c

RE: Application Planning

> I just got the e-mail too. As I mentioned in my earlier post, I've > already been using Fusebuilder. I'm just wondering if there may be > anything else out there that's better. What do you think is missing from FuseBuilder? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Com

Re: OT: SQL count of rows from a union query

Hey George, AFAIK, derived tables in T-SQL need an alias...try this: SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID )

RE: URL String and cfsavecontent

Try it directly (make sure it exists). -mk var myvar = _root.lid; var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { getUrl('Detail.cfm?task=1&LID=' + _root.lid, GET); } }

OT: Calling Parent Page in IFRAME - Cross Domai

Sorry for the OT. I have a problem where I have a page say on www.xyz.com , this page contains an iframe which has loaded a site www.abc.com. Is there anyway I can reference the parent page from the iframe (and from within the www.abc.com pages) without the Permission Denied error due to JS Secur

Flash Forms Newbie Question

I am using the following code on my very first Flash Form: Staff Member Jane Doe When I view the form, the drop drown box appears (even with only one item) but the text "Staff Member" does not show u

CF and SQL Server DTS - Dynamically

Has anyone done this before? I am using CFMX6.1 and MS SQL Server 7. I have a DTS package that exports data out of a table to a CSV file. Basically it uses a SQL query based on a "datecreated" field. This allows me to take anything that is 30 days or older and make a CSV out of it. Now, the big

RE: Flash Forms Newbie Question

To use flash forms with the format of flash you will have to use the "cfgroupitem" and other tags to get you HTML to show up. Remember, it generates a flash "movie" so you can't just mingle html and cfinput tags like you used to. -mk -Original Message- From: Claremont, Timothy [mailto:[EM

load balancing

Hi all, We are thinking of scaling our servers and are looking into load balancing. We have had load balancing done through a dedicated switch at one of the companies for a client earlier, but for various reasons we don't want to use them for this client. What are our options? Can we do load

Re: load balancing

We've recently gone live using Windows Load balancing on Windows 2003 Server and CFMX7 for out Intranet and about to go live with the same but CFMX7 Enterprise for our internet sites. It works just fine with CFMX - you're only load balancing port 80 at the end of the day. We're using client variab

RE: load balancing

We're on MX 6.1 right now. Is this possible with MX or do I need 7? Also do I need the enterprise version? Russ -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 12:18 PM To: CF-Talk Subject: Re: load balancing We've recently gone live using Wi

Re: Flash Forms Newbie Question

just use the label attribute in the cfselect to output "Staff Member" Claremont, Timothy wrote: >I am using the following code on my very first Flash Form: > >skin="haloBlue"> > > > > Staff Member > > > size="1" > message="You did not select a s

Coldfusion Switch Error - Hex Characters

Hello, I have an odd error with a piece of code I'm migrating from CF5 to MX6.1. It is a simple switch statement that takes Hex7 values as a string and spits out the ascii equivilent as a string. Problem is, it is reading hex value '00' and '0A' as the same thing, and returns a duplicate value e

Re: PreserveSingleQuotes Woes - Possible Bug?

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--- http://livedocs.macromedia.com/coldfusion/6.1/

Forms Advice

Hi, my website has a series of pictures that make up a hike - a photo gallery essentially. The photo's themselves should have two attributes 1) caption and 2) an available bit. Typically there are from 10 to 100 photos per hike instance. My previous way of handling things was to loop over ea

Re: Forms Advice

Couple other ideas: 1) make your page one large form, with field names like caption#imageId#, and then process them all when you submit. Going this route, I'd still probably page the gallery into batches of ten or so, just to make it more managable. 2) keep the per-image forms, but use JS Remoti

Re: OT: SQL count of rows from a union query

>>I think it's light years better than the union query There is still a union, and if the subqueries generate a long list, it must be pretty unefficient. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please

Re: PreserveSingleQuotes Woes - Possible Bug?

>>Is it just the way the function is written? Is this fixed in CF 7? I don't know, are you sure your application is run by CFMX ? 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

Data Binding on Forms

I have a form where the ultimate objective is to store the client number. So, I have a CFINPUT named txtClientNum and a CFSELECT named ClientNum Therefore, the data entry operator can enter EITHER the client number (into the CFINPUT) or choose the client name from a drop down list (CFSELECT). I

RE: load balancing

I ran a set of 4 Win 2k servers with CF 5 and Windows NLB. It's fine except for one thing If one CF instance crashes, port 80 on that server goes idle... The NLB load balancing is not application aware and therefore thinks that the idle server can stand some more load and so redirects all the

RE: load balancing

Isn't there some way to configure the NLB to hit a page (a cf page) to test if the server is up? -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 1:21 PM To: CF-Talk Subject: RE: load balancing I ran a set of 4 Win 2k servers with CF 5 and Window

Re: PreserveSingleQuotes Woes - Possible Bug?

>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 yo

Re: load balancing

John, What was your reason for not using client over j2ee session vars? -Adam On 7/8/05, John Beynon <[EMAIL PROTECTED]> wrote: > We've recently gone live using Windows Load balancing on Windows 2003 > Server and CFMX7 for out Intranet and about to go live with the same > but CFMX7 Enterprise f

Re: OT: SQL count of rows from a union query

Well, I'll be! It worked. This is the second time that this has happened to me where the absence of an alias has screwed things up. Thanks Joe! George On 7/8/05, Joe Rinehart <[EMAIL PROTECTED]> wrote: > Hey George, > > AFAIK, derived tables in T-SQL need an alias...try this: > > SELECT count(

Parsing XML problem

How do you parse out this kind of XML string? I need to find the value of aAccountNumber and bAddress: aAccountNumber X bAddress X I suppose if I could depend on the order of the Parameters, I could refer to the values like so: Parameter[1].ParameterValue.xmlText

Re: Including App.cfc in App.cfc

On 7/8/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > The Application.cfc in the nested directory will omit the > Application.cfc code in the parent directory... this means that much > of the code to set these variables would need to be duplicated in both > cfc's. What I read (and I could be misi

Re: Including App.cfc in App.cfc

I read that he wanted a way to insure that app-scope vars would exist at the right names across several separate folders. Or, you could do what Sean Corfield blogged about a while ago: /appProxy.cfc /Application.cfc extends="appProxy" /admin/Application.cfc extends="appProxy" That would, from a

Re: Application Planning

My only real beef with it is in regard to large application development. Once an application reaches a certain size, making changes can be a bit of a bear. In general though, I do like it and it is pretty solid. At the moment though, I'm curious to see what else is out there. Adalon, at face v

RE: Application Planning

> From: Anne Girardeau [mailto:[EMAIL PROTECTED] > Adalon, at face value, seems to be a pretty solid piece of software. > But I'm currently awaiting an evaluation license to see if it > offers any significant advantages over Fusebuilder. Anne, Contact Andrew J. Ibbotson over at Synthis. His e

Re: Parsing XML problem

On 7/8/05, Rebecca Wells <[EMAIL PROTECTED]> wrote: > How do you parse out this kind of XML string? I need to find the value > of aAccountNumber and bAddress: > > > aAccountNumber > X > > > bAddress > X > xPath to the rescue: aAccountNumber 12345 bAd

Re: Application Planning

Thanks! Actually I left a message on his voicemail earlier. Hopefully he'll get back to me before the end of the day. --Anne Michael T. Tangorre wrote: >>From: Anne Girardeau [mailto:[EMAIL PROTECTED] >>Adalon, at face value, seems to be a pretty solid piece of software. >>But I'm currently

RE: load balancing

> Isn't there some way to configure the NLB to hit a page (a cf page) to test > if the server is up? Nope :( The native CF5 Ent load balancing software had that facility but MS NLB doesn't It is the major drawback of the MS NLB implementation... Paul ~~

Re: Application Planning

Good luck. I've been waiting since Tuesday. My guess is that the 4th has morphed into a vacation week at Synthis. I'm hoping to hear something Monday. On 7/8/05, Anne Girardeau <[EMAIL PROTECTED]> wrote: > Thanks! Actually I left a message on his voicemail earlier. Hopefully > he'll get back to m

Re: Including App.cfc in App.cfc

Yeah, I was pretty much giving a basic example, using a DSN variable. I'll just need it to simply be available throughout the site and its directories. Thanks guys! Will ~| Logware (www.logware.us): a new and convenient web-b

Re: Application Planning

Lol, thanks for letting me know. I thought it seemed unusually difficult to get a hold of anyone there. --Anne Deanna Schneider wrote: >Good luck. I've been waiting since Tuesday. My guess is that the 4th >has morphed into a vacation week at Synthis. I'm hoping to hear >something Monday. > >On

Poor performing Oracle Query

What would be a good checklist to try and figure out why a query built by one of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ tool in the Oracle development suite? But when that same query is placed in a tag set, it takes 18 minutes to run! -- Ian S

Re: Application Planning

I was wondering if most of the US took the week offlist is kinda quiet this week ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems

Re: Poor performing Oracle Query

Ian Skinner wrote: > What would be a good checklist to try and figure out why a query built by one > of our Oracle DBAs runs in about 30 seconds when he runs it through the SQL+ > tool in the Oracle development suite? But when that same query is placed in > a tag set, it takes 18 minutes to ru

Remote forms

I have a client who wants to provide their clients access to a parts finder using data from their site but not hosting it. So I guess it would need to be platform independent. Any recommendations? It's nothing too complicated, just a series of drill down menus of about 5 items (multiple-select:

Re: Application Planning

W00t! I just got a call back from Andy Ibbotson. Apparently they're having a promotion right now and are offering Adalon for $750 per seat. --Anne Deanna Schneider wrote: >Good luck. I've been waiting since Tuesday. My guess is that the 4th >has morphed into a vacation week at Synthis. I'm ho

Re: Remote forms

AJAX. -Adam On 7/8/05, Doug Bedient <[EMAIL PROTECTED]> wrote: > I have a client who wants to provide their clients access to a parts finder > using data from their site but not hosting it. So I guess it would need to be > platform independent. Any recommendations? It's nothing too complicated,

Re: Remote forms

Okay. I've heard of it. Any good tutorials around? > AJAX. > > -Adam > > On 7/8/05, Doug Bedient <[EMAIL PROTECTED]> wrote: > > I have a client who wants to provide their clients access to a parts > finder using data from their site but not hosting it. So I guess it > would need to be platform

Re: Including App.cfc in App.cfc

In retrospect, Jared & Eddie's suggestions are better for general consumption. :) Although I will say that for a new app, using the onTap framework makes the issue moot due to its nested directory execution. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add feature

RE: Poor performing Oracle Query

I'm told about 10, but those ten are summations of a lot of data from some very large (100,000's of records) tables. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning -Original Message

Re: Poor performing Oracle Query

Does it run slow from SQLPlus when executed from the web server itself? For perhaps a "quick" fix I'd probably try throwing it into an SP and calling that to see if the delay in executing goes away. On 7/8/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > > I'm told about 10, but those ten are sum

RE: Poor performing Oracle Query

We're working on the SP version to see if that help. No it does not take nearly as long to run in SQLPlus, about 20 seconds, versus 18 minutes when run from a CF page. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run.

RE: Calling Parent Page in IFRAME - Cross Domai

Neil, >I have a problem where I have a page say on www.xyz.com , this page >contains >an iframe which has loaded a site www.abc.com. > >Is there anyway I can reference the parent page from the iframe (and from >within the www.abc.com pages) without the Permission Denied error due to JS >Security R

RE: Poor performing Oracle Query

Well we have more information on the problem. The query that was running fairly well at 30 seconds or so was being run against a validation database where the data is static. The query that was performing poorly at 18 minutes was being run against the production server where the data is very a

detect flash player 7 with CF?

Hi, Is there a way to detect flash Player 7 using CF? I want to use cfform, but so many of my customers don't have flash player 7 and don't have permissions to install them. So I want to detect if they have flash player 7. If they do, I would set format="flash". If they don't, I would set f

Re: Parsing XML problem

Thank you, Eddie. That helped me figure it out, but it turned out that I didn't need to use cfxml as I was already using xmlparse, but the rest of your code was spot on. Have a good weekend, if you haven't already started. >On 7/8/05, Eddie Awad wrote: > >xPath to the rescue: > > > > >aAccou

detect flash player 7 with CF?

Hi, Is there a way to detect flash Player 7 using CF? I want to use cfform, but so many of my customers don't have flash player 7 and don't have permissions to install them. So I want to detect if they have flash player 7. If they do, I would set format="flash". If they don't, I would set f

Re: detect flash player 7 with CF?

As you worded it, no, you can't do that, but you can do it with other ways: Use javascript to set a cookie with the value (JS-based flash sniffing is cake; there's a million scripts around), and then you can check the value of the cookie with CF when you're rendering your forms. If you need failo

Re: Poor performing Oracle Query

> The query that was performing poorly at 18 minutes was being run against the > production server where the data is very active. Apparently every time data > was being added to the main tables, this query would be started over. So > depending on the traffic sometime it performs relatively wel

RE: Poor performing Oracle Query

Does oracle have something similar to "with (nolock)" that SQL server has? This would just run the query and not wait if it can get a lock on all the tables.. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:15 PM To: CF-Talk Subject: RE: Poor p

Re: Parsing XML problem

> Thank you, Eddie. That helped me figure it out, but it turned out that I > didn't need to use cfxml as I was already using xmlparse, but the rest of > your code was spot on. Have a good weekend, if you haven't already started. I used only to test my code. I'm glad it was helpful. Have a nice

Re: Poor performing Oracle Query

> Does oracle have something similar to "with (nolock)" that SQL server has? > This would just run the query and not wait if it can get a lock on all the > tables.. In Oracle, If you're just "select"ing rows from tables, there should not be any locks issued on the rows unless you explicitly say "f

cf mx exception error messages

Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. "Error","jrpp-260","07/06/05","12:18:04",,"Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]

Re: load balancing

out of curisoity, are you using cfcharting at all? DK On 7/8/05, John Beynon <[EMAIL PROTECTED]> wrote: > > We've recently gone live using Windows Load balancing on Windows 2003 > Server and CFMX7 for out Intranet and about to go live with the same > but CFMX7 Enterprise for our internet sites.

cf mx exception error messages

Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am confused.Any help would be appreciated. "Error","jrpp-260","07/06/05","12:18:04",,"Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]

RE: cf mx exception error messages

What do you mean the page is missing? -Original Message- From: Dave Nixon [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:59 PM To: CF-Talk Subject: cf mx exception error messages Can anyone explain below why you get a SQL query error for a page that is possibly missing??? I am c

RE: Poor performing Oracle Query

There must be some way to tell oracle you want to read 'dirty' data. Are you using a cftransaction? Perhaps you need something like ? Russ -Original Message- From: Eddie Awad [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:41 PM To: CF-Talk Subject: Re: Poor performing Oracle Q

Re: Including App.cfc in App.cfc

On 7/8/05, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote: > Or, you could do what Sean Corfield blogged about a while ago: > > /appProxy.cfc > /Application.cfc extends="appProxy" > /admin/Application.cfc extends="appProxy" Almost... Check my blog: http://corfield.org/blog/index.cfm?do=b

Re: Remote forms

Rob Rohan's Neuromancer is a great AJAX implementation that pre-existed the AJAX terminology (other than the cleaning product, anyway). He's got tutorials and examples here: http://www.robrohan.com/projects/neuromancer/ Hope that helps... J On 7/8/05, Doug Bedient <[EMAIL PROTECTED]> wrote: >

Re: Including App.cfc in App.cfc

I suppose, depending on the needs of the specific application you could go either way. If your Application.cfc's all inherited from a specific ApplicationProxy.cfcthen you could make global changes easily without being forced to change the Application.cfc in your root. But, if you have one Applic

Re: Including App.cfc in App.cfc

I like the appProxy.cfc, but take a step further an put all those constants in an xml file that appProxy can parse. That way whoever is deploying your app or managing the server (even if its you) won't have to mess around with cf code. Then you can have seperate xml files for your different deploym

RE: cf mx exception error messages

>What do you mean the page is missing? > >-Original Message- >From: Dave Nixon [mailto:[EMAIL PROTECTED] >Sent: Friday, July 08, 2005 7:59 PM >To: CF-Talk >Subject: cf mx exception error messages > >Can anyone explain below why you get a SQL query error for a page that is >possibly missing

RE: cf mx exception error messages

I know that those pages are not there yet Thanks Dave >What do you mean the page is missing? > >-Original Message- >From: Dave Nixon [mailto:[EMAIL PROTECTED] >Sent: Friday, July 08, 2005 7:59 PM >To: CF-Talk >Subject: cf mx exception error messages > >Can anyone explain below why you

Re: cf mx exception error messages

CF sometimes gets a little weird with templates that once existed, but no longer exist. This is by design if you have the template cache enabled, but it can happen even with it off. Clear your cfclasses directory (inside WEB-INF) and restart and it'll probably go away. cheers, barneyb On 7/8/05

Re: Including App.cfc in App.cfc

On 7/8/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote: > I like the appProxy.cfc, but take a step further an put all those > constants in an xml file that appProxy can parse. Or use ColdSpring and have its bean factory manage the configuration based on XML files! -- Sean A Corfield -- http://corfie