Re: Code reuse ideas?
My favourite line from that doc: Do not use client scope. I'm glad I'm not alone in avoiding it completely... On 12/2/05, Dawson, Michael [EMAIL PROTECTED] wrote: We are working on a new intranet that will locate the CFCs, custom tags and includes, outside the web root just for this purpose. MACR's best-practice document shows a common directory structure that is the base of our directory structure: http://livedocs.macromedia.com/wtg/public/coding_standards/structure.htm l -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225904 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: cfgrid flash form question
Hi Nick, I haven't tested it yet but it should work this way: cfformitem type=script function check_batch_state() { if(batchType.dataProvider[batchType.selectedIndex]['Adjustment_Batch_Type']= 'IND') { myButton.enabled = false; // if that bellow don't work try this _root.myButton.enabled = false; } } /cfformitem BTW: If you want to know more about the methods or properties of the elements, take a look into the Flex ActionScript and MXML API Reference http://livedocs.macromedia.com/flex/15/asdocs_en/asdoc-title.html Cheers, Artur -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 12:10 AM To: CF-Talk Subject: cfgrid flash form question Hi All, I am using a cfgrid flash type. cfgrid name=batchType height=200 width=410 vspace=10 selectmode=edit query=GetAdjustmentBatchTypes insert=Yes insertbutton=Add New Type delete=yes onchange=check_batch_state() cfformitem type=script function check_batch_state(){ if(batchType.dataProvider[batchType.selectedIndex]['Adjustment_Batch_Typ e']='IND'){ I NEED TO DISABLE THE DELETE BUTTON IF THIS ROW IS SELECTED } } /cfformitem I want to be able to disable the 'delete' button via script, if the user selects a certain row. Any idea how I can reference the delete button since it is auto generated by cfgrid when you set 'delete=yes'? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225905 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
JRUN4 and logging
Hello, I changed the default location of the log files, so went to jrun.xml to change the filename attribute as follows: F:/logs/CF/{jrun.server.name}-{log.level}-event.log (this also splits the log files for each type of event). This works as expected, BUT I still have the server writing default-err.log and default-out.log in C:\CFusionMX\runtime\logs ... Duplicate entries, as they are a collection of each of the entries of each separate log file I configured ... I then noticed that the registry has also 2 keys defined for log file location of the CF server service: SystemErr and SystemOut. This is probably what I need to deal with, but didn't find much info about it. Does anybody know how to deal with this kind of eccentricity? Delete the keys? Null them? (We are running CFMX 6.1, Entreprise, non J2EE deployment) Thanks, Albert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225906 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: Free SSl certs was: Re: Authorize.net request
You can also just generate a cert yourself for testing anyway - I use OpenSSL- works a treat. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 30 November 2005 22:29 To: CF-Talk Subject: Free SSl certs was: Re: Authorize.net request Bryan, when I click join at CACert, I get a possible bogus certificate warning from Firefox. Is this something all CAcert users are going to have to subject their users too, or is it just the way that CAcert setup their site? I noticed that Firefox complained about *.cacert.org, maybe if you actually tie it to a FQDN (www.cacert.org instead of *.cacert.org) you won't see the warning. Have you tried their certificates? I haven't used 'em yet...only recently heard about them myself...so here's the loose tidbits I've heard: Folks like Verisign have a deal with browser makers to check the maker of the cert before showing that warningif they find that the maker is say Verisign that warning does not show. This is why certs cost so much for something that is pretty basic. This is something that the CACert folks have been trying to get around and I think they have...but with NS and IE..perhaps not Firefox yet So some users may get that warning...others may notbut hey...if they do they'll know your site is secure ;-) You're probably better off reading their news or forums than listening to my ramblings...but hopefully that's enough info to find reality ;-) 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225907 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
anybody ever use cftable?
Other than dave, has anybody EVER used the cftable tag?? Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225908 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: Humor for the day
rofl Bobby, soo true! -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: 01 December 2005 18:32 To: CF-Talk Subject: OT: Humor for the day http://www.scaryideas.com/project.jpg ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225909 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: anybody ever use cftable?
On occasion, although I usually end up finding some reason to change my mind and use the more traditional HTML tables instead. Matt Osbun On 12/2/05, Will Tomlinson [EMAIL PROTECTED] wrote: Other than dave, has anybody EVER used the cftable tag?? Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225910 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: anybody ever use cftable?
I have before for some quick jobs to just throw some quick data around, but I definitely don't make a habit out of it. On 12/2/05, Will Tomlinson [EMAIL PROTECTED] wrote: Other than dave, has anybody EVER used the cftable tag?? Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225911 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
Getting a bunch of recv failed and JRunRequest.reencode exceptions
Any idea how to avoid this error? Not sure whether it matters, but its filling my logs.. The post error I get occasionally, the recv failed error I show in my logs about 2-5 per minute... The server handles about 1 million requests a day Also, any way to make the default-out and default-err.logs rotate like the rest of then I have CFMX 6.1 Professional 12/02 03:09:38 warning Error while parsing POST data java.lang.IllegalArgumentException: ISO-8859-8-I at jrun.servlet.JRunRequest.reencode(JRunRequest.java:434) at jrun.servlet.JRunRequest.parsePostData(JRunRequest.java:419) at jrun.servlet.JRunRequest.getParameters(JRunRequest.java:383) at jrun.servlet.JRunRequest.getInputStream(JRunRequest.java:261) at javax.servlet.ServletRequestWrapper.getInputStream(ServletRequestWrapper.java:191) at coldfusion.filter.FusionContext.getRequestContent(FusionContext.java:553) at coldfusion.filter.FormScope.fillForm(FormScope.java:193) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:345) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) The other type: 12/02 07:57:03 error Software caused connection abort: recv failed java.net.SocketException: Software caused connection abort: recv failed at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) at java.io.BufferedInputStream.read1(BufferedInputStream.java:222) at java.io.BufferedInputStream.read(BufferedInputStream.java:277) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:533) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:525) at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:543) at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:232) at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:144) at jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:433) at jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(ThreadPool.java:280) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:76) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225912 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: anybody ever use cftable?
I didn't even know there was a CFTable tag :) But in all fairness, I have only been coding ColdFusion for like 6 years. BEGIN MINI RANT: While we are on the topic of things that coldfusion has built in to make things easier, I want to mention CFForm. People who like this tend to get all cranky about how hard forms are to make and how much time they take. Now, maybe I don't make the world's most awesome programs, but am I the only one who thinks that building a form, even a rather large one, is no big whoop? ... Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com Vote for Pedro ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225913 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: anybody ever use cftable?
Try doing a large Flash CFFORM. Pain in the butt. Maybe the new Flex Builder 2 features can be ported to DW8? Peter Tilbrook ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Phone: (02) 6284 2727 Mobile: 0432 897 437 Email: [EMAIL PROTECTED] WWW: http://www.coldgen.com/ http://www.actcfug.com -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Friday, 2 December 2005 11:30 PM To: CF-Talk Subject: RE: anybody ever use cftable? I didn't even know there was a CFTable tag :) But in all fairness, I have only been coding ColdFusion for like 6 years. BEGIN MINI RANT: While we are on the topic of things that coldfusion has built in to make things easier, I want to mention CFForm. People who like this tend to get all cranky about how hard forms are to make and how much time they take. Now, maybe I don't make the world's most awesome programs, but am I the only one who thinks that building a form, even a rather large one, is no big whoop? Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com Vote for Pedro ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225914 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: CFC style question (for UI CFCs)
Continuing this thread here... I like consistency too, and that's why I like to think of these as UI CFCs, and not just CFCs. I have business logic CFCs too, and they will never return output directly. (I name them differently and put them in a different location.) Custom tags are just too lame to force all shared UI-related stuff to be implemented with them I started avoiding cfinvoke in favor or this style of calling: cfoutput#variables.thingFormatter.outputTable(option1=x, option2=y)#/cfoutput because you can't tell if the method will output directly or return a string, but either way, it works. (I also like that you don't have to use quoted/pounds around the arguments... option1=x above is nicer looking to me than option1=#x#.) Q: Is there no way to have a string returned by a cfinvoked method automatically output? Do you really have to use returnVariable? Seems like that would be a nice shortcut to have... Thanks Mark -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 01, 2005 4:47 PM To: CF-Talk Subject: Re: CFC style question (for UI CFCs) As I often say, I like doing what fits the specific project best. Consitency is more important to me. If I'm going to avoid output from cfc's in a project, I'll avoid it consistently... --Ferg Will Tomlinson wrote: I like outputting directly myself. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225915 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: anybody ever use cftable?
Building a form is a piece of cake... -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 13:30 To: CF-Talk Subject: RE: anybody ever use cftable? I didn't even know there was a CFTable tag :) But in all fairness, I have only been coding ColdFusion for like 6 years. BEGIN MINI RANT: While we are on the topic of things that coldfusion has built in to make things easier, I want to mention CFForm. People who like this tend to get all cranky about how hard forms are to make and how much time they take. Now, maybe I don't make the world's most awesome programs, but am I the only one who thinks that building a form, even a rather large one, is no big whoop? ... Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com Vote for Pedro ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225916 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
interacting with java and return a ColdFusion query
All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm#1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225917 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: interacting with java and return a ColdFusion query
I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225918 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: interacting with java and return a ColdFusion query
Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225919 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: Small CF Job - What the heck *is* emo, anyway?
On Nov 30, 2005, at 11:29 AM, Jennifer Gavin-Wear wrote: lol .. small furry muppet .. I'd never heard of it either :-/ Ditto. Seems to be essentially a competitor for paypal from what I read on the website. Nice to see paypal hasn't completely squashed any competition. (Because they could definitely use someone to light a fire under them in terms of professionalism.) --min it happens to be https://www.emocorp.com/ A merchant account thingy whatsit. The job is to make some (very) minor web site changes and then integrate with EMO for on line payment. The client is offering $200, but might pay a little more. I'm not looking for anything out of it. It doesn't look very complicated but I'm up to my eyeballs in other stuff. Any takers? Jenny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225920 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: interacting with java and return a ColdFusion query
So you can use #queryNew()# function within CF pages to produce the query result. -Dov -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:27 AM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java 2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225921 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: CFXML issue
Hi Ken. From the addSOAPRequestHeader doco... If you pass XML in the value parameter, ColdFusion ignores the namespace and name parameters. If you require a namespace, define it within the XML itself. So you'll need to do it like this (chuck your ID in there); cfxml variable=authHeader tns:AuthenticationHeader xmlns:tns=http://skats.net/services/; SessionID12345/SessionID /tns:AuthenticationHeader /cfxml cfscript vinService = CreateObject(webservice,http://www.codebump.com/services/zipcodelookup.as mx?wsdl); addSOAPRequestHeader(vinService,http://this.is/ignored/,IgnoredName;, authHeader, true); returnStruct = vinService.GetDistanceBetweenZipCodes(zip1 = 91709,zip2 = 90034); /cfscript When running it you'll see Subscription ID is empty in the soap fault only if you do not add the soap header or include the SessionID element. I hope this helps... when you get your CF7 server hehehe. Cheers. -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Friday, 2 December 2005 6:16 AM To: CF-Talk Subject: Re: CFXML issue Hi Ade. Actually no. I am trying to create this to pass it as a header for a soap request. My complete code looks like this: cfprocessingdirective suppresswhitespace=Yes cfcontent type=text/xml; charset=utf-16 cfxml variable=creds tns:AuthenticationHeader id=h_id1 SessionID xsi:type=xsd:stringX/SessionID /tns:AuthenticationHeader /cfxml /cfprocessingdirective cfscript vinService = CreateObject(webservice, http://www.codebump.com/services/zipcodelookup.asmx?wsdl;); addSOAPRequestHeader(vinService,http://skats.net/services/;, AuthenticationHeader, creds, FALSE); returnStruct = vinService.GetDistanceBetweenZipCodes(zip1 = 91709,zip2 = 90034); /cfscript cfdump var=#returnStruct# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225922 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: interacting with java and return a ColdFusion query
Well, I still think you can use cfquery to get at the cotent. On one of the DRK's there was a CF_Lucene tag set which did quite a lot with CF and Lucene. There are also numerous other sites which mention Lucene and ColdFusion working in tandem One is Aarons (albeit old!) http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_cold fusion.html HTH -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:27 To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225923 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: interacting with java and return a ColdFusion query
Hmm, I am not sure I get what you mean. Sorry for my dullness! Lucene returns search results in the form of a list like so: http://lucene.apache.org/java/docs/api/org/apache/lucene/search/Hits.html. Do I then take that list and transform it into a Query? How do I do that? Thanks, George On 12/2/05, Katz, Dov B (IT) [EMAIL PROTECTED] wrote: So you can use #queryNew()# function within CF pages to produce the query result. -Dov -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:27 AM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java 2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225924 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: interacting with java and return a ColdFusion query
Oh yeah, I am familiar with Aaron's tag. That was the basis of the CFX tag that I had written. Is the CF_Lucene tag available somewhere? I don't have access to the DRK. George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Well, I still think you can use cfquery to get at the cotent. On one of the DRK's there was a CF_Lucene tag set which did quite a lot with CF and Lucene. There are also numerous other sites which mention Lucene and ColdFusion working in tandem One is Aarons (albeit old!) http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_cold fusion.html HTH -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:27 To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225925 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
remove
remove ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225926 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
MissingIncludeHandler property of runtime not working?
To enforce a lot of settings in our application, we set them on startup in the code. One property I was trying to add to our setup was the MissingIncludeHandler property of the setRuntimeProperty() method. Doesn't seem to work. Also can't seem to find any reference to it when I Google. Anyone else run across this problem before and found a way around it? Try this code in your CFMX app to see what happens. cfscript admin = createobject(component, CFIDE.adminapi.administrator); admin.login({your CFAdmin password}); runtime = createobject(component, CFIDE.adminapi.runtime); runtime.setRuntimeProperty(MissingIncludeHandler, /any/page/in/your/app.cfm); mihFile = runtime.getRuntimeProperty(MissingIncludeHandler); /cfscript cfoutput#mihFile#/cfoutput ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225927 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: interacting with java and return a ColdFusion query
cfscript myQuery=QueryNew(Doc,ID,Score); // QueryAddRow(myQuery,LuceneResults.size()) // Loop over that list, and call QuerySetCell(Key, Value, RowNumberStartingFrom1) /cfscript -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:47 AM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hmm, I am not sure I get what you mean. Sorry for my dullness! Lucene returns search results in the form of a list like so: http://lucene.apache.org/java/docs/api/org/apache/lucene/search/Hits.htm l. Do I then take that list and transform it into a Query? How do I do that? Thanks, George On 12/2/05, Katz, Dov B (IT) [EMAIL PROTECTED] wrote: So you can use #queryNew()# function within CF pages to produce the query result. -Dov -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:27 AM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Ja va 2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225928 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: cfform (formerly 'anybody ever use cftable?')
While we are on the topic of things that coldfusion has built in to make things easier, I want to mention CFForm. People who like this tend to get all cranky about how hard forms are to make and how much time they take. Now, maybe I don't make the world's most awesome programs, but am I the only one who thinks that building a form, even a rather large one, is no big whoop? I don't know about forms being easier with cfform, except for the validation. I LOVE using cfform's validation options. Much easier than building a bunch of JS by hand. And yes, I do server side validation as well, but as long as the user has JS enabled in their browser, client side validation is a nice user friendly feature in web forms. And client side validation with cfform/cfinput/cfselect/etc. ROCKS! - This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225929 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: remove
remove yourself. look at the bottom of every email you get for the link. Noah Mudge wrote: remove ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225930 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: interacting with java and return a ColdFusion query
I second that. I am doing the same thing in cfQuickDocs to build a query object from XML. Except I'm not using cfscript, but the idea is the same. :) -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 7:58 AM To: CF-Talk Subject: RE: interacting with java and return a ColdFusion query cfscript myQuery=QueryNew(Doc,ID,Score); // QueryAddRow(myQuery,LuceneResults.size()) // Loop over that list, and call QuerySetCell(Key, Value, RowNumberStartingFrom1) /cfscript - [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225931 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: interacting with java and return a ColdFusion query
Yowdy, I don't think the cfx package provides a query class that you can create in java and return to CF without using the cfx processRequest/response stuff. Instead how about returning a Java array of objects or structures? They can fit the bill sometimes. Here's the list of the conversions; http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/ wwhelp.htm?href=0379.htm Also this might help, I haven't tried to create these classes; http://www.activsoftware.com/mx/undocumentation/query.cfm Cheers, AS -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Saturday, 3 December 2005 1:48 AM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Oh yeah, I am familiar with Aaron's tag. That was the basis of the CFX tag that I had written. Is the CF_Lucene tag available somewhere? I don't have access to the DRK. George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Well, I still think you can use cfquery to get at the cotent. On one of the DRK's there was a CF_Lucene tag set which did quite a lot with CF and Lucene. There are also numerous other sites which mention Lucene and ColdFusion working in tandem One is Aarons (albeit old!) http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_cold fusion.html HTH -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:27 To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225932 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
cfquery results attribute execution time question
Hey guys, Would those of you that are using my qbrowser on cf 7 check something out for me? When you execute a query using the qbrowser on cf 7, it takes the results attribute and then uses it to display the execution time of the query when it shows the results. But if you turn on debugging, the time that is reported by the results attribute is not the same as the time value in the sql queries section of the debugging. Oftentimes the debug shows a time that is much faster (less ms) than the results attribute reports, but it generally seems like the results attribute is more accurate, although I really have no idea which to believe. My questions I guess are this: Does anyone else see this same thing? Why are the times different? I would figure that the two should actually be comming from the same code, but apparently not. Which one is accurate, or more accurate, and why is the other not accurate? Is there a way to get execution time that the debugging template reports? -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225933 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: interacting with java and return a ColdFusion query
Yowdy, I don't think the cfx package provides a query class that you can create in java and return to CF without using the cfx processRequest/response stuff. Instead how about returning a Java array of objects or structures? They can fit the bill sometimes. Here's the list of the conversions; http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/ wwhelp.htm?href=0379.htm Also this might help, I haven't tried to create these classes; http://www.activsoftware.com/mx/undocumentation/query.cfm Cheers, AS -Original Message- -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225934 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: Small CF Job - What the heck *is* emo, anyway?
On 12/2/05, Lewis Sellers [EMAIL PROTECTED] wrote: On Nov 30, 2005, at 11:29 AM, Jennifer Gavin-Wear wrote: lol .. small furry muppet .. I'd never heard of it either :-/ Ditto. Seems to be essentially a competitor for paypal from what I read on the website. Nice to see paypal hasn't completely squashed any competition. (Because they could definitely use someone to light a fire under them in terms of professionalism.) Yeah, well with the acquisition of Verisign's online payment division (PayFlow, PayFlow Pro), that should just about squash any lasting competitors!! Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225935 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: Using NT user database with CF
On Dec 1, 2005, at 5:26 PM, Matt Robertson wrote: Anyone know of a way that CF can hook into win2k/NT/2k3 user accounts? In other words, someone logs onto Windows when they fire up their desktop and this info is also used to authenticate their CF-based intranet session. What Ian said. Also, see http://www.intrafoundation.com/intrafoundation/products.php? ProductCode=IHTK for some older CFX tools to manage IIS and NT user accounts if that need comes up (with full source). --min -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225936 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: Using NT user database with CF
What happened to your Lewis?! -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 15:27 To: CF-Talk Subject: Re: Using NT user database with CF On Dec 1, 2005, at 5:26 PM, Matt Robertson wrote: Anyone know of a way that CF can hook into win2k/NT/2k3 user accounts? In other words, someone logs onto Windows when they fire up their desktop and this info is also used to authenticate their CF-based intranet session. What Ian said. Also, see http://www.intrafoundation.com/intrafoundation/products.php? ProductCode=IHTK for some older CFX tools to manage IIS and NT user accounts if that need comes up (with full source). --min -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225937 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: anybody ever use cftable?
Maybe all we need is some nice XSLT to convert forms from FlexBuilder to CF ignore what you cant convert and just put what you can? Anyone up for the challenge?! MD On 02/12/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Building a form is a piece of cake... -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 13:30 To: CF-Talk Subject: RE: anybody ever use cftable? I didn't even know there was a CFTable tag :) But in all fairness, I have only been coding ColdFusion for like 6 years. BEGIN MINI RANT: While we are on the topic of things that coldfusion has built in to make things easier, I want to mention CFForm. People who like this tend to get all cranky about how hard forms are to make and how much time they take. Now, maybe I don't make the world's most awesome programs, but am I the only one who thinks that building a form, even a rather large one, is no big whoop? ... Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com Vote for Pedro ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225938 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: JRUN4 and logging
these two logs are always there and can't be turned off AFAIK. Certainly they can't be rotated like the others, a PITA. DK On 12/2/05, Beru [EMAIL PROTECTED] wrote: Hello, I changed the default location of the log files, so went to jrun.xml to change the filename attribute as follows: F:/logs/CF/{jrun.server.name}-{log.level}-event.log (this also splits the log files for each type of event). This works as expected, BUT I still have the server writing default-err.log and default-out.log in C:\CFusionMX\runtime\logs ... Duplicate entries, as they are a collection of each of the entries of each separate log file I configured ... I then noticed that the registry has also 2 keys defined for log file location of the CF server service: SystemErr and SystemOut. This is probably what I need to deal with, but didn't find much info about it. Does anybody know how to deal with this kind of eccentricity? Delete the keys? Null them? (We are running CFMX 6.1, Entreprise, non J2EE deployment) Thanks, Albert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225939 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: cfform (formerly 'anybody ever use cftable?')
I never cared for cfforms. I'd much rather roll my own JS validation and replace things like Javascripts annoying alert() function with something a little more tasteful. Cfform won't do that. It won't highlight fields in question. It won't auto focus to fields in question. It won't validate fields 'on the fly'... (Say when you focus off the field or something) And it usually doesnt play nice with other javascript that might already exist in the page. :) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:58 AM To: CF-Talk Subject: RE: cfform (formerly 'anybody ever use cftable?') While we are on the topic of things that coldfusion has built in to make things easier, I want to mention CFForm. People who like this tend to get all cranky about how hard forms are to make and how much time they take. Now, maybe I don't make the world's most awesome programs, but am I the only one who thinks that building a form, even a rather large one, is no big whoop? I don't know about forms being easier with cfform, except for the validation. I LOVE using cfform's validation options. Much easier than building a bunch of JS by hand. And yes, I do server side validation as well, but as long as the user has JS enabled in their browser, client side validation is a nice user friendly feature in web forms. And client side validation with cfform/cfinput/cfselect/etc. ROCKS! - This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225940 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: Keeping a session alive
Bobby, 1) I absolutely REFUSE to use a frame or Iframe whatsoever. Then you like making life hard. ;) While an frame would be the most compatible, and IFRAME should really work in every modern browser (doesn't work in Netscape 4, but if you need that you could use an ILAYER tag for NS4.) Seriously, an IFRAME would be the best way to go. 2) It wouldn't allow for seamlessly 'alerting' the user about a session that I might not be able to 'reset' and keep alive. Sure it would. Just have the IFRAME refresh itself: -- keepyoursessionalive.cfm -- cfset iRefreshInSeconds = 600 / html head meta http-equiv=refresh content=cfoutput#iRefreshInSeconds#/cfoutput / cfif structKeyExists(session, someSessionVarThatShouldExist) script type=text/javascript alert(Your session has expired.); /script /cfif /head body/body /html 3) too easy. Lol While I can probably hammer in a nail using my PSP, I'd prefer using a hammer. I know the hammer will work. The PSP will probably work, but I'm just as likely to break my PS as I am to hammer in the nail. - Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225941 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: Keeping a session alive
If you want to refresh, you can also use an image Make image.cfm. img name='session' src=image.cfm cfcontent type=image/gif file=some1PixelGIF Add CFHEADER for expires so it always goes back to the server Then you can make a JS in your page, which does this: // every 10 minutes setInterval(document.images['session'].src='image.cfm';,600); This will keep the session alive... -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:03 AM To: CF-Talk Subject: RE: Keeping a session alive Bobby, 1) I absolutely REFUSE to use a frame or Iframe whatsoever. Then you like making life hard. ;) While an frame would be the most compatible, and IFRAME should really work in every modern browser (doesn't work in Netscape 4, but if you need that you could use an ILAYER tag for NS4.) Seriously, an IFRAME would be the best way to go. 2) It wouldn't allow for seamlessly 'alerting' the user about a session that I might not be able to 'reset' and keep alive. Sure it would. Just have the IFRAME refresh itself: -- keepyoursessionalive.cfm -- cfset iRefreshInSeconds = 600 / html head meta http-equiv=refresh content=cfoutput#iRefreshInSeconds#/cfoutput / cfif structKeyExists(session, someSessionVarThatShouldExist) script type=text/javascript alert(Your session has expired.); /script /cfif /head body/body /html 3) too easy. Lol While I can probably hammer in a nail using my PSP, I'd prefer using a hammer. I know the hammer will work. The PSP will probably work, but I'm just as likely to break my PS as I am to hammer in the nail. - Dan ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225942 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: Keeping a session alive
Hey, thats pretty nifty there thanks. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:08 AM To: CF-Talk Subject: RE: Keeping a session alive If you want to refresh, you can also use an image Make image.cfm. img name='session' src=image.cfm cfcontent type=image/gif file=some1PixelGIF Add CFHEADER for expires so it always goes back to the server Then you can make a JS in your page, which does this: // every 10 minutes setInterval(document.images['session'].src='image.cfm';,600); This will keep the session alive... -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:03 AM To: CF-Talk Subject: RE: Keeping a session alive Bobby, 1) I absolutely REFUSE to use a frame or Iframe whatsoever. Then you like making life hard. ;) While an frame would be the most compatible, and IFRAME should really work in every modern browser (doesn't work in Netscape 4, but if you need that you could use an ILAYER tag for NS4.) Seriously, an IFRAME would be the best way to go. 2) It wouldn't allow for seamlessly 'alerting' the user about a session that I might not be able to 'reset' and keep alive. Sure it would. Just have the IFRAME refresh itself: -- keepyoursessionalive.cfm -- cfset iRefreshInSeconds = 600 / html head meta http-equiv=refresh content=cfoutput#iRefreshInSeconds#/cfoutput / cfif structKeyExists(session, someSessionVarThatShouldExist) script type=text/javascript alert(Your session has expired.); /script /cfif /head body/body /html 3) too easy. Lol While I can probably hammer in a nail using my PSP, I'd prefer using a hammer. I know the hammer will work. The PSP will probably work, but I'm just as likely to break my PS as I am to hammer in the nail. - Dan ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225943 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: Keeping a session alive
Just out of curiosity... can a frame trigger a js event in another frame? Just curious since I still refuse to use one :) Thats the second time someone has mentioned 'harder' or 'more trouble'. Come on people... it's not brick work... it's programming. Nothing about it is 'hard' or 'troubling' Nice PSP analogy though ;) I've got a nice method with httprequest on a timed trigger now. It works great. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:03 AM To: CF-Talk Subject: RE: Keeping a session alive Bobby, 1) I absolutely REFUSE to use a frame or Iframe whatsoever. Then you like making life hard. ;) While an frame would be the most compatible, and IFRAME should really work in every modern browser (doesn't work in Netscape 4, but if you need that you could use an ILAYER tag for NS4.) Seriously, an IFRAME would be the best way to go. 2) It wouldn't allow for seamlessly 'alerting' the user about a session that I might not be able to 'reset' and keep alive. Sure it would. Just have the IFRAME refresh itself: -- keepyoursessionalive.cfm -- cfset iRefreshInSeconds = 600 / html head meta http-equiv=refresh content=cfoutput#iRefreshInSeconds#/cfoutput / cfif structKeyExists(session, someSessionVarThatShouldExist) script type=text/javascript alert(Your session has expired.); /script /cfif /head body/body /html 3) too easy. Lol While I can probably hammer in a nail using my PSP, I'd prefer using a hammer. I know the hammer will work. The PSP will probably work, but I'm just as likely to break my PS as I am to hammer in the nail. - Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225944 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: Using NT user database with CF
I use the same model that Ian does. I then maintain a database within the website that assigns permissions based on the username. The database contains fields for the username, and one field for each directory on the website, with either a simple yes or no value in each field. So, if #username# does not have permissions for a given directory on my website, they are CFLOCATION'd to an access request page where they can request access to the directory in question. On my application.cfm page, I have the following: !--- Remove the domain name from the cgi.auth_user - CFSET VisitorName = #lcase(removeChars(cgi.auth_user, 1, 10))# !--- Determine the current directory - CFSET CurrentDirectory = #removeChars(CF_Template_Path, 1, 19)# CFSET CurrentDirectory = #spanexcluding(currentdirectory, \)# CFIF #CurrentDirectory# NEQ default.cfm !--- The user is not at the home page -- cfquery name=AccessRights datasource=Security dbtype=ODBC SELECT VisitorName FROM tblAccess WHERE VisitorName = '#VisitorName#' AND #CurrentDirectory# = Yes /cfquery CFIF #AccessRights.RecordCount# EQ 0 !--- No username with rights in this dir, send to Access Request Page--- cflocation url=http://#cgi.SERVER_NAME#/security/ARP.cfm; /CFIF /CFIF By placing the code in the application.cfm page, I defeat efforts of users to change the username by using the address line. So, something like this would not allow an end user to impresonate another user: http://website.com?visitorname=jblow; It may not be the fastest or most elegant solution, but it works like a charm for us, and satisfies the security police here at work. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225945 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: Keeping a session alive
1) I absolutely REFUSE to use a frame or Iframe whatsoever. You're right. Have a look at XMLHttpRequest in Javascript. You can call a CF template every 10 min or so, directly from a script, without having to reload any part of the page, no blink, no glass cursor, no nothing. The user will see nothing. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225946 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: Using NT user database with CF
Thanks guys. This is all very helpful. Sounds simple too. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225947 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: cfgrid flash form question
Nick, the best way is to use a cfinput type=button to delete the rows insted of the auto genereted del of the grid. This code also popup´s an confirmation alert to confirm the delete: cfsavecontent variable=actionDelete var batchType = batchType var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { var item = batchType.selectedItem; if(_global.backupDP != undefined) { for(var i = 0; i _global.backupDP.length; i++) { if(_global.backupDP[i] == item) { _global.backupDP.removeItemAt(i); } } } GridData.deleteRow(batchType); } } //set the font color and button labels of all alerts _global.styles.Alert.setStyle(color, 0xFF); mx.controls.Alert.cancelLabel = No!; mx.controls.Alert.yesLabel = Yes; //create the alert var qtexto = 'Tem certeza que deseja excluir o livro \n\n' + batchType.selectedItem.titulo.toUpperCase(); var myAlert = mx.controls.Alert.show(qtexto, Confirmação, mx.controls.Alert.YES | mx.controls.Alert.CANCEL, box1, myClickHandler); /cfsavecontent And the button would be something like this: cfinput type=button name=removesub value=Excluir onclick=#actionDelete# enabled={(batchType.selectedItem.id != undefined batchType.selectedItem.id != 'what you don´t want it to be')} / I used the batchType.selectedItem.id but I don´t know the columns of your grid so you may have to change the 'id' for some existing row. If you want the code to do the insert button just ask. Felipe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225948 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
MX7 CFHTTP : connection failure with Proxy
Hi, I have a problem with CFHTTP when used with a proxy. It gives time out / connection failure. The dump of the cfhttp is : -- struct Charset= [empty string] ErrorDetail= Connect Exception: Connection timed out: connect Filecontent= Connection Failure Header= [undefined struct element] Mimetype= Unable to determine MIME type of file. Responseheader= struct [empty] Statuscode= Connection Failure. Status code unavailable. Text= YES --- What I try to do is to execute a CGI, a perl file, to query some files, if they exist, the perl file will send it back to the client via http. The files are encoded and package within a XML tag. Basically, the network is : Client- ColdFusion MX7 --- Proxy -- CGI Server The code I used to test this is : --begin code 1--- CFHTTP METHOD=POST URL=http://myproxy/cgi-bin/mro/perlFile.pl; result=strXMLFile cfhttpparam name=strOutputTo type=formfield value=Screen cfhttpparam name=strCurrentUrl type=formfield value=http://cfmServer/cfmFile.cfm; cfhttpparam name=strMasterDwgtype=formfield value=123445 cfhttpparam name=strMasterRevtype=formfield value=D cfhttpparam name=strDwgInRev type=formfield value=REVISION cfhttpparam name=strToolNumbers type=formfield value=123445 cfhttpparam name=strDwgServertype=formfield value=wwt cfhttpparam name=strOverlay type=formfield value=FALSE /CFHTTP cfdump var=#strXMLFile# hr / cfoutput File Content 1== #HTMLCodeFormat(strXMLFile.FileContent)# == /cfoutput --end code 1--- where - myproxy = the proxy - cfmserver = the MX7 server - cgiserver = server where reside the perl file I tried to use the CFHTTP attributes proxyserver and proxyport without succes. The code 2 is shown below: ---begin code 2-- CFHTTP METHOD=POST URL=http://cgiserver/cgi-bin/mro/perlFile.pl; result=strXMLFile proxyserver=myproxy proxyport= cfhttpparam name=strOutputTo type=formfield value=Screen cfhttpparam name=strCurrentUrl type=formfield value=http://cfmServer/cfmFile.cfm; cfhttpparam name=strMasterDwgtype=formfield value=123445 cfhttpparam name=strMasterRevtype=formfield value=D cfhttpparam name=strDwgInRev type=formfield value=REVISION cfhttpparam name=strToolNumbers type=formfield value=123445 cfhttpparam name=strDwgServertype=formfield value=wwt cfhttpparam name=strOverlay type=formfield value=FALSE /CFHTTP cfdump var=#strXMLFile# hr / cfoutput File Content 1== #HTMLCodeFormat(strXMLFile.FileContent)# == /cfoutput ---end code 2 The strange things is that when I call directly the CGIserver I got what I expected ie the files I requested I google and tried a lot of suggestions from people who got a similar problem of Connection failure but not necessesarely with a proxy. Things I tried for example: 1-http://www.talkingtree.com/blog/index.cfm/2004/7/28/20040729#more 2-http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=21241forumid=4 3-http://qaix.com/coldfusion/313-460-cfhttp-connection-failure-read.shtml Anyone have an idea ? I appreciate your help ! Thanks Waltereo ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225949 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
MX7 CFHTTP : connection failure with Proxy
Hi, I have a problem with CFHTTP when used with a proxy. It gives time out / connection failure. The dump of the cfhttp is : -- struct Charset= [empty string] ErrorDetail= Connect Exception: Connection timed out: connect Filecontent= Connection Failure Header= [undefined struct element] Mimetype= Unable to determine MIME type of file. Responseheader= struct [empty] Statuscode= Connection Failure. Status code unavailable. Text= YES --- What I try to do is to execute a CGI, a perl file, to query some files, if they exist, the perl file will send it back to the client via http. The files are encoded and package within a XML tag. Basically, the network is : Client- ColdFusion MX7 --- Proxy -- CGI Server The code I used to test this is : --begin code 1--- CFHTTP METHOD=POST URL=http://myproxy/cgi-bin/mro/perlFile.pl; result=strXMLFile cfhttpparam name=strOutputTo type=formfield value=Screen cfhttpparam name=strCurrentUrl type=formfield value=http://cfmServer/cfmFile.cfm; cfhttpparam name=strMasterDwgtype=formfield value=123445 cfhttpparam name=strMasterRevtype=formfield value=D cfhttpparam name=strDwgInRev type=formfield value=REVISION cfhttpparam name=strToolNumbers type=formfield value=123445 cfhttpparam name=strDwgServertype=formfield value=wwt cfhttpparam name=strOverlay type=formfield value=FALSE /CFHTTP cfdump var=#strXMLFile# hr / cfoutput File Content 1== #HTMLCodeFormat(strXMLFile.FileContent)# == /cfoutput --end code 1--- where - myproxy = the proxy - cfmserver = the MX7 server - cgiserver = server where reside the perl file I tried to use the CFHTTP attributes proxyserver and proxyport without succes. The code 2 is shown below: ---begin code 2-- CFHTTP METHOD=POST URL=http://cgiserver/cgi-bin/mro/perlFile.pl; result=strXMLFile proxyserver=myproxy proxyport= cfhttpparam name=strOutputTo type=formfield value=Screen cfhttpparam name=strCurrentUrl type=formfield value=http://cfmServer/cfmFile.cfm; cfhttpparam name=strMasterDwgtype=formfield value=123445 cfhttpparam name=strMasterRevtype=formfield value=D cfhttpparam name=strDwgInRev type=formfield value=REVISION cfhttpparam name=strToolNumbers type=formfield value=123445 cfhttpparam name=strDwgServertype=formfield value=wwt cfhttpparam name=strOverlay type=formfield value=FALSE /CFHTTP cfdump var=#strXMLFile# hr / cfoutput File Content 1== #HTMLCodeFormat(strXMLFile.FileContent)# == /cfoutput ---end code 2 The strange things is that when I call directly the CGIserver I got what I expected ie the files I requested I google and tried a lot of suggestions from people who got a similar problem of Connection failure but not necessesarely with a proxy. Things I tried for example: 1-http://www.talkingtree.com/blog/index.cfm/2004/7/28/20040729#more 2-http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=21241forumid=4 3-http://qaix.com/coldfusion/313-460-cfhttp-connection-failure-read.shtml Anyone have an idea ? I appreciate your help ! Thanks Waltereo ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225950 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
Tabbed interface testers
I have ported over a cool ASP class that I used to use in an old position. I need some people to test it and make sure there is no functionality issues with the port. You can view how it looks here http://www.reactivevision.com/tabs/demo/ You can download it here http://www.reactivevision.com/tabs.zip . I could use some javascript gurus to take a look at an issue with image reloading and Internet Explorer. For some reason on rollover it wants to reload the pictures even though they are already cached. It works fine in Firefox. This has been an issue with this utility for some time. Enjoy. Bob Everland ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225951 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: Keeping a session alive
This is probably what I meant when I said use AJAX. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:25 AM To: CF-Talk Subject: Re: Keeping a session alive 1) I absolutely REFUSE to use a frame or Iframe whatsoever. You're right. Have a look at XMLHttpRequest in Javascript. You can call a CF template every 10 min or so, directly from a script, without having to reload any part of the page, no blink, no glass cursor, no nothing. The user will see nothing. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225952 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: Error SQL Params
But late, but tou could use SQL Profiler. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: John Skrotzki [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Fri Dec 02 05:41:54 2005 Subject: Error SQL Params I spent the last hour trying to find an answer to my question with no luck. I have a custom error page that emails me with alot of info but one thing I would LOVE is to see the value of the sql params that where sent to the database. For now I have this ( parital listing ) in the email: Diagnostics [#error.diagnostics#]: Error Executing Database Query. Invalid data for CFSQLTYPE CF_SQL_FLOAT. The error occurred on line 487. Last SQL Code [#error.rootCause.SQL#]: UPDATE Invoice SET Paid = (param 1) WHERE Ident = (param 2) Is there a way to extract the param values and place it in the email also. Thanks... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225953 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: Keeping a session alive
-Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:08 AM To: CF-Talk Subject: RE: Keeping a session alive If you want to refresh, you can also use an image I've an extensive article and sample code for using a GIF as a data pipe here: http://www.depressedpress.com/Content/Development/JavaScript/Articles/GIFAsP ipe/Index.cfm The article also provides the JavaScript code needed to parse responses from the server using this. Hope it helps, Jim Davis ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225954 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: interacting with java and return a ColdFusion query
I think you need to use the class coldfusion.sql.QueryTable to do what you want. It's in either cfx.jar or cfusion.jar. Mark -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:17 AM To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2. htm#1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225955 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: CFC web service persistence concepts.
Not really. It's basically the same problem as you have with regular web pages. You can require and use cookies for state management, or you can explicitly create a token that will then be passed to future requests for the same session. Ok, but I don't understand the web service side of things enough to visualize how to do this. How does one create a persistent object from and/or for a web service CFC? Does ColdFusion create a session for a web service I can access? What does one do with the token when it is returned to access a session? I'm hoping for a quick outline or sample of the techniques for doing this. Thanks -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225956 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: cfgrid flash form question
Felipe, Thank you! I thought about doing it that way too but I didn't know enough Flex and actionscript to make that happen. Can I ask you another question? What if I wanted to disable (gray out) a row in the cfgrid when 'selectmode=edit'? -Original Message- From: Felipe Fernandes [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 8:42 AM To: CF-Talk Subject: Re: cfgrid flash form question Nick, the best way is to use a cfinput type=button to delete the rows insted of the auto genereted del of the grid. This code also popup´s an confirmation alert to confirm the delete: cfsavecontent variable=actionDelete var batchType = batchType var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { var item = batchType.selectedItem; if(_global.backupDP != undefined) { for(var i = 0; i _global.backupDP.length; i++) { if(_global.backupDP[i] == item) { _global.backupDP.removeItemAt(i); } } } GridData.deleteRow(batchType); } } //set the font color and button labels of all alerts _global.styles.Alert.setStyle(color, 0xFF); mx.controls.Alert.cancelLabel = No!; mx.controls.Alert.yesLabel = Yes; //create the alert var qtexto = 'Tem certeza que deseja excluir o livro \n\n' + batchType.selectedItem.titulo.toUpperCase(); var myAlert = mx.controls.Alert.show(qtexto, Confirmação, mx.controls.Alert.YES | mx.controls.Alert.CANCEL, box1, myClickHandler); /cfsavecontent And the button would be something like this: cfinput type=button name=removesub value=Excluir onclick=#actionDelete# enabled={(batchType.selectedItem.id != undefined batchType.selectedItem.id != 'what you don´t want it to be')} / I used the batchType.selectedItem.id but I don´t know the columns of your grid so you may have to change the 'id' for some existing row. If you want the code to do the insert button just ask. Felipe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225957 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: Keeping a session alive
Nice. Just one of the MANY useful reads at depressedpress.com :) Thanks Jim. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 12:00 PM To: CF-Talk Subject: RE: Keeping a session alive -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:08 AM To: CF-Talk Subject: RE: Keeping a session alive If you want to refresh, you can also use an image I've an extensive article and sample code for using a GIF as a data pipe here: http://www.depressedpress.com/Content/Development/JavaScript/Articles/GIFAsP ipe/Index.cfm The article also provides the JavaScript code needed to parse responses from the server using this. Hope it helps, Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225958 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: interacting with java and return a ColdFusion query
yes, Mark's correct. You can populate a coldfusion.sql.QueryTable with a java.sql.ResultSet (passed into the constructor). I usually only resort to a java wrapper class when there's a specific reason that the java calls cannot be coded in CFML. Is that the case here? I think you need to use the class coldfusion.sql.QueryTable to do what you want. It's in either cfx.jar or cfusion.jar. Mark -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:17 AM To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2. htm#1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225959 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: anybody ever use cftable?
gee, lemme guess that this is going into your output_all_html_content_from_cfc.cfc thats gunna change the way everyone uses cfc's lol Why do u even ask? if 99.9% of the responces are to not use it you are gunna use it anyways... I didn't even know it existed, who's code did you steal and see it on? ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Will Tomlinson [EMAIL PROTECTED] Sent: Friday, December 02, 2005 6:11 AM To: CF-Talk cf-talk@houseoffusion.com Subject: anybody ever use cftable? Other than dave, has anybody EVER used the cftable tag?? Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225960 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: interacting with java and return a ColdFusion query
You can also create an arbitrary QueryTable (with columns you specify). I wish there was a way to do this without having to reference cfusion.jar... I do it to help maintain a back-end (in java) vs front-end (in cfml) distinction in the system. -Original Message- From: Dave Ross [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 12:09 PM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query yes, Mark's correct. You can populate a coldfusion.sql.QueryTable with a java.sql.ResultSet (passed into the constructor). I usually only resort to a java wrapper class when there's a specific reason that the java calls cannot be coded in CFML. Is that the case here? I think you need to use the class coldfusion.sql.QueryTable to do what you want. It's in either cfx.jar or cfusion.jar. Mark -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:17 AM To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2 .. htm#1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225961 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: Keeping a session alive
This is probably what I meant when I said use AJAX. Probabily, although AJAX may be a big word when only a couple of lines of code are needed in this case. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225962 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
OT: Subversion migration
My development server finally arrived and I'd like to move my SVN repository from my local machine to the new dev machine. I have TortoiseSVN on my local machine, but the dev server is 64-bit and I can't get Tortoise to work on there. So, can I use the Tortoise Repo-Browser on my local machine to do what I need? If not, how do I do it command-line? I have the subversion book but I can't understand how to do what I'm after. Thanks for any help. Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225963 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: OT: Subversion migration
Do you mean your working directory? If you need to move your repo, commit everything from your working directory, delete your working directory, copy the repository directory to the new location (your new box), and then check out your working directory again from the new location. If you just need to move your working directory, simply check in changes, delete it, and check it out again in the new location (your new box). In either case, I'd recommend checking out a full-service SVN client. Tortoise is great for basic stuff, but a 'real' client will serve you better. SmartSVN is one I used and liked, but my tool of choice these days is Subclipse, an SVN plugin for Eclipse. Both of those happen to be Java, so if you've got a JRE that runs on your 64-bit system, they'll work without issue. cheers, barneyb On 12/2/05, Paul [EMAIL PROTECTED] wrote: My development server finally arrived and I'd like to move my SVN repository from my local machine to the new dev machine. I have TortoiseSVN on my local machine, but the dev server is 64-bit and I can't get Tortoise to work on there. So, can I use the Tortoise Repo-Browser on my local machine to do what I need? If not, how do I do it command-line? I have the subversion book but I can't understand how to do what I'm after. Thanks for any help. Paul -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225964 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: Subversion migration
Barney, thanks for the info. I use CFEclipse and Subclipse, but on my local development machine rather than the dev server... In any case I think maybe I was overcomplicating things. The new dev server will become my SVN server, but I will continue to develop on my local machine. Thus my working copy will remain where it is (local), but I'd like to get the repository onto the dev server. Is it really just as simple as copy/paste the entire repository directory to the new server? -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 11:45 AM To: CF-Talk Subject: Re: OT: Subversion migration Do you mean your working directory? If you need to move your repo, commit everything from your working directory, delete your working directory, copy the repository directory to the new location (your new box), and then check out your working directory again from the new location. If you just need to move your working directory, simply check in changes, delete it, and check it out again in the new location (your new box). In either case, I'd recommend checking out a full-service SVN client. Tortoise is great for basic stuff, but a 'real' client will serve you better. SmartSVN is one I used and liked, but my tool of choice these days is Subclipse, an SVN plugin for Eclipse. Both of those happen to be Java, so if you've got a JRE that runs on your 64-bit system, they'll work without issue. cheers, barneyb On 12/2/05, Paul [EMAIL PROTECTED] wrote: My development server finally arrived and I'd like to move my SVN repository from my local machine to the new dev machine. I have TortoiseSVN on my local machine, but the dev server is 64-bit and I can't get Tortoise to work on there. So, can I use the Tortoise Repo-Browser on my local machine to do what I need? If not, how do I do it command-line? I have the subversion book but I can't understand how to do what I'm after. Thanks for any help. Paul -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225965 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: rss feed
Alright, using your sample code, I seem to have produced a viable xml document. Now the way that I understand an rss feed is that I produce an xml file on the server and a link that goes to it. Can I make that file on the server using cfheader? I've given it a shot but it's not working. Right now it displays on the page rathe than in a file. If I change the cfcontent type to applicatin/excel it'll save a file. Any clues to the right path would be nice - not an answer but a clue... (cause we could all use a clue) cfsavecontent variable=xml?xml version=1.0? headerThis is my header/header /cfsavecontent cfsetting showdebugoutput=yes cfheader name=Content-Disposition value=inline; filename=h.xml cfcontent type=text/xmlcfoutput#xml#/cfoutput All the above is doing is bundling up that multi-line variable so you can use it later. Then, later you can output it as xml: cfcontent type=text/xmlcfoutput#xml#/cfoutput If you have debugging turned on for your IP, be sure to kill it for this page. The following code should give you a properly formatted XML document with one thing in it (header). cfsavecontent variable=xml?xml version=1.0? headerThis is my header/header /cfsavecontent cfsetting showdebugoutput=no cfcontent type=text/xmlcfoutput#xml#/cfoutput On 11/15/05, daniel kessler [EMAIL PROTECTED] wrote: ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225966 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: rss feed
That showdebugoutput should be no - debug output is going to royally screw with your xml. Beyond that, I'm not sure what exactly you're trying to do. On 12/2/05, daniel kessler [EMAIL PROTECTED] wrote: Alright, using your sample code, I seem to have produced a viable xml document. Now the way that I understand an rss feed is that I produce an xml file on the server and a link that goes to it. Can I make that file on the server using cfheader? I've given it a shot but it's not working. Right now it displays on the page rathe than in a file. If I change the cfcontent type to applicatin/excel it'll save a file. Any clues to the right path would be nice - not an answer but a clue... (cause we could all use a clue) cfsavecontent variable=xml?xml version=1.0? headerThis is my header/header /cfsavecontent cfsetting showdebugoutput=yes cfheader name=Content-Disposition value=inline; filename=h.xml cfcontent type=text/xmlcfoutput#xml#/cfoutput All the above is doing is bundling up that multi-line variable so you can use it later. Then, later you can output it as xml: cfcontent type=text/xmlcfoutput#xml#/cfoutput If you have debugging turned on for your IP, be sure to kill it for this page. The following code should give you a properly formatted XML document with one thing in it (header). cfsavecontent variable=xml?xml version=1.0? headerThis is my header/header /cfsavecontent cfsetting showdebugoutput=no cfcontent type=text/xmlcfoutput#xml#/cfoutput On 11/15/05, daniel kessler [EMAIL PROTECTED] wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225967 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: Keeping a session alive
Bobby, Just out of curiosity... can a frame trigger a js event in another frame? Provider there are the same domain (which is usually the case,) yes. Just use the parent object to reference the document object that created the iframe /. Just curious since I still refuse to use one :) That's the second time someone has mentioned 'harder' or 'more trouble'. Come on people... it's not brick work... it's programming. Nothing about it is 'hard' or 'troubling' Nice PSP analogy though ;) I've got a nice method with httprequest on a timed trigger now. It works great. Just remember that the xmlHttpRequest object could open up compatibility problems between different browsers. It just seems like overkill for you need. -Dan ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225968 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: rss feed
That showdebugoutput should be no - debug output is going to royally screw with your xml. oops, forgot that I changed that. Beyond that, I'm not sure what exactly you're trying to do. well, I'm trying to make an export of some of my database information into something that an rss reader could use. I want our What's New in the College to be an rss feed. I thought that was through making an xml file. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225969 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: interacting with java and return a ColdFusion query
Well, I managed to get something working with everybody's help here. Thanks everyone! I'll try and post the exact solution, when I polish it. George On 12/2/05, Gaulin, Mark [EMAIL PROTECTED] wrote: You can also create an arbitrary QueryTable (with columns you specify). I wish there was a way to do this without having to reference cfusion.jar... I do it to help maintain a back-end (in java) vs front-end (in cfml) distinction in the system. -Original Message- From: Dave Ross [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 12:09 PM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query yes, Mark's correct. You can populate a coldfusion.sql.QueryTable with a java.sql.ResultSet (passed into the constructor). I usually only resort to a java wrapper class when there's a specific reason that the java calls cannot be coded in CFML. Is that the case here? I think you need to use the class coldfusion.sql.QueryTable to do what you want. It's in either cfx.jar or cfusion.jar. Mark -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:17 AM To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2 .. htm#1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225970 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: OT: Subversion migration
Yep, it's really that simple. You'll need to delete your existing working directory, copy the repo, and then check your WD out again, so that the SVN metadata reflects the new repo location.You can look into `svn switch` which would allow you to change the metadata in place, but I've had mixed luck with it, so I go the delete/checkout route. Just make sure you check in any uncommitted changes first. ;) cheers, barneyb On 12/2/05, Paul [EMAIL PROTECTED] wrote: Barney, thanks for the info. I use CFEclipse and Subclipse, but on my local development machine rather than the dev server... In any case I think maybe I was overcomplicating things. The new dev server will become my SVN server, but I will continue to develop on my local machine. Thus my working copy will remain where it is (local), but I'd like to get the repository onto the dev server. Is it really just as simple as copy/paste the entire repository directory to the new server? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225971 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: Subversion migration
Thanks again. I have it sorted out now. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 12:49 PM To: CF-Talk Subject: Re: OT: Subversion migration Yep, it's really that simple. You'll need to delete your existing working directory, copy the repo, and then check your WD out again, so that the SVN metadata reflects the new repo location.You can look into `svn switch` which would allow you to change the metadata in place, but I've had mixed luck with it, so I go the delete/checkout route. Just make sure you check in any uncommitted changes first. ;) cheers, barneyb On 12/2/05, Paul [EMAIL PROTECTED] wrote: Barney, thanks for the info. I use CFEclipse and Subclipse, but on my local development machine rather than the dev server... In any case I think maybe I was overcomplicating things. The new dev server will become my SVN server, but I will continue to develop on my local machine. Thus my working copy will remain where it is (local), but I'd like to get the repository onto the dev server. Is it really just as simple as copy/paste the entire repository directory to the new server? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225972 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: rss feed
alright, I went to CFFILE and it seems to be working fine. well, still some problems, but understandable and fixable problems. thanks all! well, I'm trying to make an export of some of my database information into something that an rss reader could use. I want our What's New in the College to be an rss feed. I thought that was through making an xml file. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225973 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
Coldfusion creating an excel file, problems....
I'm using CF to create an Excel file for me on the fly. There are currently 2500 records in the db, but when I create the Excel file I only get 1850, and the content gets cut off right in mid record. I'm wondering if there's some crazy character in one of the fields that's doing it. Does anyone have any ideas? Here's some samples of the Account NUmber field (from the client, not from me): A4062834023)_D,NRan A4042737277%2NV(ITim A5021563429#` %4PAmy A5021563429%L*)PHec A4052758846!E#CPOBri A4042744086Y+H?NJen Here's the column where the output stops: A0072037096%Y6OMit I get nothing after this snippet: A0072037096, but there are other fields that have in them and no problem. And here's the code I'm using: cfheader name=content-disposition value=attachment;filename=Fortna_Mailing_List.xls cfcontent type=application/msexcel html head title new document /title /head body cfquery name=outputList dataSource=#Application.DSN# dbType=#Application.DBType# username=#Application.username# password=#Application.password# SELECT * FROM mailinglist /cfquery table id=excel_tbl tr tdSubscribe Date/td tdAccount Number/td tdName/td tdOrganization/td tdEmail Address/td tdPhone/td tdSend Email?/td tdSubscribe Status/td /tr cfoutput query=outputList tr td#DateFormat(info_dateadded,mm-dd-)#/td td#info_accountno#/td td#info_name#/td td#info_org#/td td#info_email#/td td#info_phone#/td td#info_sendemail#/td td#info_status#/td /tr /cfoutput /table /body /html !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225974 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: Coldfusion creating an excel file, problems....
I'll take a wild guess and suggest that the problem is not the , but the . Your ColdFusion will happily spit that account number out, but the web browser will try to do something with anything that starts with . -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 2:06 PM To: CF-Talk Subject: Coldfusion creating an excel file, problems I'm using CF to create an Excel file for me on the fly. There are currently 2500 records in the db, but when I create the Excel file I only get 1850, and the content gets cut off right in mid record. I'm wondering if there's some crazy character in one of the fields that's doing it. Does anyone have any ideas? Here's some samples of the Account NUmber field (from the client, not from me): A4062834023)_D,NRan A4042737277%2NV(ITim A5021563429#` %4PAmy A5021563429%L*)PHec A4052758846!E#CPOBri A4042744086Y+H?NJen Here's the column where the output stops: A0072037096%Y6OMit I get nothing after this snippet: A0072037096, but there are other fields that have in them and no problem. And here's the code I'm using: cfheader name=content-disposition value=attachment;filename=Fortna_Mailing_List.xls cfcontent type=application/msexcel html head title new document /title /head body cfquery name=outputList dataSource=#Application.DSN# dbType=#Application.DBType# username=#Application.username# password=#Application.password# SELECT * FROM mailinglist /cfquery table id=excel_tbl tr tdSubscribe Date/td tdAccount Number/td tdName/td tdOrganization/td tdEmail Address/td tdPhone/td tdSend Email?/td tdSubscribe Status/td /tr cfoutput query=outputList tr td#DateFormat(info_dateadded,mm-dd-)#/td td#info_accountno#/td td#info_name#/td td#info_org#/td td#info_email#/td td#info_phone#/td td#info_sendemail#/td td#info_status#/td /tr /cfoutput /table /body /html !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion creating an excel file, problems....
A...hadn't thought about that. I'll see about finding and replacing that. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 3:17 PM To: CF-Talk Subject: RE: Coldfusion creating an excel file, problems I'll take a wild guess and suggest that the problem is not the , but the . Your ColdFusion will happily spit that account number out, but the web browser will try to do something with anything that starts with . -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 2:06 PM To: CF-Talk Subject: Coldfusion creating an excel file, problems I'm using CF to create an Excel file for me on the fly. There are currently 2500 records in the db, but when I create the Excel file I only get 1850, and the content gets cut off right in mid record. I'm wondering if there's some crazy character in one of the fields that's doing it. Does anyone have any ideas? Here's some samples of the Account NUmber field (from the client, not from me): A4062834023)_D,NRan A4042737277%2NV(ITim A5021563429#` %4PAmy A5021563429%L*)PHec A4052758846!E#CPOBri A4042744086Y+H?NJen Here's the column where the output stops: A0072037096%Y6OMit I get nothing after this snippet: A0072037096, but there are other fields that have in them and no problem. And here's the code I'm using: cfheader name=content-disposition value=attachment;filename=Fortna_Mailing_List.xls cfcontent type=application/msexcel html head title new document /title /head body cfquery name=outputList dataSource=#Application.DSN# dbType=#Application.DBType# username=#Application.username# password=#Application.password# SELECT * FROM mailinglist /cfquery table id=excel_tbl tr tdSubscribe Date/td tdAccount Number/td tdName/td tdOrganization/td tdEmail Address/td tdPhone/td tdSend Email?/td tdSubscribe Status/td /tr cfoutput query=outputList tr td#DateFormat(info_dateadded,mm-dd-)#/td td#info_accountno#/td td#info_name#/td td#info_org#/td td#info_email#/td td#info_phone#/td td#info_sendemail#/td td#info_status#/td /tr /cfoutput /table /body /html !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225976 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: Coldfusion creating an excel file, problems....
I have trouble sometimes when streaming file content like that to the browser. What I would recommend doing is write the content to a file, then use the CFContent tag to stream the file to the browser (with deletefile attribute set to yes). This has taken care of weird character issues and the like. In and of itself, Excel should not have a problem with characters. I escape stuff all the time in excel (ex. #8212;) without issue. ... Ben Nadel Web Developer Nylon Technology 6 West 14th Street New York, NY 10011 212.691.1134 212.691.3477 fax www.nylontechnology.com Vote for Pedro ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225977 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: cfgrid flash form question
Nick, I don´t think you can disable an specific row in a grid but you can use form fields and binds insted of the editable grid, take a look at tihs: www.larousse1.com.br/edita It´s a CMS in flash forms that i did. Go at 'livros' under 'catalogo' at the menu and you will see a nice example of what I´m talking about. When you select a row in the grid it populates the fileds in the second panel for you edit them with this aproach you can enable and disable the editing panel as you wish. If you want I can give you some help. Felipe On 12/2/05, Nick Han [EMAIL PROTECTED] wrote: Felipe, Thank you! I thought about doing it that way too but I didn't know enough Flex and actionscript to make that happen. Can I ask you another question? What if I wanted to disable (gray out) a row in the cfgrid when 'selectmode=edit'? -Original Message- From: Felipe Fernandes [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 8:42 AM To: CF-Talk Subject: Re: cfgrid flash form question Nick, the best way is to use a cfinput type=button to delete the rows insted of the auto genereted del of the grid. This code also popup´s an confirmation alert to confirm the delete: cfsavecontent variable=actionDelete var batchType = batchType var myClickHandler = function (evt) { if (evt.detail == mx.controls.Alert.YES) { var item = batchType.selectedItem; if(_global.backupDP != undefined) { for(var i = 0; i _global.backupDP.length; i++) { if(_global.backupDP[i] == item) { _global.backupDP.removeItemAt(i); } } } GridData.deleteRow(batchType); } } //set the font color and button labels of all alerts _global.styles.Alert.setStyle(color, 0xFF); mx.controls.Alert.cancelLabel = No!; mx.controls.Alert.yesLabel = Yes; //create the alert var qtexto = 'Tem certeza que deseja excluir o livro \n\n' + batchType.selectedItem.titulo.toUpperCase(); var myAlert = mx.controls.Alert.show(qtexto, Confirmação, mx.controls.Alert.YES | mx.controls.Alert.CANCEL, box1, myClickHandler); /cfsavecontent And the button would be something like this: cfinput type=button name=removesub value=Excluir onclick=#actionDelete# enabled={(batchType.selectedItem.id != undefined batchType.selectedItem.id != 'what you don´t want it to be')} / I used the batchType.selectedItem.id but I don´t know the columns of your grid so you may have to change the 'id' for some existing row. If you want the code to do the insert button just ask. Felipe ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225978 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
Stored Proc
Hi guys. As they say in CF good practices. Make your database do the work for you. I have a CFC with this function below. I need to make it into a stored procedure. The function is: cffunction name=LatLonDist returntype=numeric access=public cfargument name=lat1 type=numeric required=true cfargument name=lon1 type=numeric required=true cfargument name=lat2 type=numeric required=true cfargument name=lon2 type=numeric required=true cfargument name=units type=string required=true cfset var myResult = 0 CFIF (arguments.lat1 GT 90 OR arguments.lat1 LT -90 OR arguments.lon1 GT 180 OR arguments.lon1 LT -180 OR arguments.lat2 GT 90 OR arguments.lat2 LT -90 OR arguments.lon2 GT 280 OR arguments.lon2 LT -280) cfset myResult = 0 cfelse cfset lat1 = arguments.lat1 * pi()/180 cfset lon1 = arguments.lon1 * pi()/180 cfset lat2 = arguments.lat2 * pi()/180 cfset lon2 = arguments.lon2 * pi()/180 cfset UnitConverter = 1.150779448 cfif arguments.units eq 'nm' cfset UnitConverter = 1.0 /cfif cfif arguments.units eq 'km' cfset UnitConverter = 1.852 /cfif cfset distance = 2*asin(sqr((sin((arguments.lat1-arguments.lat2)/2))^2 + cos(arguments.lat1)*cos(arguments.lat2)*(sin(( arguments.lon1-arguments.lon2)/2))^2)) cfif arguments.units neq 'radians' cfset distance = UnitConverter * 60 * distance * 180/pi() /cfif cfset myResult=distance /CFIF cfreturn myResult /cffunction Thanks, K ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225979 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: Using NT user database with CF
On Dec 2, 2005, at 10:19 AM, Robertson-Ravo, Neil (RX) wrote: What happened to your Lewis?! Pardon? I'm right here? ... If you mean my name ... it's Lewis, yes, but my nickname has been min since around 1993.. if that's what you mean. Sec. K. An old DOS VGA demo... Notice the screenshots. http://www.intrafoundation.com/intrafoundation/products.php? ProductCode=demob Min is short for minimalist group. Long story... --min er, Lewis. -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 15:27 To: CF-Talk Subject: Re: Using NT user database with CF On Dec 1, 2005, at 5:26 PM, Matt Robertson wrote: Anyone know of a way that CF can hook into win2k/NT/2k3 user accounts? In other words, someone logs onto Windows when they fire up their desktop and this info is also used to authenticate their CF-based intranet session. What Ian said. Also, see http://www.intrafoundation.com/intrafoundation/products.php? ProductCode=IHTK for some older CFX tools to manage IIS and NT user accounts if that need comes up (with full source). --min -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225980 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: Stored Proc
As they say in CF good practices. Make your database do the work for you. That's news to me. Why take a good cfc that is working just fine and turn it into a stored proc? Assuming that is the way you are going to go, regardless of my ramblings, what DB are you running? Stored procedures are different in every DB... --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225981 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: Stored Proc
I know where you are coming from, Munson. However, believe me, I have good reason to do that. I have a table db_postalcodes of all US zipcodes and their latitutde and longitudes. I am building a store locator app. My logic is to take the zipcode entered by the user, fetch the latitutde and logitude for it, compare it with the zipcodes of our store locations. My CFC calculates the distance between 2 given zipcodes. Then I present the least distance to the user. So far, I have code that looks like this: (It is very taxing on the database): cfobject component=Resources name=ObjRes cfset userzip=86403 !--- zip entered by user--- cfquery name=GetUserZip datasource=#request.datasource# select latitude, longitude from db_postalcodes where ZIPCode='#userzip#' /cfquery cfset lat1=#GetUserZip.latitude# cfset lon1=#GetUserZip.longitude# cfquery name=GetQDZips datasource=#request.datasource# select db_users.user_id, db_users.user_postal AS QDZip from db_users where db_users.user_postal is not null AND db_users.country_id=218 AND user_id IN (Select user_ID from db_quikdrop where inactive IS NULL) /cfquery cfset distlist= cfloop query=GetQDZips cfquery name=GetQDZip datasource=#request.datasource# select latitude, longitude from db_postalcodes where ZIPCode = '#Left( GetQDZips.QDZip,5)#' /cfquery cfset lat2=#GetQDZip.latitude# cfset lon2=#GetQDZip.longitude# cfif IsNumeric(lat2) AND IsNumeric(lon2) cfset distance=ObjRes.LatLonDist(lat1,lon1,lat2,lon2,'nm') cfset distlist= ListAppend(distlist,distance) /cfif /cfloop cfset distlist=listsort(distlist,numeric) cfoutput#distlist#/cfoutput I would appreciate ways to make this code more efficient. Thanks, K On 12/2/05, Munson, Jacob [EMAIL PROTECTED] wrote: As they say in CF good practices. Make your database do the work for you. That's news to me. Why take a good cfc that is working just fine and turn it into a stored proc? Assuming that is the way you are going to go, regardless of my ramblings, what DB are you running? Stored procedures are different in every DB... --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225982 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: Stored Proc
One thing I would do to speed things up a little is use cfqueryparam. Not only is this good to make sure the user isn't performing a sql injection attack, but cfqueryparam will send a compiled query to the DB, which can speed things up (otherwise the DB has to compile every query, including all the ones in your loop). You'll have to play around to see if this speeds things up or not. -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 4:33 PM To: CF-Talk Subject: Re: Stored Proc I know where you are coming from, Munson. However, believe me, I have good reason to do that. I have a table db_postalcodes of all US zipcodes and their latitutde and longitudes. I am building a store locator app. My logic is to take the zipcode entered by the user, fetch the latitutde and logitude for it, compare it with the zipcodes of our store locations. My CFC calculates the distance between 2 given zipcodes. Then I present the least distance to the user. So far, I have code that looks like this: (It is very taxing on the database): cfobject component=Resources name=ObjRes cfset userzip=86403 !--- zip entered by user--- cfquery name=GetUserZip datasource=#request.datasource# select latitude, longitude from db_postalcodes where ZIPCode='#userzip#' /cfquery cfset lat1=#GetUserZip.latitude# cfset lon1=#GetUserZip.longitude# cfquery name=GetQDZips datasource=#request.datasource# select db_users.user_id, db_users.user_postal AS QDZip from db_users where db_users.user_postal is not null AND db_users.country_id=218 AND user_id IN (Select user_ID from db_quikdrop where inactive IS NULL) /cfquery cfset distlist= cfloop query=GetQDZips cfquery name=GetQDZip datasource=#request.datasource# select latitude, longitude from db_postalcodes where ZIPCode = '#Left( GetQDZips.QDZip,5)#' /cfquery cfset lat2=#GetQDZip.latitude# cfset lon2=#GetQDZip.longitude# cfif IsNumeric(lat2) AND IsNumeric(lon2) cfset distance=ObjRes.LatLonDist(lat1,lon1,lat2,lon2,'nm') cfset distlist= ListAppend(distlist,distance) /cfif /cfloop cfset distlist=listsort(distlist,numeric) cfoutput#distlist#/cfoutput I would appreciate ways to make this code more efficient. Thanks, K On 12/2/05, Munson, Jacob [EMAIL PROTECTED] wrote: As they say in CF good practices. Make your database do the work for you. That's news to me. Why take a good cfc that is working just fine and turn it into a stored proc? Assuming that is the way you are going to go, regardless of my ramblings, what DB are you running? Stored procedures are different in every DB... --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Need help invoking CFC using CFSCRIPT
Hi, I'm building some user-configurable front page widgets for a site that I'm building. I'd prefer to use CFSCRIPT for a number of reasons. Anyway, I'm having trouble getting any output. This code, using CFINVOKE, works fine (it returns the HTML for an image tag): cfinvoke component=lib.cfc.html_modules method=fpRandImage returnvariable=img#img# Yet, this code within a CFSCRIPT block, returns [EMAIL PROTECTED]: fpWidgetObj = createObject(component,lib.cfc.html_modules); newrow = queryAddRow(qryFPSidebar, 1); temp = querySetCell(qryFPSidebar, order, 3); temp = querySetCell(qryFPSidebar, type, Image); temp = querySetCell(qryFPSidebar, content, #fpWidgetObj.fpRandImage#); I'm returning the data as a query object to make it easier to sort the data for display on the front page. Any ideas what I'm doing wrong? Thanks Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225984 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
xmlParse error
I have been developing an app locally that works like a charm. I just rolled onto my new testing server and it no longer likes my XML config files. When I try to run xmlParse I get the error Content is not allowed in prolog. The error makes me think my XML is suspect, but I'm certain it is the same exact XML that works on my local machine. In fact the only difference at all is the machine on which it's being parsed... I'm stumped. Have any of you run across that error before? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225985 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: xmlParse error
I'm stumped. Have any of you run across that error before? Oh yeah I've seen this one a hundred times. It's always come from the wrong path to the xml file. The error message is a little confusing, making you think it's the xml itself, but it's not. I'd re-check the path or whatever you're using to fins the xml file itself. Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225986 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: Need help invoking CFC using CFSCRIPT
I'm building some user-configurable front page widgets for a site that I'm building. I'd prefer to use CFSCRIPT for a number of reasons. Anyway, I'm having trouble getting any output. This code, using CFINVOKE, works fine (it returns the HTML for an image tag): cfinvoke component=lib.cfc.html_modules method=fpRandImage returnvariable=img#img# Yet, this code within a CFSCRIPT block, returns [EMAIL PROTECTED]: fpWidgetObj = createObject(component,lib.cfc.html_modules); newrow = queryAddRow(qryFPSidebar, 1); temp = querySetCell(qryFPSidebar, order, 3); temp = querySetCell(qryFPSidebar, type, Image); temp = querySetCell(qryFPSidebar, content, #fpWidgetObj.fpRandImage#); I'm returning the data as a query object to make it easier to sort the data for display on the front page. Any ideas what I'm doing wrong? Method calls in CFSCRIPT need to be written just like they are for built-in functions: fpWidgetObj.fpRandImage() What your code is returning is a pointer to the function, more or less. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225987 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
OT - Firefox crashing
I was wondering if any of you have had problems with Firefox not releasing memory and crashing. There have been times I have seen Firefox using over 1 gig of ram! I have researched this and found it is a known bug. If others are having this problem I just wondered what you did, are you frustrated like me, and if you found a work around other than restarting Firefox. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225988 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 - Firefox crashing
Yup, my Firefox has been crashing too. It will suddenly die and give the Send Error Report dialog box. I will check to see how much ram it's using next time I run it. - Original Message - From: Stan Winchester [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 02, 2005 5:14 PM Subject: OT - Firefox crashing I was wondering if any of you have had problems with Firefox not releasing memory and crashing. There have been times I have seen Firefox using over 1 gig of ram! I have researched this and found it is a known bug. If others are having this problem I just wondered what you did, are you frustrated like me, and if you found a work around other than restarting Firefox. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225989 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: OT - Firefox crashing
Happens a lot when trying to play a video... I feel your pain. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 8:14 PM To: CF-Talk Subject: OT - Firefox crashing I was wondering if any of you have had problems with Firefox not releasing memory and crashing. There have been times I have seen Firefox using over 1 gig of ram! I have researched this and found it is a known bug. If others are having this problem I just wondered what you did, are you frustrated like me, and if you found a work around other than restarting Firefox. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225990 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: Stored Proc
I do this type of search on a site of mine, and it just uses SQL to do it all. I pass in a zip to it and the sql does all the work, not cf. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225991 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: OT - Firefox crashing
yeah it happens with vids a lot, especially on myspace, it's almost always them damn crap assed ms wma junk (imagine that) all the others seem to work fine. I wished ms would just give up and just make copy paper or something useful.. ;) ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Bobby Hartsfield [EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:37 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: OT - Firefox crashing Happens a lot when trying to play a video... I feel your pain. ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 8:14 PM To: CF-Talk Subject: OT - Firefox crashing I was wondering if any of you have had problems with Firefox not releasing memory and crashing. There have been times I have seen Firefox using over 1 gig of ram! I have researched this and found it is a known bug. If others are having this problem I just wondered what you did, are you frustrated like me, and if you found a work around other than restarting Firefox. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225992 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: OT - Firefox crashing
Yeah actually.. it NORMALLY is wmv's but it has happened with other videos as well. I cant recall it happening with anything other than videos though ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:46 PM To: CF-Talk Subject: RE: OT - Firefox crashing yeah it happens with vids a lot, especially on myspace, it's almost always them damn crap assed ms wma junk (imagine that) all the others seem to work fine. I wished ms would just give up and just make copy paper or something useful.. ;) ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Bobby Hartsfield [EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:37 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: OT - Firefox crashing Happens a lot when trying to play a video... I feel your pain. :.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 8:14 PM To: CF-Talk Subject: OT - Firefox crashing I was wondering if any of you have had problems with Firefox not releasing memory and crashing. There have been times I have seen Firefox using over 1 gig of ram! I have researched this and found it is a known bug. If others are having this problem I just wondered what you did, are you frustrated like me, and if you found a work around other than restarting Firefox. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225993 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: Stored Proc
First, I get all the long/lat info from the zip table with a query named passedzip. No cfqueryparams here so don't say anything bout it. And I did this two years ago before I got decent. lol SELECT * FROM tblzipcodes WHERE zipcode=#FORM.passedzipcode# This runs the query to display the items found within the passed radius from the form. Just drop out all the crap fields. SELECT tblChorusGroups.ChorusID, tblChorusGroups.ChorusName, tblChorusGroups.ChorusCity, tblChorusGroups.ChorusState, tblChorusGroups.ChorusZip, tblChorusTypes.ChorusTypeCategory, tblChorusTypes.ChorusID, tblzipcodes.zipcode, tblzipcodes.longitude, tblzipcodes.latitude, ROUND((ACOS((SIN(#passedzip.latitude#/57.2958) * SIN(latitude/57.2958)) + (COS(#passedzip.latitude#/57.2958) * COS(latitude/57.2958) * COS(longitude/57.2958 - #passedzip.longitude#/57.2958 * 3963) AS distance FROM tblChorusGroups, tblChorusTypes, tblzipcodes WHERE tblChorusGroups.ChorusID = tblChorusTypes.ChorusID AND tblChorusGroups.ChorusZip = tblzipcodes.zipcode AND (latitude = #passedzip.latitude# - (#FORM.passedradius#/111)) AND (latitude = #passedzip.latitude# + (#FORM.passedradius#/111)) AND (longitude = #passedzip.longitude# - (#FORM.passedradius#/111)) AND (longitude = #passedzip.longitude# + (#FORM.passedradius#/111)) cfif IsDefined(grouptype) AND #FORM.grouptype# NEQ AND tblChorusGroups.ChorusGroupType = '#FORM.grouptype#'/cfif cfif IsDefined(groupcategory) AND #FORM.groupcategory# NEQ AND tblChorusTypes.ChorusTypeCategory = '#FORM.groupcategory#'/cfif GROUP BY tblChorusGroups.ChorusName ORDER BY distance Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225994 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: OT - Firefox crashing
I wished ms would just give up and just make copy paper or something useful.. Yeah, thats what id do if I was dominating the world... pshhh ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:46 PM To: CF-Talk Subject: RE: OT - Firefox crashing yeah it happens with vids a lot, especially on myspace, it's almost always them damn crap assed ms wma junk (imagine that) all the others seem to work fine. I wished ms would just give up and just make copy paper or something useful.. ;) ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Bobby Hartsfield [EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:37 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: OT - Firefox crashing Happens a lot when trying to play a video... I feel your pain. :.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 8:14 PM To: CF-Talk Subject: OT - Firefox crashing I was wondering if any of you have had problems with Firefox not releasing memory and crashing. There have been times I have seen Firefox using over 1 gig of ram! I have researched this and found it is a known bug. If others are having this problem I just wondered what you did, are you frustrated like me, and if you found a work around other than restarting Firefox. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225995 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: Stored Proc
Thanks Will. Can you please share your code with me? Or give me some hints how to do it? Regards, K On 12/2/05, Will Tomlinson [EMAIL PROTECTED] wrote: I do this type of search on a site of mine, and it just uses SQL to do it all. I pass in a zip to it and the sql does all the work, not cf. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225996 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: Stored Proc
Thanks Will. Can you tell if the formula that you used to calculate the distance between 2 latitutdes and longitudes is the flat-earth formula or the spherical earth formula? I am talking about: ROUND((ACOS((SIN(#passedzip.latitude#/57.2958) * SIN(latitude/57.2958)) + (COS(#passedzip.latitude#/57.2958) * COS(latitude/57.2958) * COS(longitude/57.2958 - #passedzip.longitude#/57.2958 * 3963) Thanks again, K On 12/2/05, Will Tomlinson [EMAIL PROTECTED] wrote: First, I get all the long/lat info from the zip table with a query named passedzip. No cfqueryparams here so don't say anything bout it. And I did this two years ago before I got decent. lol SELECT * FROM tblzipcodes WHERE zipcode=#FORM.passedzipcode# This runs the query to display the items found within the passed radius from the form. Just drop out all the crap fields. SELECT tblChorusGroups.ChorusID, tblChorusGroups.ChorusName, tblChorusGroups.ChorusCity, tblChorusGroups.ChorusState, tblChorusGroups.ChorusZip, tblChorusTypes.ChorusTypeCategory, tblChorusTypes.ChorusID, tblzipcodes.zipcode, tblzipcodes.longitude, tblzipcodes.latitude, ROUND((ACOS((SIN(#passedzip.latitude#/57.2958) * SIN(latitude/57.2958)) + (COS(#passedzip.latitude#/57.2958) * COS(latitude/57.2958) * COS(longitude/57.2958 - #passedzip.longitude#/57.2958 * 3963) AS distance FROM tblChorusGroups, tblChorusTypes, tblzipcodes WHERE tblChorusGroups.ChorusID = tblChorusTypes.ChorusID AND tblChorusGroups.ChorusZip = tblzipcodes.zipcode AND (latitude = #passedzip.latitude# - (#FORM.passedradius#/111)) AND (latitude = #passedzip.latitude# + (#FORM.passedradius#/111)) AND (longitude = #passedzip.longitude# - (#FORM.passedradius#/111)) AND (longitude = #passedzip.longitude# + (#FORM.passedradius#/111)) cfif IsDefined(grouptype) AND #FORM.grouptype# NEQ AND tblChorusGroups.ChorusGroupType = '#FORM.grouptype#'/cfif cfif IsDefined(groupcategory) AND #FORM.groupcategory# NEQ AND tblChorusTypes.ChorusTypeCategory = '#FORM.groupcategory#'/cfif GROUP BY tblChorusGroups.ChorusName ORDER BY distance Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225997 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: OT - Firefox crashing
lol yeah instead they do cool stuff like .net, how'd that .net site go for ya?? haha ;)~ ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Bobby Hartsfield [EMAIL PROTECTED] Sent: Friday, December 02, 2005 10:02 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: OT - Firefox crashing I wished ms would just give up and just make copy paper or something useful.. Yeah, that's what id do if I was dominating the world... pshhh ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225998 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: Stored Proc
lol, this otta be a good one lol ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Ken [EMAIL PROTECTED] Sent: Friday, December 02, 2005 10:04 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Stored Proc Thanks Will. Can you please share your code with me? Or give me some hints how to do it? Regards, K On 12/2/05, Will Tomlinson wrote: I do this type of search on a site of mine, and it just uses SQL to do it all. I pass in a zip to it and the sql does all the work, not cf. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225999 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: Stored Proc
Thanks Will. Can you tell if the formula that you used to calculate the distance between 2 latitutdes and longitudes is the flat-earth formula or the spherical earth formula? I am talking about: ROUND((ACOS((SIN(#passedzip.latitude#/57.2958) * SIN(latitude/57.2958)) + (COS(#passedzip.latitude#/57.2958) * COS(latitude/57.2958) * COS(longitude/57.2958 - #passedzip.longitude#/57.2958 * 3963) I don't know what it is. I think I found it through google a while back. I DO know that it seems to give fairly accurate results. And it also displays the distance in the results, which is nice. Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226000 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 - Firefox crashing
Dont you have some browser wars to go fight? Changing the world one weak minded follower at a time huh? Lol ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 10:19 PM To: CF-Talk Subject: RE: OT - Firefox crashing lol yeah instead they do cool stuff like .net, how'd that .net site go for ya?? haha ;)~ ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Bobby Hartsfield [EMAIL PROTECTED] Sent: Friday, December 02, 2005 10:02 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: OT - Firefox crashing I wished ms would just give up and just make copy paper or something useful.. Yeah, that's what id do if I was dominating the world... pshhh :.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226001 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 syntax
Hi. I want to use this in one of my stored procedures. Can anyone correct the syntax here for me please. The formula i want to use is: 2*asin(sqrt((sin((lat1-lat2)/2))^2 + cos(lat1)*cos(lat2)*(sin((lon1-lon2)/2))^2)) Thanks, K ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226002 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: Stored Proc
Thanks Will. I just got this formula. But I need to convert this into SQL syntax: 2*asin(sqrt((sin((lat1-lat2)/2))^2 + cos(lat1)*cos(lat2)*(sin((lon1-lon2)/2))^2)) The POWER function of SQL is confusing. This formula uses the curved earth formula. - K On 12/2/05, Will Tomlinson [EMAIL PROTECTED] wrote: Thanks Will. Can you tell if the formula that you used to calculate the distance between 2 latitutdes and longitudes is the flat-earth formula or the spherical earth formula? I am talking about: ROUND((ACOS((SIN(#passedzip.latitude#/57.2958) * SIN(latitude/57.2958)) + (COS(#passedzip.latitude#/57.2958) * COS(latitude/57.2958) * COS(longitude/57.2958 - #passedzip.longitude#/57.2958 * 3963) I don't know what it is. I think I found it through google a while back. I DO know that it seems to give fairly accurate results. And it also displays the distance in the results, which is nice. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226003 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