Re: reinit application variables
On Feb 17, 2008 5:38 PM, Ricardo Russon [EMAIL PROTECTED] wrote: Matt, Is there any performance gain using structKeyExists(url, 'init') over isdefined(url.init) ? Is it a best pactice thing or your own preference? Ric. structKeyExists is my preference. As whether or not there is a performance gain, I'm sure others will be glad to debate. And it won't be the first time. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:33841#170108 http://www.google.com/search?q=structkeyexists+vs+isdefined -- Matt Williams It's the question that drives us. ~| 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:299241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reinit application variables
On Feb 16, 2008 3:40 PM, Chad Gray [EMAIL PROTECTED] wrote: How do you reset application variables? I am using application.cfc to set some application variables and cant figure out how to reset them so they reload with different data. One way is to add this in onRequestStart: cfif structKeyExists(url, 'init') AND url.init EQ myInitPass cfset onApplicationStart() / /cfif Then you can reset them by adding init=myInitPass into the url. -- Matt Williams It's the question that drives us. ~| 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:299211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf to pdf
cfdocument format=pdf ? On Feb 16, 2008 1:32 PM, Steve Kahn [EMAIL PROTECTED] wrote: For output of cf to pdf what would you recommend? I need to pass form input to 50 different letters and then save them as one pdf file. TIA No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.7/1283 - Release Date: 2/16/2008 2:16 PM ~| 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:299212 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: ThickBox (JQuery)
Steve, as for modal, add modal=true and clicking the parent is disabled. Though you will need to add a button or link that calls tb_remove() or you can't exit it all. I haven't tried any dragging. The sources the others have mentioned will be best for that and future questions. Matt On Thu, Feb 14, 2008 at 9:37 PM, Rey Bango [EMAIL PROTECTED] wrote: No prob. Just so you know, I'm part of the jQuery team and I troll here often. If you need something, feel free to email me directly. Rey Steve Good wrote: Thanks Rey. That might be exactly what I need. ~Steve Rey Bango wrote: Steve, Check out http://dev.iceburg.net/jquery/jqModal/ Rey... Steve Good wrote: I gave up on the CF8 bundled AJAX libraries and moved on to JQuery. I decided to use ThickBox for my modal window needs, but I've noticed some differences between thickbox and cfwindow. 1. ThickBox is not modal in the same way that cfwindow is. It fades out the parent layer, but unlike cfwindow, I can exit the thickbox by clicking in the faded area. With cfwindow my interaction is limited to just the modal window. Is there a way to accomplish the same thing in ThickBox? 2. I can't figure out how to make the thickbox window draggable like cfwindow. Is this something that is possible with thickbox? I know this isn't directly related to CF, but I am at a loss for places to ask. If anyone knows of a list or forums where these kinds of questions would be more appropriate to ask please let me know :) Thanks! ~| 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:299050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Beyond Captcha
+1 on cfformprotect. Just did an install last week. Quick. Easy. Transparent to user. And so far no spam. http://cfformprotect.riaforge.org/ -- Matt Williams It's the question that drives us. ~| 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:298458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Beyond Captcha
If you're dealing with an actual person, then there is probably no stopping them. Is that what you mean by crackers / hackers? Do you mean trying to get in admin parts of sites, or legitimate customer account screens? I'm not sure I understand the use case... On Feb 7, 2008 1:37 PM, William Seiter [EMAIL PROTECTED] wrote: This tag seems nice for a blogging environment or a web entry system (similar to the web page where you can add comments to this list at houseoffustion.com), but what about not just the 'spammers', what about the crackers and hackers who want to gain entry to the website via a login page? William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Mike Francisco [mailto:[EMAIL PROTECTED] Sent: Thursday, February 07, 2008 11:25 AM To: CF-Talk Subject: RE: Beyond Captcha I don't want to speculate, but I do know what works extremely well for my apps... Jake Munson's CFFormProtect -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Thursday, February 07, 2008 11:19 AM To: CF-Talk Subject: Beyond Captcha It might just be wishful thinking on my part, but I believe that Captcha will soon be as rare (and just as appreciated) as those little icons saying 'this site optimized for IE 4.0'. ~| 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:298462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dead Beat Clients.
On Feb 4, 2008 11:26 AM, Michael Dinowitz [EMAIL PROTECTED] wrote: While this thread has evolved into a useful discussion, it's original premise is one that is not only inflammatory but possibly libelous. The problem is that it was probably posted by a sock puppet account as my emails to angry housewife have not resulted in any reply (though it'll probably result in a reply to this thread). For this reason, the base post will be removed from the archive and the threading will be reset to reflect the removal. I'll also be looking into the source of the account to see who it's a sock puppet for. Should not be a problem. Probably a good idea Michael. It is interesting that the original angry housewife post said it isn't libelous, but obviously wanted to be anonymous. Things that make you say hmmm. -- Matt Williams It's the question that drives us. ~| 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-Jobs-Talk/message.cfm/messageid:3644 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: Dead Beat Clients.
On Feb 2, 2008 6:55 PM, angry housewife [EMAIL PROTECTED] wrote: I have watched my husband work very hard for three or four contracts in the last six months where he has only been paid ten percent of his total invoiced hours. My husband never signs a contract where the work has to be completed before he is paid, yet every client of his who has not paid uses this as an excuse not to pay because the work or project is not completed. The only work my husband ever seems to get paid in full for is for work done on-site. I'm sorry, but this really sounds like bad business not on the part of the client, but on your husband's part. If the same client did not pay several different contractors, they are probably at fault. If the same contractor doesn't get paid by several different clients, he is probably at fault. Yes there are deadbeat clients out there. Perhaps a list would be helpful. But maybe your husband doesn't need instead of a list of clients to avoid. Maybe he needs some training / help in drafting contracts and dealing with said dead-beat clients. I've done very little on contract myself, but if I ever started, I would seek some help from someone more experienced first. Someone like Jeff Houser on this list generally has the best advice and has experience with clients of all types. He has been burned, but has not come here bitching and moaning and wanting to name names. He figures out what went wrong and tries to fix it for future clients. Your husband (and yourself) would do well to do the same. And / Or hire someone to train / help you learn how to deal with the past problems. If such a deadbeat list were to exist, I may look at it as a reference to beware of. But I'm not likely to accept it as gospel that the client will not pay. I would have to question the contractor who put the name there in the first place. Did they really deliver what the client asked for? What kind of communication did he have with the client? Etcetera, etcetera. I know that there are 2 sides to every story. Simply putting a client name on a list is very one-sided. Just my 2 cents. -- Matt Williams It's the question that drives us. ~| 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-Jobs-Talk/message.cfm/messageid:3622 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: Dead Beat Clients.
It is true that I do not have much contracting experience. And I am probably naive about all the things that can go wrong. Because of this and due to Isaac's comments, I will retract my comment that because a contractor has had several non-paying clients that the contractor is at fault. On the other hand, I will uphold my belief that there is two sides (maybe even more, if there are other middle-men or vendors at play) to the story. I'm not saying that a list is necessarily a bad idea. What I am saying, and what I would encourage every other developer to do, is take that list with a grain of salt. Heh, if I was approached by a client that I knew had the worst reputation on the dead-beat list, I would probably ask them about it straight up. But I would not immediately rule them out until I felt I had both (all) sides of the story. As for a union, who knows, maybe it is a good idea. It would take a bit more dissatisfaction than the few on this list before it would happen. I know there are a lot of developers that have been burned, but are probably quite satisfied overall. I also will uphold my belief that getting some help on contracts and communication with clients is always a good idea. Just like always trying to expand and improve your programming skill, even the experienced contractors should keep learning how to better deal with clients. My humble opinions, Matt Williams ~| 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-Jobs-Talk/message.cfm/messageid:3627 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: Upload progress bar
On Feb 2, 2008 4:36 PM, Gerald Guido [EMAIL PROTECTED] wrote: http://www.webdice.org/uber_uploader/ From the research I did on this a few months ago you need to use either Perl or Flash to accomplish real upload status. That uber_uploader uses Perl on the backend to do its thing. Because I'm more comfortable with Flash that Perl, I used this: http://www.element-it.com/MultiPowUpload.aspx The docs even show a way to hide the flash (still embed it, but not visible) and work with it via html/javascript. There's a free version and a pay version. The company is in Russia, but I found their support to be very responsive and even accommodated a feature request for me. -- Matt Williams It's the question that drives us. ~| 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:298017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Starting up work environment
Maybe they will start sequentially. I haven't actually tried it to tell the truth. As for not restarting. I used to do that, but starting noticing a slowness and other intermittent problems if I don't shut down at night. Basically I would end up having to reboot after a couple of hours in the morning anyway. I hadn't thought of Warren's idea of a separate login, but I think I would still rather have an on-demand way to start all the programs. Perhaps I'll just try a batch file and see if they run as expected. I guess even if they aren't sequential, it doesn't matter, they'll just take longer to boot, but would anyway. The only thing I'm not sure how to do is start the VPN connection. Is there an exe associated with this? Or some flags to an exe? As for the quick launch idea, I abandoned it a long time ago. I use the Pin to Start Menu instead. All my often used programs are just in the Start menu and I don't have to navigate through All Programs. I prefer this over the quick launch because I like my task bar real estate for the open windows. Oh, and I don't have anything on my desktop. I have desktop icons turned off. That just seems like a very un-handy place to put things. As soon as one program is maximized, they are no longer easily accessible. Thus, the pin to start menu idea. Matt On Feb 1, 2008 8:42 AM, Dave Watts [EMAIL PROTECTED] wrote: I know a batch file can do this, but is it going to do them all at once? If so, is there a way to make it pause between each? If you just start each program directly from the batch file, they'll start sequentially. You can spawn programs so that the batch file continues running while the programs are starting, though, I think. Are there other solutions? Suspend mode? Why bother restarting? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ ~| 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:297908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: Starting up work environment
Does anybody have an automated way to start up your work environment (Windows)? I don't think I want to use the windows startup folder because I wouldn't want it everytime I start the computer. I work at home and my work laptop is also my personal laptop. I'm thinking a batch file is what I'm looking for, but not sure. For example, each morning for work I open the following: FireFox IE Trillian VPN Connection Outlook Eclipse MS SQL Mgt Studio Express A folder on my C: drive I know a batch file can do this, but is it going to do them all at once? If so, is there a way to make it pause between each? Are there other solutions? Thanks. -- Matt Williams It's the question that drives us. ~| 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:297901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Consultant's Revenge
*cough* liability *cough* Seeing as how it is anonymous, companies would come after the site owner for anything they feel is untruthful (you know, the beyond the shadow of a doubt type thing). Be careful trying to recreate a judicial court. On Jan 31, 2008 5:05 PM, Joseph Smuzynski [EMAIL PROTECTED] wrote: After dealing with a few too many disreputable companies, I'm just about ready to build a new site that is sort of a cross between f*ckedcompany.comand ChexSystems. The idea is to have a site where consultants of all types can come and anonymously post their negative experiences with various companies, large or small. The hope is that with proper marketing, it will become the first place a consultant comes to check out a company before doing work for them. If a company ends up with a negative listing, the way they get the listing removed is to make good with the consultant, then the consultant can mark the case closed. Naturally, if they have multiple bad entries, they would have to make good with everybody. The site would not allow inflammatory types of comments about a company; only facts. Each entry would be reviewed and approved before being posted. There would have to be supporting data too... for example, let's say a company refused to pay your last invoice. You would need to provide a copy of your last invoice and a work log to document it. All listings would have to include proof that you actually worked for the company... e.g. copies of pay stubs, a copy of the contract, etc. Otherwise the site could be used for extortion and would lose it's advantage because it wouldn't be taken seriously. So, the point is to help show companies that they have to treat consultants well... pay their people what they're owed, treat them kindly, etc. Otherwise these companies may find themselves unable to get people to work for them anymore. I don't see this being a lawsuit magnet either. Each posting would have to be factual, not emotional. No slanderous or libelous remarks. Just facts. It would boil down to the consultant's word against the company. No names of people would be mentioned, so you couldn't call people out by name. You could go as far as to say your supervisor was a micro-manager but you couldn't say, my supervisor, Bill Smith, was a micro-manager and was always giving me a hard time. Sure, the easier way is to just post about 'em here on cf-jobs-talk, but then you're likely to end up with a bad rap since a lot of job posters read this list too, no doubt looking for anybody who might be willing to speak out. I haven't really decided what to call the site either. I'm not even sure yet if I'll do it; I'm curious to hear what others think of the idea. Joe ~| 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-Jobs-Talk/message.cfm/messageid:3589 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: CF MX8: This is driving me nuts!!!
doesn't access prefer double quotes? (getUser.UserLogin = paulw) AND (getUser.Password = 2324986). On Jan 23, 2008 12:11 PM, Rick Root [EMAIL PROTECTED] wrote: On 1/23/08, Nick Ross [EMAIL PROTECTED] wrote: Syntax error (missing operator) in query expression '(getUser.UserLogin = 'paulw') AND (getUser.Password' = '2324986')'. You have an extra ' after Password probably should be AND (getUser.Password = '2324986') Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(getUser.UserLogin = 'paulw') AND (getUser.Password' = '2324986')'. Problem #2 - Access sucks. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| 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:297211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: designing db tables for calendar events
http://www.bennadel.com/projects/kinky-calendar.htm On Jan 15, 2008 4:10 AM, Azadi Saryev [EMAIL PROTECTED] wrote: what are you ideas so far? what design have you come up with on your own? --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com Ravi Shankar wrote: I would like your expert help in the same. I am working on a project in which i have to design the web-page for scheduling the meetings online with recurrence option also. The screen is the same as it comes in the outlook express when we schedule any meeting. It has the following fields . .. I need to come up with the table structures for this. Can you pls help me in designing the tables for this. Looking forward for your help. Thanks Ravi ~| 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:296603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: add value to id in js cf
To clarify, the first part of the jquery selector - $('table.tablesorterLQ') - translates to English as Select any table with the class of tablesorterLQ. That is why you don't need to iterate over the multiple tables or use the id attribute. It is already selecting all of those tables and applying the tablesorter functionality to them. Matt On Jan 11, 2008 8:36 PM, Sonny Savage [EMAIL PROTECTED] wrote: You can skip the array creation and loop from the first part of my example, and pretty much copy what Matt did: script type=text/javascript src=jquery.js/script script type=text/javascript src=jquery.tablesorter.min.js/script script type=text/javascript $(document).ready(function(){ $('table.tablesorterLQ').tablesorter({sortList: [[0,0],[0,1]], widgets: ['zebra']}); }); /script On Jan 11, 2008 8:24 PM, Paul Ihrig [EMAIL PROTECTED] wrote: ok. thanks guys i will look at it once my eyes relax a bit. so should i first var aSortTables = $(table.tablesorterLQ); for ( var i = 1; i aSortTables.length; i++ ) to creat the +1 count? or is this not needed. i am not familar with the short cut you mentioned. i dont see in Matts test where the i is invoked in the top part of the js? sorry if i dont make any sense. On Jan 11, 2008 4:34 PM, Matt Williams [EMAIL PROTECTED] wrote: On Jan 11, 2008 2:43 PM, Sonny Savage [EMAIL PROTECTED] wrote: jQuery might even have a shortcut that assigns all the elements of the array at once: $(table.tablesorterLQ).tablesorter({sortList:[[0,0],[0,1]], widgets: ['zebra']}); Sonny is right. What he has should work. Here is some code I have that makes the 2 tables sortable. link rel=stylesheet type=text/css media=screen href=style.css charset=utf-8 / script src=jquery.js type=text/javascript/script script type=text/javascript src=jquery.tablesorter.min.js/script script type=text/javascript $(document).ready(function(){ $('.tablesorter').tablesorter({ sortList: [[0,0],[0,1]], widgets: ['zebra'] }); }); /script cfoutput cfloop from=1 to=2 index=i table class=tablesorter id=tblRep#i# thead tr thname/th thnumber/th /tr /thead tbody tr tdAaron #i#/td td20/td /tr tr tdBill #i#/td td10/td /tr /tbody /table /cfloop /cfoutput -- Matt Williams It's the question that drives us. ~| 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:296470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: A Very Sophisticated Query
Chad, that means order by Transaction_ID descending FIRST, then order by Bin_Name ascending SECOND. So where there are rows with the same Transaction_ID, the order will be by Bin_Name. On Jan 11, 2008 9:39 AM, Chad Gray [EMAIL PROTECTED] wrote: You can do this? ORDER BY BinD.Transaction_ID DESC, Bin.Bin_Name ASC I will have to experiment with that. I did not know this was possible to ORDER each joined table a different way. -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Friday, January 11, 2008 10:02 AM To: CF-Talk Subject: Re: A Very Sophisticated Query *Correction on #2* SELECT BinD.Transaction_ID, BinD.Bin_ID, Bin.Bin_Name, BinD.Serial_ID, Serial.Serial_Name, BinD.Bin_Quantity FROM BinD INNER JOIN Bin ON BinD.Bin_ID = Bin.Bin_ID INNER JOIN Serial ON BinD.Serial_ID = Serial.Serial_ID WHERE BinD.Serial_ID = 2 ORDER BY BinD.Transaction_ID DESC, Bin.Bin_Name ASC On Jan 11, 2008 10:01 AM, Sonny Savage [EMAIL PROTECTED] wrote: Tell me if this is what you're looking for: 1) *BinD Records For a Transaction, most recent BinD first:* SELECT BinD.BinD_ID, BinD.Bin_ID, Bin.Bin_Name, BinD.Serial_ID, Serial.Serial_Name , BinD.Bin_Quantity FROM BinD INNER JOIN Bin ON BinD.Bin_ID = Bin.Bin_ID INNER JOIN Serial ON BinD.Serial_ID = Serial.Serial_ID WHERE BinD.Transaction_ID = 63 ORDER BY BinD.BinD_ID DESC 2) *BindD Records For a Serial, most recent transactions first, the sorted by Bin:* SELECT BinD.Transaction_ID, BinD.Bin_ID, Bin.Bin_Name, BinD.Serial_ID, Serial.Serial_Name, BinD.Bin_Quantity FROM BinD INNER JOIN Bin ON BinD.Bin_ID = Bin.Bin_ID INNER JOIN Serial ON BinD.Serial_ID = Serial.Serial_ID WHERE BinD.Serial_ID = 2 ORDER BY BinD.Transaction_ID DESC On Jan 9, 2008 2:25 AM, Gonzo Rock [EMAIL PROTECTED] wrote: I know there are a few SQL savants on this list so I wanted to see if I might learn something from one of you. I believe this is a very sophisticated query... at least for me it is A real head scratcher ;-) And I really need to figure this out! So here goes... There is some Lot of parts being manufactured ... so we have the Lot Table. Each part in the Lot has a unique Serial ID to identify it in the Lot it belongs to... so we have the Serial Table. Each unique serialized part is broken up into multiple pieces and each piece receives a Bin designation for it's Grade so we have a Bin Table. The pieces are grades several time... and every time the Lot is Graded the results for each Serialized part in the Lot are stored in the BinD (D for Detail), table and they all share the same incrementing Transaction_ID for when the Grading was done. Now the task is two fold. 1st task - Given a Lot_ID, query the most recent BinD_Quantities recorded for each of the Serial_ID's in the Lot. I've been trying to do this by creating loops inside of loops inside of loops, each one running a query at the center of each respective loop. IE Query Lots, Loop through Lots and query Serials, Loop through Serials and query BinD records. But heres the rub(at least for me ;-) How to query the most recent set of BinD records? Or better yet a single query that pulls the results of all the serials for a Trans_ID broken out by Bin_ID, Summed Bin Quantity. 2nd task - Given a Serial_ID, generate a table listing showing the various values the Bins held in the past up to the most recent Grading...(ie, the serial with the highest Transaction_ID) Lot Table Lot_ID, Dev_Name == 1, 2001 2, 2001-A 3, 20012 Serial Table Serial_ID, Serial_Name, Lot_ID(relates to the Lot Table) == 1, 1003204, 2 2, 1003205, 2 3, 1003250, 2 4, 1001231, 1 5, 100121, 1 Bin Table Bin_ID, Bin_Name == 1, Grade A 2, Grade B 3, Grade C 4, Grade D BinD Detail Table BinD_ID, Bin_ID, Serial_ID, Bin_Quantity, Transaction_ID(of the test that generated Group results) == 1,1,1,23,31 2,2,1,15,31 3,3,1,14,31 4,4,1,20,31 5,1,2,13,31 6,2,2,13,31 7,3,2,20,31 8,4,2,13,31 9,1,3,23,31 10,2,3,191 11,3,3,20,31 12,4,3,13,31 13,1,1,23,63 14,2,1,15,63 15,3,1,14,63 16,4,1,20,63 17,1,2,13,63 18,2,2,13,63 19,3,2,20,63 20,4,2,13,63 21,1,3,23,63 22,2,3,19,63 23,3,3,20,63 24,4,3,13,63 25,1,4,12,67 26,2,4,0,67 27,3,4,14,67 28,4,4,17,67 29,1,5,9,67 30,2,5,10,67 31,3,5,24,67 31,4,5,18,67 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial
Re: add value to id in js cf
On Jan 11, 2008 2:43 PM, Sonny Savage [EMAIL PROTECTED] wrote: jQuery might even have a shortcut that assigns all the elements of the array at once: $(table.tablesorterLQ).tablesorter({sortList:[[0,0],[0,1]], widgets: ['zebra']}); Sonny is right. What he has should work. Here is some code I have that makes the 2 tables sortable. link rel=stylesheet type=text/css media=screen href=style.css charset=utf-8 / script src=jquery.js type=text/javascript/script script type=text/javascript src=jquery.tablesorter.min.js/script script type=text/javascript $(document).ready(function(){ $('.tablesorter').tablesorter({ sortList: [[0,0],[0,1]], widgets: ['zebra'] }); }); /script cfoutput cfloop from=1 to=2 index=i table class=tablesorter id=tblRep#i# thead tr thname/th thnumber/th /tr /thead tbody tr tdAaron #i#/td td20/td /tr tr tdBill #i#/td td10/td /tr /tbody /table /cfloop /cfoutput -- Matt Williams It's the question that drives us. ~| 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:296458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Stupid Array Question... Part 2
cfloop from=1 to=#ArrayLen(MyArray)# index=i cfoutput#i#/cfoutput //outputs the key value cfoutput#MyArray[i]#/cfoutput //outputs the element value /cfloop On Jan 10, 2008 9:57 AM, Robert Harrison [EMAIL PROTECTED] wrote: I have a simple array. When I do a dump it gives me the key and one element. Like: Key Value 1 34 2 67 3 52 I want to loop over the array and output the key value and element value. How the heck do I do that. Sample below: cfloop from=1 to=#ArrayLen(MyArray)# index=i cfoutput#MyArray.mykeyvalue#/cfoutput what outputs the key value? cfoutput#MyArray.myelementvalue#/cfoutput what is the name of the element value? /cfloop Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:296358 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: When to purchase Flex
Sounds like a question for Adobe sales team to me. On Jan 8, 2008 3:45 PM, Andy Matthews [EMAIL PROTECTED] wrote: My department has been alotted cash to purchase licsences for Flex in the 1st quarter. I know that Flex 3 is pending, and could be coming out anytime within the next month or two. I have an AIR app that needs to be built in Jan/Feb and so I need Flex 3 to do it. I'm wondering if we purchased Flex 2 now (to get access to the extended Flex 3 beta cycle), if we'd be shooting ourselves in the foot. I don't want to drop $6000 for F2 liscenses only to be told that we don't qualify for the free upgrade to Flex 3. Anyone have suggestions? 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/ ~| 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:296196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion IDE survey
On Jan 7, 2008 1:56 PM, Jerry Guido [EMAIL PROTECTED] wrote: I am a huge fan of Aptana for working with CSS and JS. Take a look at what they are doing with third party JavaScript libraries. Aptana love seems to be a theme in this thread. Maybe we should all hope for this headline ... Adobe buys Aptana, plans killer CF IDE -- Matt Williams It's the question that drives us. ~| 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:296054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Viviotech Outage
On Jan 4, 2008 4:37 PM, Brad Wood [EMAIL PROTECTED] wrote: Well, technically if this is their first outage all year, they are allowed to be down for 8.76 hours and still claim 99.9% uptime. :) 365.25 * .001 * 24 And technically, this is a leap year, so they could claim 366 instead of just 365.25, so 8.784 hours of down time. I'm just glad I'm not having to do the scrambling to get it fixed. What a stress that is. I hope most of us have not been major pests and calling every 5 minutes. I highly doubt any of the VivioTech guys are just playing solitaire while the power is down. -- Matt Williams It's the question that drives us. ~| 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:295922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Webservice from linux vs windows
I thought about case sensitivity and double-checked it all. And I'm not sure where the case sensitivity would be wrong as it fails on the call to the web service... Any other ideas? Anyone? Matt On Dec 29, 2007 12:08 PM, Dominic Watson [EMAIL PROTECTED] wrote: Case sensitivity perhaps? Dominic On 29/12/2007, Matt Williams [EMAIL PROTECTED] wrote: I'm calling several methods on a web service from my win xp dev workstation. It works fine. But the same web service called from my VPS which is on linux does not want to play nice. I get Cannot perform web service invocation theMethodName. Even more odd, is that I can call a different method on the same service successfully. I've tried doing JavaCast on the values sent, among other things. Has anyone seen any such oddity? Other ideas to try? -- Matt Williams It's the question that drives us. ~| 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:295572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Webservice from linux vs windows
That was it Ray. Thanks. Matt On Dec 31, 2007 9:52 AM, Raymond Camden [EMAIL PROTECTED] wrote: Don't forget that when you call a web service, CF caches the WSDL response. If you are editing the WS, you need to refresh the WSDL cache in the CF Admin, or use the refreshwsdl option in CF8. On Dec 31, 2007 9:06 AM, Matt Williams [EMAIL PROTECTED] wrote: I thought about case sensitivity and double-checked it all. And I'm not sure where the case sensitivity would be wrong as it fails on the call to the web service... Any other ideas? Anyone? Matt -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster ~| 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:295588 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Webservice from linux vs windows
I'm calling several methods on a web service from my win xp dev workstation. It works fine. But the same web service called from my VPS which is on linux does not want to play nice. I get Cannot perform web service invocation theMethodName. Even more odd, is that I can call a different method on the same service successfully. I've tried doing JavaCast on the values sent, among other things. Has anyone seen any such oddity? Other ideas to try? -- Matt Williams It's the question that drives us. ~| 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:295525 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ValueList and Peformance
Reviewing some older code, I found this. cfif qKeyword.recordCount lte 150 cfset searchCriteria.tmpIDList = valueList(qKeyword.key) / /cfif qKeyword is the results from a Verity search. The code is taking the key column from that (which translates to the Primary Key) and converting it to a list so that we can run another query to get actual data columns. The query will use WHERE myID IN (#searchCriteria.tmpIDList#). Does anyone know why the developer would have wanted this list only if the record count is LTE 150? The Verity results often return more than 150 records causing the cfset to not run, thus the query to get the actual data columns returns all records (the WHERE myID IN () clause doesn't run at all if tmpIDList isn't there). Doh! Are there any performance issues with using ValueList() on say 500+ records? What about performance of the query for doing WHERE myID IN (#List Of 500+ IDs#)? Other workarounds for this issue? -- Matt Williams It's the question that drives us. ~| 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:294704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ValueList and Peformance
I do know SQL Server has a limit of 2100 parameters in any given query. We have a limit of returning 750 rows to the user anyway, so that shouldn't be a problem. On Dec 13, 2007 12:12 PM, Raymond Camden [EMAIL PROTECTED] wrote: Casey, you mean a list in SQL right? Cuz CF has no limits on Lists as strings. If I remember correctly, a List can only hold so much data. After that I think it just cuts off. I can't remember. for something like ID's it should be ok with 500 records. For search terms you would be running close to the limit. -- Matt Williams It's the question that drives us. ~| 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:294716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: VPS hosting, anyone?
I've been hosting with Viviotech for a little over a year now and couldn't be happier. The support has been great when I need it. Not having to worry about the Shared Hosting headaches I read about so much on this list is worth a little extra price to me. Not to mention my cost is offset by the clients' annual hosting fee anyway. Note, though, that pricing for a CF8 setup is significantly higher than CF7. $70/mo higher at VivioTech ($25 vs $95). With a year or more contract, that $95/mo is approaching the price of just outright buying a copy of Standard for yourself. On Dec 13, 2007 11:54 AM, Rizal Firmansyah [EMAIL PROTECTED] wrote: Hi Guys, i need your input on choosing VPS hosting service. Anyone using it? Any pros and cons on using shared vs vps vs dedicated machine? Thanks, Rizal ~| 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:294726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Filemaker Pro
A client has a pre-built system on Filemaker Pro 9. The db is hosted. The website is on a different host. Am I able to remotely query that db with CF? If so, what is involved? Does the Filemaker host need to do anything special other than provide me with the IP, db and login info? I'm guessing I would need the Filemaker JDBC driver installed on the CF server. Any pointers are appreciated. -- Matt Williams It's the question that drives us. ~| 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:294628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC Not acting like I expect
You have specified the returnType as query, but you seem to be returning only the ID. Change one or the other to make it happy. On Nov 6, 2007 10:43 AM, Bruce Sorge [EMAIL PROTECTED] wrote: I have a CFC that both inserts a series of field variables and returns the ID number that was just created. I am getting an error that states the value returned from the insertProposal function is not of type query. Here is the function: cffunction name=insertProposal access=public returntype=query cfargument name=BidType type=string required=yes cfargument name=Number type=string required=yes cfargument name=Description type=string required=yes cfargument name=Contact_Name type=string required=yes cfargument name=Contact_Phone type=string required=yes cfargument name=Contact_Email type=string required=yes cfargument name=Job_Walk_Date type=string required=yes cfargument name=Job_Walk_Time type=string required=yes cfargument name=Status type=numeric required=yes cfargument name=Create_Date type=date required=yes cfargument name=Create_Time type=string required=yes cfset propID=foo cfstoredproc procedure=pr_InsertRFP datasource=#Request.dsn# cfprocparam cfsqltype=cf_sql_varchar dbvarname=BidType type=in value=#Arguments.BidType# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Number type=in value=#Arguments.Number# cfprocparam cfsqltype=cf_sql_longvarchar dbvarname=Description value=#Arguments.Description# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Contact_Name type=in value=#Arguments.Contact_Name# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Contact_Phone type=in value=#Arguments.Contact_Phone# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Contact_Email type=in value=#Arguments.Contact_Email# cfprocparam cfsqltype=cf_sql_date dbvarname=Job_Walk_Date type=in value=#Arguments.Job_Walk_Date# cfprocparam cfsqltype=cf_sql_time dbvarname=Job_Walk_Time type=in value=#Arguments.Job_Walk_Time# cfprocparam cfsqltype=cf_sql_integer dbvarname=Status type=in value=#Arguments.Status# cfprocparam cfsqltype=cf_sql_date dbvarname=Create_Date type=in value=#Arguments.Create_Date# cfprocparam cfsqltype=cf_sql_time dbvarname=Create_Time type=in value=#Arguments.Create_Time# /cfstoredproc cfreturn propID /cffunction When I run the page, the insert query works. I captured the SP in SQL Profiler, copied it into a new query in SQL Server Manager, and it inserts the information and returns the newly created ID as it should, so I am baffeled. Perhaps I need another pair of eyes to see what might end up being a glaringly obvious error on my part. Thanks, Bruce ~| 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:292770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFM page loads, then closes immediately.
On 11/1/07, Andy Matthews [EMAIL PROTECTED] wrote: I suspect it might have to do with the location (in code) of the cfheader/cfcontent blocks. Aren't they supposed to come first in the doc? Hey Andy, have you tried other settings for the cfheader/cfcontent tags? Here's what I've used and seems to work in FF and IE. And I do have them at the end of the file, though I don't think it matters. cfheader name=Content-Disposition value=attachment; filename=#fileName# cfcontent type=application/vnd.ms-excel file=#myFilePath# deletefile=true / -- Matt Williams It's the question that drives us. ~| 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:292500 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFM page loads, then closes immediately.
Doing the attachment part of value makes the prompt come up for the user to save or open the spreadsheet. #filename# is the suggested name of the file if the user selects to save it. file=#myFilePath# and deleteFile=true are probably not needed in your case. In my case, I'm actually creating an excel document (not just sending html to excel) that gets saved on the server, then sent to the client. On 11/1/07, Andy Matthews [EMAIL PROTECTED] wrote: I'm experimenting with it right now. I've determined that it's the cfcontent tag that's causing the issue. But that's also the portion that causes the page to be an Excel file though. Removing it allows the page to load, but it loads as a plain HTML page, and not as a triggered Excel file download. I'll give your code a try. In the lines below, what's the difference between #filename# and #myFilePath#? -- Matt Williams It's the question that drives us. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OOP Coldfusion
The quick way to fix this issue is to just set the argument type to any. Coldfusion is dynamic and can handle that just fine. However, this can make debugging the app more difficult because instead of getting a helpful type-casting error, you may get something like tthe method cannot be found, further down the line of code execution. The slower way to fix this issue, and probably the better in the long run way, would be to learn and use ColdSpring to handle your object instantiation and dependencies. Using ColdSpring, you would declare the classes and their dependencies in an xml file and then do something like cfset page = application.CSFactory.getBean('page') / It will already have an instance of head in it because of the xml declarations. Matt On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Hi All, I'm working on an OOP project and am having a bit of a problem with objects referencing each other. My folder structure is /siteRoot/ /siteRoot/core (Where all my classes are) /siteRoot/core/valueObjects I'm quite early on in the build so I'm just setting up my value classes. I've got two classes in there, one called Page, the other called Head. Back at the root I'm instantiating these classes in a cfm file called testing. cfset page = CreateObject(component,core.valueObjects.Page).init() cfset head = CreateObject(component,core.valueObjects.Head).init(title:This is a new title) So far so cool. The problem is that one of the properties of the Page class is a Head object. This is populated with this function in the Page class cffunction name=setHead access=public hint=Sets the Head Object cfargument name=head type=core.valueObjects.Head required=yes cfset variables.head = ARGUMENTS.head /cffunction However when I call the function from the testing page with : cfset page.setHead(head) I get an error : - The HEAD argument passed to the setHead function is not of type core.valueObjects.Head. When as far as I'm concerned it is. The fix I came up with is to change the argument in the setHead function to be only Head. Now this sort of works as Page and Had live in the same folder, but I can see problems further down the line unless I get this clear in my head. So am I a - doing this wrong, should there be a special place or method of creating CF classes where they can reference each other with complete class paths? b - Just accept that the classes can only reference each other relatively? c - Go back to actionscript and stop pretending to be a server side coder? Thanks in advance Tim ~| 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:290859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
On 10/11/07, Matt Williams [EMAIL PROTECTED] wrote: On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Having said that tho - which is the best framework? ColdMachTransfer-ReactorFuseGlue But be sure to get the BER from SVN or CVS or Walgreens, or something. :P -- Matt Williams It's the question that drives us. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP Coldfusion
On 10/11/07, Tim Ashworth [EMAIL PROTECTED] wrote: Having said that tho - which is the best framework? ColdMachTransfer-ReactorFuseGlue -- Matt Williams It's the question that drives us. ~| 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:290878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invoking component
On 10/10/07, Bruce Sorge [EMAIL PROTECTED] wrote: OK, so I see that there are at least three ways to invoke a component. Using the CFINVOKE tag, CFSET and wrapped in CFSCRIPT. So what is the best method? Or are there different situations where you would use one or the other? I would think that each has an advantage and disadvantage. I typically use CFINVOKE, although recently I have been using the CreateObject method in a CFSCRIPT tag. http://www.coldfusionjedi.com/index.cfm/2007/4/15/Ask-a-Jedi-cfinvoke-and-createObject -- Matt Williams It's the question that drives us. ~| 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:290773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Name of uploaded file before cffile
Right Ian. I understand that part. But consider this: 1) User uploads myFile.txt 2) CF puts it into c:\temporary\directory\neo12345.tmp 3) Form field value has c:\temporary\directory\neo12345.tmp 4) code calls cffile action=upload ... / 5) If I did not specify a new file name in the destination attribute, the file retains the myFile.txt name. 6) If I specified a variable for the result attribute (e.g. myUploadResult), I can get to that file name via myUploadResult.clientFile My question, and this is more out of curiosity than anything, is how does CF remember the original user's file name of myFile.txt between steps 3 and 4 above. Looking through the various scopes doesn't seem to reveal it. The form field, as you mentioned is a random name in a temporary directory. Matt On 10/10/07, Ian Skinner [EMAIL PROTECTED] wrote: Back from an unintentionally long weekend. I presume the file name is part of the HTTP data sent by the browser through the web server to ColdFusion. If you output the form file field you will see a long random character name of the temporary file created by the web server that is where ColdFusion gets the file to move where specified by the cffile call. ~| 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:290774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AOP in ColdSpring and ModelGlue
My understanding of AOP is that it really shouldn't affect the process flow of a request. Partly because it would be messy for it to have access to the request (event, or whatever). And partly because it just isn't what AOP is for. As Brian mentioned, things like logging are more appropriate. I have also used it for a notification type of service where if certain data changes, I fire off an email. The advice is not changing any data, but simply comparing old with new and acting upon that comparison. AOP seems to make more sense for behind the scenes type of stuff, not validation where a request will be changed based on the results of that validation. -- Matt Williams On 10/8/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Brian, Thanks a great deal for the detailed reply, it does help make things a little clearer. You're right to say that my example was hardcoded values and this would most defiantly be difficult to validate using AOP, however in a real working example I have a nice little validation service adapted from Javier Julios data Validator component which allows me to define data validation rules for variables by name, so the advice object would be passing the variable 'name' off to the validation service and the service would then find the correct rules for that variable and test it against them accordingly. So in my case, being able validate variables on the fly using AOP is certainly plausible. Like you say the general principle of this process should be identical regardless of whether I'm using MG or not, however the problem that arises with MG is that the only way I can currently see this working is to adapt my controllers so they contain a conditional which watches for returned values from the proxy, and if there is one then act upon it by pushing the user back to the form, however this seems to totally eliminate the benefits of an AOP approach to the concerns as the whole point of AOP is to eliminate code which doesn't concern the business logic. If we're using something like before or after advice then this isn't a problem as its effectively non responsive and has no control over the work flow, however when trying to apply this 'about' advice, I can't see how it can be done without defeating its own purpose of having to watch for returned values. Unless of course we can give the advice object access to the event object. Thanks again mate, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 08 October 2007 15:10 To: CF-Talk Subject: Re: AOP in ColdSpring and ModelGlue The fact that you're using Model-Glue should make no difference at all. If it is, then you're thinking about it the wrong way. I see a few problems with what you've said: - AOP is really meant to eliminate duplication by encapsulating a generic, common process so that it can be reused across many method calls or components. I'm not sure validation really qualifies, since it is so specific to the particular object or data being validated. Usual suspects for AOP include logging, security, and data formatting. So I'm not sure if what you're doing really lends itself to AOP in the first place, since I don't see how your code is reusable. The example you gave is hardcoding a call to getName() which already means this advice is really not going to work with other kinds of data. - You're right that the advice has no access to the Model-Glue event object. It shouldn't. You have access to whatever arguments were passed into the original method, and access to any return value from that method. So if your UserService returns an object or a struct indicating success or failure, along with error messages, you can manipulate that before it gets returned back to the controller. Basically, if you can imagine dropping Model-Glue and having a web service call your Service (and your advice), and having it work and return data that the web service could use, then you're at the right conceptual level. Whenever this won't work (for example, you're wanting the advice to have access to the Model-Glue event object, which obviously would be extremely difficult if the client was a web service instead of Model-Glue), it means you aren't keeping your application layers properly encapsulated. Hope that helps. Brian On 10/8/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Now this is where I become a little confused, see, in the old days I would validate the data inside my controller, and if the data failed validation I would add a result of 'failed' and update the viewstate with an error message, then use the events xml definition to pass the user back to the form if the result of 'failed' was present. However, from what I can see here I have no access to the event object from my advice object, so I'm not able to add results or update the view state
Re: CF Coding Standards
On 10/8/07, Rick Root [EMAIL PROTECTED] wrote: cfif spouse_exists and arguments.clear_spouse and arguments.recurse Man, sometimes I wish I could clear my spouse's arguments too. Her arguments make me want to recurse too. -- Matt Williams It's the question that drives us. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Name of uploaded file before cffile
Is it possible to get the name of the client's file before doing cffile? I am testing for file size by doing a cfdirectory and filtering on the neoX.tmp file name provided in the form field. If the file size is too large, I would like to tell the user which file (this is a multiple upload form) was denied. I know I could upload the file to a temporary location and then move it, but that is more than I want and defeats the purpose in a way. I'm pretty sure the answer is no, but just wanted to double-check. Thanks, -- Matt Williams It's the question that drives us. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Name of uploaded file before cffile
On 10/5/07, Ian Skinner [EMAIL PROTECTED] wrote: I'm pretty sure the answer is no, but just wanted to double-check. Thanks, Yup, the answer is no. Before CF has a chance to do anything, the browser has read the file from the client's machine, bundled it into the response header, sent the whole kit-n-caboodle to the web server, the web server has parsed out the file from the header and sent it onto ColdFusion. Then ColdFusion can start doing something with it. So by this time the file has long been uploaded and transfered across the networks. If you want to do anything before this, it is going to have to be done client side. I figured as much, but out of curiosity, where does CF get the file name from? It would seem it has to be somewhere temporarily between the .tmp file and the actual cffile call. Does it reside in the actual file meta data or something? Matt ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Name of uploaded file before cffile
Yea I'm doing the hidden field thing. It's just one of those things I guess. I'm still curious as to where CF gets the file name from after doing the cffile call. Thanks Matt On 10/5/07, Brad Wood [EMAIL PROTECTED] wrote: The form post must complete before any ColdFusion runs. By that time, it is too late because the file is already uploaded. You need something on the client. Perhaps some flash could determine that... ~Brad -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Friday, October 05, 2007 12:00 PM To: CF-Talk Subject: Name of uploaded file before cffile Is it possible to get the name of the client's file before doing cffile? I am testing for file size by doing a cfdirectory and filtering on the neoX.tmp file name provided in the form field. If the file size is too large, I would like to tell the user which file (this is a multiple upload form) was denied. I know I could upload the file to a temporary location and then move it, but that is more than I want and defeats the purpose in a way. I'm pretty sure the answer is no, but just wanted to double-check. Thanks, -- Matt Williams It's the question that drives us. ~| 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:290393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I'm completely Stumped - All I want to do is ...
Don't understand. You want the mouse coordinates when they click Submit? Or some other time? You say you want to capture the coordinates, but on what event? On 10/5/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: All, Sorry for the repeat post. I've searched all day for a solution and can't find anything. I want to capture the coordinates from this sample and pass them for use in a cf scope. I'm stumped! http://dunnbypaul.net/js_mouse/ If I could only get the x and y coordinates in a form in the action param and pass them URL scope then use ... cfset RIGHT = #ListFirst(CGI.QUERY_STRING)# cfset DOWN = #ListLast(CGI.QUERY_STRING)# ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trying to understand the CF8 - .Net integration
Come on Vince. Some people is a terrible way to make an argument. Some people survive suicide attempts. Some people smoke a pack of cigarettes a day and live to be 100. For the cost issue, if that is all it boils down to, why not go with all open-source/free? Plenty of job seekers there too. On 10/3/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 02 Oct 2007, [EMAIL PROTECTED] wrote: 1. Licensing costs. Some people balk at paying $7500 per CPU pair for CF Enterprise when ASP.NET is included in Windows at no cost. ASP has less features than CF8. It depends what you use. And of course, if you use CF you can avoid the Microsoft O/S tax. 2. Performance and realiability. Some people find they get better performance and realiability of their web applications running .NET rather than CF. I've never been convinced by this. I think this happens when people switch because they're rewriting the app from scratch, removing all the cruft and sticky plaster. 3. Developer tools. Some people find that the tools available for ASP.NET development--especially Visual Studio--are superior to tools available for CF development. This is probably true. CFEclipse is good, but it's not Flex Builder. 4. Developer availability. Some people find it's easier to hire trained, experienced ASP.NET developers than it is to find and hire trained, experienced CF developers. I agree. We can't seem to get hold of a decent extra one for love or money ! I realize I have to tread carefully here, so again, I'm not advocating that anyone should switch from CF to .NET, but am disputing Dave's statement that, it's almost never a good idea to switch from CF to .NET I'd dispute the unqualified version too. -- Tom Chiverton Helping to completely brand viral solutions on: http://thefalken.livejournal.com -- Matt Williams It's the question that drives us. ~| 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:290071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conferences
http://www.coldfusionportal.org/ On 9/26/07, William Seiter [EMAIL PROTECTED] wrote: WOW!! There is some 'seriously' dated information on that page... William -- William E. Seiter Web Developer http://William.Seiter.com -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 25, 2007 9:42 PM To: CF-Talk Subject: Re: Conferences Yeah, there's http://www.cfconf.org/ -- nathan strutz http://www.dopefly.com/ On 9/25/07, Dale Fraser [EMAIL PROTECTED] wrote: Is there a list of all the CF conferences somewhere. I need to organise a trip to the US and thought it would be nice to hit a CF conference in the process. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289495 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 Tab Issue
On 8/29/07, Rey Bango [EMAIL PROTECTED] wrote: There's a little more that needs to be said. I am not knocking jQuery Then I take it you agree that my analogy is a little better. Comparing jQuery to a Hyundai Excel was a bit of a knock and I hope I've offered a different perspective by comparing it to a Ferrari. Rey, I think you mis-read Andrew's comment: Now to make a comparison against CF8 and jQuery is like making a comparison with a Hyundai Excel and a Jaguar. This means that CF8 is the Hyundai (as far as it's Javascript abilities) and jQuery is the Jaguar. -- Matt Williams It's the question that drives us. ~| 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:287376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple File Uploading
My challenge is to provide a tool for uploading multiple files that gives a progress/status bar as each is uploading. From what I understand (and I'm not an expert), the progress bar part can only be done with some sort of client side solution: ActiveX, Flash or CGI script. Although I really like this one: http://www.element-it.com/MultiPowUpload.aspx, we want a non-Flash solution to accommodate those 2 or 3 users that don't/can't have flash installed. I'm thinking that the ActiveX part is out as it also requires an install. There are some cheap/free Perl CGI scripts, but can my Windows server run this? We currently have CF7, Windows Server 2003, IIS 6. I don't know anything about Perl. Is it possible to use something like this? Or is there another solution I am missing? Thanks for any tips. -- Matt Williams It's the question that drives us. ~| 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:287375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Auto refresh new form field
Or just a 2 select related type deal. Depending on how many colleges are in your list, it would be a lot of pre-loaded data, but doable. http://www.google.com/search?hl=enq=coldfusion+related+selects Matt On 8/28/07, Raymond Camden [EMAIL PROTECTED] wrote: Have you looked at CF8's ajax stuff? It would allow for this. Otherwise - you can try Spry as well. On 8/28/07, Jim Harmer [EMAIL PROTECTED] wrote: I'm a beginner and I'm having the hardest time with inserting a record to the database from a form. The problem is that I want the site to be open to all colleges across the nation. I have a list of all of the colleges, but it's WAY too many for a pick list. I know how to have them search the database for their college, but they might type ASU instead of Arizona State and therefore wouldn't find their college. I want them to choose their state in one form field and have the page auto refresh with a new pick list of just the colleges in that state under it. Is there an easier way? If not, how in the world do I do that? THanks. ~| 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:287309 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: Javascript MouseOver
missing a comma after left=450 ? On 8/21/07, Steve LaBadie [EMAIL PROTECTED] wrote: I have created a mouse over effect and it works fine. The only problem I am having is that the top= in the below example does not work in Firefox. Are there any ideas to resolve this issue? The window stay at the top instead of coming down 350px. Code: script type=text/javascript !-- function openWindow(url, name) { myWin = window.open(,, width=200,height=100,left=450 top=350); myWin.document.write (bodyfont style='font-size: 11px; font-family: verdana;'Blah Blah Blah./font); myWin.document.write (/body/html); myWin.document.close(); } function closeIt() { if (!myWin.closed) myWin.self.close() } //-- /script Calling Link: a href=https://ssl.esu.edu/1card/; target=_blank onMouseOver=openWindow() onMouseOut=closeIt() onClick=return falseLink/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| 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:286743 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: Installing Apache Server w/CF 7
Look for httpd.exe in a bin directory. On 8/14/07, Andy [EMAIL PROTECTED] wrote: I am trying to create a development environment with CF 7 Apache server. I've downloaded and am using The ACME Guide as help. I've successfully installed Apache 2.2.4 and am now installing CF 7.01 and when selecting the server, the ACME Guide says to set the Directory and file name of server binary - C:\Program Files\Apache Group\Apache2\bin\Apache.exe. This file doesn't exist in this directory nor anyplace on my PC. What file should I be seting here? Andy ~| 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:286187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GotCFM.com Approaching 1000 Sites - Contest/Prizes
Rey, I could add a couple hundred or so to the list. Most are somewhat brochure ware and may only use cfinclude and cfmail (for contact form) for its only cfcode. But many of them are also database powered. However, I do not see myself having the time to enter these into the form. Perhaps there is an easier way such as via a spreadsheet or something. I could work on a list slowly and send it to eventually. -- Matt Williams It's the question that drives us. On 8/10/07, Rey Bango [EMAIL PROTECTED] wrote: Hi everyone, I'm very happy to announce that GotCFM.com is just 10 sites shy of reaching 1000 CFML-Powered sites. This is really an awesome achievement and helps to show that CF-technologies are very relevant in today's Internet development efforts. ~| 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:285975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DW8 download?
I have the exe installer (windows) and the 8.02 updaters. I don't think there would be any reason I couldn't send it to you somehow. On 8/8/07, Eric Roberts [EMAIL PROTECTED] wrote: I couldn't find it either when I reinstalled the OS on my laptop...which forced me to go get eclipse... Eric -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:09 AM To: CF-Talk Subject: DW8 download? Anyone have a link to the Dreamweaver 8 downloads? I need to get that version. We have our own key for it just need to re-install. ~| 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:285767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Violation of primary key error - how to troubleshoot
I need help in how to troubleshoot this issue. I get this error when trying to do an insert. Violation of PRIMARY KEY constraint 'pk_FieldName'. Cannot insert duplicate key in object 'SomeTable'. The field in question is the primary key and is an identity column set to auto-increment by 1. How can a table set to auto-increment violate a primary key? This is SQL Server 2005. I first got it in a CF page, but get the error even if running the query directly in a query window in SQL Server Management Studio. -- Matt Williams It's the question that drives us. ~| 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:282747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Violation of primary key error - how to troubleshoot
Thanks Ian and Will. I should have explained better, or at least shown the SQL. I'm not trying to insert the ID field, just the other fields. Will, no I cannot manually enter the data. I'm going to pass it off as corrupt data for now (this is on a testing db) and see if it resolves itself after refreshing that db. Matt On 7/2/07, Will Tomlinson [EMAIL PROTECTED] wrote: I need help in how to troubleshoot this issue. I get this error when trying to do an insert. Can you manually enter the data into the table? ~| ColdFusion 8 beta â Build next generation applications today. Free beta download 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:282751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Anyone with jExcel experience?
I'm trying to use the jExcel java utility to read an Excel template, replace an image (logo) and save it with a new name. I am having trouble on the first step - reading the excel template. I am able to create a new, blank workbook, so I believe the jar file is installed correctly (placed in c:\CFusionMX7\lib). The method to read a book is public static Workbook getWorkbook(java.io.File file) However, when I call getWorkbook, I get an error saying that method cannot be found. Here is what I have that will throw that error. workbook = createObject(java,jxl.Workbook); file = createObject(java,java.io.File).init(C:\invoice.xls); workbook = workbook.getWorkbook(file); Looking for any ideas here as I have run out myself. -- Matt Williams It's the question that drives us. ~| 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:280465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone with jExcel experience?
I forgot to add that if anyone has another way to do this, I am open to that too. I have banged my head up against the Jakarta POI api wall for a solution to this too. There I am able to open an excel file and resave it, but the image part doesn't seem to work for me. I get File error: data may have been lost when opening the excel file. I can post the code I've been using here if it would help anyone. -- Matt Williams It's the question that drives us. ~| 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:280467 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone with jExcel experience?
Thanks for replying guys. After playing with both of your code samples, it turns out my problem was using the word file as my variable name. That is a keyword in java so doing getWorkbook(file) was breaking. On to the next step. Has anyone taken an existing image and put it into a spreadsheet via jExcel? I'm getting a similar error, but this time on the ImageIO java class. I've checked variable names to make sure that isn't the problem. Here is what I have so far (after getting a workbook and a sheet): img = createObject(java, java.io.File).init(c:\smallBox.png); my_input = createObject(java,javax.imageio.ImageIO).read(img); my_baos = createObject(java,java.io.ByteArrayOutputStream); ImageIO = createObject(java,javax.imageio.ImageIO); ImageIO.write(my_input, png, my_baos); wi = createObject(java,jxl.write.WritableSheet).init(javaCast('double',1), javaCast('double',1), javaCast('double',10), javaCast('double',10), img); sheet.addImage(wi); On 6/8/07, Paul Hastings [EMAIL PROTECTED] wrote: Matt Williams wrote: create a new, blank workbook, so I believe the jar file is installed correctly (placed in c:\CFusionMX7\lib). stop/restart the cf server service? workbook = createObject(java,jxl.Workbook); file = createObject(java,java.io.File).init(C:\invoice.xls); workbook = workbook.getWorkbook(file); well i normally would do something like: cfscript spreadsheet=createObject(java,java.io.File).init(C:\invoice.xls); workBook=createObject(java,jxl.Workbook).getWorkbook(spreadsheet); .. .. .. .. /cfscript ~| 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:280479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone with jExcel experience?
Okay. I got it working. Definitely some java strictness going on. And being pretty much java stupid, I did much trial and error to get this to work. I'll post code here and maybe blog it later so hopefully anyone in the future can find it. Using jExcel, I was able to open an existing spreadsheet, make a copy, put in an image an save the new file. !--- Get java Input File of spreadsheet template --- cfset fileInput = createObject(java, java.io.File).init(c:\invoice.xls) / !--- Get instance of jExcel Workbook object --- cfset wb = createObject(java,jxl.Workbook) / !--- Read that File into the workbook object --- cfset wb1 = wb.getWorkbook(fileInput) / !--- Create an output file for copying to --- cfset fileOutput = createObject(java, java.io.File).init(c:\invoiceCopy.xls) / !--- Create a copy of the original workbook object --- cfset wb2 = wb.createWorkbook(fileOutput, wb1) / !--- Get the first sheet (zero based) in the workbook --- cfset sheet = wb2.getSheet(javaCast('int',0)) / !--- Get java Input File of the image --- cfset myImg = createObject(java, java.io.File).init(c:\CityBoyntonBeach.gif) / !--- Read that image into a java ImageIO object (allows us to get width and height, etc.) --- cfset myInput = createObject(java,javax.imageio.ImageIO).read(myImg) / !--- Get instance of java ByteArrayOutputStream. This is used to convert the image to PNG. Be sure to call init() here or things break. --- cfset myBaos = createObject(java,java.io.ByteArrayOutputStream).init() / !--- Convert the image to PNG, storing it into the ByteArrayOutputStream just instantiated. --- cfset ImageIO = createObject(java,javax.imageio.ImageIO).write(myInput, javaCast(string,PNG), myBaos) / !--- Get the width and height of the image divided by some excel default values. Without this the image is enlarged incorrectly --- cfset myWidth = myInput.getWidth() / 64 / !--- 64 is default width of an excel cell (in pixels maybe?) --- cfset myHeight = myInput.getHeight() / 17 /!--- 17 is default height of an excel cell --- !--- Put image into a jExcel writable image object, parameters are column number(zero based), row number (zero based), width, height, image --- cfset wi = createObject(java,jxl.write.WritableImage).init(javaCast('double',1), javaCast('double',0), javaCast('double',myWidth), javaCast('double',myHeight), myBaos.toByteArray()) / !--- add the image to the sheet. --- cfset sheet.addImage(wi) / !--- Save and close. --- cfset wb2.write() / cfset wb2.close() / -- Matt Williams It's the question that drives us. ~| 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:280484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Set server var at startup?
I think I did hear Ben Forta say server variables are not recommended. I can't remember any reasons why though. My question would be how are you setting the server variable? Going back to Phil B's original question of can you set it at server startup? No. So if you are setting server variables in Application CFC, then it seems to me that the variable is actually an application variable. The company I work for now uses a platform config xml file which has server settings (which are specific to the server and application). So each app has it's own config file, with sections in it per server. Matt On 6/8/07, J.J. Merrick [EMAIL PROTECTED] wrote: geez hold of the dogs, I will rescind my statement and chalk it up to a friday misrant. On 6/8/07, Dave Watts [EMAIL PROTECTED] wrote: Creating server variables are not recommended so there may be another route you can take. Not recommended by whom, exactly? This kind of blanket statement is almost always unwarranted. There is nothing wrong, generally, with using server variables. 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 ~| ColdFusion 8 beta â Build next generation applications today. Free beta download 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:280494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Set server var at startup?
And even if onServerStart() did exist, putting it in Application.CFC does not make sense to me. We would need a Server.cfc or something that existed outside of webroot, possibly in the JRun/CFusionMX directory. Or maybe you could just set some server variables in the CF Administrator, the way we define mappings or Data sources, etc. It would need to be something that was loaded automatically whenever the CF service was started. On 6/8/07, Dave Watts [EMAIL PROTECTED] wrote: Not if the variables are set in the onServerStart method. To the best of my knowledge, there is no such event method in CF 7. While you could write a method and call it onServerStart, it wouldn't run when the server started. 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 ~| ColdFusion 8 beta â Build next generation applications today. Free beta download 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:280502 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Subversion and Dreamweaver 8
Elena, if you do go with Dreamweaver, you will need an external Subversion client such as Tortoise to manage updating and committing your local working copy. As far as I know (DW 8), DW does not have anyway to natively support access to a SVN repository. Matt On 6/8/07, Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Elena, My advise for you would be to use Eclipse instead of Dreamweaver. You can then download CFEclipse which is the plug in for Eclipse and then following that install SVN which is the subversion for Eclipse. From that point on you need to get acquitted with the workbench in Eclipse and a few other things. Ravi. Elena Aminova wrote: I was asked to select and configure code repository for our development environment and since I have heard and read so much about subversion, so far it is my pick, unless anyone has any compelling reasons for me not to. The questions I have are the following: How does Subversion version control system work with Dreamweaver 8? Any other open source alternatives to Subversion (using Apache OS)? 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:280503 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Set server var at startup?
On 6/8/07, Ravi Gehlot [EMAIL PROTECTED] wrote: Matt, As far as I know if you server scope your variable it will be available throughout your entire application as well as to all of the other applications on that server. Depending on how your network is set up that server scoped variable might be available throughout a node of servers also. In my view, putting it on Application.cfc does make sense because the application uses functions to called methods so if onServerStart existed it could be called as a method through cffunction via the cfcomponent on the Application.cfc file. Right Ravi. I was referring to a hypothetical onServerStart that would be supported by Adobe, not one that I the developer manually added to App.cfc. If the idea were to exist, then what I said would be the case. -- Matt Williams It's the question that drives us. ~| 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:280507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Set server var at startup?
On 6/8/07, Dave Watts [EMAIL PROTECTED] wrote: So if you are setting server variables in Application CFC, then it seems to me that the variable is actually an application variable. unless the variable is intended for use across multiple applications. True, the intention may be for server wide use, but how is it managed? Is there a mother-App.cfc that all the other App.cfc's extend? Or does each App.cfc have it's own copy of the server variables? Or is there one app that must be started before others are? Seems kinda dangerous either way you work it. Room for error. -- Matt Williams It's the question that drives us. ~| 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:280512 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks)
On 5/9/07, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 5/9/07, Aaron Roberson [EMAIL PROTECTED] wrote: Where can I learn how to do the above. That is very cool stuff that I have neglected heretofore. At the risk of self-promotion, you could check out my class at CFUnited, which is covering SVN, Ant, and a host of other related technologies for getting started with development best practices. http://www.teratech.com/go/classdetails?trainingaction=detailTID=274 Aaron, I understand not being able to make it to CFUnited. And because John Paul is humble, I will also mention that he is available for consulting on these types of issues. Getting yourself setup with subversion correctly is money well spent. I have worked with John and can vouch for his level of expertise in this matter. With that said, if you want to go the poor man's route, you can do so. It just requires a bit more effort and time on your part. Here are some resources to get you started: A pretty good blog entry about the concept of version control in a CF environment: http://www.ryanguill.com/blog/?mode=entryentry=897E322E-40CA-6D1C-8A4C3B3FE67B7FD9 Free online book about subversion (the manual): http://svnbook.red-bean.com/ Googling subversion and coldfusion turns up quite a bit of useful links, including this one: http://www.robgonda.com/blog/index.cfm/2005/7/7/Subversion-up-and-running-in-30-minutes-or-less Just a note as I'm not sure if it has been made clear. To use source control, such as subversion, you do not have to use Eclipse. You should use source control even if you stick with Dreamweaver. In either case you need a client program to interact with the subversion server. Subclipse is a way to do it directly in Eclipse. Tortoise seems to be the most popular way outside of eclipse. It simply provides right-click context menus on any directory that is part of a source control repository. Hope that helps. -- Matt Williams It's the question that drives us. ~| 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:277437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Verity help with @ symbol
I am doing a simple search. And I have read the manual (although I'll admit not in as much depth as I did today). The @ symbol is definitely a headache for me. Perhaps I have created the index in a weird way or something. But basically I used a query to create it, with the user first name, last, email, etc. If I search on [EMAIL PROTECTED], I get no results. But searching on just testEmail gets results, showing the email in there. I've tried it with the @ symbol escaped (using @@, \@, [EMAIL PROTECTED]). Any insight, or possibly someone being able to replicate would be much appreciated. Thanks, Matt On 3/15/07, Dinner [EMAIL PROTECTED] wrote: What kind of verity search are you doing? I think that will change what is escaped, etc, etc.. RTM for verity searches, I think that's covered in there. FWIW, I usually do the websearch kind, when I use it. HIH! On 3/15/07, Matt W wrote: I have a verity collection of usernames, email addresses, etc. When searching on somename@, I get results, but if I search on [EMAIL PROTECTED], no results are found (yes assuming that email address does exist). Basically, if I add anything after the @ symbol, verity results croak. Here is attribute I am using from the cfsearch tag: criteria=`#Lcase(arguments.searchCriteria)#`* If I remove the backquote, I get no results with the @ symbol, regardless of what's before or after it. I have tried various other iterations of the wildcard before and after the backquote, and without it altogether. Hoping someone has overcome a similar issue, -- Matt Williams It's the question that drives us. ~| 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:272891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Verity help with @ symbol
I have a verity collection of usernames, email addresses, etc. When searching on somename@, I get results, but if I search on [EMAIL PROTECTED], no results are found (yes assuming that email address does exist). Basically, if I add anything after the @ symbol, verity results croak. Here is attribute I am using from the cfsearch tag: criteria=`#Lcase(arguments.searchCriteria)#`* If I remove the backquote, I get no results with the @ symbol, regardless of what's before or after it. I have tried various other iterations of the wildcard before and after the backquote, and without it altogether. Hoping someone has overcome a similar issue, -- Matt Williams It's the question that drives us. ~| 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:272762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How Many CF Developers Are There: Dave Mendels Says 300K
Created almost a year ago: http://www.frappr.com/cfdevelopers On 3/1/07, Kevin Aebig [EMAIL PROTECTED] wrote: Wow... that's reminds me of the days of Flash 3 when I heard a Java guy say that Flash would never touch the popularity of Java... Web 2.0 is the real deal and you can't touch Flex for RAD. !k -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 5:40 PM To: CF-Talk Subject: Re: How Many CF Developers Are There: Dave Mendels Says 300K And to add I very much doubt Flex users will ever suprecede ColdFusion users. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: greg h To: CF-Talk Sent: Wed Feb 28 23:05:41 2007 Subject: How Many CF Developers Are There: Dave Mendels Says 300K Just an fyi ... John Dowdell excerpted some comments that Dave Mendelshttp://www.adobe.com/aboutadobe/pressroom/executivebios/davidmendels ...htmlhad posted last month: http://weblogs.macromedia.com/jd/archives/2007/02/flex_adoption.cfm Specific quote from Dave Mendels: We have an active community of about 300K ColdFusion developers, well over a million Flash designer/developers, and several million Dreamweaver customers. The post that Dave was commenting on was written by Shashank Tiwarihttp://www.oreillynet.com/pub/au/2799who started his post out with: Today we have between 3 and 4 million Java developers. g ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: A question about CFCFactory objects as a singleton ....
I choose [B]. Less objects = a good thing. On 1/8/07, Mike Kear [EMAIL PROTECTED] wrote: I'm building an app where usage is going to be FAR higher than anything i've used OOP for before, so I am trying to be careful to build it with the potential bottlenecks in mind. In this job i might have several hundred concurrent users accessing the application.(in the past i've used it for things like a CMS where only one person is going to be using it for an hour or so every few days at most, so bottlenecks and performance issues are still important but not as high a priority). I have a CFCFactory, that generates all the DAOs and Beans as i need but since every record has a trace of who created it and when, and who was the last to access it and when, the CFCFactory needs to pass to the CFC the credentials of the user. My question is about the best way to pass the credentials in A couple of scenarios: [A] Should I give each logged in user their own instance of the CFCFactory in the session scope, telling the CFCFactory their login credentials when it's instantiated. Then the CFCFactory passes the credentials on to each CFC as they're instantiated OR [B] Have only one instance of the CFCFactory in the application scope, passing in the credentials to the createbean(session.userbean) or createDAO( session.userbean) method as it's called OR [C] I've missed the point entirely and there's a whole n'other way to look at it and get the user's credentials down to the final insert/update query. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:265960 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Getting counts and the sum
In SQL, is there an easy way to get the counts of something and then also the total of all those counts? For example, I'm getting the count of times each user has logged in, but I also need the total number for all users. In 2 queries, it would be like so. --For each user... Select userID, Count(userID) AS userCount FROM userLogins GROUP BY userID --For total Select Count(userID) AS totalCount FROM userLogins One solution I just tried is a bit of a hack, but it works. I did the first query as above. Then, cfset LoginCounts = ValueList(myQ.userCount, '+') / cfset TotalLogins = evaluate(LoginCounts) / Yes, it uses the dreaded evaluate, but this just may be a case where it comes in handy. What do y'all think? -- Matt Williams It's the question that drives us. ~| 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:265877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Output not what I expect
You have maxrows=1 on your cfoutput. That means it will only see one of the three NC_IDs. I think. On 1/5/07, Bruce Sorge [EMAIL PROTECTED] wrote: I have this piece of code: cfloop from=1 to=#ArrayLen(NCArray)# index=i cfoutput group=NC_ID maxrows=1 td input type=checkbox name=NC_ID value=#NCArray[i][2]# cfif getPCtoNCRet.NC_ID IS NCArray[i][2] Checked/cfif nbsp;#NCArray[i][1]# /td /cfoutput cfif i MOD 4 EQ 0 /tr tr /tr /cfif /cfloop What is happening is that the only checkbox that is checked is the last one in the query result. If I have three NC_ID in the getPCtoNCRet variable, then I want all three checkboxes checked. Why is this not happening? Thanks, -- Bruce Sorge ~| 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:265882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting counts and the sum
On 1/5/07, Greg Morphis [EMAIL PROTECTED] wrote: what DB are you working with, some, like Oracle have a sum(foo) over (partition by goo).. that you could use in this example MSSQL 2005. On 1/5/07, Matt Williams [EMAIL PROTECTED] wrote: In SQL, is there an easy way to get the counts of something and then also the total of all those counts? For example, I'm getting the count of times each user has logged in, but I also need the total number for all users. In 2 queries, it would be like so. --For each user... Select userID, Count(userID) AS userCount FROM userLogins GROUP BY userID --For total Select Count(userID) AS totalCount FROM userLogins One solution I just tried is a bit of a hack, but it works. I did the first query as above. Then, cfset LoginCounts = ValueList(myQ.userCount, '+') / cfset TotalLogins = evaluate(LoginCounts) / Yes, it uses the dreaded evaluate, but this just may be a case where it comes in handy. What do y'all think? -- Matt Williams It's the question that drives us. ~| 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:265883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Where are the Los Angeles Developers?
I was recently hired by a So. Cal. company, but I live in Colorado and am soon moving to Kentucky. The company looked locally, worked with remote contractors for 6 months, and then hired 2 of them as full-time remote team members. There does seem to be a trend to having part of your team remote. Doing it full time will be a new venture for the company and for me. I agree with this. Also, many more developers are able to work remotely and live in 'less expensive' areas but still work for companies where the cost of living is higher. I have a contract with a Fortune 500 company based in Arkansas, my manager is in Pennsylvania, and I live and work from my home office in Texas. It's a regular 40 hour a week contract position, they just don't require to be on site. If they required me to be on site in Pennsylvania, there's no way I would take the contract. I own a 4,000 square foot house in the Dallas Fort Worth area for $200k but in Pennsylvania, that would cost a minimum of $600k (if I'm lucky). -- Matt Williams It's the question that drives us. ~| 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-Jobs-Talk/message.cfm/messageid:3206 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: Bond sucks and cfreturn sucks
I see Will's point. Not that I want it to change, but cfreturn value=#myFoo# / would be more consistent with other cf tags, such as cfswitch expression=#myVar# (instead of just cfswitch myVar) Matt On 12/9/06, Dave Watts [EMAIL PROTECTED] wrote: Ok, why does cfreturn go against the grain of all the cf tags?? cfreturn getproductreviews why is there no attribute quotes in it? I always thought it looked a bit odd and stuck out from other cf tag code. -- Matt Williams It's the question that drives us. ~| 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:263439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about Object Relationship Mapping
On 12/7/06, Aaron Roberson [EMAIL PROTECTED] wrote: Is it better to create a has-a relationship between one-to-many objects than to just invoke the objects separately? For instance, I have a product object (bean, DAO, gateway and service) and a product items object (bean, DAO, gateway, service). Each product has many product items. Is it better to map the product items to the product object (array, struct or query) through the product's service layer or to just invoke each object and pass them the product id? Aaron, Here is one way I handled this type of issue using the Person with many Addresses idea. http://mattw.mxdj.com/sample_servicedaobean_files.htm -- Matt Williams It's the question that drives us. ~| 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:263221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Marketing CF
I would agree Brad. Perhaps Adobe's site (at least the CF part) needs to have some separation for What type of potential customer are you? Then a guy like your friend may get channeled into some pages that explain for as littles $x.xx / month you can have a fully dynamic, database driven site for your store. I guess for now though, it is up to us developers to be the marketing people in the field, if for no other reason than job security. :) Matt On 11/30/06, Brad Wood [EMAIL PROTECTED] wrote: Sorry this is a bit off topic, but it's been bothering me... pseudo-rant So I was talking to a friend from my church last weekend. He owns an automotive spring shop and is trying to get a website up (products, shopping cart etc..), but all he knows is HTML. His first problem in my opinion is that he is paying someone to hand-build hundreds of STATIC HTML pages which contain all of his available products. I just couldn't seem to convince him that he REALLY needed a database. But that's not what bothered me though. Before I even mentioned he should use CF, I told him that's what I code in, and he recognized it from searching the WEB (he's done a little homework). His first response was, Oh, I looked at ColdFusion, but it was *way* too expensive. Well, all this guy really wants/needs is a small hosted site in a shared environment for not more than 15 bucks a month. No problem. So, how is it that people search the web and completely miss that fact? He actually thought he was going to have to pay thousands of dollars for ColdFusion server! I know we've had discussions about the cost vs price of CF, but that's not really what this is about. It just bugs me that when an uneducated (but smart) person looks on the web for the first time the impression they can get is Don't use CF, it will cost you thousands of dollars. When people sign up for cheap shared hosting accounts, they don't assume they will need to purchase their operations system, database licenses, or any of that shmoo. I guess it just bugs me that it is easy for people to completely turn away from CF without ever looking at it just because no-one was there to explain it. I want to see CF succeed in the market, obviously. What can we do (not that we aren't already) to help spread correct info. /pseudo-rant ~Brad ~| 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:262223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Jingle Bells
Sorry to continue the off-topic-ness The biggest difference in Colorado snow and other parts of the country is in Colorado it can snow during any season. Most snow falls in winter, but spring and fall get plenty also. Summer is less likely, but not uncommon. Here's my blog entry from Sept. 22 (which was not the first of the season). http://mattw.mxdj.com/fall__snow_fall.htm On 11/29/06, Gabrielle Mack [EMAIL PROTECTED] wrote: Ha! You think thats bad?? Try living in the snow belt of the great lakes (ie...upstate nyseasonal depression capital haha) ~| 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:262084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Jingle Bells
Dave, I'm in skier/snowboarder heaven: Summit County (aka Colorado's Playground). 5 ski areas are all within less than 20-30 minutes drive. Many more with in 1-2 hours. Approx. 360 of snow per year and 9000 feet above sea level. Mountain peaks all around, some up to 14,000 feet. Beautiful scenery, but expensive (probably not as much as So. Cal. though) because it is a resort area. Not many CF jobs, but if you can work remotely... Matt On 11/29/06, Dave Hatz [EMAIL PROTECTED] wrote: Matt, What part of CO are in you in? I am So. Cal and dying to get to some snow. It is so damn dry out here, I don't remember what the rain looks like, let alone what snow is :) Dave -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 11:35 AM To: CF-Talk Subject: Re: Jingle Bells Sorry to continue the off-topic-ness The biggest difference in Colorado snow and other parts of the country is in Colorado it can snow during any season. Most snow falls in winter, but spring and fall get plenty also. Summer is less likely, but not uncommon. Here's my blog entry from Sept. 22 (which was not the first of the season). http://mattw.mxdj.com/fall__snow_fall.htm On 11/29/06, Gabrielle Mack [EMAIL PROTECTED] wrote: Ha! You think thats bad?? Try living in the snow belt of the great lakes (ie...upstate nyseasonal depression capital haha) ~| 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:262164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SSL Providers
Anyone have any recommendations for SSL certificates? I've used Verisign and Network Solutions. Net Sol is cheaper. Are there any others out there that are safe and cheaper? Thanks, -- Matt Williams It's the question that drives us. ~| 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:261706 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 I get number of birthdays?
IF the form field doesn't exist, an error is being thrown. You may not actually see the error depending on if a cftry is wrapped around the query. Or sometimes I've just had errors that don't get thrown correctly. On 11/25/06, Rick Faircloth [EMAIL PROTECTED] wrote: Jim... (or anyone else)... Do you see anything wrong with this code (part of a larger query) that would cause the query not to return no results if the following formfields, Form.Earliest_Birthdate_Day and Form.Earliest_Birthdate_Month and Form.Latest_Birthdate_Day and Form.Latest_Birthdate_Month are *not* used in the form (in other words, they CFIF at the beginning of this part of the query should exclude this section from consideration in the query). Here's the code: CFIF Form.Earliest_Birthdate_Day is not Day and Form.Earliest_Birthdate_Month is not Month and Form.Latest_Birthdate_Day is not Day and Form.Latest_Birthdate_Month is not Month and ((Month(Client_Birthdate) = #Form.Earliest_Birthdate_Month# and Day(Client_Birthdate) = #Form.Earliest_Birthdate_Day#) orMonth(Client_Birthdate) #Form.Earliest_Birthdate_Month#) CFIF Form.Earliest_Birthdate_Month GT Form.Latest_Birthdate_Month !---This takes care of cases where the months go over a new year--- or CFELSE and /CFIF ((Month(Client_Birthdate) = #Form.Latest_Birthdate_Month# andDay(Client_Birthdate) = #Form.Latest_Birthdate_Day#) orMonth(Client_Birthdate) #Form.Latest_Birthdate_Month#) /CFIF Thanks, Rick PS - This was working fine yesterday, then today it just started returning no results if the formfields Earliest_Birthdate_Day, Earliest_Birthdate_Month, Latest_Birthdate_Day, and Latest_Birthdate_Month are not used. ??? -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, November 24, 2006 4:22 PM To: CF-Talk Subject: Re: How do I get number of birthdays? I think this will work...check the logic, though. WHERE ((Month(Client_Birth_Date) = #Form.Earliest_Birth_Month# AND Day(Client_Birth_Date) = #Form.Earliest_Birth_Day#) OR Month(Client_Birth_Date) #Form.Earliest_Birth_Month#) cfif Form.Earliest_Birth_Month GT Form.Latest_Birth_Month !---This takes care of cases where the months go over a new year--- OR cfelse AND /cfif ((Month(Client_Birth_Date) = #Form.Latest_Birth_Month# AND Day(Client_Birth_Date) = #Form.Latest_Birth_Day#) OR Month(Client_Birth_Date) #Form.Latest_Birth_Month#) ~| 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:261663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Code Question
Well put Mark. I'm with you on learning new tools too. If I wasn't, I'd still be using an Apple II+ to make new Lode Runner levels (hopefully didn't date myself too badly there). Personally I like the Project structure. In fact, I have my .cfm and ..cfc files set to open into Notepad if I'm just double clicking it from Windows Explorer. This is so it will open quick and I can find what I'm looking for easily. But that is definitely rare and I usually am in Eclipse / CFEclipse to begin with. Searching an entire project is flexible and fast. And Rick, I'm definitely a keyboard shortcut guy also. The CFEclipse toolbar is turned off. I've actually adapted some of Dreamweaver's shortcuts to be the CFEclipse default. Learning new shortcuts is definitely frustrating at first, but if you're committed to switching tools, it come pretty quick. My $.02 On 11/14/06, Mark Drew [EMAIL PROTECTED] wrote: I guess with any *new* thing there is a learning curve, and people showing you how to use it always helps. -- Matt Williams It's the question that drives us. ~| 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:260423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Capture Alternatives
Here's how Ben Nadel is doing it: http://www.bennadel.com/index.cfm?dax=blog:397.view On 11/13/06, Bobby Hartsfield [EMAIL PROTECTED] wrote: There was yet another Slashdot article about it yesterday and someone mentioned this. I haven't tried it but if you are having an issue that could quickly put it to the test, I'd give it a shot. just put an empty, hidden field in your form. When you process the form, make sure it is still empty. The poster suggested that bots fill in all fields that they can find. That makes a LITTLE sense but I think I'd hide the field with CSS and not give it an actual type of 'hidden'. -Original Message- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: Monday, November 13, 2006 7:26 AM To: CF-Talk Subject: Capture Alternatives Hi all, Has anyone come up with any alternatives to using form captures for preventing spam bots? Ideally I'd like a solution that is relatively seamless to the users requiring little/no extra involvement. R ~| 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:260168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Extensions
cfc files are ColdFusion Components and are pure CF. They can be called, but not like a regular .cfm file. You have to invoke (or instantiate) a cfc first (several ways to do this). Then you can call the various functions that would be defined by the programmer inside the CF Component. Matt On 11/11/06, Jason T. Slack [EMAIL PROTECTED] wrote: Hello All, First let me say that I am thankful for the help you all have provided so far. It is helping me hit the ground running and getting up to speed as quickly as possible. Thanks! I have another question: Extensions. The normal extension is .cfm, but then there are .cfc files. Are there other extensions than these and what are they used for? Can I call a .cfc file from an form on Post? What I am trying to due is distinguish what parts of my site are pure CF code and what other parts are tied to pages that will be displayed to the user. Like right now I have my Login method in a .cfm file and i works, but I dont want someone coming behind me to get this confused for a page that is displayed to the user when it never gets displayed to the user. It just decides if they are allowed to be here or not. Can I get your thoughts please? -Jason ~| 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:260040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hosting recommendations
Bryan, if you do go with VivioTech, pretend Peter Farrell (CF Weekly podcast co-host) gave you a referral. His referral ID is MaePub (I just put it in the comments when I did my order), or you can use his banner link from http://blog.maestropublishing.com Matt On 11/3/06, Bryan Stevenson [EMAIL PROTECTED] wrote: Thanks for the info MattI think we'll be heading that way shortly. It seems like a super easy way to host our smaller clients (all the benefits of co-lo/dedicated with way less hassle/expense). 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 ~| 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:259138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JS Rollover Not Opening New Browser Window
What do the js functions - onPictureRollover36A3260Over() - have in them? Maybe I don't fully understand what you want, but javascript isn't going to look at target=_blank. To get javascript to open a new window, you want something like window.open('filename.cfm',some,parameters,such,as,width,height,etc) Matt On 11/3/06, Rick Faircloth [EMAIL PROTECTED] wrote: I've got this code.why won't it open a new browser window? a href=http://www.fl.living.net/idxfirm/3087550; Target=_blank onMouseOver=onPictureRollover36A3260Over(this) onMouseOut=onPictureRollover36A3260Out(this)IMG ID=PictureRollover36 HEIGHT=21 WIDTH=170 SRC=./Florida_Properties_01.jpg BORDER=0 ALT= name=PictureRollover36A3260/a The Target=_blank works fine in a regular link, but not in this rollover code. Why? Thanks, 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:259140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JS Rollover Not Opening New Browser Window
Rick, I don't mean to offend in any way, but you did say your javascript was generated. Honestly I don't see how your javascript does anything. Here's a simple example of how you can do a link with an image. When you mouse over the image, it changes to the 02 version of the image. When you mouse off, it goes back to 01. When you mouse over the image and click on it, it will first change as described above based on the onMouseOver javascript event. The a href tag handles opening the link in a new window (based on target=_blank). The main difference in what I have here is that the onMouseOver and onMouseOut event calls are in the img tag, not the a href tag. Also the this.id part is case sensitive, so this.ID won't work. script type=text/javascript!-- function switchImage(imgID, imgSrc) { document.getElementById(imgID).src = imgSrc; } //--/script a href=http://www.fl.living.net/idxfirm/3087550; Target=_blank img id=PictureRollover36 height=21 width=170 src=./Florida_Properties_01.jpg border=0 alt= onMouseOver=switchImage(this.id,'./Florida_Properties_02.jpg') onMouseOut=switchImage(this.id,'./Florida_Properties_01.jpg') / /a Hope this helps. Matt 11/3/06, Rick Faircloth [EMAIL PROTECTED] wrote: Rick Faircloth wrote: Thanks for the reply, Matt... I've pasted in the entire script and the previous line of code I sent that references it. How can I modify this code to include the window.open function in the HTML? function onClick or something? (As you can tell, I am *not* a JS coder...this was generated for me) Rick script type=text/javascript!-- function onPictureRollover36A3380Over() {} function onPictureRollover36A3380Out() {} //--/script script type=text/javascript!-- graphic1PictureRollover36A3380 = new Image() graphic1PictureRollover36A3380.src = './Florida_Properties_01.jpg'; graphic2PictureRollover36A3380 = new Image() graphic2PictureRollover36A3380.src = './Florida_Properties_02.jpg'; function onPictureRollover36A3380Over() { document.PictureRollover36A3380.src=graphic2PictureRollover36A3380.src; } function onPictureRollover36A3380Out() { document.PictureRollover36A3380.src=graphic1PictureRollover36A3380.src; } //--/script a href=http://www.fl.living.net/idxfirm/3087550; Target=_blank onMouseOver=onPictureRollover36A3260Over(this) onMouseOut=onPictureRollover36A3260Out(this)IMG ID=PictureRollover36 HEIGHT=21 WIDTH=170 SRC=./Florida_Properties_01.jpg BORDER=0 ALT= name=PictureRollover36A3260/a ~| 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:259154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hosting recommendations
I just set up a VPS with viviotech. So far so good. Small learning curve for me. I did the most basic VPS, but added CF 7. Paid for 2 years, which translates to ~$45/mo. Eventually I'll have at least 3 clients paying $20/mo (they are non-profit, so I'm giving a bargain), so it pays for itself. Matt On 11/2/06, Yves Arsenault [EMAIL PROTECTED] wrote: I've been using Vivio as well. I'm quite happy with them. BD used to come with the VPS packages, but I think there's an add-on price now. Would have to check with them though. ;-) Peace. Yves On 11/2/06, Munson, Jacob [EMAIL PROTECTED] wrote: I'd recommend Vivio. You can get a full VPS account where you can do whatever you want (you're root on the server). Only $20/mo, but I'm not sure if that comes with BlueDragon or not (I know it doesn't come with ColdFusion). It used to come with BlueDragon, but I think they stopped that promotion. http://www.viviotech.net/hosting.cfm I haven't tried their shared accounts though. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, November 02, 2006 11:41 AM To: CF-Talk Subject: hosting recommendations I need hosting recommendations for a relatively small site. Here are my requirements 1 - shared hosting 2 - affordable 3 - linux 4 - mysql 5 - cffile, createObject() available 6 - EASY TO USE END USER CONTROL PANEL for account management 7 - reliable 8 - tech support available via phone or live chat. HostMySite meets most of those - though I don't particularly like their control panel and they seem to have occassional reliability issues. I love their support though. (btw, anyone notice how ridiculously expensive edge web hosting is? wowzers) EMF idahopower.com made the following annotations. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == ~| 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:258899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: hosting recommendations
On 11/2/06, Bryan Stevenson [EMAIL PROTECTED] wrote: When you say you added CF 7 did you mean you purchased a copy and installed it? or does the host add it to your account and you pay extra for it? Bryan, you can do either way. In the long run, purchasing would be cheaper, but I didn't have the grand or so for the Standard version and therefore opted to pay monthly for it. Plus I figured if I but CF 7 now, I'll be wanting to upgrade to 8 next year. It think the deal was $20/mo for the base VPS account, plus $25/mo for CF 7. The VPS option is fairly new to me also. I signed up for it a little over a week ago. But you have full access to the CF Administrator, no functions (e.g., createObject) are blocked, you have full email control and tons of other stuff. I'm still learning since it is based on Linux (CentOS distro), but so far I have four websites up (some still say Under Construction) and have no complaints. Matt ~| 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:258934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JRun Connector Protocol Error
This is the error I got when trying to upgrade my production Win 2000/IIS server from CF 6 to CF 7: JRun Connector Protocol Error I did some googling and tried the applicable suggestions to no avail. Here's what I tried: *Make sure all Extension Mappings point to the correct jrun.dll file *Check the Cache ISAPI Applications setting. *Restart Services *Reboot computer *Change permissions on wsconfig directory (set everyone to full control) The install log does show 1 NonFatal error, not sure if it is related: ANT Script Error: Status: ERROR Additional Notes: ERROR - configure-dlls.xmlFailed to copy D:\CFusionMX7\lib\cfperfmon_mx.dll to C:\WINNT\system32\cfperfmon_mx.dll due to C:\WINNT\system32\cfperfmon_mx.dll (The process cannot access the file because it is being used by another process) The jrun log has this message: 2006-10-24 06:41:56 jrISAPI[filter:1884] Couldn't initialize from remote server, JRun server(s) probably down. 2006-10-24 06:41:56 jrISAPI[filter:1884] could not initialize proxy for 127.0.0.1:51011 This is a dedicated server at CFX Hosting. After a couple of install attempts, I reverted back to CF 6. Any ideas on what else to try? Thanks, -- Matt Williams It's the question that drives us. ~| 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:257869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: install CFMX7 on 64bit windows
Try a search on 64 on forta.com/blog. Some posts there, but don't know if they are helpful. On 10/24/06, kurt schroeder [EMAIL PROTECTED] wrote: ok, it can be done, so some people claim, anyone have the outline for the steps necessary to get this to work? i'm using 64 bit intel, wondows 203 64bit, sqlserver 64bit, and of course the related version of iis. I appreciate the help! KES ~| 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:257881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache, IE cgi.http_referer
On 10/16/06, Snake [EMAIL PROTECTED] wrote: Any variable that is considered personal information and can be used for tracking purposes may not be sent. Russ But can anybody explain why the variable shows in Firefox, but not IE? This makes me think there's an IE setting - maybe the security or privacy level. I'll play around with those. -- Matt Williams It's the question that drives us. ~| 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:256910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache, IE cgi.http_referer
On 10/16/06, Doug Bezona [EMAIL PROTECTED] wrote: Honestly though, the conclusion you probably should be coming to here is not to depend on the referrer info being present for anything meaningful, since there are a lot of things a potential user could have installed, or ways a browser might be set, that can interfere with it. Okay, sorry for ignoring the comments that I shouldn't be relying on the referer. This is a system where there is some control over the user's browser. It is online software where certain requirements can be met. However, I tried adjusting both the security and privacy settings but no help. Also, there isn't any firewall or other software blockage. This is just my local machine. So the question at hand should be how can you make a link that will go back one page (that page being unknown) and refresh it? I'm thinking I may have to make the calling page(s) submit a form with a hidden variable that I can use. -- Matt Williams It's the question that drives us. ~| 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:256915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache, IE cgi.http_referer
By unknown I simply meant that it could be one of several possible pages within the site. So yes, all potential pages are internal and we do have control over those. A littel more detail... The initial page has a drop down select box. In the on change of that select I redirect to another page with a form. If the user is to click cancel on that form, I want to take them back one page, but the select box should have it's original value (originally came from db) selected and not the value the user selected which caused the redirect. Make sense? So it is a select box which could be wrapped in form tags and then a hidden field passed. I was just looking for something better. Thanks. Matt On 10/16/06, Doug Bezona [EMAIL PROTECTED] wrote: So the question at hand should be how can you make a link that will go back one page (that page being unknown) and refresh it By unknown, do you mean literally any arbitrary page on the internet, or an arbitrary page from within your site/application? If it's the former, there probably isn't a truly reliable solution - experiment with the JavaScript history() function and you might get closer - although I don't know how you would force a refresh on a page you can't control. If its pages within your own site, or a site you have control over, you may have better options, bit without a more detailed explanation of what you are trying to do and why, it's hard to say exactly what the best approach might be. ~| 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:256950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Apache, IE cgi.http_referer
On my laptop, I can't get IE to give me output for cgi.http_referer. A dump of CGI shows it as a variable, but with empty string. Anyone else run into this? Sample code: a href=#CGI.HTTP_REFERER#Cancel/a Real issue here is to go back one page, but to force that page to reload. So a simple history.go(-1) doesn't do the reload. Other ideas? -- Matt Williams It's the question that drives us. ~| 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:256836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache, IE cgi.http_referer
On 10/15/06, Claude Schneegans [EMAIL PROTECTED] wrote: cgi.http_referer The http_referer vartiable is set and transmitted by the browser,... if it wants to. If the browser does not set it, the CF server will not get it. How rude of the browser! Is this a setting the user can control? -- Matt Williams It's the question that drives us. ~| 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:256839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apache, IE cgi.http_referer
On 10/15/06, Doug Bezona [EMAIL PROTECTED] wrote: Are you by any chance running a security suite such as Zone Alarm, Norton Internet Security or the like? Nope. Pretty straightforward here. Matt Q. said: The http_referer will only exist if the page load is a result of a link click or a form submission. If you just type the URL into the addy bar, then it will be an empty string. Could be part of the issue. The template that won't work is called by a javascript redirect. However, this does work in Firefox. -- Matt Williams It's the question that drives us. ~| 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:256849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Just joined; looking for advice
Thanks Dave, Judith and Jeff. Good stuff. Jeff, my motivation for quitting is not simply I don't like my job. My original post gave 2 reasons: -freelance work pays much more - almost twice -leaving some aspects of my FT job such as network maintenance help desk I should have given the third reason I am considering going freelance: the work is already in my lap (literally: I use a laptop at home). About 2 years ago I started helping one guy who has 20-30 clients. He is not a developer; he only handles client sales/relations. The deal here is he emails me the change / needs and I just do it. No client interaction for me. Most of these are smaller jobs, but occasionally (most recently this week) there are bigger jobs (100+ hours). In addition to that, I am working with one other company who is migrating a system from spaghetti/procedural code to OO/Frameworks. This contract is up in December, but they have mentioned they have more coming up in 1st qtr '07 (and possibly beyond) and would like me to be part of that. There are already other potential clients too. As Judith mentioned, it is usually feast or famine; I'm feeling the feast right now and think at least for starters, I would have very little marketing to do. Hopefully some of these will turn into, as Jeff said, steady clients. Along with this third reason of the work is already there, for the past few months I've been killing myself and neglecting my family by trying to keep the full time job and do contract work. I'm a morning person, so I typically get up at 5am, work for a couple of hours, get ready and go to work. Since June I cut my FT job down to 4 days a week so I could have one day a week for side work. But lately I've had to do some evening work and quite a bit on the weekends too, just to keep up. When I think to myself that something has got to change, I wonder why I would give up the higher paying side work for the lesser paying FT job. Sorry for the long post, just wanted you all to better understand where I'm coming from. I would be interested if anyone has any suggestions on time tracking/billing software. I currently just use Excel Word for this, but in a very rudimentary way with very little reporting capabilities. Again, thanks for the advice thus far. -- Matt Williams It's the question that drives us. ~| 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-Jobs-Talk/message.cfm/messageid:3152 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Just joined; looking for advice
So what kind of advice would folks give to a someone considering quitting my regular job and becoming a full-time freelancer. My regular job is a mix of coding, network maintanence, and other IT-type stuff. Over the past year or so I've picked up a couple of freelance/contractor positions. The primary reason I am considering this is that the freelance work pays much more - almost twice. I've calculated all the costs of things like health insurance, taxes, etc. and believe I could come out ahead. A secondary reason would be I could concentrate on coding/builing applications and drop the less enjoyable parts of the job which are coding. Ideally I would be able to have my current employer as a client and be able to continue the coding part of this job. But that may be wishful thinking, especially when I tell them my hourly rate. Any advice and suggestions are appreciated. Thanks. -- Matt Williams It's the question that drives us. ~| 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-Jobs-Talk/message.cfm/messageid:3147 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: Date Add
cfset myDate = DateAdd('d',14,Now()) / Then in your query: #CreateODBCDateTime(myDate)# Can also be combined to one statement: #CreateODBCDateTime(DateAdd('d',14,Now()))# On 10/4/06, Mark Leder [EMAIL PROTECTED] wrote: How do I take a current date/time #now()# and add a number of days to it, such as 14 days into the future, then convert to #CreateODBCDateTime()# so I can stick in a db? Can't find anything on cflib, and I'm confused by the syntax of dateAdd()... Thanks, Mark ~| 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:255594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: open new window
Or good old a href=myNewWindow.cfm target=_blank... On 10/3/06, Teddy Payne [EMAIL PROTECTED] wrote: Just use a hovering div so the popup blocker cannot prevent the content from showing. Teddy On 10/3/06, Charlie Griefer [EMAIL PROTECTED] wrote: popup blocker's there for a reason. if you could easily circumvent it and spawn windows that the user doesn't want spawned (hence their use of a popup blocker), that's almost as intrusive as say, trying to disable their back button :) On 10/3/06, Richard White [EMAIL PROTECTED] wrote: Hi, i am wondering if it is possible to open a new window without a the browsers pop-up blocker stopping it from opening the code i am using is as follows: window.open('newWindow.cfm'); but the pop-up blocker stops it from opening i would appreciate any help thanks ~| 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:255198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Wierd SQL Server issue
Anyone dealt with this? Some SQL Databases are not accessible from CF. The DSN verifies correctly, but I can't hit any of the tables. In addition, the Dreamweaver RDS doesn't list the tables, but does list some weird tables such as dbo.spt_monitor and dbo.spt_values. This is SQL Server 2000. -- Matt Williams It's the question that drives us. ~| 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:253748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4