Re: Replying after the message
I think that in is most cases, I am reading on my Blackberry and for long posts, you get a scroll for more, and more just to read a reply... I think it is a preference, got a to love a top v bottom preference! This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Mark Henderson To: CF-Talk Sent: Wed Sep 06 05:06:13 2006 Subject: RE: Replying after the message Robertson-Ravo, Neil (RX) wrote: I know Thunderbird etc does this out of the box, and it probably does make sense the way we read etc, but does anyone else find a reply after a message damn annoying?! Then Dave Watts responded No, it's just you. I totally agree with Dave but that is just my opinion of course. In fact, if you happen to be on either the WDD design or css-discuss lists (and those struggling to learn css really should join) you'll get politely scolded for top posting (and sometimes NOT so politely!). Trimming of course certainly does help, and often leaving the entire contents of the previous email intact, whether you bottom or top post, makes readability difficult. Truly though, there really is no right or wrong answer on this one, it's more a matter of preference. Microsoft's default has definitely made top posting the *norm* however. Here is an argument *for* top posting, though as already stated I'm certainly not an advocate: http://www.hawkwings.net/2005/10/03/shooting-yourself-in-the-foot-or-hea d-one-round-in-the-bottom-vs-top-posting-war/ Mark -- This message has been scanned for viruses and dangerous content by ISPNZ's automated virus detection system, and is believed to be clean. ~| 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:252173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replying after the message
What lists are these? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Mark Henderson To: CF-Talk Sent: Wed Sep 06 05:06:13 2006 Subject: RE: Replying after the message Robertson-Ravo, Neil (RX) wrote: I know Thunderbird etc does this out of the box, and it probably does make sense the way we read etc, but does anyone else find a reply after a message damn annoying?! Then Dave Watts responded No, it's just you. I totally agree with Dave but that is just my opinion of course. In fact, if you happen to be on either the WDD design or css-discuss lists (and those struggling to learn css really should join) you'll get politely scolded for top posting (and sometimes NOT so politely!). Trimming of course certainly does help, and often leaving the entire contents of the previous email intact, whether you bottom or top post, makes readability difficult. Truly though, there really is no right or wrong answer on this one, it's more a matter of preference. Microsoft's default has definitely made top posting the *norm* however. Here is an argument *for* top posting, though as already stated I'm certainly not an advocate: http://www.hawkwings.net/2005/10/03/shooting-yourself-in-the-foot-or-hea d-one-round-in-the-bottom-vs-top-posting-war/ Mark -- This message has been scanned for viruses and dangerous content by ISPNZ's automated virus detection system, and is believed to be clean. ~| 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:252175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Search-function on website
If you used Verity in CF 5, did you use the K2 engine or the VDK engine? The K2 engine is much better in many respects, and if I recall correctly, CFMX 6.x uses K2 instead of VDK. I don't realy recall any specific choice that I made. K2 sounds the most familiar, but that may be because it's used in later versions of CF. If you want to search PDFs using SQL Server's full-text functionality, you can do that with a little work: http://www.adobe.com/support/downloads/detail.jsp?ftpID=2611 Interesting link, I'll look into that. However, I don't know how well that works with large numbers of PDF documents, since I haven't done it myself. If not for the PDF part, I'd unhesitatingly recommend SQL Server full-text indexing over Verity. Well the thing that bugs me the most of the SQL Server full-text search is the fact that it doesn't search on parts of words. I can't really think of a good example in English, but Dutch works just as well (only you don't understand the words): Take these three words that appear in texts of different pages: zetel, zetels, restzetel(s). Now if you search for 'zetel' you are presented with the pages with 'zetel' and 'zetels' if you use a prefix (*) notation in your CONTAINS. However restzetel or restzetels does not come up at all. LIKE '%zetel%' would of course yield all of these results, which is a desired result, but of course I would like a ranking kinda like this: zetel zetels restzetel restzetels. Well.. that being said, I guess I'll have to look into verity again. See if the results are somewhat better this time. Thanks for your response. ~| 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:252174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replying after the message
An RFC for posting, lol. Looks like I will have to scroll for more, and more, and more:-) This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Dave Watts To: CF-Talk Sent: Wed Sep 06 00:31:29 2006 Subject: RE: Replying after the message I know Thunderbird etc does this out of the box, and it probably does make sense the way we read etc, but does anyone else find a reply after a message damn annoying?! No, it's just you. Here are some relevant links. The RFC in question (yes, there is one!): http://tools.ietf.org/html/rfc1855 - go to page 7 Posting styles: http://en.wikipedia.org/wiki/Top-posting What Top-Posting Is (my favorite description): http://blinkynet.net/comp/toppost.html 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! ~| 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:252176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Search-function on website
You may have to code/develop something using the Verity SDK but I am not sure what is available with the OEM version which ships with ColdFusion. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Auke van Leeuwen To: CF-Talk Sent: Wed Sep 06 07:30:39 2006 Subject: Re: Search-function on website If you used Verity in CF 5, did you use the K2 engine or the VDK engine? The K2 engine is much better in many respects, and if I recall correctly, CFMX 6.x uses K2 instead of VDK. I don't realy recall any specific choice that I made. K2 sounds the most familiar, but that may be because it's used in later versions of CF. If you want to search PDFs using SQL Server's full-text functionality, you can do that with a little work: http://www.adobe.com/support/downloads/detail.jsp?ftpID=2611 Interesting link, I'll look into that. However, I don't know how well that works with large numbers of PDF documents, since I haven't done it myself. If not for the PDF part, I'd unhesitatingly recommend SQL Server full-text indexing over Verity. Well the thing that bugs me the most of the SQL Server full-text search is the fact that it doesn't search on parts of words. I can't really think of a good example in English, but Dutch works just as well (only you don't understand the words): Take these three words that appear in texts of different pages: zetel, zetels, restzetel(s). Now if you search for 'zetel' you are presented with the pages with 'zetel' and 'zetels' if you use a prefix (*) notation in your CONTAINS. However restzetel or restzetels does not come up at all. LIKE '%zetel%' would of course yield all of these results, which is a desired result, but of course I would like a ranking kinda like this: zetel zetels restzetel restzetels. Well.. that being said, I guess I'll have to look into verity again. See if the results are somewhat better this time. Thanks for your response. ~| 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:252177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: passing arguments into a instantiated java object
thanks for that Dan, now watch me attempt to absorb your Java knowledge. ~| 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:252178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cross-Server Joins
I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? -- Jay ~| 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:252179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fusion Reactor issues
Can you: -adjust your jvm memory settings so you have more available memory for CF? -adjust your FR settings so it doesn't kill threads, or at least allow more threads until it starts killing them off? Unfortunately FR is within the CF container, so if CF is unresponsive, FR will be too. :( -- Maureen Barger CIT Information Systems 120 Maple Ave. Cornell University [EMAIL PROTECTED] On Tue, September 5, 2006 22:19, Rick Root wrote: Sometimes, someone will do something on my server, because of poorly written code by yours truly, that will suck up huge amounts of memory and fusion reactor will start killing requests. However, sometimes, during this time, I can't even get into Fusion Reactor - or if I can, it's only because it's lost it's connection to my (one) instance and that doesn't do me much good. I couldn't figure out how to reconnect fusion reactor to my coldfusion instance... seems like restarting coldfusion is a bit overkill since eventually it returned to normal function. Also, it seems to me that not being able to access Fusion Reactor when Codlfusion is experiencing an overload situation.. well, that makes Fusion Reactor a lot less valuable, because I can't go in and see what requests are being processed, and kill them if necessary. ~| 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:252180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I am soooo pissed
Whats the betting that domain will be available again, in say, 3 days? On 9/5/06, Jim McAtee [EMAIL PROTECTED] wrote: ..com's are s 1999 - Original Message - From: Doug Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 2:58 PM Subject: Re: I am s pissed You know what is weird...The site is already online!! I thought it took awhile, especially at networksolutions. Go Figure Doug - Original Message - From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 1:38 PM Subject: RE: I am s pissed Just wait. The person bidding might default. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 2:25 PM To: CF-Talk Subject: Re: I am s pissed No, it was just a regular type name I suppose. gobuddy.com the auction is now at 3,800.00 - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 1:22 PM Subject: RE: I am s pissed Was it something CF related, as I have tons of CF related domains -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 05 September 2006 20:13 To: CF-Talk Subject: OT: I am s pissed I hate all these auctions for domain names. I was after a domain that expired and was being auctioned at snapnames, I had a limit at what I would pay and it was 1,000.00 and the damn thing is already up to 2,600.00 Oh well, I guess the search continues for something good. ~| 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:252181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cross-Server Joins
I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? Before you reply, my mistake. By cross-server I should have said cross-platform. I am trying to link a MySQL database into MSSQL. I have found several references online but none of them work so I was wondering if any of you had experience. -- Jay ~| 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:252182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cross-Server Joins
Hi Jay You need to have a look at linked servers, this article has a heap of stuff in it. http://www.databasejournal.com/features/mssql/article.php/3085211 Im sure there is a simpler route by prefixing the table with the db.owner.table or something like that, Neil Ravo Robertson was the chap I saw doing it a while back I will give him a shout and ask what he was doing. HTH Jose Diaz On 9/6/06, James Smith [EMAIL PROTECTED] wrote: I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? -- Jay ~| 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:252183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cross-Server Joins
Ah okay, Linked servers I would say would be the way. Jose On 9/6/06, James Smith [EMAIL PROTECTED] wrote: I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? Before you reply, my mistake. By cross-server I should have said cross-platform. I am trying to link a MySQL database into MSSQL. I have found several references online but none of them work so I was wondering if any of you had experience. -- Jay ~| 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:252184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cross-Server Joins
However James Ive never actually done what your requesting myself, if it works I'd love to know heh ;) On 9/6/06, Jose Diaz [EMAIL PROTECTED] wrote: Ah okay, Linked servers I would say would be the way. Jose On 9/6/06, James Smith [EMAIL PROTECTED] wrote: I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? Before you reply, my mistake. By cross-server I should have said cross-platform. I am trying to link a MySQL database into MSSQL. I have found several references online but none of them work so I was wondering if any of you had experience. -- Jay ~| 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:252185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cross-Server Joins
Indeed, Linked Servers is what you want to look for - not sure about the performance though ;-) -Original Message- From: Jose Diaz [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 11:22 To: CF-Talk Subject: Re: Cross-Server Joins Ah okay, Linked servers I would say would be the way. Jose On 9/6/06, James Smith [EMAIL PROTECTED] wrote: I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? Before you reply, my mistake. By cross-server I should have said cross-platform. I am trying to link a MySQL database into MSSQL. I have found several references online but none of them work so I was wondering if any of you had experience. -- Jay ~| 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:252186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cross-Server Joins
There is a good walkthrough at http://developer.infi.nl/index.php?ID=6article=6 but after creating the linked server it fails when I try to access it. Neither server craches the enterprise manager just sits there doing nothing, no processors get 100% used, no memory gets hogged, it just sits there with an hourglass for as long as you are prepared to wait. Ah okay, Linked servers I would say would be the way. I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? Before you reply, my mistake. By cross-server I should have said cross-platform. I am trying to link a MySQL database into MSSQL. I have found several references online but none of them work so I was wondering if any of you had experience. ~| 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:252187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion serial number lost
Thank you for your help, unfortunately I had no time to register, it was a fresh copy (Murphy docet). But I can't believe there is no solution to this issue. Max -Original Message- From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Date: Tue, 05 Sep 2006 22:21:41 -0400 Subject: Re: Coldfusion serial number lost Massimo Gianadda wrote: Sorry for the OT, but I'm really frustrated, I have purchased Coldfusion from an Italian reseller, unfortunately CD with serials has been kept away by a courier who retired a server and are lost. If you REGISTERED the product with Adobe, hey *MIGHT* be able to help... if not though, you're probably SOL. 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:252188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFForm Integer Validation Allowing Commas
That was one hell of a rant. I started using Perl as my first web dynamic language back in college. That being said and for everyone who feels the pain of Perl, you will be in regex hell for your stay in Hotel Perl Mod. What I did get from Perl was the positive side of regex, I use regex to validate cfform controls. I agree with the usage of commas, but I have plenty of financial clients that will disagree with you on the integer. Commas are just a presentational way of showing large numbers more legibly. I do not advocate allowing the entering of number and I provide both client side and server side validation for any user entered information. Your complaint is valid, but there are plenty of ways to go around it. I do not expect the CF language to have a validation, function or tag that will magically solve every issue. What I do expect and CF has always provided is the ability to combine all of the features of CF to accomplish them. CF has so many ways to approach a solution that people can get lost in translation. I hope that you do not use a cfform validation as your reason to leave the realm of ColdFusion. ColdFusion is still the easiest way to achieve a lot in a short amount of time. Teddy On 9/5/06, Justin Holzer [EMAIL PROTECTED] wrote: How is 1,235 considered an integer? I know that ColdFusion is a lossely typed language, but what CF programmer is writing code like cfset myNumber = 1,234 / ? Not only is it wrong to validate numeric input with commas, it's counter-intuitive, illogical, and just plain insecure. If the programmer wishes the user to be able to enter commas, that's fine, but it should certainly not be the default behavior, especially when the validation did not work that way prior to MX 7. I don't understand why the person/people who developed these most recent validation functions did not think programmers would not want the numeric data to be something that could be stuck straight into a SQL query as a numeric data type. Commas should be an exception, not the rule. Add a new validation function called numberWithCommas or something like that, but why break something that works just fine? What's even worse, is the number validation functions will allow an arbitrary number of commas at arbitrary positions. So the user can enter 1,,2,,,35 and it will validate just fine. This is because whoever wrote the validation JavaScript (located in cfform.js) decided it would be a wise idea to strip the commas, and other special characters, from the input string before validating it. However, these characters are not stripped from the user's actual input, so the JavaScript is validating something different that was actually typed. I don't see how you can call this anything but a bug. I've been a huge fan and supporter of ColdFusion since I started using it in version 5. However, this recent discovery has caused me to lose a lot of faith, because data validation that is something that I fell can not be overlooked in the slightest, as it apparently has been in MX 7. I for one, will be using custom regular expressions, until Adobe either issues a fix for the validation functions, or the new version of CF is released, and I would suggest that everyone else do the same, as that current numeric validation functions pose a serious security risk and allow users to easily crash your application if you do not know what to expect. As a footnote, I've also had issues with the validate=telephone function as well. I would suggest for anyone that extensively uses the validation feature in cfform elements, to write their own custom regular expressions for as many of the validation types as possible. Of course, you could also make changes to the cfform.js script, but that probablly isn't the wisest idea for a long-term solution. Regards, Justin Holzer I was gonna say, I thought an Int was just a whole number, meaning no fractions or decimals correct? Commas should be allowed past that shouldn't they? ~| 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:252189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
restarting CF via the factory
Was wondering if it was possible to restart Coldfusion ( and related services ) programmatically.. perhaps through the factory? ~| 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:252190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replying after the message
Robertson-Ravo, Neil (RX) wrote: An RFC for posting, lol. Looks like I will have to scroll for more, and more, and more:-) That isn't very convincing from somebody with a 15 line signature. Jochem ~| 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:252191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: restarting CF via the factory
Create a batch file to stop then start the services, and call it via cfexecute. You will need to add a wait command between the stop and start as cf can take a few minutes to stop sometimes. Russ -Original Message- From: D F [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 12:56 To: CF-Talk Subject: restarting CF via the factory Was wondering if it was possible to restart Coldfusion ( and related services ) programmatically.. perhaps through the factory? ~| 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:252192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion serial number lost
The serial is also on the box and the card that came inside the box. If you have lost ALL of these, then your stuffed, as you have no proof you ever owned it. Russ -Original Message- From: Massimo Gianadda [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 12:12 To: CF-Talk Subject: Re: Coldfusion serial number lost Thank you for your help, unfortunately I had no time to register, it was a fresh copy (Murphy docet). But I can't believe there is no solution to this issue. Max -Original Message- From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Date: Tue, 05 Sep 2006 22:21:41 -0400 Subject: Re: Coldfusion serial number lost Massimo Gianadda wrote: Sorry for the OT, but I'm really frustrated, I have purchased Coldfusion from an Italian reseller, unfortunately CD with serials has been kept away by a courier who retired a server and are lost. If you REGISTERED the product with Adobe, hey *MIGHT* be able to help... if not though, you're probably SOL. 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:252193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: restarting CF via the factory
unfortunatley cannot do this ( already thought of that ) with present server configuration. Either through Bat. or .wsh/vbs/js etc... permissions issue with managed server. Create a batch file to stop then start the services, and call it via cfexecute. You will need to add a wait command between the stop and start as cf can take a few minutes to stop sometimes. Russ -Original Message- From: D F [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 12:56 To: CF-Talk Subject: restarting CF via the factory Was wondering if it was possible to restart Coldfusion ( and related services ) programmatically.. perhaps through the factory? ~| 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:252194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replying after the message
LOL, yeah well corporate rules, and besides the sig is at the end ;-p -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 13:01 To: CF-Talk Subject: Re: Replying after the message Robertson-Ravo, Neil (RX) wrote: An RFC for posting, lol. Looks like I will have to scroll for more, and more, and more:-) That isn't very convincing from somebody with a 15 line signature. Jochem ~| 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:252195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: can you resolve this domain?
Works from the UK.. -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 04:27 To: CF-Talk Subject: Re: OT: can you resolve this domain? Hey all, We are having some dns issues where some ISP's can resolve our domain and some can't. Something about nameserver records pointing to multiple servers. It would be super duper if some folks could try to hit our domain, and then just reply to the list yes or no and what isp you are on, or if you use a different dns server than your isp's, whose dns server you're using. For example yes - comcast or no - cox. So far ones that can't resolve are Speakeasy and Verizon, while it seems others can. The domain is: http://www.igigi.com TIA! No for Verizon from here in the back waters of Chesapeake Bay :-) ~| 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:252197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: restarting CF via the factory
Use ColdFusion to create the text you need to create the batch file. Use cffile to create a file, add the text for commands you need and then change the file extension to .bat or whatever. I doubt the server manager locked down creation of new files in your working web directory. Teddy On 9/6/06, D F [EMAIL PROTECTED] wrote: unfortunatley cannot do this ( already thought of that ) with present server configuration. Either through Bat. or .wsh/vbs/js etc... permissions issue with managed server. Create a batch file to stop then start the services, and call it via cfexecute. You will need to add a wait command between the stop and start as cf can take a few minutes to stop sometimes. Russ -Original Message- From: D F [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 12:56 To: CF-Talk Subject: restarting CF via the factory Was wondering if it was possible to restart Coldfusion ( and related services ) programmatically.. perhaps through the factory? ~| 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:252200 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replying after the message
Robertson-Ravo, Neil (RX) wrote: LOL, yeah well corporate rules That's why I don't post from a corporate address: I think it is unprofessional to bombard readers with all that junk. It is a one-time setup issue for me vs. a recurring reading experience for everybody on the list. Jochem ~| 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:252201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cross-Server Joins
Check out the OPENROWSET function in T-SQL:
OPENROWSET
Includes all connection information necessary to access remote data from
an OLE DB data source. This method is an alternative to accessing tables
in a linked server and is a one-time, ad hoc method of connecting and
accessing remote data using OLE DB. The OPENROWSET function can be
referenced in the FROM clause of a query as though it is a table name.
The OPENROWSET function can also be referenced as the target table of an
INSERT, UPDATE, or DELETE statement, subject to the capabilities of the
OLE DB provider. Although the query may return multiple result sets,
OPENROWSET returns only the first one.
OPENROWSET ( 'provider_name'
, { 'datasource' ; 'user_id' ; 'password'
| 'provider_string' }
, { [ catalog. ] [ schema. ] object
| 'query' }
)
Mark
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 6:17 AM
To: CF-Talk
Subject: RE: Cross-Server Joins
I have heard tell that it is possible to perform cross-database and
even cross-server joins in MSSQL but I can't find any good info on how
it is done. Can someone point me in the right direction, specifically
for the cross server stuff?
Before you reply, my mistake. By cross-server I should have said
cross-platform. I am trying to link a MySQL database into MSSQL.
I have found several references online but none of them work so I was
wondering if any of you had experience.
--
Jay
~|
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:252202
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: can you resolve this domain?
No, @ videotron.ca serving mostly the province of Quebec. Works today. May be it was just a question of letting all DNS in the world to update. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:252203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Digest mode list problems
I'm having all kinds of issues with my cf-talk and cf-community digests. Are those of you who get the single message feed having problems too? George ~| 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:252204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I am soooo pissed
Not if the domain was already hosted at Netsol. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 3:59 PM To: CF-Talk Subject: Re: I am s pissed You know what is weird...The site is already online!! I thought it took awhile, especially at networksolutions. Go Figure Doug ~| 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:252205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cross-Server Joins
Using mySQL it's possible (as long as the user you're logged in as has permissions on both tables. Simply prepend the tablename with the database name like so: SELECT d1t1.id, d2t2.id FROM database1.table1 AS d1t1 INNER JOIN database2.table2 AS d2t2 ON d1t1.id = d2.t2.id !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:59 AM To: CF-Talk Subject: Cross-Server Joins I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? -- Jay ~| 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:252206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFOpenChat 0.97b Released
A lot of progress has been made in the last week with regards to the reliability of CFOpenChat. It handles temporary connection failures much better now, and will hopefully no longer just randomly decide to boot everyone out of the chat room at will. CFOpenChat is a coldfusion powered chat room application built using Rob Gonda's ajaxCFC. It supports MSSQL and MySQL, and could easily be adapted for other database as well. For full details, a demo, and the download, visit: http://www.opensourcecf.com/cfopenchat/ CFOpenChat is free, open source software licensed under the BSD license. Enjoy! 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:252207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fusion Reactor issues
Maureen Barger wrote: Can you: -adjust your jvm memory settings so you have more available memory for CF? -adjust your FR settings so it doesn't kill threads, or at least allow more threads until it starts killing them off? Raise the level of the rivers, and the rocks won't be noticeable. Unfortunately FR is within the CF container, so if CF is unresponsive, FR will be too. :( Okay, however, once CF becomes responsive again, how do I get Fusion Reactor to reconnect to my instance? It seems that the only way to do so is to restart Coldfusion, which is undesirable. 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:252208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cross-Server Joins
I think he sorted it, that will work for the same DB instance/type but for X-Server joins you will need to use Linked Servers. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 14:19 To: CF-Talk Subject: RE: Cross-Server Joins Using mySQL it's possible (as long as the user you're logged in as has permissions on both tables. Simply prepend the tablename with the database name like so: SELECT d1t1.id, d2t2.id FROM database1.table1 AS d1t1 INNER JOIN database2.table2 AS d2t2 ON d1t1.id = d2.t2.id !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:59 AM To: CF-Talk Subject: Cross-Server Joins I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? -- Jay ~| 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:252209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cross-Server Joins
Yah... Saw that. Never would have thought you could do a join between two diff databases. I guess you'd have to use ANSI standard functions eh? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 8:57 AM To: CF-Talk Subject: RE: Cross-Server Joins I think he sorted it, that will work for the same DB instance/type but for X-Server joins you will need to use Linked Servers. ~| 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:252210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cross-Server Joins
However James Ive never actually done what your requesting myself, if it works I'd love to know heh ;) I have used cross server joins before on MSSQL 2000 servers and the performance was so bad I had to take it out. I eventually had to call a proc on the second server to gather data, and then pass the result set back to first server which I dumped into a temp table and THEN joined my stuff to it. It was a pain, but it performed a few thousand times better. I really think we had some configuration awry somewhere though... ~| 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:252211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Peg = Margaret name matching code
I think using a database table, like Pete suggested, is a decent solution. The issues I was hoping to avoid were the tedious data entry, quality assurance testing, and keeping it updated. That is why I was hoping for something open-source or a professional product. There are products that do this that you can buy, although the few I have seen are very expensive, and they probably do not integrate well with ColdFusion. Soundex would help for accidental misspellings, which is more likely for addresses than names. For example, College vs Collage. I imagine those would be identical to Soundex. Minnesota and Massachusetts are commonly misspelled. Thank you, Mike Chabot On 9/5/06, Robert Munn [EMAIL PROTECTED] wrote: Why not write a package that does it? You even have a name for it- Peg! Does anyone know of code that can match formal names, such as Michael with their less formal equivalents, such as Mike. I was starting to code this but stopped after realizing that there were thousands of these nicknames. I am mainly interested in names, but matching addresses abbreviation, such as Blvd = Boulevard might be helpful as well. http://www.usgenweb.org/research/nicknames.shtml ~| 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:252212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFOpenChat 0.97b Released
http://www.opensourcecf.com/cfopenchat/ CFOpenChat is free, open source software licensed under the BSD license. Very nice, liked it a lot :) Paul ~| 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:252213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Selenium Testing with CF (?)
Michael, We use Selenium in-house for our testing. It has saved us a lot of time and is a great tool. Highly Reccomended. We plan to wire up a bunch of selenium test cases to run at night on our HEAD code branch. Leon -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Saturday, September 02, 2006 10:55 PM To: CF-Talk Subject: Selenium Testing with CF (?) Has anyone used Selenium ( http://www.openqa.org/selenium/ ) to test any scripts, if not CF apps itself. I just came across it earlier and have been curious. ~| 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:252214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: can you resolve this domain?
Works today. !k -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 4:00 PM To: CF-Talk Subject: RE: can you resolve this domain? No - Sasktel / BigPipe (Canuck ISP) !k -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 3:52 PM To: CF-Talk Subject: Re: can you resolve this domain? No - Uniserve.com (Canadian ISPcovers whole country) Victoria, BC Canada 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:252215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cross-Server Joins
OK, sorted. I used the previously mentioned tequnique but changed the
connection string to...
DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=intranet;UID=;PWD=;OPTION=3
And used the MyODBC 3.51.12 driver, 3.51.11 or earlier didn't work (I was on
11).
I now have CF joining tables from a MSSQL database with those from a MySQL
database just fine, the performance is sucky but for this it doesn't matter
as it is being upgraded to MSSQL shortly anyway, just not shortly enough for
this project ;-)
--
Jay
~|
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:252216
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Password access for PDF files
I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:252217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Password access for PDF files
Add an Isapi rewrite to redirect all .pdfs to a page like library.cfm? file=filename.ext Then you can log the filename and any other info in a database, and then serve the file via CFHEADER.? T On 6 Sep 2006, at 16:26, Andy Matthews wrote: I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:252218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Password access for PDF files
Right. I'm planning on some system setups to make sure that people can't link directly to the file. How would this work though with alternate file types? For example, all but 3 or 4 of my newsletters are PDF. The other 3 or 4 are plain Coldfusion pages. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 10:32 AM To: CF-Talk Subject: Re: Password access for PDF files Add an Isapi rewrite to redirect all .pdfs to a page like library.cfm? file=filename.ext Then you can log the filename and any other info in a database, and then serve the file via CFHEADER.? T On 6 Sep 2006, at 16:26, Andy Matthews wrote: I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:252219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Password access for PDF files
The ISAPI rewrite would catch ALL instances of .pdf or whatever you script it to: So , www.domain.com/test.pdf would be caught, rewritten to: www.domain.com/library/downloads.cfm?file=test.pdf The file string could then be parsed, checked in a databse, and then served if approved. You'd have to put an exception in the http.ini file to prevent the Filter from re-catching the .pdf in the ?file= string though! T On 6 Sep 2006, at 16:36, Andy Matthews wrote: Right. I'm planning on some system setups to make sure that people can't link directly to the file. How would this work though with alternate file types? For example, all but 3 or 4 of my newsletters are PDF. The other 3 or 4 are plain Coldfusion pages. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 10:32 AM To: CF-Talk Subject: Re: Password access for PDF files Add an Isapi rewrite to redirect all .pdfs to a page like library.cfm? file=filename.ext Then you can log the filename and any other info in a database, and then serve the file via CFHEADER.? T On 6 Sep 2006, at 16:26, Andy Matthews wrote: I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:252220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiserver instances and web server configuration
Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read: directory) within a single web site uses a DIFFERENT instance of Coldfusion than the rest of the web site? 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:252221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiserver instances and web server configuration
Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read: directory) within a single web site uses a DIFFERENT instance of Coldfusion than the rest of the web site? Yes. Each CF server will require a unique context root. By default, CF's context root is /. You'll need to change one of them to /some_directory. It's been a while since I've done this so I can't give you step-by-step instructions, but this should get you 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! ~| 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:25 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiserver instances and web server configuration
No. ColdFusion instances are tied to the web server and, as a result, to the site itself. I don't know any any way to take this to a more granular level. On 9/6/06, Rick Root [EMAIL PROTECTED] wrote: Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read: directory) within a single web site uses a DIFFERENT instance of Coldfusion than the rest of the web site? 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:252223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiserver instances and web server configuration
Dave and Rick, If you guys can figure out how to do this I'd love to know - it would make a nice blog entry :) I did not know this was possible in IIS - I always used different site roots instead (www1, www2 ... Etc). -mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 11:06 AM To: CF-Talk Subject: RE: Multiserver instances and web server configuration Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read: directory) within a single web site uses a DIFFERENT instance of Coldfusion than the rest of the web site? Yes. Each CF server will require a unique context root. By default, CF's context root is /. You'll need to change one of them to /some_directory. It's been a while since I've done this so I can't give you step-by-step instructions, but this should get you 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! ~| 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:252224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: IIS 6 Virtual Directories
Is there a way to configure a virtual directory in IIS that automatically applies to *ALL* web sites? There must be, because when you install coldfusion, cfdocs and cfide are automatically added the new web sites created in IIS (if coldfusion is configured standalone). I'm not sure how it's done though. I'd like to create a couple of virtual directories on each of my 8 hosted sites without going through the obnoxious process of point and clicking my way through the creation of 16 or 24 different virtual directories. 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:252225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiserver instances and web server configuration
Dave - Do I understand correctly, then, that ColdFusion will allow you to tie multiple CF Servers to a single virtual host using the wsconfig utility? On 9/6/06, Dave Watts [EMAIL PROTECTED] wrote: Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read: directory) within a single web site uses a DIFFERENT instance of Coldfusion than the rest of the web site? Yes. Each CF server will require a unique context root. By default, CF's context root is /. You'll need to change one of them to /some_directory. It's been a while since I've done this so I can't give you step-by-step instructions, but this should get you 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! ~| 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:252226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiserver instances and web server configuration
Do I understand correctly, then, that ColdFusion will allow you to tie multiple CF Servers to a single virtual host using the wsconfig utility? If they have different context roots, yes, I think so. 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! ~| 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:252227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: can you resolve this domain?
All, thanks for trying my domain. Turns out it was a Plesk 8/Red Hat Linux issue causing the nameserver to crash which has now been rectified. If anyone is running that configuration this link describes the issue. http://forum.swsoft.com/showthread.php?s=429144aedcddc7f1d70655bd55f2e133threadid=22147perpage=15highlight=named%20failedpagenumber=1 -- Josh - Original Message - From: Claude Schneegans [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, September 06, 2006 5:54 AM Subject: Re: OT: can you resolve this domain? No, @ videotron.ca serving mostly the province of Quebec. Works today. May be it was just a question of letting all DNS in the world to update. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:252228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiserver instances and web server configuration
Wow. I guess it just seemed so counterintuitive (maybe my intuition is faulty) that I never tried to do that. Or maybe I just never had a business case. :-) I agree with Mark, though, that this would be good blog-fodder. On 9/6/06, Dave Watts [EMAIL PROTECTED] wrote: Do I understand correctly, then, that ColdFusion will allow you to tie multiple CF Servers to a single virtual host using the wsconfig utility? If they have different context roots, yes, I think so. 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! ~| 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:252229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: IIS 6 Virtual Directories
Probably several ways. I remember using cfx_IIS for this kind of thing. You probably also have the ability to use the .vbs admin files in the wwwroot. You could also roll your own using a VB app. Jeez, there may even be interfaces for this in IIS 6 which are new since 5. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Rick Root To: CF-Talk Sent: Wed Sep 06 17:15:43 2006 Subject: SOT: IIS 6 Virtual Directories Is there a way to configure a virtual directory in IIS that automatically applies to *ALL* web sites? There must be, because when you install coldfusion, cfdocs and cfide are automatically added the new web sites created in IIS (if coldfusion is configured standalone). I'm not sure how it's done though. I'd like to create a couple of virtual directories on each of my 8 hosted sites without going through the obnoxious process of point and clicking my way through the creation of 16 or 24 different virtual directories. 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:252230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiserver instances and web server configuration
Rob Wilkerson wrote: Wow. I guess it just seemed so counterintuitive (maybe my intuition is faulty) that I never tried to do that. Or maybe I just never had a business case. :-) I agree with Mark, though, that this would be good blog-fodder. Well there's definately no way to do it in the web site configuration tool.. so it must be a manual think ,which I'll have to look into further. 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:252231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: IIS 6 Virtual Directories
Robertson-Ravo, Neil (RX) wrote: Probably several ways. I remember using cfx_IIS for this kind of thing. You probably also have the ability to use the .vbs admin files in the wwwroot. You could also roll your own using a VB app. Jeez, there may even be interfaces for this in IIS 6 which are new since 5. That last part there doesn't seem to be.. you can edit global web site properties but there doesn't seem to be any way in the IIS admin to create a global virtual directory... I'll check out the vb admin scripts 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:252232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Password access for PDF files
First store the files you want to 'lock' outside of the webroot so no one is going to guess a link to them or share it once they have downloaded it. Next, write a form that asks for all the information you want to store in the database. When the form is submitted, validate your fields and then use cfheader and cfcontent to push the file to the user I use a random file name to give the user so they donÂ’t even know the original file name (like it matters since they are stored outside the webroot though) So basically... cfif FORM FIELDS ALL CHECK OUT OK cfset tempname = randrange(1, 9) .pdf / cfheader name=Content-disposition value=attachment;filename=#tempname# cfcontent type=application/pdf file=d:\full\path\to\file.pdf /cfif ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 11:27 AM To: CF-Talk Subject: Password access for PDF files I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:252233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: IIS 6 Virtual Directories
Check out what you can do via COM as well (if anything) This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Rick Root To: CF-Talk Sent: Wed Sep 06 17:40:03 2006 Subject: Re: SOT: IIS 6 Virtual Directories Robertson-Ravo, Neil (RX) wrote: Probably several ways. I remember using cfx_IIS for this kind of thing. You probably also have the ability to use the .vbs admin files in the wwwroot. You could also roll your own using a VB app. Jeez, there may even be interfaces for this in IIS 6 which are new since 5. That last part there doesn't seem to be.. you can edit global web site properties but there doesn't seem to be any way in the IIS admin to create a global virtual directory... I'll check out the vb admin scripts 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:252234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Password access for PDF files
Oops... That will force the user to download the file not open it in their browser. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 12:39 PM To: CF-Talk Subject: RE: Password access for PDF files First store the files you want to 'lock' outside of the webroot so no one is going to guess a link to them or share it once they have downloaded it. Next, write a form that asks for all the information you want to store in the database. When the form is submitted, validate your fields and then use cfheader and cfcontent to push the file to the user I use a random file name to give the user so they donÂ’t even know the original file name (like it matters since they are stored outside the webroot though) So basically... cfif FORM FIELDS ALL CHECK OUT OK cfset tempname = randrange(1, 9) .pdf / cfheader name=Content-disposition value=attachment;filename=#tempname# cfcontent type=application/pdf file=d:\full\path\to\file.pdf /cfif ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 11:27 AM To: CF-Talk Subject: Password access for PDF files I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:252235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: IIS 6 Virtual Directories
iisvdir.vbs doesn't do exactly what I want but at least I can copy/paste... anything is easier than creating 24 virtual directories via point and click! 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:252236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SOT: IIS 6 Virtual Directories
iisvdir.vbs doesn't do exactly what I want but at least I can copy/paste... anything is easier than creating 24 virtual directories via point and click! This came up on the list a few days ago. I've written scripts to do this before; unfortunately, I don't have them available where I am now. But, it was very easy to do - you might want to check out sample scripts on http://www.iisfaq.com/. 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! ~| 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:252237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: IIS 6 Virtual Directories
You can certainly do this via cfx_IIS tag. Not sure what the support it like though for II6. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Rick Root To: CF-Talk Sent: Wed Sep 06 17:51:05 2006 Subject: Re: SOT: IIS 6 Virtual Directories iisvdir.vbs doesn't do exactly what I want but at least I can copy/paste... anything is easier than creating 24 virtual directories via point and click! 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:252238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Password access for PDF files
I don't mind that actually. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 11:44 AM To: CF-Talk Subject: RE: Password access for PDF files Oops... That will force the user to download the file not open it in their browser. ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 12:39 PM To: CF-Talk Subject: RE: Password access for PDF files First store the files you want to 'lock' outside of the webroot so no one is going to guess a link to them or share it once they have downloaded it. Next, write a form that asks for all the information you want to store in the database. When the form is submitted, validate your fields and then use cfheader and cfcontent to push the file to the user I use a random file name to give the user so they donÂ’t even know the original file name (like it matters since they are stored outside the webroot though) So basically... cfif FORM FIELDS ALL CHECK OUT OK cfset tempname = randrange(1, 9) .pdf / cfheader name=Content-disposition value=attachment;filename=#tempname# cfcontent type=application/pdf file=d:\full\path\to\file.pdf /cfif :.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 11:27 AM To: CF-Talk Subject: Password access for PDF files I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:252239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problems with instance manager
so i've installed CF7.0.2 in multiserver mode and I've logged into the CF Administrator. I am trying to create a new instance in the enterprise manager, and it keeps failing on step 3 [step 3 of 4] Deploying, this may take a few minutes... I get a request timeout error The request has exceeded the allowable time limit Tag: cfoutput it happens after 5-10 minutes. the settings in the administrator is set to timeout requests at 60 seconds but it's going way longer than that. Why is this taking so long? It's a nice server, dual xeon 2.4ghz, 4gb of ram and no load on it whatsoever. 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:252240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: restarting CF via the factory
Well the problem is not file creation, the problem is not having admin access to the services to restart them. Hence why I was looking for a backdoor to restarting the CF server. ~| 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:252241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Problems with instance manager
so i've installed CF7.0.2 in multiserver mode and I've logged into the CF Administrator. I am trying to create a new instance in the enterprise manager, and it keeps failing on step 3 [step 3 of 4] Deploying, this may take a few minutes... I get a request timeout error The request has exceeded the allowable time limit Tag: cfoutput it happens after 5-10 minutes. the settings in the administrator is set to timeout requests at 60 seconds but it's going way longer than that. Why is this taking so long? It's a nice server, dual xeon 2.4ghz, 4gb of ram and no load on it whatsoever. It can take quite a while for this to run, although 10 minutes seems excessive from my own experience. Try disabling the request timeout setting in the CF Administrator temporarily. 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! ~| 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:252242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problems with instance manager
third try's a charm... I had to disable my on-access virus scanning.. that always slows stuff down. Rick Root wrote: so i've installed CF7.0.2 in multiserver mode and I've logged into the CF Administrator. I am trying to create a new instance in the enterprise manager, and it keeps failing on step 3 [step 3 of 4] Deploying, this may take a few minutes... I get a request timeout error The request has exceeded the allowable time limit Tag: cfoutput it happens after 5-10 minutes. the settings in the administrator is set to timeout requests at 60 seconds but it's going way longer than that. Why is this taking so long? It's a nice server, dual xeon 2.4ghz, 4gb of ram and no load on it whatsoever. ~| 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:252243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Password access for PDF files
Then it is most definitely the way I'd go. Give a shout if you have any trouble with it. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 1:02 PM To: CF-Talk Subject: RE: Password access for PDF files I don't mind that actually. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 11:44 AM To: CF-Talk Subject: RE: Password access for PDF files Oops... That will force the user to download the file not open it in their browser. :.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/438 - Release Date: 9/5/2006 ~| 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:252244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problems with instance manager
Have u checked the jrun logs to see what they say. It shouldn't take that long, so something is obviously failing. Snake -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 18:38 To: CF-Talk Subject: Problems with instance manager so i've installed CF7.0.2 in multiserver mode and I've logged into the CF Administrator. I am trying to create a new instance in the enterprise manager, and it keeps failing on step 3 [step 3 of 4] Deploying, this may take a few minutes... I get a request timeout error The request has exceeded the allowable time limit Tag: cfoutput it happens after 5-10 minutes. the settings in the administrator is set to timeout requests at 60 seconds but it's going way longer than that. Why is this taking so long? It's a nice server, dual xeon 2.4ghz, 4gb of ram and no load on it whatsoever. 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:252245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Bulk data loading
Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be greatly appreciated. I've played with a CFC that makes Java calls but without success. Thanks in advance, -- Chris Tilley ~| 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:252246 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Bulk data loading
This is something that the database should do, not CF. Not being an Oracle guy, I can't tell you what that is, but it has been discussed here recently. (Hint. :) ) Anyways, you're looking for whatever Oracle's equivalent is to MSSQL's DTS. That should at least get you on the right track. Ray -Original Message- From: Chris Tilley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 2:20 PM To: CF-Talk Subject: Bulk data loading Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be greatly appreciated. I've played with a CFC that makes Java calls but without success. Thanks in advance, -- Chris Tilley ~| 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:252247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bulk data loading
Does anyone have a tested method of uploading bulk data to a database? Just set a datasource using the Microsoft Excel ODBC driver and query in the data. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:252248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bulk data loading
You're talking about a CSV right? What amounts to a simple list, but with zillions of rows? The trick I found to getting this done (which the good folks here helped with enormously) is to use java to read each line incrementally rather than having cffile try to scarf down the whole file into memory. I don't have code handy right this second (I can get hold of it when I get back home tonight) but basically once you read in a single line you just use list processing to feed the individual fields into an insert statement. I actually used listToArray() and then array notation in my code, to keep from having to use listGetAt() or somesuch on every spot on my insert. Was easier for me as well if I wanted to manipulate the field prior to saving as well. On 9/6/06, Chris Tilley [EMAIL PROTECTED] wrote: Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be greatly appreciated. I've played with a CFC that makes Java calls but without success. Thanks in advance, -- Chris Tilley ~| 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:252249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Bulk data loading
Well, yea, I guess, depending on the size of this spreadsheet, this would work just as well. Chris, how large is this Excel sheet? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 2:31 PM To: CF-Talk Subject: Re: Bulk data loading Does anyone have a tested method of uploading bulk data to a database? Just set a datasource using the Microsoft Excel ODBC driver and query in the data. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:252250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bulk data loading
Matt Robertson wrote: You're talking about a CSV right? What amounts to a simple list, but with zillions of rows? The trick I found to getting this done (which the good folks here helped with enormously) is to use java to read each line incrementally rather than having cffile try to scarf down the whole file into memory. I don't have code handy right this second (I can get hold of it when I I blogged the method at www.opensourcecf.com =) 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:252251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bulk data loading
Rick Root wrote: I blogged the method at www.opensourcecf.com =) specifically... http://www.opensourcecf.com/1/2006/07/Reading-large-files-with-java-versus-CFFILE.cfm ~| 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:252252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bulk data loading
Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be greatly appreciated. I've played with a CFC that makes Java calls but without success. Thanks in advance, -- Chris Tilley With Oracle, 9i or newer your best bet is to set up an externally organized table. It's basically stored SQL loader which allows you to access an external text file as you would any read-only oracle table via SQL. You would export your Excel data into csv format, then set up the EOT to point to that file. You can then overwrite that file at any time with new data. Here's an example of the PL/SQL to create one of these. Most of it will be cut and paste - you'll need to create a directory in Oracle (pointer to the filesystem directory you will put the CSV in) and fill it in for MYDATA_DIR CREATE TABLE EXT_ACCOUNT_BALANCE ( ACCOUNTVARCHAR2(20 BYTE), BEGIN_BAL NUMBER ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY MYDATA_DIR ACCESS PARAMETERS ( RECORDS DELIMITED BY 0x'0a' CHARACTERSET WE8ISO8859P9 LOGFILE 'beginbalance.log' BADFILE 'beginbalance.bad' READSIZE 1048576 FIELDS TERMINATED BY , OPTIONALLY ENCLOSED BY '' LDRTRIM REJECT ROWS WITH ALL NULL FIELDS ( account CHAR(255) TERMINATED BY , OPTIONALLY ENCLOSED BY '', begin_bal CHAR(255) TERMINATED BY , OPTIONALLY ENCLOSED BY '' ) ) LOCATION (MYDATA_DIR:'beginbalance.csv') ) ; ~| 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:252253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bulk data loading
Ray, Approx. 145kb, 1000 rows with 16 columns Matt, I'd love to see your sample code, if you don't mind sharing? Chris On 9/6/06, Ray Champagne [EMAIL PROTECTED] wrote: Well, yea, I guess, depending on the size of this spreadsheet, this would work just as well. Chris, how large is this Excel sheet? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 2:31 PM To: CF-Talk Subject: Re: Bulk data loading Does anyone have a tested method of uploading bulk data to a database? Just set a datasource using the Microsoft Excel ODBC driver and query in the data. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:252254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
dynamic related select box
Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamic related select box
CFAjax Ali Majdzadeh wrote: Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bulk data loading
On 6 Sep 2006, at 11:19, Chris Tilley wrote: Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be greatly appreciated. I've played with a CFC that makes Java calls but without success. You'll probably get the best performance using the Oracle SQL*Plus tools, specifically SQL*Loader: http://www.orafaq.com/faq/sql_loader -- Joseph Lamoree ~| 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:252257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bulk data loading
I've tried it but getting an error message: 12:52:15.015 - Expression Exception - in D:\Inetpub\cf\WorkingCapitalFund\FileReader.cfc : line 65 Variable RETURNSTRING is undefined. Any ideas why? On 9/6/06, Rick Root [EMAIL PROTECTED] wrote: Rick Root wrote: I blogged the method at www.opensourcecf.com =) specifically... http://www.opensourcecf.com/1/2006/07/Reading-large-files-with-java-versus-CFFILE.cfm ~| 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:252258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamic related select box
Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign The most commonly used CF solution is Nate Weiss' Two-Selects related custom tag: http://projects.nateweiss.com/nwdc/downloads/cf/CF_TwoSelectsRelated.zip very simple to use. Selene Bainum also has a good tutorial on related selects that you might want to check out. http://www.webtricks.com/sourcecode/code.cfm?CodeID=18 hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| 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:252259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bulk data loading
Chris Tilley wrote: I've tried it but getting an error message: 12:52:15.015 - Expression Exception - in D:\Inetpub\cf\WorkingCapitalFund\FileReader.cfc : line 65 Variable RETURNSTRING is undefined. Any ideas why? Your cfc is referencing a variable that isn't defined? I don't know, I can't see your code =) returnstring isn't in my code anywhere... 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:252260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bulk data loading
Joseph Lamoree wrote: You'll probably get the best performance using the Oracle SQL*Plus tools, specifically SQL*Loader: http://www.orafaq.com/faq/sql_loader You are probably right - but for 1000 records, 145KB of data, and it only occurs once per year (I think that's what he said), it's probably not worth the effort. 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:252261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application CFC and the URL.
Which events in the application.cfc framework, if any, would have access to URL variables? In more specific terms, if I wanted to have an application.cfc function called based on the existence and|or value of a url variable, how could I do this? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:252262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Application CFC and the URL.
I use the CGI and URL values in my OnApplicationStart() method with no problems ( I think ). Although an also initialize outside of on applicationStart method... So not sure. All I know is the site works. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:37 PM To: CF-Talk Subject: Application CFC and the URL. Which events in the application.cfc framework, if any, would have access to URL variables? In more specific terms, if I wanted to have an application.cfc function called based on the existence and|or value of a url variable, how could I do this? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:252263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bulk data loading
On 6 Sep 2006, at 12:45, Rick Root wrote: You are probably right - but for 1000 records, 145KB of data, and it only occurs once per year (I think that's what he said), it's probably not worth the effort. True. I thought we were talking about a jazillion rows. I have a similar requirement for one of my projects -- to generate a batch of a few hundred thousand serial numbers and do a bulk import to PostgreSQL. The serial numbers are appended to a CSV flat file as they are created. I use the native psql program and a bit of shell scripting to bring them into the appropriate table. It takes far longer to generate the serial numbers with a PRNG than it does to copy them to the database, but less time than it takes to get another cup of coffee. -- Joseph Lamoree ~| 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:252264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Upload File first within a form, retain form values
I've never done a upload funtion/submit process as a subset process from within another parent form. Any CF custom tags do this or any direction would be great. I have a form with name, company name, etc. and within the form I have an upload file form field with an upload file only submit button. There's two submit/function buttons, the first within the form and is the upload file process mentioned above and the second surrounds the entire form inclusing the file upload as a save all button. I want to retain the name company name etc. when the user uploads the file and I want to save the the entire from when the user clicks save all which would commit the entire form. 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:252265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Application CFC and the URL.
Depends on when you want the code to execute. If it is a URL variable, you probably want it onRequestStart. On 9/6/06, Ben Nadel [EMAIL PROTECTED] wrote: I use the CGI and URL values in my OnApplicationStart() method with no problems ( I think ). Although an also initialize outside of on applicationStart method... So not sure. All I know is the site works. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:37 PM To: CF-Talk Subject: Application CFC and the URL. Which events in the application.cfc framework, if any, would have access to URL variables? In more specific terms, if I wanted to have an application.cfc function called based on the existence and|or value of a url variable, how could I do this? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:252266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Bulk data loading
Sorry to come in late in the convo... If you can put the file in a public directory, I have found from some simple testing that CFHttp is faster than a buffered file reader... http://bennadel.com/blog/200-ColdFusion-CFHttp-To-Query-Much-Faster-Than-Jav a-Buffered-Reader.htm DISCLAIMER: I am a ColdFusion programmer, not a Java programmer, so there are probably issues. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Chris Tilley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:26 PM To: CF-Talk Subject: Re: Bulk data loading I've tried it but getting an error message: 12:52:15.015 - Expression Exception - in D:\Inetpub\cf\WorkingCapitalFund\FileReader.cfc : line 65 Variable RETURNSTRING is undefined. Any ideas why? On 9/6/06, Rick Root [EMAIL PROTECTED] wrote: Rick Root wrote: I blogged the method at www.opensourcecf.com =) specifically... http://www.opensourcecf.com/1/2006/07/Reading-large-files-with-java-ve rsus-CFFILE.cfm ~| 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:252267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse - FTP???
I posted a semi-walkthrough to the list for using Eclipse's FTP stuff, that is also an option (and I prefer it to working directly on the server). Search the archives for elcipse ftp and it should pop up. To repeat, it's geared towards working locally and uploading changed files when you're done, i.e. it doesn't directly open the files on the server. Great plugin! Don't know if you'd get the same read-only stuff or not... On 9/5/06, Rey Bango [EMAIL PROTECTED] wrote: Its definitely a big fileset situation. Ugh. :o( I appreciate the help. Rey Jim Wright wrote: Jim Wright wrote: This should only copy changed files (although I haven't tested that much with the FTP...the local copy definitely only copies over changed files, but when I'm doing the FTP, I've generally made a lot of changes, so I'm not positive.) Rey, As I was throwing out something untested here, I thought I better do a little testing, and this may not work for you. The FTP process depends on file times to decide what to send, so if your fileset has a lot of files, comparing the times will take a while (I just made a mod to a single file...Ant only sent up the one file, but it took 7 minutes to do it...the fileset is around 600 files...it might still work if you have a small fileset). I assume the local process does the same thing, but it is almost instantaneous with the same fileset. -jim ~| 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:252268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: passing arguments into a instantiated java object
For some reason they both can't handle interfaces very well. No one bothered to use the forName() method. O well So I wrote a small interface viewer. Take that rabbit! So now I know resultSet has 139 methods. On 9/6/06, James Holmes [EMAIL PROTECTED] wrote: The Object Viewer gives [empty string] For the same class. On 9/6/06, Dan Plesse [EMAIL PROTECTED] wrote: Does this work for you? cfset ResultSet = createObject(java, java.sql.ResultSet) cfdump var=#getJavaMetadata(ResultSet)#/ 09/06 00:09:44 Error [web-17] - The selected method getClass was not found.Either there are no methods with the specified method name and argument types, or the method getClass is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. The specific sequence of files included or processed is: C:\CFusionMX7\wwwroot\GetMetaData.cfm, line: 29 -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:252269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Google maps and Ajax
Are there any tools out there to help me connect google maps with my database of locations? I have about 20,000 locations I need to show on the map. I am guess I need Ajax which I have done none of. Any tools to help me would be appreciated. ThanksRob ~| 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:252270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: dynamic related select box
I like to write my own related selects but look for CF_TwoSelectsRelated by Nate Weiss (there are also others that will relate more than 2 selects) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:03 PM To: CF-Talk Subject: dynamic related select box Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Job Board Application
I need a job board application with Resume search ability and the ability in the future to possibly charge employers to post jobs. So we need user and employer accounts. If someone can recommend a good option that would be great. I am looking to buy something not an ASP. Vendor welcome to contact Me. Jim Louis Best Meetings Inc. [EMAIL PROTECTED] ~| 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:252272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dynamic related select box
Here is one you could use. It is not a custom tag, but not near as difficult
to format your html around it either. Just modify your queries etc...
cfif isDefined('form.select_Main_Group')
cfset page.select_Main_Group = form.select_Main_Group
/cfif
cfoutput
form name=DropDown method=post
!--- query DB for the first drop down list ---
cfquery name=get_Main_Group datasource=xxx
select categories.cat_id,
categories.category,
categories.parent_id
from categories
where categories.parent_id is null
/cfquery
!--- first drop down list ---
!--- NOTICE the onChange javascript event in the select tag, this is what
submits the form after the first selection ---
select name=select_Main_Group required=yes
onChange=this.form.submit()
option/option
!--- dynamically populate the first drop down list based on the
get_Main_Group query ---
!--- NOTICE the CFIF within the option tag, this says, if the first
selection has been made, display the chosen option when the page
reloads ---
cfloop query=get_Main_Group
option value=#cat_id# cfif
isDefined(form.select_Main_Group)cfif form.select_Main_Group eq
#cat_id#selected/cfif/cfif#category#/option
/cfloop
/select
p
!--- if the first selection has been made, display the second drop down
list with the appropriate results ---
cfif isDefined(page.select_Main_Group)
!--- query DB for second drop down list, based on the selected item from
the first list ---
cfquery name=get_Sub_Group datasource=xxx
select categories.cat_id,
categories.category,
categories.parent_id
from categories
where categories.parent_id = #form.select_Main_Group#
/cfquery
!--- second drop down list ---
select name=select_Sub_Group required=yes
onChange=this.form.submit()
optionSelect Subgroup/option
!--- dynamically populate the second drop down list based on the
get_Sub_Group query ---
cfloop query=get_Sub_Group
option value=#cat_id# cfif
isDefined(form.select_sub_group)cfif form.select_sub_group eq
#cat_id#selected/cfif/cfif#category#/option
/cfloop
/select
/cfif
/form
/cfoutput
- Original Message -
From: Bobby Hartsfield [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, September 06, 2006 2:21 PM
Subject: RE: dynamic related select box
I like to write my own related selects but look for CF_TwoSelectsRelated
by
Nate Weiss (there are also others that will relate more than 2 selects)
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ali Majdzadeh [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 3:03 PM
To: CF-Talk
Subject: dynamic related select box
Hi everybody:
I need a solution for dynamic related select box. For example when the
user
selects the state in the other select box all the cities of the selected
state appear.
Do you any free/easy way to do that. I use coldfusion/ms access.
Thanks
Benign
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252273
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Google maps and Ajax
Robert, I've become a big fan of JQuery (www.jquery.com) because of its great syntax and good documentation. They also have a demo that integrates with Google Maps which you can find here: http://olbertz.de/jquery/googlemap.html Unfortunately, its not an official demo so you will have to tinker with it. Rey... Robert Walters wrote: Are there any tools out there to help me connect google maps with my database of locations? I have about 20,000 locations I need to show on the map. I am guess I need Ajax which I have done none of. Any tools to help me would be appreciated. ThanksRob ~| 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:252274 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Application CFC and the URL.
Which events in the application.cfc framework, if any, would have access to URL variables? I would guess: onRequestStart, onRequestEnd, and onRequest. In more specific terms, if I wanted to have an application.cfc function called based on the existence and|or value of a url variable, how could I do this? You would check for its existence in, say, onRequestStart, then call the appropriate function. Presumably, you want to reinitialize your application? You can invoke onApplicationStart from within onRequestStart. 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! ~| 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:252275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
