RE: PostgreSQL database size
Mike, Check out the ColdFusion + ArcIMS blog for more information: http://www.mariposa.com.au/arcims/ Cheers, Hugo (we are using CFMX + ArcSDE + ArcIMS ) -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Office [mailto:[EMAIL PROTECTED] | Sent: Tuesday, November 30, 2004 06:35 | To: CF-Talk | Subject: Re: PostgreSQL database size | | My understanding is (don't have any of these ESRI goodies | yet) that an xml call is made to arcIMS giving extant and layers etc. | | The image returned can then be inserted as a static image on | any web page. | | The CMS has been designed to store a reference to extants and | layers. So CF should be able to put a static map image on any page. | | Mike | | -- Original Message -- | From: Paul Hastings [EMAIL PROTECTED] | Reply-To: [EMAIL PROTECTED] | Date: Tue, 30 Nov 2004 11:38:38 +0700 | | Office wrote: | I've seen flash interfaces on ArcIMS and they seem to run | much faster | than the java stuff. Our main website which is a content management | system runs on CF and we | are hoping to put up an alternative flash remoting interface | on that for users who want it. The CMS will call and insert | the maps into the CMS pages both cf and flash. Well thats the idea. | | i can't see how. backend is still backend, nothing to do | w/the user GUI. | a flash or html frontend still has to call the arcIMS | server for the server to generate an image. unless you're | confusing the java client w/the java connector? the java | client is a true GIS client, ie it gets the raw data from the | server does stuff with it locally. the java connector is | just that, a connector, like the cfx or asp connectors to arcIMS. | | | | ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185636 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: OT: Flashpaper
Hey, Well I am having some good success with Flashpaper and calling it via ColdFusion BUT the problem I have is this: when you convert an HTM or HTML page it always comes up with the damn printing dialog box which the user has to select - which makes no sense as when you convert a .doc it does it automatically. I have placed a call with MM to see what the scoop is on thisas it would seem to be a bug. N -Original Message- From: E C list [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 21:16 To: CF-Talk Subject: RE: OT: Flashpaper I haven't tried Martin's tag, but I can tell you from using the free tag CF_HTML2PDF3 that also relies on HTMLdoc to convert to pdf's that its not quite perfect. Unfortunately, I can't use FOP because I am on ColdFusion 5 for the server where this is needed. It looks like FOP would be a better alternative if I were able to use that one. I would really love to see a flashpaper plugin too. That would be very welcomed. -Original Message- From: Martin Parry [mailto:[EMAIL PROTECTED] Sent: Friday, November 26, 2004 10:25 AM To: CF-Talk Subject: RE: OT: Flashpaper Hiya - I've posted a template which is part of my CMS for you. It relies on HTMLDoc and uses CFEXECUTE to convert inbound HTML passed as an attribute into a PDF file. The template is at http://www.beetrootstreet.com/_media/zip/PDFSaveContent.ZIP HTMLDOC is found at http://www.easysw.com/htmldoc/software.php?VERSION=1.8.24 Hope you can make good use of it. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.com __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185637 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: Best way to access CFC's?
Thanks Dave, I will take a look. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 17:47 To: CF-Talk Subject: Re: Best way to access CFC's? On Mon, 29 Nov 2004 12:39:35 -0400, Andy Mcshane [EMAIL PROTECTED] wrote: Starting to update a site by converting code to CFC's, anyone have any thoughts on what is the best or most efficient way to access a CFC? Is it better to use CFInvoke or should I use CreateObject? Which method is better and why? They're effectively the same thing, except you'd use createObject if you're a cfscript fan and the tag-based cfinvoke if you're not. If you are new or relatively new to CFCs, be sure to check out this document which is a community-driven best practices document for working with them: http://www.dintenfass.com/cfcbestpractices/ Regards, Dave. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185638 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: Best way to access CFC's?
Are there any benefits of one over the other? Are there any performance issues to consider? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 18:29 To: CF-Talk Subject: Re: Best way to access CFC's? CFINVOKE and createObject are very different beasts. CFOBJECT and createObject are the same, but CFINVOKE creates and instance of the CFC, calls the specified method on it, and then lets the instance disappear, with no hope of holding on to it for future reuse. Here's two examples of creating an object instance: cfset i = createObject(component, test) / cfobject action=create type=component name=i class=test / And here's two examples of calling a method on a CFC, without creating an instance: cfset r = createObject(component, test).testMethod() / cfinvoke component=test method=testMethod returnvariable=r / cheers, barneyb ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185639 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 and Databases
Jason Smith wrote: I have a client that has access backend for his cf application, when trying to run a query for a report that checks for item status the page always times out never will load. The query works on other reports with no problem. There are about 1500 products in the field and the status id is numerical from 1-10. Now myself personally I would never use an access database for this type of work I would prefer to use mysql but I don't have that choice. So if anyone is familiar with cf/access or know of any issues that have to do with access indexing not working correctly under a cf app please let know. 1500 records is really a drop in the ocean for what, the much maligned, Access can handle. Its not ideal for a web app, but it'll handle a hell of a lot more traffic than is generally made out with careful querying and the judicious use of the various types of caching available in CF. The problem sound like it is down to the query and the indexes on the tables. Can you tell us the query and the table structure, specifically the column type and indexes for the columns that are joined? Stephen ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185640 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: Best way to access CFC's?
Thanks, that makes it a little clearer. Now for the newbie dumb question, how does the code know where to find the components? i.e. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / Do you have to create a mapping to a directory called component that contains all of the CFC's? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 19:16 To: CF-Talk Subject: Re: Best way to access CFC's? If you're component is stateful, you'll want to invoke methods on the same instance of the component instead of continually creating new instances. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / !--- Set first number --- cfinvoke component=#myAdder# method=setNumberOne cfinvokeargument name=number value=2 /cfinvoke !--- Set second number --- cfinvoke component=#myAdder# method=setNumberTwo cfinvokeargument name=number value=3 /cfinvoke !--- Get sum --- cfinvoke component=#myAdder# method=getSum returnVariable=sum /cfinvoke !--- Displays five --- cfoutput#sum#/cfoutput There's a few different ways to write thisI'd probably use: cfset myAdder = createObject(component, addsTwoNumbers) / cfset myAdder.SetNumberOne(2) / cfset myAdder.SetNumberTwo(3) / cfoutput#myAdder.getSum()#/cfoutput -joe ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185641 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: Slideshow like on news.bbc.co.uk
Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre reason. It just comes up blank. I'm hosted on a shared server and have been told that the component is installed. Should it be this hard or am i doing something wrong? Thanks, Stu From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 20:36:56 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Slideshow like on news.bbc.co.uk easy to do in java just look up free java slideshow on google then use your cfm output query as the images in the java personally its much easier to just do it in flash -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 18:49:16 + Hi guys, I'm trying to make a slideshow, I was going to do it with an iframe but then I came across some problems with iframes how I needed to put a query not only on my main page, but also in my iframe as I realised that the iframe being another page isn't like an include. I'm not thinking that an iframe isn't the best way to go. On the bbc news website (http://news.bbc.co.uk/1/hi/in_pictures/4049765.stm) they have a good little system which works with javascript. Is there any easy way to do this with CF or will I need something client side? First I run a query and collect all the photoID's (from my photo table) which correspond to a particular article. Then I check to see if there is only one photo then I just output that, but if there is more than 1 then I put it into a slideshow. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185642 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
CFEclipse - Database Viewer (MS Access)
Just start using cfeclipse and I'm loving it. Most of our Databases are MS Access Database and I am looking for a good Eclipse plugin that would allow me to view and work with MS Access. I've tried dbViewer and it only seems to accept jdbc connection and from my understanding MS Access requires odbc or some sort of jdbc - odbc bridge. This is where it begins to get a little over my head. But if some one is using eclipse to work with MS Accesss Databases I would greatly appreciate your help. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185643 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: Slideshow like on news.bbc.co.uk
Stuart please look this site: http://www.renatoimoveis.com/venda_detalhes.cfm?imovID=E117DE64-3472-FB8F-9FBE84A746D5F0D1 in the footer you could see a very nice slide show built with js and populate from CF. Click in iniciar to start the slide show. parar will stop, avançar and so on... If you need fast access to any image you could click in the select field located at the right side in slide show. Clicking in any image will open an new window with big image. If looks nice I could send that script to you. Cheers On Tue, 30 Nov 2004 06:23:44 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre reason. It just comes up blank. I'm hosted on a shared server and have been told that the component is installed. Should it be this hard or am i doing something wrong? Thanks, Stu From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 20:36:56 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Slideshow like on news.bbc.co.uk easy to do in java just look up free java slideshow on google then use your cfm output query as the images in the java personally its much easier to just do it in flash -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 18:49:16 + Hi guys, I'm trying to make a slideshow, I was going to do it with an iframe but then I came across some problems with iframes how I needed to put a query not only on my main page, but also in my iframe as I realised that the iframe being another page isn't like an include. I'm not thinking that an iframe isn't the best way to go. On the bbc news website (http://news.bbc.co.uk/1/hi/in_pictures/4049765.stm) they have a good little system which works with javascript. Is there any easy way to do this with CF or will I need something client side? First I run a query and collect all the photoID's (from my photo table) which correspond to a particular article. Then I check to see if there is only one photo then I just output that, but if there is more than 1 then I put it into a slideshow. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185644 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: CFEclipse - Database Viewer (MS Access)
Hmm, I would say that this is possible...have a look at http://eclipse-plugins.2y.net/eclipse/plugins.jsp?category=Database, you get what you want here. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 11:32 To: CF-Talk Subject: CFEclipse - Database Viewer (MS Access) Just start using cfeclipse and I'm loving it. Most of our Databases are MS Access Database and I am looking for a good Eclipse plugin that would allow me to view and work with MS Access. I've tried dbViewer and it only seems to accept jdbc connection and from my understanding MS Access requires odbc or some sort of jdbc - odbc bridge. This is where it begins to get a little over my head. But if some one is using eclipse to work with MS Accesss Databases I would greatly appreciate your help. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185645 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: CFEclipse - Database Viewer (MS Access)
Thanks. I looked at many of these and I had a difficult time finding something that works with MS Access. In fact tried DBEdit and dbViewer and no luck.I can certainly try a few of the other but I was hoping to avoid the hassel of installing things that don't work. Or maybe they do and I'm just not doing something right. The documentation for both DBEdit and dbViewer is just hurrible. -- Original Message -- From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 11:38:42 - Hmm, I would say that this is possible...have a look at http://eclipse-plugins.2y.net/eclipse/plugins.jsp?category=Database, you get what you want here. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 11:32 To: CF-Talk Subject: CFEclipse - Database Viewer (MS Access) Just start using cfeclipse and I'm loving it. Most of our Databases are MS Access Database and I am looking for a good Eclipse plugin that would allow me to view and work with MS Access. I've tried dbViewer and it only seems to accept jdbc connection and from my understanding MS Access requires odbc or some sort of jdbc - odbc bridge. This is where it begins to get a little over my head. But if some one is using eclipse to work with MS Accesss Databases I would greatly appreciate your help. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185646 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: Incremental CFCONTENT?
Thanks to all. This is great, and works well. I keep forgetting that cfmx now has jsp/servlet support. Not quite sure if it improves performance all that much, but it makes me feel comfortable that I'm not needlessly CFFILE-reading cached sections of pages into memory before dumping them to the output stream. BTW - do you happen to know whether this books a new http request in IIS web server logs? (not that it is so important, just curious). Thanks again, -dov -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, November 29, 2004 5:57 PM To: CF-Talk Subject: Re: Incremental CFCONTENT? It won't try to compile the file if there is no server mapping to the .txt extension. Use cfset getPageContext().include(header-static-html.txt) It's my understanding that this will, in fact, execute the page if it is a JSP or CFM file. Is it the case that it will not attempt to execute the page if it isn't mapped to a specific executable file extension? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185647 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
Error establishing socket
I'm running MSSQL2k and CFMX 6.1 on the same box. I just bounced the cf box b/c the JRun Protocol Error page was showing (Cannot connect to JRun)... on some, but not all requests. Then, I got this error after bouncing CF,... Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Error establishing socket. No buffer space available (maximum connections reached?): JVM_Bind Any ideas? Thanks -dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185648 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
Possible Connection Leak?
After doing some debugging, my JVM_BIND issue seems like CF's java process ran out of file handles (however you describe them on windows sockets, etc)... I suspect there is a leak in error handling of CFMail which can forget to close socket resources obtained in the mail thread If I had to guess, there's no finally{ close connections... } in the mail spool thread, if there is an exception in the connect method. The reason I say this, is because right before my JVM_BIND (no more available connections / max connections reached) exceptions were thrown, I saw TONS of the excerpted log snippets below. (and I suspect the exception was thrown after obtaining some sort of socket resource, and not giving it back). Is there any way to ask Macromedia from this list? Error,scheduler-0,11/30/04,04:53:36,,Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.BindException: Address already in use: connect javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.BindException: Address already in use: connect at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:867) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:156) at javax.mail.Service.connect(Service.java:234) at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:871) at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:744) at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:674) at coldfusion.mail.MailSpooler.deliverStandard(MailSpooler.java:947) at coldfusion.mail.MailSpooler.run(MailSpooler.java:912) at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201) at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:70) -dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185649 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: Slideshow like on news.bbc.co.uk
no its not hard but im not sure that u need to go all the way to remoting look at this http://www.jamwerx.com/slides/1.htm if that works for you just save the page and use that swf, u can resize it if u need to then there are 2 embeds the 1st one uses images i manually entered, the 2nd i commented out, look at the image names, in the 2nd it calls a cfm variable that i set by doing a query and making a list outta the output. I use something like that to show images on real estate sites, pretty easy -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 06:23:44 -0500 Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre reason. It just comes up blank. I'm hosted on a shared server and have been told that the component is installed. Should it be this hard or am i doing something wrong? Thanks, Stu From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 20:36:56 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Slideshow like on news.bbc.co.uk easy to do in java just look up free java slideshow on google then use your cfm output query as the images in the java personally its much easier to just do it in flash -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 18:49:16 + Hi guys, I'm trying to make a slideshow, I was going to do it with an iframe but then I came across some problems with iframes how I needed to put a query not only on my main page, but also in my iframe as I realised that the iframe being another page isn't like an include. I'm not thinking that an iframe isn't the best way to go. On the bbc news website (http://news.bbc.co.uk/1/hi/in_pictures/4049765.stm) they have a good little system which works with javascript. Is there any easy way to do this with CF or will I need something client side? First I run a query and collect all the photoID's (from my photo table) which correspond to a particular article. Then I check to see if there is only one photo then I just output that, but if there is more than 1 then I put it into a slideshow. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185650 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: Best way to access CFC's?
In that example, it will look in the directory of the calling template. The component part of the call tells it that you're creating an object of type component. You can also have a mapping to a directory for components, and you can also use dot notation. For example: cfset myAdder = createObject(component, addsTwoNumbers) / looks in current directory or looks in mapped cfc directory if it's at the root (but I doubt that) cfset myAdder = createObject(component, cfc.addsTwoNumbers) / looks in root of directory mapped to /cfc - Original Message - From: Andy Mcshane [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 4:28 AM Subject: RE: Best way to access CFC's? Thanks, that makes it a little clearer. Now for the newbie dumb question, how does the code know where to find the components? i.e. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / Do you have to create a mapping to a directory called component that contains all of the CFC's? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 19:16 To: CF-Talk Subject: Re: Best way to access CFC's? If you're component is stateful, you'll want to invoke methods on the same instance of the component instead of continually creating new instances. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / !--- Set first number --- cfinvoke component=#myAdder# method=setNumberOne cfinvokeargument name=number value=2 /cfinvoke !--- Set second number --- cfinvoke component=#myAdder# method=setNumberTwo cfinvokeargument name=number value=3 /cfinvoke !--- Get sum --- cfinvoke component=#myAdder# method=getSum returnVariable=sum /cfinvoke !--- Displays five --- cfoutput#sum#/cfoutput There's a few different ways to write thisI'd probably use: cfset myAdder = createObject(component, addsTwoNumbers) / cfset myAdder.SetNumberOne(2) / cfset myAdder.SetNumberTwo(3) / cfoutput#myAdder.getSum()#/cfoutput -joe ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185651 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: Best way to access CFC's?
Great, got it. Many thanks for your help. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 13:19 To: CF-Talk Subject: Re: Best way to access CFC's? In that example, it will look in the directory of the calling template. The component part of the call tells it that you're creating an object of type component. You can also have a mapping to a directory for components, and you can also use dot notation. For example: cfset myAdder = createObject(component, addsTwoNumbers) / looks in current directory or looks in mapped cfc directory if it's at the root (but I doubt that) cfset myAdder = createObject(component, cfc.addsTwoNumbers) / looks in root of directory mapped to /cfc - Original Message - From: Andy Mcshane [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 4:28 AM Subject: RE: Best way to access CFC's? Thanks, that makes it a little clearer. Now for the newbie dumb question, how does the code know where to find the components? i.e. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / Do you have to create a mapping to a directory called component that contains all of the CFC's? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 19:16 To: CF-Talk Subject: Re: Best way to access CFC's? If you're component is stateful, you'll want to invoke methods on the same instance of the component instead of continually creating new instances. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / !--- Set first number --- cfinvoke component=#myAdder# method=setNumberOne cfinvokeargument name=number value=2 /cfinvoke !--- Set second number --- cfinvoke component=#myAdder# method=setNumberTwo cfinvokeargument name=number value=3 /cfinvoke !--- Get sum --- cfinvoke component=#myAdder# method=getSum returnVariable=sum /cfinvoke !--- Displays five --- cfoutput#sum#/cfoutput There's a few different ways to write thisI'd probably use: cfset myAdder = createObject(component, addsTwoNumbers) / cfset myAdder.SetNumberOne(2) / cfset myAdder.SetNumberTwo(3) / cfoutput#myAdder.getSum()#/cfoutput -joe ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185652 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: CFEclipse - Database Viewer (MS Access)
My guess would be that DBEdit would work if you can find a JDBC driver for Access: http://servlet.java.sun.com/products/jdbc/drivers/search_results.jsp?jdbc_ve rsion=0vendor_name=cert_mode=andjdbc_driver_type_mode=anddbms=6dbms_mod e=andfeatures_mode=andresults_per_page=20submit=Search dbViewer seems to work using ODBC. Did you try setting up an ODBC data source and pointing it at your Access database? Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 6:58 AM To: CF-Talk Subject: RE: CFEclipse - Database Viewer (MS Access) Thanks. I looked at many of these and I had a difficult time finding something that works with MS Access. In fact tried DBEdit and dbViewer and no luck.I can certainly try a few of the other but I was hoping to avoid the hassel of installing things that don't work. Or maybe they do and I'm just not doing something right. The documentation for both DBEdit and dbViewer is just hurrible. -- Original Message -- From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 11:38:42 - Hmm, I would say that this is possible...have a look at http://eclipse-plugins.2y.net/eclipse/plugins.jsp?category=Database, you get what you want here. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 11:32 To: CF-Talk Subject: CFEclipse - Database Viewer (MS Access) Just start using cfeclipse and I'm loving it. Most of our Databases are MS Access Database and I am looking for a good Eclipse plugin that would allow me to view and work with MS Access. I've tried dbViewer and it only seems to accept jdbc connection and from my understanding MS Access requires odbc or some sort of jdbc - odbc bridge. This is where it begins to get a little over my head. But if some one is using eclipse to work with MS Accesss Databases I would greatly appreciate your help. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185653 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: CFEclipse - Database Viewer (MS Access)
dbViewer seems to work using ODBC. Did you try setting up an ODBC data source and pointing it at your Access database? Huh? Sorry I'm a Newbie at least when in comes to working with ODBC / JDBC drivers. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185654 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: CFEclipse - Database Viewer (MS Access)
dbViewer seems to work using ODBC. Did you try setting up an ODBC data source and pointing it at your Access database? Just discover that my databasess are referenced in the System ODBC area. Now it dbViewer it ask for a directory path to the driver. How do you find that? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185655 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: Licensing a CF app
I'm not sure that re-writing a tonne of code is what would be required. We've converted a number of fairly large applications (thousands of pages) to BlueDragon; the time doing so is usually measured in hours or days. Often it's only one or two tweaks that have to be made to get everything running. Most BlueDragon customers approach this no differently than they would an upgrade from CF5 to CFMX, for example. That is, they don't expect their CF5 code to run perfectly out of the box on CFMX, and therefore don't expect the same from BlueDragon. Of course, just as for the CF5-to-CFMX upgrade, there has to be enough benefit to the BlueDragon upgrade to make it worth your effort. The first step (after reviewing the BlueDragon CFML Compatibility Guide) is to run the BlueDragon precompiler on your code base--this will flush out most of the incompatibilities. After that, it's a simple matter of running through your application to verify that everything works. We're happy to provide assistance if you're interested in making a go of it. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Martin Parry [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 1:55 AM To: CF-Talk Subject: RE: Licensing a CF app I've pained over this and finally decided that the only feasible way to do it was to provide a CMS appliance to the customers who wanted to host their own websites/intranets using my CMS. This is essentially a locked down server that only I have access to (for updates etc.). I also spent quite a while trying to re-use the .class files that CF generates. Proved a tad too tricky so I ditched that idea. Blue Dragon - When I was looking at it, yes it was very good and offered this type of functionality but I have a LOT of code in the CMS and Blue Dragon didn't work out of the box. As I'm genetically lazy I couldn't stomach re-writing a tonne of code - so stuck in my comfort zone ;) Just my 2¢ worth Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 21:35 To: CF-Talk Subject: Re: Licensing a CF app Thanks to everyone who replied. I had forgotten about BlueDragon's ISV program. And I guess it's unknown whether the Blackstone functionality referred to would actually allow the sort of disabling we'd like. From comments I've seen here before, Coral gets mixed reviews. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185656 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: CFMX 6.1 - java.lang.NullPointerException
The stack trace does seem to report an issue with casting a particular variable as a double datatype, and which is somehow related to the update of data in the client scope. In my experience, however, NullPointerException errors are triggered by invalid custom tag references. ie, the filename is generate_main_navbar.cfm, but you call it as cf_generate_main_navigation_bar. Might be another thing to look for if you can't determine the client-scope issue. Matt Matthew Drayer ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185657 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
Calendar Apps?
Old subject but thought I would aask again is there any free calendar apps out there anyone is willing to part with I am looking for something that someone can check there own as well of the rest of the groups events. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185658 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: Calendar Apps?
http://calendar.viviotech.net/ Sooo close to being done... -Jordan Eric Creese wrote: Old subject but thought I would aask again is there any free calendar apps out there anyone is willing to part with I am looking for something that someone can check there own as well of the rest of the groups events. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185659 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: MX Methodologies (Mach2?? Fusebox??)
It is a big deal if it made your job easier and your project more successful. My point is that it DOES NOT make my job easy. Apparently, at least for the product I'm thinking of, it made easier for the programmers to make an inefficient system that repeats 5 times the same query in the same page, etc. And it is a commercial product. And no, trying to find my way in a structure that includes 100 templates DOES NOT make my job easier. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185660 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: MX Methodologies (Mach2?? Fusebox??)
Don't you mean a web page.. when.. someone talks to me about a web application.. i'm more thinking in terms of web services.. There is no difference, a Web application is nothing but a set of Web pages working on some set of data. Hmm.. how about RemoteScripting (JSRS), Flash.. These is on the client side, we are talking about CF on server. I think.. again you are reffering to a CF Web Site.. CF applications.. are little diffrent then.. A CF powered Web site IS a CF Application. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185661 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: MX Methodologies (Mach2?? Fusebox??)
I'm not sure how many times it must be stated in this thread that using a framework will not prevent a bad developer from writing bad code any more than using an OO language like Java can prevent bad code. If this application that you worked on made an inefficient system that duplicates queries then they clearly didn't know what they were doing. Same goes for their use of included files, if the files were not organized well and named appropriately then no framework in the world is going to help. Frameworks exist to make the life of a developer easier, not more difficult. If a framework isn't helping someone do their job, for whatever reason, the answer is simple: don't use one. For me, software engineering is always about learning new things and taking new approaches. The more I learn the better developer I become. From this standpoint, I would say learning OOP, as well as becoming familiar with frameworks, are both very good investments. At best, one may discover some very useful things and add new techniques to their toolkit. At worse, one has added to their knowledge about programming and can now make decisions and assessments when they see other people's code using OOP or frameworks. Either way they benefit. On Tue, 30 Nov 2004 09:56:47 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: It is a big deal if it made your job easier and your project more successful. My point is that it DOES NOT make my job easy. Apparently, at least for the product I'm thinking of, it made easier for the programmers to make an inefficient system that repeats 5 times the same query in the same page, etc. And it is a commercial product. And no, trying to find my way in a structure that includes 100 templates DOES NOT make my job easier. -- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185662 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: Calendar Apps?
Jordan, Hey - how about a sample -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 7:32 AM To: CF-Talk Subject: Re: Calendar Apps? http://calendar.viviotech.net/ Sooo close to being done... -Jordan Eric Creese wrote: Old subject but thought I would aask again is there any free calendar apps out there anyone is willing to part with I am looking for something that someone can check there own as well of the rest of the groups events. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185663 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: Calendar Apps?
I was in the middle of creating one if you ping me about it from time to time (or check my blog periodically), I'll gladly give it away. ~Simon Simon Horwith Chief Information Officer, AboutWeb http://www.aboutweb.com Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com Eric Creese wrote: Old subject but thought I would aask again is there any free calendar apps out there anyone is willing to part with I am looking for something that someone can check there own as well of the rest of the groups events. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185664 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: Slideshow like on news.bbc.co.uk
Here is a little slide show I did that uses JavaScript and CF. It pulls the name of all the pictures in a specific directory and then builds the slide show from there allowing me to add or remove pictures just by putting pictures in the directory. If you are interested I can send you the CF code. Doug James IT Developer Hollings Cancer Center http://hcc.musc.edu Stuart Kidd wrote: Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre reason. It just comes up blank. I'm hosted on a shared server and have been told that the component is installed. Should it be this hard or am i doing something wrong? Thanks, Stu From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 20:36:56 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Slideshow like on news.bbc.co.uk easy to do in java just look up free java slideshow on google then use your cfm output query as the images in the java personally its much easier to just do it in flash -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 18:49:16 + Hi guys, I'm trying to make a slideshow, I was going to do it with an iframe but then I came across some problems with iframes how I needed to put a query not only on my main page, but also in my iframe as I realised that the iframe being another page isn't like an include. I'm not thinking that an iframe isn't the best way to go. On the bbc news website (http://news.bbc.co.uk/1/hi/in_pictures/4049765.stm) they have a good little system which works with javascript. Is there any easy way to do this with CF or will I need something client side? First I run a query and collect all the photoID's (from my photo table) which correspond to a particular article. Then I check to see if there is only one photo then I just output that, but if there is more than 1 then I put it into a slideshow. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185665 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: Slideshow like on news.bbc.co.uk
Sorry, forgot the link: http://www.dragonboatcharleston.org/index.cfm?show=photos.main Doug Doug James wrote: Here is a little slide show I did that uses JavaScript and CF. It pulls the name of all the pictures in a specific directory and then builds the slide show from there allowing me to add or remove pictures just by putting pictures in the directory. If you are interested I can send you the CF code. Doug James IT Developer Hollings Cancer Center http://hcc.musc.edu Stuart Kidd wrote: Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre reason. It just comes up blank. I'm hosted on a shared server and have been told that the component is installed. Should it be this hard or am i doing something wrong? Thanks, Stu From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 20:36:56 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Slideshow like on news.bbc.co.uk easy to do in java just look up free java slideshow on google then use your cfm output query as the images in the java personally its much easier to just do it in flash -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 18:49:16 + Hi guys, I'm trying to make a slideshow, I was going to do it with an iframe but then I came across some problems with iframes how I needed to put a query not only on my main page, but also in my iframe as I realised that the iframe being another page isn't like an include. I'm not thinking that an iframe isn't the best way to go. On the bbc news website (http://news.bbc.co.uk/1/hi/in_pictures/4049765.stm) they have a good little system which works with javascript. Is there any easy way to do this with CF or will I need something client side? First I run a query and collect all the photoID's (from my photo table) which correspond to a particular article. Then I check to see if there is only one photo then I just output that, but if there is more than 1 then I put it into a slideshow. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185666 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: CFEclipse - Database Viewer (MS Access)
I don't use windows or access so this is mostly just bits of information... What you have to do is setup a system (or user I guess) odbc data source (using control panel) - which should be basic for a windows savy sort... then for the jdbc driver you use the jdbc odbc bridge. The driver name is: sun.jdbc.odbc.JdbcOdbcDriver Then the url you connect to is: jdbc:odbc:Fred Where Fred is generally your data source name or database system. That should work with quantam (I assume) or with BBEdit. Here is a quick read from a java point of view, but still a bit helpful http://java.sun.com/docs/books/tutorial/jdbc/basics/connecting.html Good luck On Tue, 30 Nov 2004 06:31:57 -0500, Dwayne Cole [EMAIL PROTECTED] wrote: Just start using cfeclipse and I'm loving it. Most of our Databases are MS Access Database and I am looking for a good Eclipse plugin that would allow me to view and work with MS Access. I've tried dbViewer and it only seems to accept jdbc connection and from my understanding MS Access requires odbc or some sort of jdbc - odbc bridge. This is where it begins to get a little over my head. But if some one is using eclipse to work with MS Accesss Databases I would greatly appreciate your help. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185667 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
unix user cfexecute
In the documentation of cfexecute the effective user is mentioned. I like to know how to find out the user who executes the executable fired by cfexecute. I think this is the effective user, but when i try to found out about it on the web I could not find a thing about it. Can anybodie help me with this, i like to use scp to transfer some files from the databaseserver server to the aplicationserver server. Thnx in advance, Gijs ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185668 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: MX Methodologies (Mach2?? Fusebox??)
Claude, My question was worded that way due to the way his statement was worded. I was simply curious what he felt was, I was not hinting towards anything with the question just being curious since his statement to me implied that he thought there was a general better solution. I always find Dave's posts interesting and have over the years, has certainly led me to investigate various things on my own to see what they are all about. I agree with most of the points you made in your various emails on this subject. I for one do not try to do OO, FB, Mach-II, or whatever just because I feel it has to be done no matter what the projects needs are. I am always curious as to why people use some of these things and yes I do use some of them sometimes. However usually the reasons I see stated are just the same rehashed reasons and often I wonder if people use them because they are sheep or truely because the reason they gave. BTW, I am a sheep at times so I mean nothing insultive with that comment. :) -- Aaron Rouse http://www.happyhacker.com/ On Mon, 29 Nov 2004 23:01:39 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: Which language do you think is ideal for OO web programming? Now this is a bad question. One should ask Which language is ideal to do what I have to do. OO programming is a tool, not a goal, if it is the best tool, go OO, if something else is better, simpler or whatever, for Christ sake, use it ! ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185669 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: Slideshow like on news.bbc.co.uk
I would like the code cause I use a js slide show now and would like to populate it dynamically -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 9:58 AM To: CF-Talk Subject: Re: Slideshow like on news.bbc.co.uk Here is a little slide show I did that uses JavaScript and CF. It pulls the name of all the pictures in a specific directory and then builds the slide show from there allowing me to add or remove pictures just by putting pictures in the directory. If you are interested I can send you the CF code. Doug James IT Developer Hollings Cancer Center http://hcc.musc.edu Stuart Kidd wrote: Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre reason. It just comes up blank. I'm hosted on a shared server and have been told that the component is installed. Should it be this hard or am i doing something wrong? Thanks, Stu From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 20:36:56 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Slideshow like on news.bbc.co.uk easy to do in java just look up free java slideshow on google then use your cfm output query as the images in the java personally its much easier to just do it in flash -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 18:49:16 + Hi guys, I'm trying to make a slideshow, I was going to do it with an iframe but then I came across some problems with iframes how I needed to put a query not only on my main page, but also in my iframe as I realised that the iframe being another page isn't like an include. I'm not thinking that an iframe isn't the best way to go. On the bbc news website (http://news.bbc.co.uk/1/hi/in_pictures/4049765.stm) they have a good little system which works with javascript. Is there any easy way to do this with CF or will I need something client side? First I run a query and collect all the photoID's (from my photo table) which correspond to a particular article. Then I check to see if there is only one photo then I just output that, but if there is more than 1 then I put it into a slideshow. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185670 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: MX Methodologies (Mach2?? Fusebox??)
Claude Schneegans wrote: It is a big deal if it made your job easier and your project more successful. My point is that it DOES NOT make my job easy. Apparently, at least for the product I'm thinking of, it made easier for the programmers to make an inefficient system that repeats 5 times the same query in the same page, etc. And it is a commercial product. And no, trying to find my way in a structure that includes 100 templates DOES NOT make my job easier. I tend to stay out of the fusebox arguments and have since in the inception of FB3, which is frankly a right old mess and deserves the criticism it deserves when, in my opinion (which probably isn't worth a damn), it lost sight one of the original core concepts of Fusebox; readability. It became illegible to the casual code browser and the core code was quite capable of generating spaghetti without adding anything extra to the application. This said, Mach-ii does intrigue me and given appropriate time I will be taking a look at it. This all aside, well a written Fusebox application, whatever version you use be it FB2, xFB, FB3, FB4 or Mach-ii (not strictly FB, but an off-shoot all the same), should NOT call the same query in the same page 5 times. That is just plain bad application design and development and is not a function of Fusebox. Breaking an application into lots of small templates that are only included when required and controlled by conditions is actually very efficient in version of CF prior to CFMX. The reason being that in previous version of CF included files are only ever interpreted when a surrounding condition was found to be true. For example : cfif somecondition cfinclude template=thisfile.cfm cfelse cfinclude template=thatfile.cfm /cfif If somecondition is true then thisfile.cfm is picked up and interpreted, but thatfile.cfm is ignored. If these templates are actually quite large and the code was inline in the condition above, then every single line of code would have to be interpreted, rather than only the code that is required for the given condition. This doesn't forgive bad layout of conditions and poor naming for files, but with readable code, sensible filenames and a fuseaction you should be able to isolate the file you need to one or two files at the most fairly quickly. Unfortunately, FB3 does not lend itself well to this simple concept because it attempts to make life easy for you by allowing you to map circuits in the fbx_Circuits.cfm file and having 300 lines of code in one of 5 files in order to work all that out. I still use an enhanced/extended version of fb2 after all these years. I can go back to an application that I haven't looked at in years or look at any number of applications written by a number of colleagues around the country and within minutes I can follow the code and find the files I need. (I may cringe at some of the code I wrote way-back-when, but that soon repaired if needs be) Anyway, after all that, my point is that your problem with this application that you mention is unlikely to due to the fact that it is a Fusebox framework application and more to do with shoddy workmanship. You should have been able to add a new circuit for your new functionality and simple change a few display templates in order to add the appropriate links to the new actions in your new circuit. Fusebox really is just a simple hub/spoke procedural framework at the end of the day. Other than that, I agree with a lot of what you've said. Other than for code re-use, I still don't quite understand why OO is being forced onto a concept that is inherently procedural. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185671 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
cfstoredproc and cfdump
I'm using the following stored procedure and using cfdump to see the output. This is the stored procedure:- cfstoredproc procedure=mysp dataSource=mydsn username=myusername password=mypassword cfprocparam value=#Form.username# cfsqltype=CF_SQL_INTEGER type=In cfprocparam value=#Form.password# cfsqltype=CF_SQL_VARCHAR type=In cfprocresult name=searchResults /cfstoredproc cfdump var=#searchResults# The output from cfdump returns :B1 P_KEY Y 1234567 The Y denotes that the user has a normal login. There are three other flags that can be returned based on the user's situation A, E or W but I don't know what the column names are. How can I reference whether a Y, A, E or W are returned when I don't know the column id's? TIA ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185672 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
Anyone see this error before?
I got this out of the blue on CFMX 6.1 unable to create new native thread If you know what would cause it, could you explain it to me? -- Phillip B. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185673 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: Anyone see this error before?
I have seen it thrown on a CFFILE action upload ... ended up being an incorrect destination path being plugged into the tag. Greg Landers -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 10:33 AM To: CF-Talk Subject: Anyone see this error before? I got this out of the blue on CFMX 6.1 unable to create new native thread If you know what would cause it, could you explain it to me? -- Phillip B. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185674 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: cfstoredproc and cfdump
queryName.columnList ? -Adam On Tue, 30 Nov 2004 11:18:03 -0400, Ian Littlefair [EMAIL PROTECTED] wrote: I'm using the following stored procedure and using cfdump to see the output. This is the stored procedure:- cfstoredproc procedure=mysp dataSource=mydsn username=myusername password=mypassword cfprocparam value=#Form.username# cfsqltype=CF_SQL_INTEGER type=In cfprocparam value=#Form.password# cfsqltype=CF_SQL_VARCHAR type=In cfprocresult name=searchResults /cfstoredproc cfdump var=#searchResults# The output from cfdump returns :B1 P_KEY Y 1234567 The Y denotes that the user has a normal login. There are three other flags that can be returned based on the user's situation A, E or W but I don't know what the column names are. How can I reference whether a Y, A, E or W are returned when I don't know the column id's? TIA ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185675 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: MX Methodologies (Mach2?? Fusebox??)
Other than for code re-use, I still don't quite understand why OO is being forced onto a concept that is inherently procedural. Forced is a strong word, but probably accurate given the current environment in development today. As people have said, there are situations where it is useful and others where it is most likely overkill. A good example of overkill is when developing a Mom Pop, Inc. web site to sell watermelon lollipops, or a simple content management system for a small business. However, any major web application of significant complexity (valuate that however you will) should be using OO concepts in some degree. My current assignment has me looking over procedural code that was poorly written in 2000 as bad developers were put into a bad situation. Fast forward to 2004 and this code is now a momumental challenge to maintain and extend. Most modules easily reach 300-500 lines of code (sometimes more) and can accomplish several tasks. Tracking down one bug, even for highly skilled developers, can take an entire workday. It would require 8-12 months for a team of 3 or more developers to repurpose this into a manageable and scalable application. As we have heard, examples like this abound (which I still find amazing these days), and the best thing to focus on is writing clean, simple code that is adequately documented and follows industry best practices. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185676 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: MX Methodologies (Mach2?? Fusebox??)
Look, this is all very simple. The best frameworks/methodologies ranked in order are: 1) Mach-II 2) JSF-CF (Java Server Faces for CF) 3) CFOBJECKTS 4) FuseBox 4 5) FuseBox 3 6) MVC-QT (The most RAD environment for making MVC apps) The new MX-XCEL framework and wireframing system should be out in a 0.9 rev after the first of the year. It will set the development world on fire, as it is tied directly to the new event gateway functionality in Blackstone. -- A ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185677 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
just a test: ignore
just testing ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185678 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: MX Methodologies (Mach2?? Fusebox??)
Care to provide links for some of those, namely JSF-CF, MVC-QT and MX-XCEL? I couldn't find anything on Google for them. Thanks. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Why are you wearing that stupid man suit? - Frank ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185679 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: unix user cfexecute
On Tue, 30 Nov 2004 11:13:04 -0400, gijs meirmans [EMAIL PROTECTED] wrote: In the documentation of cfexecute the effective user is mentioned. I like to know how to find out the user who executes the executable fired by cfexecute. I think this is the effective user, but when i try to found out about it on the web I could not find a thing about it. Can anybodie help me with this, i like to use scp to transfer some files from the databaseserver server to the aplicationserver server. It's the user that the coldfusion process (or jrun if you're using the J2EE version) is running as. However, I would strongly advise that you stay away from cfexcute on unix systems if you can. Because of the way the fork() method was implemented on unix systems (which is what cfexecute calls under the hood to run the external process) it duplicates the amount of memory of the calling process to run the external process, which is crazy. So, for example, if your JRun process is currently taking up 1 GB of RAM (a pretty common JVM size), then cfexecute will run the external process using 1 GB of RAM, which will very quickly throw an Out of Memory exception. I learned this the hard way so I figured I'd save you the hassle down the road. In single-user testing you might not see the error because you might have enough swap space to create this second process, but any more than a couple of users will bring your system to a grinding halt. So I'm not sure what you're trying to do, but I would find another way to do it. Mind you, this is not Macromedia's problem -- it's a UNIX problem that is just a known implementation issue. Regards, Dave. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185680 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 Query question. Please help...
Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185681 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: cfstoredproc and cfdump
queryName.columnList ? -Adam On Tue, 30 Nov 2004 11:18:03 -0400, Ian Littlefair [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185682 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: cfstoredproc and cfdump
Thanks Adam. Could you be a bit more specific please? Ian ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185683 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 Query question. Please help...
Multiple ways heres one: SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) Adam On Tue, 30 Nov 2004 12:01:30 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185684 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 Query question. Please help...
How about this? Select CustID from customers where custID not in (select custid from orders) -dov -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:01 PM To: CF-Talk Subject: SQL Query question. Please help... Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185685 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 Query question. Please help...
Sometimes using NOT can have performance issues You can also do: SELECT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:06 AM To: CF-Talk Subject: Re: SQL Query question. Please help... Multiple ways heres one: SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) Adam On Tue, 30 Nov 2004 12:01:30 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185686 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 Query question. Please help...
Lookingat this more you will probably only want unique customers so it some opne places multiple orders you may want to throw a distinct in there SELECT DISTINCT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Eric Creese Sent: Tuesday, November 30, 2004 11:05 AM To: CF-Talk Subject: RE: SQL Query question. Please help... Sometimes using NOT can have performance issues You can also do: SELECT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:06 AM To: CF-Talk Subject: Re: SQL Query question. Please help... Multiple ways heres one: SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) Adam On Tue, 30 Nov 2004 12:01:30 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185687 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 Query question. Please help...
select custid from customers minus select custid from orders On Tue, 30 Nov 2004 11:05:11 -0600, Eric Creese [EMAIL PROTECTED] wrote: Sometimes using NOT can have performance issues You can also do: SELECT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:06 AM To: CF-Talk Subject: Re: SQL Query question. Please help... Multiple ways heres one: SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) Adam On Tue, 30 Nov 2004 12:01:30 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185688 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 Query question. Please help...
Sometimes not join in the from clause can have performance issues too plus that will only return customers that are in both tables. If you prefer ther other route youi can do this: Select Distinct cust.CustId From Customers cust LEFT JOIN orders ON cust.custID = orders.CustId Where Orders.CustId IS NULL Either way 98% of the time if you look at the excecution plan that is produced by SQL server you will find them to be the same. Other DBMS I don't know about. Adam H On Tue, 30 Nov 2004 11:05:11 -0600, Eric Creese [EMAIL PROTECTED] wrote: Sometimes using NOT can have performance issues You can also do: SELECT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:06 AM To: CF-Talk Subject: Re: SQL Query question. Please help... Multiple ways heres one: SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) Adam On Tue, 30 Nov 2004 12:01:30 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first query gets all Customer IDs. The second query gets all Csutomer IDs that have placed orders. Is there some way in SQL, to combine these two queries into one and return only the Customer IDs that are in the 'Customers' table that ARE NOT in the 'Orders' table. Using this example, 200 records would be returned. Any help would be appreciated. Che ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185689 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 Query question. Please help...
Adam/Dov Using your query my recordcount is off. Actual # of customer ids from my customers table = 865. Actual # of customer ids from my orders table = 596. Using your query, the difference = 335. 865 - 596 should = 269. What am I missing? Debug info is below. - getCustsFromCusts (Records=865, Time=0ms) SQL = SELECT CustID FROMCustomers getCustsFromOrders (Records=596, Time=15ms) SQL = SELECT CustID FROMOrders getCustsNoOrder (Records=335, Time=16ms) SQL = SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185690 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 Query question. Please help...
Under your math you are assuming a 1 to 1 relationship between orders and Custromers. Unless you are running a scam, where no customer would ever by from you twice, that is not case, the whole reason you have 2 seperate tables. Hope thats makes sense. Adam H On Tue, 30 Nov 2004 12:18:23 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Adam/Dov Using your query my recordcount is off. Actual # of customer ids from my customers table = 865. Actual # of customer ids from my orders table = 596. Using your query, the difference = 335. 865 - 596 should = 269. What am I missing? Debug info is below. - getCustsFromCusts (Records=865, Time=0ms) SQL = SELECT CustID FROMCustomers getCustsFromOrders (Records=596, Time=15ms) SQL = SELECT CustID FROMOrders getCustsNoOrder (Records=335, Time=16ms) SQL = SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185691 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: CFScheduler and java mail exceptions....
Sorry for bumping this, but *any help it appreciated! Thanks Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 10:45 am To: CF-Talk Subject: CFScheduler and java mail exceptions Morning all I've got a scheduled task that distributes about 1400 e-mails to our users. Recently though it's only been sending about 1000 of these e-mails: the remaining 400 do not send (have to send manually). There is nothing in the application.log, but the following is in MailSent.log (x400 lines): Information,scheduler-4,11/29/04,09:48:35,,Moved undelivered mail: Mail56511.cfmail to C:\CFusionMX/Mail/Undelivr directory And the following is in the exception.log (x400 times): Error,scheduler-4,11/29/04,09:48:35,,220 tmcmon02-lgn.penmail.bt.com NTMail (v4.30.0013/NT2289.01.57849cd5) ready for ESMTP transfer javax.mail.MessagingException: 220 tmcmon02-lgn.penmail.bt.com NTMail (v4.30.0013/NT2289.01.57849cd5) ready for ESMTP transfer at com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879) at com.sun.mail.smtp.SMTPTransport.helo(SMTPTransport.java:511) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:243) at javax.mail.Service.connect(Service.java:234) at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:871) at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:744) at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:674) at coldfusion.mail.MailSpooler.deliverStandard(MailSpooler.java:947) at coldfusion.mail.MailSpooler.run(MailSpooler.java:912) at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201) at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:70) Any ideas as to what I should be looking at to get this fixed? Cheers rob ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185692 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 Query question. Please help...
You have multiple Orders for some customers. What is count for: SELECT DISTINCT Custid from Orders -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:18 PM To: CF-Talk Subject: RE: SQL Query question. Please help... Adam/Dov Using your query my recordcount is off. Actual # of customer ids from my customers table = 865. Actual # of customer ids from my orders table = 596. Using your query, the difference = 335. 865 - 596 should = 269. What am I missing? Debug info is below. - getCustsFromCusts (Records=865, Time=0ms) SQL = SELECT CustID FROMCustomers getCustsFromOrders (Records=596, Time=15ms) SQL = SELECT CustID FROMOrders getCustsNoOrder (Records=335, Time=16ms) SQL = SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185693 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 Query question. Please help...
I see. Haven't had my lunch yet. Thanks for your help. Che -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:23 PM To: CF-Talk Subject: Re: SQL Query question. Please help... Under your math you are assuming a 1 to 1 relationship between orders and Custromers. Unless you are running a scam, where no customer would ever by from you twice, that is not case, the whole reason you have 2 seperate tables. Hope thats makes sense. Adam H On Tue, 30 Nov 2004 12:18:23 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Adam/Dov Using your query my recordcount is off. Actual # of customer ids from my customers table = 865. Actual # of customer ids from my orders table = 596. Using your query, the difference = 335. 865 - 596 should = 269. What am I missing? Debug info is below. - getCustsFromCusts (Records=865, Time=0ms) SQL = SELECT CustID FROMCustomers getCustsFromOrders (Records=596, Time=15ms) SQL = SELECT CustID FROMOrders getCustsNoOrder (Records=335, Time=16ms) SQL = SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185694 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 Query question. Please help... HA!
At 12:22 PM 11/30/2004, Adam Haskell wrote: Under your math you are assuming a 1 to 1 relationship between orders and Custromers. Unless you are running a scam, where no customer would ever by from you twice, that is not case, the whole reason you have 2 seperate tables. Hope thats makes sense. Ahhh, database design is always easier when there is a scam involved. And when programming for the mob, you never need to have a confirmation for the delete button. ;) Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED]| | Home: 919.303.0218| | Off Road Rally Racing Team: http://LinaRacing.com/ | |Do you like Evite? This is better: http://RSVPtracker.com/ | +===+ ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185695 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: cfstoredproc and cfdump
Ian Littlefair wrote: Thanks Adam. Could you be a bit more specific please? If you output searchResults.columnlist after you've called your stored procedure it should give you the list of columns returned. However, from your cfdump I would hazard that the column names will be :B1 and P_Key. You might want to look at your SP to get it to return your flag column in a valid column name, say something like login_flag Hope that helps Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185696 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 Question
In MS SQL, why does this work: CASE YEAR(tabInvoices.InvoiceDate) but this throw and error that InvoiceDate is not in group: CASE YEAR(tabInvoices.InvoiceDate) -1 I can't add InvoiceDate to GROUP BY because then the results are wrong Andy ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185697 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: cfstoredproc and cfdump
Stephen Moretti (cfmaster) wrote: Ian Littlefair wrote: Thanks Adam. Could you be a bit more specific please? If you output searchResults.columnlist after you've called your stored procedure it should give you the list of columns returned. However, from your cfdump I would hazard that the column names will be :B1 and P_Key. You might want to look at your SP to get it to return your flag column in a valid column name, say something like login_flag Oh! Meant to say. You should still be able to access that :B1 column inside a cfloop/cfoutput, like this : searchResults[:B1] Stephen ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185698 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
CFMODULE vs. CFINCLUDE
I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece bought up an old question I had. Is there any performance difference between a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout? In the first case, your code is: cfmodule template=layout.cfm Display stuff /cfmodule In the second case you have: CFINCLUDE template=header Display Stuff CFINCLUDE template=footer Because of the nature of the CFMODULE, it's called twice and various variables are created in its process. The CFINCLUDE method uses 2 CFINCLUDES, but there's nothing special about them. No extra variables, etc. Logic says that the CFINCLUDE method of template layout is more efficient, but I'd like to know what others think? I'll ask the question about what people think of the pagecontext include vs. cfinclude another time. :) ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185699 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: CFMODULE vs. CFINCLUDE
CFModule encapsulates the layout nicer than 2 isolated CFINCLUDES... You have a single layout.cfm which detects if #thistag.executionmode# is start and shows the header or footer. It makes for an easier read if the module is CF_TAGNAME'd.. Example... You have layout.cfm, so you can do this: CF_LAYOUT my page /CF_LAYOUT That's more elegant than cfinclude header, cfinclude footer, and allows you to pass in custom arguments since it's using cfmodule under the covers. That's my take on things -dov -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:46 PM To: CF-Talk Subject: CFMODULE vs. CFINCLUDE I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece bought up an old question I had. Is there any performance difference between a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout? In the first case, your code is: cfmodule template=layout.cfm Display stuff /cfmodule In the second case you have: CFINCLUDE template=header Display Stuff CFINCLUDE template=footer Because of the nature of the CFMODULE, it's called twice and various variables are created in its process. The CFINCLUDE method uses 2 CFINCLUDES, but there's nothing special about them. No extra variables, etc. Logic says that the CFINCLUDE method of template layout is more efficient, but I'd like to know what others think? I'll ask the question about what people think of the pagecontext include vs. cfinclude another time. :) ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185700 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: CFMODULE vs. CFINCLUDE
Michael Dinowitz wrote: I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece bought up an old question I had. Is there any performance difference between a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout? In the first case, your code is: cfmodule template=layout.cfm Display stuff /cfmodule In the second case you have: CFINCLUDE template=header Display Stuff CFINCLUDE template=footer Because of the nature of the CFMODULE, it's called twice and various variables are created in its process. The CFINCLUDE method uses 2 CFINCLUDES, but there's nothing special about them. No extra variables, etc. Logic says that the CFINCLUDE method of template layout is more efficient, but I'd like to know what others think? I'll ask the question about what people think of the pagecontext include vs. cfinclude another time. :) If I remember correctly, doesn't cfmodule create a whole new memory block for every call, where as the cfinclude will only use the existing memory space and be part of the normal page cache? Even if this isn't true for CFMX any more, personally, I'd probably lean towards the cfinclude method, because a) thats what I'm used to, b) I find it visually easier to read c) I feel like can tinker with the header and footer dynamically with a cfinclude than a cfmodule. andd) Easier to get to the header and footers if I need to change them or simply replace them. What goes on inside the the cfmodule? Is the header and footer actually inside the cfmodule template or does it include the header and footer templates? If it includes them, then it'd be a bit of a pointless call to the cfmodule, if its in the cfmodule template, then refer to my point (d) above. ;) Stephen ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185701 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: MX Methodologies (Mach2?? Fusebox??)
Damien McKenna wrote: Care to provide links for some of those, namely JSF-CF, MVC-QT and MX-XCEL? I couldn't find anything on Google for them. Thanks. Please forgive me. I couldn't resist throwing a bunch of made up frameworks into the mix to fan the flames. The names are pretty good, though, no?! As for the MX-XCEL, it's my own bastardization of Mach-II and an implicit invocation system. Works quite well. I guess I could release the code -- Alex Sherwood ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185702 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: CFEclipse - Database Viewer (MS Access)
This almost worked. It seems to referring to the named datasource, which in my case is a ms accesss file, as a database server and all the registered ODBC datasources are showing up as database on the server. The schema information was correctly queryed but details about the columns etc. did not work. -- Original Message -- From: Rob [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 08:10:26 -0800 I don't use windows or access so this is mostly just bits of information... What you have to do is setup a system (or user I guess) odbc data source (using control panel) - which should be basic for a windows savy sort... then for the jdbc driver you use the jdbc odbc bridge. The driver name is: sun.jdbc.odbc.JdbcOdbcDriver Then the url you connect to is: jdbc:odbc:Fred Where Fred is generally your data source name or database system. That should work with quantam (I assume) or with BBEdit. Here is a quick read from a java point of view, but still a bit helpful http://java.sun.com/docs/books/tutorial/jdbc/basics/connecting.html Good luck On Tue, 30 Nov 2004 06:31:57 -0500, Dwayne Cole [EMAIL PROTECTED] wrote: Just start using cfeclipse and I'm loving it. Most of our Databases are MS Access Database and I am looking for a good Eclipse plugin that would allow me to view and work with MS Access. I've tried dbViewer and it only seems to accept jdbc connection and from my understanding MS Access requires odbc or some sort of jdbc - odbc bridge. This is where it begins to get a little over my head. But if some one is using eclipse to work with MS Accesss Databases I would greatly appreciate your help. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185703 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: MX Methodologies (Mach2?? Fusebox??)
That is so hilarious and I'm being serious not sarcastic at all. Great input as always Alex. On Tue, 30 Nov 2004 11:39:46 -0500, Alex Sherwood [EMAIL PROTECTED] wrote: Look, this is all very simple. The best frameworks/methodologies ranked in order are: 1) Mach-II 2) JSF-CF (Java Server Faces for CF) 3) CFOBJECKTS 4) FuseBox 4 5) FuseBox 3 6) MVC-QT (The most RAD environment for making MVC apps) The new MX-XCEL framework and wireframing system should be out in a 0.9 rev after the first of the year. It will set the development world on fire, as it is tied directly to the new event gateway functionality in Blackstone. -- A ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185704 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 Question
Andy, Try: YEAR(dateadd(year,-1,tabInvoices.InvoiceDate) -mk -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:37 AM To: CF-Talk Subject: SQL Question In MS SQL, why does this work: CASE YEAR(tabInvoices.InvoiceDate) but this throw and error that InvoiceDate is not in group: CASE YEAR(tabInvoices.InvoiceDate) -1 I can't add InvoiceDate to GROUP BY because then the results are wrong Andy ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185705 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
Embedding Images in Excel
We have a series of reports which include graphs (via cfchart in .jpg format). We provide the ability to export those reports to Excel. However, if a user saves that excel spreadsheet and opens it later (after CF has cleared the cache), the image has expired. Primarily, this is because, instead of embedding the actual images in the file, it treats it like an img tag and pulls the image from the server each time. But, because CF no longer has that image connection, the chart no longer shows up. In the livedocs, I've seen one work-around that would fix this, where you bascially copy the chart to a new location, so it's not part of the charting cache. But, that would require storing those images, which can quickly eat up space. What I'd like to do, if possible, is actually embed the image inside the Excel file (rather than there just being a link to the image). Is there a way to do that with CF? Some details on our system: 1) 2 load-balanced servers with automatic replication [yes, sticky sessions are on, so it shouldn't be an issue of it looking at the wrong server -- actually, it can be an issue, because when they re-open the file, they may be sent to the other server. But, it's essentially the same as CF clearing its charting cache] 2) CFMX 6.1 on Win2k3. Thanks in advance! Scott -- - Scott Brady http://www.scottbrady.net/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185706 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: MX Methodologies (Mach2?? Fusebox??)
If you're serious I'm sure numerous people would be interested in looking at it! On Tue, 30 Nov 2004 13:05:40 -0500, Alex Sherwood [EMAIL PROTECTED] wrote: Damien McKenna wrote: Care to provide links for some of those, namely JSF-CF, MVC-QT and MX-XCEL? I couldn't find anything on Google for them. Thanks. Please forgive me. I couldn't resist throwing a bunch of made up frameworks into the mix to fan the flames. The names are pretty good, though, no?! As for the MX-XCEL, it's my own bastardization of Mach-II and an implicit invocation system. Works quite well. I guess I could release the code -- Alex Sherwood ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185707 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: MX Methodologies (Mach2?? Fusebox??)
Brian Kotek wrote: If you're serious I'm sure numerous people would be interested in looking at it! Unfortunately, it removes much of the proper restrictions in Mach-II (like peeking into the eventQueue, prepeding events, extending the framework iteself) that create the uniformity of the framework. I've chosen to overlook some of the better programming practices enforced by Mach-II - all for the sake of convenience. Maybe over the Christmas break [can I say Christmas, or do I need to say Holiday break? - ;-)] I'll sit down and package it up in a zip file. -- A ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185708 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: CFMODULE vs. CFINCLUDE
If I remember correctly, doesn't cfmodule create a whole new memory block for every call, where as the cfinclude will only use the existing memory space and be part of the normal page cache? You are correct, even in CFMX. Even if this isn't true for CFMX any more, personally, I'd probably lean towards the cfinclude method, because a) thats what I'm used to, Same here. b) I find it visually easier to read Same here. e) Allows you to cycle in special headers/footers at any time rather than editing a central display template. What goes on inside the the cfmodule? Is the header and footer actually inside the cfmodule template or does it include the header and footer templates? If it includes them, then it'd be a bit of a pointless call to the cfmodule, if its in the cfmodule template, then refer to my point (d) above. ;) The header and footer is actually inside the cfmodule with a piece of logic to see if it's the start or end of the execution. The content between the cfmodule call tags is evaluated after the tag start and before the tag end. Also, all content between the tags is loaded into a variable called generatedcontent. It's overhead I don't like, but there may be something I'm missing which is why I asked. Well, that and I like to make people think. :) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185709 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: CFMODULE vs. CFINCLUDE
Not that it's a huge deal, but don't forget that cfmodule also requires a single file compilatation as opossed to two file compilations, as well ;) ~Simon Simon Horwith Chief Information Officer, AboutWeb http://www.aboutweb.com Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com Katz, Dov B (IT) wrote: CFModule encapsulates the layout nicer than 2 isolated CFINCLUDES... You have a single layout.cfm which detects if #thistag.executionmode# is start and shows the header or footer. It makes for an easier read if the module is CF_TAGNAME'd.. Example... You have layout.cfm, so you can do this: CF_LAYOUT my page /CF_LAYOUT That's more elegant than cfinclude header, cfinclude footer, and allows you to pass in custom arguments since it's using cfmodule under the covers. That's my take on things -dov -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:46 PM To: CF-Talk Subject: CFMODULE vs. CFINCLUDE I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece bought up an old question I had. Is there any performance difference between a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout? In the first case, your code is: cfmodule template=layout.cfm Display stuff /cfmodule In the second case you have: CFINCLUDE template=header Display Stuff CFINCLUDE template=footer Because of the nature of the CFMODULE, it's called twice and various variables are created in its process. The CFINCLUDE method uses 2 CFINCLUDES, but there's nothing special about them. No extra variables, etc. Logic says that the CFINCLUDE method of template layout is more efficient, but I'd like to know what others think? I'll ask the question about what people think of the pagecontext include vs. cfinclude another time. :) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185710 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: Calendar Apps?
I'm in the process of creating a simple calendaring app as a proof-of-concept for a backend framework I'm working on. Both the framework and the app will be free (as in speech and beer) when I'm done. cheers, barneyb On Tue, 30 Nov 2004 08:40:08 -0600, Eric Creese [EMAIL PROTECTED] wrote: Old subject but thought I would aask again is there any free calendar apps out there anyone is willing to part with I am looking for something that someone can check there own as well of the rest of the groups events. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185711 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: Embedding Images in Excel
Try inserting a simple image into a blank excel sheet and then save it and open the excel sheet in a text editor. See what the actual code looks like and how they embed an image in there. John -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 1:15 PM To: CF-Talk Subject: Embedding Images in Excel We have a series of reports which include graphs (via cfchart in .jpg format). We provide the ability to export those reports to Excel. However, if a user saves that excel spreadsheet and opens it later (after CF has cleared the cache), the image has expired. Primarily, this is because, instead of embedding the actual images in the file, it treats it like an img tag and pulls the image from the server each time. But, because CF no longer has that image connection, the chart no longer shows up. In the livedocs, I've seen one work-around that would fix this, where you bascially copy the chart to a new location, so it's not part of the charting cache. But, that would require storing those images, which can quickly eat up space. What I'd like to do, if possible, is actually embed the image inside the Excel file (rather than there just being a link to the image). Is there a way to do that with CF? Some details on our system: 1) 2 load-balanced servers with automatic replication [yes, sticky sessions are on, so it shouldn't be an issue of it looking at the wrong server -- actually, it can be an issue, because when they re-open the file, they may be sent to the other server. But, it's essentially the same as CF clearing its charting cache] 2) CFMX 6.1 on Win2k3. Thanks in advance! Scott -- - Scott Brady http://www.scottbrady.net/ ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185712 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: MX Methodologies (Mach2?? Fusebox??)
I've worked on precisely zero web apps that didn't have to have functionality added to it. I've worked on precisely zero web apps that didn't have to have maintenance done to it. This is over the course of 7 years. Everything a developer writes can benefit from OO. Does it make apps more maintainable? Sure. Can it make it worse? Sure. Do I have to use my brain cells to make sure it's more maintainable? Yes. Aww heck. I don't even know why I try here. I've never met so many damn IT people that are so unwilling to even try something new and try to at least have an informed opinion, but instead like to criticize something that doesn't fit into their narrow programming view using the usual lame ad hominem and straw man attacks. (this is not directed at you, Steve). Other than for code re-use, I still don't quite understand why OO is being forced onto a concept that is inherently procedural. Forced is a strong word, but probably accurate given the current environment in development today. As people have said, there are situations where it is useful and others where it is most likely overkill. A good example of overkill is when developing a Mom Pop, Inc. web site to sell watermelon lollipops, or a simple content management system for a small business. However, any major web application of significant complexity (valuate that however you will) should be using OO concepts in some degree. My current assignment has me looking over procedural code that was poorly written in 2000 as bad developers were put into a bad situation. Fast forward to 2004 and this code is now a momumental challenge to maintain and extend. Most modules easily reach 300-500 lines of code (sometimes more) and can accomplish several tasks. Tracking down one bug, even for highly skilled developers, can take an entire workday. It would require 8-12 months for a team of 3 or more developers to repurpose this into a manageable and scalable application. As we have heard, examples like this abound (which I still find amazing these days), and the best thing to focus on is writing clean, simple code that is adequately documented and follows industry best practices. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185713 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
Best Practice: Import Delimited List to Database
Client is looking for an application to import a delimited list of names and email addresses directly into a database for further manipulation. While I can think of a number of ways to pull this off, what's the opinion on the most efficient way to doing it? Thanks, -- Les Mizzell ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185714 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: CFMODULE vs. CFINCLUDE
I'd agree with Simon, specifically the not that it's a huge big deal. I'll go out on a limb here and say if your site will not work when using cf_foo/cf_foo versus an include, then you have other problems. Yes, cf_foo (or cfmodule) is slower than cfinclue. But don't worry about it. Unless you are running Spectra and have 500 or so custom tags running at once, it will never be a real issue. I'd always go for the custom tag solution since it protects your calling documents from having their variables screwed up by the customtag/cfinclude code. e) Allows you to cycle in special headers/footers at any time rather than editing a central display template. You can also just simply not use the custom tag on a page that needs something special. Also, all content between the tags is loaded into a variable called generatedcontent. I don't think it's copied, I'm pretty sure it is a reference. Did you notice that you can modify this value and it changes what is between the tags? You don't have to return anything, just reset it. If I can summarize, I do not believe the performance reasons are a valid concern. I'd go with the syntax you are most comfortable with. Just remember that, all things being considered, the custom tag method is safer to your calling document. On Tue, 30 Nov 2004 18:22:37 +, Simon Horwith [EMAIL PROTECTED] wrote: Not that it's a huge deal, but don't forget that cfmodule also requires a single file compilatation as opossed to two file compilations, as well ;) ~Simon Simon Horwith Chief Information Officer, AboutWeb http://www.aboutweb.com Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com Katz, Dov B (IT) wrote: CFModule encapsulates the layout nicer than 2 isolated CFINCLUDES... You have a single layout.cfm which detects if #thistag.executionmode# is start and shows the header or footer. It makes for an easier read if the module is CF_TAGNAME'd.. Example... You have layout.cfm, so you can do this: CF_LAYOUT my page /CF_LAYOUT That's more elegant than cfinclude header, cfinclude footer, and allows you to pass in custom arguments since it's using cfmodule under the covers. That's my take on things -dov -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:46 PM To: CF-Talk Subject: CFMODULE vs. CFINCLUDE I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece bought up an old question I had. Is there any performance difference between a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout? In the first case, your code is: cfmodule template=layout.cfm Display stuff /cfmodule In the second case you have: CFINCLUDE template=header Display Stuff CFINCLUDE template=footer Because of the nature of the CFMODULE, it's called twice and various variables are created in its process. The CFINCLUDE method uses 2 CFINCLUDES, but there's nothing special about them. No extra variables, etc. Logic says that the CFINCLUDE method of template layout is more efficient, but I'd like to know what others think? I'll ask the question about what people think of the pagecontext include vs. cfinclude another time. :) ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185715 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: Best Practice: Import Delimited List to Database
Depends on the database and the source ;-) SQL Server...use DTS (data transformation service) to import the list (CSV file...Excel file...other DB) Any tab or comma delimited file should be super easy to parse and insert into the DB...client could upload file and that would fire off the process Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185716 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: Best Practice: Import Delimited List to Database
You could: Use a DTS package for the import. Treat the file like a cf datasource using the txt driver. Read the file using cf_file and step through each record tucking it into the db. I'd want a little more detail on what database, how long the list is and how often this happens before deciding. Jerry Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 11/30/04 01:54PM Client is looking for an application to import a delimited list of names and email addresses directly into a database for further manipulation. While I can think of a number of ways to pull this off, what's the opinion on the most efficient way to doing it? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185718 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: Best Practice: Import Delimited List to Database
SQL Server...use DTS (data transformation service) to import the list (CSV file...Excel file...other DB) This will have to be done from an administration form from a web page. The client isn't going to have access to the SQL Admin, nor do we want him too!! -- Les Mizzell ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185717 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: Best Practice: Import Delimited List to Database
Do they want you to build a web-based app or could they access the DB server directly? MS SQL Server has built-in capabilities for this with the import wizard. I've done a web-based app to do this sort of thing as well and can lend some advice if that's what you're looking for. Just let me know. John Burns -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 1:55 PM To: CF-Talk Subject: Best Practice: Import Delimited List to Database Client is looking for an application to import a delimited list of names and email addresses directly into a database for further manipulation. While I can think of a number of ways to pull this off, what's the opinion on the most efficient way to doing it? Thanks, -- Les Mizzell ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185719 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: Best Practice: Import Delimited List to Database
What is the source of this list? If it's a file, what is the size. Raymond wrote a nice UDF wrapper for a java call that imports and loops over a file that works better than CFFILE/CFLOOP. I've used it (modified) to import a few hundred thousand line file into a DB. Once you have the data and parse it into 'chunks', it's just a CFQUERY tag to put it in. Bottom line is that more info is needed about where/what/where. Client is looking for an application to import a delimited list of names and email addresses directly into a database for further manipulation. While I can think of a number of ways to pull this off, what's the opinion on the most efficient way to doing it? Thanks, -- Les Mizzell ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185720 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: Best Practice: Import Delimited List to Database
At 02:01 PM 11/30/2004, Bryan Stevenson wrote: Depends on the database and the source ;-) And how often it needs to be done. Once? Once a day? And who is going to do it. SQL Programmer? Secretary? No one will be able to advise you on efficiency until you specify who you're trying to make it efficient for: -the computer? -the programmer? -the maintainer? -the network? -the user? -the disk? As usual, details get in the way of answering questions. ;) Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED]| | Home: 919.303.0218| | Off Road Rally Racing Team: http://LinaRacing.com/ | |Do you like Evite? This is better: http://RSVPtracker.com/ | +===+ ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185721 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: Best Practice: Import Delimited List to Database
Cold fusion can execute DTS packages from the server. A cfm page can gather the data, set up the database, then trigger the DTS package to run the import without the user even being aware of what is happening. Jerry Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 11/30/04 02:04PM SQL Server...use DTS (data transformation service) to import the list (CSV file...Excel file...other DB) This will have to be done from an administration form from a web page. The client isn't going to have access to the SQL Admin, nor do we want him too!! ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185722 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: Best Practice: Import Delimited List to Database
Yep...but you can fire DTS on the fly ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Les Mizzell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:04 AM Subject: Re: Best Practice: Import Delimited List to Database SQL Server...use DTS (data transformation service) to import the list (CSV file...Excel file...other DB) This will have to be done from an administration form from a web page. The client isn't going to have access to the SQL Admin, nor do we want him too!! -- Les Mizzell ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185723 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: Best Practice: Import Delimited List to Database
What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They would be saving their spreadsheets as CSV files then uploading them via a web form. -- Aaron Rouse http://www.happyhacker.com/ On Tue, 30 Nov 2004 14:08:46 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: What is the source of this list? If it's a file, what is the size. Raymond wrote a nice UDF wrapper for a java call that imports and loops over a file that works better than CFFILE/CFLOOP. I've used it (modified) to import a few hundred thousand line file into a DB. Once you have the data and parse it into 'chunks', it's just a CFQUERY tag to put it in. Bottom line is that more info is needed about where/what/where. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185724 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: Best Practice: Import Delimited List to Database
FileRead http://cflib.org/udf.cfm?ID=417 What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They would be saving their spreadsheets as CSV files then uploading them via a web form. -- Aaron Rouse http://www.happyhacker.com/ On Tue, 30 Nov 2004 14:08:46 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: What is the source of this list? If it's a file, what is the size. Raymond wrote a nice UDF wrapper for a java call that imports and loops over a file that works better than CFFILE/CFLOOP. I've used it (modified) to import a few hundred thousand line file into a DB. Once you have the data and parse it into 'chunks', it's just a CFQUERY tag to put it in. Bottom line is that more info is needed about where/what/where. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185726 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: Best Practice: Import Delimited List to Database
Ok, well, if you can GUARANTEE that the data will be in the proper order everytime than it's pretty easy. Obviously, you'll have to do some data-checking and stuff but if they're smart enough to give it in the correct format, that makes things much easier. In generic terms, what I've done is accept the input from the user (either allow them to upload a .txt file or give them a textarea to copy and paste the data into). Then you need to break your data apart into multiple lists. I make one list with the delimited of the line separators (chr(13) and chr(10)) which essentially breaks the data into rows. I loop over that list and break each element (row) into another list using my field delimiter (either a comma or whatever character you tell them to use). Note: This may be a problem if your data has any commas in it and you use commas as your delimiters. One easy thing you can do it check the number of list elements before you submit to the database and if it's not what you're expecting flag that as a bad row and move on. You could easily add some data integrity checks as well with UDFs to check that the email is correct, etc. Again, all of this depends on how smart your user is and how good the data is, so the more checks, the better, but you're still not guaranteed success. The only big downside that I've found to this method is that if it's a large amount of data, the user may get impatient and try re-submitting multiple times or something because the browser has to pass the info to the server (either file upload or form submission) then you're parsing out a lot of data as well and doing lots of queries (use CFQUERYPARAM) so it takes a while. For the second part, you can use CFFLUSH to try to push some kind of status to the users. Get creative and make a status bar that updates via javascript when a certain percentage of the records are done. I hope that makes sense and helps. John Burns -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 2:04 PM To: CF-Talk Subject: Re: Best Practice: Import Delimited List to Database SQL Server...use DTS (data transformation service) to import the list (CSV file...Excel file...other DB) This will have to be done from an administration form from a web page. The client isn't going to have access to the SQL Admin, nor do we want him too!! -- Les Mizzell ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185725 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: Best Practice: Import Delimited List to Database
If you're running SQL server check out BULK INSERT. Adam On Tue, 30 Nov 2004 13:12:57 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They would be saving their spreadsheets as CSV files then uploading them via a web form. -- Aaron Rouse http://www.happyhacker.com/ On Tue, 30 Nov 2004 14:08:46 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: What is the source of this list? If it's a file, what is the size. Raymond wrote a nice UDF wrapper for a java call that imports and loops over a file that works better than CFFILE/CFLOOP. I've used it (modified) to import a few hundred thousand line file into a DB. Once you have the data and parse it into 'chunks', it's just a CFQUERY tag to put it in. Bottom line is that more info is needed about where/what/where. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185727 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
jsessionid cookies
I am running CFMX on my development XP machine and have turned OFF Use j2ee session variables i.e. it is NOT checked but a session cookie called jsessionid is still written (twice!) everytime I enter the site from my browser. I have cleared out all cookies and can see it being written as I enter the site. I have 3 basic questions: 1. Is this possibly being used by CF to track the sessions (instead of the CFID/CFTOKEN pair) even though I have said not to? 2. How can I turn it off? 3. My hosting company says they cannot use j2ee session variables on a shared host since it would mess up those users relying on CF session variables. Is this true? If you know a place that clarifies this issue, please point me there. Nick ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185728 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: Best Practice: Import Delimited List to Database
I am using Oracle, was stated in my quoted msg you included. I could use SQLLDR, this import need is down low on the todo list so I have just randomly been looking into different avenues. -- Aaron Rouse http://www.happyhacker.com/ On Tue, 30 Nov 2004 14:19:04 -0500, Adam Haskell [EMAIL PROTECTED] wrote: If you're running SQL server check out BULK INSERT. Adam On Tue, 30 Nov 2004 13:12:57 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They would be saving their spreadsheets as CSV files then uploading them via a web form. -- Aaron Rouse http://www.happyhacker.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185729 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: Embedding Images in Excel
Well, since I can't view a binary file in a text editor (at least, not meaningfully so that I know of), all I can do is save it in some other format. Saving it as HTML doesn't help too much, because it ends up being the same (linking to an image). I may have to find some other way to do it. They want to be able to have saved files with the images, yet also be able to manipulate those files on their own. (PDF would take care of the first requirement, but not the first) Scott On Tue, 30 Nov 2004 13:50:20 -0500, Burns, John D [EMAIL PROTECTED] wrote: Try inserting a simple image into a blank excel sheet and then save it and open the excel sheet in a text editor. See what the actual code looks like and how they embed an image in there. John -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 1:15 PM To: CF-Talk Subject: Embedding Images in Excel We have a series of reports which include graphs (via cfchart in .jpg format). We provide the ability to export those reports to Excel. However, if a user saves that excel spreadsheet and opens it later (after CF has cleared the cache), the image has expired. Primarily, this is because, instead of embedding the actual images in the file, it treats it like an img tag and pulls the image from the server each time. But, because CF no longer has that image connection, the chart no longer shows up. In the livedocs, I've seen one work-around that would fix this, where you bascially copy the chart to a new location, so it's not part of the charting cache. But, that would require storing those images, which can quickly eat up space. What I'd like to do, if possible, is actually embed the image inside the Excel file (rather than there just being a link to the image). Is there a way to do that with CF? Some details on our system: 1) 2 load-balanced servers with automatic replication [yes, sticky sessions are on, so it shouldn't be an issue of it looking at the wrong server -- actually, it can be an issue, because when they re-open the file, they may be sent to the other server. But, it's essentially the same as CF clearing its charting cache] 2) CFMX 6.1 on Win2k3. Thanks in advance! Scott -- - Scott Brady http://www.scottbrady.net/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185730 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: Incremental CFCONTENT?
It wouldn't register in the log. It's not an http call. Thanks to all. This is great, and works well. I keep forgetting that cfmx now has jsp/servlet support. Not quite sure if it improves performance all that much, but it makes me feel comfortable that I'm not needlessly CFFILE-reading cached sections of pages into memory before dumping them to the output stream. BTW - do you happen to know whether this books a new http request in IIS web server logs? (not that it is so important, just curious). Thanks again, -dov -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, November 29, 2004 5:57 PM To: CF-Talk Subject: Re: Incremental CFCONTENT? It won't try to compile the file if there is no server mapping to the .txt extension. extension? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185731 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
Clustercat replacement?
Mothernature.com has a cluster using open director and cluster cats. Cluster cats is buggy for us and we'd like to replace it. Is there a good replacement for it? Can MX talk directly to open director? Can MX gather IIS status info? We're just looking for options. Thanks ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185732 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: Anyone see this error before?
I've been getting it about once a week. The problem I have is that the logs don't tell me what caused it. Just that it happened. On Tue, 30 Nov 2004 10:37:58 -0600, Greg Landers [EMAIL PROTECTED] wrote: I have seen it thrown on a CFFILE action upload ... ended up being an incorrect destination path being plugged into the tag. Greg Landers -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 10:33 AM To: CF-Talk Subject: Anyone see this error before? I got this out of the blue on CFMX 6.1 unable to create new native thread If you know what would cause it, could you explain it to me? -- Phillip B. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185733 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: Best Practice: Import Delimited List to Database
Sorry quoted the wrong person was directed toward Les. Your post was the last post and I hit reply, case of me being lazy :) Adam On Tue, 30 Nov 2004 13:31:40 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: I am using Oracle, was stated in my quoted msg you included. I could use SQLLDR, this import need is down low on the todo list so I have just randomly been looking into different avenues. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185734 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: jsessionid cookies
CFMX doesn't set the jsessionid cookie itself, it's set by the J2EE application server. Setting CMFX to use J2EE session management means CFMX session variables are stored in the J2EE HTTP session object (and can thus be accessed through Java calls). Setting CFMX for J2EE session management on a shared host would require some coordination, but seems feasible. best, Chris Norloff http://www.macromedia.com/support/coldfusion/ts/documents/tn18232.htm -- Original Message -- From: Nick Cabell [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 11:26:20 -0800 I am running CFMX on my development XP machine and have turned OFF Use j2ee session variables i.e. it is NOT checked but a session cookie called jsessionid is still written (twice!) everytime I enter the site from my browser. I have cleared out all cookies and can see it being written as I enter the site. I have 3 basic questions: 1. Is this possibly being used by CF to track the sessions (instead of the CFID/CFTOKEN pair) even though I have said not to? 2. How can I turn it off? 3. My hosting company says they cannot use j2ee session variables on a shared host since it would mess up those users relying on CF session variables. Is this true? If you know a place that clarifies this issue, please point me there. Nick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185735 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