Re: oracle database link
As someone already indicated, why do you want to run db link command from CF. It should be just a one time thing that your DBA can run. Later you can run query against a table in linked database like this SELECT * FROM On Wed, Aug 4, 2010 at 9:58 AM, Won Lee won...@gmail.com wrote: I assume you mean a link from one oracle schema to another schema by executing the CREATE DATABASE LINK sql command through a CFML page. Is this correct? If it is check your permissions. This most likely has nothing to do with CF. As I side note, I don't think CFML pages should be running this sort of code. You should just login to your Oracle DB and run that command to create a link. Curious? Is there a reason why you just don't create a new CF datasource in the CF ADMIN? On Wed, Aug 4, 2010 at 9:11 AM, Dave P jda...@gmail.com wrote: Hello all, Has anyone actually gotten a database link working from a CF server to a second oracle server? I'm trying a connection string: create database link prodlink connect to myusername identified by mypass using 'PROD'; and getting: Error Executing Database Query. Executing the SQL statement is not allowed. The problem is that I am not the admin and have little oracle experience. The DBA has little CF (or even web) experience. It sounds like to me there is a permissions error in either the oracle DB, or in CF. I'm not sure which. Of course i'm crunched for time. Any ideas? Thank you, Dave Powell ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: oracle database link
My last email was incomplete SELECT * FROMyourtableinlinke...@nameofdblink On Wed, Aug 4, 2010 at 8:25 PM, Qasim Rasheed qasim.li...@gmail.com wrote: As someone already indicated, why do you want to run db link command from CF. It should be just a one time thing that your DBA can run. Later you can run query against a table in linked database like this SELECT * FROM On Wed, Aug 4, 2010 at 9:58 AM, Won Lee won...@gmail.com wrote: I assume you mean a link from one oracle schema to another schema by executing the CREATE DATABASE LINK sql command through a CFML page. Is this correct? If it is check your permissions. This most likely has nothing to do with CF. As I side note, I don't think CFML pages should be running this sort of code. You should just login to your Oracle DB and run that command to create a link. Curious? Is there a reason why you just don't create a new CF datasource in the CF ADMIN? On Wed, Aug 4, 2010 at 9:11 AM, Dave P jda...@gmail.com wrote: Hello all, Has anyone actually gotten a database link working from a CF server to a second oracle server? I'm trying a connection string: create database link prodlink connect to myusername identified by mypass using 'PROD'; and getting: Error Executing Database Query. Executing the SQL statement is not allowed. The problem is that I am not the admin and have little oracle experience. The DBA has little CF (or even web) experience. It sounds like to me there is a permissions error in either the oracle DB, or in CF. I'm not sure which. Of course i'm crunched for time. Any ideas? Thank you, Dave Powell ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
Here is a great post by Joel on Distributed version control http://www.joelonsoftware.com/items/2010/03/17.html On Fri, Mar 26, 2010 at 5:38 PM, Ben Alembick benalemb...@gmail.com wrote: Wow guys thats a lot of info, really useful cheers. Ive just had a look at HG and cant even get it installed (not a good start), keep getting an error message after the install process when eclipse restarts, it attempts to open preferences and try's to save the mercurial section. Any way thats on the Mac, and GIT is working ok (just learning :-)) I will try both on the PC next week (time permitting). I really like the idea of not having to rely on a Central repository, so development can be done with no connection. Is it possible to work with SVN like this. So i Have a main SVN repo on a staging server and i also have svn on my laptop etc? (am i right in describing one possible GIT setup as like SVN having a MAIN Repo but also allowing the users themselves to have a repo?) Gonna have a read of the Books Won Lee and Denstar have recomended. Also a quick question. GITHUB provides the ability to keep a master repo there, is it possible to replace GITHUB with my own server? Im guessing you can, but could you give me some pointers which is the best way to approach this? Can i use RDS protocol to import / push the repo? Cheers really getting into this now. Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Thinking of a career change.. how does one get into Technical Recruiting..
Scott, I know your comments weren't directed towards anyone in particular and I have also seen the misuse of the program myself. However the thing that bothers me that people try to put all the blame on this program. I know, I came to this country legally, paid all my taxes for 7+ years and earned my green card. I hope we all appreciate the usefulness of real skills coming to this country (which I am now proud to call my second home). Thanks Qasim On Fri, Mar 13, 2009 at 4:44 PM, Scott Stewart sstwebwo...@bellsouth.netwrote: There's nothing wrong with the program, if as you said it's used appropriately. But it is a program that needs to be tightened up by the new administration so that there is less chance for abuse. Unfortunately it's a program that I've personally been burned by a couple of times. Qasim, I hope you understand that my comments don't reflect on you personally. -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Qasim Rasheed [mailto:qasim.li...@gmail.com] Sent: Friday, March 13, 2009 4:32 PM To: cf-jobs-talk Subject: Re: Thinking of a career change.. how does one get into Technical Recruiting.. What's wrong with H1B visa if used appropriately. I came to this country based on that facility and have been able to become a permanent citizen. On Fri, Mar 13, 2009 at 3:07 PM, Ravi Gehlot r...@ravigehlot.net wrote: Correct. There are good recruiters as there are bad ones. There are good and bad everywhere. So it is important to work with someone that you trust. Every programmer must do their own research. Ravi. Scott Stewart wrote: I've worked with both, if I do go down this road I know who I don't want to be and that the guy who recruits by attrition. I've been the recipient of the fishing email and phone calls dozens of times, and it's never panned out. Someone with horribly broken English calls about a job half way across the country and my first response is are they considering telecommuters, the answer is usually no, or what?. My next question is is your client willing to contract a relocation company to move myself and my wife and buy our house. The answer again is usually no, and then they ask if I'm willing to rent an apartment wherever the job is, my answer is always no, because by this point, their asking me to take a financial loss to work for their client. On the other hand there are a handful of recruiters with whom I have had very very successful relationships with, and one in particular who has become a pretty good friend.. why, because they're honest stand up people who look at prospective employment candidates as something more than just an email address or a means to fulfill US State Department guidelines, to bring in H1B Visas candidates. -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4209 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Using Subclipse on Eclipse
Here are steps 1. switch your local copy to trunk (Project - Team - Switch) 2. Merge your working copy (trunk) with the version xx On Sun, Feb 22, 2009 at 3:33 PM, Chad McCue c...@advmediaproductions.comwrote: I am confused on how to update my trunk from my working branch. Here are my steps below. Please let me know if I am not doing this correctly from the start. I am using subclipse and eclipse together. 1) I have created a repository (A) 2) In that repository I have created a trunk folder and branches folder. 3) I imported the latest version of my website that is in production into my trunk folder 4) I then created my version branch from my trunk within the branch folder of repository (A). So it looks like Repository A - Branches -Version1.2 - Trunk - Site Files 5) I then right-clicked on Version1.2 and did a checkout to my local CFEclipse project 'Version1.2 6) I made all my necessary changes that would be included in my new version. Tested it and everything is done. 7) I then Commit my changes from my working copy into my Version1.2 branch. My question now is how do I merge my Version1.2 branch changes back into the Trunk folder. This is to be done so when I create version1.3 in my branch folder from the trunk following the above method I get all the changes that would have been done in my 1.2 version. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: Jquery VISTA (IE)
Apologies for slightly off topic post but based on number of JQuery guru on this list, I thought someone might be able to shed some light. Here is the message that I posted on jQuery list few moments ago I am having a strange problem with performing a simple AJAX call on a Vista machine using IE as the browser. The same request work fine with Firefox on the same machine. Here is the sample code script src=jquery.js/script script $(function(){ $(#temp).load(test2.cfm); }); /script div id=temp /div The error I get in the script window will be Automation Server can't create object. Any idea? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is this a CF bug or just a Java behavior?
One of my fellow developer discovered some weird behaviour with ColdFusion number manipulation. Here is an example cfset a = 26.2 / cfset b = 20 / cfset c = a - b / cfoutput Value of c: #c# br / Is c EQ 6.2: #c EQ 6.2# br / ToString on c: #c.toString()# br / /cfoutput If you run this piece of code the first value will be 6.2, second will be a NO and then toString will result in 6.199. Isn't this a simple subtraction? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Decent Eclipse plugin for SQL editing?
Although I haven't used it myself but MyEclipse comes with a DB plugin which looks nice. On Wed, Jun 25, 2008 at 2:10 PM, Nathan Strutz [EMAIL PROTECTED] wrote: Mark, I tried out the Eclipse Data Tools plugin a while ago and blogged it here: http://www.dopefly.com/techblog/entry.cfm?entry=243 nathan strutz http://www.dopefly.com/ On Wed, Jun 25, 2008 at 6:43 AM, Gaulin, Mark [EMAIL PROTECTED] wrote: Hi I'm looking for an Eclipse plugin (for 3.2) that will do syntax highlighting and such for SQL (T-SQL specifically, but I don't care about that), specifically for *.sql files. I tried SQL Explorer but it does a pretty lame job of syntax highlighting while editing existing sql files... it appears to need something like CFE's refresh syntax highlighting because only the lines you actually edit get highlighted and the rest are plain text. There are other plugins out there but I value this group's opinions. Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: deploying and using jar files
Have you tried putting the jar in this path C:\ColdFusion8\wwwroot\WEB-INF\lib Thanks On Wed, Jun 25, 2008 at 5:56 PM, Doug Boude (rhymes with 'loud') [EMAIL PROTECTED] wrote: Okay, from what I've read thus far, deploying a jar file is so easy that even a monkey could do it. As I understand it, if I drop the jar file into the /lib directory and then restart CF 8, it will magically be available to me. Only, I must be missing something because this hasn't been the case. Here are the details: I am working on a project that requires the use of java proxies. I am in the process of setting up my local environment using CF8 developer edition, standalone. I drop the jar file (Wdqc00sm.jar) into the /lib directory and restart. I then attempt to execute a template with two lines in it: cfset objSecurity = createobject(Java,Wdqc00sm.Abean.Wdqc00s1SecurityAuthorization).Init() cfdump var=#objSecurity# and promptly get the error: Object Instantiation Exception. An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. Error: com/ca/gen75/jprt/ProxyException. Now, if I take the exact same template and execute it on the remote dev server where CF8 is running J2EE style on Linux (which I can't develop on due to other issues), with the same jar file deployed there, the object is created and dumps just fine. SO, can anybody tell me what I have to do to successfully install/deploy this jar file locally? Any input is MUCH appreciated. :) Doug ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: delete duplicates.
I am sure there are few udf on cflib.org that can be used. Have you looked there? HTH On Wed, May 21, 2008 at 3:08 PM, morchella [EMAIL PROTECTED] wrote: i have some duplicates in a list i need to delete but am not getting it once again. cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter cfoutput group=specs_partnum cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)# cfset acccL = ListSort(#acccL#,text, ASC) #acccL# /cfoutput/cfloop br /br / /cfoutput spits out: Cable Management 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 9970271 9970271 9970271 thanks guys. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's wrong with this query?
This is something that I would do on Oracle INSERT INTO t_table (tableid,table_name) SELECT 1 AS tableid , 'Table1' AS tablename FROMdual WHERE NOT EXISTS ( SELECT1 FROMt_user u WHERE u.tableid = 1 ) On Fri, May 16, 2008 at 11:12 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Not being so well-versed in indexing (just starting using those in MySQL 5), I don't understand how having a unique index on the photo_filename column will prevent an insert of a duplicate value. Is that function a part of creating a unique index? Does it cause MySQL 5 to screen inserts for duplicates and reject them? ??? Rick -Original Message- From: Didgiman [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 11:04 AM To: CF-Talk Subject: Re: What's wrong with this query? You could always create a unique index on the photo_filename column. Wim. On Fri, May 16, 2008 at 4:57 PM, Aaron Rouse [EMAIL PROTECTED] wrote: When I have done this, I used a NOT EXISTS, so something like this random example I just pulled from Google: http://archives.postgresql.org/pgsql-general/2003-06/msg01683.php On Fri, May 16, 2008 at 9:40 AM, Rick Faircloth [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's wrong with this query?
I meant this how you can write a similar query in Oracle. On Fri, May 16, 2008 at 11:17 AM, Qasim Rasheed [EMAIL PROTECTED] wrote: This is something that I would do on Oracle INSERT INTO t_table (tableid,table_name) SELECT 1 AS tableid , 'Table1' AS tablename FROMdual WHERE NOT EXISTS ( SELECT1 FROMt_user u WHERE u.tableid = 1 ) On Fri, May 16, 2008 at 11:12 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Not being so well-versed in indexing (just starting using those in MySQL 5), I don't understand how having a unique index on the photo_filename column will prevent an insert of a duplicate value. Is that function a part of creating a unique index? Does it cause MySQL 5 to screen inserts for duplicates and reject them? ??? Rick -Original Message- From: Didgiman [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 11:04 AM To: CF-Talk Subject: Re: What's wrong with this query? You could always create a unique index on the photo_filename column. Wim. On Fri, May 16, 2008 at 4:57 PM, Aaron Rouse [EMAIL PROTECTED] wrote: When I have done this, I used a NOT EXISTS, so something like this random example I just pulled from Google: http://archives.postgresql.org/pgsql-general/2003-06/msg01683.php On Fri, May 16, 2008 at 9:40 AM, Rick Faircloth [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmail won't send
If you have access to CF Admin that try verifying the mail server first. On Fri, Apr 25, 2008 at 3:08 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Are you seeing any messages show up in your mail spool folder? Any error messages in the CF Admin logs? Rick -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:48 PM To: CF-Talk Subject: cfmail won't send Is there anything wrong with this? I know the code is called, but I've not been receiving the emails. cfmail TO = [EMAIL PROTECTED] FROM = [EMAIL PROTECTED] REPLYTO = [EMAIL PROTECTED] SUBJECT = Expenditure Request Received TIMEOUT = 30 SERVER = mail.umd.eduWe will respond within 1 working day. If there is a problem, contact Vanessa Greer at (301) 405-2113. Your request number is #get_id.id#. Thank you. /cfmail thanks. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 Web Server Configuration
Hello everyone, Here is my OS configuration Windows 2003 Server ColdFusion 8 0 JRun install with multiserver I set up two sites on IIS and was able to configure one of them with one instance of CF8. However now the Web Server Configurator won't start. I clicked the option on Start and it shows me the existing configured web server but when I click Add it just never respond, Any idea? Thanks Qasim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Web Server Configuration
Doug, Thanks for responding. I did tried the manual configuration option by 1. first using wsconfig.exe on the command line with appropiate parameters but it still went to infinity and never returned. 2. I've also tried the technique described here but no luck. http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18724sliceId=2#iis Although when I tried option 2, Web Server Connector was showing me two configured server. However the IIS website stopped responding by just serving blank pages for html and download for any page with .cfm extension. Any idea? Thanks Qasim On Thu, Apr 17, 2008 at 2:57 PM, Doug Arthur [EMAIL PROTECTED] wrote: Is the problem with \bin\wsconfig.exe? If so, you may want to try and manually configuring your web server. Although, I wouldn't recommend to go that route, but if wsconfig.exe is locking up, I don't know why that would be. If you need help manually configuring, I can help you out. - Doug -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Thursday, April 17, 2008 12:00 PM To: CF-Talk Subject: CF8 Web Server Configuration Hello everyone, Here is my OS configuration Windows 2003 Server ColdFusion 8 0 JRun install with multiserver I set up two sites on IIS and was able to configure one of them with one instance of CF8. However now the Web Server Configurator won't start. I clicked the option on Start and it shows me the existing configured web server but when I click Add it just never respond, Any idea? Thanks Qasim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OutofMemoryError
I would second Brad's comment about using DB's mechanism to build XML. We use Oracle at work here and with various XML function available in 10g release, most of our XML is generated from SQL queries. Thanks Qasim On Tue, Apr 15, 2008 at 11:24 AM, Joel Watson [EMAIL PROTECTED] wrote: Brian-- These links look great! The ExportDbToXml.cfc is actually just what I needed. Unfortunately, I am still receiving an error when performing this function: Stream closed: The error occurred in \com\FileWriter.cfc: line 118 Called from \com\ExportDbToXml.cfc: line 272 Called from \com\ExportDbToXml.cfc: line 55 Called from \reports\alldata.cfm: line 5 Called from \reports.cfm: line 173 Called from \reports.cfm: line 1 116 : cfargument name=strIn type=string required=No default= hint=a string to write to the file / 117 : 118 : cfset variables.joBufferedWriter.write(javaCast(string, arguments.strIn)) / 119 : cfset variables.joBufferedWriter.newLine() / 120 : /cffunction Now into Java, I am completely out of my knowledge set, so your continuing help would be greatly appreciated! Thanks! Joel Watson How are you creating the XML variable? Becuase if you are building it up manually by concatenating strings together this is common. This is because every time you concatenate a string it creates a new Java String instance, which means you have (depending on how many columns you have) hundreds of thousands or even millions of String instances that won't be garbage collected until after the request is over and all references to them are gone. Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to build up the XML string, as these are specifically for building up large strings without constantly creating new instances. You can find easy CFC wrappers for these and other Java classes at http://www.informationsavvy.com/coldfusion/. On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Forcing a CFC to refresh...
I believe refreshWSDL was added in CF8. For earlier version, this blog post might help you. http://www.bpurcell.org/blog/index.cfm?mode=entryENTRY=965 HTH 2008/4/15 João_Fernandes [EMAIL PROTECTED]: Develop locally but if you want to force to refresh a webservice try cfset ws = createObject('webservice', someUrl, { refreshWSDL=yes } ) -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303493 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfform format=flash onload
This works for me on CF8 cfform format=flash skin=haloblue onload=password.setFocus() cfformgroup type=horizontal id=myUID cfinput name=UserID width=200 maxlength=50 required=yes value= type=text cfinput name=password width=200 maxlength=50 required=yes value= type=text /cfformgroup /cfform On Tue, Apr 15, 2008 at 4:42 PM, James Blaha [EMAIL PROTECTED] wrote: Greg, When you run your code in your environment then do a page refresh is the cursor blinking in the text field? -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Migrating to Application.cfc
Barney, I would be interested in knowing what are the weaknesses in Application.cfc based on your expertise. Thanks On Thu, Apr 10, 2008 at 12:47 PM, Barney Boisvert [EMAIL PROTECTED] wrote: As long as you use the same application name, the application has no awareness of an Application.cfm/cfc distinction. Only the Application.* file itself is different. Both have strengths and weaknesses. cheers, barneyb On Thu, Apr 10, 2008 at 9:38 AM, Jeff Price [EMAIL PROTECTED] wrote: This is not a question about the structure of an Application.cfc, I've got that down. No problem. This is about taking a bunch of apps that use the same application scope but different Application.cfm files, and converting them one by one to Application.cfc. All of these have the same Application scope of MyApp so the user only has to log into one app, and they are thus logged into them all. tools/calc/Application.cfm tools/time/Application.cfm apps/funstuff/Application.cfm Now, my question is...what happens if I change one those to use Application.cfc and leave the others at Application.cfm. Am I asking for a world of hurt and hidden consequences? or will everything play nicely together. I would still have to worry about values being overwritten and other enjoyable bugs like that. :) Thanks in advance. -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 and log4j
I've a project on riaforge related to log4j. You might want to take a peek at it cflog4j.riaforge.com HTH On Thu, Mar 27, 2008 at 3:58 AM, vishnu prasad [EMAIL PROTECTED] wrote: how to use classloader . can u give me sample code snippet? You will have to use a classloader to use a version other than that supplied with CF 7. On Thu, Mar 27, 2008 at 4:11 PM, vishnu prasad [EMAIL PROTECTED] wrote: hi last post is not displaying in Houseoffusion , it display the message The page you are looking for does not exist at this location. some one has replied but i cant see the msg, hence positing it again . Hi Cfgurus we are facing a problem in CF7 server when we access the third party Java API which uses the log4j 1.29 version -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com. au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 and log4j
The link was on the external i.e. http://code.google.com/p/cflog4j/ I've used the latest version of log4j with this app. On Thu, Mar 27, 2008 at 10:29 PM, vishnu prasad [EMAIL PROTECTED] wrote: There is no download link? r u using the latest version of log4j or using the one shipped with Coldfusion? I've a project on riaforge related to log4j. You might want to take a peek at it cflog4j.riaforge.com HTH On Thu, Mar 27, 2008 at 3:58 AM, vishnu prasad [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Reg ex question
My regular expression skills are quite limited so before spending hours on this, I thoughy may be someone can help me with this piece. [HEAD] titleMy Home Page/title link href=style.css rel=stylesheet type=text/css / [/HEAD] [BODY] h1Home Page/h1 [/BODY] I need a regular expression that will give me everything inside [HEAD} tags without the tags. Thanks -- Qasim Rasheed ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reg ex question
Jay, Thanks for a quick response. It does work however if I add body as another regex, the head section shows up in body. e.g. cfsavecontent variable=wholestring [HEAD] titleMy Website/title link href=view/_css/style.css rel=stylesheet type=text/css / [/HEAD] [BODY] h1Home Page/h1 [/BODY] /cfsavecontent !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head cfoutput#reReplaceNoCase(wholestring,'\[HEAD\](.+)\[/HEAD\](.*)','\1')#/cfoutput /head body cfoutput#reReplaceNoCase(wholestring,'\[BODY\](.+)\[/BODY\](.*)','\1')#/cfoutput /body /html Thanks On Tue, Mar 18, 2008 at 12:11 PM, James Smith [EMAIL PROTECTED] wrote: Assuming you meant HEAD and not [HEAD] you can use... reReplaceNoCase(thisPage.string,'HEAD(.+)/HEAD(.*)','\1') If you meant to use square brackets it will change to... reReplaceNoCase(thisPage.string,'\[HEAD\](.+)\[/HEAD\](.*)','\1') -- Jay On Tue, Mar 18, 2008 at 3:52 PM, Qasim Rasheed [EMAIL PROTECTED] wrote: My regular expression skills are quite limited so before spending hours on this, I thoughy may be someone can help me with this piece. [HEAD] titleMy Home Page/title link href=style.css rel=stylesheet type=text/css / [/HEAD] [BODY] h1Home Page/h1 [/BODY] I need a regular expression that will give me everything inside [HEAD} tags without the tags. Thanks -- Qasim Rasheed ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cheap CF8 hostings
I am running my personal site with GlobalOneHosting which offer CF8 with mySQL at a very reasonable price. http://www.globalonehosting.com/index.cfm HTH Qasim Rasheed On Fri, Mar 14, 2008 at 8:17 AM, Robert Rawlins [EMAIL PROTECTED] wrote: Hi Ali, I've got both shared accounts and dedicated servers with www.crystaltech.com. They're very affordable and there technical support is second to none, they come highly recommended, I know quite a few other cf developers use them and I've never heard anything but positive feedback about them. They will also fit your $200 a year budget. Take a look at the site and see if it takes your fancy. Robert -Original Message- From: Ali [mailto:[EMAIL PROTECTED] Sent: 14 March 2008 12:09 To: CF-Talk Subject: cheap CF8 hostings Hi: Is there any CF8 shared hosting company which has cheap windows hosting plans for small CF sites? Ideal prices will be under 200$ a year shared web hosting. Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Paperthin's Commonspot
Scott, I am not sure if it is true that Fed Govt will say no to any open source. We are using FarCry here on one of our largest public website for a Federal Govt Agency. Thanks Qasim On Jan 31, 2008 2:42 PM, Scott Stewart [EMAIL PROTECTED] wrote: The feds general rule on Open Source is no. Exceptions being Apache, Sendmail and the like because either they offer paid support or there's a third party authority who can provide support. I've downloaded FarCry, I'll play with it, but they really want something retail.. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Matthew Williams [mailto:[EMAIL PROTECTED] Sent: Thursday, January 31, 2008 12:55 PM To: CF-Talk Subject: Re: Paperthin's Commonspot For my needs FarCry is out of the question because it's open source (most federal agencies poo poo anything that's open source off the bat, because of support issues). Actually, that's not a completely accurate statement. The Daemonites have released FarCry to the public under an open source license, true. However, most of the work done to the FarCry core is paid for by their clients. Support, training, implementation, modification can all be obtained through Daemon. It's like other commercial offerings this way, but I'd venture a guess that Daemon is more willing to help when it comes to system modification. Now, will it meet your requirements the same way as CommonSpot? Depends on your needs. My understanding of CommonSpot is that it makes importing existing content easy (at least according the docs). You can use a WYSIWIG editor to modify templates (again, from what I saw in the docs). You can have a single authoring server and multiple front ends. These are things that FarCry does not do (yet). I'm curious about this myself. I'll be meeting one of Dave Watt's team members in the near future for a CommonSpot install. However, I'm only responsible for the machine it resides on. I'll not be doing any development on it. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excel to Query
Here is a post by Jason (CF Product Manager) discussing the use of JExcel with ColdFusion http://www.cfinsider.com/index.cfm/2008/1/3/Modify-Excel-Spreadsheets-with-ColdFusion-the-easy-way HTH Qasim On Jan 28, 2008 10:26 AM, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: Ben Nadel created a very nice cfc called POIUtility.cfc. This ColdFusion component works with POI to read/write excel spreadsheets. Please look this link: http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm Cheers Marco Antonio On Jan 28, 2008 6:56 AM, Richard White [EMAIL PROTECTED] wrote: Hi, we purchased a cfx called excel2query as we are developing an import facility that allows users to import data out of an excel document into the mysql database. we have to do it into a query as then we run various verifications on the data. however we have noticed that it gets the data that ms excel stores and not what it displays. for example, in excel someone may put integer values 1,2,3 etc... in a column then they use the format cell to display it how they want, e.g. they may format these integers to a number with 1 decimal point. we need to get these formatted values and not just what they entered first. does anyone know of anyway we can get ms excel to store the values it has formated or any other tag that converts ms excel data to a query and gets the actual displays value after formatting? thanks very much for your help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ant Subversion
Dan The error indicate that SVN jar files aren't being located by your build file. I usualy place those under ANTINSTALLATION/lib so that any project can use it. Thanks Qasim On Jan 18, 2008 5:30 PM, Andrew Scott [EMAIL PROTECTED] wrote: If it was me I would use ants built in zipping feature, and place it in the build.xml file. The added overhead to svn to that is overkill and unecessary overhead. On 1/19/08, Dan Vega [EMAIL PROTECTED] wrote: Today I was trying to setup svnant and subversion. I basically want to be able to create a zip file of a project anytime I want one. I was reading a good article today here http://www.phillnacelli.net/blog/index.cfm/2007/1/28/ANT-Builds-and-Subversion-SVN The problem Is I could not get it to work and kept getting the following error. I keep getting the error Could not load definitions from resource svntask.properties. It could not be found. Anyone use svnant know why this could be happening? Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: JavaScript version of listContains()
sorry, I responded too quick. This will actually be ListFind and not ListContains. On Jan 18, 2008 2:32 PM, Qasim Rasheed [EMAIL PROTECTED] wrote: I am hoping this will work function ListContains(list,item,delim){ var del = (delim == null)? ,: delim; return list.split(del).indexOf(item) != -1; } On Jan 18, 2008 12:38 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Jan 18, 2008 9:35 AM, Claude Schneegans [EMAIL PROTECTED] wrote: that's not to say there's not a simple way tho. The only other way I can think of is using regExp, but not really simpler. yeah, i thought about using subStr... but then you'd have to check for an optional comma in front and an optional comma behind to account for first/last elements... and at that point you enter the realm of regExp, so i'd wuss out and just do the loop :) -- Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter. - Dave Barry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: JavaScript version of listContains()
I am hoping this will work function ListContains(list,item,delim){ var del = (delim == null)? ,: delim; return list.split(del).indexOf(item) != -1; } On Jan 18, 2008 12:38 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Jan 18, 2008 9:35 AM, Claude Schneegans [EMAIL PROTECTED] wrote: that's not to say there's not a simple way tho. The only other way I can think of is using regExp, but not really simpler. yeah, i thought about using subStr... but then you'd have to check for an optional comma in front and an optional comma behind to account for first/last elements... and at that point you enter the realm of regExp, so i'd wuss out and just do the loop :) -- Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter. - Dave Barry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Hosting
James Thanks for your valuable suggestion however since this will be for my personal site which doesn't get much traffic except for few family members I am looking for the cheapest option available. That was the reason I asked for efree2net.com in my original post as they seems to advertise pretty decent plan at a cheaper price. Any one has any experience with them or does most people here uses high end host for their personal blogs etc? Regards Qasim On Jan 13, 2008 4:13 AM, James Holmes [EMAIL PROTECTED] wrote: If you're sick of shared hosting you can get a VPS with Viviotech. Bluedragon works out quite cheap this way and for a higher spend you can get CF7 or CF8. On Jan 13, 2008 11:17 AM, Qasim Rasheed [EMAIL PROTECTED] wrote: I know this topic has been beaten to death but my current host xtreme-host have run out of business. Any recommendation for a cheap host? Does anyone has any experience with efree2net.com? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Hosting
I know this topic has been beaten to death but my current host xtreme-host have run out of business. Any recommendation for a cheap host? Does anyone has any experience with efree2net.com? Thanks in advance Qasim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 + Apache Virtual host
Hi, I am having a hard time configuring Apache Virtual host with ColdFusion 8. Here is my setup 1. Windows XP. 2. Apache 2.2.6 3. ColdFusion 8 - Multi instance. Here is what I've done till now 1. Installed Apache and CF8 with JRUN. 2. Create a new CF intances in CF Admin 3. Ran the Web Connector for Apache and the two virtual host can connect to CF successfully. Here is the VH definitions VirtualHost *:80 ServerAdmin [EMAIL PROTECTED] DocumentRoot E:\apachesites\qasim ServerName qasimrasheed.local ServerAlias www.qasimrasheed.local ErrorLog logs/qasimrasheed.local-error.log Directory / Order Allow,Deny Allow from all /Directory /VirtualHost VirtualHost *:80 ServerAdmin [EMAIL PROTECTED] DocumentRoot E:\apachesites\qasim1 ServerName qasimrasheed1.local ServerAlias www.qasimrasheed1.local ErrorLog logs/qasimrasheed1.local-error.log Directory / Order Allow,Deny Allow from all /Directory /VirtualHost Here is how ColdFusion connector added things to Apache conf. IfModule mod_jrun22.c JRunConfig Verbose false JRunConfig Apialloc false JRunConfig Ignoresuffixmap false JRunConfig Serverstore C:/JRun4/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51020 #JRunConfig Errorurl url optionally redirect to this URL on errors #JRunConfig ProxyRetryInterval 600 number of seconds to wait before trying to reconnect to unreachable clustered server #JRunConfig ConnectTimeout 15 number of seconds to wait on a socket connect to a jrun server #JRunConfig RecvTimeout 300 number of seconds to wait on a socket receive to a jrun server #JRunConfig SendTimeout 15 number of seconds to wait on a socket send to a jrun server AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf /IfModule Ok now I commented the serverstore and bootstrap from above and added these to individual Virtual Host. However it doesn't work and I see these errors in Apache log files [Sun Jan 06 19:29:29 2008] [notice] jrApache[6472: 35340] can't retrieve servers from server, no bootstrap specified. [Sun Jan 06 19:29:29 2008] [notice] jrApache[6472: 35340] can't load servers from serverstore, no serverstore specified. [Sun Jan 06 19:29:29 2008] [notice] jrApache[6472: 35340] can't persist servers, no serverstore specified. [Sun Jan 06 19:29:29 2008] [notice] jrApache[6472: 35340] Couldn't initialize from remote server, JRun server(s) probably down. [Sun Jan 06 19:29:29 2008] [notice] jrApache[6472: 35340] JRun will not accept request. Check JRun web server configuration and JRun mappings on JRun server. Thanks. Any help is greatly appreciated. Qasim. -- Qasim Rasheed Certified Advance ColdFusion MX Developer (IM qasimrasheed AT yahoo, msn or GTalk) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 + Apache Virtual host
James, Those are before IfMoule section, however if I do not specify anything on each Virtual Host they can all connect to the single CF server successfully. Regards Qasim On Jan 6, 2008 9:20 PM, James Holmes [EMAIL PROTECTED] wrote: Are the Virtual Host definitions before or after the IfModule section in the file? On Jan 7, 2008 9:36 AM, Qasim Rasheed [EMAIL PROTECTED] wrote: Hi, I am having a hard time configuring Apache Virtual host with ColdFusion 8. Here is my setup 1. Windows XP. 2. Apache 2.2.6 3. ColdFusion 8 - Multi instance. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 2008 conferences of interest
Rick, I cannot find the list of topics and schedule on flex360 website. Is it something that is still unknown? Thanks Qasim On Jan 4, 2008 8:18 AM, Rick Root [EMAIL PROTECTED] wrote: I've been given official permission to attend 360|Flex in Atlanta next month. Booked my room at the Omni Hotel at CNN Center yesterday. The 360|Flex web site doesn't do a particularly good job publishing the discount code for their block of rooms.. but it's there if you hunt via google :) Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT:Flex Training
Sorry for being slightly OT. Does anyone has recommendations for Flex training with emphasis on using ColdFusion at the back end? Thanks -- Qasim Rasheed (IM qasimrasheed AT yahoo, msn or GTalk) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query columnCount
ListLen( query.columnlist ) On 11/13/07, Richard White [EMAIL PROTECTED] wrote: Hi, hopefully this is a very simple question. i cant find the answer on google :( how do i count how many columns were returned in a cfquery thanks ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Market Dept - Project Management help
http://www.pcuf.fi/~pjt/pink/software-architecture.html On 11/2/07, Kevin Aebig [EMAIL PROTECTED] wrote: Here's how I've dealt with that issue and thus far, it's practically not a problem anymore. - Strict Documentation that needs to be signed off. If they wish other features be added, the deadline gets pushed back. Otherwise it's something that can be taken care of down the road. If it wasn't important enough to remember during the last phase of planning, than it isn't important enough to lose sleep over. - Quote double the amount of time it will take you. Explain to them the reason for this is because many different things can go wrong and you want to be sure that you can deliver on time. You can mention that it's likely that if everything goes well the project will be done early to appease them. If they aren't happy with that, than this would be the time to mention that a lack of planning on their part doesn't constitute an emergency on yours. Hold your ground. Don't give into the guilt they'll try to put on you because it's only setting a precedent that they'll be able to take advantage of you. Just remember that many people don't learn unless there's a consequence and the fact that you continue to bail them out isn't helping the matter. They don't think anything is wrong, because they aren't suffering and the projects are going out on time... at your expense. Cheers and good luck, !k -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 9:50 AM To: CF-Talk Subject: Market Dept - Project Management help All, Do you work in a Marketing department? Do you have more than a few people giving you requests for projects? I'm not talking about text and images or content managment, but custom applications. Ever work with someone that gives you bits and peices of a project and then make multiple changes and edits after the project document has been defined? I need a application/process that is simple enough for Marketing people to use that will force them to organize their projects before they even get to the Web team. The amount of time that is wasted revisting projects for multiple changes is rediculous! Then they ask the Web team why a project isn't completed. FRUSTRATING! Any feedback to get these non-technical marketing people more organized would be great! Pulling my hair out! Thanks D ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Returning and object from a Web Service
Dean, A shot in the dark, but do you have cfproperty .. defined for the attributes of your User object that you are trying to return? Thanks Qasim On 10/26/07, Dean Lawrence [EMAIL PROTECTED] wrote: What type of CFC object are you trying to return... More the case is it in the same directory as the webservice? Or does it use a mapping? If a mapping, try using a CFC that is in the same directory as the web service. It is a simple User object that I created (usrname, password, etc.). It is located in a subdirectory below the web service itself. I can call it and use it within the webservice method call, but if I try to return it directly or as an element of an array (i.e. cfreturn User /), I get the error message that I originally posted. Instead I need to break it apart and either need to return individual element values, place each value into a structure, or return a query instead. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: column totals
I would move this total logic to the actual query i.e. SQL which will be the most efficient IMHO. HTH Qasim On 10/15/07, Ben Doom [EMAIL PROTECTED] wrote: I don't know about actual cycle efficiency, but arraysum(query['row']) is what I use. Very good on typing efficiency. :-) --Ben Doom Toby King wrote: Hi there I have an application where I am outputing a number of sales figures for a year for various departments. Basically the table that I am outputing is in this format: Dept July Aug SepOctNov DecTotal A 23 24 20 18 15 50 150 B 20 20 20 20 20 20 120 C 10 10 10 10 10 10 60 Total xxx xxx xxx xxx xxx xxx xxx Basically I have not had any trouble creating the total for the end of the row - I have created an array and just added to the array and then I get the total. I am struggling with obtaining the total for the bottom of the columns. What would be the most efficient way to do this. Thanks in advance. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CPU spiking, possible bad loop or conditional statement
SeeFusion FusionReactor are the one that come to mind if you are looking for a server monitoring utility. HTH Qasim On 10/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: All, Can anyone recommend a server monitoring tools for a CF MX install that all of a sudden is creating the CPU to spike and the CF server is maxing out? Thanks for any direction. D ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Killing a login
If you are on CFMX, you can use J2EE session which will expire on browser close. HTH On 10/12/07, Richard Colman [EMAIL PROTECTED] wrote: I am trying to provide a logout function on my site. I have tried various combination like: cfcookie name = UserID value = #session.client_id# expires = NOW cfset structDelete(cookie,'UserID') / CFSET temp=structDELETE(session, 'level') CFSET temp=structDELETE(session, 'loginok') CFSET temp=structDELETE(session, 'client_id') CFSET temp=structDELETE(session, 'lname') CFSET temp=structDELETE(session, 'fname') But the login presists until the browser is closed. Is there any way to kill a login without exiting the browser? Any suggestions appreciated. Rick Colman ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Null Values
Instead of Stored procedure, you can simply do this CASE WHEN col is NULL THEN 'YOURINDICATORFORNULL' ELSE col END AS col HTH On 10/8/07, Richard White [EMAIL PROTECTED] wrote: perfect, thanks very much charlie :) in relation to the issue of null values being different to empty strings in the database, am i right by saying the only way to get round this would be to create a stored procedure that ran sql code to test for a null value or empty string then pass back a result to cf telling it whether it is null or an empty string? thanks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290576 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic named CFC and method
I believe this will work cfset cfc = application.aImage / cfset method = 'updateIm' / cfinvoke component=#cfc# method=#method# .. your arguments here cfinvoke HTH On 9/7/07, Andrew Grosset [EMAIL PROTECTED] wrote: Have you tried using cfinvoke? see where it says This works but I'm not accessing the cfc in the application scope which rather defeats the purpose of writing it into the application scope. there is a cfinvoke example. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query speed diference
If your DB is Oracle, you can easily use MERGE SQL command for this purpose. HTH Qasim On 8/30/07, Nick de Voil [EMAIL PROTECTED] wrote: Jay Which of these two methods would be faster? - Method 1 - cfquery SELECT * FROM table WHERE someID = #someVar# /cfquery cfif query.recordCount IS 1 cfqueryUPDATE table.../cfquery cfelse cfqueryINSERT INTO table.../cfquery /cfif - Method 2 - cfquery DELETE FROM table WHERE someID = #someVar# /cfquery cfqueryINSERT INTO table.../cfquery You can achieve an improvement by either: - changing your logic so that you know whether to do an update or insert without needing to check the record ID against the database; or - whichever of the 2 methods you use, combining the 2 SQL statements into one stored procedure or at least one CFQUERY. Nick ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Forcing a session to end...
StructClear( session ) On 8/2/07, James Smith [EMAIL PROTECTED] wrote: Is there any way to end a session when a logout link is clicked? I have tried... cfset temp = onSessionEnd(session,application) cfapplication name=application sessiontimeout=#createTimeSpan(0,0,0,0)# But it leaves the session scope fully populated. I have even tried... cfset temp = onSessionEnd(session,application) cfapplication name= application sessiontimeout=#createTimeSpan(0,0,0,0)# cfset temp = structClear(sesion) cflocation url=/ But that doesn't work either. I am sure I am missing something simple but this is driving me nuts! -- Jay ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Writing large data files
I have released a UDF over at cflib.org, that will convert a ColdFusion query to CSV using JavaString Buffer which is considerably faster. http://www.cflib.org/udf.cfm?ID=1197 Thanks and let me know if you have any problem. Qasim On 7/24/07, Garth Young [EMAIL PROTECTED] wrote: Hi, There have been previous posts about writing large data files from database queries and I have the same problem. The files I need to create may be up to 200-300MB in size (csv). I haven't tried in off-peak time but when I tried a large queries during normal hours it got a memory error. Does anyone know if there anyway to stream the results of a query which I can then write to a file? Java has been mentioned for the file write. Is there any way to stream the result of a query in java, ColdFusion or similar? One option is to write a file using PL/SQL but with the current secruity policies it looks to be a time consuming process to get the appropriate permissions in place. Cheers ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with Query
First write your sql as SELECT p.photoID, p.photoTitle, c.commentId, c.commentText FROMphotos p LEFT OUTER JOIN comments c ON c.photoid_fk = p.photoid ORDER BY p.photoID, c.commentID Then output the query using cfoutput and group like this ul cfoutput query=yourQuery group=photoID li#photoTitle#/li ul cfoutput li#commentText#/li /cfoutput /ul /cfoutput /ul HTH Qasim On 7/22/07, Joel Watson [EMAIL PROTECTED] wrote: I have two tables, photos and comments. Their structures are as follows: photos table -- photoID photoTitle comments table -- commentID commentText photoID_fk I need to write a query that will allow me to display all the records in photos while also displaying the comments that match up to each photoID record. Kind of like this: photoID 1 comment 1 comment 2 photoID 2 comment 3 comment 4 photoID 3 [no comments] photoID 4 comment 5 comment 6 And so on... Any help would be greatly appreciated. Thanks! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with Query
Joe, First of all I am not sure if you need LEFT JOIN for both comments and prices. My first example was based on the assumption that you could have photos without comments and you might want to display those as well. It will help if you can paste the entire query and your output code. Thanks Qasim On 7/22/07, Joel Watson [EMAIL PROTECTED] wrote: First write your sql as SELECT p.photoID, p.photoTitle, c.commentId, c.commentText FROMphotos p LEFT OUTER JOIN comments c ON c.photoid_fk = p.photoid ORDER BY p.photoID, c.commentID Then output the query using cfoutput and group like this ul cfoutput query=yourQuery group=photoID li#photoTitle#/li ul cfoutput li#commentText#/li /cfoutput /ul /cfoutput /ul HTH Qasim Actually, instead of only showing 1 record for each comments grouping, it repeats the entries to a weird number of iterations. So if there is one comment for photoID 16, it repeats that one entry 16 times... ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Incident Tracking
shamelessplug http://cfdefect.riaforge.com /shamelessplug I wrote this application based on light house using Fusebox 5, ColdSpring, Reactor etc as a fun exercise. Thanks Qasim On 7/20/07, Steve Good [EMAIL PROTECTED] wrote: Hey Gang, Before I go and put a project together, thought I would ask if something like this already exists. My support team needs a way to track various support incidents throughout the company. The only solutions I have seen were outdated PHP apps. The one I found that seemed to have the most promise is not working the way I want it to. Besides, I'm already running CF7, so I'd like to leverage that to my benefit. Thanks in advance, Steve Good ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: accessing log files programatically
Jonathon, I wrote a small utility to expand the logging functionality by using log4j. http://cflog4j.riaforge.org/ Hope that helps Qasim On 7/14/07, Jonathon Stierman [EMAIL PROTECTED] wrote: Anyone know of a good way to (1) get data out of the CF log files, and (2) archive the log files after getting the data? I poked around the Admin API hoping to find something related to logging in there, but no dice as far as I could tell. So relucatantly, I toyed around with doing cffile actions, which works alright to get the data. But writing back to the log file doesn't seem to have the desired effect. It doesn't seem to crash anything, but I do get some strange formatting issues (lots of extra white space for any error) for any errors that occur after I archive the log. What have you guys done to fetch data out of the log files programatically? Jonathon ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Structures... How Do I properly write this?
Use this cfloop from=1 to=#ArrayLen( xmlcontent.message.items.item )# index=x cfif NOT StructKeyExists( stWSSB_Tickler, x ) cfset stWSSB_Tickler[x] = StructNew() / /cfif cfif ( NOT StructKeyExists( stWSSB_Tickler[x], 'tickler' ) ) OR ( StructKeyExists( stWSSB_Tickler[x], 'tickler' ) AND stWSSB_Tickler[x].tickler neq 'Y' ) cfset stWSSB_Tickler[x].ord_qty = xmlcontent.message.items.item[x].ord_qty.xmlText / cfset stWSSB_Tickler[x].unit_price = xmlcontent.message.items.item[x].unit_price.xmlText / cfset stWSSB_Tickler[x].tickler = Y / /cfif /cfloop HTH On 6/14/07, Che Vilnonis [EMAIL PROTECTED] wrote: I fixed my typo but I'm still getting errors with the code below. The error I now get reads: Element 1 is undefined in a CFML structure referenced as part of an expression. I'm sure this is a simple fix... What am I missing? -Original Message- Basically, I have nested structures. I want to check if the nested structure exists first. If it does not exist, then I'll create it. Then I want to check if the nested structure's tickler value is Y. Obviously, my cfif logic is not correct. Thanks! cfif NOT isDefined(stWSSB_Tickler) cfset stWSSB_Tickler = structNew() /cfif cfloop from=1 to=#arrayLen(xmlcontent.message.items.item)# index=x cfif NOT structIsEmpty(stWSSB_Tickler[x]) cfif structFind(stWSSB_Tickler[x], tickler) NEQ Y cfset stWSSB_Tickler[x] = structNew() cfset stWSSB_Tickler[x].ord_qty = xmlcontent.message.items.item[x].ord_qty.xmlText / cfset stWSSB_Tickler[x].unit_price = xmlcontent.message.items.item[x].unit_price.xmlText / cfset stWSSB_Tickler[x].tickler = Y / /cfif /cfif /cfloop ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Information about pass Java ResultSet(or QueryTable) to Coldfusion QueryTable
I think Sean is right on target. Your own class return a QueryTable object and there is no constructor in ColdFusion QueryTable class that matches that argument. I would assume if you can modify your custom class to return a Java ResultSet object instead, it should work. Thanks Qasim On 6/13/07, Sean Corfield [EMAIL PROTECTED] wrote: On 6/13/07, Andrea Botta [EMAIL PROTECTED] wrote: cfset pra = createObject(Java, Pratica).init(glb,dbprop) cfset ourQuery =createObject(java, coldfusion.sql.QueryTable).init( pra.search()) Since pra.search() returns a QueryTable already, can't you just say this: cfset ourQuery = pra.search() Maybe the QueryTable constructor doesn't match how you're using it and ColdFusion cannot figure out how to construct it? -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large CSV File
Another option will be to use ODBC file connection if you are on windows. HTH On 6/12/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Eek! A file of that size and complexity needs to be handled by the database, putting it into an array would be a nightmare. It would be fine for smaller files, but something that size would probably push the server over. Les, what database are you using? *Crosses fingers he says something decent :-D I would import into the database and then do the manipulation there with stored procs for sure. Rob -Original Message- From: Phillip M. Vector [mailto:[EMAIL PROTECTED] Sent: 12 June 2007 15:06 To: CF-Talk Subject: Re: Large CSV File Is it all brand new records? or will most of the data after the first be already in there and need to be updated? I learned that the best way to parse it is to set up a upload once (using cffile) and then every week, load the csv file into an array and then compare it with the data already there. Of course, if it's always new data, see if you can convince them to do uploads every night so that you can handle the data without to much hit on your server. Les Mizzell wrote: I've got a vendor that's going to FTP product data files directly into a folder on a site. From there, I need to be able to run several different queries on this to come up with a list of PIN numbers which then get used elsewhere. I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 meg CSV text file! They FTP a new one once a week. What would be considered best practice in handling this file so i can run queries on it? Import the needed bits into a database (still a big chunk of data)? Something else? You can't directly query a CSV file, correct? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do you stay up on blogs?
I have been using Abilon on Windows for the past few years. HTH Qasim On 5/24/07, Ryan, Terrence [EMAIL PROTECTED] wrote: I'm a big fan of Sharpreader. It's desktop. It treats feeds similar to mail, in that you can read/delete individual entries. It will pop up notification of new feeds. Etc. But it doesn't make noise for you. Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escape single quote in Multiple Row Insert Problem
You can try using PreserveSingleQuotes function. HTH Qasim On 5/21/07, Les Mizzell [EMAIL PROTECTED] wrote: Doing a multiple row insert cfloop from=1 to=#int(request.numTRAVEL)# index=idx cfquery name=WRITE_ENROLL INSERT INTO mytable ( myNAME ) VALUES ( '#evaluate(form.myNAME#idx#)#' ) /cfquery /cfloop Works fine until somebody enters Bob O'Hara into the form. I'm having a little trouble trying to escape the single quote in O'Hara while keeping the rest of the query intact. If if was a single record insert something like the below would work fine: '#Replace(form[myNAME],','',ALL)#' Suggestions? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fusebox Help
Jordan, I am glad to be of help. There are several execution modes that govern a fusebox application lifecyle. It would definitely help you to look into this brief documenation. http://www.fusebox.org/index.cfm?fuseaction=documentation.WhatsNewInFusebox5 Although this mainly discusses Fusebox 5, but you will see various execution option for Fusebox 4 under Execution Mode section. Thanks Qasim On 5/15/07, Jordan Michaels [EMAIL PROTECTED] wrote: Just to follow up on this, I think Qasim's suggestion was right on the mark. I updated that Fusebox setting, cleared all the parsed files, and started surfing the site again. The random errors we were getting no longer appear present, and I'm crossing my fingers hoping they don't return. Thanks Qasim! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Jordan Michaels wrote: Hello Qasim, Thank you for this. I'm learning a lot about Fusebox as I work on this project. =) The fusebox.xml.cfm has the mode set to Development. I will try to do my research on what effect this has on the application as a while, but any additional pointers you could provide would be greatly appreciated! Thank you for this! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Qasim Rasheed wrote: Jordan, The autogenerated files should be in the parsed directory under your application root. This is where fusebox keeps generated files after it has gone through the compile process. If your site in development mode ( i.e. mode parameter in fusebox.xml.cfm file? Thanks Qasim On 5/14/07, Jordan Michaels [EMAIL PROTECTED] wrote: There we go. Fusebox 4. Thanks Josh. I completely agree with your comments as well. I'm not trying to imply anything about the stability of fusebox, but since neither I, or anyone in my shop has spent any large amounts of time working with Fusebox. I guess I was just wondering if anyone had seen this kind of behavior before. My (limited?) understanding of fusebox suggests that there are some pages which are interpreted, then written to the file system. I'm wondering if these seemingly random errors have anything to do with that process. Like perhaps wherever the problem lies is in the process that creates these files? Perhaps this process is not able to finish, or is finishing incorrectly each time the page is hit... and that results in the random code errors? That is where my thoughts are taking me at the moment anyway... Any insights anyone has would be immensely appreciated. ;) Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Josh Nathanson wrote: Has anyone seen this kind of behavior in a Fusebox site before? Any suggestions on where I should start looking for a problem cause? Since the errors appear to be random (go to page, click a link, get random error - go to page, click same link, get different random error) I'm not sure where to even begin. Jordan - the best way to at least figure out the version is to look for index.cfm in the root, open that file and see which core file it's calling (assuming they're using index.cfm as the main template). Fusebox in itself is not inherently buggy, but like any other framework, poor coding will lead to poor results. -- Josh ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fusebox Help
Jordan, The autogenerated files should be in the parsed directory under your application root. This is where fusebox keeps generated files after it has gone through the compile process. If your site in development mode (i.e. mode parameter in fusebox.xml.cfm file? Thanks Qasim On 5/14/07, Jordan Michaels [EMAIL PROTECTED] wrote: There we go. Fusebox 4. Thanks Josh. I completely agree with your comments as well. I'm not trying to imply anything about the stability of fusebox, but since neither I, or anyone in my shop has spent any large amounts of time working with Fusebox. I guess I was just wondering if anyone had seen this kind of behavior before. My (limited?) understanding of fusebox suggests that there are some pages which are interpreted, then written to the file system. I'm wondering if these seemingly random errors have anything to do with that process. Like perhaps wherever the problem lies is in the process that creates these files? Perhaps this process is not able to finish, or is finishing incorrectly each time the page is hit... and that results in the random code errors? That is where my thoughts are taking me at the moment anyway... Any insights anyone has would be immensely appreciated. ;) Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Josh Nathanson wrote: Has anyone seen this kind of behavior in a Fusebox site before? Any suggestions on where I should start looking for a problem cause? Since the errors appear to be random (go to page, click a link, get random error - go to page, click same link, get different random error) I'm not sure where to even begin. Jordan - the best way to at least figure out the version is to look for index.cfm in the root, open that file and see which core file it's calling (assuming they're using index.cfm as the main template). Fusebox in itself is not inherently buggy, but like any other framework, poor coding will lead to poor results. -- Josh ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help with java
Mike, Can you please explain what exactly is the problem or error you are receiving? Thanks Qasim On 5/14/07, Mik Muller [EMAIL PROTECTED] wrote: Last bump. No help here? --- A few months ago I posted some help requests for using Babylon Chat server and got some suggestions, but I'm just too flat out to adequately trouble-shoot this on my own. I need help and I'm willing to pay. And since this isn't a job type posting I thought I'd post my request here. Hope it's ok. I am having trouble getting a Java chat server app to run. I am vaguely familiar with what's involved and at stake, but I cannot get this thing to run. I'm using CF7 on Win2003Server. As I said, I am willing to pay someone to help me debug the issue and get the app running. For the person who knows what their doing java-server-wise, I'm sure this is a simple issue. Please contact me asap and we'll set something up for next week. Preferable if you have Skype and Unyte, or we can do a GoTo Meeting. Thanks, Mik Here's a passage from the help file: If you want to run the server, or run the client as a standalone Java application, then you will need to obtain/locate the command-line program called 'java'. After you have done this, you will need to set your CLASSPATH. This variable tells the Java software where to find all the parts of Babylon that it needs. After you download and/or build Babylon, you will have a file called 'babylon.jar'. You need to put the pathname of this file into your CLASSPATH variable. One convenient way to do this is to use the -classpath argument to the Java program, like so: java -classpath babylon-directory/babylon.jar babylon Otherwise, you should set the environment variable manually: For example, using 'csh' on a Unix-like system, you would do something like: setenv CLASSPATH babylon-directory/babylon.jar:$CLASSPATH Under DOS/Windows, it's more like this: set CLASSPATH=c:bablon-directory\babylon.jar;%CLASSPATH% Now you can start either a Babylon client, a server, or both. To start the client, invoke the Java program with the name 'babylon', plus any of the options shown: java babylon [-username name] [-password password] [-servername host] [-portnumber port] [-autoconnect] [-chatroom room] [-xsize width] [-ysize height] [-nopasswords] [-locksettings] [-hidecanvas] More info here: http://visopsys.org/andy/babylon/developers.html If anyone can help me get this thing running I'd be most appreciative. Michael Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Bluedragon Installation
Hello folks, I am hoping that someone on this list might be able to help me with the installation issues. I downloaded the Server JX from New Atlanta website and clicked through the installer with builtin webserver. However when I try to access url http://localhost:8080/bluedragon, I am faced with a 403 Forbidden error. I am running ColdFusion 5, ColdFusion 6.1, ColdFusion MX 7 (with IIS) and JRun+ColdFusion MX (with Apache) on same machine with no problem. Thanks in advance for your help. -- Qasim Rasheed Certified Advance ColdFusion MX Developer (IM qasimrasheed AT yahoo, msn or GTalk) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bluedragon Installation
Andrew, Thanks for the response. How do I set up permission for the directory for the built in web server? Qasim On 5/13/07, Andrew Scott [EMAIL PROTECTED] wrote: Sounds like a permission error for the directory that holds the pages. On 5/14/07, Qasim Rasheed [EMAIL PROTECTED] wrote: Hello folks, I am hoping that someone on this list might be able to help me with the installation issues. I downloaded the Server JX from New Atlanta website and clicked through the installer with builtin webserver. However when I try to access url http://localhost:8080/bluedragon, I am faced with a 403 Forbidden error. I am running ColdFusion 5, ColdFusion 6.1, ColdFusion MX 7 (with IIS) and JRun+ColdFusion MX (with Apache) on same machine with no problem. Thanks in advance for your help. -- Qasim Rasheed Certified Advance ColdFusion MX Developer (IM qasimrasheed AT yahoo, msn or GTalk) ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Java equivalent of CFHTTP ?
I'll sendong HTTPClient. Vey straight forward and easy to implement. On 5/11/07, Mark Drew [EMAIL PROTECTED] wrote: java.net.URL If I recall does most of this. MD On 5/11/07, Barney Boisvert [EMAIL PROTECTED] wrote: I've always used HTTPClient, both from Java and CF apps where CFHTTP wasn't sufficient. cheers, barneyb On 5/11/07, Yves Leung-Tack [EMAIL PROTECTED] wrote: HI, Is there an equivalent to CFHTTP in Java? I'd like to be able to call a Python script and receive its response. Any code example is welcome !! Thanks ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using .jar file with cfobject
Bruce try this cfset fso = CreateObject( 'java', 'java.io.FieOutputStream').init( CreateObject( 'java', 'java.io.File' ).init( 'e:/temp/tempimage.png' ) ) / Although in my opinion you are better off using a BufferedOutputStream as it is suppose to perform better. However I haven't work with batik. HTH Qasim On 5/8/07, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions [EMAIL PROTECTED] wrote: Don't seem to like that either. Get the same error message. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 4:11 PM To: CF-Talk Subject: RE: Using .jar file with cfobject cfset pngpath = e:\temp\tempimage.png Try e:/temp/tempimage.png. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Image Resize Code
I released an application for Image cropping, resizing on Adobe Exchange a while back. It uses Java Advance Image (JAI) API. Here is the link *http://tinyurl.com/2ax664 Thanks Qasim * On 5/4/07, Aaron Roberson [EMAIL PROTECTED] wrote: Does anyone know what Costco Photo Center is using for their image manipulation? You can change an image from color to bw, sepia and maybe polarize. It also does crop, rotate, brighten exposure, red-eye reduction, and you can apply borders. Here is a link: http://www.costcophotocenter.com/howitworks -Aaron ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL fieldnames
You can simply do this StructKeyList( URL ) HTH Qasim On 4/19/07, Richard Cooper [EMAIL PROTECTED] wrote: Cheer Rob, that'll do the trick. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need help with grouped query and inner cfoutput
I beleive your cfoutput group should match the sort order of the query. On 4/8/07, Will Tomlinson [EMAIL PROTECTED] wrote: I usually don't have problems with grouping and outputting data, but this one's got my number so far... With my db schema, a question can be related to more than one answer set. An answer set can be related to more than one question. An answer set can be related to more than one answer. An answer can be related to more than one answer set. All my questions work except the rankings. I'm trying to do this. Question: Rank your favorite colors. Answer set: Blue Answers: select options blah blah1,2,3,4/select Answer set: Green Answers: select options blah blah1,2,3,4/select etc.. etc.. Here's my query: SELECT tblquestionsets.questionsetid, tblquestionsets.questionsetname, tblquestions.questionid, tblquestions.questionsetid, tblquestions.question, tblquestions.questioncatid, tblquestions.questionsortnum, tblquestions.questionrequired, tblquestioncats.questioncatid, tblquestioncats.questioncatname, tblquestionsanswers_x.questionanswersetid, tblquestionsanswers_x.answersetid, tblquestionsanswers_x.questionid, tblanswersets.answersetid, tblanswersets.answersetname, tblanswersets.answersettypeid, tblanswersets.answersetrequired, tblanswersettypes.answersettypeid, tblanswersettypes.answersettypename, tblanswersetsanswers_x.answersetsanswersid, tblanswersetsanswers_x.answersetid, tblanswersetsanswers_x.answerid, tblanswers.answerid, tblanswers.answername, tblanswers.answervalue, tblanswers.answersortnum, tblquestionsets.questionsetdateadded FROM tblquestionsets, tblquestions, tblanswersets, tblquestionsanswers_x, tblanswersettypes, tblanswers, tblanswersetsanswers_x, tblquestioncats WHERE tblquestionsets.questionsetID = tblquestions.questionsetID AND tblquestions.questionid = tblquestionsanswers_x.questionid AND tblquestionsanswers_x.answersetid = tblanswersets.answersetid AND tblanswersets.answersetid = tblanswersetsanswers_x.answersetid AND tblanswersetsanswers_x.answerid = tblanswers.answerid AND tblanswersets.answersettypeid = tblanswersettypes.answersettypeid AND tblquestions.questioncatid = tblquestioncats.questioncatid AND tblquestionsets.questionsetID = 1 AND tblquestions.questioncatid = 3 ORDER BY tblanswersets.answersetid, tblanswers.answerid Here's my output: cfoutput query=getAdditionalQuestions group=questionID cfoutput #answersetname#br / cfselect name=Q_question#ctr# option value=#questionID#_#answerID##answername#/option /cfselect /cfoutput /cfoutput But here's what it outputs: http://wtomlinson.com/questionCap.jpg I need it to show just one answer set, but with the multiple answers in the dropdown. I've tried playing with all sorts of combinations, with no luck. Any ideas? Thanks, Will ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fusebox 5.1 + J2EE WAR deployment fails with encrypted templates.
Tero, It seems that you have encrypted fusebox.xml.cfm and other circuit.xml.cfmfiles. Those are essentially just XML which has a .cfm extension. HTH Qasim On 3/26/07, Tero Pikala [EMAIL PROTECTED] wrote: Hi I'm testing Fusebox 5.1 application deployment as a WAR to JRun 4.0 I have recent FB 5.1 files and skeleton Fusebox 5.1 application from www.fusebox.org If I deploy it without encrypting source it works just fine. If I encrypt source I'm getting following error message: -- Element fusebox is undefined in a Java object of type class coldfusion.runtime.ApplicationScope referenced as The error occurred in C:\webroot\servletfilter\errortemplates\genericErrorMessage.cfm: line 2 Called from C:\webroot\servletfilter\errortemplates\fusebox.fuseboxXMLError.cfm: line 1 Called from C:\webroot\servletfilter\fusebox5\fuseboxApplication.cfc: line 541 Called from C:\webroot\servletfilter\fusebox5\fusebox5.cfm: line 198 Called from C:\webroot\servletfilter\index.cfm: line 2 1 : cfoutput 2 : h3This is the template #application[FUSEBOX_APPLICATION_KEY].errortemplatesPath##cfcatch.type#.cfm /h3 3 : h2An Error of type #cfcatch.type# has occurred/h2 4 : h4#cfcatch.message#/h4 -- Is anybody familiar with this? In its potential usage we would definitely prefer encrypted templates if it can be fixed easily. Thanks Tero Pikala ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need More SQL help - DRIVING ME NUTS!
Will, Which DB are you using and if it's not difficult can you also post db scripts to create tables and populate some sample data.? Thanks Qasim On 3/20/07, Will Tomlinson [EMAIL PROTECTED] wrote: Ok, I'm really close on this. I've been workin on it for hours, changing queries, not gettin the results I need. I filled out one survey of 3 questions, each question has 5 possible answers. Here's the query: SELECT Q.questionID, Q.questionsetID, Q.question, Q.answersetid, ARS.answersetid, ARS.answersetname, A.answerID, A.answersetID, A.answername, A.answersortnum, A.answervalue, EAR.evalID, EAR.answerID, E.evalID, E.InstructorID, COUNT(EAR.answerID) AS numAnswers FROM tblquestions Q INNER JOIN tblanswersets ARS USING (answerSetID) INNER JOIN tblanswers A USING (answerSetID) LEFT JOIN tblevalanswerresults EAR USING (questionID) INNER JOIN tblEvaluations E ON E.evalID = EAR.evalID WHERE E.InstructorID = '#SESSION.CollegeID#' GROUP BY Q.questionID, A.answerID HEre's the results, with my cfoutput grouping http://wtomlinson.com/evalQRYs/qryData2.gif It should return 0 for 4 answers out of 5, since I can only answer one of five possible answers. But it's counting 1 for each answer - not right. I think I can tell what's happening, but don't know how to fix it. It's like it's grouping off the tblAnswers table, but should be calculating rows from the tblEvalAnswerResults table. And here's my DB schema if it helps: http://wtomlinson.com/evalDBSchema.jpg Thanks!! Will ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using queryname.columnlist
I would modify the code to eliminate evaludate cfscript function sqlValueFormat(field) { if (isNumeric(field)) { field = trim(field); } else { field = ' trim(field) '; } return field; } /cfscript cfset table_list = table1, table2, table3, table4, table5, table6 cfset k = 1 / cfloop index=i list=#table_list# delimiters=, cfquery name=getall datasource=db_mysql SELECT * FROM#trim(i)# /cfquery cfloop query=getall cfquery datasource=db_mssql INSERT INTO #trim(i)# cfloop list=#getall.columnlist# index=j #j# cfif k LT ListLen( getall.columnlist ),/cfif cfset k = k + 1 / /cfloop cfset k = 1 / VALUES ( cfloop list=#getall.columnlist# index=j #sqlValueFormat( getall[j][currentrow] )# cfif k LT ListLen( getall.columnlist ),/cfif cfset k = k + 1 / /cfloop ) /cfquery /cfloop /cfloop On 3/19/07, Mik Muller [EMAIL PROTECTED] wrote: You want to evaluate field to its value if (isNumeric(field)) { field = trim(evaluate(field)); } else { field = ' trim(evaluate(field)) '; } return field; Mik At 09:21 AM 3/19/2007, Pete Ruckelshaus wrote: Hi All, I have a data import project that I am trying to simplify, mainly because of the number of tables and amount of data involved. I'm importing a number of tables from a MySQL database to an MS SQL Server database with an identical structure, except for datatypes being changed where appropriate. The problem is, in my code I am ending up passing in the column name rather than the actual column value. Can anyone tell me what I'm doing wrong? Here's my code: cfscript function sqlValueFormat(field) { if (isNumeric(field)) { field = trim(field); } else { field = ' trim(field) '; } return field; } /cfscript cfset table_list = table1, table2, table3, table4, table5, table6 cfloop index=I list=#table_list# delimiters=, cfquery name=getall datasource=db_mysql SELECT * FROM#trim(i)# /cfquery cfquery name=insertAll datasource=db_mssql cfloop query=getall INSERT INTO #trim(i)#(#getall.columnlist#) VALUES (cfloop list=#getall.columnlist# index=j delimiters=,#sqlValueFormat(evaluate(j))#cfif NOT listLast(getall.columnlist, ,),/cfif/cfloop); /cfloop /cfquery /cfloop The error that I'm getting is cannot convert the value STAMP to a boolean -- STAMP is a column name in the table, not the actual chunk of data, which is what I want. Thanks! Pete ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: udf var
You have an argument with the name 'form'. Your var scoped variables cannot be of the same name as your argument variable. Thanks On 3/6/07, Will Tomlinson [EMAIL PROTECTED] wrote: I haven't built a simple udf in forever, but decided to do one for my trimming of formfields. I tried sticking a cfset var form = right above the loop, but I get an error: Cannot declare local variable FORM twice. cfcomponent cffunction name=cleanFormfields access=public returntype=struct cfargument name=form cfloop list=#ARGUMENTS.FORM.fieldnames# index=thisfield cfset FORM[thisfield] = Trim(ARGUMENTS.FORM[thisfield]) /cfloop cfreturn form /cffunction /cfcomponent Am I not supposed to var this one? Thanks, Will ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271814 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmodule advice...
Will, Another approach would be to use cfimport which I personally prefer and it is supposed to be a bit faster (I could be wrong). In addition to Ray's suggestion, you can definitely do something like this if you do not want tag to run twice cfif thisTag.ExecutionMode eq 'start' your code goes here /cfif HTH On 3/2/07, Janet MacKay [EMAIL PROTECTED] wrote: And, if you don't want your tag to run twice, add cfexit method=exittag to the end of your custom tag. I never knew about that one. I just tried it. Sure enough .. the tag runs twice without the cfexit method=exittag. Learn something new everyday. Thanks for the tip! Janet ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query To Database
This might help you although I haven't tested it cfloop query=CSVData cfquery name=insert ... INSERT INTO TableName ( cfloop list=#CSVData.columnlist# index=i #i#, /cfloop ) VALUES ( cfloop list=#CSVData.columnlist# index=i '#i#', /cfloop ) /cfquery /cfquery On 2/28/07, Deepak Gupta [EMAIL PROTECTED] wrote: Hi My code cfloop query=CSVData cfquery name=CSVInsert datasource Insert into TableName (#ColumnList#) Values (?,?,?...) /cfquery /cfloop How can I dynamically place the column values from the CSVData query here ? I will appreciate if someone can answer this. I need something like Values ( #Time#, #Date#, #NOW()#,) Date and time is coming dynamically from the query. -DG ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Formatting your SQL Statements
Since a query will not be producing any output, I would suggest to put it inside a cfsilent block so eliminate all white space. Thanks On 3/1/07, Mark A Kruger [EMAIL PROTECTED] wrote: Ah... Well I don't use the GUI ... Just query analyzer.. The script generator code is actually quite good.. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 3:32 PM To: CF-Talk Subject: RE: Formatting your SQL Statements When people do that build-query thing they select tables and drag-drop to hook up foreign keys. The SQL code that that generates is almost offensive. It seems to randomly break lines and indent. Not sure where it is as I never use it. ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 4:04 PM To: CF-Talk Subject: RE: Formatting your SQL Statements What do you mean? Out of like ... Firehose mode? I use query analyzer to write and it formats splendidly - as does the script generator... What part of SQL server are you rioting against :) ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AJAX back button
This is a library without using JQuery http://codinginparadise.org/weblog/2005/08/ajax-tutorial-saving-session-across.html Thanks Qasim On 2/23/07, Rey Bango [EMAIL PROTECTED] wrote: Tackling the back button in Ajax isn't a trivial task and has really frustrated a lot of developers. Several of the frameworks out there offer back button support so you may want to consider switching. As Andy mentioned, jQuery (www.jquery.com) offers a plugin that supports this functionality and makes it easy to implement. The plugin can be found here: http://www.stilbuero.de/jquery/history/ Rey... Richard Cooper wrote: Hi all, I've a site that has a lot of onclick content changes using ajax. I'm a creature of habit and have been using the same framework I started with, Simple AJAX Code-Kit. My question is what is the best way to cope with using back button and bookmarks. Should I change frameworks, or is there simple solutions out there that can be appended to my current framework? I know there is a lot of info out there in goolge land but a bit of guidance will probabley save me a lot of time. Thanks, R ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdSpring - What's my DAO do?
Adam, this would be my suggestion however some CS guru might have a better idea bean id=DogDAO class=com.DogDAO / bean id=DogGateway class=com.DogGateway / bean id=DogService class=com.DogService property name=DogDAO ref bean=DogDAO / /property property name=DogGateway ref bean=DogGateway / /property /bean Thanks Qasim On 2/12/07, Adam Roussos [EMAIL PROTECTED] wrote: All, I am still trying wrap my head around using ColdSpring+ModelGlue and focusing on getting my best practices right. That said, there is one major question that I am struggling with. As for some background, I have modeled my CS+MG development around Brian Kotek's excellent article on ColdSpring. In this article Brian, reinforces using a Service with a Data Gateway and a DAO that depend on it. In addition, the DAO and DG have a config that they depend on. For this example, let's say I am building an application to manage an inventory of dogs. If we follow out Brian's article, this means that I have a DogService.cfc which depends on the DogDAO.cfc as well as a DogGateway.cfc. This is where I get stuck. I want my DG and my DAO to return objects of type Dog of course. So, how do I handle the instantiation of these objects from within the DAO and the DG. The obvious answer is use cfobject dummy but this means neglecting this nice shiny IoC framework we have. So, if we donât hardcode the path to the CFC, how do we do it? I have thought about a couple solutions with the following being my best bet. This would be to add a DogFactory.cfc and make it a dependency of DogService.cfc and define this relationship in ColdSpring. Then, within the service (DogService), we can pass the DogFactory to the DogDAO and DogGateway for them to use. Although this solution does eliminate the hard coded object creation, I believe this to be a very unelegant solution. It seems unnecessary to create two factories, one for the DAO and one for the DG. So - how do I create an object (or multiple) from within my DAO and DG without hard coding the path? AdamR ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: blogCFC?
Doug, By any chance, do you have debugging turned on? Thanks Qasim On 1/29/07, Raymond Camden [EMAIL PROTECTED] wrote: The front page shouldn't be _too_ slow. The caching is mainly meant to make the most viewed page quicker. (Ok, maybe I'm being defensive now ;) On 1/29/07, Russ [EMAIL PROTECTED] wrote: BlogCFC is a bit slow, which is why it has a caching mechanism for the home page. If you don't reinit it all the time, it should be fast enough. It also might be some of the optional components. We have it running on a large site, with no performance issues, while on my personal site, it does seem a bit slow. Russ -- === Raymond Camden Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hiding url variables
Or simply Encrypt and Decrypt using ColdFusion builtin functions. HTH On 1/27/07, Doug Brown [EMAIL PROTECTED] wrote: I do not have a real answer to the question but...maybe disguise it. set it cfset myUrlVar = createUUID() 1 get it cfset myUrlVar = right(myUrlVar,1) Doug B. - Original Message - From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, January 27, 2007 4:44 PM Subject: hiding url variables Hi, i have a cfm page that uses a javascript function to append a variable to a url. I then use the coldfusion url variable set to collect the variable in the receiving cfm page. however, the variable data is being displayed in the address bar in the browser. is there anyway to hide the variable data so that it doesn't show in the address bar? thanks very much for any help ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamic valuelist
Micheal, You can easily do something like this cfset myList = ArrayToList( yourQuery[yourColumn].toArray() ) / HTH Qasim On 1/26/07, Michael Dinowitz [EMAIL PROTECTED] wrote: Perfect. And it uses something that I mentioned in my From UDFs to CFCs article in FAQU 2. See what happens when you code without sleep. :) This is part of a new version of my MakeTree() UDF, which is being used by my 'soup to nuts' comment.cfc. And for those who will ask, I'll post it up for public use. untested: ArrayToList(Arguments.Query[Arguments.Unique]) On 26/01/07, Michael Dinowitz [EMAIL PROTECTED] wrote: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: StructClear and passing in a string...
This should work on CFMX AFAIK cfset StructClear( getPageContext().getBuiltinScopes().get( YOURSTRUCT ) ) / HTH On 1/26/07, Andy Matthews [EMAIL PROTECTED] wrote: I have an interesting situation... We have a multi-server configuration and there are times when we need to clear a certain structure, SESSION.userinformation or APPLICATION.siteinformation for example. BUT, we need to clear it across all servers. My first thought is to create a template that can be called on one server, which will cfhttp to the other servers and run this code: cfset StructClear(Evaluate(ARGUMENTS.myStruct)) Where myStruct is a URL variable passed into a CFC. Evaluate works, but I'm wondering if there's a way to avoid using it? Anyone have an idea? Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL order by
http://db4free.blogspot.com/2006/06/sorting-of-numeric-values-mixed-with.html On 1/25/07, Chad Gray [EMAIL PROTECTED] wrote: You got me pointed in a great new direction. I will figure out the details and if there is a better function then isNumeric for the data I am dealing with. Thanks! -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 10:18 AM To: CF-Talk Subject: Re: SQL order by Jim Wright wrote: I should point out one issue with the way I did it...the isnumeric function is not perfect, and will resolve to true things that can't be converted to INT...case in point... IsNumeric('1,0.') = 1 CAST('1,0.' AS INT) throws an error and further, you need to look at the numeric data you are converting...is it all ints...you may need to convert to something else...also, you can google on isreallynumeric and isreallyinteger...those are some custom functions I've used in the past. sorry about the multiple posts...headache...not thinking clearly. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse / Eclipse question
I have been using MyEclipse (www.myeclipseide.org) for a while now and have found it to be pretty useful with its XML, CSS Javascript and a load of other plugins. This is the plugin that all my team use at work for VSS. http://vssplugin.sourceforge.net/ HTH On 1/24/07, Andrew Scott [EMAIL PROTECTED] wrote: Or! http://www.eclipseplugincentral.com/ Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help Needed for fine-tuning CF code
As far as I can tell looking at the various suggestion, the most probable bottle neck is in your SQL code and not the CFM. Some stupid questions? 1. DO you have indexes on the table? 2. Which DB are you using? Different DB vendor will let you select only a subset of data i.e. SQL Server (Top 50) or mySQL (Limit 50) etc. Thanks Qasim On 1/23/07, hussain shaikh [EMAIL PROTECTED] wrote: I am actually displaying only 100 records per page, so I guess that should not be the problem. But is there any way by which I can display the contents of the table as the data is rendered by HTML. I have tried cfflush but it didn't worked out. Hussain. If the CF is processing in 100 Ms then the problem lies with the HTML. Do you have a nested table layout? If you do avoid it. Also if your creating say 1000 rows for the page, consider changing it to mulitple tables i.e every 50 results create a new table. This should mean the data appears in chunks of 50. You can also use cfflush with this but I don't think it would be required in this situation. Something like this just above your /cfoutput should help: cfif currentrow mod 50 EQ 0 /table table /cfif ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: isURL() function on cflib
If you are on CFMX, you should be able to use isValid to validate a URL among various others. HTH On 1/23/07, Ben Nadel [EMAIL PROTECTED] wrote: I am writing up a demo for this now... So if no one solves it, I will demonstrate. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 4:53 PM To: CF-Talk Subject: isURL() function on cflib Hi, I used this isURL() function I found on CFLIB, but it reports the below URL's as invalid. Any ideas what's wrong with the reg exp ? function isURL(stringToCheck){ return REFindNoCase(^(((https?:|ftp:|gopher:)\/\/))[-[:alnum:]\?%,\.\/##!@:=\ +~_] +[A-Za-z0-9\/]$,stringToCheck) NEQ 0; } Here are the types of URL's found to be invalid (I have 'd out the proprietary information but the structure remains the same): http://..com/xx/xxx.cfm?cdcrs=RD4823 http://..com/xx/xxx.cfm?cdcrs=RD4823empcode=GUEST43352 empcode=GUEST43352 (I'm guessing it has something to do with not handling a URL with parameters) http://..com/on_job/supplychain/index.html (this one has an _ in it) http://..com (i have no idea why this one is found invalid) http://xxx.x.com/xx (this one either) https://x.xl.com/x/xxx/. (techincally, this one will work, because the period will be translated as the current directory, so it should return valid) If any one has any recommendations on how to fix the reg exp so that it will consider these URL's valid, please let me know. Thanks! Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to dump a sql query to text
I am not sure if this solves your problem, but if you have debugging turned on the server, you can get several information from the servicefactory debugging object. Here is a UDF that I wrote a while back which return true if the query ran was a cached one. http://www.cflib.org/udf.cfm?ID=1202 Thanks, Qasim On 1/22/07, Christopher Jordan [EMAIL PROTECTED] wrote: Yeah, but you'd still have a problem when using CFQueryParams. :o' Chris Scott Weikert wrote: Well, you could start by throwing the SQL query code into a var to begin with: cfset SQLVar = Select * from table Or build it up as you would build it within the cfquery tags. Then execute it: cfquery etc etc #SQLVar# /cfquery And since it's already in a var, you can write it to your DB as you see fit. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CGI.servername reliability
cfdump var=#getPageContext().getRequest()# / will give you an alternative to almost all CGI variables provided you are using CFMX 6 and later. HTH Qasim On 12/27/06, Dave Watts [EMAIL PROTECTED] wrote: Is there a more reliable way to determine the domain name than using CGI.server name? Specfically, I have multiple domain names pointing to the same folder via IIS and would like to determine which one is in use. I have noted that not all interent users provide the CGI variables which causes a problem. Any ideas on a better way to handle it? CGI.HTTP_HOST tells you what the browser's Host header contains. If you're using host headers to differentiate requests to multiple virtual servers, that's what you'd need to look at. On the other hand, if you're using different IP addresses for your virtual servers, you could detect the requested IP address instead. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No, I'll call you...
We have a similar architecture at my work where those long reports are sent as an Async request (Async Gateway) and then user is notified via email when reports are complete. Thanks On 12/21/06, Christopher Jordan [EMAIL PROTECTED] wrote: This probably isn't what you want either, but... You could have your report program write to a table when it's complete. The record would consist of who needs to be notified, and the status of their notification. Maybe the session ID or some session variable could be stored. Then you could have a javascript function that you include at the top of every page (like from the Application.cfm) that fires off an ajax call to check this table for the presence of finished jobs that belong to the current session or user or whatever. Does that sound feasible? Cheers, Chris Brad Wood wrote: Ok, so I am working on some very long reports and am peddling ideas... Here's the idea: The user runs a very long report, and the request will simply be placed in some sort of queue to be ran asynchronously. The user is told he/she will be notified when it is completed. Then the user surfs away to another portion of the site. Half an hour later when the report finishes, a message pops up on the users screen saying Your report is finished, you may view the result now. My first thought was I could place a receiver JavaScript function in every page in the site, then make an Ajax call to run the report. When the Ajax call returned, it would fire the function and display/alert the message. Well, no dice on that. I tried it in IE and FF. IE actually leaves the TCP connections open until the call returns, but there is nothing listening to receive it. FF actually threw an unhappy error when I tried to navigate away while the call was going, and then it closed the TCP connection. I'm really afraid the correct answer to this is The web is stateless. What you need is a client server app. Convert your entire site to Flex 2 Enterprise and use their sweet messaging services and all your woes will disappear Now, as much as I would like to do that, that's not really an option right now. Any suggestions? ~Brad ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No, I'll call you...
Mark Mandel has written an excellent library to perform Aynsc without CF Enterprise. http://www.compoundtheory.com/?action=asynchttp.index HTH On 12/21/06, Brad Wood [EMAIL PROTECTED] wrote: Yes, I believe so. But isn't that limited to CF Enterprise? We only have standard. *sigh* ~Brad -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2006 11:04 AM To: CF-Talk Subject: Re: No, I'll call you... Isn't this what the Event Gateway in ColdFusion could be used for? Either the CFML or a combo of the CFML and Directory Watcher. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using arrays in a simple bean
Is there are reason you cannot use Structure for meeting sponsors? e.g. cfset variables.instance.sponsors = StructNew() / cfset variable.instance.sponsors[sponser1] = 'Name of Sponsor' / .. HTH On 12/21/06, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED] wrote: I'm using a bean cfc for an instance of a meeting. Each meeting can have between 0 and 10 sponsors. (These are just string values.) Rather than have setSponsor1, getSponsor1, setSponsor2 etc. and have 10 different properties in the instance, I thought I'd put it into an array. This has two other side effects: Memory isn't taken up by undefined variables and it should easily allow for future expansion/contraction if the business rules should change. I'm having a bit of trouble getting my head around the best way to do the getter/setter methods. Has anyone done something similar that I could crib for ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: JavaScript question.
Prototype (JS) library has a built in function named $$() for this purpose. You can also use this implementation http://simon.incutio.com/archive/2003/03/25/getElementsBySelector HTH On 12/20/06, Ian Skinner [EMAIL PROTECTED] wrote: Is there any way to restrict a getElementByTag() function to a subsection of the DOM? I.E. Only return div tags that are children of the contacts fiedset node? I've tried a couple of nebulous attempts at this with no success. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Components Fusebox 5
In Fusebox 5, you can place all the above logic in fusebox.appinit.cfm file. HTH On 12/15/06, Greg Luce [EMAIL PROTECTED] wrote: Here's how I did it in FB4.1 and am doing right now in my first FB5 app. Fusebox.init.cfm !--- Initialize application components. --- cflock timeout=30 throwontimeout=No name=appcomponents type=EXCLUSIVE cfset application.AppName = createObject( 'component', ' appName.com.AppNameComponentName' ).init() / /cflock Then have my components in /com No cfinclude necessary. Greg On 12/15/06, Chris Ditty [EMAIL PROTECTED] wrote: I am trying to write my first fusebox 5 app using MX7 and components. I usually like to keep my functions in a seperate file in another directory. When I try and do an include, I get an error saying that I am missing a Fuse. I could include this function library in all my pages, but I would rather it be called just once per fuse action. Any ideas? thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT hell
We encountered similar issues along with cfdocument being very slow. We took sometime out and implemented XSL-FO which is really awesome and works seamlessly without any problem and has a lot more feature than cfdocument could offer. HTH Qasim On 12/15/06, Bryan Stevenson [EMAIL PROTECTED] wrote: I found a post on Ray's blog from October of 2005! that states the 2 behaviours I'm seeing are in fact bugs. As far as I can tell they have yet to be fixeed (I'm still running 7.01 and see no sign of these bugs in the release notes for 7.02). The bugs are: 1) CFDOCUMENTSECTION forces a page break after it's closing tag 2) If you have more than one header/footer, the last one si the only one shown I am shocked the set of tags made it out the door that way as they are VERY obvious bugs. I guess CFREPORT may solve my problemif not I'll have to do it in iText directly (I thought those days were over *sigh*). Anyways...any insight still welcome ;-) 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 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Datasources case-sensitive?
AFAIK if you have server sandboxed than datasource names are case sensitive. Thanks Qasim On 12/8/06, Steven Erat [EMAIL PROTECTED] wrote: This was bug 64046, which in turn was a duplicate of bug 54678. There is a hotfix available if you contact support. I can't verify that it was in an updater. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, December 08, 2006 6:36 PM To: CF-Talk Subject: Re: Datasources case-sensitive? Up till Updater 1 for CF7.0.2 I believe they ARE case sensitive if sandboxed. Andy ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Source control recommendation
Look at. www.cvsdude.com. I believe they provide SVN + Trac with a backup every 10 mins. Thanks, Qasim On 11/12/06, Rob Wilkerson [EMAIL PROTECTED] wrote: On 11/12/06, Nick Gleason [EMAIL PROTECTED] wrote: Hi there. We've been hosting our source code in VSS in the past but are considering moving to a new source control system and / or provider. We are basically interested in paying an affordable monthly fee to use a well regarded source control system with an experience host who is diligent about nightly backups, maintenance, and so forth. If you have any recommendations for source control systems and even providers that you have been happy with, please let me know. I can't recommend Subversion enough. I recently moved my company's source code from VSS and couldn't be happier. I also added Trac for documentation and bug tracking with fantastic results. The latter, of course, is optional. Subversion, and it's convenient integration with Ant tasks has made my life a lot easier. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Validating a form
Here is a nice blog entry by Wayne discussing form validation with javascript prototype and ColdFusion. http://swem.wm.edu/blogs/waynegraham/index.cfm/2006/9/21/Form-Validation Pretty useful library and quite extensible. On 11/6/06, Andy Matthews [EMAIL PROTECTED] wrote: I recommend giving Massimo's TMT_validator a try... It's extremely useful, works really well and it's realyl easy to get running: http://www.massimocorner.com/validator/ !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 11:43 AM To: CF-Talk Subject: Re: Validating a form Wouldn't it be nice to display all of the errors at once? Good call! Thanks for all the suggestions guys. I'll make it better. Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion session variables and Flex 2
Rick, Here is a blog post from Ben Forta on a similar topic. http://www.forta.com/blog/index.cfm/2006/9/24/Flex-And-Session-State-Management HTH Qasim On 10/14/06, Rick Root [EMAIL PROTECTED] wrote: Ping Rick Root wrote: I have a hybrid application that uses both Flex and coldfusion generated HTML. I'd like to use session variables for a few things, but I'm finding that session variables which are available on the Coldfusion pages are *NOT* available in Flex remoting calls. I have some code in my CFC that emails the session scope to me, and the content of that session scope is different for the flex remotign calls an the regular .cfm page calls. Is this normal? rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem displaying CF Debugging Information.
I am assuing that pages that do not display debugging info have cfsetting showDebugOutput=false / HTH Qasim On 10/15/06, A Bell [EMAIL PROTECTED] wrote: I have debugging enabled in the CF admin and IP set and most of the pages show the debugging info except of some pages. Can anyone help ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form Validation Custom Tag
I have heard good reviews about qForms. Thanks On 10/14/06, Mike Tangorre [EMAIL PROTECTED] wrote: From: Ali Majdzadeh [EMAIL PROTECTED] Hi everybody: Is there any reliable, complete form validation custom tag? Thanks Benign Form validation is pretty generic... what kinds of validations do you need to do? No blank fields? Check dates? Ensure one and only one checkbox is checked in a group of related checkboxes? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jsVal is a nice validation script and very good with my CF pages
Here is another library that I have found to be very useful and very easy to extend. http://tetlaw.id.au/view/blog/really-easy-field-validation-with-prototype/ Wayne Grahan has written has written an exellent blog post/article about the same library with particulat emphasis on CF http://swem.wm.edu/blogs/waynegraham/index.cfm/2006/9/21/Form-Validation Thanks, Qasim On 10/9/06, Ali Majdzadeh [EMAIL PROTECTED] wrote: Hi: Thanks for the reply. Yeah surely Massimo's tmt_validator is the top one but I had some problems with it and couldn't find a solution for that. I emailed you my problem off the list (because I had to attach some cfm pages) and if you do help me I will really appreciate it. Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Resume/CV Writing
Guys who are doing these pod cast has a series of excellent casts on the same topic. http://manager-tools.com/ HTH Qasim On 9/29/06, Nathan Strutz [EMAIL PROTECTED] wrote: Yeah, fill it out on monster and download the word doc version. Works really great. -nathan strutz http://www.dopefly.com/ On 9/29/06, Neil Middleton [EMAIL PROTECTED] wrote: Hi, I'm thinking of attempting to write myself a new Resume after seven years (so am therefore out of practice). Any tips? -- Neil Middleton Visit feed-squirrel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLog4j
Dan, Do you have another property file which has this appender 'myAppen' in it? Thanks, Qasim On 9/19/06, Dan Plesse [EMAIL PROTECTED] wrote: Qasim, I am getting this with my app log4j:ERROR The class org.apache.log4j.Appender was loaded by log4j:ERROR [EMAIL PROTECTED] whereas object of type log4j:ERROR org.apache.log4j.RollingFileAppender was loaded by [ [EMAIL PROTECTED] log4j:ERROR Could not instantiate appender named myAppen. And I don'r know how PropertyConfigurator could know about Category unless they both share a common object. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253502 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLog4j
Folks, I had some free time last weekend which prompted me to write a Wrapper CFC to deal with logging with log4j. Here is the url on google project. http://code.google.com/p/cflog4j/ I have tried to include every resource in the links section however I do apologize in advance if I missed any name or credits. The code should be self explanatory and consist of 2 CFCs 1. A Config Bean for CFLog4j.cfc 2. CFLog4j.cfc is the actual wrapper around log4j. There is some example implemention in testCFLogger.cfm in the root. Please let me know if there is any problem or if I have missed anything. Next planned step would be to create some examples of integrating DBappender which will write logs to the database directly. Thanks, Qasim ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4