Re: ODBC S1000 error
thanks for ur reply mark .. did that too... no success !! are any specific privileges required ?? something that wouldnt be needed when working directly from sql but needed when execution takes place from a CF-template ?? sanjay - Original Message - From: Mark Ireland [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:58 AM Subject: Re: ODBC S1000 error Sanjay, try explicitly naming the owner of the table in the insert query. INSERT whatever into sanjay.yourTable (yourField) value(yourValue) At 04:21 PM 27/04/01, you wrote: Hi gurus I am new to this list so pls forgive me if this is a repetition, and pls let ,e know where i could locate the solution. I am on CF 4.5.1 /NT4 sp6a I have a cf-template that calls a procedure which makes (1) an insert into my local database and (2) an insert into a remote database using a dblink (for backup purposes). The insert into the remote db fails leading to an error (S1000 ODBC error). Theres no prob with the insert on the local database. However, if i execute the procedure directly from my SQL, the insert goes thro smoothly both in the local as well as the remore database. I tried putting a db trigger that would do the remote db insert. Same problem there .. What shud i do ? Thanks sanjay ~~ 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: New CF5 Partner Hosting License
But here is the rub. What about those companies that host 30 or 40,000 CF websites in the ultra competitive $9.95 per month. A $5 increase per domain is 50% increase in costs. Too many users will just bail. McAllaire never understood that it was the ISP's that offered low cost CF hosting created a small army of CF developers who then took their skills developing a small CF app to manage the local soccer club registration system into the corporate world and build enterprise applications. Putting the screws to the small ISP hosting company to try and generate revenue on a per domain license will just force these same ISP's to bail on CF and start offering PHP and ASP which has no licensing costs. It is too bad that McAllaire doesn't' get this. - Steve Steve Pierce, HDL Co-Location starting $99 per month, no setup fee (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 11:46 PM To: CF-Talk Subject: Re: New CF5 Partner Hosting License All I can say is, lets wait and see what the price change is. I can't see CFHosting saying that every customer has to fork up an extra $100 a month for licensing. An extra $5 or $10, maybe but not a major amount. And that's all based on the license. Lets say that the license is an extra $2000. On a shared box with 10 sites that can come to an additional start up fee of $200 or less. Now take into account that most smaller sites may be 50 or 100 to a box (I'm not sure of exact numbers). So a hosting company may say If you want to move up to a box with CF 5 on it we're charging a moving fee of $20-$50. Doing that as a one time thing will either take care of the licensing or close enough to it. As I've said in the past, I know the people at CFHosting (yes, I'm biased). I don't think they're going to screw the community or themselves on this. Same goes for the other hosts as well. I also don't think that A/MM is going to try and destroy the hosting business. They want to make money (who doesn't) but they also have an eye towards the future. Getting licensing money from hosting companies isn't as painful as if they asked us ALL for an extra few thousand. But as I said in the beginning of this post, lets wait and see. But the small development companies, particularly outside the US where bandwidth is a lot more expensive, cannot afford to host their own machines, and so we rely on virtual hosts like the CFHosting and the Cyberhost etc etc. If we will have to pay extra for our sites to be hosted on these servers, to cover the cost of licensing, then we will have to rethink our 'commitment' to ColdFusion. The majority of our client choose to use virtual servers for obvious reasons, and because they don't have the resources to host or maintain in-house. If these restrictions and costs get imposed on the Host providers, then they are going to be passed on to us, and then our clients, who are simply going to say that XYZ company are going to write in ASP/PHP/JSP and hosting is going to be a fraction of the cost. It already costs more to have a CF site hosted than an ASP site... How much more is this going to make it?? For the individuals on this list, it may not be a worry... For the small development companies, it could well be. And we are talking about Macromedia See the references in other messages to Generator. Priced out of the small-business league. Macromedia are in it for the money, and this is a concern that I've had since the merger. on 4/27/01 1:04 PM, Michael Dinowitz at [EMAIL PROTECTED] wrote: I think we should look at the original post again and calm down a bit. Notice how they say Hosting Service Providers? They're not talking about me with my 3 domains on a machine. They're not talking about you with your 2 or whatever domains on your machine. They're talking about CFHosting.com, who are defined as a business that provides hosting. They're talking about businesses, not people. While I could be wrong on this, I don't think I am. Relax. We'll see how it goes, but jumping to conclusions and thinking that we have to do the unimaginable (going to asp or perl) is not needed. ColdFusion will be here for us and I think that A/MM will see us for what we are, an asset to ColdFusion. We've just got to relax. ~~ 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: New CF5 Partner Hosting License
Please leave me alone now. The future is games! ~~ 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: New CF5 Partner Hosting License
- Original Message - From: Paul Sizemore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 9:57 PM Subject: RE: New CF5 Partner Hosting License It sounds like MM is going to throw the CF community a bone and then stick us in the pound. They kill Spectra, restructure licensing, float our pallets, and make us develop with a Studio / UltraDev hybrid. All this comes from the boardroom, not a developer wish list. Former Drumbeat developers still don't have a comparable solution in UltraDev. You have to remember, MM wants to make money, not necessarily provide a better development environment for us. This can be achieved by bringing CF down to the point a general HTML developer can create a viable application. But the cost of hosting those applications will make CF an unlikely choice. I would say the majority of CF development work is actually done on small sites running on shared servers. I have worked on dozens of such sites and I know of one problem that I always have to get over - the customer complaining about hosting costs, even when it's only £40 or so per month. I welcomed the Spectra announcement, it was obvious that something had to be done as it was way too expensive to be used on most sites, unfortunately it now looks like CF may become another product like Generator - very nice but out of most companies price range. ~~ 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: New CF5 Partner Hosting License
I think it just went to hosting partners. I didn't get one either. It will be interesting to see how this pans out. After all, CF5 is just a stepping stone to Neo isn't it? Surely if they hike the pricing model too high, no-one will pick up CF5 when there is a MAJOR new release round the corner. I will have to look at the costs, the implications of not adopting it etc.. before we make a decision on CF5. I think if A/MM aren't careful this could turn around and bite them on the backside!! Just my opinion Will -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 06:21 To: CF-Talk Subject: RE: New CF5 Partner Hosting License Was this announcement sent to *all* A/MM Partners? I didn't see it. Can someone who received it shoot me a copy, please? Thanks. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Sales Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 Instant Messaging: AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED] -Original Message- From: Chris Colón [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 2:58 PM I agree. The announcement came from [EMAIL PROTECTED], which is where I sent some feedback of my own... ~~ 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: slightly OT ADO vs DAO
I've figured out why I was getting the errors. I had references for both DAO and ADO installed, and my DAO code was kicking up data type mismatch errors and stuff like that. Unchecked the ADO reference and everything worked a treat. So it would seem that you can't use both at the same time?? Cheers Will -Original Message- From: zCF Talk [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 22:49 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Some observations about ADO and DAO - DAO uses double quotes, while ADO uses single quotes (many hours spent fixing this). - If you open a recordset which is the base table, DAO returns the column names in the order they are stored in access, while ADO sorts column names alphabetically (no known workaround). --- Daniel Dewey|Tell me, and I'll forget. Systems Developer | Show me, and I may not remember. MCP (NT srvr/wkstn/eprise) | Involve me, and I'll understand. [EMAIL PROTECTED] | - Native American Proverb http://www.pobox.com/~dewey | 610-868-1421, x115 The National Association of Colleges and Employers These opinions are mine, and may not be the same as my employer ~~ 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: New CF5 Partner Hosting License
- Original Message - From: Adrian Cooper [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 11:03 PM Subject: Re: New CF5 Partner Hosting License - Original Message - From: Paul Sizemore [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 9:57 PM You have to remember, MM wants to make money, not necessarily provide a better development environment for us. This can be achieved by bringing CF down to the point a general HTML developer can create a viable application. MM would do much better to make CF Server free, and sell super high performance rich development tools to target that environment - the universe of developers would be much larger. Adrian Cooper. Not a bad idea, they could even keep Enterprise as a paid for premium product and put Pro out for free. ~~ 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: New CF5 Partner Hosting License
I think we should look at the original post again and calm down a bit. Notice how they say Hosting Service Providers? They're not talking about me with my 3 domains on a machine. They're not talking about you with your 2 or whatever domains on your machine. They're talking about CFHosting.com, who are defined as a business that provides hosting. Do you know how many companies offer ColdFusion hosting in the UK? I know of about 10-15, none of which are large, well-known companies. Why? Demon told me it was the cost of the Application Server versus demand. There response was develop in ASP. If this pricing policy works its way through, hosting companies in the UK are going to be *less* likely to purchase CFAS, not more. And of the ones that have, all of them have a price per domain pricing structure. I was hoping to see reseller ColdFusion hosting options appear in the UK where you can host multiple domains for a fixed price per month (as a developer, that's ideal - we stand to generate monthly revenue the more we develop in ColdFusion), but I can't see that happening if this announcement comes into effect. So, end result, less ColdFusion hosting on offer, hosting prices don't come down, people reluctant to go down the ColdFusion route as it seems increasingly marginialised, proprietary and costly to host. ColdFusion isn't particularly mainstream in the UK as it is. Why do something that runs the risk of making it even less-so? This announcement stands to hit hosting companies in the short term and developers (who have to source hosting solutions for the applications they develop) in the longer term. If the price squeeze is enough, ColdFusion Server sales in the UK will suffer, the effects of which will cascade down to the point at which developers learn other languages and suggest they develop applications in those instead. Methinks Allaire/Macromedia might be trying to recoup their losses on Spectra... -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ 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
List Functions
All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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: Netscape 6
I said it before and I'll say it again Mozilla is a great browser. Netscape built NS6 on a 0.8 branch of Mozilla. When the next version of Netscape come out you should a good browser, with a great JavaScript debugger , Mail client etc . Justin (wearing a black beret) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 4:29 PM To: CF-Talk Subject: RE: Netscape 6 And people wunder why no one bothers to suport it :-) -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 14:52 To: CF-Talk Subject: RE: Netscape 6 That is a known bug in Netscape 6. The latest updates have not yet fixed the problem. Benjamin S. Rogers ~~ 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: New CF5 Partner Hosting License
Correct..especially for Off Shore development such as what I do here in Trinidad. Our net connections can't support an INternational Website, so we HAVE to host on shared servers abroad like Hostpro.net or CFHOSTING etc. If the COST of hosting on a CF Enabled server goes up..why the heck would anyone outside the US choose Coldfusion??? That market is going to die off. True some may say well its not a sizeable market..but why COULDN'T it be? :) The Caribbean, and Latin America is only now, I think, starting to experience the .COM burst that the States experienced two or more years ago..Companies are starting to realise that the net is there and the net can help them. Trinidad is only just getting Wireless Cable Modems, we have Direct PC etc. and its the same thing that's starting to happen all up the caribbean island chain...these people gonna want development done. Right now everyone here knows .ASP. If it costs much more to put up a client website in the states on Coldfusion..they're not going to even sniff at CF. -Gel www.carigamer.com Island Gaming At Its Best!(tm) -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] But the small development companies, particularly outside the US where bandwidth is a lot more expensive, cannot afford to host their own machines, and so we rely on virtual hosts like the CFHosting and the Cyberhost etc etc. If we will have to pay extra for our sites to be hosted on these servers, to cover the cost of licensing, then we will have to rethink our 'commitment' to ColdFusion. ~~ 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: New CF5 Partner Hosting License
YES!! He ssss the light! -Gel www.carigamer.com ISLAND GAMING AT ITS BEST!(tm) hee hee -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Please leave me alone now. The future is games! ~~ 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: New CF5 Partner Hosting License
- Original Message - From: Aidan Whitehall [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:27 AM Yes - having been in the Internet industry in Britain ever since there was one - I founded one of the first fully national ISP's - I can certainly endorse the comments of Aidan. What few hosting companies that have been willing hitherto to support Cold Fusion will surely do so no longer if the new pricing schema is at it would appear to be. Service providers of all types are used to getting things for free - Linux, Apache, Sendmail etc.., and premium charges for CF are hardly going to encourage service providers in general to consider actually paying for a server side application. I have to say - this is extremely myopic of Macromedia (subject to seeing the full details) - it will push developers who may have been waivering to ASP/PHP etc., and other free middleware. I still firmly believe that the best strategy would be to make CF Server free, and focus on marketing development tools to a much wider audience as a result. I think the Netscape browser is a good parallel - they had to make it free and open source to encourage people to use the portal. No one will pay for browsers anymore than they will for expensive middleware, when the alternatives are free and widely supported. Adrian Cooper. Do you know how many companies offer ColdFusion hosting in the UK? I know of about 10-15, none of which are large, well-known companies. Why? Demon told me it was the cost of the Application Server versus demand. There response was develop in ASP. If this pricing policy works its way through, hosting companies in the UK are going to be *less* likely to purchase CFAS, not more. And of the ones that have, all of them have a price per domain pricing structure. I was hoping to see reseller ColdFusion hosting options appear in the UK where you can host multiple domains for a fixed price per month (as a developer, that's ideal - we stand to generate monthly revenue the more we develop in ColdFusion), but I can't see that happening if this announcement comes into effect. So, end result, less ColdFusion hosting on offer, hosting prices don't come down, people reluctant to go down the ColdFusion route as it seems increasingly marginialised, proprietary and costly to host. ColdFusion isn't particularly mainstream in the UK as it is. Why do something that runs the risk of making it even less-so? This announcement stands to hit hosting companies in the short term and developers (who have to source hosting solutions for the applications they develop) in the longer term. If the price squeeze is enough, ColdFusion Server sales in the UK will suffer, the effects of which will cascade down to the point at which developers learn other languages and suggest they develop applications in those instead. Methinks Allaire/Macromedia might be trying to recoup their losses on Spectra... -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ 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: Netscape 6
I agree, I've been using Mozilla SeaMonkey ( st00pid name ) for quite some time now, I' ve always liked it. I like NN6 too but it's a bit too buggy and slow. I think I'll go get the latest version of Mozilla and have a play. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 11:59 To: CF-Talk Subject: RE: Netscape 6 I said it before and I'll say it again Mozilla is a great browser. Netscape built NS6 on a 0.8 branch of Mozilla. When the next version of Netscape come out you should a good browser, with a great JavaScript debugger , Mail client etc . Justin (wearing a black beret) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 4:29 PM To: CF-Talk Subject: RE: Netscape 6 And people wunder why no one bothers to suport it :-) -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 14:52 To: CF-Talk Subject: RE: Netscape 6 That is a known bug in Netscape 6. The latest updates have not yet fixed the problem. Benjamin S. Rogers ~~ 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: Javascript Pop-Up Calendar
There is one on the allaire custom tags section. cant remember the company name but they also produce HTML_area -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 02:35 To: CF-Talk Subject: RE: Javascript Pop-Up Calendar Instead of a pop-up calendar , does anyone knows where i can get an active x componenet that shows a drop down calendar upon click just like what u see in microsoft outlook when u select a date. -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 5:50 AM To: CF-Talk Subject: Re: Javascript Pop-Up Calendar http://javascript.internet.com/calendars/popup-date-picker.html has one. I personally don't care for the look of this one but you should be able to modify code to fit. and another one: http://developer.iplanet.com/viewsource/husted_calendar/husted_calendar.html - Original Message - From: James Taavon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 2:54 PM Subject: Javascript Pop-Up Calendar Hey, how's everybody on this lovely Friday-Eve (Thursday for you folks who are slow). I wanted to know where I could obtain the code for a javascript pop-up calendar that I have seen on many sites. You know, the one where you click on a thumbnail calendar box, select the date and it fills it in your form field. Thanks! James ~~ 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 Newbie
I would like to list a specific directory and it's contents. I can't get the code below to display all the folders and files. table border=0 cellpadding=0 cellspacing=0 width=100% height=100% tr valign=top td cfdirectory ACTION=List DIRECTORY=C:\ NAME=DirList MODE=666 SORT=name ASC cfform ACTION=list.cfm METHOD=POST ENABLECAB=Yes cftree name=DirList align=LEFT height=400 width=248 font=Arial bold=No italic=No border=Yes hscroll=Yes vscroll=Yes required=No completepath=No appendkey=Yes highlighthref=Yes cftreeITEM VALUE=Books !--- DO CFLOOP IN HERE --- cftreeitem value=DirList parent=DirList img=document href=test.cfm queryasroot=No expand=Yes /cftree /cfform /td /tr /table ~~ 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: New CF5 Partner Hosting License
Well, personally I get a feeling that this is the first nail in the coffin of CF Application Server - see the logic - increase the price to push it up to be in the same league as Broadvision and Vignette - drop spectra as the webtop never worked - over price the back end middle ware and wait and see if large companies buy it - in the meantime develop jrun to act as CF Application Server - if CF 5 at new price fails - drop it like spectra and release jrun CF at slightly increased prices to old CF Enterprise - get us all to use that instead - etc, etc, - I'm off to buy a PHP book. J -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 12:24 To: CF-Talk Subject: Re: New CF5 Partner Hosting License - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:27 AM Yes - having been in the Internet industry in Britain ever since there was one - I founded one of the first fully national ISP's - I can certainly endorse the comments of Aidan. What few hosting companies that have been willing hitherto to support Cold Fusion will surely do so no longer if the new pricing schema is at it would appear to be. Service providers of all types are used to getting things for free - Linux, Apache, Sendmail etc.., and premium charges for CF are hardly going to encourage service providers in general to consider actually paying for a server side application. I have to say - this is extremely myopic of Macromedia (subject to seeing the full details) - it will push developers who may have been waivering to ASP/PHP etc., and other free middleware. I still firmly believe that the best strategy would be to make CF Server free, and focus on marketing development tools to a much wider audience as a result. I think the Netscape browser is a good parallel - they had to make it free and open source to encourage people to use the portal. No one will pay for browsers anymore than they will for expensive middleware, when the alternatives are free and widely supported. Adrian Cooper. Do you know how many companies offer ColdFusion hosting in the UK? I know of about 10-15, none of which are large, well-known companies. Why? Demon told me it was the cost of the Application Server versus demand. There response was develop in ASP. If this pricing policy works its way through, hosting companies in the UK are going to be *less* likely to purchase CFAS, not more. And of the ones that have, all of them have a price per domain pricing structure. I was hoping to see reseller ColdFusion hosting options appear in the UK where you can host multiple domains for a fixed price per month (as a developer, that's ideal - we stand to generate monthly revenue the more we develop in ColdFusion), but I can't see that happening if this announcement comes into effect. So, end result, less ColdFusion hosting on offer, hosting prices don't come down, people reluctant to go down the ColdFusion route as it seems increasingly marginialised, proprietary and costly to host. ColdFusion isn't particularly mainstream in the UK as it is. Why do something that runs the risk of making it even less-so? This announcement stands to hit hosting companies in the short term and developers (who have to source hosting solutions for the applications they develop) in the longer term. If the price squeeze is enough, ColdFusion Server sales in the UK will suffer, the effects of which will cascade down to the point at which developers learn other languages and suggest they develop applications in those instead. Methinks Allaire/Macromedia might be trying to recoup their losses on Spectra... -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ 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: Javascript Pop-Up Calendar...Thanks!
THANKS, THIS IS JUST WHAT I WAS LOOKING FOR!!! Larry C. Lyons wrote: James, Try Selene Bainum CFDateSelectPopup custom tag. It mostly does what you want without much modification. You can download the file at http://www.webtricks.com/SourceCode/default.cfm?Page=CFDateSelectPopup.cfm hth, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- James Taavon wrote: Hey, how's everybody on this lovely Friday-Eve (Thursday for you folks who are slow). I wanted to know where I could obtain the code for a javascript pop-up calendar that I have seen on many sites. You know, the one where you click on a thumbnail calendar box, select the date and it fills it in your form field. Thanks! James ~~ 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: New CF5 Partner Hosting License
MacroMedia/Allaire should know that a Server Side Application Server like Cold Fusion can't be compared to servers such as mail servers,webserver, etc.and push the big licensing fees. One big difference is those servers can be purschased installed out of the box and do its thing with the existing software. Cold Fusion requires applications(thus developers). What good is a server if the applications aren't there to run on it? Developers developing Cold Fusion apps is what makes the demand for a ColdFusion Server. That does Macromedia little good if we are developing in PHP,ASP etc. They are either missing the whole boat here or they have another agenda on down the road for their plans of ColdFusion. Unfortunately, its probably the latter. I agree with the reply yesterday( i don't remember who posted it), but they should make ColdFusion Server free and then charge us the high end prices for the RAD environments and the rich tools that they can provide to develop applications. - Original Message - From: James Maltby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 7:00 AM Subject: RE: New CF5 Partner Hosting License Well, personally I get a feeling that this is the first nail in the coffin of CF Application Server - see the logic - increase the price to push it up to be in the same league as Broadvision and Vignette - drop spectra as the webtop never worked - over price the back end middle ware and wait and see if large companies buy it - in the meantime develop jrun to act as CF Application Server - if CF 5 at new price fails - drop it like spectra and release jrun CF at slightly increased prices to old CF Enterprise - get us all to use that instead - etc, etc, - I'm off to buy a PHP book. J -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 12:24 To: CF-Talk Subject: Re: New CF5 Partner Hosting License - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:27 AM Yes - having been in the Internet industry in Britain ever since there was one - I founded one of the first fully national ISP's - I can certainly endorse the comments of Aidan. What few hosting companies that have been willing hitherto to support Cold Fusion will surely do so no longer if the new pricing schema is at it would appear to be. Service providers of all types are used to getting things for free - Linux, Apache, Sendmail etc.., and premium charges for CF are hardly going to encourage service providers in general to consider actually paying for a server side application. I have to say - this is extremely myopic of Macromedia (subject to seeing the full details) - it will push developers who may have been waivering to ASP/PHP etc., and other free middleware. I still firmly believe that the best strategy would be to make CF Server free, and focus on marketing development tools to a much wider audience as a result. I think the Netscape browser is a good parallel - they had to make it free and open source to encourage people to use the portal. No one will pay for browsers anymore than they will for expensive middleware, when the alternatives are free and widely supported. Adrian Cooper. Do you know how many companies offer ColdFusion hosting in the UK? I know of about 10-15, none of which are large, well-known companies. Why? Demon told me it was the cost of the Application Server versus demand. There response was develop in ASP. If this pricing policy works its way through, hosting companies in the UK are going to be *less* likely to purchase CFAS, not more. And of the ones that have, all of them have a price per domain pricing structure. I was hoping to see reseller ColdFusion hosting options appear in the UK where you can host multiple domains for a fixed price per month (as a developer, that's ideal - we stand to generate monthly revenue the more we develop in ColdFusion), but I can't see that happening if this announcement comes into effect. So, end result, less ColdFusion hosting on offer, hosting prices don't come down, people reluctant to go down the ColdFusion route as it seems increasingly marginialised, proprietary and costly to host. ColdFusion isn't particularly mainstream in the UK as it is. Why do something that runs the risk of making it even less-so? This announcement stands to hit hosting companies in the short term and developers (who have to source hosting solutions for the applications they develop) in the longer term. If the price squeeze is enough, ColdFusion Server sales in the UK will suffer, the effects of which will cascade down to the point at which developers learn other languages and suggest they develop applications in those instead. Methinks Allaire/Macromedia might be trying to recoup their losses on Spectra... -- Aidan Whitehall
RE: Resume Field
html_area_lite This is the free version of HTML_area and is available from allaires website. I would recomend it. A few odd things aobut it but does pretty much what you want it too -Original Message- From: Christine Kelley [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 20:03 To: CF-Talk Subject: Resume Field Hi all! Is there a custom tag that has a textarea that will accept formatting? Example...there is a textarea now where people can enter their resumes, but all the formatting (spacing) gets lost due to the ignoring of white space. People just like to copy their resumes from Word and paste them into the field. The field should just accept regular text (not HTML). I've looked in to EWebEditPro, but I believe there is a limit on how many people can use it at once (unless an unlimited user license is bought...expensive). Any ideas? Any help is greatly appreciated :) Christine ~~ 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: New CF5 Partner Hosting License
And we'll all continue to develop in CFS 4.5... -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 13:25 To: CF-Talk Subject: Re: New CF5 Partner Hosting License MacroMedia/Allaire should know that a Server Side Application Server like Cold Fusion can't be compared to servers such as mail servers,webserver, etc.and push the big licensing fees. One big difference is those servers can be purschased installed out of the box and do its thing with the existing software. Cold Fusion requires applications(thus developers). What good is a server if the applications aren't there to run on it? Developers developing Cold Fusion apps is what makes the demand for a ColdFusion Server. That does Macromedia little good if we are developing in PHP,ASP etc. They are either missing the whole boat here or they have another agenda on down the road for their plans of ColdFusion. Unfortunately, its probably the latter. I agree with the reply yesterday( i don't remember who posted it), but they should make ColdFusion Server free and then charge us the high end prices for the RAD environments and the rich tools that they can provide to develop applications. - Original Message - From: James Maltby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 7:00 AM Subject: RE: New CF5 Partner Hosting License Well, personally I get a feeling that this is the first nail in the coffin of CF Application Server - see the logic - increase the price to push it up to be in the same league as Broadvision and Vignette - drop spectra as the webtop never worked - over price the back end middle ware and wait and see if large companies buy it - in the meantime develop jrun to act as CF Application Server - if CF 5 at new price fails - drop it like spectra and release jrun CF at slightly increased prices to old CF Enterprise - get us all to use that instead - etc, etc, - I'm off to buy a PHP book. J -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 12:24 To: CF-Talk Subject: Re: New CF5 Partner Hosting License - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:27 AM Yes - having been in the Internet industry in Britain ever since there was one - I founded one of the first fully national ISP's - I can certainly endorse the comments of Aidan. What few hosting companies that have been willing hitherto to support Cold Fusion will surely do so no longer if the new pricing schema is at it would appear to be. Service providers of all types are used to getting things for free - Linux, Apache, Sendmail etc.., and premium charges for CF are hardly going to encourage service providers in general to consider actually paying for a server side application. I have to say - this is extremely myopic of Macromedia (subject to seeing the full details) - it will push developers who may have been waivering to ASP/PHP etc., and other free middleware. I still firmly believe that the best strategy would be to make CF Server free, and focus on marketing development tools to a much wider audience as a result. I think the Netscape browser is a good parallel - they had to make it free and open source to encourage people to use the portal. No one will pay for browsers anymore than they will for expensive middleware, when the alternatives are free and widely supported. Adrian Cooper. Do you know how many companies offer ColdFusion hosting in the UK? I know of about 10-15, none of which are large, well-known companies. Why? Demon told me it was the cost of the Application Server versus demand. There response was develop in ASP. If this pricing policy works its way through, hosting companies in the UK are going to be *less* likely to purchase CFAS, not more. And of the ones that have, all of them have a price per domain pricing structure. I was hoping to see reseller ColdFusion hosting options appear in the UK where you can host multiple domains for a fixed price per month (as a developer, that's ideal - we stand to generate monthly revenue the more we develop in ColdFusion), but I can't see that happening if this announcement comes into effect. So, end result, less ColdFusion hosting on offer, hosting prices don't come down, people reluctant to go down the ColdFusion route as it seems increasingly marginialised, proprietary and costly to host. ColdFusion isn't particularly mainstream in the UK as it is. Why do something that runs the risk of making it even less-so? This announcement stands to hit hosting companies in the short term and developers (who have to source hosting solutions for the applications they develop) in the longer term. If the price squeeze is enough, ColdFusion Server sales in the UK will suffer, the effects of which will cascade down to the point at which
Bulk Insert
Situation: Need to add about 1000 records to a remote DB. Trying to write a bulk insert type app in CF for it. Pretty sure I need to use CFLOOP - list to get it done. Resources: Access 2000 DB, csv file of records (comma delimited), no admin access to server, 24 hours. I'm thinking something like: cfloop list=#Form.Input# delimiters=, index=ThisFile cfoutput cfquery name=update datasource=myDB dbtype=ODBC INSERT INTO MyTable (Field1, Field2, Field3) VALUES (#ThisFile#) /cfoutput /cfloop Form.Input comes, of course, from a textarea field on a form not shown here. Am I even close here? Just wanting tips or pointers, not outright answers. I love to learn this sort of thing for myself so I always know it. How does this know when it has reached EOF? Guy J. McDowell www.guymcdowell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bulk Insert
Although its not desirable, I 've done bulk insert remotely using coldfusion up to 40,000 records. One thing I learned the hard way the first time was after my insert application finished running, I automatically assumed it should be done inserting to the database. So I would query and not see all the records there and thought something went wrong. But in reality, I guess it all queues up in Cold Fusion server memory and takes a good while to finish. So be patient with it, it takes a while, especially if you have a lot of table joins looping going on. - Original Message - From: Guy McDowell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 7:56 AM Subject: Bulk Insert Situation: Need to add about 1000 records to a remote DB. Trying to write a bulk insert type app in CF for it. Pretty sure I need to use CFLOOP - list to get it done. Resources: Access 2000 DB, csv file of records (comma delimited), no admin access to server, 24 hours. I'm thinking something like: cfloop list=#Form.Input# delimiters=, index=ThisFile cfoutput cfquery name=update datasource=myDB dbtype=ODBC INSERT INTO MyTable (Field1, Field2, Field3) VALUES (#ThisFile#) /cfoutput /cfloop Form.Input comes, of course, from a textarea field on a form not shown here. Am I even close here? Just wanting tips or pointers, not outright answers. I love to learn this sort of thing for myself so I always know it. How does this know when it has reached EOF? Guy J. McDowell www.guymcdowell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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: Report
Thanks for your reply. I am unable to find any proper logic for my problem. And well thats the problem:). I am tried using Quarter function but it only gives the the quarter number such as April is in 2nd quarter. Please help. Shally. --- Chris Maloney [EMAIL PROTECTED] wrote: Considering you didn't paste any errors that you have received with this the first thing I suggest you do is change the name of your date field from 'Date' to something else like 'myDate'. 'Date' is a reserved word in SQL and frequently causes problems because Access will not warn you of this when you are creating a table. Chris -Original Message- From: Shally [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:05 AM To: CF-Talk Subject: Report Hi Every one, I have an access table having 3 fields Date, Quantity and Amount. I am working on a report where I have to calculate the Quantity and Amount on quarterly bases for last year and this year. I tried using the function Quarter but an unable to reach any solution.Please help!! Thanks in advance Shally. ~~ 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: List Functions
Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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
Large recordset = large whitespace???
I have a query that can return several thousand records. When I run a query that only returns a small number ( lets say 15 or so, which is what I have seen), the page behaves fine, displays fine, etc. HOWEVER if I return a large number of records (1020, which is what I have seen), there is a huge amount of white space (like 2 page down's worth on a 1024 X 768 resolution) displayed before the table of results... in effect, making it look as if there was nothing returned, and all there is showing initially is the page header graphics. I've made sure everything that can be set to 0 is (margins, cellpadding, etc.) and that all the table elements are valigned to TOP... any other suggestions? Gina Shillitani ~~ 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: New CF5 Partner Hosting License
I think I'm a partner, but I didn't get it. I believe it was sent to the hosting partners only. Was this announcement sent to *all* A/MM Partners? I didn't see it. Can someone who received it shoot me a copy, please? Thanks. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Sales Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 Instant Messaging: AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED] -Original Message- From: Chris Colón [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 2:58 PM I agree. The announcement came from [EMAIL PROTECTED], which is where I sent some feedback of my own... ~~ 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: New CF5 Partner Hosting License
If the UK or other non-US ISPs talked to A/MM, maybe individual deals could be made. If I was at A/MM I'd talk to ISPs on a per company basis and for some wave the fee for a time to 'help get them on their feet'. ISP building is great in the long run but may cost a little in licensing in the short. But that's just me. Do you know how many companies offer ColdFusion hosting in the UK? I know of about 10-15, none of which are large, well-known companies. Why? Demon told me it was the cost of the Application Server versus demand. There response was develop in ASP. If this pricing policy works its way through, hosting companies in the UK are going to be *less* likely to purchase CFAS, not more. And of the ones that have, all of them have a price per domain pricing structure. I was hoping to see reseller ColdFusion hosting options appear in the UK where you can host multiple domains for a fixed price per month (as a developer, that's ideal - we stand to generate monthly revenue the more we develop in ColdFusion), but I can't see that happening if this announcement comes into effect. So, end result, less ColdFusion hosting on offer, hosting prices don't come down, people reluctant to go down the ColdFusion route as it seems increasingly marginialised, proprietary and costly to host. ColdFusion isn't particularly mainstream in the UK as it is. Why do something that runs the risk of making it even less-so? This announcement stands to hit hosting companies in the short term and developers (who have to source hosting solutions for the applications they develop) in the longer term. If the price squeeze is enough, ColdFusion Server sales in the UK will suffer, the effects of which will cascade down to the point at which developers learn other languages and suggest they develop applications in those instead. Methinks Allaire/Macromedia might be trying to recoup their losses on Spectra... -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ 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: Report
calculate the cut-off dates thus:
Now()
DateAdd('m',-3,Now())
DateAdd('m',-6,Now()))
etc.,
- Original Message -
From: Shally [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 9:30 AM
Subject: RE: Report
Thanks for your reply.
I am unable to find any proper logic for my problem.
And well thats the problem:).
I am tried using Quarter function but it only gives
the the quarter number such as April is in 2nd
quarter.
Please help.
Shally.
--- Chris Maloney [EMAIL PROTECTED] wrote:
Considering you didn't paste any errors that you
have received with this the
first thing I suggest you do is change the name of
your date field from
'Date' to something else like 'myDate'. 'Date' is a
reserved word in SQL and
frequently causes problems because Access will not
warn you of this when you
are creating a table.
Chris
-Original Message-
From: Shally [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 10:05 AM
To: CF-Talk
Subject: Report
Hi Every one,
I have an access table having 3 fields Date,
Quantity
and Amount.
I am working on a report where I have to calculate
the
Quantity and Amount on quarterly bases for last year
and this year.
I tried using the function Quarter but an unable
to
reach any solution.Please help!!
Thanks in advance
Shally.
~~
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: New CF5 Partner Hosting License
One of the main strengths of CF has always been its developer community. MANY, MANY improvements came from them. I wonder how MM quantifies Developer Community and Developer Community Good Will in its cost/benefit analysis whose goal is to maximize profits. best, paul At 05:15 PM 4/26/01 -0700, you wrote: i agree with your latter sentiments. we've been developing more and more non-CF (jsp, php, asp) applications for a variety of reasons. and now i'm very, very glad. i also agree this doesn't appear to be headed in a positive direction, but i suppose we need to wait and see what MM comes up with. like you, i hope they consider this very carefully. ~~ 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: Large recordset = large whitespace???
using any custom tags? they may be introducing the white space. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 9:42 AM Subject: Large recordset = large whitespace??? I have a query that can return several thousand records. When I run a query that only returns a small number ( lets say 15 or so, which is what I have seen), the page behaves fine, displays fine, etc. HOWEVER if I return a large number of records (1020, which is what I have seen), there is a huge amount of white space (like 2 page down's worth on a 1024 X 768 resolution) displayed before the table of results... in effect, making it look as if there was nothing returned, and all there is showing initially is the page header graphics. I've made sure everything that can be set to 0 is (margins, cellpadding, etc.) and that all the table elements are valigned to TOP... any other suggestions? Gina Shillitani ~~ 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: New CF5 Partner Hosting License
The first thing that sprang to mind when I read this was... Macromedia don't even have a partner program of any sort. At least not available here in Australia. So that could indicate that there isn't much of a 'Developer Community' within Macromedia! One of the main strengths of CF has always been its developer community. MANY, MANY improvements came from them. I wonder how MM quantifies Developer Community and Developer Community Good Will in its cost/benefit analysis whose goal is to maximize profits. best, paul At 05:15 PM 4/26/01 -0700, you wrote: i agree with your latter sentiments. we've been developing more and more non-CF (jsp, php, asp) applications for a variety of reasons. and now i'm very, very glad. i also agree this doesn't appear to be headed in a positive direction, but i suppose we need to wait and see what MM comes up with. like you, i hope they consider this very carefully. ~~ 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: Large recordset = large whitespace???
Have you got a p or br lurking around somewhere in the table, not correctly enclosed in td/td and tr/tr ? Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 2:43 PM To: CF-Talk Subject: Large recordset = large whitespace??? I have a query that can return several thousand records. When I run a query that only returns a small number ( lets say 15 or so, which is what I have seen), the page behaves fine, displays fine, etc. HOWEVER if I return a large number of records (1020, which is what I have seen), there is a huge amount of white space (like 2 page down's worth on a 1024 X 768 resolution) displayed before the table of results... in effect, making it look as if there was nothing returned, and all there is showing initially is the page header graphics. I've made sure everything that can be set to 0 is (margins, cellpadding, etc.) and that all the table elements are valigned to TOP... any other suggestions? Gina Shillitani ~~ 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: Report
select datepart(q,somedate) as quarter,sum(qty),sum(amt)
from sometable
group by datepart(q,somedate)
Should give you a quarterly summary table I I understand the question
.
Eric
From: Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Report
Date: Fri, 27 Apr 2001 09:52:43 -0400
calculate the cut-off dates thus:
Now()
DateAdd('m',-3,Now())
DateAdd('m',-6,Now()))
etc.,
- Original Message -
From: Shally [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 9:30 AM
Subject: RE: Report
Thanks for your reply.
I am unable to find any proper logic for my problem.
And well thats the problem:).
I am tried using Quarter function but it only gives
the the quarter number such as April is in 2nd
quarter.
Please help.
Shally.
--- Chris Maloney [EMAIL PROTECTED] wrote:
Considering you didn't paste any errors that you
have received with this the
first thing I suggest you do is change the name of
your date field from
'Date' to something else like 'myDate'. 'Date' is a
reserved word in SQL and
frequently causes problems because Access will not
warn you of this when you
are creating a table.
Chris
-Original Message-
From: Shally [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 10:05 AM
To: CF-Talk
Subject: Report
Hi Every one,
I have an access table having 3 fields Date,
Quantity
and Amount.
I am working on a report where I have to calculate
the
Quantity and Amount on quarterly bases for last year
and this year.
I tried using the function Quarter but an unable
to
reach any solution.Please help!!
Thanks in advance
Shally.
~~
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: Large recordset = large whitespace???
You could also try cfsetting enablecfoutputonly=Yes before your cfcode and cfsetting enablecfoutputonly=no at the end if you are collating or concatenating the results in anyway - or calling a custom tag, etc J -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 15:12 To: CF-Talk Subject: RE: Large recordset = large whitespace??? Have you got a p or br lurking around somewhere in the table, not correctly enclosed in td/td and tr/tr ? Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 2:43 PM To: CF-Talk Subject: Large recordset = large whitespace??? I have a query that can return several thousand records. When I run a query that only returns a small number ( lets say 15 or so, which is what I have seen), the page behaves fine, displays fine, etc. HOWEVER if I return a large number of records (1020, which is what I have seen), there is a huge amount of white space (like 2 page down's worth on a 1024 X 768 resolution) displayed before the table of results... in effect, making it look as if there was nothing returned, and all there is showing initially is the page header graphics. I've made sure everything that can be set to 0 is (margins, cellpadding, etc.) and that all the table elements are valigned to TOP... any other suggestions? Gina Shillitani ~~ 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: Large recordset = large whitespace???
I believe that you are referring to the actual page output. Whitespace is the blank space that you would see on a view source. Anyhow, I would imagine that you are displaying everything in a table that has hidden form fields somewhere in it. Hidden form fields take up a very small amount of real estate on your page, but if these are all bunched together, it can really screw up the expected output. If your hidden form fields are outside of tds, it places the resulting space prior to the table. just like table tr tdA/td tdB/td C /tr /table would place the C prior to the table -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 8:43 AM To: CF-Talk Subject: Large recordset = large whitespace??? I have a query that can return several thousand records. When I run a query that only returns a small number ( lets say 15 or so, which is what I have seen), the page behaves fine, displays fine, etc. HOWEVER if I return a large number of records (1020, which is what I have seen), there is a huge amount of white space (like 2 page down's worth on a 1024 X 768 resolution) displayed before the table of results... in effect, making it look as if there was nothing returned, and all there is showing initially is the page header graphics. I've made sure everything that can be set to 0 is (margins, cellpadding, etc.) and that all the table elements are valigned to TOP... any other suggestions? Gina Shillitani ~~ 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
Accessing Remote Databases
Hi, I'm trying to access a remote datasource but the mapped drive does not show up when I browse initial directories in the CFIDE for ODBC. I've tried certain login rights per Article 175 on Allaire's Support site, but to no avail. Any help is greatly appreciated. CF 4.5.1 MS Access (as ODBC datasource) Andrew Peterson ~~ 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
Disabling the BACK button (again)
There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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
OT: Firewalls
Apologies for OT nature of the question, but I know there's a lot of net admin talent here so I figured it wouldn't hurt to ask. I'm about to recommend one of two firewalls for my network, and I'd appreciate any opinions on them. They are: 3Com OfficeConnect Internet Firewall DMZ; SonicWall XPRS2 Both have DMZ ports, support enough users, have a browser-accessable admin interface, have automatic firmware updates. The SonicWall has site flitering built in, while the 3Com filtering is optional (though this feature is not all that important on this network - security and administrator friendliness are more important ;). I want to put in a firewall with a DMZ port for future web expansion (I'd rather not have to go ask for more money in 6 months for a new firewall with a DMZ...). I've heard positive things about the SonicWall, but the 3Com is half the price, plus I have other 3Com network equipment (that *shouldn't* make a difference, but hey, stranger thins have happened...). Any opinions, alternate products, warnings, etc.? Feel free to reply offlist. Cheers, -- James Mathieson Information Systems Manager The Wildlife Society 5410 Grosvenor Lane Bethesda, MD 20814-2197 PH: 301-897-9770 Fax: 301-530-2471 [EMAIL PROTECTED] http://www.wildlife.org/ -- ~~ 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: Disabling the BACK button (again)
Try setting a cookie or session variable when the form is submitted the first time. In your submission script, look for the cookie or session var - and if it exists, disallow the submission. Dave - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:46 AM Subject: Disabling the BACK button (again) There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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: Firewalls
I purchased the OfficeConnect Internet Firewall DMZ about three months ago when I was setting up my new company. I have been happy with its performance, although the alert logs can be difficult to decrypt for a non-network admin person (me). The setup was very easy and I was up and running in less than 15 minutes. I don't know anything about the SonicWall, but I can give you a pretty decent recommendation of the 3Com product. Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 http://www.prairiesoftdev.com Amateurs practice until they get it right, Experts practice until they can't get it wrong. -Original Message- From: james [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 10:01 To: CF-Talk Subject: OT: Firewalls Apologies for OT nature of the question, but I know there's a lot of net admin talent here so I figured it wouldn't hurt to ask. I'm about to recommend one of two firewalls for my network, and I'd appreciate any opinions on them. They are: 3Com OfficeConnect Internet Firewall DMZ; SonicWall XPRS2 Both have DMZ ports, support enough users, have a browser-accessable admin interface, have automatic firmware updates. The SonicWall has site flitering built in, while the 3Com filtering is optional (though this feature is not all that important on this network - security and administrator friendliness are more important ;). I want to put in a firewall with a DMZ port for future web expansion (I'd rather not have to go ask for more money in 6 months for a new firewall with a DMZ...). I've heard positive things about the SonicWall, but the 3Com is half the price, plus I have other 3Com network equipment (that *shouldn't* make a difference, but hey, stranger thins have happened...). Any opinions, alternate products, warnings, etc.? Feel free to reply offlist. Cheers, -- James Mathieson Information Systems Manager The Wildlife Society 5410 Grosvenor Lane Bethesda, MD 20814-2197 PH: 301-897-9770 Fax: 301-530-2471 [EMAIL PROTECTED] http://www.wildlife.org/ -- ~~ 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
Using Excel COM Object without installing Excel
Does anyone know if one can access the Excel COM object using the CFOBJECT tag without installing the full Excel application on the server? I am wondering if there is just a type library, or a combination of DLLs that can be installed on the server, rather than actually installing Excel. If you have done this, it would be great if you could refer me to any instructions you found regarding the installation. Thanks, Bob ~~ 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: Firewalls
I've got some experience with the Sonicwalls - both the SonicWall XPRS2 and the higher end VX. You get great bang for the buck - they are solid products. But if you need to do anything sophisiticated, like authentication by port, you're going to need something a bit more powerful - like Checkpoint. Regards, Chris - Original Message - From: james [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:01 AM Subject: OT: Firewalls Apologies for OT nature of the question, but I know there's a lot of net admin talent here so I figured it wouldn't hurt to ask. I'm about to recommend one of two firewalls for my network, and I'd appreciate any opinions on them. They are: 3Com OfficeConnect Internet Firewall DMZ; SonicWall XPRS2 Both have DMZ ports, support enough users, have a browser-accessable admin interface, have automatic firmware updates. The SonicWall has site flitering built in, while the 3Com filtering is optional (though this feature is not all that important on this network - security and administrator friendliness are more important ;). I want to put in a firewall with a DMZ port for future web expansion (I'd rather not have to go ask for more money in 6 months for a new firewall with a DMZ...). I've heard positive things about the SonicWall, but the 3Com is half the price, plus I have other 3Com network equipment (that *shouldn't* make a difference, but hey, stranger thins have happened...). Any opinions, alternate products, warnings, etc.? Feel free to reply offlist. Cheers, -- James Mathieson Information Systems Manager The Wildlife Society 5410 Grosvenor Lane Bethesda, MD 20814-2197 PH: 301-897-9770 Fax: 301-530-2471 [EMAIL PROTECTED] http://www.wildlife.org/ -- ~~ 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: Report
Thanks for your mail.
But I am stuck in this query.
++
cfset previousdate= DateAdd(d, -1, now())
cfset previousdate2=#DateFormat
previousdate,mm/dd/yy)#
cfset
previousdate3=#DateFormat(previousdate,mm/dd/)#
cfquery name=report7
datasource=ShoppingCartReport
dbtype=ODBC
SELECT datepart(q,#previousdate3#) As
quarter,sum([Total Orders]) AS TotalOrders,
sum([Total Dollar Amount Of Sales]) AS
TotalDollarAmountOfSales
FROM[Sales Totals By Day]
GROUP BY datepart(q,#previousdate3#)
But this gives me an error.
Is datepart is some thing wich could be used in SQL.
Please help..
Shally.
--- Eric Dawson [EMAIL PROTECTED] wrote:
select datepart(q,somedate) as
quarter,sum(qty),sum(amt)
from sometable
group by datepart(q,somedate)
Should give you a quarterly summary table I I
understand the question
.
Eric
From: Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Report
Date: Fri, 27 Apr 2001 09:52:43 -0400
calculate the cut-off dates thus:
Now()
DateAdd('m',-3,Now())
DateAdd('m',-6,Now()))
etc.,
- Original Message -
From: Shally [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 9:30 AM
Subject: RE: Report
Thanks for your reply.
I am unable to find any proper logic for my
problem.
And well thats the problem:).
I am tried using Quarter function but it only
gives
the the quarter number such as April is in 2nd
quarter.
Please help.
Shally.
--- Chris Maloney [EMAIL PROTECTED] wrote:
Considering you didn't paste any errors that
you
have received with this the
first thing I suggest you do is change the name
of
your date field from
'Date' to something else like 'myDate'. 'Date'
is a
reserved word in SQL and
frequently causes problems because Access will
not
warn you of this when you
are creating a table.
Chris
-Original Message-
From: Shally [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 10:05 AM
To: CF-Talk
Subject: Report
Hi Every one,
I have an access table having 3 fields Date,
Quantity
and Amount.
I am working on a report where I have to
calculate
the
Quantity and Amount on quarterly bases for last
year
and this year.
I tried using the function Quarter but an
unable
to
reach any solution.Please help!!
Thanks in advance
Shally.
~~
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
CF Session IDs?
I have an issue with a template that is called through a cfhttp. The problem is, when it errors and we cf_catch it, the session variables are not available to be emailed to me. Does the CF server maintain an ID system for the sessions it is supporting? If so, is it possible to pull that id out within the session? And then, is it possible to use that id outside of that session to refer to that session and its variables? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ 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: Using Excel COM Object without installing Excel
Are you wanting to create Excel .xls files to be deposited on the server? If you're returning information to the browser where Excel with be engaged, you have other options. Using CFCONTENT, you can return a comma delimited file that will engage Excel and be read by it. You can do this without Excel on the server. Dave - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:10 AM Subject: Using Excel COM Object without installing Excel Does anyone know if one can access the Excel COM object using the CFOBJECT tag without installing the full Excel application on the server? I am wondering if there is just a type library, or a combination of DLLs that can be installed on the server, rather than actually installing Excel. If you have done this, it would be great if you could refer me to any instructions you found regarding the installation. Thanks, Bob ~~ 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: COM/MTS NT/2000 AND CF 4 .vs CF 5
I'm sure there's some sort of a datatype issue. Both vbscript and cfml use variants, but I'm sure there's some differences in how they are passed. Have you tried CFSET strWDDX_Retval = objContact.Add(#strWDDX_Input#) or in your vb code, CStr() your method params. Other than that, it's probably something extra you'll need to do in your vb code, and while it's a CF-related issue, I'm sure people will start throwing their kitchen garbage at yoiu when you start posting VB code to the list : - ) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] zCF Talk wrote: I have a com object that I have created and tested on Windows 2000 using CF v5b3. It works great. Awesome. So I recompile the object on a Windows NT box, and install it on the Windows NT server. ASP can access the object without a hitch, but in the following code snippit, the 'CFSET' fails with the very intuitive Object variable or With block variable not set. How do I go about debugging this application? I know that the object is instantiated, because if I try accessing a method that doesn't exist, I get the following COM error: COM error 0x80020006. Unknown name So how do go about debug this component? It takes and is supposed to return a WDDX packet. CFFILE ACTION=READ FILE=e:\inetpub\sites\membdb\source.xml VARIABLE=strWDDX_Input CFOBJECT TYPE=COM NAME=objContact CLASS=UDB_Contact.Business ACTION=CREATE CFSET strWDDX_Retval = objContact.Add(strWDDX_Input) CFFILE ACTION=WRITE FILE=e:\inetpub\sites\membdb\result.xml OUTPUT=#strWDDX_Retval# ADDNEWLINE=Yes --- Daniel Dewey|Tell me, and I'll forget. Systems Developer | Show me, and I may not remember. MCP (NT srvr/wkstn/eprise) | Involve me, and I'll understand. [EMAIL PROTECTED] | - Native American Proverb http://www.pobox.com/~dewey | 610-868-1421, x115 The National Association of Colleges and Employers These opinions are mine, and may not be the same as my employer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 11:00 AM To: CF-Talk Subject: RE: slightly OT ADO vs DAO You can use either ysntax but you have to add a reference to the ado or dao library in the project in the sam way as you do for a vb project. Go to tools references and choose one or both. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Well, thats what I thought too, to be honest, but a more experienced VBA developer than me said the errors were due to this difference between DAO and ADO. I will try using ADO syntax and see if that works. Thanks for all your input Andy Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:15 To: CF-Talk Subject: RE: slightly OT ADO vs DAO If you are using VBA you should be able to choose which connection method you use without any problem. As far as I can remember the code in the module/class you are creating is separate from the mdb.I'm not sure what you mean when you say in an ADO database. The database is just a database - ADO is purely used as a method of interogating it. As I said earlier - it's been a while since I used Access/VBA so may be way off! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:10 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Cheers Andy, Its just I'm writing some VBA and gettings errors which I think are caused by using DAO syntax in a ADO database, but that doesn't make too much sense to me?? Cheers Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 14:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Yeh I think so. My use of
Re: Javascript Pop-Up Calendar...Thanks!
Glad to help. larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- James Taavon wrote: THANKS, THIS IS JUST WHAT I WAS LOOKING FOR!!! ~~ 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: New CF5 Partner Hosting License
At 09:48 AM 4/27/01, you wrote: Michael, If the UK or other non-US ISPs talked to A/MM, maybe individual deals could be made. If I was at A/MM I'd talk to ISPs on a per company basis and for some wave the fee for a time to 'help get them on their feet'. ISP building is great in the long run but may cost a little in licensing in the short. But that's just me. While this may serve to put some balm on the current wound, it indicates a mindset that, if it comes to pass, will amount to a significant dropoff in the vitality of this community. Waiving the fee for a time is not the issue, it's dealing with the competitive pressures. When crossing paths with micro$oft, one misstep is all it takes... Netscape made that misstep, and never recovered. I'm afraid that if a/MM takes licensing in this direction, they will not recover from that. I know that we will switch to another platform (probably asp) if, in fact this is where the licensing is headed. We've looked forward to the features in CF5 for awhile now, but it is just not going to be a viable alternative if a/MM goes down this road. ~~ 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: List Functions
Hi Robert, Thanks for the tip, but it didn't work. The server can't figure out what theLoop is I get : Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #listgetat(theloop,i)# Error near line 42, column 95. Error resolving parameter THELOOP ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: -You have misspelled the parameter name, or -You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#listgetat(theloop,i)#), occupying document position (42:94) to (42:115) in the template file /opt/coldfusion/CustomTags/bestbets/rTreelw.cfm Any clues? Thanks in advance - I'm still stumped. Loryn Robert Segal wrote: Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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: Disabling the BACK button (again)
Using JavaScript reduces the load on the server and is more effective. http://javascript.internet.com/forms/disable-submit.html HTH Regards, Rob --- Dave Hannum [EMAIL PROTECTED] wrote: Try setting a cookie or session variable when the form is submitted the first time. In your submission script, look for the cookie or session var - and if it exists, disallow the submission. Dave - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:46 AM Subject: Disabling the BACK button (again) There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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: Firewalls
I highly recommend the WatchGuard Firebox II. http://www.cdw.com/shop/products/default.asp?EDC=125111 Tony Gruen -Original Message- From: Chris Michl [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 8:20 AM To: CF-Talk Subject: Re: Firewalls I've got some experience with the Sonicwalls - both the SonicWall XPRS2 and the higher end VX. You get great bang for the buck - they are solid products. But if you need to do anything sophisiticated, like authentication by port, you're going to need something a bit more powerful - like Checkpoint. Regards, Chris - Original Message - From: james [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:01 AM Subject: OT: Firewalls Apologies for OT nature of the question, but I know there's a lot of net admin talent here so I figured it wouldn't hurt to ask. I'm about to recommend one of two firewalls for my network, and I'd appreciate any opinions on them. They are: 3Com OfficeConnect Internet Firewall DMZ; SonicWall XPRS2 Both have DMZ ports, support enough users, have a browser-accessable admin interface, have automatic firmware updates. The SonicWall has site flitering built in, while the 3Com filtering is optional (though this feature is not all that important on this network - security and administrator friendliness are more important ;). I want to put in a firewall with a DMZ port for future web expansion (I'd rather not have to go ask for more money in 6 months for a new firewall with a DMZ...). I've heard positive things about the SonicWall, but the 3Com is half the price, plus I have other 3Com network equipment (that *shouldn't* make a difference, but hey, stranger thins have happened...). Any opinions, alternate products, warnings, etc.? Feel free to reply offlist. Cheers, -- James Mathieson Information Systems Manager The Wildlife Society 5410 Grosvenor Lane Bethesda, MD 20814-2197 PH: 301-897-9770 Fax: 301-530-2471 [EMAIL PROTECTED] http://www.wildlife.org/ -- ~~ 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 Session IDs?
Lon, Yes, the server automatically produces the CFID and CFToken variables for each user. You do need to code your application.cfm accordingly to take advantage of them. But, if you want to come back and access these variables at a later date, you would be better off setting client variables and store them in a backend database. HTH Regards, Rusher --- Lon Lentz [EMAIL PROTECTED] wrote: I have an issue with a template that is called through a cfhttp. The problem is, when it errors and we cf_catch it, the session variables are not available to be emailed to me. Does the CF server maintain an ID system for the sessions it is supporting? If so, is it possible to pull that id out within the session? And then, is it possible to use that id outside of that session to refer to that session and its variables? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ 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: Disabling the BACK button (again)
qForms automatically disables a submission from occuring when a click-happy user keeps trying to submit a form: http://www.pengoworks.com/qForms/ -Dan -Original Message- From: Robert Rusher [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:54 AM To: CF-Talk Subject: Re: Disabling the BACK button (again) Using JavaScript reduces the load on the server and is more effective. http://javascript.internet.com/forms/disable-submit.html HTH Regards, Rob --- Dave Hannum [EMAIL PROTECTED] wrote: Try setting a cookie or session variable when the form is submitted the first time. In your submission script, look for the cookie or session var - and if it exists, disallow the submission. Dave - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:46 AM Subject: Disabling the BACK button (again) There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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: List Functions
You need to make a slight change: instead of looping the number of items in the list, why not loop through the list itself? cfloop list=#thelist# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#i#;#i#/a /cfouput /cfloop --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: L Williams [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 16:53 To: CF-Talk Subject: Re: List Functions Hi Robert, Thanks for the tip, but it didn't work. The server can't figure out what theLoop is I get : Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #listgetat(theloop,i)# Error near line 42, column 95. Error resolving parameter THELOOP ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: -You have misspelled the parameter name, or -You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#listgetat(theloop,i)#), occupying document position (42:94) to (42:115) in the template file /opt/coldfusion/CustomTags/bestbets/rTreelw.cfm Any clues? Thanks in advance - I'm still stumped. Loryn Robert Segal wrote: Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listge tat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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: Disabling the BACK button (again)
Using JavaScript reduces the load on the server and is more effective. Until Javascript is turned off, at which stage you're back to square 1. Tracking the page requests on the server is a better id if you really need to be sure that the form hasn't been reposted. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Robert Rusher [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 16:54 To: CF-Talk Subject: Re: Disabling the BACK button (again) Using JavaScript reduces the load on the server and is more effective. http://javascript.internet.com/forms/disable-submit.html HTH Regards, Rob --- Dave Hannum [EMAIL PROTECTED] wrote: Try setting a cookie or session variable when the form is submitted the first time. In your submission script, look for the cookie or session var - and if it exists, disallow the submission. Dave - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:46 AM Subject: Disabling the BACK button (again) There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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: List Functions
Your cfloop should be like this.. cfloop index=i list=#thelist# delimiters=- cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Robert -Original Message- From: L Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 10:53 AM To: CF-Talk Subject: Re: List Functions Hi Robert, Thanks for the tip, but it didn't work. The server can't figure out what theLoop is I get : Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #listgetat(theloop,i)# Error near line 42, column 95. Error resolving parameter THELOOP ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: -You have misspelled the parameter name, or -You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#listgetat(theloop,i)#), occupying document position (42:94) to (42:115) in the template file /opt/coldfusion/CustomTags/bestbets/rTreelw.cfm Any clues? Thanks in advance - I'm still stumped. Loryn Robert Segal wrote: Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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: Disabling the BACK button (again)
Not if it does not work reliably . . . 8-) Dave - Original Message - From: Robert Rusher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:54 AM Subject: Re: Disabling the BACK button (again) Using JavaScript reduces the load on the server and is more effective. http://javascript.internet.com/forms/disable-submit.html HTH Regards, Rob --- Dave Hannum [EMAIL PROTECTED] wrote: Try setting a cookie or session variable when the form is submitted the first time. In your submission script, look for the cookie or session var - and if it exists, disallow the submission. Dave - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:46 AM Subject: Disabling the BACK button (again) There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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: List Functions
change theLoop to theList -Original Message- From: L Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 10:53 AM To: CF-Talk Subject: Re: List Functions Hi Robert, Thanks for the tip, but it didn't work. The server can't figure out what theLoop is I get : Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #listgetat(theloop,i)# Error near line 42, column 95. Error resolving parameter THELOOP ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: -You have misspelled the parameter name, or -You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#listgetat(theloop,i)#), occupying document position (42:94) to (42:115) in the template file /opt/coldfusion/CustomTags/bestbets/rTreelw.cfm Any clues? Thanks in advance - I'm still stumped. Loryn Robert Segal wrote: Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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: List Functions
cfloop list=#theList# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#i##i#/a /cfouput /cfloop - Original Message - From: L Williams [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:53 AM Subject: Re: List Functions Hi Robert, Thanks for the tip, but it didn't work. The server can't figure out what theLoop is I get : Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #listgetat(theloop,i)# Error near line 42, column 95. Error resolving parameter THELOOP ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: -You have misspelled the parameter name, or -You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#listgetat(theloop,i)#), occupying document position (42:94) to (42:115) in the template file /opt/coldfusion/CustomTags/bestbets/rTreelw.cfm Any clues? Thanks in advance - I'm still stumped. Loryn Robert Segal wrote: Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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: New CF5 Partner Hosting License
MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can´t run a business competing with free open source software, and the equally free MS security blanket. I remember Jeremy, I think, saying if you can´t get your tools adopted by the corps, strategically, you´re dead. He didn´t say anything about CF hosting shops. Len http://MenAndMice.com/DNS-training : Austin,TX: SFO,CA; 7,8 May http://BIND8NT.MEIway.com : ISC BIND 8.2.3 NT3 for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways ~~ 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: Disabling the BACK button (again)[javascript]
I could not get this javascript to work, at least within a CFFORM and a CFINCLUDE. just an FYI. -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 9:09 AM To: CF-Talk Subject: Re: Disabling the BACK button (again) Not if it does not work reliably . . . 8-) Dave - Original Message - From: Robert Rusher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:54 AM Subject: Re: Disabling the BACK button (again) Using JavaScript reduces the load on the server and is more effective. http://javascript.internet.com/forms/disable-submit.html HTH Regards, Rob --- Dave Hannum [EMAIL PROTECTED] wrote: Try setting a cookie or session variable when the form is submitted the first time. In your submission script, look for the cookie or session var - and if it exists, disallow the submission. Dave - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:46 AM Subject: Disabling the BACK button (again) There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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: SQL2000 server not recognized by CF 4.5
Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ 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: COM/MTS NT/2000 AND CF 4 .vs CF 5
Billy -- Thanks... I know that there are a lot of CF purists out there, so I'll deal with the flak. The object kinda works. When first called, I get the Object variable or With block variable not set error. If you hit reload, same problem. But if you wait a few minutes, and then hit reload, it works. I really don't know where to turn, and since it works in VB/ASP, I can't call Microsoft. The server config is pretty clean/stable: Version 4, 5, 1, SP2 Edition Enterprise Operating System Windows NT OS Version 4.0, Service Pack 5 OS Build Number 1381 The VB function is rather simple: Public Function Add(ByVal spacket As String) As String end function The ASP code that calls the function is simple too, and never fails: % set oObj = server.createobject(UDB_Contact.Business) strResult = oObj.add(strSource) % The CF code should work the same way, or so I thought: CFOBJECT TYPE=COM NAME=objContact CLASS=UDB_Contact.Business ACTION=CREATE CFSET strWDDX_Retval = objContact.Add(strWDDX_Input) --- Daniel Dewey|Tell me, and I'll forget. Systems Developer | Show me, and I may not remember. MCP (NT srvr/wkstn/eprise) | Involve me, and I'll understand. [EMAIL PROTECTED] | - Native American Proverb http://www.pobox.com/~dewey | 610-868-1421, x115 The National Association of Colleges and Employers These opinions are mine, and may not be the same as my employer -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:27 AM To: CF-Talk Subject: Re: COM/MTS NT/2000 AND CF 4 .vs CF 5 I'm sure there's some sort of a datatype issue. Both vbscript and cfml use variants, but I'm sure there's some differences in how they are passed. Have you tried CFSET strWDDX_Retval = objContact.Add(#strWDDX_Input#) or in your vb code, CStr() your method params. Other than that, it's probably something extra you'll need to do in your vb code, and while it's a CF-related issue, I'm sure people will start throwing their kitchen garbage at yoiu when you start posting VB code to the list : - ) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] zCF Talk wrote: I have a com object that I have created and tested on Windows 2000 using CF v5b3. It works great. Awesome. So I recompile the object on a Windows NT box, and install it on the Windows NT server. ASP can access the object without a hitch, but in the following code snippit, the 'CFSET' fails with the very intuitive Object variable or With block variable not set. How do I go about debugging this application? I know that the object is instantiated, because if I try accessing a method that doesn't exist, I get the following COM error: COM error 0x80020006. Unknown name So how do go about debug this component? It takes and is supposed to return a WDDX packet. CFFILE ACTION=READ FILE=e:\inetpub\sites\membdb\source.xml VARIABLE=strWDDX_Input CFOBJECT TYPE=COM NAME=objContact CLASS=UDB_Contact.Business ACTION=CREATE CFSET strWDDX_Retval = objContact.Add(strWDDX_Input) CFFILE ACTION=WRITE FILE=e:\inetpub\sites\membdb\result.xml OUTPUT=#strWDDX_Retval# ADDNEWLINE=Yes --- Daniel Dewey|Tell me, and I'll forget. Systems Developer | Show me, and I may not remember. MCP (NT srvr/wkstn/eprise) | Involve me, and I'll understand. [EMAIL PROTECTED] | - Native American Proverb http://www.pobox.com/~dewey | 610-868-1421, x115 The National Association of Colleges and Employers These opinions are mine, and may not be the same as my employer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 11:00 AM To: CF-Talk Subject: RE: slightly OT ADO vs DAO You can use either ysntax but you have to add a reference to the ado or dao library in the project in the sam way as you do for a vb project. Go to tools references and choose one or both. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:41 To: CF-Talk Subject: RE: slightly OT ADO vs DAO Well, thats what I thought too, to be honest, but a more experienced VBA developer than me said the errors were due to this difference between DAO and ADO. I will try using ADO syntax and see if that works. Thanks for all your input Andy Will -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:15 To: CF-Talk Subject: RE: slightly OT ADO vs DAO If you are using VBA you should be able to choose which connection method you use without any problem. As far as I can remember the code in the module/class you are creating is separate from the mdb.I'm not sure what you mean when you say in an ADO database. The database is just a database - ADO is purely used as a
RE: Using Excel COM Object without installing Excel
No. I need to take an excel file, open it, and save it as a text file. Thanks, Bob -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: April 27, 2001 11:24 AM To: CF-Talk Subject: Re: Using Excel COM Object without installing Excel Are you wanting to create Excel .xls files to be deposited on the server? If you're returning information to the browser where Excel with be engaged, you have other options. Using CFCONTENT, you can return a comma delimited file that will engage Excel and be read by it. You can do this without Excel on the server. Dave - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:10 AM Subject: Using Excel COM Object without installing Excel Does anyone know if one can access the Excel COM object using the CFOBJECT tag without installing the full Excel application on the server? I am wondering if there is just a type library, or a combination of DLLs that can be installed on the server, rather than actually installing Excel. If you have done this, it would be great if you could refer me to any instructions you found regarding the installation. Thanks, Bob ~~ 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: Disabling the BACK button (again)
Another way is to pass your variables through a popup window. I posted a code snippet a week or so ago. E-mail me if you need more details on this approach. Lonny Eckert Hesta Corporation [EMAIL PROTECTED] Hesta 610-230-2500 x147 ~~ 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: New CF5 Partner Hosting License
I really can't see A/MM abandoning us. Think about it, every author (with the exception of a few that they have in house) are in the low end. Every person who runs a community site is in the low end. With very few exceptions, every person who made CF what it is today is in the low end. They HAVE to know that abandoning us (and yes, I'm definitely in the low end as well) will only result in the death of CF. There's no chance in hell they're going to do that. Even if they're positioning CF for the upmarket they'll have to take care of us. Either that or just drop CF. MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can´t run a business competing with free open source software, and the equally free MS security blanket. I remember Jeremy, I think, saying if you can´t get your tools adopted by the corps, strategically, you´re dead. He didn´t say anything about CF hosting shops. Len http://MenAndMice.com/DNS-training : Austin,TX: SFO,CA; 7,8 May http://BIND8NT.MEIway.com : ISC BIND 8.2.3 NT3 for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways ~~ 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: Disabling the BACK button (again)
I should have said. As a first line of defense. 8^) If you can catch it before it gets to the server, you will improve server performance. Regards, Rusher --- Dave Hannum [EMAIL PROTECTED] wrote: Not if it does not work reliably . . . 8-) Dave - Original Message - From: Robert Rusher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:54 AM Subject: Re: Disabling the BACK button (again) Using JavaScript reduces the load on the server and is more effective. http://javascript.internet.com/forms/disable-submit.html HTH Regards, Rob --- Dave Hannum [EMAIL PROTECTED] wrote: Try setting a cookie or session variable when the form is submitted the first time. In your submission script, look for the cookie or session var - and if it exists, disallow the submission. Dave - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 10:46 AM Subject: Disabling the BACK button (again) There must be a zillion messages on this topic. Sorry to bring it up again. But, you know, it's not a problem until it is YOUR problem. Any recent developments on disabling the BACK button to avoid duplicate form submissions/charges? Rick Colman ~~ 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: Disabling the BACK button (again)
Do you have example code where this was integrated into a CF webpage where the values of certain form fields were dynamic? e.g. #country# etc.? Is it also a simple POST to the next page where the standard form.firstname form.lastname could be grabbed and stuck in a daatabase? -Gel -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]] qForms automatically disables a submission from occuring when a click-happy user keeps trying to submit a form: http://www.pengoworks.com/qForms/ -Dan ~~ 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: New CF5 Partner Hosting License
MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can´t run a business competing with free open source software, and the equally free MS security blanket. And where would that leave smaller developers? Out in the cold or suddenly finding themselves having to learn PHP? ~~ 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: New CF5 Partner Hosting License
I don't think I can agree with that statement. Everything we've heard from A/MM so far points the opposite. MM has made it's mark with lower end applications. Even UltraDev is only a $500+ product. Supposedly, they dropped Spectra because it was too high of a dollar tag for their focus. I think we just need to see the details before we all jump to conclusions. Everything we've seen says that MM has a true commitment to CF. Dave - Original Message - From: Len Conrad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 7:27 AM Subject: RE: New CF5 Partner Hosting License MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can´t run a business competing with free open source software, and the equally free MS security blanket. I remember Jeremy, I think, saying if you can´t get your tools adopted by the corps, strategically, you´re dead. He didn´t say anything about CF hosting shops. Len ~~ 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: New CF5 Partner Hosting License
At 07:27 AM 4/27/01, you wrote: Len, I certainly can't fault them on principle if this is their approach.. Whether or not this is a valid revenue model remains to be seen. From my perspective (which is different than most g), each developer needs to decide whether this fits THEIR business model.. I'm afraid without a critical mass of lower end stuff, there will be no energy base upon which to have and develop a brand name and a viable community. and it certainly doesn't fit OUR business model. I'm about as anti-m$ as you can get, but i'm ready to jump ship to asp if this comes to pass. I used to use webboard many years ago, but switched to IIS when our business model and approach dictated it. MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can´t run a business competing with free open source software, and the equally free MS security blanket. I remember Jeremy, I think, saying if you can´t get your tools adopted by the corps, strategically, you´re dead. He didn´t say anything about CF hosting shops. Len http://MenAndMice.com/DNS-training : Austin,TX: SFO,CA; 7,8 May http://BIND8NT.MEIway.com : ISC BIND 8.2.3 NT3 for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways ~~ 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
OT: JS Input Mask for textbox
Forgive the off topic post, but this is for a cf app, so Ithought you folks wouldn't mind. Has anyone written an input mask in javascript utilizing the onkeydown/onkeyup events, so that as the user is typing a value into a text box, the value is formatted correctly. For example entering a U.S. phone number, as they type in the area code a hyphen would appear after the third character, then another hypen would appear after the seventh character so as they type the number 55, the hyphens would automatically be thrown in resulting in 555-555-. I'd rather not re-invent the wheel if I don't have too, so if there is something like this that has already been done, I'd love to see it, or if someone has any ideas or can point me in the right direction I'd be most appreciative. Most everything I've seen so far, validates against a mask after the form has been submitted, I'd like to implement the mask at the time the values are being typed in, much like the input mask functionality in MS Access or in VB apps. BTW, if this topic has been here before, and you are annoyed by it, please contact me off-list so I can supply you with my home phone number so that you can scream invectives at me. Thanks in advance. Michael ~~ 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: SQL2000 server not recognized by CF 4.5
What I have heard from a number of very knowledgeable SQL Server DBAs is that SQL7 runs better on NT4 than SQL2000. If you're on Windows 2000, SQL2000 performs better than SQL7. Bob -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: April 27, 2001 12:39 PM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ 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 Session IDs?
We are currently using CFID and CFToken for session management purposes. What I would like to be able to do is to access session variables outside of that session. We have worked a way around this whch requires serializing and then deserializing our 2 main session variables. This requires more overhead and time than I would like to spend. So I am trying to find a shortcut. And I thought if CF uses an internal id system for sessions, we might be able to reference them that way. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Robert Rusher [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 12:03 PM To: CF-Talk Subject: Re: CF Session IDs? Lon, Yes, the server automatically produces the CFID and CFToken variables for each user. You do need to code your application.cfm accordingly to take advantage of them. But, if you want to come back and access these variables at a later date, you would be better off setting client variables and store them in a backend database. HTH Regards, Rusher ~~ 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: New CF5 Partner Hosting License
Don't panic yet. I believe a FAQ is in the works that will explain all this. Stay tuned. --- Ben Forta -Original Message- From: Zac [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 1:08 PM To: CF-Talk Subject: RE: New CF5 Partner Hosting License MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can?t run a business competing with free open source software, and the equally free MS security blanket. And where would that leave smaller developers? Out in the cold or suddenly finding themselves having to learn PHP? ~~ 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: New CF5 Partner Hosting License
Let me preface this by saying that it isn't meant as a comment about Macromedia but is a general comment They HAVE to know that abandoning us (and yes, I'm definitely in the low end as well) will only result in the death of CF. Publicly held software companies are beholden to their shareholders and the bottom line. If the management of the company thinks that they can make more money in a process that eliminates 90% of their small scale developers they will do it. No question. If the idea is sound in the long term is another matter entirely. And I think you can look at the history of software development firms to see that foresight and long-term planning are not necessarily skills that the management of software companies have in excess. ~~ 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: Using Excel COM Object without installing Excel
Then use the excel file as a data source in a query, then write it back out to a text file. Dave - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 12:39 PM Subject: RE: Using Excel COM Object without installing Excel No. I need to take an excel file, open it, and save it as a text file. Thanks, Bob -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: April 27, 2001 11:24 AM To: CF-Talk Subject: Re: Using Excel COM Object without installing Excel Are you wanting to create Excel .xls files to be deposited on the server? If you're returning information to the browser where Excel with be engaged, you have other options. Using CFCONTENT, you can return a comma delimited file that will engage Excel and be read by it. You can do this without Excel on the server. Dave - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:10 AM Subject: Using Excel COM Object without installing Excel Does anyone know if one can access the Excel COM object using the CFOBJECT tag without installing the full Excel application on the server? I am wondering if there is just a type library, or a combination of DLLs that can be installed on the server, rather than actually installing Excel. If you have done this, it would be great if you could refer me to any instructions you found regarding the installation. Thanks, Bob ~~ 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: JS Input Mask for textbox
Michael, qForms won't do it on a key press, but it will do it onBlur--which is going to be a much more compatible method. qForms: http://www.pengoworks.com/qForms/ -Dan -Original Message- From: Mike Morris [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 1:34 PM To: CF-Talk Subject: OT: JS Input Mask for textbox Forgive the off topic post, but this is for a cf app, so Ithought you folks wouldn't mind. Has anyone written an input mask in javascript utilizing the onkeydown/onkeyup events, so that as the user is typing a value into a text box, the value is formatted correctly. For example entering a U.S. phone number, as they type in the area code a hyphen would appear after the third character, then another hypen would appear after the seventh character so as they type the number 55, the hyphens would automatically be thrown in resulting in 555-555-. I'd rather not re-invent the wheel if I don't have too, so if there is something like this that has already been done, I'd love to see it, or if someone has any ideas or can point me in the right direction I'd be most appreciative. Most everything I've seen so far, validates against a mask after the form has been submitted, I'd like to implement the mask at the time the values are being typed in, much like the input mask functionality in MS Access or in VB apps. BTW, if this topic has been here before, and you are annoyed by it, please contact me off-list so I can supply you with my home phone number so that you can scream invectives at me. Thanks in advance. Michael ~~ 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: Report
datepart is SQL
In your stmt
datepart(q,#previousdate3#)
#previousdate3# should refer to a table field not a date value, so I am a
little confused as to what you are trying to do with the query.
But in a little more detail here is the SQL in action.
Data: sometable
SomeDateQty Amt
01 Jan 2000 10 10.00
01 Mar 2000 10 20.00
01 May 2000 10 30.00
01 Jul 2000 10 40.00
01 Sep 2000 10 50.00
01 Nov 2000 10 60.00
01 Dec 2000 10 70.00
my query:
select datepart(q,SomeDate) as Qrt, sum(qty), sum(amt)
from sometable
group by datepart(q,SomeDate)
will return the dataset
Qrt SumQty SumAmt
1 20 30.00
2 10 30.00
3 20 90.00
4 20 130.00
Not sure if I understand what you want to do.
Eric
From: Shally [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Report
Date: Fri, 27 Apr 2001 08:18:22 -0700 (PDT)
Thanks for your mail.
But I am stuck in this query.
++
cfset previousdate= DateAdd(d, -1, now())
cfset previousdate2=#DateFormat
previousdate,mm/dd/yy)#
cfset
previousdate3=#DateFormat(previousdate,mm/dd/)#
cfquery name=report7
datasource=ShoppingCartReport
dbtype=ODBC
SELECT datepart(q,#previousdate3#) As
quarter,sum([Total Orders]) AS TotalOrders,
sum([Total Dollar Amount Of Sales]) AS
TotalDollarAmountOfSales
FROM[Sales Totals By Day]
GROUP BY datepart(q,#previousdate3#)
But this gives me an error.
Is datepart is some thing wich could be used in SQL.
Please help..
Shally.
--- Eric Dawson [EMAIL PROTECTED] wrote:
select datepart(q,somedate) as
quarter,sum(qty),sum(amt)
from sometable
group by datepart(q,somedate)
Should give you a quarterly summary table I I
understand the question
.
Eric
From: Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Report
Date: Fri, 27 Apr 2001 09:52:43 -0400
calculate the cut-off dates thus:
Now()
DateAdd('m',-3,Now())
DateAdd('m',-6,Now()))
etc.,
- Original Message -
From: Shally [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 9:30 AM
Subject: RE: Report
Thanks for your reply.
I am unable to find any proper logic for my
problem.
And well thats the problem:).
I am tried using Quarter function but it only
gives
the the quarter number such as April is in 2nd
quarter.
Please help.
Shally.
--- Chris Maloney [EMAIL PROTECTED] wrote:
Considering you didn't paste any errors that
you
have received with this the
first thing I suggest you do is change the name
of
your date field from
'Date' to something else like 'myDate'. 'Date'
is a
reserved word in SQL and
frequently causes problems because Access will
not
warn you of this when you
are creating a table.
Chris
-Original Message-
From: Shally [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 10:05 AM
To: CF-Talk
Subject: Report
Hi Every one,
I have an access table having 3 fields Date,
Quantity
and Amount.
I am working on a report where I have to
calculate
the
Quantity and Amount on quarterly bases for last
year
and this year.
I tried using the function Quarter but an
unable
to
reach any solution.Please help!!
~~
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: Using Excel COM Object without installing Excel
or create an HTML file and set the mime type to excel. (works pretty slick). From: Dave Hannum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Using Excel COM Object without installing Excel Date: Fri, 27 Apr 2001 11:24:13 -0400 Are you wanting to create Excel .xls files to be deposited on the server? If you're returning information to the browser where Excel with be engaged, you have other options. Using CFCONTENT, you can return a comma delimited file that will engage Excel and be read by it. You can do this without Excel on the server. Dave - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:10 AM Subject: Using Excel COM Object without installing Excel Does anyone know if one can access the Excel COM object using the CFOBJECT tag without installing the full Excel application on the server? I am wondering if there is just a type library, or a combination of DLLs that can be installed on the server, rather than actually installing Excel. If you have done this, it would be great if you could refer me to any instructions you found regarding the installation. Thanks, Bob ~~ 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: List Functions
oops, shouldn't have copied and pasted... It should be cfloop index=i list=#thelist# delimiters=- cfoutput a href=http://www.domain.com/search_children.cfm?parent=#i#;#i#/a /cfouput /cfloop Sorry, Robert -Original Message- From: Robert Long [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:11 AM To: CF-Talk Subject: RE: List Functions Your cfloop should be like this.. cfloop index=i list=#thelist# delimiters=- cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Robert -Original Message- From: L Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 10:53 AM To: CF-Talk Subject: Re: List Functions Hi Robert, Thanks for the tip, but it didn't work. The server can't figure out what theLoop is I get : Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #listgetat(theloop,i)# Error near line 42, column 95. Error resolving parameter THELOOP ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: -You have misspelled the parameter name, or -You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#listgetat(theloop,i)#), occupying document position (42:94) to (42:115) in the template file /opt/coldfusion/CustomTags/bestbets/rTreelw.cfm Any clues? Thanks in advance - I'm still stumped. Loryn Robert Segal wrote: Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ 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: New CF5 Partner Hosting License
At 01:35 PM 4/27/01, you wrote: Yet ??? gg Don't panic yet. I believe a FAQ is in the works that will explain all this. that's good news... ~~ 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: New CF5 Partner Hosting License
And where would that leave smaller developers? If the smaller developers aren´t worth their cost of sales, then, yes ... Out in the cold and you don´t make significant money selling CF software, but from your CF apps and support contract revenue, none of which goes back to MM. Of course, the other shoe will drop, which will be software renting, time-limited product activation codes, since that´s where MS is officially going, sooner rather than later. Let´s not get emotional about it, it´s the brutal face of business. Remember, as long as one can do it in the name of (moral) religion or (amoral) business, you can do anything. :)) Len http://MenAndMice.com/DNS-training : Austin,TX: SFO,CA; 7,8 May http://BIND8NT.MEIway.com : ISC BIND 8.2.3 NT3 for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways ~~ 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: New CF5 Partner Hosting License
Do let us know when the FAQ is ready so we can begin panicking. ;-) In the mean time, that's for helping calm our fears. -- Hans Omli -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 10:35 AM To: CF-Talk Subject: RE: New CF5 Partner Hosting License Don't panic yet. I believe a FAQ is in the works that will explain all this. Stay tuned. --- Ben Forta -Original Message- From: Zac [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 1:08 PM To: CF-Talk Subject: RE: New CF5 Partner Hosting License MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can?t run a business competing with free open source software, and the equally free MS security blanket. And where would that leave smaller developers? Out in the cold or suddenly finding themselves having to learn PHP? ~~ 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
send html page using CFMAIL
I am working on a web page in which there is a send this page to your friend feature. If there is anyone who had worked on this before please give me some idea how it can be done with CFMAIL. My coding in the action page is like : cfmail From=#form.sender# to=#Form.Email# subject=#Form.message#, type=HTML /cfmail * but i am wondering where i should put the sent page information so the email will have that particular page embedded in it. thank to all of you. -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.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
storing client variables in MS SQL
Is there a sample table structure available to be able to create a table on MS SQL when moving the client variables storage to a database from the registry? I've found lots on information on how to do it mechanically (in CF Administrator) but no technical details with table setup. Thanks! Mark ~~ 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: New CF5 Partner Hosting License
- Original Message - From: Angél Stewart [EMAIL PROTECTED] Sent: Friday, April 27, 2001 12:16 PM Correct..especially for Off Shore development such as what I do here in Trinidad. Our net connections can't support an INternational Website, so we HAVE to host on shared servers abroad like Hostpro.net or CFHOSTING etc. Same here in the Isle of Man - we it's all about the offshore industry and offshore hosting, and everyone except us is developing in ASP. I suspect that there must be alot of marginal situations like here, where it won't take much to go to ASP which is universally supported at no incremental cost. Adrian Cooper. ~~ 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: New CF5 Partner Hosting License
- Original Message - From: Ben Forta [EMAIL PROTECTED] Sent: Friday, April 27, 2001 6:35 PM Don't panic yet. I believe a FAQ is in the works that will explain all this. Stay tuned. Well I hope they publish it quickly. I hear that Amazon are suddenly doing a roaring trade in teach yourself ASP and PHP books :-) Adrian Cooper. ~~ 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
CFMAIL weirdness/mutant email/not related to bulk email delivery
Hello all, Any input you may have on this problem will be greatly appreciated. I have been experiencing some very strange behavior on the part of CFMAIL lately. Our CF app sends 2 different notifications to 2 different recipients when a user performs certain actions. Each CFMAIL tag resides in a separate customtag, and they are executed one after another. The symptoms are: 1) Mails occasionally being sent to the incorrect recipient. The header in the Email contains the correct recipient address, but the email is actually delivered to someone else. 2) From the previously mentioned 2 email notifications: part of the first notification, and the entire header+body of the second notification are concatenated into a single, mutant email. The intended recipient of the second email does not receive the mutant email (that address does not appear in the log files). The web servers are rarely at maximum utilization, and the emails are generated at a slow, but steady rate (~2 emails once every few minutes). There are no errors thrown, and the log files are not particularly helpful since although I know an email was sent, it is difficult to determine whether it was sent to the correct recipient or not, as well as whether or not the email was one of the mutants. For your viewing pleasure, I have included the body of one of the mutant emails. *** From: [EMAIL PROTECTED] To: undisclosed-recipients: Sent: Saturday, April 21, 2001 10:10 PM ollowing URL: http://xxx.xxx.com/url/url.cfm contentcontentcontentcontentcontentcontentcontent contentcontentcontentcontentcontentcontentcontent contentcontentcontentcontentcontentcontentcontent . RSET RSET MAIL FROM:[EMAIL PROTECTED] RCPT TO:[EMAIL PROTECTED] DATA Content-type: text/html Date: Sat, 21 Apr 2001 22:09:28 -0400 From: [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Subject: Notification To: [EMAIL PROTECTED] (this is the body of the email that should go to the customer) contentcontentcontentcontentcontentcontentcontent contentcontentcontentcontentcontentcontentcontent contentcontentcontentcontentcontentcontentcontent *** As you can see, the first part of the first email has been lost, and the second email has been appended to what is left of the first email. Has anyone ever experienced anything similar? Thanks, everyone! Tai U ? developer ? Mindseye Inc ? [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: JS Input Mask for textbox
Hmmm...see if this is what you're talking about. http://members.aol.com/grassblad/html/maskFone2.html I've used it to do just what you're talking about. And if I'm not mistaken, there will be a couple of versions of this idea at that site; see which one you like best. There's some other goodies there, too. HTH, Matthew -Original Message- From: Mike Morris [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 12:34 PM To: CF-Talk Subject: OT: JS Input Mask for textbox Has anyone written an input mask in javascript utilizing the onkeydown/onkeyup events, so that as the user is typing a value into a text box, the value is formatted correctly. For example entering a U.S. phone number, as they type in the area code a hyphen would appear after the third character, then another hypen would appear after the seventh character so as they type the number 55, the hyphens would automatically be thrown in resulting in 555-555-. ~~ 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: Using Excel COM Object without installing Excel
Thanks for the suggestion, but it seems to me that that would involve a lot more processing (ODBC to read each record, CF to write each record back out to a file) than simply opening the file with Excel and saving it as a text file. We could be talking about thousands of records in this file, and I don't think that CF is all that efficient at writing text files. I've got the whole system working, and I can install Excel on the server if necessary, but I'm just trying to find out whether it's possible to do it (use the Excel COM object), without installing the whole shebang. Thanks, Bob -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: April 27, 2001 1:50 PM To: CF-Talk Subject: Re: Using Excel COM Object without installing Excel Then use the excel file as a data source in a query, then write it back out to a text file. Dave - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 12:39 PM Subject: RE: Using Excel COM Object without installing Excel No. I need to take an excel file, open it, and save it as a text file. Thanks, Bob -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: April 27, 2001 11:24 AM To: CF-Talk Subject: Re: Using Excel COM Object without installing Excel Are you wanting to create Excel .xls files to be deposited on the server? If you're returning information to the browser where Excel with be engaged, you have other options. Using CFCONTENT, you can return a comma delimited file that will engage Excel and be read by it. You can do this without Excel on the server. Dave - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:10 AM Subject: Using Excel COM Object without installing Excel Does anyone know if one can access the Excel COM object using the CFOBJECT tag without installing the full Excel application on the server? I am wondering if there is just a type library, or a combination of DLLs that can be installed on the server, rather than actually installing Excel. If you have done this, it would be great if you could refer me to any instructions you found regarding the installation. Thanks, Bob ~~ 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
evaluate(), single ', a SQL insert
Hey everyone;
Again - my mind is mush this week (hurray for sleeping in on a Saturday). Anyways -
The problem is the SQL chokes because of ' characters in a form field I'm passing to
it. Normally I can work with this, but because I'm doing a call against a dynamically
generated variable, it keeps hacking on me.
Here's code:
CFOUTPUT query=Questions_List
CFSET findmatch = num#questions_list.QuestionID#
CFSET findvalue = form.num#questions_list.QuestionID#
CFIF #isdefined(findmatch)#
CFquery Datasource=#AppPDS#
Insert INTO QuestionResponse
(ConsultantID, QuestionID, Response, QuestionnaireResponseID)
Values
('#szCandidateID#', '#Questions_List.QuestionID#', '#evaluate(findvalue)#',
'#New_ID.newnumber#')
/cfquery
/cfif
/cfoutput
As you can see, I'm doing a dynamic check against a variety of form.fields that may or
may not be returned. So when inserting into the Response field, I have(?) to run an
evaluate. This evaluate returns the data (text) that sometimes includes the '
character. When it does, the insert statement hacks and dies.
How can I adjust the SQL (or something else) to get around this problem? Any
suggestions? I totally appreciate any and all assistance on this issue.
Stephen R. Cassady
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: New CF5 Partner Hosting License
I agree, they also recently changed the price for Generator making it quite affordable and now available for multiple domains as well... I would wait to see every details of the new price policy before making any comment. Macromedia's move on Generator actually goes on the opposite direction, since they failed to target the high end market, they are going back to their traditional low end customers PS I am learning PHP anyway, who know :-) Massimo Foti [EMAIL PROTECTED] My own Corner of the web http://www.massimocorner.com Dreamweaver, Ultradev and Fireworks goodies It should be this hole in the ozone layer But I am not the coder I use to be... Dave Hannum [EMAIL PROTECTED] wrote in message 00de01c0cf3c$650074d0$bd08eb84@jasper">news:00de01c0cf3c$650074d0$bd08eb84@jasper... I don't think I can agree with that statement. Everything we've heard from A/MM so far points the opposite. MM has made it's mark with lower end applications. Even UltraDev is only a $500+ product. Supposedly, they dropped Spectra because it was too high of a dollar tag for their focus. I think we just need to see the details before we all jump to conclusions. Everything we've seen says that MM has a true commitment to CF. ~~ 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
Passing back the ID field from an Insert
Hey all this my be a bit OT, I want to get the primary key / ID field passed back to CF when I make an INSERT into SQL server 7.0. Im aware that this can be done with triggers. I was hoping some one could copy and paste some example code for me. TIA, Jeff ~~ 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: evaluate(), single ', a SQL insert
I just wrote a paper on that bug. Basically, the escaping of single quotes
is done in the evaluation of the variable within CFQUERY. The execute
function stops that from happening on all versions of CF from 4 on up
(didn't test earlier). If you have to use an evaluate, do a replace on it to
escape the single quotes.
Hey everyone;
Again - my mind is mush this week (hurray for sleeping in on a Saturday).
Anyways -
The problem is the SQL chokes because of ' characters in a form field I'm
passing to it. Normally I can work with this, but because I'm doing a call
against a dynamically generated variable, it keeps hacking on me.
Here's code:
CFOUTPUT query=Questions_List
CFSET findmatch = num#questions_list.QuestionID#
CFSET findvalue = form.num#questions_list.QuestionID#
CFIF #isdefined(findmatch)#
CFquery Datasource=#AppPDS#
Insert INTO QuestionResponse
(ConsultantID, QuestionID, Response, QuestionnaireResponseID)
Values
('#szCandidateID#', '#Questions_List.QuestionID#',
'#evaluate(findvalue)#', '#New_ID.newnumber#')
/cfquery
/cfif
/cfoutput
As you can see, I'm doing a dynamic check against a variety of form.fields
that may or may not be returned. So when inserting into the Response field,
I have(?) to run an evaluate. This evaluate returns the data (text) that
sometimes includes the ' character. When it does, the insert statement hacks
and dies.
How can I adjust the SQL (or something else) to get around this problem?
Any suggestions? I totally appreciate any and all assistance on this issue.
Stephen R. Cassady
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
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: New CF5 Partner Hosting License
As I hit SEND I wondered how long it would be until someone responded with that. g -Original Message- From: Hans Omli [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 2:18 PM To: CF-Talk Subject: RE: New CF5 Partner Hosting License Do let us know when the FAQ is ready so we can begin panicking. ;-) In the mean time, that's for helping calm our fears. -- Hans Omli -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 10:35 AM To: CF-Talk Subject: RE: New CF5 Partner Hosting License Don't panic yet. I believe a FAQ is in the works that will explain all this. Stay tuned. --- Ben Forta -Original Message- From: Zac [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 1:08 PM To: CF-Talk Subject: RE: New CF5 Partner Hosting License MM could be positioning CF upmarket, abandoning the low-end web apps to PHP, open source platforms, and ASP, and targetting primarily, exclusively the corps, not the hosting services, knowing MM can?t run a business competing with free open source software, and the equally free MS security blanket. And where would that leave smaller developers? Out in the cold or suddenly finding themselves having to learn PHP? ~~ 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: SQL2000 server not recognized by CF 4.5
On all tests we've run over here, we've found SQL Server 2000 to be *significantly* faster than SQL 7.0, particularly with queries where optimization plays a larger role. SQL Server 2000 also holds the industry record for TPC-C performance, which is a pretty good indicator of real world performance (SQL 7 doesn't even place). See http://www.tpc.org/tpcc/results/tpcc_perf_results.asp for more info. Michael Caulfield -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:39 AM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ 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: New CF5 Partner Hosting License
unless you go out of business or lose your religion. -Original Message- From: Len Conrad [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 8:11 AM To: CF-Talk Subject: RE: New CF5 Partner Hosting License And where would that leave smaller developers? If the smaller developers aren´t worth their cost of sales, then, yes ... Out in the cold . and you don´t make significant money selling CF software, but from your CF apps and support contract revenue, none of which goes back to MM. Of course, the other shoe will drop, which will be software renting, time-limited product activation codes, since that´s where MS is officially going, sooner rather than later. Let´s not get emotional about it, it´s the brutal face of business. Remember, as long as one can do it in the name of (moral) religion or (amoral) business, you can do anything. :)) Len http://MenAndMice.com/DNS-training : Austin,TX: SFO,CA; 7,8 May http://BIND8NT.MEIway.com : ISC BIND 8.2.3 NT3 for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways ~~ 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: New CF5 Partner Hosting License
Len Conrad wrote: And where would that leave smaller developers? If the smaller developers aren´t worth their cost of sales, then, yes As has been mentioned before, I don't think that most companies factor in the value of small developers into their cost benefit analysis Out in the cold and you don´t make significant money selling CF software, but from your CF apps and support contract revenue, none of which goes back to MM. Or does it? No-one has, to my knowledge, spent any time examining the issue of how much a company makes (long term) from the support they give to small developers. Macromedia might not make a lot from direct sales but I think that the long-term profitability of the company has to be built on small developers. Let´s not get emotional about it, it´s the brutal face of business. Well that¹s certainly a logical approach but you really can't expect people to be anything other than emotional when there is a perceived direct threat to their ability to make a living. Or to the investment they have made in CF. I've just finished spending 3 months writing a CMS framework. I certainly don't want to see that effort go down the drain. -- Consistency is the refuge of the unimaginative Oscar Wilde 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
