Re: cf tutorials
If your in NY I'll be giving 6 intro classes free of charge for people in Brooklyn to get them interested. In addition, I'll be speaking at the next NYCFUG on two topics, one of which is a basic one: comparison statements in ColdFusion 3 approaches to query caching You're welcome to come to both and I'm hoping to get video of them up on the Dinowitz and Associates site (http://www.dinowitzandassociates.com) Hey all, I want my son to learn CF. Is there a series of good tutorials that teach CF in an organized, concise way? I would love him to take some classes, but the money is way tight right now. Thanks, Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222887 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
(Admin) missing posts
Due to a small virus and the steps to deal with it, the posts for the lists did not go out from about 6 or 7pm Nov 1st till about 11pm or so. If you are expecting an answer to a question or want to see what was posted, please visit the list archives at: http://www.houseoffusion.com/cf_lists/threads.cfm/4 All of the posts that did not go out were still archived. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222888 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion and WebLogic
On Tuesday 01 November 2005 19:49, Dave Watts wrote: directly to Java bytecode, bypassing the Java source code. But even if you could get to that, it wouldn't be very maintainable, so for all practical purposes you'd have to rewrite it anyway. We've always thought that if the worst happened, we could just decompile the Java class files and work from the reconstructed source. Not very much fun, however. -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222889 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF7 and 64-bit CPUs
Quick question: Will CF7 work on a 64-bit processor running with a 32-bit OS? I have an AMD Opteron (64-bit) processor and am running Red Hat Enterprise Linux ES 3 *in 32 bit mode*. Yesterday, after fighting against it, I discovered that CF will not work on a 64-bit OS: I was having the problem as described on this technote: http://www.macromedia.com/go/baec9c0c (nice that this wasn't highlighted earlier) So the OS was rekicked into 32-bit mode, but now I'm getting the following error: [EMAIL PROTECTED] root]# ./coldfusion-701-lin.bin Preparing to install... Extracting the JRE from the installer archive... The included VM could not be extracted. Please try to download the installer again and make sure that you download using 'binary' mode. Please do not attempt to install this currently downloaded copy. Yesterday, at least this installed, but wouldn't run. Now, it's not even installing. So, do I need to replace the hardware? Thanks, Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFContent cancels out JS
Can you walk me through this a touch? I have a page that dumps a database using cfdump. Above the cfdump is a button that says download to excel. If clicked, do I reload the page, do a cfcontent and output the database info into a table, then reload the original page (with the button and the cfdump) using cflocation? I don't understand the process that you're suggesting but it sounds right-on. CFCONTENT cancels out any previously generated content so your banner, menus etc will not show. Use a CFABORT after it if necessary to prevent any content generated after your excel file from showing too, although a properly structured page shouldn't need that. This way you don't need the extra page. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
error Requested resource 'null' (null) not found with ColdFusion MX 7.0.1
Hi, I installed ColdFusion MX 7.0.1 on Red Hat Enterprise Linux 3 ES (Update 6). I migrated the settings from a previous ColdFusion MX 7.0.0 installation (putting the neo-*.xml files in the 'cf6settings' directory and letting the migration wizard run whe accessing the CF Administrator for the first time). The new ColdFusion MX 7.0.1 installation seems to work fine, but there are a bunch of errors in the 'cfserver.log' file: 11/02 07:39:34 info report 11/02 07:39:34 error Requested resource 'null' (null) not found 11/02 07:39:46 error Requested resource 'null' (null) not found 11/02 07:41:20 error Requested resource 'null' (null) not found 11/02 07:41:25 info report 11/02 07:41:25 error Requested resource 'null' (null) not found 11/02 07:41:32 info report 11/02 07:41:32 error Requested resource 'null' (null) not found 11/02 07:41:42 error Requested resource 'null' (null) not found 11/02 07:43:39 error Requested resource 'null' (null) not found 11/02 07:46:05 error Requested resource 'null' (null) not found Any idea? Should I just (safely) ignore them? Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222892 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf tutorials
Thanks. I'll be looking foward to the video! We are in Maryland, so that won't work. Thanks, Mark -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 AM To: CF-Talk Subject: Re: cf tutorials If your in NY I'll be giving 6 intro classes free of charge for people in Brooklyn to get them interested. In addition, I'll be speaking at the next NYCFUG on two topics, one of which is a basic one: comparison statements in ColdFusion 3 approaches to query caching You're welcome to come to both and I'm hoping to get video of them up on the Dinowitz and Associates site (http://www.dinowitzandassociates.com) Hey all, I want my son to learn CF. Is there a series of good tutorials that teach CF in an organized, concise way? I would love him to take some classes, but the money is way tight right now. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222893 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL DSN
We use a FQDN rather than a netbios name. E.g. Servername.domainname -- Russ -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 15:21 To: CF-Talk Subject: Re: MySQL DSN On 10/31/05, Snake [EMAIL PROTECTED] wrote: I don't acxtually have any to test a sthey have all been removed from the server. But it's the standard error you get if you pass invalid login details or no login details at all. I'm jumping in late here w/o all the backstory on this thread, but if you're got a server with multiple IP addresses on it (esp Windows, IMHO) you can sometimes get a different address if you're using the netbios name instead of the IP in the datasource connection setup. This case isn't db-specific -- I've seen it happen w/ MS-SQL as well, but it's always on machines that have multiple IPs. The symptoms however, are typically *random* failures of the connection, not specifically when it's cfquery vs cfquery name= password=. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222894 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
possibly OT: barcode scanning...
This isnt' a CF question directly, but there might be a CF related answer so I'll ask it here anyway. My wife is getting ready to start a business selling CDs for on half.com. A friend who is planning on taking Jaime up on the offer, has over 1000 CDs which would take QUITE a long time to catalog. My thought is to get a barcode scanner and whip them all out. I wonder if anyone has done this before for their own collection and would care to share their method. andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222895 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Maybe OT, MySQL install problem
SOrry if this is deemed OT, but it relates to CF :) I'm trying to install MySQL on my Win2k server. It's already running M$SQL and CF7. THe install seems to go ok, except the service can't start. I go into the instance configurator and it hangs at the starting service/security step (last step) I t get a generic, service can't be started, error 0 Any thoughts. I've installed/removed/reinstalled a few times. Rebooted often. Same result each time. J -- John Wilker Writer/Web Consultant www.johnwilker.com http://www.johnwilker.com / www.red-omega.comhttp://www.red-omega.com The measure of success is not whether you have a tough problem to deal with, but whether it's the same problem you had last year. ~John Foster Dulles, Former US Sec. of State. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222896 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: possibly OT: barcode scanning...
I have used a barcode scanner with cf before, its actually not cf related though. The barcode scanner is a peripheral just like a mouse is to the system, you just make a form with a text input, make sure it has focus and then scan the barcode. It will input the string into the text field. make sure you note that some scanners also issue a submit request somehow after its input, so just be aware of that. After that, its just up to you with what you do with it after the input. On 11/2/05, Andy Matthews [EMAIL PROTECTED] wrote: This isnt' a CF question directly, but there might be a CF related answer so I'll ask it here anyway. My wife is getting ready to start a business selling CDs for on half.com. A friend who is planning on taking Jaime up on the offer, has over 1000 CDs which would take QUITE a long time to catalog. My thought is to get a barcode scanner and whip them all out. I wonder if anyone has done this before for their own collection and would care to share their method. andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222897 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: possibly OT: barcode scanning...
I wonder if anyone has done this before for their own collection and would care to share their method. Bacode readers are very simple: they are pluged in place of the keyboard, and they host the keyboard itself. This way, they act exactly as if what they read was typed on the keyboard, so you can use standard input fields in forms, just make sure the focus is on the correct field when the barcode is read. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222898 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Upcoming 4 day CSS Class
I understand that registration has opened for my upcoming class on Cascading Style Sheets at Teratech. The class is 4 days, hands on and runs from November 29th through Friday December 4th. I will be spending a full day on floats, positioning and layouts as well as covering lists, forms, typography and much much more. For more information or to register http://www.teratech.com/training/oc_classes.cfm#CS201H Sandy Clark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222899 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
flash forms auto focus on first text field?
Hey guys, does anyone know how to make a flash form auto focus on a text field once the form loads? Thanks -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222900 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: flash forms auto focus on first text field?
Alright, scratch that, i figured that out. you use the setFocus() method. so its like textid.setFocus() but now I have a different question. I have a normal html form where someone has to fill in an ldap username. No one knows what these usernames are though, so there is a button for lookup, which uses javascript to pop open a window. The window has a flash form with a text input and a data grid, and as you type the name of the person in the text box, it uses flash remoting to bring back the search results in the data grid. Then they select the name of the person they want, hit submit in the flash form. It then posts back to the same page, on post it uses javascript to fill in the text input on the page the spawned the window in the first place and closes the window. Its a great solution. Only problem is, when they click the button to lookup, and the flash form loads, even though I am setting focus to the text input, the user still has to click inside the flash movie and give it focus before they can start typing. Does anyone know a way that I can set focus to the flash movie and then on the text input where they can just click the lookup button and just start typing as soon as the form loads? Thanks, On 11/2/05, Ryan Guill [EMAIL PROTECTED] wrote: Hey guys, does anyone know how to make a flash form auto focus on a text field once the form loads? Thanks -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222901 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: flash forms auto focus on first text field?
Ryan Guill wrote: Hey guys, does anyone know how to make a flash form auto focus on a text field once the form loads? h Make a function that you run via the onload attribute. In that function set the focus for the first field. eg. FormName.fieldname.setfocus(); This does require that you have the updater installed, so that you can use onload and cfformitem type=script to create functions. Hope this helps Stephen ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222902 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rumors from Max...
On Tuesday 01 November 2005 18:51, Jeff Small wrote: Rumor is, Adobe might release CF to the open source community... I would only be moderately surprised, though very excited, if this became true. A few years ago, CFML was about the only easy, quick way to build a dynamic web site (certainly nothing else was tag-based, really). Now, there are great JSP tag libs - such as Apache's Tomahawk extensions. The argument for 4 grand of CFML server to do something equally well as a JSP page is getting harder and harder to make. Remember, most people don't use Flash forms, gateways and all the other stuff CF comes with that JSP doesn't. Add to that that I have yet to see a good reason for using Flash anything over a decent DHTML version, and maybe you can see why we have a long term vision here that replaces our large CFML site with one based on JSP taglibs and a full J2EE architecture (which we have for webservice purposes anyway). This work will also pay off when/if we have to bundle up and ship to customers our application - 4K more profit (or undercutting the opposition) per unit is a lot. Dunno if open source CFML would be enough to halt this. Might just be... -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222903 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFContent cancels out JS
It's even eaiser than that. cfif StructKeyExists(FORM,WhateverYouCallTheSubmitButton) cfcontent ...etc for the cfcontent bit cfelse !--- your entire page, cfdump, form and all here --- /cfif This way the page shows the webpage in the browser unless the form button is clicked - the self posting form then causes the excel file to download with out any of the annoying new window stuff. I've used this exact technique in pages before with great success. On 11/2/05, daniel kessler [EMAIL PROTECTED] wrote: Can you walk me through this a touch? I have a page that dumps a database using cfdump. Above the cfdump is a button that says download to excel. If clicked, do I reload the page, do a cfcontent and output the database info into a table, then reload the original page (with the button and the cfdump) using cflocation? I don't understand the process that you're suggesting but it sounds right-on. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222904 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Rumors from Max...
LOL.I doubt that will happen - though I suppose if it does it will be day we move off it. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 15:26 To: CF-Talk Subject: Re: Rumors from Max... On Tuesday 01 November 2005 18:51, Jeff Small wrote: Rumor is, Adobe might release CF to the open source community... I would only be moderately surprised, though very excited, if this became true. A few years ago, CFML was about the only easy, quick way to build a dynamic web site (certainly nothing else was tag-based, really). Now, there are great JSP tag libs - such as Apache's Tomahawk extensions. The argument for 4 grand of CFML server to do something equally well as a JSP page is getting harder and harder to make. Remember, most people don't use Flash forms, gateways and all the other stuff CF comes with that JSP doesn't. Add to that that I have yet to see a good reason for using Flash anything over a decent DHTML version, and maybe you can see why we have a long term vision here that replaces our large CFML site with one based on JSP taglibs and a full J2EE architecture (which we have for webservice purposes anyway). This work will also pay off when/if we have to bundle up and ship to customers our application - 4K more profit (or undercutting the opposition) per unit is a lot. Dunno if open source CFML would be enough to halt this. Might just be... -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222905 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Rumors from Max...
I wouldn't think this would happen. Many federal agencies have a large commitment to ColdFusion, if it goes open source (with no single authoritative source for support IE: Adobe) It'll leave theses agencies with a product that they'll drop like a bad habit. That's too big of a single customer base to just leave out in the cold. sas Scott A. Stewart ColdFusion Developer GNSI 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 10:26 AM To: CF-Talk Subject: Re: Rumors from Max... On Tuesday 01 November 2005 18:51, Jeff Small wrote: Rumor is, Adobe might release CF to the open source community... I would only be moderately surprised, though very excited, if this became true. A few years ago, CFML was about the only easy, quick way to build a dynamic web site (certainly nothing else was tag-based, really). Now, there are great JSP tag libs - such as Apache's Tomahawk extensions. The argument for 4 grand of CFML server to do something equally well as a JSP page is getting harder and harder to make. Remember, most people don't use Flash forms, gateways and all the other stuff CF comes with that JSP doesn't. Add to that that I have yet to see a good reason for using Flash anything over a decent DHTML version, and maybe you can see why we have a long term vision here that replaces our large CFML site with one based on JSP taglibs and a full J2EE architecture (which we have for webservice purposes anyway). This work will also pay off when/if we have to bundle up and ship to customers our application - 4K more profit (or undercutting the opposition) per unit is a lot. Dunno if open source CFML would be enough to halt this. Might just be... -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222906 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rumors from Max...
I dont usually do this, but isn't this a topic best suited for cf-community? On 11/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: LOL.I doubt that will happen - though I suppose if it does it will be day we move off it. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 15:26 To: CF-Talk Subject: Re: Rumors from Max... On Tuesday 01 November 2005 18:51, Jeff Small wrote: Rumor is, Adobe might release CF to the open source community... I would only be moderately surprised, though very excited, if this became true. A few years ago, CFML was about the only easy, quick way to build a dynamic web site (certainly nothing else was tag-based, really). Now, there are great JSP tag libs - such as Apache's Tomahawk extensions. The argument for 4 grand of CFML server to do something equally well as a JSP page is getting harder and harder to make. Remember, most people don't use Flash forms, gateways and all the other stuff CF comes with that JSP doesn't. Add to that that I have yet to see a good reason for using Flash anything over a decent DHTML version, and maybe you can see why we have a long term vision here that replaces our large CFML site with one based on JSP taglibs and a full J2EE architecture (which we have for webservice purposes anyway). This work will also pay off when/if we have to bundle up and ship to customers our application - 4K more profit (or undercutting the opposition) per unit is a lot. Dunno if open source CFML would be enough to halt this. Might just be... -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222907 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Rumors from Max...
I wouldn't think this would happen. Many federal agencies have a large commitment to ColdFusion, if it goes open source (with no single authoritative source for support IE: Adobe) It'll leave theses agencies with a product that they'll drop like a bad habit. That's too big of a single customer base to just leave out in the cold. While I think this rumor is rubbish, I have to comment on your statement. There are a lot of companies that live off of open source software. MySQL, RedHat, Novell, IBM, all make a LOT of money selling/supporting open source software. It's usually a case of giving away a low end version and offering support, while selling a high end version. But some only offer support. So if ColdFusion were to be open sourced, I'm sure Adobe/Macromedia would be there offering support and high end versions, and no customers would be 'out in the cold'. But again, I think this will never happen. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222908 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rumors from Max...
Seriously. Do we really need to have a bunch of retarded posts about the demise of ColdFusionAGAIN! As long as CF turns a profit, it will continue to be sold and supported. Move this topic to the cf-paranoid-retards list. -Adam On 11/2/05, Ryan Guill [EMAIL PROTECTED] wrote: I dont usually do this, but isn't this a topic best suited for cf-community? On 11/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: LOL.I doubt that will happen - though I suppose if it does it will be day we move off it. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 15:26 To: CF-Talk Subject: Re: Rumors from Max... On Tuesday 01 November 2005 18:51, Jeff Small wrote: Rumor is, Adobe might release CF to the open source community... I would only be moderately surprised, though very excited, if this became true. A few years ago, CFML was about the only easy, quick way to build a dynamic web site (certainly nothing else was tag-based, really). Now, there are great JSP tag libs - such as Apache's Tomahawk extensions. The argument for 4 grand of CFML server to do something equally well as a JSP page is getting harder and harder to make. Remember, most people don't use Flash forms, gateways and all the other stuff CF comes with that JSP doesn't. Add to that that I have yet to see a good reason for using Flash anything over a decent DHTML version, and maybe you can see why we have a long term vision here that replaces our large CFML site with one based on JSP taglibs and a full J2EE architecture (which we have for webservice purposes anyway). This work will also pay off when/if we have to bundle up and ship to customers our application - 4K more profit (or undercutting the opposition) per unit is a lot. Dunno if open source CFML would be enough to halt this. Might just be... -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222909 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Rumors from Max...
LOL! -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:09 To: CF-Talk Subject: Re: Rumors from Max... Seriously. Do we really need to have a bunch of retarded posts about the demise of ColdFusionAGAIN! As long as CF turns a profit, it will continue to be sold and supported. Move this topic to the cf-paranoid-retards list. -Adam On 11/2/05, Ryan Guill [EMAIL PROTECTED] wrote: I dont usually do this, but isn't this a topic best suited for cf-community? On 11/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: LOL.I doubt that will happen - though I suppose if it does it will be day we move off it. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 15:26 To: CF-Talk Subject: Re: Rumors from Max... On Tuesday 01 November 2005 18:51, Jeff Small wrote: Rumor is, Adobe might release CF to the open source community... I would only be moderately surprised, though very excited, if this became true. A few years ago, CFML was about the only easy, quick way to build a dynamic web site (certainly nothing else was tag-based, really). Now, there are great JSP tag libs - such as Apache's Tomahawk extensions. The argument for 4 grand of CFML server to do something equally well as a JSP page is getting harder and harder to make. Remember, most people don't use Flash forms, gateways and all the other stuff CF comes with that JSP doesn't. Add to that that I have yet to see a good reason for using Flash anything over a decent DHTML version, and maybe you can see why we have a long term vision here that replaces our large CFML site with one based on JSP taglibs and a full J2EE architecture (which we have for webservice purposes anyway). This work will also pay off when/if we have to bundle up and ship to customers our application - 4K more profit (or undercutting the opposition) per unit is a lot. Dunno if open source CFML would be enough to halt this. Might just be... -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Podcast Series | Tips, Tricks and News
My first podcast ever. Great. Very well done. Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Michael Haynie [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 31, 2005 11:56 PM Subject: Re: ColdFusion Podcast Series | Tips, Tricks and News Episode II is up now, lots of good stuff including Ajax and Google Maps API. If you are subscribed via iTunes, it seems to be lagging on the new episode, but ipodder and the rest pulled it as we published. So, episode II is there as well. Thanks for the kind words and we hope to do one weekly and incorporate code, examples, and news. Thanks for listening! Michael ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Force PDF Download
Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rumors from Max...
Seriously. Do we really need to have a bunch of retarded posts about the demise of ColdFusionAGAIN! Hmm..I actually didn't see it as the demise of ColdFusion...I thought it sounded like a really great idea. Take something that's had the benefit of years of company development and solidity, and open it up to the rest of the community? Make money off the development front end (Dreamweaver, Studio, Flex) and use the free back end to power it all? Sounded pretty cool to me. I didn't *even* think of it as the demise of ColdFusion. I mean, imagine if ISPs simply were able to install CF on whatever server they had and there was no charge? Remember, it's just a server product. There are a bunch of other server products that do pretty much the same thing (middleware) and they don't cost a dime. I think one of the main stumbling blocks in developing CF stuff is that you have to go find yourself a CF host, or buy yourself a copy of the software and maintain a server yourself. If it was something that anyone could get and install and run, I think you'd see a LOT more hosts offering it as just a standard server/hosting product, similar to the way PHP and MySQL are pretty much offered by *every* host on the planet. I think it'd rule. I don't have much confidence in Adobe in the middleware server space...call me skeptical. I just think the community has better vision than Adobe might have in terms of what may be best for the software going forward. It sure seems like they haven't been promoting it as a complimentary technology alongside of Flex like they *should* be... And yeah, it should've been posted to Community. I started typing and the autocomplete just filled it in without me paying attention, sorry. If you want to move it over there, I certainly understand. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Force PDF Download
Is that the only code on the download page? Aldon Moore wrote: Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222914 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force PDF Download
This is what I am using cfheader name=Content-Disposition value=inline; filename=#pdfToCreate# cfheader name=Expires value=#Now()# cfcontent type=application/pdf file=#variables.vcSystemGeneratedAppPath##pdfToCreate# deletefile=yes -Original Message- From: Aldon Moore [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:54 To: CF-Talk Subject: Force PDF Download Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222915 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force PDF Download
I think you should remove the attachment;filename=ebook.pdf part. I'm not sure what should go there, but I think that's causing the problem. - Matt Small -Original Message- From: Aldon Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 11:54 AM To: CF-Talk Subject: Force PDF Download Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force PDF Download
What fails? Do you get a message? Is it in IE and Firefox or just IE? -Original Message- From: Aldon Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 11:54 AM To: CF-Talk Subject: Force PDF Download Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222917 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force PDF Download
This may be overkill but I use this for a document library tool I built. Just replace some of my variable names. cfheader name=Content-Type value=application/pdf cfheader name=Content-Disposition value=filename=something.pdf# cfheader name=Content-Location value=#URLEncodedFormat(documentSelect.savedName)# cfcontent type= application/pdf file=#Folder##documentSelect.savedName# -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 11:33 AM To: CF-Talk Subject: RE: Force PDF Download This is what I am using cfheader name=Content-Disposition value=inline; filename=#pdfToCreate# cfheader name=Expires value=#Now()# cfcontent type=application/pdf file=#variables.vcSystemGeneratedAppPath##pdfToCreate# deletefile=yes -Original Message- From: Aldon Moore [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:54 To: CF-Talk Subject: Force PDF Download Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rumors from Max...
Munson, Jacob wrote: I wouldn't think this would happen. Many federal agencies have a large commitment to ColdFusion, if it goes open source (with no single authoritative source for support IE: Adobe) It'll leave theses agencies with a product that they'll drop like a bad habit. I don't agree. An organization such as Adobe could continue to provide commercial support to an open-source project. They could continue to develop it as well. for example, what if they were to open source the basic standard version, but offered additional functionality in an enterprise version offered commercially. That's feasible. Plenty of organizations out there buy commercial licenses and commercial support from MySQL AB. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL distinct
Hi guys, I'm trying to do something simple but having a bit of a bother. cfquery name=GetUsers datasource=user020 SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID /cfquery I'm trying to get a list of all the users in table tbl)020publicUsers which have a record in the table tbl_020eventDetails. However, I keep get multiple listings for the users who have multiple rows in tbl_020eventDetails. I did trying adding the word DISTINCT after SELECT but it didn't do anything. Any help would be gratefully appreciated. Thanks, Stuart Kidd ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222920 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL distinct
Stuart: You need to use an INNER JOIN in your query. The query should be: SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID = e.userID HTH -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 12:56 PM To: CF-Talk Subject: SQL distinct Hi guys, I'm trying to do something simple but having a bit of a bother. cfquery name=GetUsers datasource=user020 SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID /cfquery I'm trying to get a list of all the users in table tbl)020publicUsers which have a record in the table tbl_020eventDetails. However, I keep get multiple listings for the users who have multiple rows in tbl_020eventDetails. I did trying adding the word DISTINCT after SELECT but it didn't do anything. Any help would be gratefully appreciated. Thanks, Stuart Kidd ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL distinct
that is because you are getting the event details as well e.eventID and e.userID if you remove these from the select list and put the DISTINCT back that should do the trick. Mike T On 11/2/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I'm trying to do something simple but having a bit of a bother. cfquery name=GetUsers datasource=user020 SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID /cfquery I'm trying to get a list of all the users in table tbl)020publicUsers which have a record in the table tbl_020eventDetails. However, I keep get multiple listings for the users who have multiple rows in tbl_020eventDetails. I did trying adding the word DISTINCT after SELECT but it didn't do anything. Any help would be gratefully appreciated. Thanks, Stuart Kidd ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222922 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL distinct
cfquery name=GetUsers datasource=user020 SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID /cfquery By selecting e.eventID from the tbl_020eventDetails e table, every row selected is going to be distinct. A couple of thing you can do, is not select the data from the eventDetails table, then the DISTINCT command should work as you desired. Or you some aggregate functions. cfquery name=GetUsers datasource=user020 SELECT u.userID, u.firstName, u.lastName, SUM(e.eventID), SUM(e.userID) FROM tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID GROUP BY u.userID, u.firstName, u.lastName /cfquery This will return all the users that have records in the details table with a count of how many records they have. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222923 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News
What is a podcast anyway? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:22 To: CF-Talk Subject: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News My first podcast ever. Great. Very well done. Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Michael Haynie [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 31, 2005 11:56 PM Subject: Re: ColdFusion Podcast Series | Tips, Tricks and News Episode II is up now, lots of good stuff including Ajax and Google Maps API. If you are subscribed via iTunes, it seems to be lagging on the new episode, but ipodder and the rest pulled it as we published. So, episode II is there as well. Thanks for the kind words and we hope to do one weekly and incorporate code, examples, and news. Thanks for listening! Michael ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222924 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
rds remote view shows nothing
i am attempting to connect do a dev machine i have in the basement via rds.. when i set it up in dwmx.. i get no error when connecting.. but the remote view shows only the folder path i entered when i setup the connection... no files.. nothing else.. has anyone else seen this.. or know what the deal is? Crit ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: Rumors from Max...
I have never been a big fan of open source, I always preferred having a company to call for support. But that possibility vanished with Allaire. Since MM owned CF, you have to get out your creditcard just to speak to anyone. You then have to prove that your problem is due to problem with CF or a bug, and it's not your own stupidity if you do not want to get charged hundreds of dollars. There is no email support from Macromedia, you have to ask the community. So really, CF may as well be open source for all the difference it would make. I really want to find time to spend with Blue Dragon, because New Atlanta are more like Allaire, and at least you actually get support from them. -- Russ -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:39 To: CF-Talk Subject: [SPAM : 8.1] Re: Rumors from Max... Seriously. Do we really need to have a bunch of retarded posts about the demise of ColdFusionAGAIN! Hmm..I actually didn't see it as the demise of ColdFusion...I thought it sounded like a really great idea. Take something that's had the benefit of years of company development and solidity, and open it up to the rest of the community? Make money off the development front end (Dreamweaver, Studio, Flex) and use the free back end to power it all? Sounded pretty cool to me. I didn't *even* think of it as the demise of ColdFusion. I mean, imagine if ISPs simply were able to install CF on whatever server they had and there was no charge? Remember, it's just a server product. There are a bunch of other server products that do pretty much the same thing (middleware) and they don't cost a dime. I think one of the main stumbling blocks in developing CF stuff is that you have to go find yourself a CF host, or buy yourself a copy of the software and maintain a server yourself. If it was something that anyone could get and install and run, I think you'd see a LOT more hosts offering it as just a standard server/hosting product, similar to the way PHP and MySQL are pretty much offered by *every* host on the planet. I think it'd rule. I don't have much confidence in Adobe in the middleware server space...call me skeptical. I just think the community has better vision than Adobe might have in terms of what may be best for the software going forward. It sure seems like they haven't been promoting it as a complimentary technology alongside of Flex like they *should* be... And yeah, it should've been posted to Community. I started typing and the autocomplete just filled it in without me paying attention, sorry. If you want to move it over there, I certainly understand. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222926 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News
What is a podcast anyway? It's the newfangled word for an audio recording. The iPod has infected every aspect of language, apparently. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222927 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News
On 11/2/05, Snake [EMAIL PROTECTED] wrote: What is a podcast anyway? See Rob Brooks-Bilson's comments on Ray's blog entry here: http://ray.camdenfamily.com/index.cfm/2005/11/1/ColdFusion-Podcast-Explosion ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222928 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Passing functions as arguments?
Kenton, I'm guessing, but that sounds likea php thing to me. In CF, and in most traditional languages, you'll find, the ideal way to do it is to pass object references instead of functions. Put your cffunctions inside of CFCs and send the cfc to a method of a cfc. As for being able to pass a function as an argument, you can always try it. Leave off the () and just send the name. I have no idea what it will do, but it does sound like it should throw an error. There are probably workarounds, such as passing the function name as a string and then evaluate()ing it. In any event, the cleaner way is going to be to pass the CFC instead of the individual function. -nathan strutz http://www.dopefly.com/ On 11/1/05, Kenton Gray [EMAIL PROTECTED] wrote: In other languages I learned the joy of passing function references as arguments, is such a thing possible in coldfusion? If I could pass in a reference to a function as an argument, life would be nice. If there is no exact way are there any work arounds? Kenton ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222929 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Passing functions as arguments?
Actually, you can indeed pass the name of a function to another function, perhaps as a callback (a bit like using pointers to functions in C). I used this technique in an XML based menuing app I wrote a while back. Details are at http://www.macromedia.com/devnet/coldfusion/extreme/xml_menu.html. --- Ben -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 1:25 PM To: CF-Talk Subject: Re: Passing functions as arguments? Kenton, I'm guessing, but that sounds likea php thing to me. In CF, and in most traditional languages, you'll find, the ideal way to do it is to pass object references instead of functions. Put your cffunctions inside of CFCs and send the cfc to a method of a cfc. As for being able to pass a function as an argument, you can always try it. Leave off the () and just send the name. I have no idea what it will do, but it does sound like it should throw an error. There are probably workarounds, such as passing the function name as a string and then evaluate()ing it. In any event, the cleaner way is going to be to pass the CFC instead of the individual function. -nathan strutz http://www.dopefly.com/ On 11/1/05, Kenton Gray [EMAIL PROTECTED] wrote: In other languages I learned the joy of passing function references as arguments, is such a thing possible in coldfusion? If I could pass in a reference to a function as an argument, life would be nice. If there is no exact way are there any work arounds? Kenton ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222930 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Passing functions as arguments?
Agreed. It can be done, but the better way is to pass the whole object. On 11/2/05, Nathan Strutz [EMAIL PROTECTED] wrote: Kenton, I'm guessing, but that sounds likea php thing to me. In CF, and in most traditional languages, you'll find, the ideal way to do it is to pass object references instead of functions. Put your cffunctions inside of CFCs and send the cfc to a method of a cfc. As for being able to pass a function as an argument, you can always try it. Leave off the () and just send the name. I have no idea what it will do, but it does sound like it should throw an error. There are probably workarounds, such as passing the function name as a string and then evaluate()ing it. In any event, the cleaner way is going to be to pass the CFC instead of the individual function. -nathan strutz http://www.dopefly.com/ On 11/1/05, Kenton Gray [EMAIL PROTECTED] wrote: In other languages I learned the joy of passing function references as arguments, is such a thing possible in coldfusion? If I could pass in a reference to a function as an argument, life would be nice. If there is no exact way are there any work arounds? Kenton ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222931 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Passing functions as arguments?
Another example is QuickSort at CFLIB: http://www.cflib.org/udf.cfm?ID=518 On 11/2/05, Ben Forta [EMAIL PROTECTED] wrote: Actually, you can indeed pass the name of a function to another function, perhaps as a callback (a bit like using pointers to functions in C). I used this technique in an XML based menuing app I wrote a while back. Details are at http://www.macromedia.com/devnet/coldfusion/extreme/xml_menu.html. --- Ben -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222932 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News
Snake, here's a link to what Podcasting is: http://www.020.com/webs/02005/showArticle.cfm?id=234 On 2 Nov 2005, at 18:15, Snake wrote: What is a podcast anyway? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:22 To: CF-Talk Subject: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News My first podcast ever. Great. Very well done. Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Michael Haynie [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 31, 2005 11:56 PM Subject: Re: ColdFusion Podcast Series | Tips, Tricks and News Episode II is up now, lots of good stuff including Ajax and Google Maps API. If you are subscribed via iTunes, it seems to be lagging on the new episode, but ipodder and the rest pulled it as we published. So, episode II is there as well. Thanks for the kind words and we hope to do one weekly and incorporate code, examples, and news. Thanks for listening! Michael ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222933 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News
It's the newfangled word for an audio recording. The iPod has infected every aspect of language, apparently. LOL...brilliant! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222934 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News
The iPod MUST DIE i couldn't resist :-) What is a podcast anyway? It's the newfangled word for an audio recording. The iPod has infected every aspect of language, apparently. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News
The iPod MUST DIE Mine already has ... twice. Don't jinx me, ok? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222936 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL distinct
Hi Stuart Try Inner Join with the key in each table IE: Imagine u have two tables Basket and basketDetails in an ecommerce application SELECT* FROM_C_Basket INNER JOIN _R_BasketDetails ON _C_Basket.idBasket = _R_BasketDetails.idBasket In this case idbasket is primary key in _C_Basket ... Regards __ M.Sc. Hassan Arteaga RodrÃguez Microsoft Certified System Engineer IT Specialist DIGI Grupo de Desarrollo. COPEXTEL, S.A. Este email y sus adjuntos está dirigido solamente a los destinatarios consignados en el mismo y debe ser considerado confidencial. Si Ud. no es el destinatario consignado o la persona responsable de entregar/enviar el presente, no podrá copiarlo o entregarlo/enviarlo a ninguna otra persona ni utilizar el mismo en forma no autorizada. Dichas acciones están prohibidas y pueden ser consideradas ilegales. Si Ud. recibiese este email por error, por favor comunÃquelo de inmediato al emisor del mismo. -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 12:56 PM To: CF-Talk Subject: SQL distinct Hi guys, I'm trying to do something simple but having a bit of a bother. cfquery name=GetUsers datasource=user020 SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID /cfquery I'm trying to get a list of all the users in table tbl)020publicUsers which have a record in the table tbl_020eventDetails. However, I keep get multiple listings for the users who have multiple rows in tbl_020eventDetails. I did trying adding the word DISTINCT after SELECT but it didn't do anything. Any help would be gratefully appreciated. Thanks, Stuart Kidd ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222937 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Query column index number
Hi folks. How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example cfquery name=qry datasource=test #qry.column[1]# /cfquery Or something similar to this. Thanks in advance. --- --- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222938 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Caching, caching what is doing all this caching?!
Yesterday, my workstation started experiencing some maddening kind of intermittent caching. I will put (publish) my code updates from my local (U:) folder to my testing (C:) folder, which is set up as a IIS5 (Win2000 server) website running ColdFusion (MX6.1). I've worked for many moons like this with no difficulty. Starting yesterday I am experiencing intermittent caching where, after I have updated the code - verified by looking at and comparing the local and testing file versions - refreshing or even restarting the browser will not execute the new version of the code. Restarting the CF application service will clear what ever is being saved, and the new file will then run. This is most annoying. I have looked at all the CF-Admin settings for caching. All three options are unchecked. Where else could this be coming from? And why did it start yesterday? The only change made on Monday was I started using DreamWeaver 8 from using DreamWeaver 7. Could it be causing the problem? If you just hate DreamWeaver in general, I am unable to consider changing to anything like Eclipse at this time - Corporate software policy ya know. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222939 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL distinct
The original OP did have an inner join using the older style of putting the join in the WHERE clause. If he is on a system like me, using an older Oracle 8i or previous version, he can't use the new fangled (13 year old) syntax of INNER JOIN, OUTER JOIN, FULL JOIN, CROSS JOIN. Oh how I wish I could do those things. But I can't. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222940 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Sorry for that stupid piece of code I just posted a few minutes ago. Trying to type too fast and answers phones and talk to others all at the same time. Here is a better illustration of what I want: cfquery name=qry datasource=test Select * from table /cfquery cfoutput query=qry #qry.column[1]# /cfoutput Thanks -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 1:56 PM To: CF-Talk Subject: Query column index number Hi folks. How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example cfquery name=qry datasource=test #qry.column[1]# /cfquery Or something similar to this. Thanks in advance. --- --- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222941 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query column index number
cfquery name=qry datasource=test #qry.column[qry.currentrow]# /cfquery ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222942 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf tutorials
FYI- If anyone would be interested, I found what seems to be a very complete and well organized ColdFusion tutorial at Lynda.com. It is a 15+ hour course taught on quicktime video by a guy named Joey Lott. I think the price of $25/month is quite reasonable. Mark -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 8:08 AM To: CF-Talk Subject: RE: cf tutorials Thanks. I'll be looking foward to the video! We are in Maryland, so that won't work. Thanks, Mark -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 AM To: CF-Talk Subject: Re: cf tutorials If your in NY I'll be giving 6 intro classes free of charge for people in Brooklyn to get them interested. In addition, I'll be speaking at the next NYCFUG on two topics, one of which is a basic one: comparison statements in ColdFusion 3 approaches to query caching You're welcome to come to both and I'm hoping to get video of them up on the Dinowitz and Associates site (http://www.dinowitzandassociates.com) Hey all, I want my son to learn CF. Is there a series of good tutorials that teach CF in an organized, concise way? I would love him to take some classes, but the money is way tight right now. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222943 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
re: Query column index number
I don't think that this is possible by number alone. Columns are akin to keys in a structure. Rows are like an array. You could possibly loop over the column list and try to access your columns that way. But beware that the column list will not be returned in the same order that you specified in your cfquery call and they will be returned in all uppercase. Jeff Original Message From: Steve Milburn [EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 11:59 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Query column index number Hi folks. How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example cfquery name=qry datasource=test #qry.column[1]# /cfquery Or something similar to this. Thanks in advance. --- --- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example Each query includes a variable called columnList that you can look at. cfoutput query=qry #evaluate(qry. listGetAt(qry.columnList, 2))# /cfoutput -Justin ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222945 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
cfoutput query=qry #evaluate(qry. listGetAt(qry.columnList, 2))# /cfoutput OR to remove the evaluate function call. cfoutput query=qry #qry[listGetAt(qry.columnlist,2)]# /cfoutout The caveat here is that columnlist is not in same order as the select clause. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222946 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
OR to remove the evaluate function call. cfoutput query=qry #qry[listGetAt(qry.columnlist,2)]# /cfoutout That would be great, if it worked. Query objects cannot be accessed like structures. Query columns can (qry.col[row]), but not the query itself. Throws a Complex object types cannot be converted to simple values error in CFMX7. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222947 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Yes, I know, and I am using that in one part of the page. Here's the rub. I am being given a spreadsheet that I have no control over. The column headers in the spreadsheet contain periods(for example, a column header might be 5.1.A.1.C), that when imported to sql server are converted to # signs, so it becomes 5#1#A#1#C. I was using something along these lines: cfloop list=qry.columnList index=column cfset colValue = #evaluate(column)# ...other stuff here... /cfloop However, CF does not like trying to evaluate columns that have # in them. I have a few other ideas, but I was hoping I could refer to the columns by an index. If I do a CFDump of the query, I get the correct values in the columns, so CF can process the table on some level. But I can't loop through the column names and evaluate them, and by the same token I cant use cfoutput query=qry#columnName#/cfoutput. Beside, I don't even know what the column names will be as they are subject to change. Thanks for your help -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 PM To: CF-Talk Subject: RE: Query column index number How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example Each query includes a variable called columnList that you can look at. cfoutput query=qry #evaluate(qry. listGetAt(qry.columnList, 2))# /cfoutput -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222948 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: Rumors from Max...
I can deploy .NET or PHP for how much? Zip... zero... Nadda. The cost of the server is the only real hurdle that stops CF from overtaking the web development world. And you're right about support in that it's too many levels before anything truly helpful come to light. Cheers, Kevin -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: November 2, 2005 12:20 PM To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max... I have never been a big fan of open source, I always preferred having a company to call for support. But that possibility vanished with Allaire. Since MM owned CF, you have to get out your creditcard just to speak to anyone. You then have to prove that your problem is due to problem with CF or a bug, and it's not your own stupidity if you do not want to get charged hundreds of dollars. There is no email support from Macromedia, you have to ask the community. So really, CF may as well be open source for all the difference it would make. I really want to find time to spend with Blue Dragon, because New Atlanta are more like Allaire, and at least you actually get support from them. -- Russ -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:39 To: CF-Talk Subject: [SPAM : 8.1] Re: Rumors from Max... Seriously. Do we really need to have a bunch of retarded posts about the demise of ColdFusionAGAIN! Hmm..I actually didn't see it as the demise of ColdFusion...I thought it sounded like a really great idea. Take something that's had the benefit of years of company development and solidity, and open it up to the rest of the community? Make money off the development front end (Dreamweaver, Studio, Flex) and use the free back end to power it all? Sounded pretty cool to me. I didn't *even* think of it as the demise of ColdFusion. I mean, imagine if ISPs simply were able to install CF on whatever server they had and there was no charge? Remember, it's just a server product. There are a bunch of other server products that do pretty much the same thing (middleware) and they don't cost a dime. I think one of the main stumbling blocks in developing CF stuff is that you have to go find yourself a CF host, or buy yourself a copy of the software and maintain a server yourself. If it was something that anyone could get and install and run, I think you'd see a LOT more hosts offering it as just a standard server/hosting product, similar to the way PHP and MySQL are pretty much offered by *every* host on the planet. I think it'd rule. I don't have much confidence in Adobe in the middleware server space...call me skeptical. I just think the community has better vision than Adobe might have in terms of what may be best for the software going forward. It sure seems like they haven't been promoting it as a complimentary technology alongside of Flex like they *should* be... And yeah, it should've been posted to Community. I started typing and the autocomplete just filled it in without me paying attention, sorry. If you want to move it over there, I certainly understand. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222949 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFContent cancels out JS
That worked great! I kept the download code as a separate page and just did a cfinclude on it. Wonderful. Thank for your help! It's even eaiser than that. cfif StructKeyExists(FORM,WhateverYouCallTheSubmitButton) cfcontent ... etc for the cfcontent bit cfelse !--- your entire page, cfdump, form and all here --- /cfif ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Have you tried using de() within your evaluate to get past the icky column names? -Justin -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:44 PM To: CF-Talk Subject: RE: Query column index number Yes, I know, and I am using that in one part of the page. Here's the rub. I am being given a spreadsheet that I have no control over. The column headers in the spreadsheet contain periods(for example, a column header might be 5.1.A.1.C), that when imported to sql server are converted to # signs, so it becomes 5#1#A#1#C. I was using something along these lines: cfloop list=qry.columnList index=column cfset colValue = #evaluate(column)# ...other stuff here... /cfloop However, CF does not like trying to evaluate columns that have # in them. I have a few other ideas, but I was hoping I could refer to the columns by an index. If I do a CFDump of the query, I get the correct values in the columns, so CF can process the table on some level. But I can't loop through the column names and evaluate them, and by the same token I cant use cfoutput query=qry#columnName#/cfoutput. Beside, I don't even know what the column names will be as they are subject to change. Thanks for your help -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 PM To: CF-Talk Subject: RE: Query column index number How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example Each query includes a variable called columnList that you can look at. cfoutput query=qry #evaluate(qry. listGetAt(qry.columnList, 2))# /cfoutput -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222951 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
What you may need to do is escape those #'s, which of course means doubling them up so they become ##'s. Some basic string manipulation would do this. Then some of the previous attempts should work. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222952 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query column index number
forgive me for not modifying this to show you only exactly what you need, but the following will show you pretty much how to get there: cfset variables.arResultsHeaders = ListToArray(variables.q.columnlist) / cfoutput table align=left style=background-color:##fff; cfif variables.numCells lte variables.maxsortableclass=sortable/cfif id=queryResults tr th Row /th cfloop from=1 to=#arrayLen(variables.arResultsHeaders)# index=i th #variables.arResultsHeaders[i]# /th /cfloop /tr cfloop from=1 to=#variables.q.recordCount# index=k tr th #NumberFormat(k,)# /th cfloop from=1 to=#arrayLen(variables.arResultsHeaders)# index=j td #variables.q[#variables.arResultsHeaders[j]#][k]# /td /cfloop /tr /cfloop /table /cfoutput where variables.q is the query. The line: #variables.q[#variables.arResultsHeaders[j]#][k]# is your money maker. On 11/2/05, Justin D. Scott [EMAIL PROTECTED] wrote: Have you tried using de() within your evaluate to get past the icky column names? -Justin -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:44 PM To: CF-Talk Subject: RE: Query column index number Yes, I know, and I am using that in one part of the page. Here's the rub. I am being given a spreadsheet that I have no control over. The column headers in the spreadsheet contain periods(for example, a column header might be 5.1.A.1.C), that when imported to sql server are converted to # signs, so it becomes 5#1#A#1#C. I was using something along these lines: cfloop list=qry.columnList index=column cfset colValue = #evaluate(column)# ...other stuff here... /cfloop However, CF does not like trying to evaluate columns that have # in them. I have a few other ideas, but I was hoping I could refer to the columns by an index. If I do a CFDump of the query, I get the correct values in the columns, so CF can process the table on some level. But I can't loop through the column names and evaluate them, and by the same token I cant use cfoutput query=qry#columnName#/cfoutput. Beside, I don't even know what the column names will be as they are subject to change. Thanks for your help -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 PM To: CF-Talk Subject: RE: Query column index number How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example Each query includes a variable called columnList that you can look at. cfoutput query=qry #evaluate(qry. listGetAt(qry.columnList, 2))# /cfoutput -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222953 Archives:
RE: Force PDF Download
Yes this is the only code on the download page! -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 12:42 PM To: CF-Talk Subject: Re: Force PDF Download Is that the only code on the download page? Aldon Moore wrote: Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222954 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query column index number
Can someone tell me if my reply came through just a second ago? I got one of those body too long messages, but it doesnt tell me if my message actually goes through anyway or not. On 11/2/05, Ian Skinner [EMAIL PROTECTED] wrote: What you may need to do is escape those #'s, which of course means doubling them up so they become ##'s. Some basic string manipulation would do this. Then some of the previous attempts should work. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222955 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force PDF Download
Both IE and FireFox Error:cannot download ebook_download.cfm -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 12:51 PM To: CF-Talk Subject: RE: Force PDF Download What fails? Do you get a message? Is it in IE and Firefox or just IE? -Original Message- From: Aldon Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 11:54 AM To: CF-Talk Subject: Force PDF Download Hello People! I need to force download a pdf file but my code is trying to download the page that contains the script! cfheader name=Content-disposition value=attachment;filename=ebook.pdf cfcontent type=application/pdf file=d:/webspace/mysite.com/wwwroot/ebook/ebook.pdf but this code fails. Is there a better solution?? Aldon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222956 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query column index number
It always goes through. That's just a warning that you need to trim. Ryan Guill wrote: Can someone tell me if my reply came through just a second ago? I got one of those body too long messages, but it doesnt tell me if my message actually goes through anyway or not. On 11/2/05, Ian Skinner [EMAIL PROTECTED] wrote: What you may need to do is escape those #'s, which of course means doubling them up so they become ##'s. Some basic string manipulation would do this. Then some of the previous attempts should work. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222957 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Yes, that message is just a warning to remind you to trim posts if you are replying. The message still goes through. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222958 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL distinct
Thanks for all your help on that one guys :) All working now. On 2 Nov 2005, at 19:36, Hassan Arteaga wrote: Hi Stuart Try Inner Join with the key in each table IE: Imagine u have two tables Basket and basketDetails in an ecommerce application SELECT* FROM_C_Basket INNER JOIN _R_BasketDetails ON _C_Basket.idBasket = _R_BasketDetails.idBasket In this case idbasket is primary key in _C_Basket ... Regards __ M.Sc. Hassan Arteaga RodrÃguez Microsoft Certified System Engineer IT Specialist DIGI Grupo de Desarrollo. COPEXTEL, S.A. Este email y sus adjuntos está dirigido solamente a los destinatarios consignados en el mismo y debe ser considerado confidencial. Si Ud. no es el destinatario consignado o la persona responsable de entregar/enviar el presente, no podrá copiarlo o entregarlo/enviarlo a ninguna otra persona ni utilizar el mismo en forma no autorizada. Dichas acciones están prohibidas y pueden ser consideradas ilegales. Si Ud. recibiese este email por error, por favor comunÃquelo de inmediato al emisor del mismo. -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 12:56 PM To: CF-Talk Subject: SQL distinct Hi guys, I'm trying to do something simple but having a bit of a bother. cfquery name=GetUsers datasource=user020 SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID /cfquery I'm trying to get a list of all the users in table tbl) 020publicUsers which have a record in the table tbl_020eventDetails. However, I keep get multiple listings for the users who have multiple rows in tbl_020eventDetails. I did trying adding the word DISTINCT after SELECT but it didn't do anything. Any help would be gratefully appreciated. Thanks, Stuart Kidd ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222959 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query column index number
ah, thanks. On 11/2/05, Ray Champagne [EMAIL PROTECTED] wrote: It always goes through. That's just a warning that you need to trim. Ryan Guill wrote: Can someone tell me if my reply came through just a second ago? I got one of those body too long messages, but it doesnt tell me if my message actually goes through anyway or not. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222960 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
OR to remove the evaluate function call. cfoutput query=qry #qry[listGetAt(qry.columnlist,2)]# /cfoutout That would be great, if it worked. Query objects cannot be accessed like structures. Query columns can (qry.col[row]), but not the query itself. Throws a Complex object types cannot be converted to simple values error in CFMX7. -Justin Scott Sorry, that's what I get for suggestion code without testing it. If one uses array notation, they must note complete, column and row. This works as test on 6.1. Should also work on 7, but I have not upgrade my workstation yet. All three methods output the same value from my test query. cfoutput query=test #test.factoid#br/ #test['factoid'][currentRow]#br/ #test[listGetAt(test.columnList,2)][currentRow]#br/ br/ /cfoutput -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222961 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Sorry, that's what I get for suggestion code without testing it. If one uses array notation, they must note complete, column and row. This works as test on 6.1. Should also work on 7, but I have not upgrade my workstation yet. All three methods output the same value from my test query. cfoutput query=test #test.factoid#br/ #test['factoid'][currentRow]#br/ #test[listGetAt(test.columnList,2)][currentRow]#br/ br/ /cfoutput Cool beans. I never tried accessing it with the row number also, so I'm glad to see that it works that way at least. -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222962 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Ryan Thank you. I think I will be able to build a workable solution with your code. Thanks again. -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 3:04 PM To: CF-Talk Subject: Re: Query column index number forgive me for not modifying this to show you only exactly what you need, but the following will show you pretty much how to get there: snip --- --- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222963 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query column index number
No problem, its sort of strange, ray camden just posted a question on his blog that was very similar. He also pointed out that you can take out the 's and #'s and it will still work. so this: #variables.q[#variables.arResultsHeaders[j]#][k]# can be this: #variables.q[variables.arResultsHeaders[j]][k]# and it will still work. Save you a few milliseconds probably ;) I wrote this code in a hurry a few months back, so I couldnt remember for sure. On 11/2/05, Steve Milburn [EMAIL PROTECTED] wrote: Ryan Thank you. I think I will be able to build a workable solution with your code. Thanks again. -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 3:04 PM To: CF-Talk Subject: Re: Query column index number forgive me for not modifying this to show you only exactly what you need, but the following will show you pretty much how to get there: snip --- --- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222964 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: JavaScript in Mouseover
I get this JavaScript error on the mouseover below: Expected ')' tr onMouseover=HighLightTR('##f0f0e1'); ondblclick=self.location=('getinventory4.cfm?id=#id#lname=#lname#fname=#fname#serialnumber=#serialnumber#'); When I just use the ?id=#id# after getinventory4.cfm I do not get an error, but I need to pass the other parameters as well. What am I missing here please? Thanks as always! Robert O. HW Rest of initial code: script //+-+-+-+-+-+-+-+-+-+-+-+-+for highlight row+-+-+-+-+-+-+-+-+-+-+-+-+// //desc: Highligt current row by click any cell //by: Qing-Hua Jiang //argument: backColor - highlight bgColor of the row // textColor - lighlight text color //call: like tr onClick=HighLightTR('#c9cc99','cc'); id=trO4 var preEl ; var orgBColor; var orgTColor; function HighLightTR(backColor,textColor){ if(typeof(preEl)!='undefined') { preEl.bgColor=orgBColor; try{ChangeTextColor(preEl,orgTColor);}catch(e){;} } var el = event.srcElement; el = el.parentElement; orgBColor = el.bgColor; orgTColor = el.style.color; el.bgColor=backColor; try{ChangeTextColor(el,textColor);}catch(e){;} preEl = el; } function ChangeTextColor(a_obj,a_color){ ; for (i=0;ia_obj.cells.length;i++){//put condition before increase! a_obj.cells(i).style.color=a_color; } } //+-+-+-+-+-+-+-+-+-+-+-+-+End of highlight row+-+-+-+-+-+-+-+-+-+-+-+-+// /script -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.7/156 - Release Date: 11/2/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222965 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: JavaScript in Mouseover
any chance that #lname# has an apostrophe in it? like O'Hara or something similar? regardless, might want to throw a JSStringFormat() around those values. can you paste the code from viewing source in the browser? easier to debug the rendered code. On 11/2/05, Orlini, Robert [EMAIL PROTECTED] wrote: I get this JavaScript error on the mouseover below: Expected ')' tr onMouseover=HighLightTR('##f0f0e1'); ondblclick=self.location=('getinventory4.cfm?id=#id#lname=#lname#fname=#fname#serialnumber=#serialnumber#'); When I just use the ?id=#id# after getinventory4.cfm I do not get an error, but I need to pass the other parameters as well. What am I missing here please? Thanks as always! Robert O. HW Rest of initial code: script //+-+-+-+-+-+-+-+-+-+-+-+-+for highlight row+-+-+-+-+-+-+-+-+-+-+-+-+// //desc: Highligt current row by click any cell //by: Qing-Hua Jiang //argument: backColor - highlight bgColor of the row // textColor - lighlight text color //call: like tr onClick=HighLightTR('#c9cc99','cc'); id=trO4 var preEl ; var orgBColor; var orgTColor; function HighLightTR(backColor,textColor){ if(typeof(preEl)!='undefined') { preEl.bgColor=orgBColor; try{ChangeTextColor(preEl,orgTColor);}catch(e){;} } var el = event.srcElement; el = el.parentElement; orgBColor = el.bgColor; orgTColor = el.style.color; el.bgColor=backColor; try{ChangeTextColor(el,textColor);}catch(e){;} preEl = el; } function ChangeTextColor(a_obj,a_color){ ; for (i=0;ia_obj.cells.length;i++){//put condition before increase! a_obj.cells(i).style.color=a_color; } } //+-+-+-+-+-+-+-+-+-+-+-+-+End of highlight row+-+-+-+-+-+-+-+-+-+-+-+-+// /script -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.7/156 - Release Date: 11/2/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222966 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: JavaScript in Mouseover
lname=#lname#fname=#fname# Can you have any quote in some of the lname or fname? It will surely give you trouble. Try to URLencore your parameters. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222967 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Force PDF Download
Aldon, I have a tutorial on my site on how to do this, but just to be sure I ran it again in FF and IE to make sure it really works. Here's the base code: cfset FilePath=z:\foo\bar\ cfset FileName=myfile.pdf cfset MIMEType=application/pdf cfset DisplayType=inline cfset FileToPush=FilePathFileName cfheader name=content-disposition value=#DisplayType#; filename=#FileName# cfcontent type=#MIMEType# file=#FileToPush# The intent of the above is to get a file to display inside of the browser, via the Acrobat browser plugin we (probably) all have installed. On IE 6 it worked great. On FF 1.0.4 the Acrobat plugin splash screen fired up but no display. Same failure across multiple attempts. Next, I changed the value of DisplayType to Attachment. cfset DisplayType=attachment The idea being you want the item to open not inside of the browser, but instead you want the actual Acrobat program to open up separately and display the file In FF this gave me the open-or-save dialog. Perfect. Same in IE6, where I chose Open and the Acrobat plugin loaded separately and brought up my file. It seemed in the beginning you were doing all the stuff I'm doing here. If so and you're getting an error I would look to file path problems, or naming the thing wrong. Also you have no space before your filename= parameter and I use one. Maybe thats it. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222968 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SPAM : 8.1] Re: Rumors from Max...
What concerns me with respect to taking this route is the development path of the product. ColdFusion Application Server would be one hell of a big sourceforge project. Yeah I know linux did it, but there would have to be a sizable brain trust commitment from corporations to keep the CF platform moving forward. I don't see that happening with volunteer work. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222969 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Force PDF Download
Thanks Matt.. Iwill test this method... Al -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 5:19 PM To: CF-Talk Subject: Re: Force PDF Download Aldon, I have a tutorial on my site on how to do this, but just to be sure I ran it again in FF and IE to make sure it really works. Here's the base code: cfset FilePath=z:\foo\bar\ cfset FileName=myfile.pdf cfset MIMEType=application/pdf cfset DisplayType=inline cfset FileToPush=FilePathFileName cfheader name=content-disposition value=#DisplayType#; filename=#FileName# cfcontent type=#MIMEType# file=#FileToPush# The intent of the above is to get a file to display inside of the browser, via the Acrobat browser plugin we (probably) all have installed. On IE 6 it worked great. On FF 1.0.4 the Acrobat plugin splash screen fired up but no display. Same failure across multiple attempts. Next, I changed the value of DisplayType to Attachment. cfset DisplayType=attachment The idea being you want the item to open not inside of the browser, but instead you want the actual Acrobat program to open up separately and display the file In FF this gave me the open-or-save dialog. Perfect. Same in IE6, where I chose Open and the Acrobat plugin loaded separately and brought up my file. It seemed in the beginning you were doing all the stuff I'm doing here. If so and you're getting an error I would look to file path problems, or naming the thing wrong. Also you have no space before your filename= parameter and I use one. Maybe thats it. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222970 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Passing functions as arguments?
Well I pass objects all the time, but in the case of a result function typically i'd want to call a method in the components specifically. Here is a simplified example of what I'm trying to do cfset userObj = createObject('component', 'extensions.components.user.user').init(userkey) cfset test = userObj.getUserTypeInCenter cfdump var=#test# cfset test(userObj.defaultCenters.pc) The cfdump will show that test is a function, however it does not keep the values that are passed to the component. It returns an error saying that certain variables that are defined in the init are not defined. However doing this instead works fine: cfset userObj = createObject('component', 'extensions.components.user.user').init(userkey) cfset userObj.getUserTypeInCenter(userObj.defaultCenters.pc) How I ended up making it work was passing a struct like this struct.component = userObj struct.method = create Then on the resulting function I do cfinvoke component=#result.component# method=#result.method# Thanks for all the replies, it seems that ColdFusion is so close to doing it right, to me this seems like a very clean way to pass result messages. Let me know if anyone thinks I'm doing it wrong, I'd love to stand corrected. Kenton On Nov 2, 2005, at 12:40 PM, Raymond Camden wrote: Another example is QuickSort at CFLIB: http://www.cflib.org/udf.cfm?ID=518 On 11/2/05, Ben Forta [EMAIL PROTECTED] wrote: Actually, you can indeed pass the name of a function to another function, perhaps as a callback (a bit like using pointers to functions in C). I used this technique in an XML based menuing app I wrote a while back. Details are at http://www.macromedia.com/devnet/coldfusion/extreme/xml_menu.html. --- Ben -- == = Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/ teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Need query help please
For my products, I have a tblImageTypes that looks like this ImageTypeID (PK) ImageTypeName 1Thumbnail 2Large I have a many/linking tblimages_rel that looks like this ImageID (PK) ImageTypeID (FK) prodID (FK) filename 11 25 shirtsmall.jpg 22 25 shirtlarge.jpg On my detail page I'd like to show the small image and link it to the larger image but I'm having trouble on how to run my query. cfquery blah blah SELECT imageID, prodID, imagetypeID, prodimagefilename FROM tblimages_rel WHERE prodID = #URL.prodID# ??? Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222972 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Caching, caching what is doing all this caching?!
Yesterday, my workstation started experiencing some maddening kind of intermittent caching. Ian, I had a similarly maddening experience just as I switched (simultaneously) from ColdFusion Server 5 to MX7 and from Dreamweaver Ultradev 4 to Dreamweaver 8. Don't know what caused it, but here is the ridiculous end I went to to get around the problem in the short term: I was playing with something where I needed to employ the poor old technique of trial-and-error. So, I posted the code and ran it. But it wouldn't reload, no matter what I did on the client side, unless there was a change in the size (I think) of the end file. Since I was making single character changes, it didn't reload. So, I added a 1 in the code for the body, pushed it, and it reloaded fine. After that test, I added a 2, so it now read 12, and repeated. Each time, I would add a new number (since simply changing the number would not work), until I was all done, then I deleted the whole string. Ugly, but it got me through what was indeed a maddening time. If anyone knows why this is happening, I would be curious... HTH, Matthieu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222973 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Find no records
Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need query help please
why not just name the images something like img_large.jpg and img_thumb.jpg this way you can just store img in the database (in one record), and output #img#_large.jpg or #img#_thumb.jpg depending on which you need? On 11/2/05, Will Tomlinson [EMAIL PROTECTED] wrote: For my products, I have a tblImageTypes that looks like this ImageTypeID (PK) ImageTypeName 1Thumbnail 2Large I have a many/linking tblimages_rel that looks like this ImageID (PK) ImageTypeID (FK) prodID (FK) filename 11 25 shirtsmall.jpg 22 25 shirtlarge.jpg On my detail page I'd like to show the small image and link it to the larger image but I'm having trouble on how to run my query. cfquery blah blah SELECT imageID, prodID, imagetypeID, prodimagefilename FROM tblimages_rel WHERE prodID = #URL.prodID# ??? Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find no records
SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT DISTINCT userID FROM tbl_020eventDetails) On 11/2/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222976 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find no records
Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery SELECT columns FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT e.userID FROM tbl_020eventDetails e) -Justin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222977 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find no records
Try this code. cfquery name=GetPromoters datasource=user020 SELECT u.userID,u.firstName,u.lastName,u.emailAddress,u.password FROM tbl_020publicUsers u WHERE (SELECT count(*) FROM tbl_020eventDetails e WHERE e.userID = u.userID) = 0 /cfquery Charlie Hanlon Web Apps Developer Food Service Enablers, Inc. www.fsenablers.com The People. The Platform. The Products. Make the Difference - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, November 02, 2005 4:50 PM Subject: Find no records Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222978 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find no records
Maybe this will work. I may not be understanding what you need. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT UserID FROM tbl_020eventDetails e) /cfquery On 11/2/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222979 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: JavaScript in Mouseover
I get this JavaScript error on the mouseover below: Expected ')' tr onMouseover=HighLightTR('##f0f0e1'); ondblclick=self.location=('getinventory4.cfm?id=#id#lname=#lname#fnam e=#fname#serialnumber=#serialnumber#'); When I just use the ?id=#id# after getinventory4.cfm I do not get an error, but I need to pass the other parameters as well. Robert, Is the code above wrapped in CFOUTPUT tags? I ask because I just ran the following code on my site: self.location=('myPage.cfm?id=#id#lname=#lname#'); When I arrived at the page on my site, I saw this in the address bar: myPage.cfm?id=#idlname=lname So, it's stripping out those extra hash marks and the browser will treat everything to the right of id= as a page anchor address, and you'll have no query string vars passed. Are you sure that the error is being thrown by the mouseover code and not some JavaScript on the new target page? If you are sure, I'd have to see the HighlightTR function to go further. Hope this helps, Matthieu ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222980 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need query help please
yeah I agree with Charlie.. just add an extra column called thumbnail with the image name. On 11/2/05, Charlie Griefer [EMAIL PROTECTED] wrote: why not just name the images something like img_large.jpg and img_thumb.jpg this way you can just store img in the database (in one record), and output #img#_large.jpg or #img#_thumb.jpg depending on which you need? On 11/2/05, Will Tomlinson [EMAIL PROTECTED] wrote: For my products, I have a tblImageTypes that looks like this ImageTypeID (PK) ImageTypeName 1Thumbnail 2Large I have a many/linking tblimages_rel that looks like this ImageID (PK) ImageTypeID (FK) prodID (FK) filename 11 25 shirtsmall.jpg 22 25 shirtlarge.jpg On my detail page I'd like to show the small image and link it to the larger image but I'm having trouble on how to run my query. cfquery blah blah SELECT imageID, prodID, imagetypeID, prodimagefilename FROM tblimages_rel WHERE prodID = #URL.prodID# ??? Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Caching, caching what is doing all this caching?!
If anyone knows why this is happening, I would be curious... HTH, Matthieu Now that I got most of my crunch out of the way, I did some experimenting. I noticed that DW8 had not replaced my DW7, even though it did copy all my settings. Rather nice of Eight I think. So, I loaded up Seven and did a handful of trials. I had no problems. So it does seem to be some artifice of DW8, but then why does bouncing the CF Application service, solve the clear the caching behavior? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222982 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find no records
Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday I suspect the other suggestions would work, but since we originally went the inner join rout why not do the outer join route which is designed for this purpose. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u LEFT OUTER JOIN tbl_020eventDetails e ON u.userID = e.userID AND e.userID IS NULL /cfquery -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find no records
SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password FROM tbl_020publicUsers u WHERE not exists (select * from tbl_020eventDetails e where u.userID = e.userID) May perform a bit better than NOT IN -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 4:56 PM To: CF-Talk Subject: Re: Find no records SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT DISTINCT userID FROM tbl_020eventDetails) On 11/2/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find no records
Thanks for your help everyone, definitely got it working now. Thanks, Saturday On 2 Nov 2005, at 22:54, Brian Peddle wrote: SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password FROM tbl_020publicUsers u WHERE not exists (select * from tbl_020eventDetails e where u.userID = e.userID) May perform a bit better than NOT IN -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 4:56 PM To: CF-Talk Subject: Re: Find no records SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT DISTINCT userID FROM tbl_020eventDetails) On 11/2/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
tinymce image uploader
I know someone had a image uploader for tinymce, anyone have a link? if not how is the newer versions of fckeditor? I seem to recall someone had a decent uploader for that as well but Im concerned with cross browser support ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222986 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54