Re: CF MX *right* book.
People, thanks a lot to you for opinions about MX book! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: mysql ?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:02 PM To: CF-Talk Subject: mysql ? wny good recommendations for a front end to mysql? i remember using something called MySQL-Front but it looks discontinued I havent used mysql for awhile so whats the new best thing:) dave Dave, I have been using SQLYog for a while and am quite happy with it. However, I recently discovered a new tool that rates right up there with SQLYog. It is called AquaDataStudio (http://aquadatastudio.com). The nicest feature about it is that it supports just about every major database, as well as some of the minor ones. Also, the code-completion rocks! Mike Wolfe [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Perl
On Wednesday 17 Sep 2003 04:45 am, Cedric Villat wrote: Ok, sort of off topic, but I'm trying to convert a perl program to CF. I'm stuck on a line and have no idea what it's equivalent is in CF. The line is: push @{ $children{$line{p1}}}, shortname($line{node}); I assume $children is an array, and $line is a single line of an input The char in front of a variable tells you the 'context'. @ means 'array', $ 'string'. $children says to evaluate the children object as a string, which you want to do if the array 'children' contains strings. file. What exactly does the $children{$line{p1}} mean? Get me the string at the location of A in the children array. A is the string at location p1 of the line object. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Tag for driving INPUT boxes from a SELECT statement?
Something like this ought to do the trick: select name=x onchange=this.form.yourtextbox.value=this.value; option value=11/option option value=22/option /select input type=text name=yourtextbox Pete Freitag http://www.cfdev.com/ Author of CFMX Developers Cookbook http://www.amazon.com/exec/obidos/ASIN/0672324628/netgig-20 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re:kinda ot: adobe acrobat
It sounds like you're looking for a manual process, so how about creating the two PDF files and then opening one of them in Acrobat and using DOCUMENT INSERT to append the second file? -reed ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CFC-based GPL web HTML editor
It's a lot easier to install a JVM for IE6 than it is to install a new OS! Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 6:06 PM To: CF-Talk Subject: Re: CFC-based GPL web HTML editor That would mean that everyone who uses Windows using IE 5.5+, No, because you also have all those using IE on Macs ;-) When one say 95% of IE users, this include about all Mac users. The 5% remaining are not Mac users, but Opera, Mozilla, etc. most people who are using modern browsers such as IE 5.5 certainly do have Java. IE 5.5 yes, but about 60% of users are running version 6 which does not include the Virtual Machine and many of those people won't even try to install it. It is entirely possible that the percentage of people with Java installed is actually higher than the number of people who have IE 5.5+. IMHO it is much probable it is far less than that. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CFC-based GPL web HTML editor
It took me about 5 seconds to find a java applet wysiwyg. (It's not the greatest, but it is for _everyone_) http://head.sourceforge.net/portrait.html For the IE6 no JVM argument, much like Flash, most vendors will install the JVM before shipping. Additionally the first time a user visits a page requiring a JVM, the user is prompted to download install a VM from Microsoft. The idea that most people don't have Java is just marketing spin from Microsoft. (All the Dell's we've bought with XP had a JVM pre-installed.) Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 8:33 PM To: CF-Talk Subject: Re: CFC-based GPL web HTML editor Why? It seems like most of the editors already support a very common set of features. Most users are not going to be impressed that a Java editor functions the same way on all platforms. I'm sure a Mac user would prefer the editor to function like a native application/widget. I know part of the reason I dislike Macromedia applications is that they do not feel or function like Windows applications. I pretty sure I'm note alone on this. The above perspective seems to apply to desktop applications and not web applications. I believe most users expect a web application to look and behave the same no matter what browser on what platform they are using. Because, instead of writing a relatively simple interface for each different platform, you'd have to write, test, debug, etc. all the functionality yourself. Unless I'm completely off base, I think it would take much more time to write a feature rich, cross platform HTML editor. I'd much rather just leverage the work done by other individuals. I don't have any desire to reinvent the wheel. That all may be true, but it doesn't at all speak to why a Java editor would be more limited as you first stated. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Mail spooling issue
I agree with Dan and would test this locally as much as possible. Many groanful years of dealing with CF mail (prior to 6.1 of course). TEST locally and try the new settings (eg spoolenable) in MX 6.1. It could be that MX has got to the stage where the mail server can't keep up. Nirvana? Investigate. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CFC-based GPL web HTML editor
Such a big thread an no-one has mentioned HTMLArea. Check out: http://sourceforge.net/projects/itools-htmlarea/ And here for a demo: Version 3.0 Beta http://dynarch.com/htmlarea/example-fully-loaded.html This works in IE and Mozilla based browsers. It might be worth a look just to port that to a cfc. Adam Hope. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Can I Throw within cfscript???
Right. This is one of the fundamental reasons you can't use cfscript that much. If you wrap Cfthrow in another function (or use the one Raymond wrote) the error is actually throw from the throw function, not where you called the function. So the error will always show the lines of the throw function, not actually throw was called, like it should. Is there anyway to change this? Why oh why do we have try/catch but no throw? It's like we got loops without a break command. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:18 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? You _have_ to use cfthrow within test to throw within test. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:03 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Bryan, This is not the same code. All you are doing is returning from a function call. You are NOT throwing an exception within test. Andy -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:03 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Here is the answer cftry !--- This line throws error --- cfset test1() cfcatch type=any cfoutput#test(message=CFCatch Exists - #IsDefined(cfcatch)#)#/cfoutput /cfcatch /cftry br cfscript try { test1(); } catch(Any excpt) { writeoutput(test(message=CFCatch Exists - #IsDefined(excpt)#)); } /cfscript cffunction name=Test cfargument name=message cfset myMessage=Arguments.message cfreturn myMessage /cffunction -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:34 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Bryan, Here is sample code. First, observe that the two catch blocks behave differently. Second, can you replace the throw in Test with a script statement without changing the other code? cftry cfset test() cfcatch type=any cfoutputCFCatch Exists - #IsDefined(cfcatch)#/cfoutput /cfcatch /cftry cfscript try { test(); } catch(Any excpt) { writeoutput(brCFCatch Exists - #IsDefined(cfcatch)#); } /cfscript cffunction name=Test cfthrow message=This is a throw error /cffunction Andy -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 8:18 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Ok, I need some more information. Please post an example of your cfc and your cfml page -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:00 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Not what I am looking to do. I wish for the method to stop processing when I throw the exception and for control to return to the Try/Catch blocks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Mail spooling issue
-Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 2:53 PM To: CF-Talk Subject: RE: Mail spooling issue You saw it pop up from time to time, was an effort made come up with some sort of prevention? Can it be prevented at the application level vs the core CF level. Any thoughts would be appreciated. Casey, I used to work for a company that sends approximately 1 billion (yes, billion) emails a month (and yes, they are spammers). The emails are created via a CF application run from the command line that spools the emails to a database. The outbound spooling is handled through a separate application on the mail servers that pulls the emails from the database and fires them out through Sendmail. We learned long ago about the spooling bug in CF5, and also that CF5 is not at all suited to operate as a high-volume mail server. If you continue to experience this bug, my advice to you is to implement a solution such as I have described. You don't have to use Sendmail. There are plenty of small, cheap (or free) mail servers available. My personal favorite is ArgoSoft Mail Server (http://www.argosoft.com). It supports SMTP, POP3 and IMAP, as well as having an API that you can access directly from CF. Mike Wolfe [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Date problem with CFMX and Oracle
yes...use the Oracle to_date() around your dates. Also, try using cfqueryparam, it can handle the date conversions automagically. Doug -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:54 PM To: CF-Talk Subject: Re: Date problem with CFMX and Oracle I am trying to do an update to my DB: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = {ts '2003-09-16 16:08:22'} WHERE id = 2043 This worked fine before, I updated my CFMX server to 6.01 and my JDBC drivers to 1.4, and am now getting column doesn't exist! Does anyone know why this no longer works? I understand that this worked before MX and now it doesn't, but you're using a completely different set of drivers (Oracle ODBC/Native depending on your previous CF version vs. JDBC), each with their own set of quirks. As for the exact reason you're having your problem, not sure, but I'd chalk it up to the way the JDBC drivers pass dates as opposed to the ODBC/Native drivers. I've been working with CF and Oracle since the early days of CF and learned a long time ago to use Oracle's TO_DATE() function around all dates. Oracle is very particular about date formatting, and this function is the closest to a silver bullet that I've been able to find. Also, it looks like your example is using the current date/time to insert. If that's the case, then use sysdate instead of passing in an ODBC-format date. Regards, Dave. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Perl
%children is an associative array (hash/struct) dereferenced using the syntax $children{key}. %line is also an associative array. $children{key}'s value is an array. In CF, %children is a struct that contains arrays for the value at each key. That is, cfset children[my_key]=ArrayNew(1) cfset arrayAppend(children[my_key],my_value) HTH Ryan -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:46 PM To: CF-Talk Subject: OT: Perl Ok, sort of off topic, but I'm trying to convert a perl program to CF. I'm stuck on a line and have no idea what it's equivalent is in CF. The line is: push @{ $children{$line{p1}}}, shortname($line{node}); I assume $children is an array, and $line is a single line of an input file. What exactly does the $children{$line{p1}} mean? How are they indexing an array based on a string? Any ideas? Cedric ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Quotes in dynamic queries
Dear clever people... there must be a simple solution...??. (CF 5) Consider a dynamically generated form which returns many repeating text fields appended with an index number thus form.fieldstr_1, form.fieldstr_2 Etc. and a single hidden field form.rowlist containing a list of all the index numbers. We can evaluate it easily by looping over the contents of form.rowlist. This works, but will fail if a single quote is included in a form value. Known CF problem. CFLOOP LIST=#form.rowlist# INDEX=idx CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#form[fieldstr_ idx]#' WHERE rowref = #idx# /CFQUERY /CFLOOP so we can fix it by taking the evaluation out of the CFQUERY block: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = form[fieldstr_ idx] !--- or you could use the less effecient CFSET tempVar = evaluate(form.fieldstr_#idx#) --- CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#tempVar#' WHERE rowref = #idx# /CFQUERY /CFLOOP This accepts as many single quotes as you like, but both of the above examples truncate the form value at the first instance of a double quote , despite CFDUMP suggesting the entire value is being correctly returned. How to fix this? But I don't really want to do either of the above, but for reasons I won't explain here, I really want to do a completely dynamic query: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#form[fieldstr_ idx]#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET #preservesinglequotes(tempVar)# WHERE rowref = #idx# /CFQUERY /CFLOOP How to deal with single quotes and the double quotes truncation -in the value- with this? Can you? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Can I Throw within cfscript???
Adam, you can still do a try/catch inside the throw function. By using writeoutput(excp.message); -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:05 AM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Right. This is one of the fundamental reasons you can't use cfscript that much. If you wrap Cfthrow in another function (or use the one Raymond wrote) the error is actually throw from the throw function, not where you called the function. So the error will always show the lines of the throw function, not actually throw was called, like it should. Is there anyway to change this? Why oh why do we have try/catch but no throw? It's like we got loops without a break command. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:18 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? You _have_ to use cfthrow within test to throw within test. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:03 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Bryan, This is not the same code. All you are doing is returning from a function call. You are NOT throwing an exception within test. Andy -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:03 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Here is the answer cftry !--- This line throws error --- cfset test1() cfcatch type=any cfoutput#test(message=CFCatch Exists - #IsDefined(cfcatch)#)#/cfoutput /cfcatch /cftry br cfscript try { test1(); } catch(Any excpt) { writeoutput(test(message=CFCatch Exists - #IsDefined(excpt)#)); } /cfscript cffunction name=Test cfargument name=message cfset myMessage=Arguments.message cfreturn myMessage /cffunction -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:34 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Bryan, Here is sample code. First, observe that the two catch blocks behave differently. Second, can you replace the throw in Test with a script statement without changing the other code? cftry cfset test() cfcatch type=any cfoutputCFCatch Exists - #IsDefined(cfcatch)#/cfoutput /cfcatch /cftry cfscript try { test(); } catch(Any excpt) { writeoutput(brCFCatch Exists - #IsDefined(cfcatch)#); } /cfscript cffunction name=Test cfthrow message=This is a throw error /cffunction Andy -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 8:18 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Ok, I need some more information. Please post an example of your cfc and your cfml page -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:00 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Not what I am looking to do. I wish for the method to stop processing when I throw the exception and for control to return to the Try/Catch blocks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
advice
Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: OT: Perl
%children is an associative array (hash/struct) dereferenced using the syntax $children{key}. %line is also an associative array. $children{key}'s value is an array. In CF, %children is a struct that contains arrays for the value at each key. That is, cfset children[my_key]=ArrayNew(1) cfset arrayAppend(children[my_key],my_value) HTH Ryan -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:46 PM To: CF-Talk Subject: OT: Perl Ok, sort of off topic, but I'm trying to convert a perl program to CF. I'm stuck on a line and have no idea what it's equivalent is in CF. The line is: push @{ $children{$line{p1}}}, shortname($line{node}); I assume $children is an array, and $line is a single line of an input file. What exactly does the $children{$line{p1}} mean? How are they indexing an array based on a string? Any ideas? Cedric ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CF MX *right* book.
We are kinda biased to Ben Forta et al's books - they've sold truckloads - but many other fine authors are out there too. I'm looking for a 6.1 looking title myself. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Quotes in dynamic queries
look at using cfqueryparam. It will escape stuff automagically. I've also used HTMLEditFormat() before too. Doug -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:31 AM To: CF-Talk Subject: Quotes in dynamic queries Dear clever people... there must be a simple solution...??. (CF 5) Consider a dynamically generated form which returns many repeating text fields appended with an index number thus form.fieldstr_1, form.fieldstr_2 Etc. and a single hidden field form.rowlist containing a list of all the index numbers. We can evaluate it easily by looping over the contents of form.rowlist. This works, but will fail if a single quote is included in a form value. Known CF problem. CFLOOP LIST=#form.rowlist# INDEX=idx CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#form[fieldstr_ idx]#' WHERE rowref = #idx# /CFQUERY /CFLOOP so we can fix it by taking the evaluation out of the CFQUERY block: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = form[fieldstr_ idx] !--- or you could use the less effecient CFSET tempVar = evaluate(form.fieldstr_#idx#) --- CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#tempVar#' WHERE rowref = #idx# /CFQUERY /CFLOOP This accepts as many single quotes as you like, but both of the above examples truncate the form value at the first instance of a double quote , despite CFDUMP suggesting the entire value is being correctly returned. How to fix this? But I don't really want to do either of the above, but for reasons I won't explain here, I really want to do a completely dynamic query: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#form[fieldstr_ idx]#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET #preservesinglequotes(tempVar)# WHERE rowref = #idx# /CFQUERY /CFLOOP How to deal with single quotes and the double quotes truncation -in the value- with this? Can you? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: CF MX *right* book.
We are kinda biased to Ben Forta et al's books - they've sold truckloads - but many other fine authors are out there too. I'm looking for a 6.1 looking title myself. http://www.oreilly.com/catalog/coldfusion2/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: kinda ot: adobe acrobat
And PSD (PhotoShop Document?) can be really huge files in themselves. Is this the best solution you need? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Quotes in dynamic queries
Actually cfqueryparam suffers from the same issue. You still need to use a temp var before the actual query. Richard, does this problem go away if you get rid of the evaluate? You don't need it anyway. I notice in one code block you used it, one you didn't. Also, why do you use preserveSingleQuotes? Don't you want CF to automatically escape thje for you? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:13 AM To: CF-Talk Subject: RE: Quotes in dynamic queries look at using cfqueryparam. It will escape stuff automagically. I've also used HTMLEditFormat() before too. Doug -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:31 AM To: CF-Talk Subject: Quotes in dynamic queries Dear clever people... there must be a simple solution...??. (CF 5) Consider a dynamically generated form which returns many repeating text fields appended with an index number thus form.fieldstr_1, form.fieldstr_2 Etc. and a single hidden field form.rowlist containing a list of all the index numbers. We can evaluate it easily by looping over the contents of form.rowlist. This works, but will fail if a single quote is included in a form value. Known CF problem. CFLOOP LIST=#form.rowlist# INDEX=idx CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#form[fieldstr_ idx]#' WHERE rowref = #idx# /CFQUERY /CFLOOP so we can fix it by taking the evaluation out of the CFQUERY block: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = form[fieldstr_ idx] !--- or you could use the less effecient CFSET tempVar = evaluate(form.fieldstr_#idx#) --- CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#tempVar#' WHERE rowref = #idx# /CFQUERY /CFLOOP This accepts as many single quotes as you like, but both of the above examples truncate the form value at the first instance of a double quote , despite CFDUMP suggesting the entire value is being correctly returned. How to fix this? But I don't really want to do either of the above, but for reasons I won't explain here, I really want to do a completely dynamic query: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#form[fieldstr_ idx]#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET #preservesinglequotes(tempVar)# WHERE rowref = #idx# /CFQUERY /CFLOOP How to deal with single quotes and the double quotes truncation -in the value- with this? Can you? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Date problem with CFMX and Oracle
Ah, Oracle - you have to love it! More and more corporations it seems are using this DBMS! For good reason - it is very capable. From a development point of view, especially with a frequently absent database administrator in between, it can be a nightmare. Why you are using this: ChgDate = {ts '2003-09-16 16:08:22'} Instead of a native ColdFusion function like CreateODBCDateTime(Now()) or something is beyond me. Your quotes could also be an issue, try double rather than single quotes. Also the CFUPDATE function negates the need for the SQL - just ensure the data going in is valid beforehand - eg: cfupdate datasource=#Request.DataSourceName# tablename=ACTCFUG_News formfields=NewsID,NewsTitle,NewsBody,NewsBodyTemp,NewsUpdated,NewsLocked,Ne wsReleased,NewsApproved,NewsCompleted username=#Request.DataSourceUser# password=#Request.DataSourcePassword# The formfields are validated before going to the database - an error could be trapped and handled by CFTRY or some other error handler. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
GROUP BY year, month loop
ok i am having a slight brain fart. have left my reference books at home i want to loop through year, grouping by month displaying sum total. right now i have it grouping by month displaying sum total, but it lumps the year together.. should be simple, and i have search archives.. thanks -paul cfquery name=rsDisMonth datasource=recycle SELECT Year(Month(Offload_Date)) as yearEnterd, Month(Offload_Date) as monthEnterd, SUM(Offload_Gallons) AS SumGal FROM tblOffload GROUP BY Year(Month(Offload_Date)), Month(Offload_Date) /cfquery cfoutput query=rsDisMonth group=monthEnterd tr align=right valign=top td#YearEnterd#/td td#monthEnterd#/td td#LSNumberFormat(SumGal,',99.99')#/td tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr /cfoutput ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: SOT: SSL Load Balanced CF
Thanks Howard! You have helped me out a bunch. Now, I feel comfortable enough to buy the keys ($1600), and put these theories to the test. I have been having all kinds of trouble trying to get an answer from VeriSign. -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 5:52 PM To: CF-Talk Subject: Re: SOT: SSL Load Balanced CF On Tuesday, Sep 16, 2003, at 15:29 US/Eastern, Justin Hansen wrote: I'm starting a new project that will require SSL and I have a few questions... If a user is on Server(A) and has and SSL session going what happens if Server(A) goes down? When Server(B) picks up the user will the SSL be broken? I haven't tried this (but will Real Soon Now), but given that HTTP and HTTPS are not persistent connection protocols, I think the SSL browser-server handshake has to happen each time a HTTPS connection is requested. So the important part would be that each server that could answer the request has a valid certificate. Both servers have to have different keys right? Yes. You have different certs for the same domain on different boxes. Wouldn't that break the users session? What would happen user? I don't think (though I could be wrong) that the browser compares the SSL certificate from one connection to the next. The only things the browser cares about is that the certificate is from an accepted CA and that the domain name on the cert matches the domain in the request. Sessions as far as CF cares about don't have anything to do with SSL. -- Howard Fore, [EMAIL PROTECTED] I hope you believe you understand what you think I said, but I'm not sure you understand that what you've heard is not what I meant. President Richard Nixon ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: GROUP BY year, month loop
Is the problem with your query or your output? Do you get the right results when you run the query in some sort of query analyzer? If not, my first question would be about the nested year(month( function. Do you need to do it that way? Can't you just use year(column)? If it's an output issue, it's probably because of the way you're grouping your cfoutput ordering your query. You're grouping by the month, but you don't then have an inner cfoutput to get all the years. If you want to display by month, you should also order your query by month, then by year. Right now, I'm guessing that your query is ordering by year, then by month (based on the order of your select and group by clauses.) - Original Message - From: Ihrig Paul E Cont 88 ABW/EM [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:00 AM Subject: GROUP BY year, month loop ok i am having a slight brain fart. have left my reference books at home i want to loop through year, grouping by month displaying sum total. right now i have it grouping by month displaying sum total, but it lumps the year together.. should be simple, and i have search archives.. thanks -paul cfquery name=rsDisMonth datasource=recycle SELECT Year(Month(Offload_Date)) as yearEnterd, Month(Offload_Date) as monthEnterd, SUM(Offload_Gallons) AS SumGal FROM tblOffload GROUP BY Year(Month(Offload_Date)), Month(Offload_Date) /cfquery cfoutput query=rsDisMonth group=monthEnterd tr align=right valign=top td#YearEnterd#/td td#monthEnterd#/td td#LSNumberFormat(SumGal,',99.99')#/td tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr /cfoutput ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: kinda ot: adobe acrobat
got the whole sheebang down to 1mb, which isnt a problem :) thanks tho' tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:16 AM To: CF-Talk Subject: RE: kinda ot: adobe acrobat And PSD (PhotoShop Document?) can be really huge files in themselves. Is this the best solution you need? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: kinda ot: adobe acrobat
thtas what I figgered out, later on last night thanks tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:57 AM To: CF-Talk Subject: Re:kinda ot: adobe acrobat It sounds like you're looking for a manual process, so how about creating the two PDF files and then opening one of them in Acrobat and using DOCUMENT INSERT to append the second file? -reed ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
gps stuff with cf
just curious if any one has any gps experience. looking at phones that can send / receive gps info. not sure on which one i will go with, probably Nextel, but wanted to see if any one out there had any cf examples on tracking people. not entirely ot. -paul ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: gps stuff with cf
We use Blackberry's (RIM) as they use Java and we can integrate with CF -Original Message- From: Ihrig Paul E Cont 88 ABW/EM [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 15:48 To: CF-Talk Subject: gps stuff with cf just curious if any one has any gps experience. looking at phones that can send / receive gps info. not sure on which one i will go with, probably Nextel, but wanted to see if any one out there had any cf examples on tracking people. not entirely ot. -paul ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Date problem with CFMX and Oracle
Ack! Don't use cfupdate as a solution to this problem. Dates in oracle really aren't that hard. There's a number of ways you can do them. The easiest solution for entering the current date/time (as someone mentioned) is to let Oracle do it with sysdate. So, your query would be: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = sysdate WHERE id = 2043 If you want to control the date/time, then do it like this: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = to_date('2003-09-16 16:08:22', '-mm-dd hh24:mi:ss') WHERE id = 2043 Or, if you want CF to handle it automagically it would go like this: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=2003-09-16 16:08:22 WHERE id = 2043 - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:29 AM Subject: RE: Date problem with CFMX and Oracle Ah, Oracle - you have to love it! More and more corporations it seems are using this DBMS! For good reason - it is very capable. From a development point of view, especially with a frequently absent database administrator in between, it can be a nightmare. Why you are using this: ChgDate = {ts '2003-09-16 16:08:22'} Instead of a native ColdFusion function like CreateODBCDateTime(Now()) or something is beyond me. Your quotes could also be an issue, try double rather than single quotes. Also the CFUPDATE function negates the need for the SQL - just ensure the data going in is valid beforehand - eg: cfupdate datasource=#Request.DataSourceName# tablename=ACTCFUG_News formfields=NewsID,NewsTitle,NewsBody,NewsBodyTemp,NewsUpdated,NewsLocked,Ne wsReleased,NewsApproved,NewsCompleted username=#Request.DataSourceUser# password=#Request.DataSourcePassword# The formfields are validated before going to the database - an error could be trapped and handled by CFTRY or some other error handler. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: gps stuff with cf
On Wednesday 17 Sep 2003 15:47 pm, Ihrig Paul E Cont 88 ABW/EM wrote: looking at phones that can send / receive gps info. not sure on which one i will go with, probably Nextel, but wanted to see if any one out there had any cf examples on tracking people. We use a variety of hardware. Ranges from things we can SMS (and get an SMS back), to GPRS data calls, to dedicated RF positioning. CF is able to intergrate with anything - if you have to use a non-CF 'downloader' or something, you just get CF to talk to the same DB for displaying :-) -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: CFC-based GPL web HTML editor
On Wednesday 17 Sep 2003 13:50 pm, Adam Wayne Lehman wrote: The idea that most people don't have Java is just marketing spin from Microsoft. (All the Dell's we've bought with XP had a JVM pre-installed.) Although it *is* true that some places dis-allow excutable content, such as applets, at the gateway, or by policys on the local machines. Depdends on your target market. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: GROUP BY year, month loop
hey Deanna. i figured it out.. was just the morning fog... thanks.. -paul cfquery name=rsDisMonth datasource=recycle SELECT Year(Offload_Date) as yearEnterd, Month(Offload_Date) as monthEnterd, SUM(Offload_Gallons) AS SumGal FROM tblOffload GROUP BY Year(Offload_Date), Month(Offload_Date) /cfquery !--- Start our first part of a loop to order the results by the year they where enterd. --- cfoutput query=rsDisMonth group=yearEnterd tr td colspan=6strongTotal Sum for year #YearEnterd#/strong/td /tr !--- Our second part of the loop orders by the month as well as adds up the total gallons shiped out. --- cfoutput group=monthEnterd tr td align=right valign=topnbsp;/td td align=right valign=top#MonthAsString(monthEnterd)#/td td align=right valign=top#LSNumberFormat(SumGal,',99.99')#/td td align=right valign=topnbsp;/td td align=right valign=topnbsp;/td td align=right valign=topnbsp;/td /tr /cfoutput /cfoutput ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Can I Throw within cfscript???
On Wednesday 17 Sep 2003 14:04 pm, Adam Wayne Lehman wrote: Why oh why do we have try/catch but no throw? It's like we got loops without a break command. No point. You can just an an extra looping condition, and change the value of that flag if you need to break out. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Dreamweaver Fatal Exception
A bit puzzled... I am using DWMX and during this morning.. I have gotten Dreamweaver has encoutered a Fatal Exeption and will now terminiate... What is causing this? It seems while I have been working on 2 pages. Any Ideas...? Thanks ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re:Date problem with CFMX and Oracle
6.1 makes a change that breaks code like this. This was already covered on a different mailing list. See http://www.mail-archive.com/[EMAIL PROTECTED]/msg01644.html for details. You'd do well to use cfqueryparam with a cfsqltype of cf_sql_date and/or use oracle's TO_DATE function as the other repliers have suggested. I am trying to do an update to my DB: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = {ts '2003-09-16 16:08:22'} WHERE id = 2043 This worked fine before, I updated my CFMX server to 6.01 and my JDBC drivers to 1.4, and am now getting column doesn't exist! Does anyone know why this no longer works? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Can I Throw within cfscript???
Thanks Tom. There is actually a 'break' command in cfscript, I was just using it as an example to illustrate operators and commands that go hand in hand. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:03 AM To: CF-Talk Subject: Re: Can I Throw within cfscript??? On Wednesday 17 Sep 2003 14:04 pm, Adam Wayne Lehman wrote: Why oh why do we have try/catch but no throw? It's like we got loops without a break command. No point. You can just an an extra looping condition, and change the value of that flag if you need to break out. -- Tom Chiverton (sorry 'bout sig.) Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~|BR [A HREF=http://www.houseoffusion.com/lists.cfm?link=t:4;Todays Threads/A] [A HREF=http://www.houseoffusion.com/lists.cfm?link=t:4;This Message/A] [A HREF=http://www.houseoffusion.com/lists.cfm?link=s:4;Subscription/A] [A HREF=http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1.1.4;Fast Unsubscribe/A] [A HREF=http://www.houseoffusion.com/signin/;User Settings/AP A HREF=http://www.fusionauthority.com/banners/view.cfm?bannerid=33; TARGET=_blankIMG align=center SRC=http://www.fusionauthority.com/banners/CF_intro_468x60.gif; WIDTH=468 HEIGHT=60 ALT= BORDER=0/A
Re:CFC-based GPL web HTML editor
This works in IE and Mozilla based browsers. It might be worth a look just to port that to a cfc. Did not work on Netscape 7 Windows. This post was started mentioning the port we did of SPAW but for some reason the original post got cut off. I am going to repost the info regarding the open-source CFC-based WYSIWYG editor (IE 5.5+ Windows required for WYSIWYG functionality though... a plain TEXTAREA will show up in Mozilla/Opera/others) we developed: Project Homepage in SourceForge: http://sourceforge.net/projects/spaw-cf A working demo (image upload disabled): http://www.elefectoaxe.com.co/spaw/test.cfm Regards Mauricio~|BR [A HREF=http://www.houseoffusion.com/lists.cfm?link=t:4;Todays Threads/A] [A HREF=http://www.houseoffusion.com/lists.cfm?link=t:4;This Message/A] [A HREF=http://www.houseoffusion.com/lists.cfm?link=s:4;Subscription/A] [A HREF=http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1.1.4;Fast Unsubscribe/A] [A HREF=http://www.houseoffusion.com/signin/;User Settings/AP A HREF=http://www.fusionauthority.com/banners/view.cfm?bannerid=33; TARGET=_blankIMG align=center SRC=http://www.fusionauthority.com/banners/CF_intro_468x60.gif; WIDTH=468 HEIGHT=60 ALT= BORDER=0/A
Re: Re:CFC-based GPL web HTML editor
This works in IE and Mozilla based browsers. It might be worth a look just to port that to a cfc. Did not work on Netscape 7 Windows. You need Mozilla 1.3.1+ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~|BR [A HREF=http://www.houseoffusion.com/lists.cfm?link=t:4;Todays Threads/A] [A HREF=http://www.houseoffusion.com/lists.cfm?link=t:4;This Message/A] [A HREF=http://www.houseoffusion.com/lists.cfm?link=s:4;Subscription/A] [A HREF=http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1.1.4;Fast Unsubscribe/A] [A HREF=http://www.houseoffusion.com/signin/;User Settings/AP A HREF=http://www.fusionauthority.com/banners/view.cfm?bannerid=33; TARGET=_blankIMG align=center SRC=http://www.fusionauthority.com/banners/CF_intro_468x60.gif; WIDTH=468 HEIGHT=60 ALT= BORDER=0/A
Re: A Positive for DW2004
Well just to see if I'm on crack, I did a quick test, and while it's not a factor of 10, DWMX was slower. In a search of some 30,000 files half of which are html or cfm documents, doing a simple search for cfmail I got 12:56 for HomeSite+ and 14:44 for DWMX. Only about 12% faster and on a more reasonably sized site, it's probably a wash. I took a small section of that site, amounting to 180 or so files, and did a find/replace to change cfif to CFIF. HomeSite+ 6sec and DWMX 13sec. So half the speed, but still not my 10x difference that I spouted. So maybe I'm am on crack. I think another thing that I could have been throwing into the mix was the link checking search/replace when you move or rename a file. That does seem to take quite a bit longer than a regular text search/replace. -Kevin - Original Message - From: Calvin Ward [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 7:40 PM Subject: Re: A Positive for DW2004 I've never found that to be the case. Opening and editing documents, yes CFS was faster than DWMX, Find and Replace, I found the performance on par, or in some cases better with DWMX. I'm about to do some wide scale testing with DWMX 2004 as soon as our 25 licenses arrive, I'll let you know if it is better. - Calvin - Original Message - From: Kevin Graeme [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 7:55 PM Subject: Re: A Positive for DW2004 I love the search/replace features of DWMX, but I disagree with this: CFS has nothing on DWMX Find and Replace. CFS/Homesite+ is much, much, much faster at actually doing the search/replace. DWMX is painfully slow. I haven't yet tried 2004, but I haven't heard as a new feature that the search specifically is at least 10x faster. -Kevin ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137315 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re:CFC-based GPL web HTML editor
You need Mozilla 1.3.1+ oh ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137316 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Mail spooling issue
I would encourage *anyone* who is doing email application that need to handle volume to upgrade to CFMX 6.1 Enterprise. This kind of use case is specifically what we targeted the enhancements for. As to the CF5 spool file locking problem, you can certainly fix this by switching to a Unix based operating system. :-( The problem is that windows will not let you move/delete a file being touched by some other 'process'. Have you investigated if there is a Windows patch that fixes problems with this kind of file locking happening 'randomly'? I can certainly believe there is a bug in the CF5 C++ implementation that would possibly not release a file handle properly, but if it only happens every *month* or two, I am not sure how we could have coded something so clever if we had wanted to -- Tom Jordahl Macromedia Server Development -Original Message- From: Michael Wolfe [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:44 AM To: CF-Talk Subject: RE: Mail spooling issue -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 2:53 PM To: CF-Talk Subject: RE: Mail spooling issue You saw it pop up from time to time, was an effort made come up with some sort of prevention? Can it be prevented at the application level vs the core CF level. Any thoughts would be appreciated. Casey, I used to work for a company that sends approximately 1 billion (yes, billion) emails a month (and yes, they are spammers). The emails are created via a CF application run from the command line that spools the emails to a database. The outbound spooling is handled through a separate application on the mail servers that pulls the emails from the database and fires them out through Sendmail. We learned long ago about the spooling bug in CF5, and also that CF5 is not at all suited to operate as a high-volume mail server. If you continue to experience this bug, my advice to you is to implement a solution such as I have described. You don't have to use Sendmail. There are plenty of small, cheap (or free) mail servers available. My personal favorite is ArgoSoft Mail Server (http://www.argosoft.com). It supports SMTP, POP3 and IMAP, as well as having an API that you can access directly from CF. Mike Wolfe [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137317 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Quotes in dynamic queries [solved]
Thanks for your answers CFQUERYPARAM only works after the WHERE, this is not the problem I have However having struggled with this for quite some time, I have actually found a solution. First off the double quotes problem wasn't a query problem, it was a display problem, easily solved with HtmlEditFormat() Second off, in a dynamic query like below, you need the preservesinglequotes() so the single quotes 'surrounding' the text value are not escaped automatically, however this will also preserve single quotes in the body of the text value which will cause an error. The fix is to escape any single quotes in the body of the text value before you give it to preservesinglequotes(). Once I realized what I wanted, a very simple UDF did the trick (easier to read and I will use it a lot): CFSCRIPT function EscapeSingleQuotes(x) { return replace(x,','',all); } /CFSCRIPT CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#EscapeSingleQuotes(form[fieldstr_ idx])#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET #preservesinglequotes(tempVar)# WHERE rowref = #idx# /CFQUERY /CFLOOP Raymond Camden wrote: Actually cfqueryparam suffers from the same issue. You still need to use a temp var before the actual query. Richard, does this problem go away if you get rid of the evaluate? You don't need it anyway. I notice in one code block you used it, one you didn't. Also, why do you use preserveSingleQuotes? Don't you want CF to automatically escape thje for you? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:13 AM To: CF-Talk Subject: RE: Quotes in dynamic queries look at using cfqueryparam. It will escape stuff automagically. I've also used HTMLEditFormat() before too. Doug -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:31 AM To: CF-Talk Subject: Quotes in dynamic queries Dear clever people... there must be a simple solution...??. (CF 5) Consider a dynamically generated form which returns many repeating text fields appended with an index number thus form.fieldstr_1, form.fieldstr_2 Etc. and a single hidden field form.rowlist containing a list of all the index numbers. We can evaluate it easily by looping over the contents of form.rowlist. This works, but will fail if a single quote is included in a form value. Known CF problem. CFLOOP LIST=#form.rowlist# INDEX=idx CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#form[fieldstr_ idx]#' WHERE rowref = #idx# /CFQUERY /CFLOOP so we can fix it by taking the evaluation out of the CFQUERY block: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = form[fieldstr_ idx] !--- or you could use the less effecient CFSET tempVar = evaluate(form.fieldstr_#idx#) --- CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#tempVar#' WHERE rowref = #idx# /CFQUERY /CFLOOP This accepts as many single quotes as you like, but both of the above examples truncate the form value at the first instance of a double quote , despite CFDUMP suggesting the entire value is being correctly returned. How to fix this? But I don't really want to do either of the above, but for reasons I won't explain here, I really want to do a completely dynamic query: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#form[fieldstr_ idx]#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET #preservesinglequotes(tempVar)# WHERE rowref = #idx# /CFQUERY /CFLOOP How to deal with single quotes and the double quotes truncation -in the value- with this? Can you? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137318 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Error not returned
CF 5.0 on a NT 4.0 machine calling stored procedure on SQL Server 2000 on Win2k machine. The stored procedure is using a linked server (OLEDB) to access a FoxPro table (which has been working fine until today). When I run this stored procedure from Query Analyzer, I get this error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. The provider ran out of memory. [OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]Not enough memory for file map.] When I run it from CF using a cfquery tag, I don't get any error messages. What is going on here? When this error occurs, I need to be able to catch an error in CF so that my users (and I) are alerted. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137319 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Re:Date problem with CFMX and Oracle
Using cf_sql_date will truncate the time. You want to use cf_sql_timestamp. -d - Original Message - From: Brad Howerter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:10 AM Subject: Re:Date problem with CFMX and Oracle 6.1 makes a change that breaks code like this. This was already covered on a different mailing list. See http://www.mail-archive.com/[EMAIL PROTECTED]/msg01644.html for details. You'd do well to use cfqueryparam with a cfsqltype of cf_sql_date and/or use oracle's TO_DATE function as the other repliers have suggested. I am trying to do an update to my DB: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = {ts '2003-09-16 16:08:22'} WHERE id = 2043 This worked fine before, I updated my CFMX server to 6.01 and my JDBC drivers to 1.4, and am now getting column doesn't exist! Does anyone know why this no longer works? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137320 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: advice
I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 14:46 To: CF-Talk Subject: advice Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137321 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: advice
Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 14:46 To: CF-Talk Subject: advice Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137322 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Quotes in dynamic queries [solved]
-Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:55 AM To: CF-Talk Subject: Re: Quotes in dynamic queries [solved] Thanks for your answers CFQUERYPARAM only works after the WHERE, this is not the problem I have ugh no. You can use it pretty much anywhere I suppose. Here is some sample code similar to what you are doing that I used. This has no issues with single ticks or quotes. cfquery name=update datasource=#request.datasource# UPDATE PRODUCTS SET NAME = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form['name_#i#']#, POSCATEGORY = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form['poscategory_#i#']#, ACTIONUSER = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#request.logemplid# WHERE PRODUCT = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form['product_#i#']# /cfquery Doug However having struggled with this for quite some time, I have actually found a solution. First off the double quotes problem wasn't a query problem, it was a display problem, easily solved with HtmlEditFormat() Second off, in a dynamic query like below, you need the preservesinglequotes() so the single quotes 'surrounding' the text value are not escaped automatically, however this will also preserve single quotes in the body of the text value which will cause an error. The fix is to escape any single quotes in the body of the text value before you give it to preservesinglequotes(). Once I realized what I wanted, a very simple UDF did the trick (easier to read and I will use it a lot): CFSCRIPT function EscapeSingleQuotes(x) { return replace(x,','',all); } /CFSCRIPT CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#EscapeSingleQuotes(form[fieldstr_ idx])#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET #preservesinglequotes(tempVar)# WHERE rowref = #idx# /CFQUERY /CFLOOP Raymond Camden wrote: Actually cfqueryparam suffers from the same issue. You still need to use a temp var before the actual query. Richard, does this problem go away if you get rid of the evaluate? You don't need it anyway. I notice in one code block you used it, one you didn't. Also, why do you use preserveSingleQuotes? Don't you want CF to automatically escape thje for you? === = === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:13 AM To: CF-Talk Subject: RE: Quotes in dynamic queries look at using cfqueryparam. It will escape stuff automagically. I've also used HTMLEditFormat() before too. Doug -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:31 AM To: CF-Talk Subject: Quotes in dynamic queries Dear clever people... there must be a simple solution...??. (CF 5) Consider a dynamically generated form which returns many repeating text fields appended with an index number thus form.fieldstr_1, form.fieldstr_2 Etc. and a single hidden field form.rowlist containing a list of all the index numbers. We can evaluate it easily by looping over the contents of form.rowlist. This works, but will fail if a single quote is included in a form value. Known CF problem. CFLOOP LIST=#form.rowlist# INDEX=idx CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#form[fieldstr_ idx]#' WHERE rowref = #idx# /CFQUERY /CFLOOP so we can fix it by taking the evaluation out of the CFQUERY block: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = form[fieldstr_ idx] !--- or you could use the less effecient CFSET tempVar = evaluate(form.fieldstr_#idx#) --- CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = '#tempVar#' WHERE rowref = #idx# /CFQUERY /CFLOOP This accepts as many single quotes as you like, but both of the above examples truncate the form value at the first instance of a double quote , despite CFDUMP suggesting the entire value is being correctly returned. How to fix this? But I don't really want to do either of the above, but for reasons I won't explain here, I really want to do a completely dynamic query: CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#form[fieldstr_ idx]#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE
Re: CF-Talk: Digest every hour
Ryan, Thanks, that makes sense now. Cedric Subject: OT: Perl From: Ryan Emerle [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 10:05:49 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=27180forumid=4#137291 %children is an associative array (hash/struct) dereferenced using the syntax $children{key}. %line is also an associative array. $children{key}'s value is an array. In CF, %children is a struct that contains arrays for the value at each key. That is, cfset children[my_key]=ArrayNew(1) cfset arrayAppend(children[my_key],my_value) HTH Ryan -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:46 PM To: CF-Talk Subject: OT: Perl Ok, sort of off topic, but I'm trying to convert a perl program to CF. I'm stuck on a line and have no idea what it's equivalent is in CF. The line is: push @{ $children{$line{p1}}}, shortname($line{node}); I assume $children is an array, and $line is a single line of an input file. What exactly does the $children{$line{p1}} mean? How are they indexing an array based on a string? Any ideas? Cedric ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137324 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: advice
Was in the Army and lived a total of 9 yrs in Europe. I loved it. 3 in Germany and 6 in Netherlands. Wish I could have spent more time there. Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:59 AM To: CF-Talk Subject: RE: advice Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 14:46 To: CF-Talk Subject: advice Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137325 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: advice
So the beef in europe is not as good in US huh? I am going for final semester of my MBA so I will fo in Feb tehn graduate in france on july 8th -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM To: CF-Talk Subject: RE: advice Was in the Army and lived a total of 9 yrs in Europe. I loved it. 3 in Germany and 6 in Netherlands. Wish I could have spent more time there. Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:59 AM To: CF-Talk Subject: RE: advice Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 14:46 To: CF-Talk Subject: advice Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137326 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Can I Throw within cfscript???
You mean loops without a continue command, right? There is a break in both CFML and CFSCRIPT, but continue only in CFSCRIPT. Quite annoying. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 6:05 AM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Right. This is one of the fundamental reasons you can't use cfscript that much. If you wrap Cfthrow in another function (or use the one Raymond wrote) the error is actually throw from the throw function, not where you called the function. So the error will always show the lines of the throw function, not actually throw was called, like it should. Is there anyway to change this? Why oh why do we have try/catch but no throw? It's like we got loops without a break command. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:18 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? You _have_ to use cfthrow within test to throw within test. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:03 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Bryan, This is not the same code. All you are doing is returning from a function call. You are NOT throwing an exception within test. Andy -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:03 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Here is the answer cftry !--- This line throws error --- cfset test1() cfcatch type=any cfoutput#test(message=CFCatch Exists - #IsDefined(cfcatch)#)#/cfoutput /cfcatch /cftry br cfscript try { test1(); } catch(Any excpt) { writeoutput(test(message=CFCatch Exists - #IsDefined(excpt)#)); } /cfscript cffunction name=Test cfargument name=message cfset myMessage=Arguments.message cfreturn myMessage /cffunction -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:34 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Bryan, Here is sample code. First, observe that the two catch blocks behave differently. Second, can you replace the throw in Test with a script statement without changing the other code? cftry cfset test() cfcatch type=any cfoutputCFCatch Exists - #IsDefined(cfcatch)#/cfoutput /cfcatch /cftry cfscript try { test(); } catch(Any excpt) { writeoutput(brCFCatch Exists - #IsDefined(cfcatch)#); } /cfscript cffunction name=Test cfthrow message=This is a throw error /cffunction Andy -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 8:18 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Ok, I need some more information. Please post an example of your cfc and your cfml page -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:00 PM To: CF-Talk Subject: RE: Can I Throw within cfscript??? Not what I am looking to do. I wish for the method to stop processing when I throw the exception and for control to return to the Try/Catch blocks. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137327 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: advice
Kris Pilles wrote: Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it I worked in Japan and Singapore. Try it :-) Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137328 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: advice
Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... I am sorry to sound pedandic, but pizza is clearly the most important contribution to modern civilization coming from Italy and definitely deserve a better treatment :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137330 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: mysql ?
ty all i found another one called NaviCat that looks like the real winner www.mysqlstudio.com, even converts your other db's to mysql the nicest interface by far :) dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 11:02 PM To: CF-Talk Subject: mysql ? wny good recommendations for a front end to mysql? i remember using something called MySQL-Front but it looks discontinued I havent used mysql for awhile so whats the new best thing:) dave Dave, I have been using SQLYog for a while and am quite happy with it. However, I recently discovered a new tool that rates right up there with SQLYog. It is called AquaDataStudio (http://aquadatastudio.com). The nicest feature about it is that it supports just about every major database, as well as some of the minor ones. Also, the code-completion rocks! Mike Wolfe [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137329 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: advice
Considereing I can't find someone who ha a bad thing to say about it I am going to do it... I guess I can always go back to bartending if I cant get any programming work overseas KP -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM To: CF-Talk Subject: RE: advice Was in the Army and lived a total of 9 yrs in Europe. I loved it. 3 in Germany and 6 in Netherlands. Wish I could have spent more time there. Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:59 AM To: CF-Talk Subject: RE: advice Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 14:46 To: CF-Talk Subject: advice Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137331 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: advice
I don't know about the quality, but the size of the burgers in the UK are about 1/8 of those in the US. And refillable drinks, what's all that about ;O) So the beef in europe is not as good in US huh? -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 17:17 To: CF-Talk Subject: RE: advice So the beef in europe is not as good in US huh? I am going for final semester of my MBA so I will fo in Feb tehn graduate in france on july 8th -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM To: CF-Talk Subject: RE: advice Was in the Army and lived a total of 9 yrs in Europe. I loved it. 3 in Germany and 6 in Netherlands. Wish I could have spent more time there. Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:59 AM To: CF-Talk Subject: RE: advice Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 14:46 To: CF-Talk Subject: advice Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137332 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Quotes in dynamic queries [solved]
Richard Meredith-Hardy wrote: CFQUERYPARAM only works after the WHERE, this is not the problem I have That is incorrect, you can use it anywhere. Second off, in a dynamic query like below, you need the preservesinglequotes() so the single quotes 'surrounding' the text value are not escaped automatically, however this will also preserve single quotes in the body of the text value which will cause an error. The fix is to escape any single quotes in the body of the text value before you give it to preservesinglequotes(). Once I realized what I wanted, a very simple UDF did the trick (easier to read and I will use it a lot): CFSCRIPT function EscapeSingleQuotes(x) { return replace(x,','',all); } /CFSCRIPT CFLOOP LIST=#form.rowlist# INDEX=idx CFSET tempVar = fieldstr = '#EscapeSingleQuotes(form[fieldstr_ idx])#' CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET #preservesinglequotes(tempVar)# WHERE rowref = #idx# /CFQUERY /CFLOOP Escaping single quotes often is not enough, many database have escape characters like \. You really should use cfqueryparam: CFLOOP LIST=#form.rowlist# INDEX=idx CFQUERY NAME=uddata DATASOURCE=#myDS# UPDATE testtable SET fieldstr = cfqueryparam cfsqltype=cf_sql_varchar value=#form[fieldstr_ idx]# WHERE rowref = cfqueryparam cfsqltype=cf_sql_integer value=#idx# /CFQUERY /CFLOOP Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137333 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Can I Throw within cfscript???
On Wednesday, Sep 17, 2003, at 08:20 US/Pacific, Adam Wayne Lehman wrote: Thanks Tom. There is actually a 'break' command in cfscript, I was just using it as an example to illustrate operators and commands that go hand in hand. There are a lot of folks who think that using 'break' in a loop is unstructured and bad practice... i.e., they should not go 'hand in hand'... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137334 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: advice
Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... ha, its better than the real thing--its one of the foods i really miss living the ex-pat life. and if you think american pizza's bad, come to bangkok see what they do to it here. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137335 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: advice
On Wednesday, Sep 17, 2003, at 09:16 US/Pacific, Kris Pilles wrote: So the beef in europe is not as good in US huh? The beef in Europe is prepared differently so it tastes rather different. When my wife lived in France, she used to got to a Kosher butcher because that was the closest she could get to US-style beef... ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137336 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
small article...
Hi Guys, Hi I want to share with you guys about this article. :) LOVE YOUR JOB, BUT NEVER FALL IN LOVE WITH YOUR COMPANY BECAUSE U NEVER KNOW WHEN COMPANY STOPS LOVING YOU - Narayana Murthy Extract of Mr. Narayana Murthy's Speech during Mentor Session : I know people who work 12 hours a day, six days a week, or more. Some people do so because of a work emergency where the long hours are only temporary. Other people I know have put these hours for years. I don't know if they are working all these hours, but I do know they are in the office this long. Others put in long office hours because they are addicted to the workplace. Whatever the reason for putting in overtime, working long hours over the long term is harmful to the person and to the organization. There are things managers can do to change this for everyone's benefit. Being in the office long hours, over long periods of time, makes way for potential errors. My colleagues who are in the office long hours frequently make mistakes caused by fatigue. Correcting these mistakes requires their time as well as the time and energy of others. I have seen people work Tuesday through Friday to correct mistakes made after 5 PM on Monday. Another problem is that people who are in the office long hours are not pleasant company. They often complain about other people (who aren't working as hard); they are irritable, or cranky, or even angry. Other people avoid them. Such behavior poses problems, where work goes much better when people work together instead of avoiding one another. As Managers, there are things we can do to help people leave the office. First and foremost is to set the example and go home ourselves. I work with a manager who chides people for working long hours. His words quickly lose their meaning when he sends these chiding groups e-mails with a time-stamp of 2 AM, Sunday. Second is to encourage people to put some balance in their lives. For instance, here is a guideline I find helpful: 1) Wake up, eat a good breakfast, and go to work. 2) Work hard and smart for eight or nine hours. 3) Go home. 4) Read the comics, watch a funny movie, dig in the dirt, play withyour kids, etc. 5) Eat well and sleep well. This is called recreating. Doing steps 1, 3, 4, and 5 enable step 2. Working regular hours and recreating daily are simple concepts. They are hard for some of us because that requires personal change. They are possible since we all have the power to choose to do them. In considering the issue of overtime, I am reminded of my oldest son. When he was a toddler, if people were visiting the apartment, he would not fall asleepno matter how long the visit, and no matter what time of day it was. He would fight off sleep until the visitors left. It was as if he was afraid that he would miss something. Once our visitors' left, he would go to sleep. By this time, however, he was over tired and would scream through half the night with nightmares. He, my wife, and I, all paid the price for his fear of missing out. Perhaps some people put in such long hours because they don't want to miss anything when they leave the office. The trouble with this is that events will never stop happening. That is life!! Things happen 24 hours a day. Allowing for little rest is not ultimately practical. So, take a nap. Things will happen while you're asleep, but you will have the energy to catch up when you wake. Hence LOVE YOUR JOB BUT NEVER FALL IN LOVE WITH YOUR COMPANY Have a great day ahead !! regards, Rajiva Srivastava HRD-DEL == Thanks Ram ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137337 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re:Can I Throw within cfscript???
Andy, I'm not sure this is what you are looking for, but I've done some pretty robust error trapping using this type of logic: cftry cfscript message = ; errors = 0; if ( NOT IsDefined('foo') ) { message = You must define foo; errors = 1; } /cfscript cfif errors EQ 1 cfthrow message=#message# type=goBack /cfif cfcatch type=goBack cfinclude template=[path]/errGoBack.cfm /cfcatch cfcatch type=Any cfinclude template=[path]/errAny.cfm /cfcatch /cftry Bryan, This is not the same code. All you are doing is returning from a function call. You are NOT throwing an exception within test. Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137338 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Having problem comparing variables and returning the correct results
Hi, I'm having a problem displaying some directories. Below are two sample variables which I get from my database. These are inserted into the database from another template that has checkboxes and then once submitted the database gets re-populated. That is not my problem though. It's displaying the directory tree. There are other variables in my sample which I haven't supplied code for because the problem I think is just in my cfif statement comparing the two variables. When I run the code below not all the subdirectories get listed within \reports\csl\. Only the SGML directory. Why? I know I'm checking for just an occurence but how can I do an exact match for just D:\reports\csl only and not include D:\reports\csl\sgml\tse\tsed or D:\reports\csl\sgml\tse\tsem? If I remove the directories D:\reports\csl\sgml\tse\tsed and D:\reports\csl\sgml\tse\tsem then everything works properly. It's matching on the sgml and only listing that directory. I only want it to match up to the third \ and NOTHING past. I know...I'm rambling...I hope I'm making sense! ;-D How can I do this? URLDecode(dir) = d:\reports\csl\ SESSION.DisplayShowMe = D:\reports\aclg, D:\reports\breg, D:\reports\cdir, D:\reports\cfam, D:\reports\chfl, D:\reports\cmtgl, D:\reports\cpen, D:\reports\cres, D:\reports\csl, D:\reports\csl\sgml\tse\tsed, D:\reports\csl\sgml\tse\tsem, D:\ed_depot cfif FindNoCase(URLDecode(dir),SESSION.DisplayShowMe) cfoutput tr td class=dirlinks align=right#indent#/td td valign=bottom width=16 height=13 a href=#cgi.script_name#?dir=#URLEncodedFormat(dir)##URLEncodedFormat(SESSION.stDirFileName[i])#\ class=dirlinks alt=#SESSION.stDirFileName[i]#img src=images/folder-closed.gif border=0nbsp;/a /td td valign=middle width=100% !--- Display directory folders --- a href=#cgi.script_name#?dir=#URLEncodedFormat(dir)##URLEncodedFormat(SESSION.stDirFileName[i])#\ class=dirlinks alt=#SESSION.stDirFileName[i]# #SESSION.stDirFileName[i]#/a /td /tr /cfoutput /cfif ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137339 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: advice
Puuuhhhlze! We've added so much to the genre. Go to any of the major american cities (or at least the ones I've lived in) and you'll find pizza thats pretty close to what you find in italy. And it only starts there. Theres so many other wonderful kinds of pizzas that you'll only find in america. DRE -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:21 AM To: CF-Talk Subject: Re: advice Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... I am sorry to sound pedandic, but pizza is clearly the most important contribution to modern civilization coming from Italy and definitely deserve a better treatment :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137340 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
CFMX 6.1 and JRun 4
We have had CFMX and JRun 4 coexisting peacefully on a W2K server for months, blissfully ignorant of each other. Last week we upgraded CF to 6.1 and now it appears that JRun is interfering with CF somehow. CF was grinding to a halt on a regular basis until we disabled the services for the JRun servers. Does anyone know anything about this? Thanks Nick ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137341 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
OT: N/N Group Conference
Is anyone going to the Nielson Norman Group User Experience Conference next week? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137342 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: advice
That is why I did specify American Pizza ;o) and the beef is just different not better or worse just different -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:21 AM To: CF-Talk Subject: Re: advice Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... I am sorry to sound pedandic, but pizza is clearly the most important contribution to modern civilization coming from Italy and definitely deserve a better treatment :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137343 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
SSL / Flash Remoting / CFMX
Any issues here? Has anyone done this yet? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137345 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
integrating Cybersource credit-card processing
Folks, I'm working on integrating creditcard processing from Cybersource. I work in a mixed environment of Linux and Windows so we're planning on using the Java web services interface. I've managed to get their demonstration web service clients working on the command line, but I'm having trouble with using CFINVOKE to consume their webservice. I've gotten closest with the NVP (name/value pairs) interface to the web service -- I get something like this: Web service operation runTransaction with parameters {INPUT={{MERCHANTID={myId},}},} could not be found. The XML interface just dies. Anyone done this successfully? Regards, John Paul Ashenfelter CTO/Transitionpoint ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137344 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: integrating Cybersource credit-card processing
I'm working on integrating creditcard processing from Cybersource. I work in a mixed environment of Linux and Windows so we're planning on using the Java web services interface. I've managed to get their demonstration web service clients working on the command line, but I'm having trouble with using CFINVOKE to consume their webservice. I've gotten closest with the NVP (name/value pairs) interface to the web service -- I get something like this: Web service operation runTransaction with parameters {INPUT={{MERCHANTID={myId},}},} could not be found. The XML interface just dies. Anyone done this successfully? I successfully used their Java API. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137346 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: advice
Bruce, Rodney S HQISEC/Veridian IT Services [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] That is why I did specify American Pizza ;o) Yes, but using the word pizza for that thing should be illegal :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137347 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: advice
Oh you would love it Massimo, one of the major national pizza chains is running a promotion on a new pizza concoction. They call it the Philly Cheese Steak pizza! :-) -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:21 AM To: CF-Talk Subject: Re: advice Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) Let's be real, what you have there in the USA really shouldn't be called pizza... It's really very far away from the *real* thing... I am sorry to sound pedandic, but pizza is clearly the most important contribution to modern civilization coming from Italy and definitely deserve a better treatment :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137348 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
cfcookie and browser back button - causes page refresh - help?
Hi y'all I have a new issue that has me stumped. Maybe if i talk it out, someone will know the answer. I have a CFMX include (tho the same thing probably happens in a CF5 environment tho i haven't gone back and tested it) that i'm using to create a popcorn trail at the top of all the pages in my site. We opted to use cookies to do this (yes, there are a million other ways)... and i've recently discovered this is causing a problem. There is something in the code shown at the bottom of this note that is causing my problem. If I leave the code uncommented, the code executes and cookies are properly created -- yet if i use the browser back key on any page, the previous page (which also executes the same code) re-executes - even tho the traditional back button action is to just display the page as it was. The real problem occurs when the previous page was a form - the refresh forces all of the user entered data to be lost and I don't want that to happen! If I comment out the code, everything works ok (tho the popcorn trail obviously isn't created) - but the back button in the browser does NOT cause the page to refresh automatically. Does anyone know WHY this code would cause the browser to force a page refresh in both IE5.5 and NS 4.73?? (Stuck there due to work requirements - can't go to newer browsers - sorry I can't share a link with the group - 'tiz inside a firewall) Here's the code that seems to be the problem: cfif get_page.menuLevel eq 1 !--- If cookie 1 already exists - delete and set new --- cfif isdefined(cookie.#site.siteName#cookie1) !--- If the cookie1 is already defined, delete and create new --- !--- Delete Old! --- cfcookie name=#site.siteName#cookie1 value=a href='index.cfm?#cgi.QUERY_STRING#'font color='ff'#get_page.menuTitle#/font/a expires=NOW !--- Create New! --- cfcookie name=#site.siteName#cookie1 value=a href='index.cfm?#cgi.QUERY_STRING#'font color='ff'#get_page.menuTitle#/font/a expires=1 !--- If a new cookie1 is being set, and cookie2 exists, delete cookie2 --- cfif isdefined(cookie.#site.siteName#cookie2) !--- Delte Old! --- cfcookie name=#site.siteName#cookie2 value=a href='index.cfm?#cgi.QUERY_STRING#'font color='ff'#get_page.menuTitle#/font/a expires=NOW /cfif !--- If cookie1 does not exist - create --- cfelse !--- Set the cookie! --- cfcookie name=#site.siteName#cookie1 value=a href='index.cfm?#cgi.QUERY_STRING#'font color='ff'#get_page.menuTitle#/font/a expires=1 /cfif cfelse cfif isDefined(URL.debug) not level 1br/cfif /cfif ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137349 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
OT: Linux Newbie Advice
Hey All, OK...so I'm going to give this open source hippie stuff a whirl ;-) I have an old AMD K6-2 400 MHz box with Win2K Pro currently installed One big issue is the passwords for this box have been lost. So can I simply install Linux over Windows (i.e. from boot up)? or do I have to wipe the drive first (FDisk)? What do you Linux folks recommend for a Linux package to install (i.e. RedHat version...Mandrake etc.)? Bear in mind I know very little about Linux and I don't want to play the command line game. So a package that has a decent GUI would be nice (I've seen and played a bit with X Windows...seemed nice...but what do I know...hehe). So at this point...any and all advice is welcome (and feel free to send me info offlist). TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137350 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: OT: Linux Newbie Advice
So can I simply install Linux over Windows (i.e. from boot up)? or do I have to wipe the drive first (FDisk)? Yes, you can simply install Linux over Windows assuming you don't want access to any of the data on the hard drive. What do you Linux folks recommend for a Linux package to install (i.e. RedHat version...Mandrake etc.)? Bear in mind I know very little about Linux and I don't want to play the command line game. So a package that has a decent GUI would be nice (I've seen and played a bit with X Windows...seemed nice...but what do I know...hehe). I always recommend RedHat to people since it is the most widely used distribution and thus it is easier to get help from others with. After you become more familiar with Linux in general then you can start worrying about why you would choose one distribution over the others. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137351 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Linux Newbie Advice
Thanks Matt So what's the current RedHat version that is stable? where can I grab a copy? Is it installed from a floppy/CD at boot up? I promise to RTFM after I get the dang thing ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM Subject: Re: OT: Linux Newbie Advice So can I simply install Linux over Windows (i.e. from boot up)? or do I have to wipe the drive first (FDisk)? Yes, you can simply install Linux over Windows assuming you don't want access to any of the data on the hard drive. What do you Linux folks recommend for a Linux package to install (i.e. RedHat version...Mandrake etc.)? Bear in mind I know very little about Linux and I don't want to play the command line game. So a package that has a decent GUI would be nice (I've seen and played a bit with X Windows...seemed nice...but what do I know...hehe). I always recommend RedHat to people since it is the most widely used distribution and thus it is easier to get help from others with. After you become more familiar with Linux in general then you can start worrying about why you would choose one distribution over the others. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137353 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Linux Newbie Advice
hippy stuff? LOL! I guess a proper introduction to this would be RTFM! Ha! Yeah, you should be able to grab redhat, mandrake, etc and install right over your windows install. The installers usually run a proggy to partition/format your drive and all. What flavour to use? Try them all and settle on the one you like. Redhat is fairly popular, a good start probably. I've been a Slackware fan myself, but that's real old skool hippy like I suppose. http://linuxiso.org for all of them. Have fun! Doug -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:09 PM To: CF-Talk Subject: OT: Linux Newbie Advice Hey All, OK...so I'm going to give this open source hippie stuff a whirl ;-) I have an old AMD K6-2 400 MHz box with Win2K Pro currently installed One big issue is the passwords for this box have been lost. So can I simply install Linux over Windows (i.e. from boot up)? or do I have to wipe the drive first (FDisk)? What do you Linux folks recommend for a Linux package to install (i.e. RedHat version...Mandrake etc.)? Bear in mind I know very little about Linux and I don't want to play the command line game. So a package that has a decent GUI would be nice (I've seen and played a bit with X Windows...seemed nice...but what do I know...hehe). So at this point...any and all advice is welcome (and feel free to send me info offlist). TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137352 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Linux Newbie Advice
Bryan, As a Linux Newbie, I'd recommend you look at Mandrake for this first toe in the water. Mandrake is very friendly to noobs, and you'll be able to get up and running in no time. RedHat is better known, and their installer gets better and better with each iteration, but I think Mandrake will be a little more forgiving :) Not to knock RedHat, though. I've had version 8 running on an old Compaq Presario minitower for a year with no reboots, except for when I moved and had to power down for a few days. - Jim Bryan Stevenson wrote: Thanks Matt So what's the current RedHat version that is stable? where can I grab a copy? Is it installed from a floppy/CD at boot up? I promise to RTFM after I get the dang thing ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM Subject: Re: OT: Linux Newbie Advice So can I simply install Linux over Windows (i.e. from boot up)? or do I have to wipe the drive first (FDisk)? Yes, you can simply install Linux over Windows assuming you don't want access to any of the data on the hard drive. What do you Linux folks recommend for a Linux package to install (i.e. RedHat version...Mandrake etc.)? Bear in mind I know very little about Linux and I don't want to play the command line game. So a package that has a decent GUI would be nice (I've seen and played a bit with X Windows...seemed nice...but what do I know...hehe). I always recommend RedHat to people since it is the most widely used distribution and thus it is easier to get help from others with. After you become more familiar with Linux in general then you can start worrying about why you would choose one distribution over the others. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137354 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Using data from HTTP post
Hello all, A site I am working on is going to feature some live data feeds from a 3rd party. The third party has their system setup to send data via http post, and they want a url to send to. My problem is I don't know how to use their data. I've worked with http post/variables, but never with raw data. If someone has any idea how to start me off in the right direction, I'd greatly appreciate it. The data sample provided: 1 #CSXTSWSAM010309120845/ 2 CLMDFR CSXT DJJOSE03091208DJC 3 ACFX 11 BERKELEY SC 09 12 0641 L W TOLEDOOH 4 ACRX 11 CASHAYNE NC 09 11 1339 E W BERKELEY SC 5 BNSF 11 CUMBERLAN MD 09 12 0730 L A Q14811 BALTIMORE MD 6 CSXT 11 THOMASVIL GA 09 12 0745 L A Q54511 BERKELEY SC 7 CSXT 11 CALERAAL 09 11 2230 L P Q68111 BERKELEY SC 8 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 9 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 10 CSXT 11 THOMASVIL GA 09 12 0745 L A Q54511 BERKELEY SC 11 CSXT 11 WAYCROSS GA 09 12 0820 L A Q68110 BERKELEY SC 12 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 13 CSXT 11 CHARLESTO SC 09 11 2315 L P F74611 BERKELEY SC 14 CSXT 11 CALERAAL 09 11 2230 L P Q68111 BERKELEY SC 15 CSXT 11 WAYCROSS GA 09 12 0820 L A Q68110 BERKELEY SC I was thinking I could build a struct or array with this, splitting lines with / line breaks, and determining item[x] of each line by the spaces. I just don't know how to get at the data to manipulate it since its not being passed as a named variable (like a form). Thanks in advance, Chris ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137355 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: OT: Linux Newbie Advice
So what's the current RedHat version that is stable? where can I grab a copy? I am currently sticking with RedHat 7.x myself. You could download the ISOs directly from RedHat's FTP and just burn them to CD if you want. You can also buy directly from RedHat, which has the advantage of free technical support. Is it installed from a floppy/CD at boot up? Most of the current distributions boot up from CDs. Further, they tend to provide floppy images on the CD in case you need to create a floppy for machines that can't boot from CD. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137356 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: advice
Kris, No, not France! Anywhere but France. :-) Also, don't go getting yourself one of those Mad-Cow burgers over there. Stick with pork in Europe (they don't have trichinosis [sp?] over there so you can eat it medium-rare). On the pizza thing, any of you Euro-pizza-purists ever had Chicago style? Try it before you condemn American pizza. Greg -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:17 AM To: CF-Talk Subject: RE: advice So the beef in europe is not as good in US huh? I am going for final semester of my MBA so I will fo in Feb tehn graduate in france on july 8th -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:14 PM To: CF-Talk Subject: RE: advice Was in the Army and lived a total of 9 yrs in Europe. I loved it. 3 in Germany and 6 in Netherlands. Wish I could have spent more time there. Would recommend it to anyone that can live on food other than American Pizza and Cheeseburgers ;o) -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:59 AM To: CF-Talk Subject: RE: advice Yeah that's what im thinking, its only 6 months -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 11:56 AM To: CF-Talk Subject: RE: advice I've worked overseas in Switzerland. I would strongly recommend doing it. If anything for the experience. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 14:46 To: CF-Talk Subject: advice Anyone on the list ever study/work /been overseas Trying to make a decsion about finishing my MBA overseas and wanted to speak to someone who has done it Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137357 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Using data from HTTP post
My problem is I don't know how to use their data. I've worked with http post/variables, but never with raw data. If someone has any idea how to start me off in the right direction, I'd greatly appreciate it. One trick you might be interested in is turning that data into XML so it is easily used from CF. http://archive.devx.com/java/free/articles/ml040802/ml040802-1.asp is an article I wrote on how to do this with CSV files. I was thinking I could build a struct or array with this, splitting lines with / line breaks, and determining item[x] of each line by the spaces. I just don't know how to get at the data to manipulate it since its not being passed as a named variable (like a form). You would use GetHTTPRequestData(), which returns a struct containing everything --including RAW request data-- from the request. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137358 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: OT: Linux Newbie Advice
So what's the current RedHat version that is stable? where can I grab a copy? I am currently sticking with RedHat 7.x myself. You could download the ISOs directly from RedHat's FTP and just burn them to CD if you want. You can also buy directly from RedHat, which has the advantage of free technical support. Just to take Matt's 7.x endorsement one step further, if you plan to use CF on this machine, you will need to have RedHat 7.2 (or earlier) to use Verity because of the Verity binary version restrictions. While CFMX 6.1 officially supports later versions of RedHat, Verity is not. Regards, Dave. _ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137359 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: SSL / Flash Remoting / CFMX
I've got a site running using SSL/remoting/CFMX, no problems.. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:30 AM To: CF-Talk Subject: SSL / Flash Remoting / CFMX Any issues here? Has anyone done this yet? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137360 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: OT: Linux Newbie Advice
RedHat 9.0 is in wide use and is supported by CFMX 6.1 Purchasing the package for about $39.00 at Best Buy will give you free support and updates (which seem to come about as often as the ones from Microsoft.) When doing the install, be sure to install KDE desktop if you are wanting a GUI to work with. Or if you are wanting to maintain it remotely, install Webmin. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:23 PM Subject: Re: OT: Linux Newbie Advice | Thanks Matt | | So what's the current RedHat version that is stable? where can I grab a | copy? | | Is it installed from a floppy/CD at boot up? | | I promise to RTFM after I get the dang thing ;-) | | Cheers | | Bryan Stevenson B.Comm. | VP Director of E-Commerce Development | Electric Edge Systems Group Inc. | t. 250.920.8830 | e. [EMAIL PROTECTED] | | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder Director | www.cfug-vancouverisland.com | - Original Message - | From: Matt Liotta [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, September 17, 2003 12:14 PM | Subject: Re: OT: Linux Newbie Advice | | | So can I simply install Linux over Windows (i.e. from boot up)? or do | I have | to wipe the drive first (FDisk)? | | Yes, you can simply install Linux over Windows assuming you don't want | access to any of the data on the hard drive. | | What do you Linux folks recommend for a Linux package to install (i.e. | RedHat version...Mandrake etc.)? Bear in mind I know very little about | Linux and I don't want to play the command line game. So a package | that has | a decent GUI would be nice (I've seen and played a bit with X | Windows...seemed nice...but what do I know...hehe). | | I always recommend RedHat to people since it is the most widely used | distribution and thus it is easier to get help from others with. After | you become more familiar with Linux in general then you can start | worrying about why you would choose one distribution over the others. | | Matt Liotta | President CEO | Montara Software, Inc. | http://www.MontaraSoftware.com | (888) 408-0900 x901 | | | | ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137361 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: advice
Okay guys -- this thread has gone on long enough. Time to kill it, please. -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:44 AM To: CF-Talk Subject: Re: advice Bruce, Rodney S HQISEC/Veridian IT Services [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] That is why I did specify American Pizza ;o) Yes, but using the word pizza for that thing should be illegal :-))) Massimo ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137362 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: advice
OK, well past time for this thread to head over to CF-Community. Thanks ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137363 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: Linux Newbie Advice
Can WebAdmin work with other GUIs (i.e. could I have Mandrake with X Windows installed and still use WebAdmin)? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Doug White [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:59 PM Subject: Re: OT: Linux Newbie Advice RedHat 9.0 is in wide use and is supported by CFMX 6.1 Purchasing the package for about $39.00 at Best Buy will give you free support and updates (which seem to come about as often as the ones from Microsoft.) When doing the install, be sure to install KDE desktop if you are wanting a GUI to work with. Or if you are wanting to maintain it remotely, install Webmin. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:23 PM Subject: Re: OT: Linux Newbie Advice | Thanks Matt | | So what's the current RedHat version that is stable? where can I grab a | copy? | | Is it installed from a floppy/CD at boot up? | | I promise to RTFM after I get the dang thing ;-) | | Cheers | | Bryan Stevenson B.Comm. | VP Director of E-Commerce Development | Electric Edge Systems Group Inc. | t. 250.920.8830 | e. [EMAIL PROTECTED] | | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder Director | www.cfug-vancouverisland.com | - Original Message - | From: Matt Liotta [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, September 17, 2003 12:14 PM | Subject: Re: OT: Linux Newbie Advice | | | So can I simply install Linux over Windows (i.e. from boot up)? or do | I have | to wipe the drive first (FDisk)? | | Yes, you can simply install Linux over Windows assuming you don't want | access to any of the data on the hard drive. | | What do you Linux folks recommend for a Linux package to install (i.e. | RedHat version...Mandrake etc.)? Bear in mind I know very little about | Linux and I don't want to play the command line game. So a package | that has | a decent GUI would be nice (I've seen and played a bit with X | Windows...seemed nice...but what do I know...hehe). | | I always recommend RedHat to people since it is the most widely used | distribution and thus it is easier to get help from others with. After | you become more familiar with Linux in general then you can start | worrying about why you would choose one distribution over the others. | | Matt Liotta | President CEO | Montara Software, Inc. | http://www.MontaraSoftware.com | (888) 408-0900 x901 | | | | ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137364 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Linux Newbie Advice
Bryan, Overall, I found SuSE 8.2 to be the easiest to install on an older machine. I'm a complete Linux newbie and didn't want to fool with the comand line during installation. SuSE install was straightforward and went without any hitches. It even recognized my windows network connection and DHCP and I can surf the net without any additional configuration. Others I tried: - I could install Mandrake 7.2, but it didn't recognize the D-Link DFE-530TX+ (my ethernet card). I found a Linux driver but coudn't really follow the install instructions, so I bailed out. - I couldn't install RedHat 9.1 because it didn't seem to work with my video card. My computer is old enough that I don't even have an AGP port. So RedHat 9.1 was out of the question (although I installed it on my laptop without issue). I picked SuSE because it had a reputation for ease of installation and it supposedly will support CFMX 6.1, although I have not tried installing CF yet. Hope this helps, from one newb to another. Oh yeah, I installed Linux right over Windows 98 -- it wipes the drive. -- Marc A. Garrett since1968.com Bryan Stevenson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hey All, So can I simply install Linux over Windows (i.e. from boot up)? or do I have to wipe the drive first (FDisk)? ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137365 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Urgent: Performance Help
No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137366 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Urgent: Performance Help
Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137369 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Linux Newbie Advice
One big issue is the passwords for this box have been lost. Are you concerned about recovering the data on the machine? If so, installing Linux won't necessarily help you (especially if you end up repartitioning or reformatting). You might want to try NT Locksmith and/or NT Recover: http://www.winternals.com/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137368 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT: Linux Newbie Advice
Can WebAdmin work with other GUIs (i.e. could I have Mandrake with X Windows installed and still use WebAdmin)? Yes, it does. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137367 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Urgent: Performance Help
access has been known at some point (amount of connections or maybe lines in the database) to hose up, what that means? not sure, but I know this, if at all possible, STAY AWAY FROM ACCESS tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137371 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Urgent: Performance Help
Show do they know its you if they can't prove it? One guess is that they may be view database connections from perfmon which may be pointing to your domain. How big is your access DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137370 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Urgent: Performance Help
Access tends to 'abandon' connections... a fair amount of memory loss with any large usage on a server.. Access isn't good at all for shared hosting company environments... Easy way to hose a server... Find out if they have your DSN maintaining connections ... depending on the application you will or won't want to enable maintain connections... I have found that if your are doing lots of database activity to leave it on with Access... There is also the timeout to maintain DSN connection... try putting that at 1-5 minutes.. probably set at 0 default now... -paris -- Original Message -- From: Tony Weeg [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 16:33:45 -0400 access has been known at some point (amount of connections or maybe lines in the database) to hose up, what that means? not sure, but I know this, if at all possible, STAY AWAY FROM ACCESS tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137372 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: Linux Newbie Advice
Webmin (and usermin) should work with any Linux distro - but to be sure, read the docs on sourceforge == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:09 PM Subject: Re: OT: Linux Newbie Advice | Can WebAdmin work with other GUIs (i.e. could I have Mandrake with X Windows | installed and still use WebAdmin)? | | Bryan Stevenson B.Comm. | VP Director of E-Commerce Development | Electric Edge Systems Group Inc. | t. 250.920.8830 | e. [EMAIL PROTECTED] | | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder Director | www.cfug-vancouverisland.com | - Original Message - | From: Doug White [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, September 17, 2003 12:59 PM | Subject: Re: OT: Linux Newbie Advice | | | RedHat 9.0 is in wide use and is supported by CFMX 6.1 | | Purchasing the package for about $39.00 at Best Buy will give you free | support | and updates (which seem to come about as often as the ones from | Microsoft.) | | When doing the install, be sure to install KDE desktop if you are wanting | a GUI | to work with. Or if you are wanting to maintain it remotely, install | Webmin. | | == | Stop spam on your domain, use our gateway! | For hosting solutions http://www.clickdoug.com | Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. | ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 | Suggested corporate Anti-virus policy: | http://www.dshield.org/antivirus.pdf | == | If you are not satisfied with my service, my job isn't done! | | - Original Message - | From: Bryan Stevenson [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, September 17, 2003 2:23 PM | Subject: Re: OT: Linux Newbie Advice | | | | Thanks Matt | | | | So what's the current RedHat version that is stable? where can I grab a | | copy? | | | | Is it installed from a floppy/CD at boot up? | | | | I promise to RTFM after I get the dang thing ;-) | | | | Cheers | | | | Bryan Stevenson B.Comm. | | VP Director of E-Commerce Development | | Electric Edge Systems Group Inc. | | t. 250.920.8830 | | e. [EMAIL PROTECTED] | | | | - | | Macromedia Associate Partner | | www.macromedia.com | | - | | Vancouver Island ColdFusion Users Group | | Founder Director | | www.cfug-vancouverisland.com | | - Original Message - | | From: Matt Liotta [EMAIL PROTECTED] | | To: CF-Talk [EMAIL PROTECTED] | | Sent: Wednesday, September 17, 2003 12:14 PM | | Subject: Re: OT: Linux Newbie Advice | | | | | | So can I simply install Linux over Windows (i.e. from boot up)? or | do | | I have | | to wipe the drive first (FDisk)? | | | | Yes, you can simply install Linux over Windows assuming you don't want | | access to any of the data on the hard drive. | | | | What do you Linux folks recommend for a Linux package to install | (i.e. | | RedHat version...Mandrake etc.)? Bear in mind I know very little | about | | Linux and I don't want to play the command line game. So a package | | that has | | a decent GUI would be nice (I've seen and played a bit with X | | Windows...seemed nice...but what do I know...hehe). | | | | I always recommend RedHat to people since it is the most widely used | | distribution and thus it is easier to get help from others with. After | | you become more familiar with Linux in general then you can start | | worrying about why you would choose one distribution over the others. | | | | Matt Liotta | | President CEO | | Montara Software, Inc. | | http://www.MontaraSoftware.com | | (888) 408-0900 x901 | | | | | | | | | | ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137373 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics.
Re: Linux Newbie Advice
Are you concerned about recovering the data on the machine? If so, installing Linux won't necessarily help you (especially if you end up repartitioning or reformatting). You might want to try NT Locksmith and/or NT Recover: Assuming NTFS wasn't used then the file system could be accessed directly from Linux without issue. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137374 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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