RE: FED-Ex API calls
Now why on earth would you want to interface with FedEx? :) After all UPS is now Synchronizing Commerce. Rob UPS Developer -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:18 AM To: CF-Talk Subject: FED-Ex API calls Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FED-Ex API calls
What version of CF are you trying to do this with? From what I know of the FedEx API, you can connect to it with Java, hence you should be able to write a servlet/web service for Jrun/CFMX. Another option is that you can use COM objects to connect with FedEx. I would think you create a CFOBJECT to instantiate the object and connect to it using cfscript. Just my thoughts. I'd help more, but downloading FedEx's api on a UPS machine would probably be a fireable offence. :) Rob -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:36 AM To: CF-Talk Subject: RE: FED-Ex API calls Believe I wanted to go the UPS route, but I had no choice. I assume the Fed-Ex was the low bidder on the contract and won - that's about all I know about it. I am just a developer doing what I am told to do. Yes the logo is nicer and I do want to drive the big brown truck :-) But serious if anyone has any info it would really help. Thanks Mario -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:23 AM To: CF-Talk Subject: RE: FED-Ex API calls Now why on earth would you want to interface with FedEx? :) After all UPS is now Synchronizing Commerce. Rob UPS Developer -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 10:18 AM To: CF-Talk Subject: FED-Ex API calls Hi, Has anyone been able to code a Cold Fusion page that can talk successfully with the Fed-Ex Ship API. I have take a look on their site and as usually all the examples are in ASP/ASP.NET or Java. I am trying to do this with CF of course. If anyone has any info on this with using CF or even ASP or Java, can you let me know how you accomplished this. I cannot get it to work at all. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DevCon 2003
Please try to keep personal political views out of the discussions on this list. I read the messages on here to keep informed of ColdFusion items in the world, not hear disparaging remarks about the President, the War or any other global issues. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 3:07 PM To: CF-Talk Subject: Re: DevCon 2003 Yes on the UG Manager list someone asked today if a location had been nailed down yet. Well no answer yet and MM just cancelled a new event (due to the illegal war) they had been playing up bigtime the past 2 weeksso who knows what'll happen to DevCon :-| 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: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:51 AM Subject: RE: DevCon 2003 Goodness, this may change a lot. If it's still going to be in Sept., we only have 6 months to go (and one week to budget for it) -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] I'm not 100% sure, but on the user group manager list I think it was mentioned that DevCon may be on the east coast (not a central loaction that would make sensebut that's a whole different rant). ;-) 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] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
URL Parameter list?
I know I can loop through form variables by using Form.FieldNames as a list, but is there a similar ability to loop through the URL Parameter? (IE. I use form action get instead of post). I need this ASAP as I have to turn over a project today. Thanks, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URL Parameter list?
Thanks for all the help. What I ended up doing was cfif isDefined(URL.fuseaction) cfloop collection=#URL# item=fname cfif #Evaluate(URL. fname)# neq cfset paramlist = paramlistfname = URLEncodedFormat(#StructFind(URL, fname)#) /cfif /cfloop /cfif DANGIT.. I JUST realized that all I'm doing there is passing the query string from one parameter to another. cfset paramlist= #CGI.QUERY_STRING# Does the same thing I was trying to do in the first place! Chalk it up to a bad Friday. Thanks anyway, Rob -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 1:35 PM To: CF-Talk Subject: Re: URL Parameter list? Rob, You can use CFSCRIPT and PARSE the URL. It's a pain in the butt! I feel your pain I just ran into this issue where I had a requirement to use GET, do to an IE issue with a JavaScript reload to a Parent window from a child window. My work around was in the end to just use a self submitting form and set the form variables to SESSION variables then where I needed the variables I set them to the proper scope and CFLOCKed them down. Regards, James Blaha Edwards Robert (air0rae) wrote: I know I can loop through form variables by using Form.FieldNames as a list, but is there a similar ability to loop through the URL Parameter? (IE. I use form action get instead of post). I need this ASAP as I have to turn over a project today. Thanks, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Wrox and Friends of Ed closing.
I don't know it was mentioned on the list yet or not, but Wrox press and Friends of Ed books are closing their doors. It appears that their parent company, Peer Publishing has filed for bankruptcy. Apparently all employees have been let go and many authors are not going to be getting all of the royalties that were promised to them. If there are any MacromediaMX books from Friends of Ed you want, I suggest you get them now. Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.
What database were you using? Oracle has known problems with CFUPDATE and CFINSERT. -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:19 PM To: CF-Talk Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MDAC 2.7
MDAC 2.6 and higher does not provide JET Data components. JET is the microsoft access format. You may need to download the following file. http://download.microsoft.com/download/dasdk/Install/40SP3/WIN98Me/EN-US/Jet 40SP3_Comp.exe -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 2:57 PM To: CF-Talk Subject: MDAC 2.7 Hello, I just installed MDAC 2.7 on my win 2k pro machine with CF4.5. Everythign seemed fine during the install, but now I can't connect to any of my data sources. None of them will verify in the administrator. Currenly they are all access DB's. Any ideas. Any way to uninstall MDAC 2.7. Every thing was fine before, I just thought I would keep up with the times. I guess I should of left well enought alone. Jeremy -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:40 AM To: CF-Talk Subject: Re: Clearing Cached Pages Dave, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated To stop a page from being cached by a users browser you need to use the following HTML meta tags in your pages : META http-equiv='expire' content='0' META http-equiv='pragma' content='no-cache' I suspect that if the user has set their internet options to never check for page changes then you will be a bit stuck, but any of the other settings should pick up the addition of these tags and clear their cache or at least force their browser to load a new copy of the page. Regards Stephen == CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query of Queries w/ subquery in CF 5?
I am using ColdFusion 5 Enterprise Edition. I have 2 separate oracle databases that cannot communicate to each other, but the web server can communicate to them individually. I am pulling back data from to queries as such. Query 1: Machine1 null Loc1 Machine2 null Loc2 Machine3 null Loc3 Machine4 null Loc4 Query2 null Machine1 Loc1 null Machine3 Loc3 null Machine4 Loc4 null Machine5 Loc5 I am trying to get a union query with nested selects to work as such Select * from Query1 where Q1MachineName not in (Select Q2MachineName from Query2) UNION Select * from Query2 where Q2MachineName not in (Select Q1MachineName from Query1) So I end up with Machine2 null Loc2 null Machine5 Loc5 The problem is, when I run the union query above, I get the error Query Manipulation Error Code = 0 Can't find symbol: select Any suggestions as to what I am doing wrong? Thanks, Rob Edwards ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfuion journal archives
I'm trying to read the Cold Cup of Joe articles in the CFDJ archives. When accessing, it says I need to enter my Access Code. I am a subscriber to the journal, but where do I find my access code? Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFAdvocacy.org: Looking for contributors
I think my mind's eye just went blind -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 2:10 PM To: CF-Talk Subject: RE: CFAdvocacy.org: Looking for contributors You GO man! This is great! GO CF! Its your birthday! Go CF! We go'n party like its yo birthday! *puts hands in air* Uh huh! *shakes booty* ^_^ Hows that for a start on contributions! -Gel j/k great idea though! We need something like this. .ASP/.NET proponents Have dozens of published case studies etc. to pull from Whereas I havent' seen Macromedia put out as convincing stuff on CF yet. This site is very exciting...hope the big wigs that know stuff respond :) *slinks back to CF-Community* -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] After spending way too much time in the past few weeks defending CF from utterly silly claims I've decided to create a web site to collect and present information about it. As Cfers we are all generally hit with statements like: +) CF isn't an enterprise-capable platform. +) CF is just a content management solution. +) CF isn't a standard like Java. +) Why bother with CF when ASP, JSP and PHP are free? +) CF lacks industry support so it'll just go away soon. ...and many others. cfAdvocacy.org will be a site to address these myths and reasonably compare CF to other solutions. I've done a skeleton site (it's up at www.cfadvocacy.org). What I'm looking for now is both feedback on that site (suggestions for needed content areas and so forth) and people willing to help me populate the site with information. I especially could use people good with multiple languages to do the comparisons. The goal of the site will be honest, clear reporting on CF as a solution. The site will be ever respectful of other solutions and views. In effect we will be giving CFers the tools and support they need to argue CF's case intelligently and clearly. You may contact me directly at [EMAIL PROTECTED] if you like. Comments, suggestions, criticisms? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Tag Reference PDF
There is a slightly newer poster that I found on TeraTech's website -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:35 AM To: CF-Talk Subject: Re: CF Tag Reference PDF - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 08:09 AM Subject: CF Tag Reference PDF I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): http://www.cfconf.org/cfconf-99/TeraTechCFtagPoster.pdf Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Tag Reference PDF
Dangit. Outlook closed on me before I could paste in the link. http://www.cfconf.com/cfun2k/tagposter.pdf It's dated 2000, so it probably is not much newer then 4.5 -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:35 AM To: CF-Talk Subject: Re: CF Tag Reference PDF - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 08:09 AM Subject: CF Tag Reference PDF I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): http://www.cfconf.org/cfconf-99/TeraTechCFtagPoster.pdf Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Subquery in query of queries in cf5
I am using ColdFusion 5 Enterprise Edition. I have 2 separate oracle databases that cannot communicate to each other, but the web server can communicate to them individually. I am pulling back data from to queries as such. Query 1: Machine1 null Loc1 Machine2 null Loc2 Machine3 null Loc3 Machine4 null Loc4 Query2 null Machine1 Loc1 null Machine3 Loc3 null Machine4 Loc4 null Machine5 Loc5 I am trying to get a union query with nested selects to work as such Select * from Query1 where Q1MachineName not in (Select Q2MachineName from Query2) UNION Select * from Query2 where Q2MachineName not in (Select Q1MachineName from Query1) So I end up with Machine2 null Loc2 null Machine5 Loc5 The problem is, when I run the union query above, I get the error Query Manipulation Error Code = 0 Can't find symbol: select Any suggestions as to what I am doing wrong? Thanks, Rob Edwards ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Subquery in Query of Queries on CF5
I am using ColdFusion 5 Enterprise Edition. I have 2 separate oracle databases that cannot communicate to each other, but the web server can communicate to them individually. I am pulling back data from to queries as such. Query 1: Machine1 null Loc1 Machine2 null Loc2 Machine3 null Loc3 Machine4 null Loc4 Query2 null Machine1 Loc1 null Machine3 Loc3 null Machine4 Loc4 null Machine5 Loc5 I am trying to get a union query with nested selects to work as such Select * from Query1 where Q1MachineName not in (Select Q2MachineName from Query2) UNION Select * from Query2 where Q2MachineName not in (Select Q1MachineName from Query1) So I end up with Machine2 null Loc2 null Machine5 Loc5 The problem is, when I run the union query above, I get the error Query Manipulation Error Code = 0 Can't find symbol: select Any suggestions as to what I am doing wrong? Thanks, Rob Edwards ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query of Queries in CF5 with Subquery
I am using ColdFusion 5 Enterprise Edition. I have 2 separate oracle databases that cannot communicate to each other, but the web server can communicate to them individually. I am pulling back data from to queries as such. Query 1: Machine1 null Loc1 Machine2 null Loc2 Machine3 null Loc3 Machine4 null Loc4 Query2 null Machine1 Loc1 null Machine3 Loc3 null Machine4 Loc4 null Machine5 Loc5 I am trying to get a union query with nested selects to work as such Select * from Query1 where Q1MachineName not in (Select Q2MachineName from Query2) UNION Select * from Query2 where Q2MachineName not in (Select Q1MachineName from Query1) So I end up with Machine2 null Loc2 null Machine5 Loc5 The problem is, when I run the union query above, I get the error Query Manipulation Error Code = 0 Can't find symbol: select Any suggestions as to what I am doing wrong? Thanks, Rob Edwards ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Company Name
Or he could call the interface Multi'Medias' Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 9:58 AM To: CF-Talk Subject: RE: Company Name mediamediamedia.com and then like for the interface m3 - powerful dynamic media, to the 3rd power. .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 9:53 AM To: CF-Talk Subject: RE: Company Name FigJamMedia.com ;o) -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 8:44 AM To: CF-Talk Subject: OT: Company Name Hi, I'm planning on starting up a company just for extra cash to put food on the table. I would be doing web development, Publishing print and electronic, data conversion, font development etc. I'm finding it difficult to come up with a company name that has the word media in it and having the same URL. somethingMedia.com Any ideas? --- FIGJAM --- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number. I know I've done it once before, but I can't remember what I did. For example, I have a query that will return something like the following: Machine1 Running Machine2Running Machine3Offline Machine4Running Machine5Offline Machine6Unknown I want to get some result like this: Running OfflineUnknownTotal 3 2 1 6 I know it has something to do with a sum and translating Running into 1, Offline into a 1 and Unknown into a 1, I just can't remember how I did it. This is an oracle 8i system I'm working with. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: CFQuery, Oracle and Limiting rows
I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
I've got code that does that already. (thanks for the offer anyway). my problem is that when I click the button to go to the next one hundred, the cfquery still returns 5000+ records but the cfloop goes to start row 101 and end row 200. I'm looking at possibilities with oracle's ROWNUM psudofield. If I figure out anything on my own, I'll post it here. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:01 AM To: CF-Talk Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows I had the same problem. I used a next/previous button system that showed 10 records at a time. If this is what you're looking for I'll post the code. Phil -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
Here's what i came up with (this is oracle 8.i+ specific) Select * from ( Obscenely long and complex query RANK() OVER (ORDER BY some_col ASC NULLS LAST) as Row_Rank ) Where Row_Rank between #startrow# and #endrow# This gives me 100 rows back at a time. I'm still getting an obscene time in the query so i'm trying to come up with ways to speed things up a little more. One idea is to rank on the primary table first as a subquery and then do the complex joins using the where in (subquery) clause so i only join on 100 rows at a time instead of 5000+. Another is to slightly denormalize (currently i have a complex left between join using ipranges) to speed up processing. Some background on this project (what little i am allowed to reveal): This is a tool that runs on every machine and checks in with a webserver/database on a given interval. The web server sets the interval by returning a time code. Lots of data sent in a small package including Mac address and ip address. Our IP addresses are broken down by building, so if i want to see machines in a given building i do something like (Where ipoc1 between ipocb1 and ipoce1 and ipco2 between ipcob2 and ipoce2 and ipoc3 between ipocb3 and ipoce3 and ipoc4 between ipocb4 and ipcoe4) with left joins done on the between to get null for any areas not in the iprange (the above code is basicly finding between each octet in the ip address). Yes, this does need to be real time so i can see at any given moment what machines are where and other information. One possibility is to determine the building when checking in and inserting the building name or id in the main table so i don't have to do 4 between joins for every ip address. Hence, the slight denormalization. Thanks for all the help though. Currently the processing time for all the rows is about 57000 milliseconds (57 seconds). If i get it working through the denormalization i'll post the time improvement here if anyone is interested. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:35 AM To: CF-Talk Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows Assuming you can do *TOP* within Oracle (i don't use it, so i don't know) and there is *any* field you can order by, the following works great for me (for SQL Server): select top X item_ID fromattorney where attorney_ID in ( select top Y attorney_ID fromattorney order byattorney_ID DESC ) order byattorney_ID where x = total number of rows you want and y = total_records - start_row if i have 1000 rows and want records 1 - 10 x = 10 y = 1000 - 1 + 1 = 1000 if i want 401 - 420 x = 20 y = 1000 - 401 + 1 = 600 Hope that helps. - j jim curran technical director nylon technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http
RE: CF vs. ASP
Ok, I think it's time for me to toss in my 2 cents (.75 cents Canadian). I am replying now, because most of this discussion took place after I went home yesterday. Truth is, I am an ASP developer. I have been for quite some time. I have been developing ASP since version 1.0 and have written some Big, Bad A** apps out there being used by some Fortune 500 firms (Not UPS mind you). I first learned CF in College (part of an internet development class covering CF, Java and other things). I thought it was a shame we didn't learn any ASP, so I approached my professor about it. I explained to him that I knew I was a proficient programmer (he knew as well from previous classes) and asked if I could do our database project in ASP instead of Cold Fusion. When each class got up to explain their code, it was pretty my the same, cfloop here, cfquery there... I got up and showed the ASP code off and the quicker response time (this was in the days of ASP 2.0 vs. CF 2.0, the book we used was BF's Web application Construction Kit 2nd Ed.) I was sold on ASP from that day forward and vowed never to use CF again. I started my own business and things went well for a while. Then I had a major collapse in the market I was trying to sell in and needed to find a steady job while still doing after hours work. UPS offered me a job as a Systems Management Engineer. When I started I wondered, Why did they hire me? I'm an MCSE, MCT and a lot of other TLA's and FLA's. But I had no experience in Tivoli and very little in Cold Fusion. Now, 7 months later, I consider myself very good in Cold Fusion and still learning Tivoli (my project is in web interfaces to Tivoli). In fact, I just finished a major component using CF. Having some perspective on the matter, I still think I like ASP a little better, but that's my opinion. I consider myself almost a VB expert (working on some articles for various M$ programming Mags.), so I like the granularity of ASP. If I had the tools of ASP and CF at my disposal (ASP is banned at UPS), I'd have to look at my situation. If I need something quick and easy and not a lot of fine control, I'd do it in CF easily. If I have more time and need finer control of details, I'd do it in ASP. I have found that most, if not everything that I can do in ASP, I can do in CF. In fact, I'm pushing my team to buy CF 5 or MX and get me out from the heel of CF 4.0. I think I misjudged CF some years ago, but that was when CF didn't look that good to me. (In fact, I'm working on some ideas of Fusebox for ASP.Net myself) One last thing to add to my rant. I think the code on sending e-mail was very skewed. To someone that doesn't know CF very well, it looks like it takes 25+ lines to do what CF does in 1. The code should have been more a comparison as follows: Set MyMail = CreateObject(CDONTS.NewMail) MyMail.From = [EMAIL PROTECTED] MyMail.To = [EMAIL PROTECTED] MyMail.Subject = Information Request MyMail.BodyFormat = 1 'plain text MyMail.MailFormat = 1 'plain text MyMail.Body = MsgText MyMail.Send Set MyMail = Nothing cfmail to= from= server= subject=some stuff here./cfmail That some stuff here encompasses a lot of code to make the body of the e-mail when comparing the two. (*Any opinions expressed are mine and mine alone, they do not reflect those of my employers) Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 11:28 PM To: CF-Talk Subject: Re: CF vs. ASP Matt I think the problem is that the alternative being discussed is from MSoft and the natural reaction is to barf if something is being shoved down your throat -- common sense and merits adide! Dick On Monday, August 26, 2002, at 06:20 PM, Matt Liotta wrote: People on this list are amazing. I haven't pointed out anything that is wrong with CF in this thread. I have simply pointed out that sometimes other solutions are better, which is far from hating CF. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox Books
Depends on the version of Fusebox you're planning to use. Fusebox 2.0, then read the Fusebox: Developing Cold Fusion Apps. Fusebox 3.0, then Discovering Fusebox 3. I've read them both and like the discovering fusebox 3 myself. Fusebox 3 is a little cleaner and more obvious for a OO Programmer. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 11:40 AM To: CF-Talk Subject: Fusebox Books Any recommendations of a Fuesbox book? The reviews at Amazon for Discovering Fusebox 3 and for Fusebox: Developing Cold Fusion Apps are about the same. Anyone here read them both?? Thanks, Scott __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with \ in a Javascript/Query
I have a page that populates a combo box via javascript. The data that is returned from a query is (quotes included) \\somemachine\somedir\some.exe. The Javascript sets the value via the code new Option('\\somemachine\somedir\some.exe','\\somemachine\somedir\some.exe' ) (that's the double quotes within single quotes if it's not too clear). The problem is, it translates out to \somemachine omedirsome.exe (the somedirectory begins with a t, so I'm thinking that it's translating it to a tab character). When I pass the selection to another page, it passes the tab and the formatting as translated, what I need is for the slashes and characters to be passed as that are in the DB. Is there anything I can do with regex or something to keep the slashes the way they are? Kind of like PreserveSingleQuotes. TIA, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with \ in a Javascript/Query
I kind of figured that. I forgot about the replace function and was trying to figure out how to do it with RegEx. Leave it to me to try to put a square peg in a round hole. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 9:46 AM To: CF-Talk Subject: Re: Problem with \ in a Javascript/Query In JS, the \ is the escape character, so (i think) if you just do some sort of replace to double-up all the slashes so it comes out in the js code as: somemachine\\somedir\\some.exe [EMAIL PROTECTED] 08/22/02 09:28AM I have a page that populates a combo box via javascript. The data that is returned from a query is (quotes included) \\somemachine\somedir\some.exe. The Javascript sets the value via the code new Option('\\somemachine\somedir\some.exe','\\somemachine\somedir\some.exe' ) (that's the double quotes within single quotes if it's not too clear). The problem is, it translates out to \somemachine omedirsome.exe (the somedirectory begins with a t, so I'm thinking that it's translating it to a tab character). When I pass the selection to another page, it passes the tab and the formatting as translated, what I need is for the slashes and characters to be passed as that are in the DB. Is there anything I can do with regex or something to keep the slashes the way they are? Kind of like PreserveSingleQuotes. TIA, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Nashville Anyone
What qualifies as close? Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:38 PM To: CF-Talk Subject: Nashville Anyone Is anyone here, In or close to Nashville? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ANY Major Company using Cold Fusion
UPS (albeit, 4.x) but we're using it. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Corrine Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:16 PM To: CF-Talk Subject: ANY Major Company using Cold Fusion I need some major companies that are using cold fusion. If you know of some please let me know. Thank you, Corrine Clark __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cfloop
Yes, but not through 2 queries (i think) Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 1:57 PM To: CF-Talk Subject: Cfloop Can You have nested Cfloops __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Maximizing/Minimizing menu using span..div
Set the style of your DIVs when created to display:none and they won't be expanded. In the click code for changing the div from collapsed to expanded, you can also change the img src by specifying the img by it's ID. Hope this helps, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 1:08 PM To: CF-Talk Subject: OT: Maximizing/Minimizing menu using span..div Hi, My code is working except for a few things that I'm not sure how to correct. I've been hacking with this code for a day or two now. When you load the page the menu are expanded. I'm not sure how to have them minimize upon page loading. Also, how can I load a different image (hbar-on.gif) when the menu is expanded and vice-a-versa (hbar-off.gif)? Below is my code. I removed the angle brackets around any script tags. Any help would be greatly appreciated. THanks expand.htm -- head title/title style componentBodyText {font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;font-size:65%;font-weight:regular;line-height:14px} componentHeader {color: #ff;font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;background-color:#ff;font-size:65%;font-weight:bold;text-tran sform:uppercase;} componentFooter {font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;background-color:#ff;} componentHeaderSel {color: #ff;font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;background-color:#ff;font-size:65%;font-weight:bold;text- transform:uppercase;border-color:#cc} componentHeaderText {color:#ff;font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;font-size:65%;font-weight:bold;} /style script type=text/javascript function change_display(head) { var oSrcEle = window.event.srcElement sImg666 = oSrcEle.src if (document.all.item(head).style.display == ) { document.all.item(head).style.display = none; oSrcEle.alt = expand menu; } else { document.all.item(head).style.display= ; oSrcEle.alt = collapse menu; } } /script script type=text/javascript !-- sImgDefaultArrow = ; sImgExpandedArrow = ; if (sImgDefaultArrow == ){ sImgDefaultArrow = hbar-on.gif; } if (sImgExpandedArrow == ){ sImgExpandedArrow = hbar-off.gif; } //-- /script /head body bgcolor=#ff topmargin=0 leftmargin=0 marginheight=0 marginwidth=0 script type=text/javascript language=JavaScript HTMLStr = DIV STYLE='background-color:white;width:100%;'; HTMLStr += DIV STYLE='position:absolute;top:0px;background-color:black;float:right;' NOWRAP/DIV; HTMLStr += DIV STYLE='position:absolute;top:0px;background-color:black;' NOWRAP/DIV; HTMLStr += /DIV; function drawToolbar() { document.write(HTMLStr); } /script span id=TBDownLevelDiv/span script language=JavaScript type=text/javascript !--// Hide from old browsers var ToolBar_Supported = ToolBar_Supported; TBDownLevelDiv.style.display ='none'; drawToolbar(); var fBrowserOK = true; //-- /script span table id=headeridArticle cellpadding=0 cellspacing=0 border=0 width=220 tr script language=javascript type=text/javascript !-- if (fBrowserOK) { document.write(td id=\arrowColidArticle\ bgcolor=\#ff\img id=\ImgArrowidArticle\ src= + sImgDefaultArrow + alt=\collapse menu\ border=\0\ style= \cursor:hand;\ onclick=\change_display\(\'headingidArticle\'\)\/td) } //-- /script /tr /table div id=headingidArticle style=display:visible a href=new.cfmfont face=Helvetica,Arial size=-2[New]/font/anbsp;nbsp;a href=rename.cfmfont face=Helvetica,Arial size=-2[Rename]/font/a hr width=220 align=left /div /span span table id=headeridArticle cellpadding=0 cellspacing=0 border=0 width=220 tr script language=javascript type=text/javascript !-- if (fBrowserOK) { document.write(td id=\arrowColidArticle\ bgcolor=\#ff\img id=\ImgArrowidArticle\ src= + sImgDefaultArrow + alt=\collapse menu\ border=\0\ style= \cursor:hand;\ onclick=\change_display\(\'headingidArticle2\'\)\/td) } //-- /script /tr /table div id=headingidArticle2 style=display:visible a href=new.cfmfont face=Helvetica,Arial
RE: CFMX error - again!!
I don't have MX, but if I remember my java right, it has to do with the 50 :cfset request.msgString=msg=DBError the symbol dereferences a pointer reference. In this case, you are dereferencing a string variable. Maybe try changing the to a +? Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 4:07 PM To: CF-Talk Subject: CFMX error - again!! Again, this is code that has always worked 100% with 4.5 and 5. The error given is: ~~~ You have attempted to dereference a scalar variable of type class [Ljava.lang.String; as a structure with members. The Error Occurred in [filepath deleted!]: line 52 50 :cfset request.msgString=msg=DBError 51 :cfif NOT IsDefined(dumpInfo) 52 : cfset dumpInfo=Duplicate(CFCATCH) 53 :/cfif 54 : /cfcatch This is a TRY / CATCH loop around an INSERT query, and dumpInfo is passed through to a mailing tag to email the error info to me. I can't find anything about Duplicate() in the MX documentation, and nothing that seems relevant about CFCATCH. WTF does the error mean?! :-\ Setup: WinXP Pro, IIS 5.1, CFMX Developer. cheers, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX error - again!!
Ok I did a little research. I found that strings are passed by value to functions. When you set a variable equal to another string, you're actually setting it equal to a copy of the string. When you do the Duplicate() function, you actually try to dereference the CFCATCH variable (which is a scalar variable) hence, the error. Try setting dumpInfo = CFCATCH and not a duplicate. This may be something with the way java handles the duplicate function and may not degrade gracefully anymore. Hope I was able to help in some way (keep in mind I am stuck using CF4.0 still) Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 4:21 PM To: CF-Talk Subject: RE: CFMX error - again!! There is no issue w/ in strings in CFMX. cfset foo = Ray Camden === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 4:22 PM To: CF-Talk Subject: Re: CFMX error - again!! I don't have MX, but if I remember my java right, it has to do with the 50 :cfset request.msgString=msg=DBError the symbol dereferences a pointer reference. In this case, you are dereferencing a string variable. Maybe try changing the to a +? request.msgString is appended to a URL - that needs to be there for the URL to work. Can we not have ampersands in CFMX strings?! Is there an escape code, as per HTML character entities? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF4 Java Applet Problems
I need independent confirmation of this. We have ColdFusion 4.0 running on our web servers. I installed the latest Java Virtual Machine from Sun on my PC. When I run a web page with a cold fusion java applet in it (CFGRID) I get an error. If I disable the Sun Java VM in Internet Explorer, the grid works fine. I assume this is an issue between the ColdFusion 4.0 applets and the Sun Java VM. Is there a patch to fix this on the server that goes back to CF 4.0 or does it only go back to 5.0? If there is ANY information on this, please let me know where I can find it so I can defend my position that it cannot be fixed in CF 4.0 Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail:[EMAIL PROTECTED] (2B || !2B) == ? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists