FW: 2nd try: SQL query help
Anyone have any ideas? -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:00 AM To: CF-Talk Subject: OT: SQL query help Using SQL Server, how would I define a query to return ranges of ID's (primary key) where a tinyint field was not true? I'm looking for any ranges (eg; 12202 - 12249 and 14477 - 15225) where that tinyint field is 0. I'd like to specify a minimum number of records in that range, but it's not absolutely necessary. Something like: show me sequential ranges where myTinyint = 0 and total records in each range > 100 Any help is greatly appreciated! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2nd try: SQL query help
Sounds like a job for a stored procI don't think a simple query will do it for you. Get a good T-SQL book! Good luck. -- Josh Trefethen .:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. .::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 2:22 AM To: CF-Talk Subject: FW: 2nd try: SQL query help Anyone have any ideas? -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:00 AM To: CF-Talk Subject: OT: SQL query help Using SQL Server, how would I define a query to return ranges of ID's (primary key) where a tinyint field was not true? I'm looking for any ranges (eg; 12202 - 12249 and 14477 - 15225) where that tinyint field is 0. I'd like to specify a minimum number of records in that range, but it's not absolutely necessary. Something like: show me sequential ranges where myTinyint = 0 and total records in each range > 100 Any help is greatly appreciated! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application.cfm not being included / CFMX
If it is a Unix server your file should be "Application.cfm", the capitalization is important. Even if it isn't a *nix server, you should still name the file Application.cfm :) Jeremy -- Jeremy Allen Application Architect elliptIQ Inc. [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2nd try: SQL query help
Quoting Josh Trefethen <[EMAIL PROTECTED]>: > > Sounds like a job for a stored procI don't think a simple query will > do it for you. Simple was not a requirement. I just hope performance is not a requirement either ;-) SELECT MIN(t1id) AS minimum, t2id AS maximum, MAX(occurences) AS occurences FROM( SELECT t1id, MAX(t2id) AS t2id, MAX(occurences) AS occurences FROM( SELECT t1.id AS t1id, t2.id as t2id, count(t3.id) + 2 as occurences FROM test t1, test t2, test t3 WHERE t1.id < t3.id AND t2.id > t3.id AND t1.myTinyint = 0 AND t2.myTinyint = 0 AND t3.myTinyint = 0 GROUP BY t1.id, t2.id HAVING COUNT(t3.id) > 5 -- Fill out (minimum count - 2) AND COUNT(t3.id) = t2.id -1 -t1.id ) AS sub GROUP BY t1id ) AS sup GROUP BY t2id Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: "Discovering CFC's" - confusion in 'Making Use of the Supertype'
I guess this is aimed at Hal Helms and the Techspedition people... I've been to your site and found no errata on an apparent error I've found in "Discovering CFC's". I'm liking the book so far, being intermediate to advanced in ColdFusion, but lost (until now! ;-) with OO programming. Anyway, I've got to the chapter "Making Use of the Supertype", and on pp. 66-67, I've lost the thread. I may well be missing something, but when it says (para 162) "Note that the first code to execute is the definition of a new object, super..." - I can't see any mention of "super" in the preceding code at all. I can only see a reference in the Java code on p. 65. I think I can vaguely see what the code and the text are trying to get at together, but it's only guessing because, as I said, I'm very new to OO. Is there an error in the book here or am I just plain missing something? Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: "Discovering CFC's" - confusion in 'Making Use of the Supertype'
OK, I'm close to the end of the chapter and I think I've got my head around the "super" workaround being detailed. Looking back, I think the text and code around p.67 are just jumbled in a couple of ways: - The use of the word "super" is a bit misleading. I'm guessing it's meant as a reminder that the described code is a workaround "manual" implementation of the OO "super" concept, but it comes across as a bit literal, esp. in references to and . - The subType argument seems to be implemented for the Pitcher.cfc new() method on pp. 66/67, when it actually being introduced here as "mystery code" added to the Ballplayer.cfc new() method (p. 68). If I'm really misinterpreting this, do let me know - otherwise, please bear in mind for 2nd edition! ;-) Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2nd try: SQL query help
Jochem - you are a rock star - thanks for this! Performance is not an issue - I can run this once or twice a month late, late at night :) -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 12:04 PM To: CF-Talk Subject: RE: 2nd try: SQL query help Quoting Josh Trefethen <[EMAIL PROTECTED]>: > > Sounds like a job for a stored procI don't think a simple query will > do it for you. Simple was not a requirement. I just hope performance is not a requirement either ;-) SELECT MIN(t1id) AS minimum, t2id AS maximum, MAX(occurences) AS occurences FROM( SELECT t1id, MAX(t2id) AS t2id, MAX(occurences) AS occurences FROM( SELECT t1.id AS t1id, t2.id as t2id, count(t3.id) + 2 as occurences FROM test t1, test t2, test t3 WHERE t1.id < t3.id AND t2.id > t3.id AND t1.myTinyint = 0 AND t2.myTinyint = 0 AND t3.myTinyint = 0 GROUP BY t1.id, t2.id HAVING COUNT(t3.id) > 5 -- Fill out (minimum count - 2) AND COUNT(t3.id) = t2.id -1 -t1.id ) AS sub GROUP BY t1id ) AS sup GROUP BY t2id Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server reinstall and CF
Several months ago, I installed the SQL Server trial version in anticipation of doing more development work from home for my former employer. I went through the process of re-creating their database on my local server (with 100+ tables). (by the way, you're not given any warning when your 120 day trial period is about to end, and once it ends, you're apparently SOL accessing those databases until you buy a version of SQL Server) I bought the Developer edition and installed it over the trial version. During that installation process, at the step when you're choosing "Windows Authentication" or "Mixed Mode" I couldn't recall which way I had done it before, so I chose Windows Auth. The install went seemingly ok. The CFMX Admin was still able to verify the DSN without any problems. However, when I go to a page on my machine to access a table, I get an "Invalid object name" for any table in the DB. I assume this is because I used Mixed Mode before and was using SQL Server authentication with a cf_user. I've gone into and changed the Server's registration to allow mixed mode to use SQL Authentication. The user logs in ok. I've changed the ODBC DSN info to allow the same thing. However, I still get "Invalid Object Name". Then, when I reload the page, I get: "The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null pointers are another name for undefined values." And, that seems to hose the entire server, forcing a restart. Any suggestions on how to fix this or what the real problem actually is? --- Scott Brady http://www.scottbrady.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Obvious cfscript ?
New to monkeying with cfscript...and must be missing the obvious today: This is not resolving...meaning form.d_price[i] resolves as form.d_price rather than form.d_price1 in the first loop. for (i=1; i LTE form.clientloop; i = i +1) line_total[i] = form.d_price[i] * form.qty[i]; What am I forgetting? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server reinstall and CF
Just an update . . . I found that if I rename these tables as backups and then export them into their original name (essentially creating new tables), it works ok. However, there are 110+ tables in this database, and I'd rather not have to do that for every table. Scott --- Scott Brady http://www.scottbrady.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: "Discovering CFC's" - confusion in 'Making Use of the Supertype'
> - The use of the word "super" is a bit misleading. I'm guessing it's meant > as a reminder that the described code is a workaround "manual" > implementation of the OO "super" concept, but it comes across as a bit > literal, esp. in references to and component="#super#" ... >. Yeah I found that confusing too. Hunted around for the word "super" in the code and wondered if it was a mistake. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Server reinstall and CF
> (by the way, you're not given any warning when your > 120 day trial period is about to end, and once it ends, > you're apparently SOL accessing those databases until > you buy a version of SQL Server) You can always copy the databases to another SQL Server machine, and attach them. > I bought the Developer edition and installed it over > the trial version. During that installation process, > at the step when you're choosing "Windows Authentication" > or "Mixed Mode" I couldn't recall which way I had done it > before, so I chose Windows Auth. The install went seemingly > ok. The CFMX Admin was still able to verify the DSN > without any problems. To use the Type 4 MS SQL Server JDBC driver, you'll need to configure your database server to use Mixed Mode authentication. You can do this without reinstalling it, though. Just go into Enterprise Manager, right-click on your server, select "Properties", go to the "Security" tab, then select "SQL Server and Windows" under "Authentication". I'm pretty sure you'll also need to use TCP/IP connectivity. By default, that's enabled, but if you disabled it for some reason, you'll need to enable it within the Server Network Utility within the "Microsoft SQL Server" menu group. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Obvious cfscript ?
1. The form variable is a structure, not an array. 2. You can look over the variable "fieldnames" which is a list of all form fields sent. What formfields are being sent? More than one d_price? > New to monkeying with cfscript...and must be missing the obvious today: > > This is not resolving...meaning form.d_price[i] resolves as form.d_price > rather than form.d_price1 in the first loop. > > for (i=1; i LTE form.clientloop; i = i +1) > line_total[i] = form.d_price[i] * form.qty[i]; > > > What am I forgetting? > > Regards, > > Eric J Hoffman > DataStream Connexion > www.datastreamconnexion.com > Delivering Creative Data Solutions > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Obvious cfscript ?
You appear to be referring to an array in the form scope. Perhaps this is what you want: line_total[i] = form["d_price#i#"] * form["qty#i#"]; Regards, Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: "Eric Hoffman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 7:41 AM Subject: Obvious cfscript ? > New to monkeying with cfscript...and must be missing the obvious today: > > This is not resolving...meaning form.d_price[i] resolves as form.d_price > rather than form.d_price1 in the first loop. > > for (i=1; i LTE form.clientloop; i = i +1) > line_total[i] = form.d_price[i] * form.qty[i]; > > > What am I forgetting? > > Regards, > > Eric J Hoffman > DataStream Connexion > www.datastreamconnexion.com > Delivering Creative Data Solutions > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Obvious cfscript ?
Try for (i=1; i LTE form.clientloop; i = i +1) line_total[i] = form.["d_price" & i] * form.qty[i]; HTH -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 2, 2003 18:42 To: CF-Talk Subject: Obvious cfscript ? New to monkeying with cfscript...and must be missing the obvious today: This is not resolving...meaning form.d_price[i] resolves as form.d_price rather than form.d_price1 in the first loop. for (i=1; i LTE form.clientloop; i = i +1) line_total[i] = form.d_price[i] * form.qty[i]; What am I forgetting? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PCodeRuntimeContextImp::executeSQL
> Anyone want to take a shot at why this query throws a > PCCode error every once in a while? CF5... > > > cachedafter="01/01/01"> > select *, lower(keywords) as l_keywords > from v_products > where WebStoreID = #request.webStoreID# > Maybe it has to do with the caching? I've occasionally seen some weird errors relating to query caching. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Obvious cfscript ?
I am sending 12 d_price all sequentially numbered...trying to learn how handle such...and there are 25 other fields coming with it... :-) Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 1:04 PM To: CF-Talk Subject: Re: Obvious cfscript ? 1. The form variable is a structure, not an array. 2. You can look over the variable "fieldnames" which is a list of all form fields sent. What formfields are being sent? More than one d_price? > New to monkeying with cfscript...and must be missing the obvious > today: > > This is not resolving...meaning form.d_price[i] resolves as > form.d_price rather than form.d_price1 in the first loop. > for (i=1; i LTE form.clientloop; i = i +1) > line_total[i] = form.d_price[i] * form.qty[i]; > > > What am I forgetting? > > Regards, > > Eric J Hoffman > DataStream Connexion > www.datastreamconnexion.com > Delivering Creative Data Solutions > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Obvious cfscript ?
This seems to have me on the right trackthanks a million! Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 1:07 PM To: CF-Talk Subject: Re: Obvious cfscript ? You appear to be referring to an array in the form scope. Perhaps this is what you want: line_total[i] = form["d_price#i#"] * form["qty#i#"]; Regards, Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: "Eric Hoffman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 7:41 AM Subject: Obvious cfscript ? > New to monkeying with cfscript...and must be missing the obvious > today: > > This is not resolving...meaning form.d_price[i] resolves as > form.d_price rather than form.d_price1 in the first loop. > for (i=1; i LTE form.clientloop; i = i +1) > line_total[i] = form.d_price[i] * form.qty[i]; > > > What am I forgetting? > > Regards, > > Eric J Hoffman > DataStream Connexion > www.datastreamconnexion.com > Delivering Creative Data Solutions > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Obvious cfscript ?
Try one of these. // Using the fieldnames list for(field=1;field LTE listlen(fieldnames), field=field+1) { if (listgetat(fieldnames, field) contains "d_price") { do d_price work using listgetat value } } // using the form structure for (field in form) { if (field contains "d_price") { do d_price work using form[field] } } > I am sending 12 d_price all sequentially numbered...trying to learn how > handle such...and there are 25 other fields coming with it... :-) > > > Regards, > > Eric J Hoffman > DataStream Connexion > www.datastreamconnexion.com > Delivering Creative Data Solutions > > -Original Message- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 02, 2003 1:04 PM > To: CF-Talk > Subject: Re: Obvious cfscript ? > > > > 1. The form variable is a structure, not an array. > 2. You can look over the variable "fieldnames" which is a list of all > form fields sent. What formfields are being sent? More than one d_price? > > > New to monkeying with cfscript...and must be missing the obvious > > today: > > > > This is not resolving...meaning form.d_price[i] resolves as > > form.d_price rather than form.d_price1 in the first loop. > > for (i=1; i LTE form.clientloop; i = i +1) > > line_total[i] = form.d_price[i] * form.qty[i]; > > > > > > What am I forgetting? > > > > Regards, > > > > Eric J Hoffman > > DataStream Connexion > > www.datastreamconnexion.com > > Delivering Creative Data Solutions > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: "Discovering CFC's" - confusion in 'Making Use of the Supertype'
Thank goodness, I did that too and thought I was just a bit inept. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 10:57 AM To: CF-Talk Subject: Re: SOT: "Discovering CFC's" - confusion in 'Making Use of the Supertype' > - The use of the word "super" is a bit misleading. I'm guessing it's meant > as a reminder that the described code is a workaround "manual" > implementation of the OO "super" concept, but it comes across as a bit > literal, esp. in references to and component="#super#" ... >. Yeah I found that confusing too. Hunted around for the word "super" in the code and wondered if it was a mistake. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
> Is there any way to use the "check that file exists" > setting in IIS while using SES URL's. > > Example: http:www.mysite.com/index.cfm/fuseaction/display/ No, I don't think so, since the file doesn't actually exist! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFPOP
Hi, I have written a script which checks for AutoResponders on the Mail Server and if found, deletes it from there. But there is some problem with the problem while deleting the messages. Like if you delete first messages and the last message it gives error. Following is a copy of the script: . Script . Message Headers in Your Inbox No. of Records: #GetHeaders.RecordCount# Row: #currentRow#: From: #From# -- Subject: #Subject# #currentRow# #currentRow# Deleted #GetHeaders.RecordCount# . Script . Could you please help me. Regards. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFPOP
By the way, I am using CF 5.0 Pro. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
Yikes - that would mean we would have to recode basically every app we have ever made that has and web accessible admin directory. Do you think it would be safe to use a cold fusion scripted login routine instead of ACL's and WIndows Authentication. I recall seeing recently that web based admin's getting hacked was one of the top security vulnerabilities with web apps. Does anyone know how this exploit is exploited? What context is the CFM template executed under? Is the application.cfm file still executed? Brook At 03:14 PM 2/2/2003 -0500, you wrote: > > Is there any way to use the "check that file exists" > > setting in IIS while using SES URL's. > > > > Example: http:www.mysite.com/index.cfm/fuseaction/display/ > >No, I don't think so, since the file doesn't actually exist! > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using CF to pull content from with tags for printing
Hello list - I have been messing with this- but I do not know how to complete a few aspects. I would like to control printing from a webpage that heavily uses CSS styles and positioning for layers. What I would like to do is supply a print button - on click - it would launch a 2nd window - and tag all the content from within a div tag OR a custom tag I put in like... So I would use CF to grab all text within that section ( and it's styles ) and dynamically write that to a printed page that has a special high quality logo, address and header information. Any help is GREATLY appreciated. The long route I can replace all content with an include template - and completely seperate content from html tags - BUT that would require a fair amount of work on the site AND there are cases where due to formating - I can't include all content on 1 include file. But IF I could use this - it would be great - because the pop up template would have a header and a footer - with the content include in the middle - so that should give the picture. Thanks!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
[EMAIL PROTECTED] wrote: > Yikes - that would mean we would have to recode basically every app we have > ever made that has and web accessible admin directory. Do you think it > would be safe to use a cold fusion scripted login routine instead of ACL's > and WIndows Authentication. If you can write a decent login it should be no problem. > Does anyone know how this exploit is exploited? What context is the CFM > template executed under? Is the application.cfm file still executed? Think of it as a priorities issue. Until CF MX the priority of the IIS security filter was higher as the priority of CF, so first the IIS security was checked and then the control was passed on to the CF Service. Now with CF MX the priority of the filter that intercepts for CF MX and and redirects them to CF MX is higher as the priority of the IIS Security filter. So the request is passed on to the CF MX service before IIS security settings are checkd. But it is still a normal request, and all the normal ACL rules still apply. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using CF to pull content from with tags for printing
Jason Miller wrote: > > I would like to control printing from a webpage that heavily uses CSS > styles and positioning for layers. > > What I would like to do is supply a print button - on click - it would > launch a 2nd window - and tag all the content from within a div tag OR a > custom tag I put in like... > > > > So I would use CF to grab all text within that section ( and it's styles > ) and dynamically write that to a printed page that has a special high > quality logo, address and header information. That sounds like quite a lot of work. Why not provide page that works for both monitor and printer? http://www.alistapart.com/stories/goingtoprint/ Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
If the ACL's rules still apply, are they enough to use to restrict access? At 10:42 PM 2/2/2003 +0100, you wrote: >[EMAIL PROTECTED] wrote: > > Yikes - that would mean we would have to recode basically every app we > have > > ever made that has and web accessible admin directory. Do you think it > > would be safe to use a cold fusion scripted login routine instead of ACL's > > and WIndows Authentication. > >If you can write a decent login it should be no problem. > > > > Does anyone know how this exploit is exploited? What context is the CFM > > template executed under? Is the application.cfm file still executed? > >Think of it as a priorities issue. Until CF MX the priority of the IIS >security filter was higher as the priority of CF, so first the IIS >security was checked and then the control was passed on to the CF Service. >Now with CF MX the priority of the filter that intercepts for CF MX and >and redirects them to CF MX is higher as the priority of the IIS >Security filter. So the request is passed on to the CF MX service before >IIS security settings are checkd. But it is still a normal request, and >all the normal ACL rules still apply. > >Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using CF to pull content from with tags for printing
Does it have to be in a pop-up window for some reason or can you just use existing CSS functionality to control what gets printed? Ken -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 7:43 PM To: CF-Talk Subject: Using CF to pull content from with tags for printing Hello list - I have been messing with this- but I do not know how to complete a few aspects. I would like to control printing from a webpage that heavily uses CSS styles and positioning for layers. What I would like to do is supply a print button - on click - it would launch a 2nd window - and tag all the content from within a div tag OR a custom tag I put in like... So I would use CF to grab all text within that section ( and it's styles ) and dynamically write that to a printed page that has a special high quality logo, address and header information. Any help is GREATLY appreciated. The long route I can replace all content with an include template - and completely seperate content from html tags - BUT that would require a fair amount of work on the site AND there are cases where due to formating - I can't include all content on 1 include file. But IF I could use this - it would be great - because the pop up template would have a header and a footer - with the content include in the middle - so that should give the picture. Thanks!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using CF to pull content from with tags for printing
>That sounds like quite a lot of work. Why not provide page >that works for both monitor and printer? >http://www.alistapart.com/stories/goingtoprint/ Not sure if they address anything that Eric's article doesn't, but here's a couple of other articles I had bookmarked from Evolt: Kissing Print Versions of Pages Goodbye http://www.evolt.org/article/Kissing_Print_Versions_of_Pages_Goodbye/20/ 5/index.html Printing with style http://www.evolt.org/article/Printing_with_style/17/26318/index.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
[EMAIL PROTECTED] wrote: > If the ACL's rules still apply, are they enough to use to restrict access? Could you elaborate? What do you want to do? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PCodeRuntimeContextImp::executeSQL
Does the database understand the date? With Oracle we have to use to_char or to_date (I forget at the moment). Chris Norloff -- Original Message -- From: Dave Watts <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Sun, 2 Feb 2003 14:31:28 -0500 >> Anyone want to take a shot at why this query throws a >> PCCode error every once in a while? CF5... >> >> >> > cachedafter="01/01/01"> >> select *, lower(keywords) as l_keywords >> from v_products >> where WebStoreID = #request.webStoreID# >> > >Maybe it has to do with the caching? I've occasionally seen some weird >errors relating to query caching. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
Well, for an administrative tools directory, off the root of a site. If the ACL's deny access to the IUSR account, any unauthenticated user is prompted to enter their username/password to access the cfm files within that directory (or if the files them self have these ACL's). Is that enough security for a password protected directory. An attacker would still have to guess/brute force the password to gain access to those files/directories right? Brook At 11:18 PM 2/2/2003 +0100, you wrote: >[EMAIL PROTECTED] wrote: > > If the ACL's rules still apply, are they enough to use to restrict access? > >Could you elaborate? What do you want to do? > >Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using CF to pull content from with tags for printing
We are doing this using the cfimport feature of CFMX. We also do things like print the actual URL of a link in brackets next to a link in the print version automatically (something that surprisingly is also theoretically possible with CSS). This is done using something like (the key is the blank prefix). Then in the htmltags folder you have a tag for each HTML (or other) tag you want to process. It rather depends how your system works though. If you are dealing with a lot of static pages, you might be better off with adding a print stylesheet. > -Original Message- > From: Jason Miller [mailto:[EMAIL PROTECTED]] > Sent: Monday, 3 February 2003 1:43 p.m. > To: CF-Talk > Subject: Using CF to pull content from with tags for printing > > > Hello list - > I have been messing with this- but I do not know how to > complete a few > aspects. > > I would like to control printing from a webpage that heavily > uses CSS > styles and positioning for layers. > > What I would like to do is supply a print button - on click - > it would > launch a 2nd window - and tag all the content from within a > div tag OR a > custom tag I put in like... > > > > So I would use CF to grab all text within that section ( and > it's styles > ) and dynamically write that to a printed page that has a > special high > quality logo, address and header information. > > Any help is GREATLY appreciated. > > The long route I can replace all content with an include > template - and > completely seperate content from html tags - BUT that would require a > fair amount of work on the site AND there are cases where due to > formating - I can't include all content on 1 include file. > But IF I could use this - it would be great - because the pop up > template would have a header and a footer - with the content > include in > the middle - so that should give the picture. > Thanks!! > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
[EMAIL PROTECTED] wrote: > Well, for an administrative tools directory, off the root of a site. If the > ACL's deny access to the IUSR account, any unauthenticated user is prompted > to enter their username/password to access the cfm files within that > directory (or if the files them self have these ACL's). It is my understanding that unless you switch on "Check that file exists" nobody is asked for their u/p. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
I don't see that happening. I am still prompted for a u/p. Maybe because the server does not have Updater 2 installed. I'll doublecheck - thanks. brook At 01:12 AM 2/3/2003 +0100, you wrote: >[EMAIL PROTECTED] wrote: > > Well, for an administrative tools directory, off the root of a site. If > the > > ACL's deny access to the IUSR account, any unauthenticated user is > prompted > > to enter their username/password to access the cfm files within that > > directory (or if the files them self have these ACL's). > >It is my understanding that unless you switch on "Check that file >exists" nobody is asked for their u/p. > >Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Slow Update
Hello Forum, I am trying to update an access database using a CF template which is taking ages for the job. No error is generated. When I try to accomplish the same job within Access by running a Macro (SQL Query) it takes less than half a minute for thesame job. Other CF pages with queries run without any problem. Any ideas what is happening? Where should I start looking. Regards, Srimanta > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Slow Update
Can you post the code you are using. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper -Original Message- From: DESIGN SHOP [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 1:45 PM To: CF-Talk Subject: Slow Update Hello Forum, I am trying to update an access database using a CF template which is taking ages for the job. No error is generated. When I try to accomplish the same job within Access by running a Macro (SQL Query) it takes less than half a minute for thesame job. Other CF pages with queries run without any problem. Any ideas what is happening? Where should I start looking. Regards, Srimanta > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strip characters?
Is there a clean and easy way to simply strip all characters from a field...so only integers remain? A custom tag or popular reg ex before I reinvent the wheel? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Slow Update
can we see your code? - Original Message - From: "DESIGN SHOP" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 4:44 PM Subject: Slow Update > Hello Forum, > > I am trying to update an access database using a CF template which is taking > ages for the job. No error is generated. > When I try to accomplish the same job within Access by running a Macro (SQL > Query) it takes less than half a minute for thesame job. Other CF pages with > queries run without any problem. > Any ideas what is happening? Where should I start looking. > > Regards, > > Srimanta > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Slow Update(SOLVED)
Thanks Just tried the code on a seperate machine after compacting the database. Worked like breeze. KR Srimanta - Original Message - From: Mike Brunt <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Sunday, February 02, 2003 5:11 PM Subject: RE: Slow Update > Can you post the code you are using. > > Kind Regards - Mike Brunt > Webapper Services LLC > Web Site http://www.webapper.com > Blog http://www.webapper.net > > Webapper > > -Original Message- > From: DESIGN SHOP [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 1:45 PM > To: CF-Talk > Subject: Slow Update > > Hello Forum, > > I am trying to update an access database using a CF template which is taking > ages for the job. No error is generated. > When I try to accomplish the same job within Access by running a Macro (SQL > Query) it takes less than half a minute for thesame job. Other CF pages with > queries run without any problem. > Any ideas what is happening? Where should I start looking. > > Regards, > > Srimanta > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strip characters?
rereplace(form.field, "[^0-9]+", "", "all") > -Original Message- > From: Eric Hoffman [mailto:[EMAIL PROTECTED]] > Sent: Monday, 3 February 2003 2:22 p.m. > To: CF-Talk > Subject: Strip characters? > > > Is there a clean and easy way to simply strip all characters from a > field...so only integers remain? A custom tag or popular reg > ex before > I reinvent the wheel? > > Regards, > > Eric J Hoffman > DataStream Connexion > www.datastreamconnexion.com > Delivering Creative Data Solutions > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strip characters?
Doom of the clan of RegEx ninjas says: string = rereplace(string, '[^[:digit:]]', '', 'all'); grashopper. To train at the Dojo of the Regex: http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21 -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Eric Hoffman [mailto:[EMAIL PROTECTED]] : Sent: Sunday, February 02, 2003 8:22 PM : To: CF-Talk : Subject: Strip characters? : : : Is there a clean and easy way to simply strip all characters from a : field...so only integers remain? A custom tag or popular reg ex before : I reinvent the wheel? : : Regards, : : Eric J Hoffman : DataStream Connexion : www.datastreamconnexion.com : Delivering Creative Data Solutions : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strip characters?
HTH -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 3, 2003 1:22 To: CF-Talk Subject: Strip characters? Is there a clean and easy way to simply strip all characters from a field...so only integers remain? A custom tag or popular reg ex before I reinvent the wheel? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strip characters?
#blah# - Original Message - From: "Eric Hoffman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 02, 2003 8:21 PM Subject: Strip characters? > Is there a clean and easy way to simply strip all characters from a > field...so only integers remain? A custom tag or popular reg ex before > I reinvent the wheel? > > Regards, > > Eric J Hoffman > DataStream Connexion > www.datastreamconnexion.com > Delivering Creative Data Solutions > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strip characters?
REReplace(string, "[^0-9]","","ALL") -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 7:22 PM To: CF-Talk Subject: Strip characters? Is there a clean and easy way to simply strip all characters from a field...so only integers remain? A custom tag or popular reg ex before I reinvent the wheel? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Updater2 FYI
I just installed the 2nd Updater. Started getting a funny error on this line of code: It used to work (CFMX - updater1), but now it seems that it does not , but this does: Just FYI, Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
alternate MX debug layouts?
Has anyone built a MX debug template that plays nice with layer based designs you wouldn't mind sharing? -- mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: alternate MX debug layouts?
man, you aint kidding. im amazed that we have to have this never-ending scrolling right debug layout...WHY and no, the popup window doesnt suffice either :) waaa wahhh wa tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 9:52 PM To: CF-Talk Subject: alternate MX debug layouts? Has anyone built a MX debug template that plays nice with layer based designs you wouldn't mind sharing? -- mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Invalid Object
This past weekend, I upgraded our server. I reinstalled ColdFusion MX, so reattached our MSSQL databases. Now when I try and perform ANY query on ANY database, I get this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'securityUsers'. The datasource verifies just fine in the Administrator section, and I can use the SQL Builder tool from within Homesite+. Any idea what this error is and how to fix it? Thanks. Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invalid Object
oi Cedric!! have you tried rebuilding those databases? A mate of mine had the same problem. He created new db's and imported all his info from the old and all worked fine. Genius I say. Critz Sunday, February 2, 2003, 10:25:23 PM, you wrote: CV> This past weekend, I upgraded our server. I reinstalled ColdFusion MX, so CV> reattached our MSSQL databases. Now when I try and perform ANY query on ANY CV> database, I get this error: CV> Error Executing Database Query. CV> [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name CV> 'securityUsers'. CV> The datasource verifies just fine in the Administrator section, and I can CV> use the SQL Builder tool from within Homesite+. Any idea what this error is CV> and how to fix it? Thanks. CV> Cedric CV> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Invalid Object
> This past weekend, I upgraded our server. I reinstalled > ColdFusion MX, so reattached our MSSQL databases. Now > when I try and perform ANY query on ANY database, I get > this error: > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid > object name 'securityUsers'. > > The datasource verifies just fine in the Administrator > section, and I can use the SQL Builder tool from within > Homesite+. Any idea what this error is and how to fix > it? Thanks. I think that the most common cause for this is that the database name isn't specified in the datasource, in which case the default database for the login (which is often the master database) is where the database server looks for the tables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Array and Query Length
Can someone please tell me how an array or query stored in a session varible can be one length at the end of on page, then another length at the top of the next page? I have an array and query (tried same thing two different ways) with an arrayLen() and Query.Recordcount at the top of an application page and the end of a OnRequestEnd page. One row gets added to either just fine, but on the top of the next page the array or query has ANOTHER row added two it. Yes, a duplicate row, but after the page has been returned to the client browser. I have tested this on 2 CFMX boxes and one CF5 box, so I know that it is not a server issue. But, after having two other people look at my code, and not being able to explain how this is happening, I NEED HELP!!! Anyone that is willing to assist, I will be greatly appreciative. Christian Watt Webmaster SkillPath/CompuMaster Seminars [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: 2nd ColdFusion MX updater now available.
Softly, softly it comes. Note: Updater releases are cumulative, therefore, Updater 2 includes all fixes from Updater 1. You do not have to install Updater 1 before you install Updater 2. Grab it at http://www.macromedia.com/software/coldfusion/downloads/ == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: (02) 6213 6731 Mobile: 0439 401 823 Facsimile: (02) 6213 7287 ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Array and Query Length
> Can someone please tell me how an array or query stored > in a session variable can be one length at the end of on > page, then another length at the top of the next page? > > I have an array and query (tried same thing two different > ways) with an arrayLen() and Query.Recordcount at the top > of an application page and the end of a OnRequestEnd page. > One row gets added to either just fine, but on the top of > the next page the array or query has ANOTHER row added two > it. Yes, a duplicate row, but after the page has been > returned to the client browser. > > I have tested this on 2 CFMX boxes and one CF5 box, so I > know that it is not a server issue. But, after having two > other people look at my code, and not being able to explain > how this is happening, I NEED HELP!!! > > Anyone that is willing to assist, I will be greatly > appreciative. It sounds like the code that you think is supposed to run once, is in fact running twice. You might want to post your code in its entirety here, and see if anyone can help then. If you can build a simple test case (removing any extraneous code that doesn't directly have to do with your problem), that might also be helpful. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
> It is my understanding that unless you switch on "Check > that file exists" nobody is asked for their u/p. This is not necessarily the case. I've been successfully using web server authentication (both Basic and Windows Authentication) with IIS 5 and CFMX. I suspect that it has to do with the way that the JRun connector is configured. On my test machine, I'm using the ISAPI extension. I suspect that if I instead used the ISAPI filter, I'd run into the problem, but don't have time to test that theory right now. Oddly enough, since installing Updater 2, I can't run wsconfig.exe to configure the connector. If I try, I get this: Exception in thread "main" java.lang.NoSuchMethodError: jrunx.connectorinstaller.CIUtil.unquoteString(Ljava/lang/String;)Ljava/lang/ String; at jrunx.connectorinstaller.PropertyFileEditor.nextFullEntry(PropertyFileEditor .java:96) at jrunx.connectorinstaller.gui.ConfigFrame.getConfigList(ConfigFrame.java:191) at jrunx.connectorinstaller.gui.ConfigFrame.getConfigPanel(ConfigFrame.java:132 ) at jrunx.connectorinstaller.gui.ConfigFrame.(ConfigFrame.java:90) at jrunx.connectorinstaller.gui.ConfigFrame.run(ConfigFrame.java:384) at jrunx.connectorinstaller.ConnectorInstaller.main(ConnectorInstaller.java:536 ) When I run wsconfig.jar directly, it displays the wsconfig GUI, but won't allow me to configure any web servers. I imagine that it might work if run with command-line parameters. If any Macromedia people want to shed more light on the nature of the IIS authentication problem, I'd appreciate it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: 2nd ColdFusion MX updater now available.
This has been out since mid December 2002. Is there a new one? I didn't see it.. Brook At 04:09 PM 2/3/03 +1100, you wrote: >Softly, softly it comes. > >Note: Updater releases are cumulative, therefore, Updater 2 includes all >fixes from Updater 1. You do not have to install Updater 1 before you >install Updater 2. > >Grab it at http://www.macromedia.com/software/coldfusion/downloads/ > >== >Peter Tilbrook >Internet Applications Developer >Australian Building Codes Board >GPO Box 9839 >CANBERRA ACT 2601 >AUSTRALIA > > WWW: http://www.abcb.gov.au/ >E-Mail: [EMAIL PROTECTED] >Telephone: (02) 6213 6731 >Mobile: 0439 401 823 >Facsimile: (02) 6213 7287 > > >** >The information contained in this e-mail, and any attachments to it, is >intended for the use of addressee and is confidential. If you are not >the intended recipient, you must not use, disclose, read, forward, copy or >retain any of the information. If you have received this e-mail in >error, please delete it and notify the sender by return e-mail or telephone. >The Commonwealth does not warrant that any attachments are free from >viruses or any other defects. You assume all liability for any loss, >damage, or >other consequences which may arise from opening or using the attachments. > >** > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MPSB03-02 - Using Windows NT Authentication and Windows file permissions
> Yikes - that would mean we would have to recode basically > every app we have ever made that has and web accessible > admin directory. Do you think it would be safe to use a > cold fusion scripted login routine instead of ACL's and > WIndows Authentication. Why couldn't you just enable the "Check that file exists" option within the web-accessible admin directory? That doesn't need to use search-engine-safe URLs, does it? > I recall seeing recently that web based admin's getting > hacked was one of the top security vulnerabilities with > web apps. I can't vouch for that, but it sounds plausible enough. But there's a lot you can do to secure administrative functionality, in addition to requiring a login. You can place it within its own virtual server, so that people are less likely to find it; you can limit who can access it by IP address; you can limit who can access it by requiring client certificates. You can use all of these techniques together, of course. > Does anyone know how this exploit is exploited? No, and I can't replicate it with my current configuration - web server authentication seems to work fine for me. As I posted in another message, I suspect it has to do with the JRun connector configuration; I'm using the ISAPI extension option instead of the ISAPI filter. > What context is the CFM template executed under? The CFM file is always executed within the context of the CF server, no matter what. Of course, you should limit the privileges of the account in which CF runs to the extent possible. > Is the application.cfm file still executed? I would assume so. Of course, since I haven't replicated the problem, I can't say for sure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2nd ColdFusion MX updater now available.
Uhm.. Did I miss something? | -Original Message- | From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] | Sent: Sunday, February 02, 2003 9:10 PM | To: CF-Talk | Subject: SOT: 2nd ColdFusion MX updater now available. | | | Softly, softly it comes. | | Note: Updater releases are cumulative, therefore, Updater 2 | includes all fixes from Updater 1. You do not have to install | Updater 1 before you install Updater 2. | | Grab it at http://www.macromedia.com/software/coldfusion/downloads/ | | == | Peter Tilbrook | Internet Applications Developer | Australian Building Codes Board | GPO Box 9839 | CANBERRA ACT 2601 | AUSTRALIA | | WWW: http://www.abcb.gov.au/ |E-Mail: [EMAIL PROTECTED] | Telephone: (02) 6213 6731 |Mobile: 0439 401 823 | Facsimile: (02) 6213 7287 | | | ** | The information contained in this e-mail, and any attachments | to it, is intended for the use of addressee and is | confidential. If you are not | the intended recipient, you must not use, disclose, read, | forward, copy or retain any of the information. If you have | received this e-mail in | error, please delete it and notify the sender by return | e-mail or telephone. | The Commonwealth does not warrant that any attachments are free from | viruses or any other defects. You assume all liability for | any loss, damage, or | other consequences which may arise from opening or using the | attachments. | | ** | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2nd ColdFusion MX updater now available.
> Softly, softly it comes. > > Note: Updater releases are cumulative, therefore, > Updater 2 includes all fixes from Updater 1. You do > not have to install Updater 1 before you install > Updater 2. I hate to tell you this, but it's been out for a while - since 11 December, according to the release notes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2nd ColdFusion MX updater now available.
Hey Pete, that came out almost 2 months ago...but the occasional reminder never hurts. :-) -Stace -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 12:10 AM To: CF-Talk Subject: SOT: 2nd ColdFusion MX updater now available. Softly, softly it comes. Note: Updater releases are cumulative, therefore, Updater 2 includes all fixes from Updater 1. You do not have to install Updater 1 before you install Updater 2. Grab it at http://www.macromedia.com/software/coldfusion/downloads/ == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: (02) 6213 6731 Mobile: 0439 401 823 Facsimile: (02) 6213 7287 ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: 2nd ColdFusion MX updater now available.
The Internet takes a long time to get to Australia... :) (sorry Peter... no offense... I'll buy you a beer to make it up in a couple of weeks!) On Sunday, Feb 2, 2003, at 21:51 US/Pacific, brook wrote: > This has been out since mid December 2002. Is there a new one? I > didn't see > it.. > > Brook > > At 04:09 PM 2/3/03 +1100, you wrote: >> Softly, softly it comes. >> >> Note: Updater releases are cumulative, therefore, Updater 2 includes >> all >> fixes from Updater 1. You do not have to install Updater 1 before you >> install Updater 2. >> >> Grab it at http://www.macromedia.com/software/coldfusion/downloads/ >> >> == >> Peter Tilbrook >> Internet Applications Developer >> Australian Building Codes Board >> GPO Box 9839 >> CANBERRA ACT 2601 >> AUSTRALIA >> >> WWW: http://www.abcb.gov.au/ >>E-Mail: [EMAIL PROTECTED] >> Telephone: (02) 6213 6731 >>Mobile: 0439 401 823 >> Facsimile: (02) 6213 7287 >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Array and Query Length
Here it is Dave, I have only included the page that contains all of the cf code that does any real work (not just formatting or which link to show logic). If you want more, I will be happy to provide it to you, but I will let you know, as you can see by some of the statements, that I can verify for a fact that the code that updates the Second Query (session.MyCat) does not run twice (I am referring to the session.mycat.recordcount before and after the update). I will give address of actual site for all those that are willing to help. I have the same "MyCat Length Before = #Session.MyCat.recordcount#" on an application.cfm page and a OnRequestEnd.cfm Page. Everything looks right when the record gets updated. It is after all processing is done, the page has been returned its entirty to the client, then on the following request the recordcount has increased by one. I don't understand how this can happen!!! CFScript.CFM (an included page) Select * From Schedule Order by ADate Select * From Announcements Order by AOrder MyCat Length Before = #Session.MyCat.recordcount# MyCat Length After = #Session.MyCat.recordcount# -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 11:09 PM To: CF-Talk Subject: RE: Array and Query Length > Can someone please tell me how an array or query stored > in a session variable can be one length at the end of on > page, then another length at the top of the next page? > > I have an array and query (tried same thing two different > ways) with an arrayLen() and Query.Recordcount at the top > of an application page and the end of a OnRequestEnd page. > One row gets added to either just fine, but on the top of > the next page the array or query has ANOTHER row added two > it. Yes, a duplicate row, but after the page has been > returned to the client browser. > > I have tested this on 2 CFMX boxes and one CF5 box, so I > know that it is not a server issue. But, after having two > other people look at my code, and not being able to explain > how this is happening, I NEED HELP!!! > > Anyone that is willing to assist, I will be greatly > appreciative. It sounds like the code that you think is supposed to run once, is in fact running twice. You might want to post your code in its entirety here, and see if anyone can help then. If you can build a simple test case (removing any extraneous code that doesn't directly have to do with your problem), that might also be helpful. Dave Watts, CTO, Fig Leaf
RE: SOT: 2nd ColdFusion MX updater now available.
It's a long swim. :) John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 9:58 PM To: CF-Talk Subject: Re: SOT: 2nd ColdFusion MX updater now available. The Internet takes a long time to get to Australia... :) (sorry Peter... no offense... I'll buy you a beer to make it up in a couple of weeks!) On Sunday, Feb 2, 2003, at 21:51 US/Pacific, brook wrote: > This has been out since mid December 2002. Is there a new one? I > didn't see > it.. > > Brook > > At 04:09 PM 2/3/03 +1100, you wrote: >> Softly, softly it comes. >> >> Note: Updater releases are cumulative, therefore, Updater 2 includes >> all >> fixes from Updater 1. You do not have to install Updater 1 before you >> install Updater 2. >> >> Grab it at http://www.macromedia.com/software/coldfusion/downloads/ >> >> == >> Peter Tilbrook >> Internet Applications Developer >> Australian Building Codes Board >> GPO Box 9839 >> CANBERRA ACT 2601 >> AUSTRALIA >> >> WWW: http://www.abcb.gov.au/ >>E-Mail: [EMAIL PROTECTED] >> Telephone: (02) 6213 6731 >>Mobile: 0439 401 823 >> Facsimile: (02) 6213 7287 >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4