Re: purchasing CF7 license
All places are not the same price Adobe (and Macromedia before them) has an interesting pricing policy, depedant on what part of the world you live in... CFMX 7 Enterprise, bought as a download from the online store: US price: $5,999 (USD) - roughly £3,197 (GBP) UK price: £4,225 (GBP) - roughly $7,928 (USD) So.. the same product - bought in the same online store - costs nearly $2,000 extra, if you are based iin the uk. Note this is for the download product - so there are no additional shipping costs to take into account - and this does not include any addtional VAT etc. I was pleased to see that New Atlanta do not appear to charge any additional Dirty Foreigner tax - the price for BlueDragon 6.2 for Microsoft .NET Framework 1-CPU Server appears to be $2,999 wherever you are based... Not impressed On 9/27/06, Ray Champagne [EMAIL PROTECTED] wrote: Where's the cheapest place to buy a CF7 license? Or, are all places pretty much the same price? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is anyone minding the store at Adobe?
I fully agree. It took a day and a 1/2 - but my issue was eventually forwarded to an appropriate support member at adobe. He is being extremely helpful - and committed - my last email from him yesterday was sent @ 23:59 - and he has responded to all my emails very quickly. The issue I had was that (understandably) macrodobe does not post the email addresses of their top CF support guru's online - and that you have to make the initial request through their web app - which is (was?) broken. The process I had to go through, was as follows: - Enter email into adobe web app - recieve Page does not exist error - Spend 20 mins trying to navigate through the adobe automated call terminator (I couldn't find any way of speaking to a real person on the (uk) support line) - Fool the main automated call redirector into thinking I might actually want to buy something (If I had been I definately didn't want to at this stage!) - and actually got a real person to speak to in sales. He gave me a number, which he said was the correct number for CF support - I called this number, and explained my situation to the receptionist - She sounded confused, and forwared me to an extension where she said somone should be able to help me - Redirected call went directly to somones voicemail - Eventually I managed to naviaget my way out of the mailbox back to a (different) receptionist - She forwarded my call directly to somone else (without any explaination to them who I was) - This person had no idea why my call had been directed to him, but he took down my details, and promised to find the relevant person(s) - I was emailed back within 30 mins, with a link back to the coldfusion support site (that I had been on a few hours before and was broken!) - I responded that the site was broken etc. etc. - He responded that I should send the email to him, and he would try and get it forwarded to the correct department - Within 20 minutes he called me back to say he had passed the information on, and that I should be contacted shortly - 14:35 the following day I had an urgent email from an adobe suppot rep (Sr Technical Support Engineer: FLEX / ColdFusion / JRun) - From that point on I have recieved the most helpful, friendly support I have ever recieved from a software company - no complaints at all - (esp. if / when the issue gets resolved!) Cheers Dan. Reckon the best thing you can do is email them direct not via web form (or contact someone direct). They will undoubtedly have problems with integrating two massive sites. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
We have had the following issue with Macromedia ColdFusion 7 (7.0.1.116466), running on windows 2003, which we have not been able to reolve, and cannot see really where to start! - At 00:30 on 09/09/2006 we rebooted our server. - All sites hosted on the server were tested following reboot, and were operating normally - At 11:26 all http requests to ColdFusion sites started timing out (taking longer than 30secs) The following pair of errors were logged (multiple times) within the ColdFusion exception log: *Error 1* Error,jrpp-228,*Date*,*time*,*CF Application Name*,Error attempting to resolve the template error.cfm.The template could not be found. The specific sequence of files included or processed is: *PhysicalPath*\public\index.cfm, line: 176 coldfusion.tagext.lang.ErrorTag$InvalidErrorTemplateException: Error attempting to resolve the template error.cfm. *Error 2* Error,jrpp-228,* Date*,*time*,,Not enough storage is available to process this command The specific sequence of files included or processed is: E:\CFusionMX7\wwwroot\WEB-INF\exception\coldfusion\runtime\MissingIncludeException.cfm java.io.IOException: Not enough storage is available to process this command No requests were logged within the IIS log files until: - From 13:26 all http requests to ColdFusion sites resulted in the following error: *Server Error* The server encountered an internal error and was unable to complete your request *JRun closed connection. *These requests were logged in the IIS log files. - From 14:56 all http requests to ColdFusion sites resulted in the following error: *Server Error* Either the Macromedia application server is unreachable or it does not have a mapping to process this request.* *These requests were logged in the IIS log files. - When we connected to the server on Monday morning (12/09) CPU usage for JRun was minimal, but Memory usage was at 1.4 Gb, and increasing (this is on a server with 2Gb RAM, also running MS SQL Server) - We attempted to restart ColdFusion eventually CF service stopped (after about 5 min) and once stopped, we started the service again without any problems. All sites were tested, and found to be running normally. - The server was rebooted again at 02:40 on 16/09, and again showed pretty much the same symptoms as before (although this time with no errors reported within the CF exception log) - I had increased the max JVM heap size from 512 MB to 1024 MB following the previous crash which may have prevented the java.io.IOException: Not enough storage is available to process this command errors. - This is now the third time we have had this occur (although I did not record full details for the first time and cannot be certain that this was following a reboot). - This has only happened at times when the server is not handling much traffic previously to experiencing these problems, the server had been hosting an online competition, handling around 30 simultaneous users during busy periods, and never having a window of more than 20 minutes inactivity. This did make me wonder if it might be an issue with the Garbage Collection Process? Has anyone Experienced this problem, or got any ideas as to how to resolve it? Thanks, Dan. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Ok... I have read and reread the mail I sent - and I still can't see where I said I store large objects in session scope :-/ The server is currently only hosting a single application, which uses the seesion scope only for storing a small number of simple variables specific to the currently logged in user - and there is a restriction of 5 concurrent authenticated users on the system. I doubt therefore thatsession memory usage is the problem here. Cheers Dan. On 9/18/06, Snake [EMAIL PROTECTED] wrote: That fact that you have stated you store large objects in session scope is most likely your problem. If you are instantiating CFC's in session scope, then this uses tons of memory, as you are needlessly creating a new CFC instance for each user, and unless the cose is different for every single user, there is no need to do this. Better to cache a single copy in application scope. Russ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash
Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption) First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer [EMAIL PROTECTED] wrote: Hi Daniel, Pretty much everyone running CF/Windows/SQL Server has this problem. See my page here http://www.digitalmethod.co.uk/cf/ There is no guaranteed fix other than to have an alert system in place to monitor memory usage and restart when it gets over 90% or so. Don't waste time playing with garbage collection - you also might do more harm than good. The only settings you might want to consider playing with are the SQL connections settings - the method (cursor or direct), the max number of connections and maintain connections. I've seen people mediate the problem reasonably well by splitting DSN's into two - one cursor connection that doesn't maintain connections and one direct with maintained connections for smaller queries. When the system goes into the state you describe it's often quicker to restart the server than wait for CF to restart (sometimes it never does). Tom Peer Digital Method ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is anyone minding the store at Adobe?
I tried to submit a problem using the email support app - which resulted in Page doess not exist error meesage after clicking send mail On 9/18/06, Tim Claremont [EMAIL PROTECTED] wrote: I have been trying to reach the CF tech support forums on Adobe.com. I get an error message saying, essentially, insufficient disk space. How does this happen in today's day and age of server monitoring, etc, etc. ??? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 500 errors
Hi - I am having the exact same issues - see http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:47798 I am almost certain that the error Not enough storage is available to process this command, realy means the JVM has run out of memory which it can / is allowed to access It has always been accompanied by the error Error attempting to resolve the template error.cfm - which I presume is because it is trying to load the error handling template to handle the first error, but can't because it cannot allocate any memory. Confusing error messages to say the least - and it would appear to be due to a memory leak in CF (joy oh joy) :( Let me know if you find a resolution... Cheers, Dan. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Holy crap I like CFEclipse!
Turn off the design view and you've got a serious code editor. I tend to disagree, in my opinion the real added value in DW are certain visual tools, if you don't use them, you are better served by CFEclipse or a traditional code editor, faster and with a smaller footprint, like EditPlus, UltraEdit, or even good old Homesite. Completely agree - only time I use DW is for rapid edits of static HTML (laying out html emails etc). We have guy's on the team here who use DW for everything - and this has exposed a quite annoying feature - namely its broken SourceSafe integration. If a file is checked out to another user, and you try editing it within DW, DW will remove the write protection on the file, but will not check it out. THIS IS WRONG! No other source control product that I have ever used works in this way... The write protection and the check out status go hand in hand - and you should not be able to edit a file which is not checked out. What's even worse, is that if you then try and save the file, DW will go and checkout the file over your changed file, and irrecoverably lose all your changes. In addition, if you try and do a search and replace across multiple files, some of which have been checked out, edited and saved, and some of which are still checked in, DW will prompt you to ask if you want to check out un-checked out files. If you click yes, not only will DW check out the un-checked out files, but also all the ones already checked out and changed - losing all work since you last checked your files in My colleague has lost a sum total of at least 12 hours work due to DW's sourcesafe bugs. I meanwhile use CF Eclipse with the free VSS Explorer eclipse plug in - and have never had any (VSS related) problems... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Holy crap I like CFEclipse!
LOL - I wish... Unfortuneately comercial realities mean that is not going to happen... We dev some .Net stuff aswell as CF - so Source Safe is a necessary evil... and tbh for what we want it works absolutely fine (apart from the integration with DW - which as everything else integrates fine - must be the fault of DW) Also for what this guy does (he's a junior developer doing lots of small changes to mainly static sites) DW is a timesaving tool... On 9/11/06, Russ [EMAIL PROTECTED] wrote: Agreed, DW is useless, but I think the bigger issue is that you're using SourceSafe. Get rid of the demon and go to SVN. (Then just tell that one guy that DW is no longer supported due to it's non integration with SVN and make him use CFE :-P ) Russ -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 11, 2006 12:53 PM To: CF-Talk Subject: Re: Holy crap I like CFEclipse! Turn off the design view and you've got a serious code editor. I tend to disagree, in my opinion the real added value in DW are certain visual tools, if you don't use them, you are better served by CFEclipse or a traditional code editor, faster and with a smaller footprint, like EditPlus, UltraEdit, or even good old Homesite. Completely agree - only time I use DW is for rapid edits of static HTML (laying out html emails etc). We have guy's on the team here who use DW for everything - and this has exposed a quite annoying feature - namely its broken SourceSafe integration. If a file is checked out to another user, and you try editing it within DW, DW will remove the write protection on the file, but will not check it out. THIS IS WRONG! No other source control product that I have ever used works in this way... The write protection and the check out status go hand in hand - and you should not be able to edit a file which is not checked out. What's even worse, is that if you then try and save the file, DW will go and checkout the file over your changed file, and irrecoverably lose all your changes. In addition, if you try and do a search and replace across multiple files, some of which have been checked out, edited and saved, and some of which are still checked in, DW will prompt you to ask if you want to check out un-checked out files. If you click yes, not only will DW check out the un-checked out files, but also all the ones already checked out and changed - losing all work since you last checked your files in My colleague has lost a sum total of at least 12 hours work due to DW's sourcesafe bugs. I meanwhile use CF Eclipse with the free VSS Explorer eclipse plug in - and have never had any (VSS related) problems... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252805 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Holy crap I like CFEclipse!
agreed... On 9/11/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: DW is in no way useless, I am not a fan anymore (for ColdFusion work) but it is a fantastic tool for HTML / CSS. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Mon Sep 11 19:17:54 2006 Subject: RE: Holy crap I like CFEclipse! Agreed, DW is useless, but I think the bigger issue is that you're using SourceSafe. Get rid of the demon and go to SVN. (Then just tell that one guy that DW is no longer supported due to it's non integration with SVN and make him use CFE :-P ) Russ -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED] Sent: Monday, September 11, 2006 12:53 PM To: CF-Talk Subject: Re: Holy crap I like CFEclipse! Turn off the design view and you've got a serious code editor. I tend to disagree, in my opinion the real added value in DW are certain visual tools, if you don't use them, you are better served by CFEclipse or a traditional code editor, faster and with a smaller footprint, like EditPlus, UltraEdit, or even good old Homesite. Completely agree - only time I use DW is for rapid edits of static HTML (laying out html emails etc). We have guy's on the team here who use DW for everything - and this has exposed a quite annoying feature - namely its broken SourceSafe integration. If a file is checked out to another user, and you try editing it within DW, DW will remove the write protection on the file, but will not check it out. THIS IS WRONG! No other source control product that I have ever used works in this way... The write protection and the check out status go hand in hand - and you should not be able to edit a file which is not checked out. What's even worse, is that if you then try and save the file, DW will go and checkout the file over your changed file, and irrecoverably lose all your changes. In addition, if you try and do a search and replace across multiple files, some of which have been checked out, edited and saved, and some of which are still checked in, DW will prompt you to ask if you want to check out un-checked out files. If you click yes, not only will DW check out the un-checked out files, but also all the ones already checked out and changed - losing all work since you last checked your files in My colleague has lost a sum total of at least 12 hours work due to DW's sourcesafe bugs. I meanwhile use CF Eclipse with the free VSS Explorer eclipse plug in - and have never had any (VSS related) problems... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Holy crap I like CFEclipse!
LOL - I tend to use Photoshop for that! On 9/11/06, Ken Ferguson [EMAIL PROTECTED] wrote: Yeah, and I find it to be an absolutely invaluable tool for stress-testing any new computer I get! --Ferg -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, September 11, 2006 1:39 PM To: CF-Talk Subject: Re: Holy crap I like CFEclipse! DW is in no way useless, I am not a fan anymore (for ColdFusion work) but it is a fantastic tool for HTML / CSS. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
UK Dedicated Hosting Recomendations?
Hi I need a uk dedicated hosting provider that can provide: Web Hosting Load Balancing Fail Over solutions Rock Solid SLA This is for windows servers (for Hosting CF / .NET + MS SQL) I would appreciate hearing your recomendations both for and against, from personal experience, as our current provider has let us down a few times recently. Thanks Dan. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184853 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: UK Dedicated Hosting Recomendations?
Host it In-House? No - that is not an option - Cost of connectivity where are company is based would make that prohibative, and we cannot realisticly offer 24/7 support etc. Cheers, Dan. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184857 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: UK Dedicated Hosting Recomendations?
Thanks Andrew, For a largescale uk based application, will it not make a difference to performance at all having the site hosted in the US? Also, if and when telephone support is needed, presumably that means an international call etc? You have mentioned our current hosting company there - and I agree, customer service and connection reliability absolutely sucks... One of our servers went offline at 1:30am, the automated service monitoring failed to send us an SMS, the hosting company failed to notice it, and would not even look at the server until we submitted an automated reboot request. About 1 1/2 hours later the server came back online - and one of the support people said it was something todo with the network card or cable When we asked for further information, we were told that it was nothing todo with the network, but an unidentifiable problem that disappeared after they rebooted the server twice. We checked the logs, and the only info we could see, was an error from the network card, saying it had been disconnected from the network. Sounds to me like some £!!£% unplugged the network cable form the machine / switch, and they are not prepared to admit it... Thanks, Dan Hi Dan. We are UK based, but use a US based hosting company (ev1servers.net) as all UK based hosting companies are a rip-off in comparsion, and it really doesn't matter where the servers are. EV1 has 24 hour 365 day support so it doesn't matter if you have a problem when it is 3am in the US as there is always someone there. Their prices are excellent and you get loads of bandwidth included (which no UK based provided tend to do). Also, we found the three UK providered we used in the past (Virtual Internet (the worst of the worst), Host Europe and OneAndOne) didn't provide anywhere near the level of customer service or reliability of connection that was required. Best Regards Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184858 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: UK Dedicated Hosting Recomendations?
Have you looked at RackSpace? Regards REX ~ Hi Rex, I'm looking at them now... Is this a personal recomendation? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184873 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFTRANSACTION
If you are using SQL Server, and the architechture of your application permits it, it is possible to give one account the appropriate permissions to both databases. You can then explicity name the 2nd db you are trying to access (e.g. insert into [db2].dbo.[tablename]...) I think then it should be possible to have a transaction that covers both dbs, as long as the same connection is used for both I havent checked using cftransaction, although I have done something similar within a stored procedure with serializable isolation, which may be worth exploring. You don't seem to have specified which db you are using - though I imagine something similar may be possible in most RDBMS's. HTH Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX 6.1 on W2K3
Hi Folks, We are currently in the process of upgrading one of our ISP hosted servers (i.e. having a new server replace an existing server). The ISP specifies that all new windows boxes are installed with W2K3 standard Server. Following the posts yesterday about problems people have had with W2K3, I was wondering if I could have a more exhaustive response from people who have had experience with it - both good and bad, as to whther it is really a viable platform for CF hosting, or whether we would be much better off sticking to W2K. Also if anyone has had experience with CF5 on W2K3, I'd like to hear from them too - as we may still have to run some sites on CF5 until we are completely happy that any MX related (coding) issues have been sorted... Cheers Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Both Plain Text and HTML in cfmail
I have a (incomplete but working) set of custom tags that I created to do this if you contact me offlist I can forward them to you (danlance at runbox dot com) Cheers Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Document Version Comparison
Hi all, I am in the process of spec'ing a document management system for a client, and am wanting to implement a Red-line version comparison feature, that will compare 2 html documents (text of which is stored in the db) and generate html highlighting differences between the 2. Has anyone any recommendations - most of the solutions I have seen require MS Word to be run on the server - which I'm not too keen about for stability / performance reasons... Any Help is appreciated Cheers Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Document Version Comparison
Thanks I don't quite see how that would help - What I need to do is compare 2 documents, and have the differences highlighted - added text in red, deleted text struck out, etc. Whilst this may be possible (with a great deal of iteration) using this algorithm, I think I would be better served using an existing piece of software (unless someone has complete source code for doing this :) ). If anyone has any experience in doing this from CF, that would be really useful... You should take a look at the levenshtein distance algorithm :-) This is to create a cost path using a generated matrix of words. Simple line by line comparisons are very difficult with string comparisons because you need to find the original locations before add, edit and delete actions. Micha Schopman Software Engineer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Document Version Comparison
Wow I'm impressed... When you say very CPU intensive - how intensive are we talking? I am planning on doing the comparison as a one time task, when a new version of a document is uploaded... Problem is, some of the documents may be upto a couple of hundred pages long... If you do have any more info, I'd be grateful - I think for me to create such a procedure from scratch may be beyond the scope of this project... Also, I think the rendering of content changes may be a little awkward - its really the content, and not the source html I want to compare - which would be easy enough to strip out from the html - but it would then be quite hard to render the resulting redline document with formatting preserved... Thanks Dan I came up with the algorithm because I have some experience with this subject, I haven't found any custom tags being able to compare documents, so I had to create one for a client last week. I don't have the tag by hand, unfortunately. What you have to do is split the strings create a matrix, and loop through the matrix to find the highest cost. Compare this cost to the minimal, diagonal and horizontal cost and you are able to find whether the string is added, modified or removed from the version. The process is very cpu intensive when running on ColdFusion, especially creating the matrix which is len(chars) * len(chars) in length. I also made a PHP implementation which was way more faster than ColdFusion did. Micha Schopman Software Engineer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
FW: Request Scope Questions
If this is the case, is there any disadvantage of doing duplicate rather than structcopy? - It would seem that duplicate would always work... -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: 12 November 2001 15:21 To: CF-Talk Subject: RE: Request Scope Questions if i understand correctly, a week or so ago you (dave) mentioned that duplicate was only necessary for a session structure if it contained other complex variables. you said that StructCopy was sufficient if it was merely a structure with simple variables. is this correct? christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 11, 2001 5:00 PM To: CF-Talk Subject: RE: Request Scope Questions A couple of notes here: if you do this, use something like cfset request.var=Duplicate(session.var) to transfer the variable. If you don't use Duplicate() - correct me if I'm wrong someone! - then request.var just becomes a 'pointer' to session.var, and session.var is still actually read when you refer later to request.var (rendering the whole business kind of redundant!). Duplicate() - which is only available in CF4.5+ - makes request.var a 'deep' copy of session.var, and then request.var technically has nothing to do with session.var except having the same value. It's only necessary to use Duplicate in this case if Session.var is a structure or a query. If it's just a simple value, you don't need to worry - simple values are always passed by value, not by reference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf excel formatting problem
Hi are you creating a csv? If so, enclosing the field in double quotes works fine... e.g. HouseNum,ZIP,Telephone 123,01234,01234 567890 HTH Dan -Original Message- From: Nathan Shaw [mailto:[EMAIL PROTECTED]] Sent: 30 October 2001 13:07 To: CF-Talk Subject: RE: cf excel formatting problem This is all being done dynamically. Yes, if I bring it in manually into Excel, it is not a problem at all. What I need to know is: 1) how to tell Excel to treat the zip code as a text field OR 2) how to trick Excel into thinking the zip code is a text field. Nate --- thinking aloud. 1) export / import as a text field 2) single quote at the front of the field How are you importing / exporting? Eric Dawson From: Nathan Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: cf to excel formatting problem Date: Mon, 29 Oct 2001 10:48:29 -0800 (PST) I am exporting some data to Excel and one of the fields is zip code. Excel is stripping all leading 0's (zeros) off of the zip codes. I need it to leave the zip code alone, i.e. treat it as text instead of a number. Any ideas anyone? So far, I have tried: 1) Using an obscure ASCII char in front of the zip. RESULT: Excel puts in a box when it encounters an ASCII char it does not understand 2) Enclosing the zip in both single quotes and double quotes. RESULT: Excel leaves the quotes in instead of treating them as a text qualifier 3) Looked at the Allaire forums, where I saw the same question asked but not answered. 4) Read up on Excel at cfcomet, but most things there are a little overkill for what I am trying to do. TIA, Nate = Nathan Shaw Senior Web Applications Developer iaffect, Inc. http://www.iaffectonline.com ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio memory leaks.
I generally keep CF-studio 4.52 open for 5 days at a time without any problem. This is on NT 4.0 with 256mb Most problems I come accross are with IE integration with CF-studio - in general if anything crashes it is: IE integration with Enterprise Manager (MMC on NT seems very flaky to me) IE integration with studio (umm can ayone see a pattern forming?) IE on its own - at times without any ie windows open - there can be 4 or 5 instances of ie in taskmanager - consuming well over 100mb between them. Most of these probs seemed worst on IE5.5 - seem a lot better since I put ie 6.0 on... -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: 28 September 2001 20:12 To: CF-Talk Subject: Re: CF Studio memory leaks. Ok then here is my personal experience. Stable...well as long as you dont keep it open overnight it usually wont crash. I've used Studio on four different Win2k machines in the last 2 years and it has always crashed the next day if I leave it open overnight. If in your experience you have ever create a wml or vtml script, run it then checked stuido's memory usage, especially if the script accesses a database, and you think swallowing at _least_ 2 Megabyes of memory everytime a script is run is acceptable, well then I really cant think of anything to say. That kind of memory leak is not called a leak anymore...more like a firehose. This is a wizard I put together that creates a wddx packet describing the structure of a database. http://www.oztek.net/jon/wddxgen.zip It's real simple, yet I cannot run it more than 5 or so times, before I have to restart studio, so my system can reclaim that memory. The problem is not actually running it that much, it's trying to debug a wml application in that kind of environment. I was restarting studio every 10 minutes. jon - Original Message - From: Brunt, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 28, 2001 2:09 PM Subject: RE: CF Studio memory leaks. I think all our comments are based on the experiences we have had over the years, personally as I said CF Studio 4.5.2 on Win2K has been very stable for our environment, VTML and all. Mike Brunt Sempra Energy 213.244.5226 Programming is an art form that fights back. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, September 28, 2001 10:48 AM To: CF-Talk Subject: Re: CF Studio memory leaks. It's funny you mention VTML, where the worst memory leaks are... jon over the place and once you get into VTML the options are amazing. As I said CF 4.5-Win 2k is very stable in my experience. Mike Brunt Sempra Energy 213.244.5226 Programming is an art form that fights back. -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Friday, September 28, 2001 7:05 AM To: CF-Talk Subject: Re: CF Studio memory leaks. Bah i've had Problems with CF 4.5 even rc CF 5 studio is just basically a buggy ass program and after extended time you will run into the (what i like to call) STUDIO ISSUES where stuff wont save right, or your RDS directories will show but no files or it will save FILE A into fileb and fileb into file a :) you know things that just make you want to pull your hair out Bill Wheatley Director of Development Macromedia Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 28, 2001 9:52 AM Subject: RE: CF Studio memory leaks. I'v also have numerous problems with ME, i think its the most flaky version of windows i've used. Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SELECT
how about in your query (if you're doing it like this) instead of select [fields] where [criteria] and bookID = #form.bookid#... do select [fields] where [criteria] and bookID in(#form.bookids#) (checking of course that at least one book is selected before you run the query...) if this doesnt answer your question - please expalin your problem in more detail - as I am having to guess what I think your problem is.. HTH Dan -Original Message- From: Tony Hicks [mailto:[EMAIL PROTECTED]] Sent: 01 October 2001 09:32 To: CF-Talk Subject: Re: SELECT The problem came in when I added multiple book search.. I just used a query before and grabbed the display by the option selected.. now with multi book.. I'm afraid my only option is going to be cflooping a query.. but even that generates a problem if some decide to select all.. then I'm doing a query about 75 times.. Tony Hicks -- Search the Holy Bible: http://www.bibleclicks.com - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, September 30, 2001 1:02 PM Subject: RE: SELECT It is also possible to write: option value=#name# #IIf(Form.Name EQ Name, 'selected', '')##name#/option The single quotes is equivalent to DE(). I'm not sure if this is any faster. Overall though, IIF always seems to be incredibly slow. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: September 30, 2001 11:26 AM To: CF-Talk Subject: Re: SELECT The IIf way would be: option value=#name# #IIf(Form.Name EQ Name, DE(selected), DE())##name#/option Or something along those lines, it is slower though due to the DE() functions. Why not just put the CFIF within the option tag? option value=#name# cfif Form.Name EQ Nameselected/cfif#name#/option This all assumes that Form.Name is always defined, I am guessing you have a cfparam towards the top of the page for that, like so: cfparam name=Form.Name default= Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion - Original Message - From: Bryan LaPlante [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, September 30, 2001 11:46 AM Subject: Re: SELECT I imagine you are pulling your list from a database and using the query of a cfoutput, just add this code to it. select cfoutput query=mybooknames cfif name is form.namecfset selected = selectedcfelsecfset selected = /cfif option value=#name# #selected##name#/option /cfoutput /select there is a way to do it in one line with iif() but I can't remember that one right off. Bryan - Original Message - From: Tony Hicks [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, September 30, 2001 5:00 AM Subject: SELECT Hey Guys... I have a problem, my site, www.bibleclicks.com has one request from people that send me feedback.. they want me to set it so that when a user selects a book and searches, the book remains selected on the next page.. the problem comes in here: It would take about 75 cfif tags to do it and some of them would be long.. my host is generous with bandwidth but.. I'm smart, I don't want to push the limits.. is there an easy way to do this? Thanks, Tony Hicks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XML Parser for CF
Hi Rob, I ran some tests on CFX_XMLPARSER vs MSXML, and found that while the MSXML parser was only around twice as slow on average when run once, if you ran it 10/100/1000 times the MSXML parser started to get a factor of 10 to 100 times slower (sometimes taking nearly 2 seconds to parse a packet that could be parsed in around 20ms in CFX_XMLPARSER HTH Dan -Original Message- From: Rob Gilchrist [mailto:[EMAIL PROTECTED]] Sent: 20 September 2001 17:35 To: CF-Talk Subject: RE: XML Parser for CF Hi Gary I have a site that is about to go live that uses the MSXML parser and I am a bit concerned by your statement that it buckles under load. Do you know what sort of load causes it to fail? and what are the effects when it does fail? Can your CFX_XMLPARSER convert CF Structures into XML? Thanks Rob -Original Message- From: Gary Kraeger [mailto:[EMAIL PROTECTED]] Sent: 20 September 2001 15:09 To: CF-Talk Subject: Re: XML Parser for CF We have a free one at http://www.cfdev.com here is a description of it. CFX_XMLParser is a Fast Java CFX tag that takes an XML document and returns a ColdFusion structure containing the XML document. Our tests show this parser to be about 1000% faster than the MSXML Parser invoked through CFOBJECT. CFOBJECT based parsers also tend to buckle under load. Gary cfdev.com - Original Message - From: Critter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 12:59 PM Subject: XML Parser for CF Hello CF-Talk, anyone have any suggestions for a decent one? -- Best regards, Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Question about SQL and the IMAGE datatype
Anyone want to write a FAQ on this - it seems to come up every few weeks (you could try looking at the archives...) -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 10 September 2001 13:56 To: CF-Talk Subject: RE: Question about SQL and the IMAGE datatype I've been tempted to do this and have stopped because I've been told it's not a good practice. I suppose it's inefficient to do all that extra DB work when you can just store a path to the image. I'd like to hear any opinions on just why this is a bad practice. Any thoughts? Thanks, EC -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 8:49 AM To: CF-Talk Subject: RE: Question about SQL and the IMAGE datatype Kelly - I've used the image datatype before (sql server) and I've since reverted back to just storing images on disk and entering the path in the db. We stored the images as blobs - there are two custom tags out there cfx_putimage and cfx_getimage that do this for you. Someone above me stated that blobs were not that great, so we reverted back. Honestly, I can't say why we did that because it seemed to work just fine. Mark -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 12:29 PM To: CF-Talk Subject: Question about SQL and the IMAGE datatype Has anyone every used the IMAGE datatype? Is there any advantage to this, as opposed to just putting an image name in a text field and then linking to it in the output via an img src tag? I just haven't used it so not sure why it would be a good thing. Also how exactly do you get the image in the field? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with moving from access to sql server
thats certainly possible... but is it a good idea??
I'd have thought the overhead concerned with storing 4bits (tinyint) rather
than 1 bit for each boolean field would be less than running the
convert/cast function against each value returned by the query...
I may be wrong though - have not run any empirical tests - and would be
interested to hear others thoughts/knowledge...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 19:36
To: CF-Talk
Subject: RE: help with moving from access to sql server
Can't you just use a Convert statement in your SELECT and GROUP BY clause
for the Bit fields?
For example
SELECT sum(line.total) as OrderTotal, Convert(Char(1), order.Sent) as
Shipped, order.ShipDate, order.ordernum
from line, order
where line.order_id = order.order_id
AND order.sent = 1 AND order.customer_id = #customerid#
group by Convert(Char(1), order.Sent), order.ShipDate, order.ordernum
I've done this several times on SQL Server platforms and it works with no
problem.
Hatton Humphrey
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 1:36 PM
To: CF-Talk
Subject: RE: help with moving from access to sql server
BIT is the correct type to use for a boolean value, but you must
think about
it first since BIT typed columns cannot be included in a GROUP BY clauses.
TINYINT is the one to use for boolean values if you need to group by a
column.
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 7:41 AM
To: CF-Talk
Subject: help with moving from access to sql server
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit
column.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (21:1) to (21:53).
I realise that this is caused by trying to group according to the bit
datatype.
However when I remove the grouping for this it gives an error saying
that I need to group.
This is the query I am using. Can anybody suggest a way of getting
around this.
cfquery name=gethdrs datasource=#Variables.DSN#
SELECT DISTINCT Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Quarter_ID,
Programme_Details.Locked, Programme_details.Prog_Status,
Programme_Details.ILX, Programme_Details.Executive,
Programme_Details.BSS, Programme_Details.Prog_result
FROM Programme_Hdr, Programme_Details, Business_Units2
WHERE Programme_Hdr.Programme_ID Programme_Details.Programme_ID
cfif form.Programme_Name NEQ ALL
AND Programme_Name = '#Form.Programme_Name#'
/cfif
cfif form.year NEQ ALL
AND Programme_Details.Year = '#Form.Year#'
/cfif
cfif form.quarter NEQ ALL
AND Programme_Details.Quarter = '#Form.Quarter#'
/cfif
cfif form.Business_unit NEQ ALL
AND Programme_Hdr.Business_Unit = '#form.Business_Unit#'
/CFIF
cfif listcontains(session.access,'5') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND Programme_Details.Executive = 1
OR (PROGRAMME_DETAILS.ILX=1 AND PROG_Status IN('CURRENT,COMPLETED'))
/cfif
cfif listcontains(session.access,'3') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.BSS=1 OR (Programme_Hdr.Business_unit
'#session.b_unit#' AND Programme_Details.BSS = 0))
/cfif
cfif listcontains(session.access,'2') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.ILX=1 OR (Programme_Hdr.Business_unit
'#session.b_unit#' AND Programme_Details.ILX = 0))
/cfif
cfif NOT listcontains(session.access, '1') AND NOT
listcontains(session.access, '2') AND NOT listcontains(session.access,
'5')
AND Business_Units2.bss_Name = '#session.bss#'
AND Programme_Hdr.Business_Unit = Business_Units2.bu_name
/cfif
cfif listcontains(session.access, '4') AND NOT
listcontains(session.access, '5')
AND Programme_Hdr.Business_Unit = '#session.b_unit#'
/cfif
AND Programme_Details.archived = 0
Group By Programme_Details.Quarter_ID, Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Locked,
Programme_Details.Prog_Status, Programme_Details.ILX,
Programme_Details.BSS, Programme_Details.Executive,
Programme_Details.Prog_result
cfif not parameterexists(url.orderby)
RE: CFLOCK and Session variables
2 reasons: 1/ if the user has multiple windows open 2/ If the user hits stop before a page finishes executing and executes another page.. Locking when reading prevents a variable being written when it is being read and visa versa -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 17:45 To: CF-Talk Subject: CFLOCK and Session variables A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? My impression is that: Session.var is NOT shared, Client.var is NOT shared, Application.var IS shared 2. Why would one need to use cflock when READING any shared variables? thanks y'all, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with Java
We had a problem on CF5 getting java stuff to work after changing settings in CFIDE - restarting CF made no difference - we couldnt see what was wrong... We rebooted the server and it all worked fine... this has happenned on more than one occasion... once we hadnt even changed any settings - just installed a java CFX... -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 17:35 To: CF-Talk Subject: RE: Problem with Java You probably don't need to reboot the server, just restart CF. When you make changes to the classpath or add a CFX tag you need to restart CF. But also make sure that you have specified everything correctly in the class path. Also remember that if your using .class files then you just need to specify the directory that the class files are in, in the class path, but if you have a .jar file, you need to specify the path to the .jar file. +++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 9:01 AM To: CF-Talk Subject: RE: Problem with Java Are u using CF5? If so, have you tried rebooting the server?? I found that I could not get the server to recognise my changes to the Java settings in administrator until I rebboted the server... HTH Dan -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 06:23 To: CF-Talk Subject: Re: Problem with Java Have you added the CFX to the CFX Tags section in the CF Administrator? If you have... Where is your class? For development purposes, and to ensure it's configured properly, I put them in the \cfusion\java\classes folder, then when they are ready to go to live use, I'll put them in the correct folders. on 4/9/01 2:58 PM, David Lawrence at [EMAIL PROTECTED] wrote: Hi All I am trying to use a CFX Java tag and am having problems... I have installed 'Java 2 SDK Standard Edition 1.3.1' and have configured the CF Administrator (within the Java area and the CFX area). Everytime I try to run the page calling the tag I get the following error: java.lang.ClassNotFoundException: rapidDiet. Java exception occurred in call to method. I imagine this means the application cannot find the relevant Class, but I am not sure where I am going wrong. When installing the SDK I simply used the standard install without any further modifications. Any ideas out there? Thanks David Lawrence Red 5 Interactive Media FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with Java
Are u using CF5? If so, have you tried rebooting the server?? I found that I could not get the server to recognise my changes to the Java settings in administrator until I rebboted the server... HTH Dan -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 06:23 To: CF-Talk Subject: Re: Problem with Java Have you added the CFX to the CFX Tags section in the CF Administrator? If you have... Where is your class? For development purposes, and to ensure it's configured properly, I put them in the \cfusion\java\classes folder, then when they are ready to go to live use, I'll put them in the correct folders. on 4/9/01 2:58 PM, David Lawrence at [EMAIL PROTECTED] wrote: Hi All I am trying to use a CFX Java tag and am having problems... I have installed 'Java 2 SDK Standard Edition 1.3.1' and have configured the CF Administrator (within the Java area and the CFX area). Everytime I try to run the page calling the tag I get the following error: java.lang.ClassNotFoundException: rapidDiet. Java exception occurred in call to method. I imagine this means the application cannot find the relevant Class, but I am not sure where I am going wrong. When installing the SDK I simply used the standard install without any further modifications. Any ideas out there? Thanks David Lawrence Red 5 Interactive Media FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with moving from access to sql server
Is it possible you are pointing to a SQL view - and the error is in the SQL view - I too cannot see anything obviously wrong with the SQL (with regards to the CF - parameterexists() function has been deprecated and has been replaced by isdefined() ) Cheers Dan -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 15:48 To: CF-Talk Subject: RE: help with moving from access to sql server Why do you need the GROUP BY clause at all? I don't see any aggregate functions (COUNT, SUM etc) Also, which column is a bit column and does it really need to be? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
I think... If you need CF5, then after the demo timesout, it turns into the single user version - maybe someone else can verify??? http://www.macromedia.com/software/coldfusion/trial/ -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 17:22 To: CF-Talk Subject: RE: ColdFusion license agreement If not, how do I get around the problem with out having to buy a copy? If you have CF Studio, you can use the single-user version that comes with that. I think that has all the tags. Unless you want Server 5, that is, in which case you have to wait for Studio 5. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The biggest cfmail message?
Is this content already displayed online? If so, rather than sending an email with all the images etc attached, you could link to all the image's online locations (absolute href's) and thus reduce your bandwidth requirements substantially (depending on the nature of the content...) HTH Dan -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 15:42 To: CF-Talk Subject: RE: The biggest cfmail message? At 2:32 PM +0100 8/31/01, Will Swain wrote: I think the question should be What is the biggest email that my clients will want to download without getting really hacked off?? Will Normally I would agree, but this is a subscription (paid for) newsletter... many would want to receive it in email rather than go to the site and link through web pages. Thanks, though, ot is a good point! Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The biggest cfmail message?
few reasons 1: Bandwidth on your mailserver Depending on the number of recipients your webserver is probably far better optimized for serving images, than your mail server is of sending large numbers of large emails - and the load would be far more distributed as people read their mail, rather than all in one batch when they get sent. (also with any bounced messages - the original email is often attached - and could put additional unneccessary strain on your mailserver) 2: Initial Time to display email Although in absolute terms you're right - it probably take longer to go fetch the images from the live site, the email would appear readable to the recipient as soon as all the mail is recieved - and the images could download in the background as the mail is being read. 3: User Impatience Depending on the file size, and the users bandwidth, they may not be prepared to wait for ages for some unknown massive email to download - whereas when they have it in their inbox they know what it is... 4: Cheapo ISP's restricted mailbox sizes... Some ISP's have really low size limits on their mailbox size - and will bounce messages that won't fit - My old uni only gave 300kb - though I think most commercial ISP's are better... HTH Dan -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 17:00 To: CF-Talk Subject: RE: The biggest cfmail message? At 4:22 PM +0100 8/31/01, Daniel Lancelot wrote: Is this content already displayed online? If so, rather than sending an email with all the images etc attached, you could link to all the image's online locations (absolute href's) and thus reduce your bandwidth requirements substantially (depending on the nature of the content...) HTH Dan Yes, the content is online! The email will have the hrefs as you mention. But, I don't see how this helps the receiver, the email client has to go fetch the images from the live site, as opposed to receiving them as attachments... seems that this would take a little longer. Am I missing something here? Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP - help!
Does the proxy server use NT authentication? Is CF on NT? If so it should be possible to change the account CF uses to one with access through the proxy (possibly need a new account creating...) HTH Dan -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 18:54 To: CF-Talk Subject: RE: CFHTTP - help! That will save the data, but I need to get data first. The proxy server is not authentication my http so I am not ever hitting the site to get any info back. How can I put the username and password in the cfhttp call so that the proxy will allow the request to go through. The username and password in the cfhttp call does not do the trick. Christian -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 12:36 PM To: CF-Talk Subject: RE: CFHTTP - help! Try specifying an absolute path for the contents of the CFHTTP Get request to be stored in. Thank you, Dan Phillips Express Technologies, Inc. dba CFXhosting.com -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 1:41 PM To: CF-Talk Subject: CFHTTP - help! Does anyone now how to authenticate with a proxy server using the cfhttp tag. trying to submit a page to an external site then return info to internal. Some people may not have external access so I have to do it at this level. Any help would be great! Christian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Scheduled Task and CFHTTP
Yup - We just come up against this - the remote server returns error code 500: HTTP/1.1 500 Internal Server Error Date: Fri, 31 Aug 2001 09:14:24 GMT Server: Apache/1.3.12 (Unix) mod_ssl/2.6.6 OpenSSL/0.9.6 Content-Length: 125 Connection: close Content-Type: text/html this occurs using CF5 on 3 different servers on 2 different networks... The same code runs fine on CF4.5 the code we are using: cfhttp method=POST url=DummyURL cfhttpparam name=xmldata type=FORMFIELD value=#xml# /cfhttp Any ideas anyone -Original Message- From: j s [mailto:[EMAIL PROTECTED]] Sent: 16 August 2001 19:57 To: CF-Talk Subject: CF5 Scheduled Task and CFHTTP Hello, We have been using a scheduled task to run a template that contains a cfhttp post for some time now without incident - that is, until we upgraded our dev server to 5.0. At first, I thought it might have something to do with how the code on the page being called is handling the cfhttpparam vars. This just isn't the case, though, because after isolating the cfhttp call and running it on another server with 4.5.1 installed, it works great. It also works when the page is called directly from the browser. The code I have been testing this with is similar to the following: cfhttp URL=http://myurl.com; method=POST port=80 cfhttpparam type=FORMFIELD name=search_str value=test cfhttpparam type=URL name=RequestTimeout value=60 /cfhttp The page being called uses the search_str to query either an Access or SQL Server DB (depending on the application) and populate a wddx packet with the results. Please don't ask why we are using a scheduled task as a way to call a search template - it's a long and complicated story. Just know that it worked with 4.01 and 4.5.1. Has anyone else run into this issue yet with 5.0? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with cfx_xmlparser
I had the same error - I had to reboot ther server to sort it... -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED]] Sent: 30 August 2001 01:23 To: CF-Talk Subject: RE: help with cfx_xmlparser pf, here's the error. A NativeRequest class is missing in your CFX_XMLParser.jar file??? =Error Diagnostic Information java.lang.NoClassDefFoundError: com/allaire/cfx/NativeRequest. Java exception occurred in attempt to locate class 'com/allaire/cfx/NativeRequest' (you should verify that the class is in the CLASSPATH). == Nick Han [EMAIL PROTECTED] 08/29/01 03:55PM Nick you can't send attachments to the list, please send the error in the message body. Thanks -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 4:28 PM To: CF-Talk Subject: help with cfx_xmlparser Has anyone sucessfully implemented cfx_xmlparser found on www.cfdev.com ? I ran the setup and verified all java settings in the cf administrator, and they appeared to be setup correctly. The jvm path, the class path, and the cfx jar path are all there. But when I tried running the example page, I got a java exception. Attached is a snapshot off that error. Any insight on what could have caused this error would be appreciated. Thanks. Nick Han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Xerces and CF
Yup set up the JRE and the xerces.jar in the class path I have a java file which has the line: import org.apache.xerces.dom.DocumentImpl; I then have a line in CF results = xmlXerces.getElementsByTagName(item); where xmlXerces is the name of a cfobject tag. I get the following error: GETELEMENTSBYTAGNAME is not a public field or method on this object. Please verify that this class supports this field or method. The example given in Wrox' Porfessional CF 5 book works fine - so I think everything is set up fine - unfortuneately this example only tells you how to create your own xml structure - not how to load one that already exists The CFX tag written by Pete Freitag works well - but I would like to be able to adjust the structure returned - If I could see how the integration is done in Java - I might be able to write a tag specific to our needs... Cheers, Dan -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 22:38 To: CF-Talk Subject: RE: Xerces and CF I assume you set up the JRE (Java Runtime Engine) in the CF Administrator? If not, then CF won't know what to do with the class files. If it is, check out Ben Forta's Certification Guide. There is a perfect example of how to use Java with CF using the CFOBJECT tag. I can be more specific tomorrow, I left my copy at home. Russel -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 2:38 PM To: CF-Talk Subject: Xerces and CF Has anyone sucessfully managed to integrate CF5 and Xerces, and then managed to parse XML documents??? I've been trying all afternoon, and just keep coming up with java errors - don't quite know where I'm going wrong... (Xerces is set up correctly to work with CF - its just how I then actually use it is the problem... Cheers Daniel Lancelot Web Developer Netstep Corporate Communications Tel +44 (0) 1422 200308 Fax +44 (0) 1422 200306 e-mail: [EMAIL PROTECTED] www: http://www.netstep.co.uk NOTE: The information contained in this e-mail is intended for the named recipient(s) only. It may also be privileged and confidential. If you are not an intended recipient, you must not copy, distribute or take any action in reliance upon it. No warranties or assurances are made in relation to the safety and content of this e-mail and any attachments. No liability is accepted for any consequences arising from it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Xerces and CF
Has anyone sucessfully managed to integrate CF5 and Xerces, and then managed to parse XML documents??? I've been trying all afternoon, and just keep coming up with java errors - don't quite know where I'm going wrong... (Xerces is set up correctly to work with CF - its just how I then actually use it is the problem... Cheers Daniel Lancelot Web Developer Netstep Corporate Communications Tel +44 (0) 1422 200308 Fax +44 (0) 1422 200306 e-mail: [EMAIL PROTECTED] www: http://www.netstep.co.uk NOTE: The information contained in this e-mail is intended for the named recipient(s) only. It may also be privileged and confidential. If you are not an intended recipient, you must not copy, distribute or take any action in reliance upon it. No warranties or assurances are made in relation to the safety and content of this e-mail and any attachments. No liability is accepted for any consequences arising from it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Xerces and CF
Some of them are - others are unkown exception types - basically i am completely new to java - and cant quite see where to start - I manged to get sommething that didnt crash - but I couldnt get any output from it either... Thanks Pete for the tag - I am just trying to get it working now - needed a reboot - and WOW - so much faster than MSXML Thanks for your help... Dan -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 22:04 To: Daniel Lancelot Cc: CF-Talk Subject: Re: Xerces and CF are these classpath issues? On Tue, 28 Aug 2001, Daniel Lancelot wrote: Has anyone sucessfully managed to integrate CF5 and Xerces, and then managed to parse XML documents??? I've been trying all afternoon, and just keep coming up with java errors - don't quite know where I'm going wrong... (Xerces is set up correctly to work with CF - its just how I then actually use it is the problem... Cheers Daniel Lancelot Web Developer Netstep Corporate Communications Tel +44 (0) 1422 200308 Fax +44 (0) 1422 200306 e-mail: [EMAIL PROTECTED] www: http://www.netstep.co.uk NOTE: The information contained in this e-mail is intended for the named recipient(s) only. It may also be privileged and confidential. If you are not an intended recipient, you must not copy, distribute or take any action in reliance upon it. No warranties or assurances are made in relation to the safety and content of this e-mail and any attachments. No liability is accepted for any consequences arising from it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inexact Duplicate queries
One way... If you have a uniqueidentifier across both databases (it should be possible to create one if you dont): Merge the two tables into a new table using a union query, including all fields from both tables. (mergedTable) (or create a view) Select max(uniqueIDfield) as uniqueField, (all the fields that will be the same in duplicates) from mergedTable group by (all the fields that will be the same in duplicates) and put this into another table (table2) (or create a view) then select * from mergedTable where uniqueIDfield in(select uniqueField from table2) and voila - you have your merged data... HTH Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 00:49 To: CF-Talk Subject: Inexact Duplicate queries I'm trying to merge 2 databases together, an having problem with the inexact duplicates. I have no experience in this area, so anyone have any idea on how to do it? Thanks in advance Thanh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Auto-reboot a server
Download the resource kit suppourt tools 4.0 for nt server - theres an app in there called Shutdown - set a scheduled task to run shutdown /c /r and it will force a reboot... I think this is it: http://www.microsoft.com/ntserver/nts/downloads/recommended/ntkit/default.as p -Original Message- From: John Fix 3rd [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 14:47 To: CF-Talk Subject: OT: Auto-reboot a server Is there a utility that I can run with NT scheduler that will restart an NT server? I'm trying to track down some memory leaks, but if I can't solve it before vacation time I want to just set up a way to restart the server every few days at some time in the early am. Thanks! John www.big-box.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: default.ida?
Come on - If anyone wanted to get the ip for his live server - all they have to do is: C:\ping www.cc.uk.com Pinging dynamic.cc.uk.com [193.122.20.5] with 32 bytes of data: An IP addy is hardly confidetial info... any unscrupulous people on this list would quite easily be able to do that... Dan. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 16:05 To: CF-Talk Subject: RE: default.ida? Might be an idea to go away and change the IP addresses on your servers now and abandon these two for all eternity Never put this kind of information out on the list. You are openning yourself up to abuse by the few unscrupulous people on this list... Stephen -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 15:50 To: CF-Talk Subject: RE: default.ida? 193.122.20.5 - Production 193.122.20.8 - Development Why? -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 3:34 PM To: CF-Talk Subject: RE: default.ida? whats yur ip? :-) Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 10:32 AM To: CF-Talk Subject: RE: default.ida? -Original Message- I don't actually think it's hysteria mate, do you want to see a copy of my IDS logs Not really, no. They tend to be boring and full of kidz getting 404's. :-) I did say IDS logs though, they filter out all the crap and only show me the ISAPI Extension Overflow errors. There are a large number of attacks going on as I write this Woo-wee - where have you been ? An ongoing scan of your system is a *FACT OF LIFE* for a system on the internet. My dial-up gateway at home gets scanned ! Tell me about it, then again, my server very rarely blocks anyone, so far today it's implemented over 300 24 bans on various IP addresses in the last 12 hours. That is unusual. and anyone running an unpatched/unprotected IIS server needs to do something about it asap. No, anyone running an unpatched/unprotected IIS server on a public network needs to fired, as their not doing their job. The patch was all over BugTraq et al. well before Code Red was released. Agreed! But, if you look at the domains from which these scans originate, most have no reverse look-up, or are from ISP's like @home shrug and those are just the people who wont care, because Code Red version 2 is non destructive to the local machine. Lot's of Chinese, Japanese, Koreans, Mexicans and a few US and EU academic one's as well.. There are even some coming in as 0.0.0.0 I have had a few responses from some of the ones I thought would take action, some very sheepish IISadmins out there :-) We're averaging a new attempt every minute or so -= Ed ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reboot windows 2K server?
umm - dunno - the nt one might work - id imagine all it does is an API call - which probably hasnt changed between nt and 2k... it seems that the shutdown tool for 2k is only included in the paid for resource kit ($299 i think) - not a free download. If you no anyone handy with any windows programming tool, I imagine theyd be able to program it fairly easily - I wrote a tool that did it approx 5 years ago in vb for win 95... Also I seem to remember theres a few freeware utils that do the same... -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 14:55 To: CF-Talk Subject: Reboot windows 2K server? is there a tool available for rebooting windows 2K server? Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 9:52 AM To: CF-Talk Subject: RE: Auto-reboot a server Download the resource kit suppourt tools 4.0 for nt server - theres an app in there called Shutdown - set a scheduled task to run shutdown /c /r and it will force a reboot... I think this is it: http://www.microsoft.com/ntserver/nts/downloads/recommended/ntkit/default.as p -Original Message- From: John Fix 3rd [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 14:47 To: CF-Talk Subject: OT: Auto-reboot a server Is there a utility that I can run with NT scheduler that will restart an NT server? I'm trying to track down some memory leaks, but if I can't solve it before vacation time I want to just set up a way to restart the server every few days at some time in the early am. Thanks! John www.big-box.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio 5.0?
how much does it differ from 4.52? -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 16:26 To: CF-Talk Subject: Re: Studio 5.0? Mike, I've been using Studio beta 2 since last Thursday. Beta 1 was not fun. I got many fatal exceptions and file sharing violation errors. This version is behaving much better so far. The file tab also hung in beta 1 (didn't refresh when I switched directories) This problem also seems to be fixed. Loryn Tangorre, Mike wrote: Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
from BOL: text Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. You really need more than 2GB of data??? in one text field??? WOW... -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 17:05 To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: http server for windoz ME?
how about apache? -Original Message- From: Chuck Hergenroeder [mailto:[EMAIL PROTECTED]] Sent: 23 July 2001 13:45 To: CF-Talk Subject: RE: http server for windoz ME? There is a way to Install PWS on ME, I did it when ME first was released because my new laptop came with it. I have since switched to Win2K Pro, thank god. Anyway, you have to jump through a lot of hoops to install it, and it may not work correctly. There was a step by step walk through somewhere on Microsoft's website, I don't have the exact URL. Chuck Hergenroeder Web Developer RedSiren Technologies Inc. 412 281 4427 -Original Message- From: Laszlo Nadai [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 21, 2001 8:07 PM To: CF-Talk Subject: OT: http server for windoz ME? My new notebook came with m$ ME. I was trying to install IBM's http server, but it didn't install (said I needed NT4). Is there any free http server to help develop CF while on the run with a ME notebook? TIA, laszlo If it's too OT, please reply to: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Column names containing a # sign
have you tried doubling your # ie product# = product## etc - cf should convert that to a single # before passing to db... -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:18 To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is it really POST?
also - if you fully scope all your variables, (form.* url.* variables.*) it prevents people from (easily) changing a variable they should not change... (although the standard caveats about manually submitted http requests would still apply) -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 08:30 To: CF-Talk Subject: Re: Is it really POST? Check the value of the cgi variable CGI.REQUEST_METHOD. Jim - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 12:40 PM Subject: Is it really POST? How can I check if the .cfm file was submitted using POST and not GET? (I'm trying to prevent, as possible, people to submit the params using URL and not form fields). Thanks, Michael Lugassy ~~ 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: A page call in any IMG tag???
Hi - this is an example with cf... http://www.vboston.com/DepressedPress/Content/ColdFusion/Essays/GIFAsPipe/In dex.cfm HTH Dan -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 07:03 To: CF-Talk Subject: A page call in any IMG tag??? Hi all, I was looking at an email the other day and there was a .jsp page url in the src attribute of an image tag. example: img src=www.domain.com/thispage.jsp?param1=yesparam2=yes I figure that this is how they track if someone read the email, and would like to do something similar. Has anyone ever heard of, or done this? Thanks for any info on the subject, 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: cflocation killing session vars
If the page cflocated FROM is the first page accessed in that domain, then the the CFID and CFTOKEN will not be defined, as they are stored by CF in a a cookie, and CFLOACTION prevents the cookie from being written. You may be able to get round this by using addtoken=YES in the cflocation tag. HTH Dan -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: 03 July 2001 12:32 To: CF-Talk Subject: cflocation killing session vars Hi, I usually use Client variables in this application, but in this instance I need to use a session variable which will then be killed off when the browser closes. Basically I have something like this setup: Cflock scope=SESSION timeout=15 cfset session.localads = 1 /cflock cflocation url=#new_address# addtoken=no When the user is taken #new_address#, session.localads doesn't exist - how come? Thanks -- Will new media discussion for Berkshire -=- http://bnm.lukrative.com local classifieds -=- http://www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 ~~ 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: sorting by IP addresses...
you could convert it back to an int, but then every ip starting 128 or above would display before those = 127 (negative) so Id think char(32) would be best - and store the actual binary string. -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 16:32 To: CF-Talk Subject: RE: sorting by IP addresses... Wow... now that looks so simple... Thanks a bunch Marlon Will get that implemented tonight Now what would the most efficient way be to store that value in an ACCESS database? Love this list... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Marlon Moyer [EMAIL PROTECTED] Date: Thu, 07 Jun 2001 09:24:31 -0500 Subject: RE: sorting by IP addresses... cfset myIP=192.168.1.1 cfset myBinaryIP= cfloop list=#myIP# index=byte delimiters=. cfset myBinaryIP=myBinaryIP numberFormat(formatBaseN(byte,2),) /cfloop -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 8:41 AM To: CF-Talk Subject: Re: sorting by IP addresses... Thanks Hank... the conversion for the 32bit binary would seem best... So has anyone wrote a function/Cf code to convert IPs to their binary representations? Had seen it done elsewhere in this manner and trust the designer... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Hanz Zarcovic [EMAIL PROTECTED] Date: Thu, 07 Jun 2001 09:20:48 -0400 Subject: Re: sorting by IP addresses... Paris, I imagine if you are writing some log analyzing software that you are dumping the logs into a database for easier analysis ? If you are dumping them into a database then you should just do some simple string parsing to break the IP address up into 4 tiny int fields in this way you'll be able to do any sort of funky processing you want to them. Or to get really freaky why not process them back into their 32 bit binary representations grin If you want some SQL ideas just let me know. -eric - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:35 AM Subject: sorting by IP addresses... So I am writing some log reporting for my enjoyment... well to make things a little easier to quantify... one thing I want to be ablt to do is ORDER queries by the value stored of the viewers IP ADDRESS... It doesn't work without some modification of the IP address... anyone worked on anything to do this right... for instance I get this in order: 216.56.6.245 216.66.132.134 24.16.140.8 24.165.85.118 24.178.211.39 not exactly right :) ideas please... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ 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: how to NOT get a cross join
How about using left outer join: SELECT [emailAlerts].[emailAlert_ID], [emailAlerts].[Category_id], [CATEGORIES].[Category_name], [emailAlerts].[email], [emailAlerts].[Category_id], [emailAlerts].[ADVERT_TYPE], [emailAlerts].[Name] FROM emailAlerts left outer join CATEGORIES on [CATEGORIES].[Category_id])=[emailAlerts].[Category_id] That should give you all records with corresponding categories, and those without any matching categories HTH Dan -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 16:00 To: CF-Talk Subject: SQl:how to NOT get a cross join hi hope someone here can give me a hand with this:(sorry for the cross post) I have a table called categories, the key bieng an int, with a field for the category name. Another table called adverts, an advert has a category feild which is a foreign key which links to the category table. I realised i could create a view which would join the two tables so i would have a virtual table which would have the category name field. BUT using this: SELECT [emailAlerts].[emailAlert_ID], [CATEGORIES].[Category_id], [CATEGORIES].[Category_name], [emailAlerts].[email], [emailAlerts].[Category_id], [emailAlerts].[ADVERT_TYPE], [emailAlerts].[Name] FROM CATEGORIES, emailAlerts WHERE ((([CATEGORIES].[Category_id])=[emailAlerts].[Category_id])) OR emailAlerts.Category_id = 0; I find i get duplicates with say all the records with all the categories like a cartesian product kind of thing because there is no category with the ID of 0 the query returns records with this value with every value in the category table. many thanks in advance ~~ 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: Multiple Application Variables
Are these sites on the same domain? - If they are on different domains, than the server will see each client as a different client - and so the session.dealerid will be held concurrently over the different sites. If they are on the same domains, you'll have to use some non persistent record of the dealerid - on url/form etc. HTH Dan -Original Message- From: Mark Terrill [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 04:21 To: CF-Talk Subject: Multiple Application Variables This is a multi-part message in MIME format. --=_NextPart_000_0067_01C0EDC2.67E0D4C0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Has anyone had a situation where there is a central site that spawns = 'dealer sites' which have their own look and feel but run off a central = location, with their own shopping cart session variables. The dealer is = stored as session.dealerid to keep track of what dealer interface should = be displayed.=20 Does anyone have any suggestions on how to enabled a visitor to have = multiple browser windows open that are looking at different dealer pages = with no crossover between the browser windows (due to sharing the = session.dealerid). Any suggestions on an applicable system would be = greatly appreciated. Regards, Mark --=_NextPart_000_0067_01C0EDC2.67E0D4C0 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3DMSHTML 5.00.2614.3500 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Has anyone had a situation where there = is a central=20 site that spawns 'dealer sites' which have their own look and feel but = run off a=20 central location, with their own shopping cart session variables. The = dealer is=20 stored as session.dealerid to keep track of what dealer interface should = be=20 displayed. /FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Does anyone have any suggestions on how = to enabled=20 a visitor to have multiple browser windows open that are looking at = different=20 dealer pages with no crossover between the browser windows (due to = sharing the=20 session.dealerid). Any suggestions on an applicable system would be = greatly=20 appreciated./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Regards,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Mark/FONT/DIV/BODY/HTML --=_NextPart_000_0067_01C0EDC2.67E0D4C0-- 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: Use interactive CF debugger!!! : was VeRy tricky evaluate()
One Problem I've come across, is if you have multiple CFservers set up with mappings, that it doesnt tend to automatically use the correct one based on your mapping (I think it selects the first one alphabetically) HTH Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 15:51 To: CF-Talk Subject: RE: Use interactive CF debugger!!! : was VeRy tricky evaluate() Don't know how far you've got, but first step is to set up a development mapping, and then make sure you can browse the page from within cf studio. Then open the page you want to start debugging and set a break point on a line of cf code. You should do this on any subsequent pages as well, if you don't it tends to fall over. I've found you can move through many pages, even via cflocation as long as you have a break in each page. Click on the start debug arrow button or press ctrl F5. You get to select a page to start from, make sure you pick the right page and the right development mapping and click ok. It should go to the page and stop. Sometimes it takes a couple of goes to connect to the server. Once in you can step through code, view variables, evaluate variables look at query record counts, look at the output set watches etc. But so much easier than staring at a bit of code that doesn't work. Maybe I've just been lucky in getting it running - I'm using NT4 CF4.5, but as far as I know there isn't any reason why it wouldn't, as long as your developemnt mappings work. Does anyone else know why there are probelms using it, or is it just the case that most people havn't bothered with it? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:42 To: CF-Talk Subject: RE: Use interactive CF debugger!!! : was VeRy tricky evaluate() After many many attempts i still have not got it working this may be due to the fact that i'm not sure exactly how it is supposed to work. Do you have an tips/pointers? Thanks Kola -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:24 To: CF-Talk Subject: Use interactive CF debugger!!! : was VeRy tricky evaluate() Seems to me the only way you could find your way out of this one is to use the cfstudio step through debugging. You may be doing so already but I get the impression not many cf developers use this, perhaps because it can be temperamental. But I've found it invaluable now I've got it working. It can save you mountains of time and brain ache. I'd recommend spending the time to get it running. I had it working on a stand-alone but I'd been led to believe it wouldn't work well on a network, but it does, sometimes it takes a few attempts to connect. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 16:45 To: CF-Talk Subject: VeRy tricky evaluate() I'm in a complex situation here which gives NO ERRORS but doesn't seem to work right. please help. My project has several unique sections (where the key=grid) Every user can upload several images to each group. everytime he uploads at least 1 file to a new group, I'm assigning him a session array variable that is called: session.my#url.grid#: cfif NOT isDefined(session.my#url.grid#) cflock timeout=10 throwontimeout=Yes type=EXCLUSIVE scope=SESSION cfset session.my#url.grid#=Arraynew(1) /cflock /cfif then I give him the upload form. after each upload, I'm appending the array with the new file: cflock timeout=10 throwontimeout=Yes type=EXCLUSIVE scope=SESSION cfset temp=ArrayPrepend(evaluate(session.my#url.grid#),file.serverfile) /cflock and now I want to display back the upload form, but with a list of the files he already uploaded: first I'm moving the session array into a local variable: cfif isDefined(session.my#url.grid#) cflock timeout=10 throwontimeout=Yes type=READONLY scope=SESSION cfset a=evaluate(session.my#url.grid#) /cflock then I'm looping without worrying for locking: Files that were uploaded to #url.grid#: cfloop index=i from=1 to=#arraylen(a)# #a[i]# /cfloop the a array keeps being EMPTY all the time. I'm checking that with this: cfif NOT isDefined(a) or arraylen(a) eq 0 You haven't uploaded any pictures to #url.grid# yet. /cfif note that I don't want to : a. query the db everytime to get the list of files that was uploaded. b. limit the session timout to 1 minute Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ 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: Another Access 2000 Date/Time Sort Thingie
use datepart function to sort by:
SELECT FirstName, LastName, Birthday, Met, Email, Address1, City, State,
Zip, Phone
FROMwobinfo
ORDER BY DATEPART(m, birthday), DATEPART(d, birthday);
HTH
Dan
(note the datepart function is slightly different syntax in access and SQL)
-Original Message-
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 06:42
To: CF-Talk
Subject: Another Access 2000 Date/Time Sort Thingie
I have a list of birthdays here:
http://ann.bourbon.hoosierlink.net/Wob/BirthdayForm.cfm
Right now I have all the years at 2001 and 2002 so they will sort correctly,
by month. What I want is to be able to have have them sort by the month then
day then year.
so they might apear as
January 26, 1956
January 31, 1960
February 2, 1948
March 30, 1970
Dates are entered in the Access Database:
1/26/1956
1/31/1960 ect.
CFQUERY NAME=GetBirthday DATASOURCE=wobbersmet
SELECT FirstName, LastName, Birthday, Met, Email, Address1, City, State,
Zip, Phone
FROMwobinfo
WHERE Birthday (Now())
ORDER BY WobInfo.Birthday
/CFQUERY
cfinclude template=Toolbar.cfm
TABLE WIDTH=50% BORDER=0 CELLSPACING=2 CELLPADDING=2
THFirst Name/TH THLast Name/THTHBirthday!/TH
CFOUTPUT QUERY=GetBirthday
TR BGCOLOR=#IIF(getbirthday.currentrow MOD 2, DE ('FF'), DE
('DF'))#
TD#FirstName#/TDtd#LastName#/tdTD#DateFormat(Birthday,
dd, )#/TD
/TR
/CFOUTPUT
/TABLE
/TABLE
Ann Harrell
Harrell Computer Enterprises
Phone: 219.342.0618
eFax: 603.843.9212
~~
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: CFPROCPARAM - CFSQLTYPE for UniqueIdentifier?
I think the problem will be that MS GUID's in SQL and the UUID's created using createUUID() are not the same format - the -'s are in different positions in each, so the only way to store a UUID is to use something like varchar field, or to parse the UUID to comply with SQL's GUID's... -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 03:37 To: CF-Talk Subject: CFPROCPARAM - CFSQLTYPE for UniqueIdentifier? I can't seem to get CFSTOREDPROC to accept a SQL UUID type variable. I've tried CF_SQL_VARCHAR, CF_SQL_CHAR, and CF_SQL_IDSTAMP, and they all return an error of Error converting data type varchar to uniqueidentifier. Anyone run into this before? The variable in question is a MS SQL Server 7 uniqueidentifier datatype. This is the CFPROCPARAM language in question: CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=PageID VALUE=#Attributes.PageID# NULL=No This is the stored proc in question: CREATE PROCEDURE GetPage @PageID UniqueIdentifier AS SELECT PageID,PageName FROM Pages P WHERE P.PageID = @PageID AND P.IsActive = 1 -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 ~~ 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: cfpop and multi part messages
Might be wrong - but isnt the message normally included as an attachment (at least I think thats how outlook displays it...) - maybe you need to process the attachment... -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 21:47 To: CF-Talk Subject: cfpop and multi part messages Hi, I am using cfpop to retrieve undeliverable mail and mark an account as such. When I look in the mail server mailbox the message is a multi part/mixed message which contains in the first part the reason the message could not be delivered and the actual message in the second part. Cfpop is only retrieving (or displaying) the first part of this multi part message. I need to get the whole thing. Anybody have any ideas? Brook Davies maracasmedia Inc ~~ 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: Curious about CFIF
What I have heard, is that when using CFIF, the code within the CFIF is parsed, even if the condition is not met. However, when using cfswitch, only the section matching the criteria is parsed. (this is second hand from some notes from a presentation given by Ben Forta - I am only 95% certain this is correct - I may have got the wrong end of the stick...) HTH Dan -Original Message- From: Tony Hicks [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 09:14 To: CF-Talk Subject: Curious about CFIF When you have a CFIF with a CFELSE or CFELSE IF... does cold fusion only read the code inside the matching condition? For instance cfif name is 'bob' Name = Bob cfelseif name is 'joe' Name = Joe /cfif If the name is 'bob' does CF pay any attention to the content to be processed if the name is joe? and if the name is joe, does it pay any attention to bob's content since it comes first...? Curious, Tony Hicks - Original Message - From: Bryan LaPlante [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 3:12 AM Subject: Re: Logon Attempts To resolve the problem put this code into login.cfm cfif isDefined(client.counterVar) cfset client.counterVar = IncrementValue(client.counterVar) cfelse cfset client.counterVar = 1 /cfif You can use cfinclude or call the login.cfm as a custom tag, either way the client scope will persist to the next page load where you can check it for the appropriate action. - Original Message - From: Jerry Staple [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:35 AM Subject: Logon Attempts Could anyone inform tell me what would be the best way to implement a logon page where the user gets 3 attempts to logon,after the 3 attempts the user is directed elsewhere.I have tried setting a variable on the application page then adding +1 when it goes to the Logon_Action.cfm but to no avail. Help Regards Jerry Staple Web Applications Developer Biznet Solutions 133 - 137 Lisburn Road Belfast BT9 7AG www.biznet-solutions.com Tel: +44 (0)28 90205652 Fax: +44 (0)28 9022 3223 ~~ 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: Request vs application scope
Absolutely no problem... I do it regularly... -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 08:34 To: CF-Talk Subject: Request vs application scope I am using the following line of code in my application.cfm cfset request.HomeDir = http://127.0.0.1/work/ACME/may2001/website; Then elsewhere in the site I refer all links and images to: cfoutput#request.HomeDir#/cfoutput Is this OK to do? I'm trying to avoid using the application scope. Are there any known of issues with this method? Thanks. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Request vs application scope
Yes thats right. -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 13:51 To: CF-Talk Subject: RE: Request vs application scope Thanks. Can I put any data in there that I want to use across the site? And I don't have to apply CFLOCKs do I? -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 2:32 PM To: CF-Talk Subject: RE: Request vs application scope Absolutely no problem... I do it regularly... -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 08:34 To: CF-Talk Subject: Request vs application scope I am using the following line of code in my application.cfm cfset request.HomeDir = http://127.0.0.1/work/ACME/may2001/website; Then elsewhere in the site I refer all links and images to: cfoutput#request.HomeDir#/cfoutput Is this OK to do? I'm trying to avoid using the application scope. Are there any known of issues with this method? Thanks. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Request vs application scope
But using request vars means the memory is released immediately the request has finished... I would agree if you are planning to store large/complex data (esp query result sets etc) then its probably best to use app scope... But would you consider it best if there are just a few simple vars (maybe 100B)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 15:07 To: CF-Talk Subject: RE: Request vs application scope That's the downside! Also, they are unique to each request, so memory processor usage will increase by a set amount for each page request. e.g. APPLICATION scope cflock scope=APPLICATION . cfif NOT IsDefined( APPLICATION.TestVar ) !--- Set up (say) 2KB of application variables --- /cfif /cflock - First request, you get a CPU performance hit while you set up the app. variables, and 2KB of memory is taken up by the variables. - Subsequent requests will detect the existence of APPLICATION.TestVar, and not bother setting the variables up again. - Total memory usage - 2KB for the application variables, however many page requests are made. REQUEST scope - cfset REQUEST.(whatever) = (whatever) . . . !--- set up the same 2KB of variables in the request scope --- - Every single request will use the CPU while setting up the variables, and need the 2KB of memory for itself. - If you're in a frameset, that's (say) 3 times the CPU usage and an extra 4KB of memory per client, per hit. - Total memory usage - 2KB * number of frames * number of simultaneous users. If you're using the scope to store queries or other complex objects, or even long strings, you're going to end up with a fairly hefty performance hit. Alistair Davidson Senior Developer Rocom New Media www.rocomx.net -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 14:43 To: CF-Talk Subject: RE: Request vs application scope Brilliant! So what's the downside? The variables are not persistent across pages are they? -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 2:56 PM To: CF-Talk Subject: RE: Request vs application scope Yes thats right. -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 13:51 To: CF-Talk Subject: RE: Request vs application scope Thanks. Can I put any data in there that I want to use across the site? And I don't have to apply CFLOCKs do I? -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 2:32 PM To: CF-Talk Subject: RE: Request vs application scope Absolutely no problem... I do it regularly... -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 08:34 To: CF-Talk Subject: Request vs application scope I am using the following line of code in my application.cfm cfset request.HomeDir = http://127.0.0.1/work/ACME/may2001/website; Then elsewhere in the site I refer all links and images to: cfoutput#request.HomeDir#/cfoutput Is this OK to do? I'm trying to avoid using the application scope. Are there any known of issues with this method? Thanks. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTTP Headers, firwalls and malicious users
It says as much in the CF documentation - cgi variables will always be defined - just empty if non-existant... -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 11:45 To: CF-Talk Subject: Re: HTTP Headers, firwalls and malicious users Bud [EMAIL PROTECTED] wrote in message news:p04320405b7327f745737@[ I'm pretty sure that cgi variables are always present, just empty if not contained in the request or not supported by the web server, so you don't have to check if they are defined. Doing some tests, I've got a similar feeling too. Thanks Massimo ~~ 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: Pre test / Post test
What I have done in the past is to use cfset duplicatevalue = 1 cfloop condition=duplicatevalue eq 1 generate random value... if random value not in list then... cfset duplicatevalue = 0 cfloop HTH - Dan - Original Message - From: Francis, Jennifer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 4:54 PM Subject: Pre test / Post test I'm trying to create a pretest/post test with the same questions except for the order changes for the post test. The question numbers questions are stored in the database, so I just need to pull them by the question number. I have tried to use randrange, but it creates duplicates. Is there an easy way to make sure the list does not contain any duplicates? Here's what I have so far... cfoutput cfset randlist= cfloop index=i from=1 to=10 CFSET randques=#randrange(1,10)# cfif listcontains(randlist, randques) CFSET randques=#randrange(1,10)# /cfif cfset randlist=listappend(randlist, randques) /cfloop #randlist# /cfoutput Jennifer Francis ATT Wireless * [EMAIL PROTECTED] ATT Proprietary - Use pursuant to company instructions Attention: Information contained in this EMAIL, including attachments, may contain sensitive or ATT proprietary information. Please use pursuant to company instructions. Take care not to disclose proprietary information, and forward this EMAIL and its attachments with caution only to those that have a need to have this information. ~~ 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: Simple SQL SELECT
You cant mix summary functions with normal selects in SQL To do what you want in CF, you're probalby best using queryname.recordcount in CF. cfquery name=queryname SELECT phID, phCOL FROM photos WHERE phGROUP='#grid#' AND phCOL IS NOT NULL GROUP BY phCOL /cfquery cfset cophotos = queryname.recordcount HTH Dan -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 03 May 2001 11:11 To: CF-Talk Subject: Simple SQL SELECT I'm trying to simply select a few colums from a table (phID,phCOL) + the count of that certain select each time into a variable (coPHOTOS) SELECT phID, phCOL, COUNT(phID) As coPHOTOS FROM photos WHERE phGROUP='#grid#' AND phCOL IS NOT NULL GROUP BY phCOL I keep on getting an error: Column 'photos.phID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. What is wrong? Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Partners List
I've found that if you group by conversation (outlook 2k), you seem to get your mails sorted roughly iin the order they arrive - newest at the top - as oppossed to grouping by subject, where they arrive 1/2 way down a list of x,000 subjects... -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 12:37 To: CF-Talk Subject: RE: CF-Partners List Hewolses, If you use Microsoft Outlook, you can turn on Group Sorting, and sort the emails by Subject. That helps a lot if you want to read a particular thread of conversation, and is practically the same thing that the webbased archives will do for you, except that doing it on your own computer is a lot quicker. -Gel www.carigamer.com Island Gaming At Its Best!(tm) -Original Message- From: Bonnie Betts [mailto:[EMAIL PROTECTED]] Ya know, I was thinking Is there an archive section of subjects or list postings etc that I'm not aware of? Does anyone have a suggestion for a 'wander CF Devr' to stay current (while being practical with time restraints)? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 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
RE: Dates suddenly formatting incorrectly.
I presume form.festdate is a text field?
The most reliable way of capturing dates correctly on a form is to have 3
select boxes, (day/month/year) with appropiate values in each one.
Then when the user submits use createdate(form.year,form.month,form.day) to
create an unambiguous (is that a word) date stamp.
Its normally a good idea to put that in cftry/cfcatch to catch invalid
dates entered (e.g. 30/02/01)
If you use createodbcdate() on that, then the data in db is correct.
You can then use dateformat() to display it how you want...
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 20 April 2001 11:47
To: CF-Talk
Subject: FW: Dates suddenly formatting incorrectly.
Hi all,
Strange one this, it has me totally perplexed on this Friday morning.
I have several sites which have events pages. The site admin can upload
details of new events, including their dates. This all worked fine until
yesterday, when two of them started acting strangely, like so:
User inputs date: 26/05/01
Date as shown in Access2000: 01/05/26
For some reason it seems to be swapping around the day and year. The date
field is a short date.
This is the code for uploading the date:
cfif IsDefined("Form.festdate")
cfset festdate = #CreateODBCDate(Form.festdate)#
/cfif
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
cfquery name="addfest" datasource="#datasourcename#"
INSERT INTO tblfestticks (production, festdate, notes)
VALUES (#Form.production#, #festdate#, '#Form.notes#');
/cfquery
So, I tried changing the date line to this:
cfset festdate = #CreateODBCDate(#DateFormat("#Form.festdate#",
"dd/mm/yy")#)#
and the date 26/05/01 became 05/01/26!!
Now I'm really confused, and whilst I'm sure one of you guys will take one
look at this and sort it out, I am completely stumped.
Regards,
Will Swain
~~
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: update
What db you using??? -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 15:02 To: CF-Talk Subject: update is there anyway to output the last primary key number in a table after an insert statement? i need to capture that number on the same action page so i can pass it to another table. in other words, on my insertApp.cfm i have the query to update my apps table. but on this same page at the bottom, i have another form...a form to update the licensing. when i submit this form, i need that primary key from my apps table to pass thru to my licensing table. so i need a way to capture that value. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: Weird CFFile behaviour with Mac IE5 upload
Problem is caused by MAC putting space in instead of an empty field - try using trim() when checking the field to see if it has been filled. -Original Message- From: Alex Skinner - Digital Dreams [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 10:46 To: CF-Talk Subject: RE: Weird CFFile behaviour with Mac IE5 upload Why not check the form field for the existance of a \ even if the form field is not "" is shouldn't contain a \ unless a file has been selected In addition check that the form field length is greater than 5 i.e valid 3 letter extenstion + the . + at least one \ HTH Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cameron Sent: 28 March 2001 03:57 To: CF-Talk Subject: Weird CFFile behaviour with Mac IE5 upload HI, Has anyone found that using CFFile to upload a file from a Mac IE5 browser behaves funny? My precise problem is that if a form contains a input type="file" name="theFile" field it is left blank, CF will consider that a file has been uploaded (empty file?). Using cfif form.theFile NEQ "" to check if the file field was empty no longer works. It always contains a filename. Anyone else found this? Anyone know a solution? Cameron 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: remote site MySQL or local Access?
Well certainly on the $5.99 account you get what you pay for... It doesn't seem to go down quite as much as the free sites, maybe twice a month? Not good... but still good value... Depends how critical the site is - For a small charity site etc Id say it was reasonable... -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 07:21 To: CF-Talk Cc: Garza, Jeff Subject: RE: remote site MySQL or local Access? From: Garza, Jeff [mailto:[EMAIL PROTECTED]] What server are they running on? Unix, WinNT ??? This sounds like it might be best to look at a different tool. Perhaps Perl on Unix or ASP on NT... Perl running the DBI for MySQL cranks! Just a thought. They are running Linux... apart from that I don't really know. About four months ago they promised to install PHP on the box for me but they claim they are having difficulties getting it installed and don't have enough time to sort it out. I was willing to learn a little PHP but as it's way overdue now and I don't get any money from it I think it would be best to stick with what I know, which is CF. If you decide to go ahead with it, you'll be better off using the Access DSN on CFM-Resources. The performance hit of going across the pond multiple times would probably be too much. I've stored hundreds of tables in a single access DB. Shouldn't be too much of a problem. That was kinda what I was thinking... it's just that there are so many horror stories about using Access that I was a little reluctant to trust it. What about CFM-resources.com? I realise that with free hosting you get what you pay for, but CF hosting in Australia is ridiculously expensive compared to what I've seen in the US. I was thinking I could start out on the free account and if it all works out well and I can convince someone to pay for it, upgrade to a paid account later. Does anyone have any experience with their paid hosting? Is it any more reliable than the free? And if not, are there any other "budget" CF hosts out there I might consider? Thanks again, K. Original Message- From: Kay Smoljak To: CF-Talk Sent: 3/22/01 10:52 PM Subject: remote site MySQL or local Access? Hi all, I have a non-profit site that I look after. It used to be all manually updated HTML but they are looking at expanding it a bit and I'd like to transfer some of the updating from myself to the committee members. As they are not well-funded, at the moment I'm thinking of using frames, hosting the CF elements of the site on CFM-Resources (the free account to start with, although I would consider paying the one of the other options myself later on if it was going to be more reliable) and the static pages/framesets on their donated Australian university hosting space and domain name. (The domain name is a subdomain of the university's and is quite well known to their audience, so they can't change it or move it elsewhere, before someone suggests that). With regards to the database I have two options that I can see: use the Access dsn that is part of the CFM-Resources account, or use MySQL which is installed on the Linux web server at the Australian university. I'm not sure if MySQL is actually all that much better than Access (the traffic on the site is really low, about 10-15 visitors per day at the moment) or if accessing a remote database would be too slow (and is it even possible?). Does anyone forsee any major flaws in my master plan or have any recommendations? Suggestions please! Thanks, Kay. ~~ 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: Converting Seconds to Hours,Minutes,Seconds
Cheers - I knew about MOD, but not about div (\) in CFML (all listed out under operators in CF docs if I could have been bothered reading it !!!) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 20:50 To: CF-Talk Subject: RE: Converting Seconds to Hours,Minutes,Seconds Combining mine and Daniel's ideas, heres the fastest version I could make...19 ms on my server. cfscript seconds = 5600.25; hours = seconds \ 3600; seconds = seconds mod 3600; minutes = seconds \ 60; seconds = seconds mod 60; /cfscript cfoutput#hours#:#minutes#:#seconds#/cfoutput Brian -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 3:39 PM To: CF-Talk Subject: RE: Converting Seconds to Hours,Minutes,Seconds Thanks, that's what I was looking for. Jason -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 1:33 PM To: CF-Talk Subject: RE: Converting Seconds to Hours,Minutes,Seconds Try this - it works... cfscript numsecs = 5600.25; hours = int(numsecs/3600); minutes = int((numsecs / 60) - (hours * 60)); seconds = numsecs - (hours * 3600) - (minutes * 60); /cfscript cfoutput #hours#:#minutes#:#seconds# /cfoutput -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 20:01 To: CF-Talk Subject: Converting Seconds to Hours,Minutes,Seconds I was wondering if there is anybody out there that has a piece of code that will help me solve my little problem that I am having? I need to take a number i.e. 5600.25 seconds, and find out how many hours are in that number, how many minutes, and how many seconds are remaining. New to CF, and I am struggling a little bit on this one. Thanks for your help Jason Larson [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: Exposing MS SQL7 Table to CF
I think what you might have done is not select a db in CF Admin when you set up the datasource. If you do not set up a database, then it will show you the master database, which contains a load of system tables with odd names... Have a look in cfadmin and see if a db has been specified... (Datasources, ODBC, click datasource link, next to login info there is a box called database - this should have the name of the db as specified under SQL server...) HTH Dan, PS (if you havent named the db, I have found that if you then add the db name in cfadmin, you will be able to retrive it fine in CFML code, but it wont show up right in cfstudio until you restart CF RDS service (but this might just be me...)) -Original Message- From: Eric Root [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 06:39 To: CF-Talk Subject: Exposing MS SQL7 Table to CF First time submission to CF-Talk and new to CF, so please be kind... stupid question, but I gotta start somewhere, right? Setting up a very simple SQL7 table and stored procedure to do my first stored procedure call. Created the database. Set access to public for all parameters. Entered data. Set up SP. Ran SQL7 query okay. Created DNS. Data source shows up in Studio data resource tab. Data source verified in the CF administrator. Problem: The table I created is not listed in the data source tree. Tables such as dbo.MSreplication, dbo.spt_committab, dbo.spt... etc. etc. show, but not my table. I tried checking and unchecking Use Trusted Connection in the administration ODBC page and it didn't make any difference. I have all the check boxes checked for the CF restrictions parameters. I don't understand what I am missing, since the table is opened up to the whole world using public. Why doesn't CF see the table? -- Eric Root Environmental Management Systems Inc. Web Site: http://www.mountainmyst.com/emsi/emsi_home.htm Phone (Voice): (509) 548-0243 Phone (Fax): (509) 548-0244 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: query result to list
CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#" SELECT ID, Title, Name FROM Options /CFQUERY cfset list = ValueList(getOptinfo.Name) look up query functions in cfdocs for moore info... -Original Message- From: Ethan Rosch [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 15:47 To: CF-Talk Subject: query result to list Hi all, what's the easiest way to get the outut of a query into a list? ex. CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#" SELECT ID, Title, Name FROM Options /CFQUERY and I want to access the resulting Names as a list? List(rob,ray,eddie,eagle) thanks, s ~~ 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: Coldfusion access to a DSN-less SQL 7.0 =
It is possible, as long as you have a dsn on the system pointing to a SQL 7.0 ds - then access tables etc. as #dbname#.dbo.#tablename# HTH Dan -Original Message- From: Winston Sia [mailto:[EMAIL PROTECTED]] Sent: 01 March 2001 02:51 To: CF-Talk Cc: [EMAIL PROTECTED] Subject: This is a multi-part message in MIME format. --=_NextPart_000_003A_01C0A23D.8EED6040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI, Is it possible for Coldfusion to have access to a DSN-less SQL 7.0 = database? This DSN-less database is being used by our ASP templates. Now, we want = to use our CF templates to be able to access this same database.. Any = idea? Our webhost is Hostcentric (Virtualscape) so we would be asking them to = do for us what your recommendations will be.. TIA. Winston --=_NextPart_000_003A_01C0A23D.8EED6040 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArialHI,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialIs it possible for Coldfusion to have access to = a DSN-less=20 SQL 7.0 database?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialThis DSN-less database is being used by our ASP = templates.=20 Now, we want to use our CF templates tonbsp; be able to access this = same=20 database.. Any idea?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialOur webhost is Hostcentric (Virtualscape) so we = would be=20 asking them to donbsp; for us what your recommendations will = be../FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialTIA./FONT/DIV DIVFONT face=3DArialWinston/FONT/DIV/BODY/HTML --=_NextPart_000_003A_01C0A23D.8EED6040-- 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: Coldfusion access to a DSN-less SQL 7.0 =
see my previous reply -this is possible under odbc as long as you already have (and use) a ds already set up on the server (with associated login details etc...) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 11:09 To: CF-Talk Subject: RE: Coldfusion access to a DSN-less SQL 7.0 = this is not possible until CF 5 is released. There has to be an OLEDB dsn setup on the server. If this is done, you can pass the UID,PWD,DB Name, and the server name to access you database. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: @@identity
You need to use SET NOCOUNT ON / SET NOCOUNT OFF round your query to be able
to access the info in cfquery
e.g.
cfquery datasource="#request.dsn#"
name="qAddEntry"
SET NOCOUNT ON
INSERT INTO tblUsers(name, jobtitle,
company, address, town, postcode, countryID, email, website, password, hint,
maillist, brieflist, foundsiteID)
VALUES ('#form.name#', '#form.jobtitle#',
'#form.company#', '#form.address#',
'#form.town#','#form.postcode#',#form.countryID#, '#form.email#',
'#form.website#', '#form.password#', '#form.hint#', #maillist#, #brieflist#,
#form.foundsiteID#)
SELECT newID = @@IDENTITY
SET NOCOUNT OFF
/cfquery --
cfoutput#qAddEntry.newID#/cfoutput
this works.
HTH
Dan
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 20 March 2001 05:07
To: CF-Talk
Subject: RE: @@identity
When I do that CF says not a valid query specified.
-Original Message-
From: CF [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:04 AM
To: CF-Talk
Subject: Re: @@identity
You need to give your query a name. Instead cfquery name="", use cfquery
name="queryName". Then you just access that variable as:
queryName.identity
Also, I don't know it it matters to your database or not, but you might want
to put a ; at the end of your first query to differentiate it from the next
. just to avoid confusion.
Todd Ashworth
Web Application Developer
Network Administrator
Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)
- Original Message -
From: "Joshua Tipton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 11:32 PM
Subject: @@identity
I know how to use @@identity to select the last inserted record right
under
an insert but how do I display that id of that record?
cfquery name="" datasource="gunledger" dbtype="ODBC"
INSERT INTO dbo.distrib(compname, phonenum, address, address2, city,
state,
zip, fflid, expires)
VALUES('#compname#', '#phonenum#', '#address#', '#address2#', '#city#',
'#state#', '#zip#', '#fflid#', '#expires#')
select @@identity as 'identity'
/cfquery
How do I output the identity
Josh
~~
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: link color
What do you want? Netscape to be IE 5.5 compatible??? Netscape 6 supports the DOM in a way far more compatible with the CSS guidelines than either Netscape 4 or IE 5. This does unfortuneately mean that code that worked in Nutscrape 4 and ie 5 probably wont work in NS6 If coded correctly accoring to the CSS standards, code that works in NS6 should normally work ok in IE5... I agree this is a big hassle for developers, but if everyone can work to the same standard, surely this is far better in the long run... Cheers Dan -Original Message- From: Mike Tyranski [mailto:[EMAIL PROTECTED]] Sent: 19 March 2001 23:25 To: CF-Talk Subject: Re: link color Dylan, I've seen Netscape 6 in action and I almost jumped out of my skin. Sites that had working DHTML for Netscape 4.X don't seem to work with Netscape 6. Maybe there is an option you need to turn on in Netscape 6, but I'm not sure. In my opinion, the Netscape browser lacks in support of DHTML as well as overall browser performance. On another note, your 3-layer DHTML menu sounds interesting. Is it on a public domain site that we could peek at? Thanks. Mike Dylan Bromby wrote: I've just built a 3-layer menu in DHTML that works well and didn't need any workarounds, so I would be hesitant to blame DHTML per se. The problem is Netscape 4.x doesn't follow the DOM very well, whereas IE 5/5.5 do a pretty good job. Netscape 6 is supposedly much better, but I haven't used it much. -Original Message- From: Mike Tyranski [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 1:29 PM To: CF-Talk Subject: Re: link color Robert, There is no sure fire way to do this in Netscape that I have found. There is some code at the link below that comes close though: http://www.webreference.com/js/column4/workaround.html This code relies on setting the position of a layer to absolute for every link you do this for. If you are positioning all of your content with DHTML, this might work OK, but I tend not to trust DHTML. Mike Robert Orlini wrote: Any CF tag or coding (even JavaScript) someone can spare out there that changes a color when a mouse goes over a link? It is similar to the DHTML and CSS that does it so well in IE, but would work in Netscape as well. Thanks. Robert O. HW Wilson ~~ 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: Mastering ColdFusion 4.5
If your prepared to send me a free copy, I'll happilly answer all your questions :) -Original Message- From: Kristin Aileen Motlagh [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 14:07 To: CF-Talk Subject: Mastering ColdFusion 4.5 Hello again! Since we are in the beginning of a revision to the Mastering book, I thought it might be good to ask this list for suggestions regarding improvements. One poster mentioned it is slower. I am not sure that this is the general consensus, as I have heard the opposite from many people, but if that happens to be your feeling as well, can you elaborate as to where it is slow? If you feel so inclined perhaps you can answer the following questions as well: 1. Which chapters did you find needed the most improvement? Why? For readability reasons or technical reasons? 2. Were there chapters or sections where the topic could have been more elaborate? Where? 3. Which chapters were the most useful? Did they provide knowledge you did not find elsewhere? 4. Did you find any technical problems in the book such as broken code, incorrect statements, misleading statements? Where? 5. What topics would you like to see covered that are not currently in this book? 6. Do you think this book addressed needs of the beginner developer, intermediate developer, or both? If only one or the other can you explain why? 7. Did you find typos or grammatical errors? Where? 8. Were the examples appropriate? If not, do you have suggestions for better examples? Ok, I know most of you are extremely busy, so if you do not have the time to answer all of the above questions, but would like to respond in some way, please do. But please respond off this list to my personal account: mailto:[EMAIL PROTECTED]. If the comments pertain to my chapters I will seriously consider them while updating, and if not I will forward them to either Arman or Raymond. Thanks for your time! -- Kristin Aileen Motlagh http://www.falkondesign.com Co-Author, Mastering ColdFusion 4.5 Allaire Certified ColdFusion Developer mailto:[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: Converting Seconds to Hours,Minutes,Seconds
Try this - it works... cfscript numsecs = 5600.25; hours = int(numsecs/3600); minutes = int((numsecs / 60) - (hours * 60)); seconds = numsecs - (hours * 3600) - (minutes * 60); /cfscript cfoutput #hours#:#minutes#:#seconds# /cfoutput -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 20:01 To: CF-Talk Subject: Converting Seconds to Hours,Minutes,Seconds I was wondering if there is anybody out there that has a piece of code that will help me solve my little problem that I am having? I need to take a number i.e. 5600.25 seconds, and find out how many hours are in that number, how many minutes, and how many seconds are remaining. New to CF, and I am struggling a little bit on this one. Thanks for your help Jason Larson [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: Virus alert... Eric Hoffman?
I've had that one too! -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 19 March 2001 10:34 To: CF-Talk Subject: Virus alert... Eric Hoffman? Just got this when posting "RE: PWS not starting at boot up". Since receiving the e-mail, I've just upgraded the anti-virus software from Norton 7.0 to Norton 7.5... it didn't alert me to the presence of any virii. Don't know if this is a false alarm or genuine. And, yes, the e-mail ends "To obtain detailed information about wh". There's no more after that. === --[This is an automatically generated email notification.]-- V I R U S A L E R T ! You recently sent a message containing a known virus. The message was sent on 3/19/01 5:00:04 AM. The subject of the message was: "RE: PWS not starting at boot up" The message was sent to the following recipient(s): [EMAIL PROTECTED], [EMAIL PROTECTED] One or more of the recipients listed is a Small Dog Design client. As a result, their copy of the message has been quarantined in a special confinement area and can only be released by their system administrator. This message is only meant to serve as a notification that your message was not delivered to all of the designated recipients. No action is required on your part. Please note, however, that the detection of a virus in a message you sent may be an indication that your computer system has already been compromised by a virus. To obtain detailed information about wh === -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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 Studio 4.5.2 Memory Leak?
OK, in Windoze, Memory is NOT Resources... CFStudio is Resource hungry, not Memory hungry You could have a Win98 machine with 1GB RAM and it'd fail as much as a Win98 machine with 65MB WinNT and Win2k both have a much larger resource pool than Win9x/Me, with 2k being the largest of the lot.. Maybe so, but when I put 256MB extra mem in my 2k box, ""System Slowdown"" stopped being a problem (before after the system had been up/been (heavily) used for a while, system response (menu's/switching apps etc) became quite slow, and nessecitated rebooting) So, while on 9x stability might not be affected by increasing memory, "usability" on 2k is.. I suppose this has more to do with my system usage than anything else, and is a different issue to "stability" (even though stability is percieved by many users as "How often do I need to reboot" + "How often does a program crash") Also, something crashing in NT/2k won't normally bring the machine down, but it will with 9x/Me Totally agree with you - I find this extremely frustrating when using a 9x system after using Nt/2k Cheers 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: Using javascript to create an Undo - the return
only way I can think is to save the form field to a js array every time the user clicks / presses a key... but that could be time consuming to undo if you have to go back one letter at a time... -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 14 March 2001 14:11 To: CF-Talk Subject: RE: Using javascript to create an Undo - the return I think you would need to trap every key depression and mouse click while they were in the textarea. The problem is, you would need to know where the text pointer was at any moment, and I don't see how you could do that reliably if they used the mouse to reposition it. Nick -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:37 PM To: CF-Talk Subject: Using javascript to create an Undo - the return Hi - posted this recently but still no resolution: Have a cf forum we have written, with javascript "Word" like buttons that output html for b, i and u in the input textarea - would like to include an "undo" function with acts like ctrl+Z from the keyboard - in that it will remove either the last piece of text written, or the inputted b/b (etc) tags - any suggestions? 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 Studio 4.5.2 Memory Leak?
-Original Message-
From: Richard Kuryk [mailto:[EMAIL PROTECTED]]
Sent: 14 March 2001 14:32
To: CF-Talk
Subject: RE: CF Studio 4.5.2 Memory Leak?
Cut and paste this in your wordfile, replacing your existing HTML sytanx
section. I have created this over time and in no way is it a complete set
but when I find stuff that isn't highlighted I add it in.
Rich
/L3"HTML" Nocase Noquote HTML_LANG Block Comment On = !-- Block Comment Off
= -- Block Comment On Alt = % Block Comment Off Alt = % String Chars = "'
File Extensions = HTM HTML ASP SHTML HTT JSP CFM CFML
/Delimiters = ~!@$%^*()+=|\{}[]:;"' ,.?
/Function String = "name=*""
/C1"Tags"
A /A ABBR ABBR /ABBR ABOVE ACRONYM ACRONYM /ACRONYM ADDRESS
ADDRESS /ADDRESS APPLET /APPLET ARRAY AREA /AREA
B B /B BASE BASEFONT BDO BDO /BDO BGSOUND BIG BIG /BIG
BLINK /BLINK BLOCKQUOTE BLOCKQUOTE /BLOCKQUOTE BODY BODY /BODY
BOX BR BR BIG BLINK BUTTON /BUTTON
CAPTION CAPTION /CAPTION CENTER CENTER /CENTER CITE CITE
/CITE CODE CODE /CODE COL COLGROUP /COLGROUP COMMENT
/COMMENT
DD DD /DD DEL DEL /DEL DFN DFN /DFN DIR DIR /DIR DIV
DIV /DIV DL DL /DL DT DT /DT
EM EM /EM EMBED
FIELDSET FIELDSET /FIELDSET FIG FONT /FONT FORM FORM /FORM
FRAME FRAMESET /FRAMESET
H1 H1 /H1 H2 H2 /H2 H3 H3 /H3 H4 H4 /H4 H5 H5 /H5
H6 H6 /H6 HEAD HEAD /HEAD HR HR HTML HTML /HTML
I I /I IFRAME /IFRAME ILAYER /ILAYER IMG INPUT INPUT INS
INS /INS ISINDEX ISINDEX
KBD KBD /KBD
LABEL LABEL /LABEL LAYER LAYER /LAYER LEGEND LEGEND /LEGEND
LI LI /LI LINK LISTING /LISTING
MAP /MAP MARQUEE /MARQUEE MENU MENU /MENU META MULTICOL
/MULTICOL
NEXTID NOBR /NOBR NOFRAMES /NOFRAMES NOLAYER /NOLAYER NOTE
/NOTE NOSCRIPT /NOSCRIPT
OBJECT OBJECT OL OL /OL OPTION OPTION /OPTION OPTGROUP
OPTGROUP /OPTGROUP
P P /P PARAM PRE PRE /PRE
Q Q /Q QUOTE
RANGE ROOT
S S /S SAMP SAMP /SAMP SCRIPT SCRIPT /SCRIPT SELECT SELECT
/SELECT SMALL SMALL /SMALL SOUND SPACER SPAN SPAN /SPAN
SQRT STRIKE STRIKE /STRIKE STRONG STRONG /STRONG STYLE STYLE
/STYLE SUB SUB /SUB SUP SUP /SUP
TABLE TABLE /TABLE TBODY TBODY /TBODY TD TD /TD TEXT
TEXTAREA TEXTAREA /TEXTAREA TFOOT TFOOT /TFOOT TH TH /TH
THEAD THEAD /THEAD TITLE /TITLE TR TR /TR TT /TT TT
U U /U UL UL /UL
VAR /VAR VAR
WBR
XMP /XMP
/C2"Attributes"
ABBR= ACCEPT-CHARSET= ACCEPT= ACCESSKEY= ACTION= ALIGN= ALINK= ALT= ARCHIVE=
AXIS=
BACKGROUND= BEHAVIOR BELOW BGCOLOR= BORDER=
CELLPADDING= CELLSPACING= CHAR= CHAROFF= CHARSET= CHECKED CITE= CLASS=
CLASSID= CLEAR= CODE= CODEBASE= CODETYPE= COLOR= COLS= COLSPAN= COMPACT
CONTENT= COORDS=
DATA= DATETIME= DECLARE DEFER DIR= DISABLED
ENCTYPE= EXPRESSION=
FACE= FOR= FRAME= FRAMEBORDER= FRAMESPACING=
HEADERS= HEIGHT= HIDDEN= HREF= HREFLANG= HSPACE= HTTP-EQUIV=
ID= ISMAP=
LABEL= LANG= LANGUAGE= LINK= LOOP= LONGDESC=
MAILTO= MARGINHEIGHT= MARGINWIDTH= MAXLENGTH= MEDIA= METHOD= MULTIPLE
MESSAGE=
NAME= NOHREF NORESIZE NOSHADE
OBJECT= ONBLUR= ONCHANGE= ONFOCUS= ONKEYDOWN= ONKEYPRESS= ONKEYUP= ONLOAD=
ONRESET= ONSELECT= ONSUBMIT= ONUNLOAD= ONCLICK= ONDBLCLICK= ONMOUSEDOWN=
ONMOUSEMOVE= ONMOUSEOUT= ONMOUSEOVER= ONMOUSEUP=
PROFILE= PROMPT=
READONLY REL= REV= ROWS= ROWSPAN= RULES=
SCHEME= SCOPE= SCROLLING= SELECTED SHAPE= SIZE= SPAN= SRC= STANDBY= START=
STYLE= SUMMARY=
TABINDEX= TARGET= TEXT= TITLE= TOPMARGIN= TYPE=
URL= USEMAP=
VALIGN= VALUE= VALUETYPE= VERSION= VLINK= VSPACE=
WIDTH=
=
/C3"COLDFUSIONTAGS"
CFABORT
CFCASE /CFCASE CFCATCH CFCATCH /CFCATCH CFCOOKIE
CFDEFAULTCASE /CFDEFAULTCASE
CFWDDX
CFELSE CFELSEIF
CFFORM /CFFORM
CFIF /CFIF CFINCLUDE CFINSERT
CFLOCATION CFLOOP /CFLOOP CFLOCK /CFLOCK
CFMAIL /CFMAIL CFMAILPARAM
CFOBJECT CFOUTPUT CFOUTPUT /CFOUTPUT
CFPARAM
CFQUERY /CFQUERY
CFSCRIPT /CFSCRIPT CFSET CFSQL CFSWITCH /CFSWITCH
CFTRANSACTION /CFTRANSACTION CFTRY /CFTRY CFTHROW
CFUPDATE
/C4"OPERATORS"
IS AND OR NOT GTE GT LTE LT is and or not gte gt lte lt
~~
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: Can CF work with a FileMakerPro database?
If you decide to take the project and the database is going to be access by the Internet public, make sure its the FM Pro 5 Unlimited version. The standard FM Pro 5 has a '10 IPs per 12 hour' limit. Surely if it was being accessed through CF it would only be via one IP - The IP of the CF-Server machine... ~~ 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 Studio 4.5.2 Memory Leak?
CFSTUIDO 4.5.2 is not the most stable app in the world, and is very easy to crash (try closing a window with JS in the internal browser - and watch those error messages!!!) but as far as memory holes go, its not nearly as bad as previous versions (I've been working with it for 2 days and I'm only upto 25Mb VM usage) I think if anything though, overall stability is no better, if not worse - but I'm not sure if this is studio, or MMC for ent manger running on NT - together they require me to reboot every couple of days.. Also - since upgrading to IE 5.5, memory usage seems to have gone through the roof... oten using over 50MB within a few hours of booting... -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 16:54 To: CF-Talk Subject: Re: CF Studio 4.5.2 Memory Leak? Nathan, When I have Studio and Server running all day I also have my system lock up. This has become quite annoying especially at the end of a long day. - Original Message - From: "Nathan Stanford" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 9:49 AM Subject: CF Studio 4.5.2 Memory Leak? CF Studio 4.5.2 Memory Leak? My question is my fellow employees and I seem to be having lots of problems with memory when we have CF Studio 4.5.2 open. Even if we boot up a machine and don't do anything more then open CF Studio 4.5.2 and leave the machine open all day it will lock up before the day is out. Has anyone else had this problem? Is Allaire addressing this problem? Is the a fix for this problem? Nathan ~~ 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: parsing form submission into an html file?
I have in the past used CFFILE to generate .htm files - what exactly are you wanting to do??? -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 01:48 To: CF-Talk Subject: parsing form submission into an html file? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 does anyone know of a way to create an html file from a form submission, or to insert the form fields into a template and save the result as an html file? I can't find anything on the net, and cffile seems to not be what I need. - -- Jon Tillman http://www.eruditum.org finger [EMAIL PROTECTED] to annoy the MPAA To be yourself, in a world that tries, night and day, to make you just like everybody else - is to fight the greatest battle there ever is to fight, and never stop fighting. --e.e. cummings -BEGIN PGP SIGNATURE- Version: PGP 6.5.1i iQA/AwUBOqg2Vtga7tZtnIOtEQJKDACgq6xlHux9uAaJd8mXljcgylUGMcAAn0xj K/bfzq+xEIRNVqU+6203y4Xs =RuM9 -END PGP SIGNATURE- ~~ 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 Studio 4.5.2 Memory Leak?
-Original Message- CFSTUIDO 4.5.2 is not the most stable app in the world, and is very easy to crash (try closing a window with JS in the internal browser - and watch those error messages!!!) I'm sorry, but "Well DUH!" - how are you meant to close a window that's built in to the system? Of course I'd not expect it to work - but I would expect it to gracefully inform you, instead of crashing quite so dramatically - I laughed reading the error messages you get... I'd expect it to popup something like "You really are a thick T*** - do you really expect to be able to do that within studio" Just a little bit more basic exception handling would be nice.. Also - since upgrading to IE 5.5, memory usage seems to have gone through the roof... oten using over 50MB within a few hours of booting... We've had to dump IE5.5 from most of our machines as it's so hungry - combine that with WindowsMe and you've got a REAL winner... Arggg... I'm on NT4 with 128mb at work - and generally it takes about 1.5 days between reboots... I'm on 2000 at home with IE5 and 384Mb, and generally the only time I need to reboot is when I install / uninstall some old S/W - my system is often up for weeks at a time... I was going to upgrade to IE5.5 at home - but I think I might give it a miss now... I really dont like win9x (ME inc) at all... Had to install single user CF Server and PWS on a 98 laptop for a client yesterday - should have taken max 1/2 hour - but due to win98 crashing at 99.9% of the way through installing CF, in total I installed it 4 times (and removed it 3 times). Add to that, as soon as the machine tried to restart, it fatally locked up - and no task manager to kill the problem tasks - had to powerdown and restart (scandisk found an error on the disk at least once on reboot...) If I had my own way - all the machines would have 2k on them... although I might have a job on my laptop (cyrix 586 120 with 16Mb ram and a 750Mb HD!) *** Standard Joke time *** The only way you could call Studio 4.5.2 stable is if you put a horse in it! Not bad :) ~~ 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: (Review) Conditional loops
What do make of this then??? CFLOOP is (fairly substantially) quicker when you have 1,000,000 repetitions... 1,000,000 repetitions: CF-34781 While - 50079 do-50391 100,000 repetitions: === CF-3360 While - 1859 do-1813 10,000 repetitions: == CF-343 While - 172 do-188 1,000 repetitions: CF-46 While - 16 do-16 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:26 To: CF-Talk Subject: (Review) Conditional loops I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. CFSET loopcount=0 CFSET start=GetTickCount() CFLOOP condition="loopcount LTE 1000" CFSET loopcount=loopcount+1 /CFLOOP CFSET cf=gettickcount()-start BR CFSET loopcount=0 CFSET start=GetTickCount() CFSCRIPT while (loopcount LTE 1000) loopcount=loopcount+1; /CFSCRIPT CFSET wh=gettickcount()-start BR CFSET loopcount=0 CFSET start=GetTickCount() CFSCRIPT do loopcount=loopcount+1; while (loopcount LTE 1000); /CFSCRIPT CFSET do=gettickcount()-start HR CFOUTPUT CF-#cf#BR While - #wh#BR do-#do# /CFOUTPUT ~~ 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: (Review) Conditional loops
Yeah - I checked that... ran it again: CF-33671 While - 27625 do-18782 must have been some other factor... -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:49 To: CF-Talk Subject: RE: (Review) Conditional loops Me thinks you are wrong... Did you remember to change the loop count in the CFLOOP to 1,000,000 as well? Your results are awfully close to those of the 100,000 group. 1,000,000 on my machine... PIII 600MHz 782MB RAM *** CF-44063 While - 28562 do-25297 These results are inline with all the others. Twice as fast in CFSCRIPT. *** Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:37 AM To: CF-Talk Subject: RE: (Review) Conditional loops What do make of this then??? CFLOOP is (fairly substantially) quicker when you have 1,000,000 repetitions... 1,000,000 repetitions: CF-34781 While - 50079 do-50391 100,000 repetitions: === CF-3360 While - 1859 do-1813 10,000 repetitions: == CF-343 While - 172 do-188 1,000 repetitions: CF-46 While - 16 do-16 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:26 To: CF-Talk Subject: (Review) Conditional loops I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. CFSET loopcount=0 CFSET start=GetTickCount() CFLOOP condition="loopcount LTE 1000" CFSET loopcount=loopcount+1 /CFLOOP CFSET cf=gettickcount()-start BR CFSET loopcount=0 CFSET start=GetTickCount() CFSCRIPT while (loopcount LTE 1000) loopcount=loopcount+1; /CFSCRIPT CFSET wh=gettickcount()-start BR CFSET loopcount=0 CFSET start=GetTickCount() CFSCRIPT do loopcount=loopcount+1; while (loopcount LTE 1000); /CFSCRIPT CFSET do=gettickcount()-start HR CFOUTPUT CF-#cf#BR While - #wh#BR do-#do# /CFOUTPUT ~~ 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: Broken Images / Testing for file existence
use the FileExists() function in CF -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 08:06 To: CF-Talk Subject: Broken Images / Testing for file existence I have an application where I list several items on a page and display an image for that item based on a reference number (ie, productnum+.jpg). The database table does not tell me whether there is an image for that item and there are many that do have one. I'd like to display an alternate image (or nothing at all) when there is no image present, but I can't see using an CFIF FileExists for every item for 50 or so on a page. Plus, I can't even do that because I'm grabbing the images from a different server via http only (IMG SRC="http://otherserver/path/number.jpg)... How can I avoid displaying broken images? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion ~~ 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: Broken Images / Testing for file existence
OOPS Sorry I really should read the message before replying :( It might be possible to use cfhttp to check for the existence of the file - maybe update the db with the info as David suggested... cheers Dan -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 08:27 To: CF-Talk Subject: RE: Broken Images / Testing for file existence Doesn't help, since I said: "I can't see using an CFIF FileExists for every item for 50 or so on a page. Plus, I can't even do that because I'm grabbing the images from a different server via http only" But thanks... use the FileExists() function in CF -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 08:06 To: CF-Talk Subject: Broken Images / Testing for file existence I have an application where I list several items on a page and display an image for that item based on a reference number (ie, productnum+.jpg). The database table does not tell me whether there is an image for that item and there are many that do have one. I'd like to display an alternate image (or nothing at all) when there is no image present, but I can't see using an CFIF FileExists for every item for 50 or so on a page. Plus, I can't even do that because I'm grabbing the images from a different server via http only (IMG SRC="http://otherserver/path/number.jpg)... How can I avoid displaying broken images? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion ~~ 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: Dates in OLEDB
Could somone summarise / point me to a location listing the advantages / disadvantages of OLE vs ODBC for connecting within CF...? -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] Sent: 12 March 2001 10:20 To: CF-Talk Subject: RE: Dates in OLEDB .agreed, but they could start with some common ones The problem with that is that the list of database engines is huge, and if they decide to "enhance" the system it makes a mockery of this idea I think the main way of dealing with this is that you should use # for Access and ' for SQL Server and (I think) Oracle... no idea about mySQL... and format the date in a non-ambiguous format (d mmm or mmm d works wonders for this) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Date: Sun, 11 Mar 2001 22:48:41 - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Dates in OLEDB Message-ID: [EMAIL PROTECTED] This works. Thanks, what a pain! This immediately makes a migration to OLEDB a waste of time. (Might look at it for future apps) It also makes me think there should be a set of new functions in CF: createDBdate(mydate,"theDB") createDBdatetime(mydatetime,"theDB") Where theDB could be "Access", "SQLServer","ODBC"(!) etc. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~~ 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: Dates in OLEDB
Is it true that if you have an ole access ds setup, you can connect to any mdb file on the system? Also, is it possible to do things such as setup default field values etc which arent possible through JET on odbc through OLE??? cheers -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 12 March 2001 11:01 To: CF-Talk Subject: RE: Dates in OLEDB Could somone summarise / point me to a location listing the advantages / disadvantages of OLE vs ODBC for connecting within CF...? OLEDB is (theoretically) faster as it's using the database's "native" language - this isn't always faster though - some aspects will be faster, some slower ODBC has memory leaks on some drivers (Access specifically) ODBC dates don't work in OLEDB - you have to specify the dates in the format the database expects - with ODBC, CreateODBCdate works no matter which server as the ODBC driver converts it for you ODBC and OLEDB have a natural limit of 64KB on field transfers - CF4.5 has the ability to extend this, but at a speed degridation on all queries to that DSN OLEDB can be a bitch to setup, but once it's working you can just let it get on with it Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: drop down form
Do be careful using forms, DHTML and Nutscrape 4.x (particularly 4.0x) -
I've had a lot of problems mixing forms and DHTML in NS.
Also, if you want it to work in NS6 - accessing the DOM is different...
Cheers
Dan
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2001 02:45
To: CF-Talk
Subject: RE: drop down form
i have a form on a page. i want to be able to have like a "minimize"
"maximize" button on the form.
Put this in your head:
script language='JavaScript'
function toggle(theid) {
( document.all(theid).style.display == '' ) ?
document.all(theid).style.display = 'none' :
document.all(theid).style.display = '';
return false
}
/script
Use something like this as your button:
A onclick="toggle('myID'); return false;" href="#"Toggle Visibility/A
Give whatever you want to show/hide the id 'myID' or whatever -- you can
have multiple per page. Also specify its default style="display : none" or
whatever. Incidentally, it's a really good way of dealing with long,
unwieldy forms.
Regards,
Matthew Walker
!---
E l e c t r i c S h e e p W e b
Innovative Web Applications
Tel: +64-3-374 2137
Mobile.: +64-25-605 5747
Fax: +64-3-377 7930
Web: http://www.electricsheep.co.nz/
Post...: P O Box 13-907, Armagh
Christchurch, New Zealand
Street.: 71 Durham Street
Christchurch, New Zealand
---
~~
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: Warning: Page has Expired... How do I get around that??
Has anyone investigated use of CSS to make things "non printable" or "print only"? -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 10 March 2001 12:15 To: CF-Talk Subject: RE: Warning: Page has Expired... How do I get around that?? Something you might think about is putting the variables passed into hidden form fields and put a "Back" button on the page itself instead of having your user/visitor use the browser's buttons. This would work as long as they didn't mind printing the "Back" button I know I just mentioned this as a solution to another problem, but I think it applies here; How about putting the Back button in a Frame at the top of the browser and have the bottom Frame as the printable results - you could also put a Print button in the top frame and use JS to do the printing Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cffile and mapped or UNC drives
CF needs to be logged in under an account that has rights to access the network (ie not system account - which is default.. -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: 12 March 2001 17:45 To: CF-Talk Subject: OT: cffile and mapped or UNC drives ok, i am having a monday! i am trying to use cffile to write a file to a mapped drive, i have even tried it using the unc path and have hit the wall...is this a limitation of cffile or am i missing something? -code - mapped drive-- cffile action="WRITE" file="f:\temp\myfile.txt" output="myfilestuff" addnewline="Yes" -code - unc path-- cffile action="WRITE" file="\\myserver\d:\temp\myfile.txt" output="myfilestuff" addnewline="Yes" tia -- Stephenie Hamilton -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com Winner of the 2000 ColdFusion Developer's Journal Best ColdFusion Web Host!! ~~ 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:connecting to remote SQL server via TCP-IP
Hi Can anyone give me any guidelines on how to setup a SQL server to allow remote access through enterprise manager? I try connecting to the IP address of the machine, but I get the error : Client unable to establish connection|ConnectionOpen (CreateFile() in SQL server registration. Thanks Daniel Lancelot Web Developer Netstep Corporate Communications Tel +44 (0) 1422 200308 Fax +44 (0) 1422 200306 e-mail: [EMAIL PROTECTED] www: http://www.netstep.co.uk NOTE: The information contained in this e-mail is intended for the named recipient(s) only. It may also be privileged and confidential. If you are not an intended recipient, you must not copy, distribute or take any action in reliance upon it. No warranties or assurances are made in relation to the safety and content of this e-mail and any attachments. No liability is accepted for any consequences arising from it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: find and replace
Check where the data goes in... cHANCES ARE ITS NOT BEING STORED IN THE DB PROPERLY... -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:10 To: CF-Talk Subject: find and replace Hi! I'm wondering if there is anyone who can help here. For some strange reason our live server is outputting a dateformat of #dateformat(dt, 'dd/mm/yy')# as 03/09/01 it should be 09/03/01. Our development server on the other hand is outputting correctly 09/03/01. I,ve checked the settings on both servers and I cannot figure out the problem. If anyone has an idea that would be great. Or else is there a way in CF to break it apart after it has been converted to a string, cfset dtAsString = ToString(qry_checkSamplerStatus.dt) and output the individualy. Thanx in advance... ~~ 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
