Re: CFServer Problem
I can't turn them on, since they are off. I don't know if Siteminder Services are the cause, or whether the problem is simply coincidental, but when I attempt to access my datasources through the database tab within Studio, I am unable to do so (hence, unable to view tables or construct queries), and I receive the following message: An error occurred accessing ColdFusion Server: The authentication failed. [EMAIL PROTECTED] wrote: Hi John, do you really need Siteminder-services ? If not can you switch them off ? What happens then ? Uwe Hello John, Monday, January 6, 2003, 7:12:56 PM, you wrote: JA Good thought, Uwe, but I've run 4.01 under Win2K for a year and a half JA without a hiccup. But, thanks anyway. My suspicions run toward the IIS JA Metabase or some Windows .dll that got corrupted. Whatever files the two JA Siteminder apps depend on have been corrupted, or something is JA preventing them from being installed. JA -John JA [EMAIL PROTECTED] wrote: John, I might be wrong, but as far as I know 4, Win2k is unsupported by CF 4.01 I think you must run at least 4.5.x Uwe Hello John, Monday, January 6, 2003, 6:15:30 AM, you wrote: JA Me again. JA I've been working for several days to repair whatever problem has JA mangled my ColdFusion installation. I've uninstalled everything related JA to CF that I can find, cleaned up the registry, uninstalled IIS, JA reinstalled Windows, reinstalled IIS, reinstalled ColdFusion, and I JA continue to have the same problem. JA In addition I've spent considerable time on both Microsoft's and JA Macromedia's web sites and in the books. JA So I throw myself on the mercy of you guys. There has to be an expert JA who's faced a similar problem and who can point me in the right JA direction. JA I'm running: JA Win2K Pro (plenty of RAM and disk space - no current registry errors) JA IIS 5.0 - The server displays its default files and help system, so I JA know it's running okay. JA I had MDAC 2.7, but I think my most recent reinstallation of CF may have JA reinstalled MDAC 2.0 (but reinstalling 2.7 doesn't change the situation) JA CF 4.01 JA This is the error message I get in Windows Events: JA The SiteMinder Authentication Service service failed to start due to the JA following error: JA The system cannot find the file specified. JA Authorization Service is not running either. It displays: JA The SiteMinder Authorization Service service failed to start due to the JA following error: JA The system cannot find the file specified. JA For both, Windows displays Event ID: 7000 JA My choices are to call Microsoft ($$), call Macromedia ($$), or take my JA computer to a local repair shop ($$). JA Thanks for any help you can provide. JA John JA JA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFServer Problem
Good thought, Uwe, but I've run 4.01 under Win2K for a year and a half without a hiccup. But, thanks anyway. My suspicions run toward the IIS Metabase or some Windows .dll that got corrupted. Whatever files the two Siteminder apps depend on have been corrupted, or something is preventing them from being installed. -John [EMAIL PROTECTED] wrote: John, I might be wrong, but as far as I know 4, Win2k is unsupported by CF 4.01 I think you must run at least 4.5.x Uwe Hello John, Monday, January 6, 2003, 6:15:30 AM, you wrote: JA Me again. JA I've been working for several days to repair whatever problem has JA mangled my ColdFusion installation. I've uninstalled everything related JA to CF that I can find, cleaned up the registry, uninstalled IIS, JA reinstalled Windows, reinstalled IIS, reinstalled ColdFusion, and I JA continue to have the same problem. JA In addition I've spent considerable time on both Microsoft's and JA Macromedia's web sites and in the books. JA So I throw myself on the mercy of you guys. There has to be an expert JA who's faced a similar problem and who can point me in the right JA direction. JA I'm running: JA Win2K Pro (plenty of RAM and disk space - no current registry errors) JA IIS 5.0 - The server displays its default files and help system, so I JA know it's running okay. JA I had MDAC 2.7, but I think my most recent reinstallation of CF may have JA reinstalled MDAC 2.0 (but reinstalling 2.7 doesn't change the situation) JA CF 4.01 JA This is the error message I get in Windows Events: JA The SiteMinder Authentication Service service failed to start due to the JA following error: JA The system cannot find the file specified. JA Authorization Service is not running either. It displays: JA The SiteMinder Authorization Service service failed to start due to the JA following error: JA The system cannot find the file specified. JA For both, Windows displays Event ID: 7000 JA My choices are to call Microsoft ($$), call Macromedia ($$), or take my JA computer to a local repair shop ($$). JA Thanks for any help you can provide. JA John JA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFServer Problem
Me again. I've been working for several days to repair whatever problem has mangled my ColdFusion installation. I've uninstalled everything related to CF that I can find, cleaned up the registry, uninstalled IIS, reinstalled Windows, reinstalled IIS, reinstalled ColdFusion, and I continue to have the same problem. In addition I've spent considerable time on both Microsoft's and Macromedia's web sites and in the books. So I throw myself on the mercy of you guys. There has to be an expert who's faced a similar problem and who can point me in the right direction. I'm running: Win2K Pro (plenty of RAM and disk space - no current registry errors) IIS 5.0 - The server displays its default files and help system, so I know it's running okay. I had MDAC 2.7, but I think my most recent reinstallation of CF may have reinstalled MDAC 2.0 (but reinstalling 2.7 doesn't change the situation) CF 4.01 This is the error message I get in Windows Events: The SiteMinder Authentication Service service failed to start due to the following error: The system cannot find the file specified. Authorization Service is not running either. It displays: The SiteMinder Authorization Service service failed to start due to the following error: The system cannot find the file specified. For both, Windows displays Event ID: 7000 My choices are to call Microsoft ($$), call Macromedia ($$), or take my computer to a local repair shop ($$). Thanks for any help you can provide. John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with Studio
Michael, I installed DW 4 Ultra Dev sometime back, but it didn't hurt anything. I have uninstalled it, and I've uninstalled and reinstalled CF Server and CF Studio a couple of times. I did some diagnostics and discovered some registry errors related, I think, to MDAC, which I fixed with Norton Systemworks. I reinstalled MDAC from the CF folder. I seem to recall an MDAC patch from Microsoft, but after searching their site, I can't figure out what it might have been. All of my applications work fine, including queries. But still, every time I touch Localhost in Studio's Database tab, I get the error, The connection to the server cannot be established. And whenever I click refresh on the rds://localhost server in the Remote Servers tab, I get the error, The system cannot find the file specified. Much of my searching in CF help leads me into server security issues. It might be worth noting that I can't follow some of the recommendations, because I don't have Advanced Security available to me within CF Administrator. Still hoping, John Michael Greenberg wrote: John, Did you happen to install DWMX ? I had this happen when I upgraded to DWMX, my CF Studio 5 was completely hosed. I just uninstalled and reinstalled and everything has worked swell since. Thanks, Michael - Original Message - From: John Allred [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 9:44 PM Subject: Problem with Studio This is probably a shot in the dark, but maybe someone can steer me in the right direction. My Studio 4.01 has been humming happily for a long time. But, sometime in the last few days I've lost access to the database viewer on localhost. When I try to view my tables, I get the message, The connection to the server cannot be established. I can't find anything in the help docs. Everything in IIS appears to be working. Plus, the CF server displays my site through the browser just fine. Don't know if I'm giving all the relevant information, but I sure could use an educated guess on where to look for the problem. Thanks, John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Problem with Studio
This is probably a shot in the dark, but maybe someone can steer me in the right direction. My Studio 4.01 has been humming happily for a long time. But, sometime in the last few days I've lost access to the database viewer on localhost. When I try to view my tables, I get the message, The connection to the server cannot be established. I can't find anything in the help docs. Everything in IIS appears to be working. Plus, the CF server displays my site through the browser just fine. Don't know if I'm giving all the relevant information, but I sure could use an educated guess on where to look for the problem. Thanks, John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: death of coldfusion
Mark Smeets wrote: Macromedia isn't incorporating CF into Dreamweaver for the past 2 version for nothing. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: death of coldfusion
Matt Brown wrote: It also creates a perception that your software has no value, if you give it away for free you can't charge for it later. Corel used to do this. It is good to ask these things and to think out of the box, but this isn't the way. I like the idea of being able to buy features as you go. That is really cool. I don't know if there is any research on that, but it might be worth looking at. Matt, since you mentioned Corel's failed approach to keeping older versions available, I might mention something in the Corel vs. Quark area. Corel Ventura Publisher users are similar to CF users (except that their installed base is so painfully small). They feel, almost without excpetion, that they use the best product and know all the hype from the other guys is BS. Numerous feature comparisons have been made between Ventura and Quark Xpress (page layout apps, for those who don't know). Quark offers Xtensions to its base product, and developers create and market these add-ons. Corel includes all fuctionality in the product with no extra add-ons, except for VB scripting. To get the same functionality from Quark that you get out-of-the-box with Ventura Publisher, you have to pay, literally, thousands of dollars. I think add-ons are a poor idea--they allow a manufacturer to make a stripped down product and leave important functionality to independent __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Listcontains question
Carlo, Try adding the delimiter: listcontains(newlist, #pageid#, ,) van Wyk, Carlo wrote: Hi I have the following piece of code that checks to see if a user can see a specific pageid or not. Unfortunately it is not doing the job as I have a list that looks something like this: 4,14,3,2,8,44 If the user is allowed to see page 4, then he would be able to see all pages that contains a 4, so it does not work correctly. cfif listcontains(newlist, #pageid#) cfinclude template=#page# cfelse cfoutput #application.securityerror# /cfoutput /cfif Regards Carlo FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Index of array
Jeffry, Thanks. The idea was to create Next Record and Previous Record buttons on my page. Perhaps it would be simpler to find the next alphabetical element, but I just couldn't see it. I was thinking was that, if my current record's index was 5, I could get the next record by simply adding 1 and the previous record by subtracting 1, since the array positions would be numbered sequentially. Maybe there's a common way of doing this that I haven't come across yet. Regards, --John Jeffry Houser wrote: At 03:53 PM 09/09/2001 -0500, you wrote: Is there a way to compare the content of a variable with the members of an array to get the index position of the corresponding array element? Maybe there's a better way to do this, but this seems like the right direction. What I have is a query with two columns, one alpha and one numeric (created as an autonumber). For instance, my query would return something like: ID NAME 33 A Better Way Carpet Cleaning 12 Dynamic Accountants Notice that the ID numbers are not in ascending order and have gaps between them. The array would have these two elements in alpha order by NAME. Is there a way to compare my current URL.ID of 33 to this array, return 0, to which I could add 1 to get the value, 12, from the next element in the array? I'm not quite sure what you want to do. Either it's very complex and I'm completely or it is very simple and you just got blind-sided looking for the obvious. A query returns an array of structures, but why can you not loop over the query using either CFLOOP or CFOUTPUT? CFOUTPUT queryname = myquery #myquery.ID# #myquery.name# /CFOUTPUT And it should give you the output you desire no matter what order the IDs are returned in. I may note that the index of the array in a query object has nothing to do any numerical fields returned by the query, they are sequential. So, I suppose if you really wanted to (I don't see a point) you could do something like this: CFLOOP index=temp from=1 to=arraylen(myquery) myquery[temp].ID, myquery[temp].name /CFLOOP ( I doubt the code above would work without some massaging, I'm writing from memory ) ??? -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- I'm looking for a room-mate in the Hartford CT area, starting in September -- http://www.instantcoldfusion.com | My Book: Instant ColdFusion 5.0 -- My Band: Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- My company: DotComIt, LLC database driven web data using ColdFusion -- ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Index of array
Is there a way to compare the content of a variable with the members of an array to get the index position of the corresponding array element? Maybe there's a better way to do this, but this seems like the right direction. What I have is a query with two columns, one alpha and one numeric (created as an autonumber). For instance, my query would return something like: ID NAME 33 A Better Way Carpet Cleaning 12 Dynamic Accountants Notice that the ID numbers are not in ascending order and have gaps between them. The array would have these two elements in alpha order by NAME. Is there a way to compare my current URL.ID of 33 to this array, return 0, to which I could add 1 to get the value, 12, from the next element in the array? I'm wearing out CFWACK and Mastering, as well as the online help. Thanks, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
E-commerce question
With no experience with shopping carts, SSL certificates and gateways, I don't have an answer to my banker, who asks if my software is Global Payment Systems (NDC) approved. I don't recall a discussion on this list where this was mentioned. Can anyone help me with the terminology I need to speak with him about this, or point me to a URL that has explanations that are relatively simple and straightforward? In particular, I'm not sure what he is specifically referring to by my software. CF, SSL, or what? This is a smaller, regional bank, so maybe you could prompt me with the questions I ought to be asking him. I'm currently dealing with CFHosting.com and Advances.com, if anyone has specific insights, based on these ISPs, although I'm not opposed to hosting with another, if they make the process easier to set up. Thanks, John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: http server for windoz ME?
I'd be interested to know if another server could be installed, but I know it's not possible to install PWS on ME. If you do decide to get another OS, note that there are certain MS OSes that you can't upgrade to from ME. Check the documentation. If you opt for Win2000 (which includes IIS and PWS), you'll need the full package, not an upgrade. Jeffry Houser wrote: Apache. Or isn't there a version of PWS on ME? At 05:06 PM 07/21/2001 -0700, you wrote: My new notebook came with m$ ME. I was trying to install IBM's http server, but it didn't install (said I needed NT4). Is there any free http server to help develop CF while on the run with a ME notebook? TIA, laszlo If it's too OT, please reply to: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AW: OT: http server for windoz ME?
While, on the surface, ME is the successor to 98, there are significant differences. There is a lot of functionality present in 98 that is simply missing in ME. The key word, which you used, is consumer. I think Dell, Gateway, and others, should drop their ME-only option and recognize that they have web professionals among their clientele. [EMAIL PROTECTED] wrote: Since ME is the following consumer-OS after Win98 I would wonder, that PWS wouldn't work. Under Win98 you could use PWS. Uwe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AW: OT: http server for windoz ME?
I like what you have to say better than what Microsoft told me. Could have saved $200, too. Thanks for the note. BTW, did you also find a way to run a DOS window? C. Hatton Humphrey wrote: I have installed PWS and have it running on an ME box right now! In this instance, treat your machine as a Windows 98 machine and go from there. Or you could go with Apache for Windows. HTH Hatton Humphrey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query of a Query
In the second query, don't include datasource, but do include 'dbType=query' The name should be the same as in the first query. HTH, --John Jordan Saardchit wrote: Can someone please send me the syntax on using QoQ. I can't remember the CFQUERY sytnax to reference a result set already in memory. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Db to web: Replacing odd ascii characters in db to web
Paul, You don't say whether the folks performing this task are using Quark (and cutting directly from it) or whether they are using linked text files outside of Quark. You might want to back up a step, if you still have access to Quark, and export the text as text. This will strip out all, or at least most, formatting. I've used this feature in Ventura Publisher for years. I'm not sure whether Quark allows it, but most DTP packages copy many of Ventura's features, so it should be available. If plain text export is not available, another format, like RTF, will be. Export as HTML would get you close, also. --John Paul Sinclair [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] crest.com cc: Subject: Db to web: Replacing odd ascii characters in 04/24/2001 03:33 db to web PM Please respond to cf-talk I'm managing a site where articles from a magazine are being cut and pasted into a text entry field. The people doing the actual cut and paste routine are starting from a Quark file. When they cut the text out of Quark and into the db, it is putting in all sorts of strange characters - probably high ascii characters. When a dynamically created cfm page drawing its content from the database is displayed, it puts all sorts of heiroglyphics in the output. For example, apostrophes and emdashes show up as a hollow square - that sort of thing. I've tried to do a replace function on the article's body and by and large it works. But I don't have any way of knowing what kind of odd characters are going to be in the database so I can't anticipate every odd character. Is there some way to handle this type problem? Thanks for any suggestions/solutions. Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF still relevant?
Joe said: If you're calling the better-suited things in as a CF object (e.g. Java, COM, MSXML) to do things, then why not just use those technologies (or families of technologies) and skip the CF entirely? I'm not sure I follow this. To use JAVA, COM, or any of these other techologies on a web site, you have to call them from another technology that actually communicates with the browser. This is part of what CF, ASP, JSP, and PHP do. Where is the distinction? --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
Robert, Customers, without enough information, draw their own conclusions about the cause of downtime. I don't know what you do, but CFHosting shows the courtesy of sending out announcements following outages to explain why they happened. When I know some yo-yo in downtown Atlanta cut a fiber optic line, I tend not to be irritated with CFHosting. It's not a bad strategy. While your servers may be up 99.7% of the time, other factors cause downtime, too. Sending accurate information to customers should lessen the griping. Regards, --John net_man@minds pring.comTo: CF-Talk [EMAIL PROTECTED] cc: 04/06/2001Subject: Re: Hosting recommendations 07:52 AM Please respond to cf-talk Since my last flaming for posting about my service. I have tried to resist, but I have to take offense to the statement of being down more then the average ISP. As with all we are at the mercy of the internet in general, but we strive to keep our uptime at 99.7% or greater and have the numbers and stats to prove it. I constantly have my servers and sites monitored from 3 diverse links inbound and would be happy to look into any specific incidents people have had. Sorry for the post, but when someone strikes a cord, I will take the abuse from the flamers. Thanks, Robert - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:40 AM Subject: Re: Hosting recommendations Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
I, for one, would love to see more support for Simple Message Board. Tony put a huge amount of effort into the admin of the application, and it paid off. I was able to quickly see which features needed modification, I set up my headers and footers, and I was up and running in short order. There were a couple of modules not yet complete when I downloaded it. It would be great to get them all operational. --John "Benjamin S. Rogers" wrote: Not to discourage you from starting an open source project, but there are already several in the works. Allaire Forums was open sourced and can be found at http://www.forumspot.org. There is also Simple Message Board, which can be found at http://www.simplemessageboard.com/. You may want to investigate these products and consider throwing your effort at one of these products instead of starting a new one. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
zac, I'm not sure, but you may be over-thinking this. Tony's application is simple enough without Fusebox. Coding it in that methodology, believe it or not, would make it even easier for you to modify or troubleshoot, even with no prior exposure to Fusebox. Fusebox is still CFML, after all. If he breaks it out in a consistent manner, the files will be shorter, and the program flow will be more logical and easier to follow. The only differences that might throw you into unfamiliar territory will lie in some of the application-level files. --John zac wrote: Tony Schreiber wrote: But I would be interested in hearing what you don't like about the idea... My original reaction was similar if not a bit more restrained. My concern is that I don't use fusebox myself and I think that this would limit the usability of SMB because if my lack of familiarity with it. If I use fusebox and SMB doesn't then is implementing SMB into a fusebox site as difficult as implementing a fusebox based SMB into a non-fusebox site? I don't use fusebox. I don't have any plans to learn it and I think that my plans to utilise SMB will therefore stop dead because I don't want to have to learn a development methodology on top of learning to navigate through a new codebase. -- Remember, what we do here might seem like criminal fraud but its not. Its marketing! Scott Adams email: [EMAIL PROTECTED] WWW: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Convert string to numeric
I haven't been able to find a function that will convert a string (containing only digits) to a number. Can anyone advise how to do this? TIA, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert string to numeric
Solved. It's surprising how often just asking the question allows one to arrive at the answer. --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Populate array with query
Thanks to all who responded. Kevin and Bryan suggested using sum(queryColumn) as xxx. However, I wanted to use this as an opportunity to explore arrays, which I had not previously felt the need to use. I found what I needed in ValueList and ListToArray. Three lines gives me the desired results: cfset HoursArray = ListToArray(ValueList(getMainList.hours)) cfset TotalHours = ArraySum(HoursArray) cfset Cost = TotalHours*65 Regards, --John Bryan Love BLove@xypoinTo: CF-Talk [EMAIL PROTECTED] t.com cc: Subject: RE: Populate array with query 03/01/2001 04:23 PM Please respond to cf-talk best to do math in the SQL of the query itself (if you are running a query): SELECT sum(hours) AS totalHours, sum(hours * 65) AS totalCost FROM hoursTable WHERE bla = bla CF is extremely slow compared to enterprise level databases such as SQL Server 7 and Oracle. If you insist on using CF, however, do this: cfset totalHours = arraySum(getHours) cfset cost = totalHours*65 CFOUTPUT PThe sum of the numbers is #totalHours# hours. At $65/hr, this equals #dollarformat(cost)# /CFOUTPUT Just leave the the ArraySum function out of the CFOUTPUT tags and you won't get the YES output Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 1:58 PM To: CF-Talk Subject: Populate array with query Hi, Can someone suggest a better way to sum a numeric column in a query? The solution is probably painfully simple, but I've been struggling for an hour or two on it (only have online docs available). CFOUTPUT#ArrayDeleteAt(GetHours,1)#/CFOUTPUT CFLOOP query="getMainList" CFOUTPUT#ArrayAppend(GetHours, "#numberformat(hours)#")#/CFOUTPUT /CFLOOP Line 3 produces a string of "YES"s at the top of my output- one for every record in the query. The following gives me the result I need, but I can't get around the display of the YES's that appears. cfset cost = ArraySum(GetHours)*65 CFOUTPUT PThe sum of the numbers is #ArraySum(GetHours)# hours. At $65/hr, this equals #dollarformat(cost)# /CFOUTPUT TIA, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Populate array with query
Hi, Can someone suggest a better way to sum a numeric column in a query? The solution is probably painfully simple, but I've been struggling for an hour or two on it (only have online docs available). CFOUTPUT#ArrayDeleteAt(GetHours,1)#/CFOUTPUT CFLOOP query="getMainList" CFOUTPUT#ArrayAppend(GetHours, "#numberformat(hours)#")#/CFOUTPUT /CFLOOP Line 3 produces a string of "YES"s at the top of my output- one for every record in the query. The following gives me the result I need, but I can't get around the display of the YES's that appears. cfset cost = ArraySum(GetHours)*65 CFOUTPUT PThe sum of the numbers is #ArraySum(GetHours)# hours. At $65/hr, this equals #dollarformat(cost)# /CFOUTPUT TIA, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic group in output query
I had a group column set dynamically for an output query, based on whether a form variable was passed into the template, as follows: cfif parameterexists(icat) cfset queryGroup = 'ItemCategory' cfelse cfset queryGroup = 'Category' /cfif The variable, "queryGroup," is used in the output query, as: cfoutput query="getMainList" group=#queryGroup# , and this works fine. Now, I have a situation where, if I pass in another form variable, I don't want grouping, so I need to include the whole grouping string, instead of just variable for which column to use. The following works in a CFOUTPUT, but not in a CFOUTPUT QUERY: cfset queryGroup = 'group="ItemCategory"' cfoutput#queryGroup#/cfoutput I've tried all sorts of variations on: cfoutput query="getMainList" #queryGroup#, but I get an "Invalid token" error as soon as I get to a # or (as in a CFIF at this position). Any suggestions? I suppose I could use a CFIF statement and have two versions of the CFOUTPUT, but I'd rather have dynamic text within one. TIA, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: advanced list
Douglas, If I understand the intent of your original question, I would recommend the list that ACFUG (Atlanta CFUG) hosts: http://www.acfug.org/ -- Very little chit chat and the questions are generally more advanced. Regards, --John [EMAIL PROTECTED] wrote: My apologies to the list and for starting a thread that went way too long. The intent of my question concerning other more advanced list-servs for CF stuff was not to slight anyone on this list. This list is quite useful, helpful, and attended by some very knowledgeable people. I was just looking for something with a bit less volume of questions pertaining to topics that can be answered by reading first. Again, this is not to slight those that ask nor to discourage anyone from posting nor is it an invitation for flaming. Again, my apologies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Threaded Discussion App with Tree view...??
Tony Schreiber wrote: This isn't it, but Simple Message Board has a Tree View option and is free. He forgot to mention that it's both powerful and relatively easy to configure. http://www.simplemessageboard.com/ --John Tony SchreiberTo: CF-Talk [EMAIL PROTECTED] dune@technoccc: raft.comSubject: Re: Threaded Discussion App with Tree view...?? 02/22/2001 06:40 AM Please respond to cf-talk This isn't it, but Simple Message Board has a Tree View option and is free. A year or so back, I ran across a CF app for building multiple threaded discussions. I seem to recall that you couldn't download a demo, and you couldn't buy it with credit card over the net (around $US100, I think). However, it looked fantastic, showed full tree views of threads, included IE-popups of message content when you point at the message title, pretty colors, etc. It claimed to handle the whole thing in a single Custom Tag. Does anyone recall this product, and where I can find it? I have searched the Allaire Dev Gallery, but I can't find anything like it. there are plenty of discussion apps, but none as elegant as this one. Thanks very much, Lee Bjork Borkman http://Bjork.net - ColdFusion Tags by Bjork IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Visibone color-safe palettes
Just a note to alert you to downloadable color swatches for HomeSite. http://www.visibone.com/swatches/ Just download to the palettes directory, and they're immediately available. Of course, although they only indicate downloads for HomeSite, you can download to your Studio palettes directory. --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SimpleMessageBoard now available
Other than installing CFX_Make_Tree, if I need it, does my ISP have to do anything to allow or enable this application? --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Connecting to Lotus Notes
Neil H. wrote: Long time ago I tried this. There was a little Notes ODBC connector and I could read data. Had a hell of time writing data into a DB but given enough time you can probably figure it out. I haven't tried this ODBC connector, but I have used Notes. The structure of a Notes database can be changed very easily. The best way I've been able to visualize it is as a Lotus spreadsheet on steroids. You may encounter difficulties if others have access to the Notes DB you want to exchange data with, so if you establish the connection, you may want to take steps to keep it out of reach of other developers. --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dave's Burning Rant (WAS: virus comments)
Dave, I can't argue that people want "openness" on their desktops, but I'm not sure I can go along with the notion that they're willing to sacrifice security. As one who lost over 700 files on my desktop to the Melissa virus (through no fault of my own), I for one want security. I really don't care what other users on my network want if, through carelessness, they are willing to risk my work. My time and my files are more valuable to me than other's convenience. What people want is not necessarily what they should be given. In other words, what's popular is not always what's right. Regards, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Dave's Burning Rant, Part Deux
I'm sorry but James's "Ignorance is no excuse" argument is unimpressive. If I had bought an early '70's Ford Pinto, I would never have considered anyone but Ford at fault for increasing the danger I faced on the highway, once I became aware of it. All the other factors would remain as constants. People ARE stupid, lazy, careless, impatient, gullible, etc. These traits WILL always be with us, and they WILL ALWAYS result in bad events. This is life, and there's no avoiding it. Accidents CAN be avoided, yet they still DO happen. James and others tend to put all the responsibility for avoiding virii off onto us, the end users of mail programs. If it gets into court, the standard to judge liability is what's commonly referred to as the "Reasonable Man" standard. What you're expecting of us is, I think, unreasonable. I just don't know anyone who can remain vigilant against some sort of attack 100% of the time. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Urgent - Forums 2.05 Anyone Got?
Rey, Got a URL for Forums 2.06? As usual, can't find what I'm looking for on Allaire's site. Thanks, --John "Rey Bango" rbango@accesTo: CF-Talk [EMAIL PROTECTED] spro.netcc: Subject: Re: Urgent - Forums 2.05 Anyone Got? 02/12/2001 10:48 AM Please respond to cf-talk Daryl, You should be able to use v2.06. There were some bug fixes but the DB structure stayed intact. Rey Bango Forums OpenSource Initiative Core Team www.ForumSpot.org - Original Message - From: "Daryl Fullerton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 12, 2001 10:05 AM Subject: Urgent - Forums 2.05 Anyone Got? One of Our Forums server died. Anyone got a copy of Allaire Forums 2.05 We have all the backups. Just need to install and copy files and databases. Anyone got a copy?? Appreciate any help. Cheers Daryl Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML/OS
There's glib, glad-handing, sales hype, and there's product knowledge. The two don't necessarily go together. --John "Dave Hannum" hannum@ohio.To: CF-Talk [EMAIL PROTECTED] edu cc: Subject: Re: HTML/OS 02/07/2001 11:43 AM Please respond to cf-talk They also say it won't run on Netscape Enterprise. Funny, I guess I've been just imagining that it runs on Enterprise like we have here. . . . . Also they must not know about Session and Application scope variables . . . Dave - Original Message - From: "dennis baldwin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 10:44 AM Subject: RE: HTML/OS this all sounds really hokey to me. you can't download a trial, you either view a demo or purchase. then it's all web based, what does that mean? i like how on the comparison page they say Cold Fusion won't run on IIS: http://www.aestiva.com/pages/htmlos/061481.7.18510733152 Dennis Baldwin ZAP Designs www.zapdesigns.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 7:13 AM To: CF-Talk Subject: HTML/OS Anyone know about ColdFusion users being wooed by HTML/OS http://biz.yahoo.com/bw/010205/ca_aestiva.html Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Politics RULE grrrrrrrrrrr
I don't think anyone covered the issue of responsibility. If I understand right, there are two contractors working independently. If they are competitors, how can one be turned into the traffic cop for both without some sort of contractual language to spell out the relationships, responsibilities, liabilities, and means of resolving conflicts, etc.? If this thing gets set up the way the other guy wants it, insist on a contract that will help everyone sort out the problems, once they (inevitably) happen. Without that, it will just be a shouting match, and the one who has the best connections within the organization will win. --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RFP for state portal
The State of Mississippi is soliciting bids for a state web portal infrastructure. I seriously urge any of the larger vendors to take a look at this and consider bidding on it. If accepted (one would hope, as a Cold Fusion site), you can anticipate that there would be a flood of additional projects from dozens of state agencies, since they're all looking to this portal project to provide direction for the use of web technology within state government. The state is trying to accomplish several things with this project, including central processing of credit cards for online payment of fees and sharing of public data across all agencies that need it. The people who prepared the RFP are very interested in JAVA technologies. Since much of our data resides on the state's mainframe, they would like to make that data accessible via the web. Of course, security is a top issue. The description for RFP 3205 can be found at ftp://www.its.state.ms.us/pub/issinfo/rfps/rfps.htm The RFP is linked from that page, but the direct link is ftp://www.its.state.ms.us/pub/issinfo/rfps/3205.htm There is a mandatory vendor conference in advance of the bids that will be held on February 7, 2001 in Jackson, Mississippi. If you don't attend, you won't be able to bid. You don't have to submit anything prior to the vendor conference, and you will have two days following this meeting to submit questions. Following that, bids will be due by March 2. If a Cold Fusion solution is implemented, guys, this would place CF at the center of our state government's web presence and could result in a lot of work for a number of CF shops for some time to come. The influence would likely ripple out to the web design firms in central Mississippi. PLEASE take a look. After you download the RFP and read it, if you have any questions, contact Wally DeRossette at [EMAIL PROTECTED] The project schedule is on page 25 of the RFP. I'm not directly involved with preparing the RFP or awarding the bid, but this process is handled here in my office, and I'm available to help you in any way I can. Feel free to contact me off list at [EMAIL PROTECTED] Regards, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 255 character max in Access ???
Philip, If I understand your statement correctly, I think I have to take issue. I have a newsletter app I've been working on where the following code works just fine (article_text is an Access memo field, and criteria is the form field): WHERE article_text LIKE '%#criteria#%' Maybe an exception to the rule? Regards, --John Philip Arnold - ASP wrote: Besides the indexing issue, are there any drawbacks to using the Memo type? They can't be used in a WHERE, you can only deal with them in the SELECT part of your SQL Once it's in CF, you can do whatever you want. -- Great minds discuss ideas; Average minds discuss events; Small minds discuss people. -- Eleanor Roosevelt ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 255 character max in Access ???
Philip, Don't know if you're over-tired, but this is definitely possible using both Access 97 (my version is 2-3 years old at least) and Access 2000. --John Philip Arnold - ASP wrote: If I understand your statement correctly, I think I have to take issue. I have a newsletter app I've been working on where the following code works just fine (article_text is an Access memo field, and criteria is the form field): WHERE article_text LIKE '%#criteria#%' Maybe an exception to the rule? Was this added in one of the MDAC updates? When I last used Access as an ODBC datasource (about 2 years or so ago) you couldn't do this, and you definitely can't do it (directly) with SQL Server... maybe in the updates they got around this problem... or am I just over-tired? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Great idea Adam! [Was: Re: Adam, you got to be kidding?
Can't help but do the math. 100,000 hits can't possibly be insignificant. [EMAIL PROTECTED] wrote: Please ... I just checked Webtrends for browser types hitting our site and 98% of all browsers are NN 4+ and IE 4+ ... with the over 60% being IE 5. With a sample of over 5 million hits. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF vs. Lotus Domino App Server
I had the, um, opportunity to work with Domino for a while. I probably wrecked my career with the reaction I had. In short, I found the IDE to be totally unintuitive and the output to be largely dependent on Javascript. Even if you don't write it, it will still appear in your pages. But there is no shortage of documentation. After I printed it all out, I had two feet of shelf space devoted to it. Lotus makes a good sales pitch. I'll leave it at that. Regards, John [EMAIL PROTECTED] wrote: Hi Chasmo, In my previous life as a Notes Administrator and database developer, I have worked with Domino web applications such as Domino.doc, Intranet Starter Pak, etc. What is nice about Domino is the security features. With Domino 5, you can now use RDBMS functionality which didn't exist prior to that. The downside of Domino is the maintenance and processing overhead. The skill set required for Notes/Domino is extensive and Notes/Domino administrators/developers are hard to find these days. Domino is a decaying technology which is why I got out. Good Luck John On Wed, 03 January 2001, "Chasmo" wrote: Hi All; I recently built a prototype B2B project-management app for a client in CF. He's now in his first round of funding and is getting all kinds of "suggestions," the most prominent being that the actual release be built with Domino App Server. Does anyone have any knowledge of how the two app servers compare, or possibly a good Web link on Domino's tech stuff? I checked with the standard Lotus sites, but only get the standard industry speak ("robust, extendable platform," "leverage your business" blah blah). Many thanks, Chasmo [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Who wants a CF-SQL Mailing List?
I'm with Nick. I don't see an advantage to separating SQL questions from other CF topics. I almost always read the SQL-related questions, and I learn from them, as I do from many other topics discussed on this list. One of the strengths of this community, IMO, is the breadth of knowledge of its members. I think divvying the posts up into little separate islands of interest will only serve to weaken the CF community. --John "DeVoil, Nick"To: CF-Talk [EMAIL PROTECTED] Nick.DeVoil@cc: bskyb.com Subject: RE: Who wants a CF-SQL Mailing List? 12/21/2000 09:48 AM Please respond to cf-talk I don't think SQL and Database questions are too welcome on this list. I must be kind of unobservant, I hadn't noticed that. Is that right? I mean, as you say, CF and databases are pretty inseparable. For me, two of the things that make this a great list are: 1. The breadth of subjects covered 2. The willingness of so many people to answer supposedly OT questions. Unlike some lists where people mentioning something OT always get flamed. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Setting up a poll database
I'm trying to create a poll. Since I want to use radio buttons on the form, I'm creating one field for each category of information that uses the numbers 1 through 5 to allow the user to make one selection only in each category. The problem I'm having is figuring out how I'm going to count the responses and display them. If each entry were in a different db field, I could do a count on each field and only use one SELECT query. But with different numbers in the same field, all I can think of is to use multiple queries with each one having its own WHERE clause. This seems like poor form. Does anyone have advice on how to proceed? If I get into thousands of responses, I don't want the queries to bog down. If you suggest structures, please assume I know nothing about them (which is true, BTW). TIA, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Setting up a poll database
John, Thanks for the quick reply. I can get this query working in the query builder, but I can't figure out how to display it. It looks like a structure. A little more help? Thanks, --John "John J. Kirker" wrote: Hi John, Here's some code a guy in our office gave me a while back for this: For example, if I was retrieving the responses from a Yes/No survey, I could run the following: SELECT column , Count(*) FROM table GROUP BY column The results could be: column --- Yes 432 No 165 Best, John -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 17, 2000 1:02 PM To: CF-Talk Subject: Setting up a poll database I'm trying to create a poll. Since I want to use radio buttons on the form, I'm creating one field for each category of information that uses the numbers 1 through 5 to allow the user to make one selection only in each category. The problem I'm having is figuring out how I'm going to count the responses and display them. If each entry were in a different db field, I could do a count on each field and only use one SELECT query. But with different numbers in the same field, all I can think of is to use multiple queries with each one having its own WHERE clause. This seems like poor form. Does anyone have advice on how to proceed? If I get into thousands of responses, I don't want the queries to bog down. If you suggest structures, please assume I know nothing about them (which is true, BTW). TIA, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE help
I'm not a newbie to CF, but I am to CFFILE. I have an idea how to take an existing template that queries for any of about 50 educational courses, and displays the course and section info for them, and create static HTML files instead. Any advice would be appreciated. category.cfm displays a list of all the courses. The links are displayed on the page as LIs with the course number passed to a second file used to display the course information-- course.cfm. course.cfm displays the actual information for each course offered, including section or meeting dates. Previously, I created a file, called course2htm.cfm that writes all the information for a course as I need the file to appear on the web (we don't have CF Server available to the world - so the files have to be non-CF), but I have to copy the html, and paste it into an html file. Multiply that by 50 or more, and it's not pretty. I'm thinking that I could use CFFILE either within the first file, category.cfm and create the html files when I click on the links, or I could use CFFILE within, or in conjunction with the second file, course2htm.cfm, to create the files I need. My CFWACK is at home, so all I have is the CFML Language Reference (eeeuuwww!). I may figure it out before a response comes back, but if anyone could offer some quick tips, I sure would appreciate it. TIA, --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: loops, queries, ug...
Pete, I think a simple group on the output is all you need. Query your tables (using, e.g., name = "get_subnets"), then on the output section, add a group parameter, as in: CFOUTPUT QUERY = "get_subnets" GROUP = "subnets" I'm assuming the value in "subnets" is the IP number. HTH, --John Peter Benoit pbenoit@triton-neTo: CF-Talk [EMAIL PROTECTED] twork.comcc: Subject: loops, queries, ug... 12/08/2000 09:22 AM Please respond to cf-talk I'm confused! I have 2 tables in the same database, one table has a list of subnets(subnets), and the other will contain information on each subnet(subnet_info). The subnet in the subnets table is the unique id in that table, which has a one to many relationship with the subnet in the subnet_info table. What I want to do is present a table that would present a subnet, then it's corresponinding IP's and Info, then repeat for each subnet. Something like: 208.208.208 IP = 1 Name = boxname Description = what this box does 208.208.209 ect... I'm not sure of the best method to do this. I tried building a query on the subnet table, then in the cfoutput of that query, loop through another query on the subnet_info table... but it doesn't work. Any ideas for me how to do this? TIA, Pete ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Big companies using CF
Not a big company, but a big site: http://www.mscounties.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is the Fusebox book available in stores or only at the fusionauth ority web site?
Michael, I couldn't find it on Amazon. Once you know it's there, be sure to let us know. I'd like to provide a couple of links to it. --John mdinowit@houseof fusion.com To: CF-Talk [EMAIL PROTECTED] (Michaelcc: Dinowitz) Subject: Re: Is the Fusebox book available in stores or only at the fusionauth ority web site? 12/04/2000 05:57 PM Please respond to cf-talk I know its at BN and should be at Amazon as well. Judith is speaking to a major distributor about it now and hopefully it'll get out in other places as well. Folks, The subject line says it all. I ask because I don't see it listed either at Amazon.com's website or at Softpro's. Thanks, -- Tim Dempsey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form and CFGRID on same page
Sorry for cross-posting. I should have sent this message only to CF-Talk. I want to include a CFGRID on the same page with a FORM. When the parent record is created, I would hide the grid, since it's designed for child records. However on updates to the form, I'd like to show the grid, allowing users to enter items that would be displayed on another page as a bulleted list. The page would query the parent table and populate the form on updates. The problem I anticipate is that by updating either the form OR the grid, I will destroy any changes made in the other. Has anyone tried to do something like this where they pass both sets of variables to a template that has the form update and cfgridupdate in a cftransaction? Given what I know, this seems pretty far-fetched, but I know I'm not the first to ever want to do this. Thanks, --John Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Remote DB Alteration
"Guy J. McDowell" To: CF-Talk [EMAIL PROTECTED] ofah_webmastercc: @ofah.org Subject: Remote DB Alteration 11/08/2000 10:14 AM Please respond to cf-talk Also, anyone know what the 20 or so CFML tags supported by CFExpress are? === CFABORT, CFAPPLICATION, CFBREAK, CFCOOKIE, CFIF/CFELSIF/CFELSE, CFINCLUDE, CFINSERT, CFLOCATION, CFLOOP, CFOUTPUT, CFPARAM, CFQUERY, CFSET, CFSETTING, CFSWITCH/CFCASE/CFDEFAULTCASE, CFUPDATE Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Potential problems with FREE Server
Josh, According to the docs that ship with CF Express, you get 16 Cold Fusion tags. They list 47 that are not available. Also, don't attempt to use custom tags (hence, Fusebox). So you lose most of the power of CF end up being able to create pretty basic templates only. HTH, --John "Josh R" jrblackstone@hoTo: CF-Talk [EMAIL PROTECTED] tmail.com cc: Subject: Potential problems with "FREE" Server 11/06/2000 04:47 PM Please respond to cf-talk I need some ammo here. I'm trying to convince our hoster to get something besides the "free" cf server. (Switching hosters is not an option, unfortunately, so I have to fight with them.) What potential problems can we expect if we run a site on the free server as opposed to the Pro server? I already know about the cfmail. (They want me to use FormMail.) What other problems should I bring up for reasons to upgrade the server? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Multi-table inserts updates
David, This sounds like what I'm after. But can you explain in a little more detail how you're handling the creation of the PK and FKs? Are you relying on the relationship between the tables set in the database? I'm close here. Maybe you can get me all the way home in one step. Thanks, --John David Shadovitz wrote: John, I agree with your concerns. In my Option 2, I pass the parent table info (not yet inserted into the db) to the 2nd page. I gather all of the child table info into a list for each field. Then I do all the inserts within a CFTRANSACTION: CFTRANSACTION CFQUERY to insert into parent table using FORM-scoped vars CFLOOP from 1 to length of list CFQUERY to insert into child table using ListGetAt(FORM-scoped list, index) /CFLOOP /CFTRANSACTION Let me know what you discover. -David On Fri, 27 Oct 2000 13:16:44 -0500 John Allred [EMAIL PROTECTED] writes: David, Thanks. I hadn't thought of your Option 2. I'm still thinking of a couple of other ways. The main thing with most obvious approaches is that the parent record has to be created first, then the children in subsequent steps. I guess what I was originally hoping for was something like entering parent and child info, saving the parent record and storing the child elements in an array or structure on one pass, then moving them to the child table in a second pass or upon Save Exit. Seems like this would insulate the user from the trips back and forth to the database to build up the parent and child records and behave more like non-web applications. Thanks for the suggestion. --John YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- John Allred / Jackson, Mississippi mailto:[EMAIL PROTECTED] -- "Wealth, like happiness, is never attained when sought after directly. It comes as a by-product of providing a useful service" -- Henry Ford -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Multi-table inserts updates
David, Thanks for the interest, but I suspect the solution you're heading towards would revolve around populating records in one table with multi-selects from another table. What I'm needing (or wanting) to do is enter multiple records in the child table where the input is text that the user types in. In case I'm wrong, the answer to your question is that the "nbrOrder" and "bullet" fields in the child table are simply text fields -- bullet is for the text to be entered, and nbrOrder is for the order the user wishes to establish for the resulting UL elements on the display template. Thanks, --John David ShadovitzTo: CF-Talk [EMAIL PROTECTED] dshadovi@juncc: o.com Subject: Re: Multi-table inserts updates 10/26/2000 01:04 AM Please respond to cf-talk John, I see that bullets is one of the child tables, and that its bid field provides the relationship to the parent table. Where do nbrOrder and bullet come from? Which field comes from the child table's input field on the entry template? I ask in order to see if my method would work for you. I have an entry template with a form containing several text input elements for parent table values, and a multiple-select element whose options each represent an entry in a child table. Upon submit I put the option values into a hidden element as a list. On the form's action page I insert a record into the parent table and then I loop over the list, doing an insert into the child table for each list item. It ain't easy to explain, but your answers to my questions at the top may make it more clear to us. -David On Wed, 25 Oct 2000 10:59:04 -0500 John Allred [EMAIL PROTECTED] writes: I need some advice on how to set up a form that will either insert or update data to multiple tables in the same database. I have a parent and two child tables in an Access database, and there is a one-to-many relationship established between the parent and each of the children. I'd like to keep this so I can cascade deletes, but if need be, I can work around it. At present, the FORM on my entry template includes only one INPUT field for one of the child tables. Using the following code in my action template, I can use one form to insert a record in both tables. CFINSERT dataSource="annc" tableName="vendor" formfields="vendor, imageName" cfquery datasource="annc" name="getID" select max(vid) as bid from vendor /cfquery cfquery datasource="annc" insert into bullets(bid, nbrOrder, bullet) values ('#getID.bid#', '#nbrOrder#', '#bullet#') /cfquery Ideally, I'd like to be able to enter any number of child records at the same time I create the parent record, using the same form. I'm thinking it might be possible to switch to CFFORM and include a CFGRID for the child tables. Has anyone done something like this? And could you offer advice on this or another approach. So far as I can find, CFWACK only has two paragraphs on entering data in multiple tables (p. 271 in the 2nd ed.). Thanks for any help. --John Allred YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusio
Re: Multi-table inserts updates
I forgot to mention, I'm developing this app on CF Express, so some of the more advanced tags might not be available. Thanks, --John Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Selects in CFGRID
I have four books open in front of me, and I've been searching for an answer all morning. Is there a way to insert values in a CFGRID field by selecting values from a column from another query? What I'm looking for is the same functionality as you'd get from an HTML SELECT field where you populate it with a query. Thanks, --John Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Selects in CFGRID
Aw, c'mon. Someone's bound to have some thoughts on this. Please? John Allred wrote: I have four books open in front of me, and I've been searching for an answer all morning. Is there a way to insert values in a CFGRID field by selecting values from a column from another query? What I'm looking for is the same functionality as you'd get from an HTML SELECT field where you populate it with a query. Thanks, --John Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- John Allred / Jackson, Mississippi mailto:[EMAIL PROTECTED] -- "Wealth, like happiness, is never attained when sought after directly. It comes as a by-product of providing a useful service" -- Henry Ford -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Selects in CFGRID
Simon, Yeah. Just like you would do with SELECT or CFSELECT, as in: SELECT NAME="DeptAbbrev" cfoutput query="departments" option value=#abbrev##trim(dept)#/option/cfoutput/select I can't find anything to indicate something like this is possible. I guess maybe the question is whether you can nest a SELECT field within a CFGRID. Thanks, --John Simon Horwith wrote: let me get this straight: you want to know how to create a CFGRID with one query, and populate some of it's cell values with results from another query? I'm just trying to make sure I understand the question, before I answer. ~Simon Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Selects in CFGRID
Thanks, guys. I kind of think someone missed the boat on this applet. Wouldn't it seem reasonable that, if you want to use a grid to insert/update/delete records, you might want to have it operate much like a FORM or CFFORM, using SELECT fields? Oh, well. Also, I may be missing it, but I can't find any way to apply edits to the fields or to format the data, like with numberformat or dateformat. Without all this functionality, seems like you have a merely pretty table that encourages the insertion of really sloppy data. Just my .02, and thanks again. --John Dave Watts wrote: Yeah. Just like you would do with SELECT or CFSELECT, as in: SELECT NAME="DeptAbbrev" cfoutput query="departments" option value=#abbrev##trim(dept)#/option/cfoutput/select I can't find anything to indicate something like this is possible. I guess maybe the question is whether you can nest a SELECT field within a CFGRID. Oh, you want to actually nest a select within a cfgrid? No, I do not believe you can do this. Possibly in a CFGRID that you are manually creating, rather than creating from a query. The Java applet used by CFGRID doesn't support this. I'd guess that there are third-party Java applets available that do, however. You could use one of those instead, but you'd have to populate the data with your own CFML code. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: AOL mayheim
Thanks for this insight, Simon. According to this logic, Cold Fusion would not be singled out by AOL. It would not be friendly to any server technology that presents dynamic pages based on database content, including ASP, PHP, and Domino. Can you or anyone else shed some light on just how far behind AOL's caching is? For instance, if I have info on a site that changes daily, how long will AOL users go between snapshots? This would help me explain to AOL users what they're not seeing. --John Simon Horwith shorwith@figTo: CF-Talk [EMAIL PROTECTED] leaf.comcc: Subject: RE: AOL mayheim 10/10/2000 01:51 PM Please respond to cf-talk I haven't been following this entire thread, but you've got to remember that for all intents and purposes, AOL is a cached intranet. AOL (or anyone else) cannot cache pages that are dynamically changing based on database content... or at the very least, they cannot keep very current copies of dynamic sites on their network.From AOL's standpoint, the statement that they are not "ColdFusion" friendly makes sense. ~Simon -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 10, 2000 2:34 PM To: CF-Talk Cc: [EMAIL PROTECTED] Subject: RE: AOL mayheim Hey Brian, For those of us (such as myself) who apparently need new glasses, could you help us out with a link to that info you're talking about? ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Brian bouldernet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 10, 2000 6:58 AM To: CF-Talk Subject: AOL mayheim You cannot email AOL using Cold Fusion Application Server... The default serverid, You must change it.. Also it transforms all likes like Hotmail to single quote instead of doublequotes - Original Message - From: Ryan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 10, 2000 7:15 AM Subject: Re: CGI Referrer variable stream and AOL crap. Read up on all the crappy changes like blocked Cold Fusion Application server, and all that... http://webmaster.info.aol.com/ I couldn't find anything here about blocked cold fusion... And I tried searching for 'cold fusion', 'cold', and 'fusion' and still found nothing... If AOL is blocking cfm pages somehow please tell me about it. RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: # sign in my string!
Scott, Try Replace(form.salaryreq, #, ## , ALL) to escape the pound sign. HTH, --John Scott Becker SBecker@ConnecTo: CF-Talk [EMAIL PROTECTED] tWise.com cc: Subject: # sign in my string! 10/10/2000 08:26 AM Please respond to cf-talk This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C032BD.C4B88700 Content-Type: text/plain; charset="iso-8859-1" All, Heres another stumper... CFSET salreq = "#IIf(len(form.salaryreq), DE(form.salaryreq), DE("None Listed"))#" If there is a # sign in form.salaryreq, this blows up... How would I get around this? I've tried various combinations of quotes... I know why this blows up, but I dont know how to get around this? argh! :) Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com --_=_NextPart_001_01C032BD.C4B88700 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLE# sign in my string!/TITLE /HEAD BODY PFONT SIZE=3D2All,/FONT /P PFONT SIZE=3D2Heres another stumper.../FONT BRFONT SIZE=3D2lt;CFSET salreq =3D quot;#IIf(len(form.salaryreq), = DE(form.salaryreq), DE(quot;None Listedquot;))#quot;gt;/FONT /P PFONT SIZE=3D2If there is a # sign in form.salaryreq, this blows = up... How would I get around this?/FONT BRFONT SIZE=3D2I've tried various combinations of quotes... I know = why this blows up, but I dont know how to get around this? argh! = :)/FONT /P PFONT SIZE=3D2Scott Becker/FONT BRFONT SIZE=3D2Web Developer : ConnectWise, Inc./FONT BRFONT SIZE=3D2www.ConnectWise.com/FONT /P /BODY /HTML --_=_NextPart_001_01C032BD.C4B88700-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Making Check Box Selection Mandetory
Claude, Brian and David have suggested client-side approaches, but you can also make a checkbox field required, using server side validation. Just set it up with a hidden field in the format, your_checkbox_field_required, the same as your other required fields. Be sure not to preselect any of the checkboxes, or you'll defeat the validation. --John "AustralianAccommodation.com Pty. Ltd." To: CF-Talk [EMAIL PROTECTED] director@AustralianAccommodcc: ation.com Subject: Making Check Box Selection Mandetory 10/10/2000 09:27 AM Please respond to cf-talk Using forms placing "required" and "message" inside the input tag allows you to ensure that the user enters input in order for the form to be submitted is it possible to have the same functionality over check box input when there are several check boxes to select from for the one input variable without any initially being checked and that unless the user checks one of the them the form will not be submitted I look forward to your comments Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Displaying CF code
I have some CF templates on an intranet for which I'd like to display the code in the user's browser. I find myself without my printed manuals, and I can't seem to find what I'm looking for in the online help. Can someone recommend a method I can use to include and transform the code from a CF template in another template and have it display but not execute? I fear I'm not making this very clear. What I want to do is have my main template, that is including a file based on a CFSWITCH on a variable, either include a file and execute it or pull that same file in and display the code only by replacing the left brackets with amp;lt; . TIA, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF, PHP vs. JSP?
Steven, If the client has a thoroughly thought out plan, and JSP fits well with that plan, then he/she probably does know what they want. Otherwise, it's probably the equivalent of a beauty contest. In that case, their decision would be based on less quantifiable or definable issues. If they are only "leaning," then it might be good to give them the alternatives with dollar estimates. It's going to cost the client more money or less money, depending on which route they take. Someone else might be able to do a JSP site for less than you could do it using CF. Or maybe you can save them a lot of money and provide other benefits they hadn't considered before. Unless the client is as technically savvy as you, side by side comparisons are of little use, IMO. They're still going to decide the issue on the same criteria they would have used otherwise. If you can discover those criteria, you can help them decide what is most beneficial to them. HTH, --John Steven Katz steven@idma.To: CF-Talk [EMAIL PROTECTED] com cc: Subject: CF, PHP vs. JSP? 09/26/2000 11:10 AM Please respond to cf-talk Hi, I'm developing a site that will eventually involve some dynamic components. I intended to use CF or PHP, but the client is leaning towards JSP. In what scenario would this be a better option? Any famous lists of pros and cons out there? Thanks. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [CF-Talk] OT: Subject lines
I'm afraid I missed any early complaints or discussions that caused Michael to feel we needed [CF-Talk] in the subject line at all. I use a Notes Client at work, so I have no sorting capabilities there at all and p--s poor filtering. I use Netscape at home, and my filters work fine on the To: and CC: lines. For me the [CF-Talk] is just unnecessary clutter, whether it's at the beginning or the end of the line. I would mention that it messes up sorting messages unless it's used absolutely consistently. Sometimes at the front and sometimes at the end causes a sort on Subject to fail. I don't bother with threading at all, since it tends to work poorly in my clients. If the issue is up for a vote, I vote an emphatic no. just my .02c Regards, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [CF-Talk] OT: Subject lines
Tom, I beg to differ, just slightly. Except for sorting by To: and CC:, I don't see anything you mention that Netscape Mail can't do. Maybe if I'd been able to sort on those two fields before now, I might see some advantage to it. Other than that, I have folders and filters for everything, and I can sort and search every other field in a message. I wouldn't mention it except that you seem to indicate NS has limited functionality. Using it, I can filter all my lists, and zip through 500 messages or more in a very short while. I'm in full agreement on Notes client. The same batch of mail in Notes takes nearly 10 times as long (that's no exageration). The folks who designed it obviously never received more than 25 messages in a day or created more than three mail folders. --John tom muck tommuck@basic-druTo: CF-Talk [EMAIL PROTECTED] mbeat.comcc: Subject: Re: [CF-Talk] OT: Subject lines 09/21/2000 09:05 AM Please respond to cf-talk Consider switching to Outlook express. It lets you create folders and sort by from, to, cc, subject or body. Plus, it allows you to find things within folders by from, to, cc, subject or body, so if you want to search for "CFMAIL", for instance, it will find all messages that contain CFMAIL in the body or subject. Quite handy, not to mention the organization of having separate folders for each mailing list. I tried Netscape briefly, and couldn't see any advantage. Lotus notes has horrible email formatting. tom - Original Message - From: "John Allred" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 21, 2000 8:41 AM Subject: Re: [CF-Talk] OT: Subject lines I'm afraid I missed any early complaints or discussions that caused Michael to feel we needed [CF-Talk] in the subject line at all. I use a Notes Client at work, so I have no sorting capabilities there at all and p--s poor filtering. I use Netscape at home, and my filters work fine on the To: and CC: lines. For me the [CF-Talk] is just unnecessary clutter, whether it's at the beginning or the end of the line. I would mention that it messes up sorting messages unless it's used absolutely consistently. Sometimes at the front and sometimes at the end causes a sort on Subject to fail. I don't bother with threading at all, since it tends to work poorly in my clients. If the issue is up for a vote, I vote an emphatic no. just my .02c Regards, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Extranet's
Rif, I'm not certain how you're using the term, "extranet." If you mean access by a limited number of people outside your firewall (not the whole world), then it's basically similar to your intranet with some extra security considerations. How much access you give the extranet users should probably depend on their relationship to your organization. What do you want them to know? What do you want them to be able to do? I'd recommend putting your extranet users in the same table with your employees. An extra column could differentiate between the two. Since they're coming in from outside, you might also want to provide logins for them. HTH, --John Allred Rif Kiamil wrote: Dear All, I am current designing our 2nd Intranet and we know it about a years time where are going to have Extranet users. I just want to know. Would u develop a total separate system for Extranet users or give then access to only parts of the Intranet? Any ideas about Security and database design e.g. We have a User Table and Employees table. Users are employees that have access to the intranet. Where would u put the extranet users in the users table and employees table or create there an extranet user table. Rif Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- John Allred / Jackson, Mississippi Accessibility Resources: HWG's AWARE site - http://aware.hwg.org/ W3C's WAI site - http://www.w3.org/WAI/ Campaign for a Non-Browser-Specific WWW - http://www.anybrowser.org/campaign/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ISP Recs
I know this pops up all the time, but I wonder if I couldn't get some recommendations on a good Cold Fusion ISP. The time has come for me to move on, and I'd like to hear from any of you who feel positive enough about your ISP to recommend them. Please respond off list, thanks. Criteria: Relatively inexpensive Full CF support and expertise Courteous in handling problems Little or no server down time Two pluses would be a) a host that caters to fusebox sites without charging for custom tag installation (or which allows user to install his/her own), and b) little or no charge for ODBC dsn setup, or facility to allow user to do it. Thanks, --John Allred -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problem with URLDecode
Terry, Try escaping the # symbol. It sounds like you have the entity reference stored in a text field in a database (not sure from your description of the problem). If so, write it as ##8482. HTH, --John Terry Stewart stew@stewnetTo: [EMAIL PROTECTED] .comcc: Subject: Problem with URLDecode 09/07/2000 10:48 AM Please respond to cf-talk Hello, Can anyone help me with this problem? I am trying to get a trademark character #8482; to translate back into its correct text. When I display it to screen before the CF Code that uses it in a query all works fine (except that in order to display it at this point put's it in the wrong place), however if I do the query before displaying it it won't work. I have put the URLDecode around it and it still stays encoded. It actually starts out as the characters, but being passed through Form Fields it gets translated to the encoded version (it is being passed around in the variable Criteria_#ThisRow#). Any ideas would very much be appreciated. Terry Stewart -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Inserting (or updating) more than one record at a time
Gina, I don't have a specific response to your question, only a suggestion. If your form fields correspond to columns in a table, you might find everything much easier to deal with if you modify the structure of your database. You have, essentially, these types of information: CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOURS1, FRIHOURS1,SATHOURS1. To get different ClientIDs, you change the "1" to a different number and add new columns to the table. What you might consider is breaking this up into at least two tables, one for the ClientID, and the second one for the tasks and hours associated with that ID. All of the fields in the second table can have the ending number dropped, then be combined into a single table with only 9 columns. The ClientID field would be the link back to your Client table. Doing this will shrink the size and complexity of your database, make it easier to add new ClientIDs, if needed, and make inserts, updates, and deletes, not to mention select queries, a snap to write. HTH, --John Gina Shillitani gshillitani@GeckoTo: "'[EMAIL PROTECTED]'" Media.com[EMAIL PROTECTED] cc: 09/05/2000 08:10 Subject: Inserting (or updating) more than one record AMat a time Please respond to cf-talk I have more than one set of fields to insert or update in a table. See below for the fields and sample data... can someone tell me the best way to insert or update multiple rows? Form Fields: FIELDNAMES=CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOUR S1,FRIHOURS1,SATHOURS1,CLIENTID2,TASKID2,SUNHOURS2,MONHOURS2,TUEHOURS2,WEDHO URS2,THUHOURS2,FRIHOURS2,SATHOURS2,CLIENTID3,TASKID3,SUNHOURS3,MONHOURS3,TUE HOURS3,WEDHOURS3,THUHOURS3,FRIHOURS3,SATHOURS3,CLIENTID4,TASKID4,SUNHOURS4,M ONHOURS4,TUEHOURS4,WEDHOURS4,THUHOURS4,FRIHOURS4,SATHOURS4,CLIENTID5,TASKID5 ,SUNHOURS5,MONHOURS5,TUEHOURS5,WEDHOURS5,THUHOURS5,FRIHOURS5,SATHOURS5,SUBMI T -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Has the Apocalypse cometh? (Was RE: CF vs. ASP)
Jeremy, Your rant produced a thought I hadn't had before. I wonder how competitive ASP would be vs. CF if it were not free, but instead offered at roughly the same price point? I just finished up a post to a thread on an HWG list that someone started by asking about free or low cost web/database solutions. There is a large community out there that is really into "free" and/or open source software. They sneer at companies that offer what they term "proprietary" solutions. All other things being equal, I can't imagine that nearly as many people would bother to learn and use ASP, if they had to pay for it. I'm kind of surprised that Allaire hasn't pushed their own free options more aggressively. It would be a serious coup, if they started offering Studio for free. I have no idea what their sales figures look like, but it would seem they make most of their money off of their enterprise class offerings and support subscriptions. Studio for free would certainly kick ASP's butt. Regards, --John ASP_RANT Microsoft is giving away ASP like they gave away Internet Explorer. IE, ASP+ .NET all of this is a part of Microsofts agenda to push them as a premiere devleoper of Applicaton servers provider tools and Applications Services through Microsoft. I truly believe giving away ASP does not hurt competition but if they make ASP+ a better tool and still give it away for free they are STLL practicing monopolistic tactics and I still truly believe even tho this is seemingly counterproductive at first that microsoft should be broken into at the very least Applications Company and Operating System Company. I just think it is highly un-fair of MS to be doing something like this. /ASP_RANT -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Second Request for help!
Neil, Too bad the beta testers didn't win out with this one. The inability to view multiple files is my only serious complaint with Studio. When the need to see two files simultaneously arises, I just fire up my old copy of Arachnophilia ( free download from http://www.arachnoid.com ), and I can view as many files at once as I want to, although more than four files starts to make each one more difficult to view, as the available window space for the application is divided among the open files. I'm sure other editors we've discussed in recent months will open multiple files, too, but this may be a quick solution to your problem. --John "Scott, Andrew" To: "'[EMAIL PROTECTED]'" scotta6@anz.[EMAIL PROTECTED] com cc: Subject: RE: Second Request for help! 08/22/2000 11:55 PM Please respond to cf-talk Yes that is a pain, however there are other ways to do this. When the feature split document was introduced we beta testers asked for the ability to split the pain and allow for 2 documents to be loaded. I am not sure if this request was ever made available to us, but it would be a nice thing to have added. regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: 23 August 2000 14:37 To: [EMAIL PROTECTED] Subject: Re: Second Request for help! Because CF Studio lacks the ability to resize the pane and make it a window within a window. Therefore you are unable to compare two files side by side. Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Cold Fusion Studio Question
Kim, You will not be able to view these files as CF-served pages, until you install the Cold Fusion Server that came with your copy of Studio. If you have a licensing problem, you can download a copy of Cold Fusion Express for free from the Allaire site and install it, instead. This might be a better approach if you want to set up your site on internal DNS, since people elsewhere in your organization could view and execute the files, also. The version packaged with Studio, although more powerful, can only be viewed by a single user. HTH, --John Kim Woodbridge woodbridge@emailTo: [EMAIL PROTECTED] .chop.edu cc: Subject: Newbie Cold Fusion Studio Question 08/23/2000 01:43 PM Please respond to cf-talk Hello, I am trying to set up Cold Fusion Studio in order to view and alter .cfm files created by our main IS department. I have set up the Developmental Mappings properly and have created a very simple file from an example in the Studio documentation. HTML HEAD TITLECall Department/TITLE /HEAD BODY STRONGCall Department/STRONG !--- Set all variables --- CFSET Department="Sales" CFSET City="Boston" CFSET Salary="11" !--- Display results --- CFOUTPUT I'd like to talk to someone in #Department# in #city# who earns at least #Salary#. /CFOUTPUT /BODY /HTML When I view this in my browser it shows #Department# etc. rather than filling in the variables. Does anyone know what I may have not configured properly or what I am missing here. I am not running Cold Fusion Server but am using the Microsoft Personal Server for Windows 95. Thanks in advance. Kim A. Woodbridge Web Developer Children's Hospital of Philadelphia 215-590-1197 [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Adobe sues Macromedia????
JustinMacCart hy To: [EMAIL PROTECTED] macarthy@iolcc: .ie Subject: Re: Adobe sues Macromedia 08/14/2000 11:58 AM Please respond to cf-talk They are suing over "tearable tabs" where you can click on a tab and drag it off the dialog it is on etc. Or you can drag it to CFSTUDIO too!! All Corel products have had this for years. Given the ubiquitous nature of tearoff tabs, I can't imagine how the yoyos at Adobe could hope to win such a suit. This looks to me like a ploy to slow down a progressive company by a not-so-progressive company. Two thumbs down. --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Database problems
I have a strange problem with inserts in an Access table. I can't seem to wrap either a CFINSERT or an SQL insert within a CFTRANSACTION. Either method, without a CFTRANSACTION, will successfully insert a record in my table. But as soon as I try to use CFTRANSACTION, so I can get the ID of the record just inserted and CFLOCATION to the entry form, all I do is increment the database ID, but don't insert any data. Can anyone hazard a guess what's causing this? I've read everything I can get my hands on, and I can't seem to figure it out. Thanks, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Insert produces blank record
Using an Access table, I have a template with an INSERT and a MAX(ID), plus a CFLOCATION routine within a CFTRANSACTION. I've tried it with both SQL INSERT and CFINSERT and, either way, the autonumber field is incremented, but no data is inserted in the record. If I use either insert method on its own, without a CFTRANSACTION, the record is inserted correctly. I wonder if someone could steer me to possible sources for this problem. With other databases, this method works fine using essentially the same code, so I'm wondering if there might be a setting in the database, itself, in the ODBC settings, or possibly in my APPLICATION.CFM (code below, if it helps). This has had me stymied for days. I would sure appreciate any direction you can give. Thanks --John APPLICATION.CFM cfapplication name="Employee" clientmanagement="Yes" sessionmanagement="Yes" sessiontimeout="#CreateTimeSpan(0,0,30,0)#" applicationtimeout="#CreateTimeSpan(0,0,30,0)#" setclientcookies="Yes" CFERROR TYPE="REQUEST" TEMPLATE="error_handler.cfm" MAILTO="[EMAIL PROTECTED]" !--- set datasource for this application --- CFSET dsn = 'empl_dbc' -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Database problems
Katrina Chapman To: [EMAIL PROTECTED] kchapman@volcc: t.com Subject: RE: Database problems 08/11/2000 11:45 AM Please respond to cf-talk Can we see some code? You may be nesting your tags incorrectly. --K Katrina, I think the code's fine, but here is the action template, anyway. Thanks, --John cftransaction cfquery datasource="county" insert into LINKS (APPROVE, TYPE_DESC, MAIN_NBR, LINK) values ('#form.APPROVE#', '#form.TYPE_DESC#', '#form.MAIN_NBR#', '#form.LINK#') /cfquery cfquery name="getid" datasource="county" select max(record) as newrecord from links /cfquery cfset record = #getid.newrecord# cflocation url="link_add.cfm" /cftransaction -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need your help desperately
Karl, I don't see a single specific question. All of them are of a general nature. I consider myself honest and would have no problem either asking or answering questions of this type. I don't know the whole context of this message, so I may have missed something, but based on the words alone, I hope someone will fill him in on what to expect, as long as they don't give him any of the questions asked. Regards, --John Karl Simanonok karl@advantasoluTo: "[EMAIL PROTECTED]" tions.com [EMAIL PROTECTED] cc: 08/11/2000 12:11 Subject: Re: Need your help desperately PM Please respond to cf-talk Hey, check this out! This guy is now Spamming people and trying to make himself not look like such a blatant cheater any more. He must read CF-Talk! dilip jumani wrote: Hi. I hope you are fine and enjoying best of your health. I request you to please share your experience of Cold Fusion exam. How is the exam? What kind of questions are being asked? Are there only radio buttons or check boxes, in the answers? Is it too tough? Please share your views. It will be very much helpful to me. Thanks in advance. Dilip __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
File name with query string in JS function
This is a variation on the recent thread where we discussed using link references like page.cfm?foo=bar#spot. In a framed environment, I have four JS functions that use rollovers to populate another frame using syntax like: function loadfn() { parent.empl_list.location = "alpha_fn.cfm"; I've put the functionality of all four templates I call like this into one template. The new syntax should look like: function loadfn() { parent.empl_list.location = "employee_list.cfm?sort=firstname"; The error description follows: Error in expression: url.sort = "thumbnail" Invalid conditional expression. Perhaps you are using = instead of EQ or IS to compare values. The error occurred while processing an element with a general identifier of (CFIF), occupying document position (2:1) to (2:29). The correct template gets called, but when the first line, which reads, "cfif url.sort = "thumbnail"" is reached, the error occurs. Any suggestions on how to code the javascript to pass the URL.SORT variable properly? I've tried several variations, with no luck. I've tried escaping both the question mark and equal sign, with the same results. Thanks, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Inserts and updates strategy
I have a form that needs to insert and then update values in two tables. I have the insert part, but I'm not sure how to handle the updates. During the insert, the user enters info about a URL link in the LINKS table. There is a drop down list which allows the user to select multiple counties. Selected values will be entered in successive records in a COUNTIES table, linked to the first table on the URL field. For the update, I call the form again and populate the fields with the values previously entered in both tables. The question is, if the user wants to make different selections in the drop down list, how to I make the needed changes to the COUNTIES table? In the first pass (insert), the values "1" "3" and "5" get entered. During the update, I want to remove "1" and "3", and add "2" and "4", so that I end up with only 2,4 and 5 in table. I'm thinking it might be best, during an update to COUNTIES, to delete all records related to this URL first, then insert the newly selected values. Does this seem like the right approach? Or would I be better off simply storing this list in a single field in the LINKS table and dropping the COUNTIES table altogether, since it only contains the FK and an ID field? Part of the consideration is that I want to show the ID values as preselected in the drop down list during the update. I should mention that the drop down contains a total of 82 values (populated using another query), and there might be, say, 3 values preselected. Thanks so much... --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Append a single character at the end of a form input value???
Philip Arnold - ASPTo: [EMAIL PROTECTED] pra@aspmediacc: .co.uk Subject: RE: Append a single character at the end of a form input value??? 08/10/2000 10:25 AM Please respond to cf-talk someone can correct the positioning of the # and # etc...but you see what I'm getting at? Yeah, get rid of them all - in this case as it's not in a string, you don't need #s inside the CFSet About an hour ago, I just happened to read Michael Dinowitz's, "ColdFusion with Style" ( http://www.fusionauthority.com/alert/index.cfm?alertid=8#Tech1 ), where he recommended the following on this topic: After recounting several places where a variable, function, or expression will by automatically evaluated, he says, "You should never use pounds (#) in these places. Pounds are only needed within a CFOUTPUT block, CFQUERY block, or inside any CFTAG (other than CFSET or CFIF/CFELSEIF)." Great article, Michael! --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing number of characters in CFform textarea
Claude, Not to jump in front of Jeff, but you might check out the javascript called, "Limit Textarea" at http://javascript.internet.com/forms/ According to the description, "This script controls a maximum textarea input amount and updates a small counter with how many characters are left with each keystroke. Dynamic fix now allows you to use this script in multiple textboxes on a page." HTH, --John Jeff Beer wrote: I have a great javascript function that handles this on the client side (not my own code). It has an optional counter that displays the number of characters remaining (counts down as the user enters text). Once your limit is reached, the user is unable to enter more text. I don't have it here at home. If anyone wants it, send me some mail off-list ([EMAIL PROTECTED]) and I'll send it tomorrow. Regards, Jeff -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 29, 2000 11:56 PM To: [EMAIL PROTECTED] Subject: Testing number of characters in CFform textarea I am wanting to limit the number of characters being entered into a multi lined text area cfform does cf allow for in the design of the form to limit the input of characters to a pre determined number preventing the data input of any further characters (keeping in mind this is a multi lined form so the user is able to easily read their input) or does the form need to be submitted by the user and at the time of submission cf test to the number of characters prior to updating the datafield in the database or do I have to set the max characters in the memo field of the database to the max number of characters accepted and when those characters are exceeded the database prevents the update and an appropriate error message is displayed I look forward to your comments / suggestions in this regard and thank you in advance Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- John Allred / Jackson, Mississippi Accessibility Resources: HWG's AWARE site - http://aware.hwg.org/ W3C's WAI site - http://www.w3.org/WAI/ Campaign for a Non-Browser-Specific WWW - http://www.anybrowser.org/campaign/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFLOCKs.... is this really necessary?
Zachary Bedell wrote: *shudders* Don't get me started on Allaire's documentation. We're considering starting our own internal errata list for our developers Maybe you could publish this for the rest of us, if you do it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
NQL?
Anyone familiar with NQL? I've received several contacts from the company, but I haven't had time to figure out what Network Query Language is supposed to help me do. http://www.nqlsolutions.com/ --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Express
Can anyone give me a URL where I can download CF Express? I found it on Allaire's site previously using search, but that's currently disabled. Thanks, John Allred -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Slightly OT: Dumb HTML question
You might get the result you want using CSS. Take a look at http://www.hwg.org/ and see if the table on the left is close. If so, you can open the style sheet and see how it's done. I've used it with modest success. The point is, the site works almost as well in NS as it does in IE. Regards, John Allred aimee abbott aimee@abbottTo: [EMAIL PROTECTED] s.org cc: Subject: Re: Slightly OT: Dumb HTML question 07/13/2000 11:05 PM Please respond to cf-talk At 04:09 PM 7/13/2000 -0700, Gregory Harris wrote: Hello everyone, I was trying to build a table cell TD with it's own border (apart from the rest of the table) in Netscape 4. I tried TD BORDER=1 and that didn't work, I tried a style sheet and that didn't work either, does anyone know how to do this? Thanks! table border=1 As far as I know, you can't assign a border for individual td's. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: Uncommon fonts
Uwe, This question might be better directed to a general HTML list like those offered by the HTML Writers Guild at http://www.hwg.org, however... You're not giving all the information needed here, but let me take a shot at it. HTML and CSS don't know or care about fonts. They will simply transmit a request to display a font, but for the request to be honored by the browser, the font(s) must exist on the user's system. If you specify Frutiger in a web page, only a few of your visitors are likely to see the font. Now, if you want to acquire the font and make graphics from it to use for your navigation, you'll need to own it. Since many software applications ship with a generous supply of fonts, you might already have it, although it might be named differently. Adobe has the font for sale at http://www.adobe.com/type/browser/P/P_073.html Personally, if I were going to create graphics from a font and I already had Swiss or Futura, I wouldn't bother buying Frutiger. For web work, there's not enough difference to justify spending any money on it. As a last resort, you could take your best shot at it in your code by specifying multiple fonts. A browser will use the first font in a list that's installed on the system. For instance, in HTML, use font face="frutiger, futura, swiss, sans-serif" or, in CSS, use SelectorName { font-family : frutiger, futura, swiss, sans-serif; { HTH, John Allred cftalk wrote: Hi, someone produced on an Apple MAC fonts called Frutiger (?) or Futur. HTML/CSS doesn't provide these fonts! What can I do to get a similar font in HTML ? Building graphics for the navigation-menu ? Thank you for any ideas ! SD Solutions Uwe Degenhardt Fon: 08122/903791 Fax: 08122/903792 Web: http://www.sdsolutions.de E-Mail: [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Great list WAS: Unsubscribe
Don Cuniff dcuniff@mindsTo: [EMAIL PROTECTED] pring.comcc: Subject: RE: Unsubscribe 06/29/2000 03:25 PM Please respond to cf-talk Is this the 1st time this list has ever been unified on a topic. Don't you love it when someone brings out the best is us. don = Response This is not surprising at all to me, Don. I've been monitoring an ASP list for the past couple of weeks and the difference is remarkable. On the other list, they tend to be abrupt, if not rude, very often, more interested in displaying what they know than with helping the less experienced among them. This list, on the other hand, tends to be very considerate, patient and helpful. In addition, the newbie questions on this list tend to be better thought out in the first place. And even when they're not, I don't recall anyone going out of his or her way to make the newbie feel stupid. I consider this list to be a great resource. Regards, John Allred -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Unsubscribe
Mr. Horsch, I apologize that things have apparently gotten out of hand. There's nothing that most lists like better than to get hold of a spammer, although I'm not convinced that that's what you have been. I can appreciate your difficulty in unsubscribing. Many list members had difficulty during the early part of this month. I have two suggestions: 1) issue the unsubscribe command using all email clients that you use. The signup is tied to one email address, and if you don't issue commands from that address, you'll get multiple automated messages back from the list, but you won't get unsubscribed. 2) failing that, you could set up a mail filter to delete all incoming messages from the list and just forget about it. HTH, John Allred John Allred Information Technology Services mailto:[EMAIL PROTECTED] "Words differently arranged have a different meaning, and meanings differently arranged have different effects." -- Blaise Pascal Internet MarketingTo: [EMAIL PROTECTED] Corporation cc: [EMAIL PROTECTED]Subject: Re: Unsubscribe 06/30/2000 01:38 AM Please respond to cf-talk Dear5 David... I have exercised extreme dilligence in attempting to unsubscribe. I am totally fed up. If a list can't be responsibly managed, it should not be published at all. From my point of view, you have been flaming ME with several hundred messages per day, day in and day out, week in and week out. Think twice about your remark about "having my email address" --that's a really mature remark, too. At 11:42 PM 6/28/00 -0400, you wrote: Oh that's real mature. Punish all of us on this list until you get removed. What a great human being! Just remember . . . we have YOUR email address too! - Original Message - From: Internet Marketing Corporation [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 28, 2000 11:27 PM Subject: RE: Unsubscribe To whom it may concern: I have been trying to unsubscribe from this list both through the URL and the email interface for over six weeks now. I have a large stack of reply emails saying it was successful but the posting of this message is proof that it has **NOT** been successful. I am hereby giving notice that I am tired of being polite. I will wait 48 hours and if I am still on the list I will implement large volume programmed "posting" until my postings are no longer accepted. I have really had quite enough. R.C. Horsch Internet Marketing Corporation 215-997-1234 mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Great list WAS: Unsubscribe
It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do. --John Douglas Jordon To: [EMAIL PROTECTED] zebra@interpcc: ort.net Subject: Re: Great list WAS: Unsubscribe 06/30/2000 12:19 PM Please respond to cf-talk I'm a CF newbie and non-programmer who has been helped out of several CF jams on this list. I consider it a valuable resource not to be misused or taken lightly. Doug Jordon "Gary McNeel, Jr." wrote: I could not agree with you more, John. I am on several lists and this is BY FAR the best. -Gary McNeel, Jr. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 30, 2000 8:46 AM To: [EMAIL PROTECTED] Subject: Great list WAS: Unsubscribe Don Cuniff dcuniff@mindsTo: [EMAIL PROTECTED] pring.comcc: Subject: RE: Unsubscribe 06/29/2000 03:25 PM Please respond to cf-talk Is this the 1st time this list has ever been unified on a topic. Don't you love it when someone brings out the best is us. don = Response This is not surprising at all to me, Don. I've been monitoring an ASP list for the past couple of weeks and the difference is remarkable. On the other list, they tend to be abrupt, if not rude, very often, more interested in displaying what they know than with helping the less experienced among them. This list, on the other hand, tends to be very considerate, patient and helpful. In addition, the newbie questions on this list tend to be better thought out in the first place. And even when they're not, I don't recall anyone going out of his or her way to make the newbie feel stupid. I consider this list to be a great resource. Regards, John Allred -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Unsubscribe
"webmaster@" kind of overstates this person's importance, I would say. --John Allred Billy Cravens billy.cravens@To: [EMAIL PROTECTED] sabre.com cc: Subject: Re: Unsubscribe 06/29/2000 09:04 AM Please respond to cf-talk Hehe... Check out their site, www.ivh.com To avoid being unprofessional/tacky, I won't make any comments. Draw your own conclusion. -- Billy Cravens [EMAIL PROTECTED] Internet Marketing Corporation wrote: To whom it may concern: I have been trying to unsubscribe from this list both through the URL and the email interface for over six weeks now. I have a large stack of reply emails saying it was successful but the posting of this message is proof that it has **NOT** been successful. I am hereby giving notice that I am tired of being polite. I will wait 48 hours and if I am still on the list I will implement large volume programmed "posting" until my postings are no longer accepted. I have really had quite enough. R.C. Horsch Internet Marketing Corporation 215-997-1234 mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Selects, default values..
Kenneth, You can include any options in your select that you want, either before or after your query results. Just write them as if the query output weren't present. I notice that you're not using the "value" attribute within your OPTION element. You can include this in your static options, and you can also use an additional database field to populate it within the query output. If you're inserting, this can be useful if the value you want to store differs from the visible OPTION content. e.g., instead of OPTIONmy option, you could write: OPTION value="1"My Option 1/option OPTION value="2"My Option 2/option (the end tags are optional, but I prefer to include them) Regards, John Allred Kenneth Tyler kentyler@pacTo: [EMAIL PROTECTED] bell.netcc: Subject: Re: Selects, default values.. 06/29/2000 10:08 AM Please respond to cf-talk How can i give a select a choice thats not contained in my query? Any advice Stew, SELECT NAME="mySelect" OPTIONmy option CFOUTPUT QUERY = "myQuery" OPTION#qryField# /CFOUTPUT /SELECT Kenneth Tyler, 8th Fold, Berkeley, CA, USA -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
test
test -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Seeking CF spider tag or app
Mike, If you get any responses privately, be sure to share them with the list. I'd be interested in something like this also. --John Allred Michael Bryant To: [EMAIL PROTECTED] mbryant@smtncc: et.com Subject: Seeking CF spider tag or app 06/26/2000 01:30 PM Please respond to cf-talk We are a portal site for a specific industry and we have a database of companies that are in that industry. I am looking for a spider that I can send to their URLs to retrieve email addresses and perform other functions as well. We will then send them email explaining that they are listed in our database and should come verify their listing for accuracy, etc. The features I am looking for are: * SQL database integration - pull URLs to be spidered from db - store retrieved email addresses in db * Send email automatically based on some criteria * Queue a number of URLs to spider in an automated fashion Does anyone know of anything written in CF that can do this or something close to it? An open source app that comes close could always be modified. Thanks in advance, Mike - Michael Bryant Web Application Developer SMTnet.com, The gateway to electronics manufacturing http://www.smtnet.com mailto:[EMAIL PROTECTED] Phone: (207) 780-0887 Fax: (207) 775-7710 - -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No data in new record
Hi, I've been wrestling with an add/update template. Using CFINSERT, I can get the autonumber field to increment, but the record is not added. I'm using Access 97, and the table in question is a child in a 1-M relationship. I don't have referential integrity applied, but I'm wondering if the relationship between the tables might affect my ability to insert new records. The join type is to include all parent records and only those in the child that are equal. Doing the same thing with another pair of tables works fine. But the relationship for those is reversed. Any thoughts? Thanks, -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFUG in MS
Are there any CF users interested in starting a CFUG in the Jackson, MS area? Birmingham and Atlanta are LONG drives for a mid-week meeting. Regards, John Allred -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Replacing line breaks and paragraph breaks with HTML equivelents
Dennis Powers wrote: Dave, BTW: Although I have never taken your course, you have taught me much through this medium and for that I thank you. Me too. Hey! You got a course? Where can I find out more? -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFINSERT on multiple tables
This question applies equally to inserts and updates, but describes inserts for simplicity. All references to CFINSERT I've found in CFWACK and Danesh describe the inclusion of only one tablename. For forms that query relational tables, would you have to provide for two separate inserts within a CFTRANSACTION? I'm pretty sure this will work, but I'm wondering if I can utilize one of my Access queries as the "tablename" value and do the insert in one action. Also for the child table, where I might be inserting multiple rows, do I need to do the inserts within a loop? Please be patient if this seems elementary. I'm still somewhat of a newbie. Any thoughts or advice would be appreciated... -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFINSERT on multiple tables
Dave, Thanks for the info. Any sources you can refer me to where I can dig into this in greater detail? Dave Watts wrote: Whether you use CFINSERT or a regular SQL INSERT statement within CFQUERY, you can only update one table at a time. If you need to update multiple tables, you'll need multiple inserts. Whether or not they need to be within a CFTRANSACTION really depends on the specific circumstances. If they both absolutely have to either succeed or fail together, then they belong within a transaction. Yes, if you want to perform multiple inserts within a child table, you'll probably end up looping over an insert into that table. There are alternatives, but they require a decent amount of SQL within a stored procedure. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Unable to understand error--help
Aslam, You might also check to be sure you haven't left out a quote. I had this error on a form earlier today, and it turned out I had left out a closing quote for the METHOD. --John Allred "Howell, Katie" wrote: do you have method="post" or method="get" in your cfform tag? -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 11:33 AM To: [EMAIL PROTECTED] Subject: Unable to understand error--help I have a form. I have an action page. When I fill out the form (which is simple form), I am getting an error as follows: HTTP Error 405 405 Method Not Allowed The method specified in the Request Line is not allowed for the resource identified by the request. Please ensure that you have the proper MIME type set up for the resource you are requesting. Please contact the server's administrator if this problem persists. Can someone help me and tell me where am I going wrong? Appreciate A.B. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Multiple tables redux
Hi all, I hope I'm not being a pill, but I can't get my arms around an approach. I'm sure many of you do this all the time, so it shouldn't be too hard to get me started. I have a form that allows users to fill in values that will populate both a parent and a child table. Could someone outline the high level steps to accomplish this? My books are becoming dog-eared, and I'm not getting anywhere. Your advice will be most helpful. TIA, -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
PING to check URL
I can't find any documentation on using the PING command to check for a valid URL. The alternative is to force my users to do it, when all I want is to check its validity before allowing them to enter it on my site. Any thoughts? TIA, -- John Allred / Jackson, Mississippi Mississippi Counties http://www.mscounties.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.