Clustercats Vs Win2k Advanced Server
Currently we have 3 production web servers all running CF5 (CFMX upgrade is not an option for us), different sites on each m/c. Each box services betwen 5 and 8 web sites. We don't run our own dns.What we would like to do is have all the m/c's look the same,and use either clustercats or win2k advanced server cluster services to be the front end. Any recommendations ? btw, I have no idea what I'm doing at the moment, just poking around in the dark! I will be given two m/c's to test on Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Freetext
can 'contains'be used to span multiple fts catalogs and return rows and ranks ? - Original Message - From: Philip Arnold To: CF-Talk Sent: Sunday, February 15, 2004 8:08 PM Subject: RE: SQL Freetext I'm presuming you're using SQL Server Why aren't you using CONTAINS()? It's a lot easier to read than using the FREETEXTTABLE() function IMO -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: 15 February 2004 19:22 To: CF-Talk Subject: sot: SQL Freetext Just wondering if any one has some examples of how I can do the following. I need to do a freetext search on two tables and return the selections by rank - this is what I came up with but of course gets a syntax error (no sql manual around today !) - any suggestions would be much appreciated. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER JOIN freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY], INNER JOIN freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
sot: SQL Freetext
Just wondering if any one has some examples of how I can do the following. I need to do a freetext search on two tables and return the selections by rank - this is what I came up with but of course gets a syntax error (no sql manual around today !) - any suggestions would be much appreciated. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER JOIN freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY], INNER JOIN freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Freetext
yep catalogs are created and I can do a freetext search on just one :- SELECT rank,id,name,instructions FROM recipes as ft_tbl INNER JOIN freetextTABLE (recipes,*,'#class#',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY] ORDER BY KEY_TBL.RANK desc and it works great but with the code I wrote for two I get the standard syntax error [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INNER'. - Original Message - From: Taco Fleur To: CF-Talk Sent: Sunday, February 15, 2004 4:26 PM Subject: RE: SQL Freetext What's the error you are getting? Did you actually create the full-text catalog on the columns? Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Monday, 16 February 2004 10:22 AM To: CF-Talk Subject: sot: SQL Freetext Just wondering if any one has some examples of how I can do the following. I need to do a freetext search on two tables and return the selections by rank - this is what I came up with but of course gets a syntax error (no sql manual around today !) - any suggestions would be much appreciated. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER JOIN freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY], INNER JOIN freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc Cheers Richard _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Freetext
Way to go kevin ! I didn't see that now at least I get a decent error message - of course I'm now even more confused ! [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'ft_tbl' does not match with a table name or alias name used in the query. SQL = SELECT name,description,rank,sku,price,IMAGEURL FROM cjprod as ft_tbl,peepers as ft_tbl2 INNER JOIN freetextTABLE (cjprod,*,'pasta',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY] INNER JOIN freetextTABLE (peepers,*,'pasta',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK DESC, price asc - Original Message - From: Kevin Webb To: CF-Talk Sent: Sunday, February 15, 2004 6:11 PM Subject: RE: SQL Freetext I have not done any full text search like you have, but I did notice that there is a comma after the first INNER JOIN.I have written many queries with joins and have not used a comma after an inner join.that is probably your issue. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER JOIN freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY],-- -- DELETE COMMA THAT IS HERE!!! INNER JOIN freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc Kevin -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Sunday, February 15, 2004 7:07 PM To: CF-Talk Subject: Re: SQL Freetext yep catalogs are created and I can do a freetext search on just one :- SELECT rank,id,name,instructions FROM recipes as ft_tbl INNER JOIN freetextTABLE (recipes,*,'#class#',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY] ORDER BY KEY_TBL.RANK desc and it works great but with the code I wrote for two I get the standard syntax error [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INNER'. - Original Message - From: Taco Fleur To: CF-Talk Sent: Sunday, February 15, 2004 4:26 PM Subject: RE: SQL Freetext What's the error you are getting? Did you actually create the full-text catalog on the columns? Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Monday, 16 February 2004 10:22 AM To: CF-Talk Subject: sot: SQL Freetext Just wondering if any one has some examples of how I can do the following. I need to do a freetext search on two tables and return the selections by rank - this is what I came up with but of course gets a syntax error (no sql manual around today !) - any suggestions would be much appreciated. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER JOIN freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY], INNER JOIN freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc Cheers Richard _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Freetext
Thanks Marlon, but that still gives me the same error :- [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'ft_tbl' does not match with a table name or alias name used in the query. SQL = SELECT name,description,rank,sku,price,IMAGEURL FROM cjprod ft_tbl, peepers ft_tbl2 INNER JOIN freetextTABLE (cjprod,*,'pasta',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY] INNER JOIN freetextTABLE (peepers,*,'pasta',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK DESC, price asc - Original Message - From: Marlon Moyer To: CF-Talk Sent: Sunday, February 15, 2004 7:20 PM Subject: RE: SQL Freetext Remove the as from cjprod as ft_tbl and peepers as ft_tbl2 -- marlon And Bobby you are right, I am being selfish, but the last time I checked, we don't have a whole lot of songs that feature the cowbell! -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Sunday, February 15, 2004 8:55 PM To: CF-Talk Subject: Re: SQL Freetext Way to go kevin ! I didn't see that now at least I get a decent error message - of course I'm now even more confused ! [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'ft_tbl' does not match with a table name or alias name used in the query. SQL = SELECT name,description,rank,sku,price,IMAGEURL FROM cjprod as ft_tbl,peepers as ft_tbl2 INNER JOIN freetextTABLE (cjprod,*,'pasta',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY] INNER JOIN freetextTABLE (peepers,*,'pasta',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK DESC, price asc - Original Message - From: Kevin Webb To: CF-Talk Sent: Sunday, February 15, 2004 6:11 PM Subject: RE: SQL Freetext I have not done any full text search like you have, but I did notice that there is a comma after the first INNER JOIN.I have written many queries with joins and have not used a comma after an inner join.that is probably your issue. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER JOIN freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY],-- -- DELETE COMMA THAT IS HERE!!! INNER JOIN freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc Kevin -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Sunday, February 15, 2004 7:07 PM To: CF-Talk Subject: Re: SQL Freetext yep catalogs are created and I can do a freetext search on just one :- SELECT rank,id,name,instructions FROM recipes as ft_tbl INNER JOIN freetextTABLE (recipes,*,'#class#',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY] ORDER BY KEY_TBL.RANK desc and it works great but with the code I wrote for two I get the standard syntax error [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INNER'. - Original Message - From: Taco Fleur To: CF-Talk Sent: Sunday, February 15, 2004 4:26 PM Subject: RE: SQL Freetext What's the error you are getting? Did you actually create the full-text catalog on the columns? Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Monday, 16 February 2004 10:22 AM To: CF-Talk Subject: sot: SQL Freetext Just wondering if any one has some examples of how I can do the following. I need to do a freetext search on two tables and return the selections by rank - this is what I came up with but of course gets a syntax error (no sql manual around today !) - any suggestions would be much appreciated. SELECT name, FROM table1 as ft_tbl, table2 as ft_tbl2 INNER JOIN freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY], INNER JOIN freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc Cheers Richard _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: html to image
Cheers Peter - that did the trick - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Monday, January 19, 2004 12:26 AM Subject: RE: html to image Perhaps http://www.pixel-technology.com/freeware/url2bmp/ Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 My wife says I never listen to her... At least I think that's what she said! \¯\/¯/ |¯|)¯) /¯/\¯\ \¯\/¯/ /_/\_\ |_|)_) \_\/_/ /_/\_\ RULES -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Monday, 19 January 2004 5:14 PM To: CF-Talk Subject: Re: html to image doesn't really do it I'm afraid - Original Message - From: brobborb To: CF-Talk Sent: Sunday, January 18, 2004 3:33 PM Subject: Re: html to image http://freedownloadswindows.com/windows/Capture/655846/CAP.html This is screen capture command line utility.awesome eh? :-DIt'll save your pictures somewhere as JPGs or GIFs or whatever,.Figure u can use CFEXECUTE with it - Original Message - From: admin To: CF-Talk Sent: Saturday, January 17, 2004 4:04 PM Subject: html to image Apologies if this has been covered before, but I couldn't find anything in the archives. My problem is that I need to convert a webpage, it's a coldfusion generated stats page on a server, into an image (jpg, gif etc). This is so that I can view the server status from my TV via tivo. I've managed to do something crude using the cfx image tag but if I could capture the whole page and convert the html to an image I would be really happy. Any thoughts ? Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: html to image
doesn't really do it I'm afraid - Original Message - From: brobborb To: CF-Talk Sent: Sunday, January 18, 2004 3:33 PM Subject: Re: html to image http://freedownloadswindows.com/windows/Capture/655846/CAP.html This is screen capture command line utility.awesome eh? :-DIt'll save your pictures somewhere as JPGs or GIFs or whatever,.Figure u can use CFEXECUTE with it - Original Message - From: admin To: CF-Talk Sent: Saturday, January 17, 2004 4:04 PM Subject: html to image Apologies if this has been covered before, but I couldn't find anything in the archives. My problem is that I need to convert a webpage, it's a coldfusion generated stats page on a server, into an image (jpg, gif etc). This is so that I can view the server status from my TV via tivo. I've managed to do something crude using the cfx image tag but if I could capture the whole page and convert the html to an image I would be really happy. Any thoughts ? Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
html to image
Apologies if this has been covered before, but I couldn't find anything in the archives. My problem is that I need to convert a webpage, it's a coldfusion generated stats page on a server, into an image (jpg, gif etc). This is so that I can view the server status from my TV via tivo. I've managed to do something crude using the cfx image tag but if I could capture the whole page and convert the html to an image I would be really happy. Any thoughts ? Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Logs
I was just wondering what the members of the group did to keep their log files under control, size, monitering, backing up etc. Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Remotely cycling CF server
if you have two, or more, servers just have them look at each other (cfhttp ?) and if detect a down condition do a cfexecute with psexec to restart the service - Original Message - From: Nick de Voil To: CF-Talk Sent: Thursday, November 20, 2003 1:43 PM Subject: Re: Remotely cycling CF server Tom Check out servers alive at http://www.woodstone.nu/salive/ Thanks Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Peer Review - Load Balancing
I slapped together some code to provide a very simple load balance system for coldfusion servers that are using sql on other boxes. I would appreciate if the experts on this list could have a look at the code (it can be found at http://www.y2kinternet.com/timetest/timetest.zip) and make any suggestions, positive and negative about the code and the concept. Cheers Richard p.s. I'm a lousy sql and coldfusion programmer ! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Peer Review - Load Balancing
Hi Tony. Good point, we run about 500-1500 per sec, but we are also very cheap so a hardware solution is out. The overhead of a trivial transaction should be minimal, and I though this code might do an automatic failover. Cheers Richard - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:02 PM Subject: RE: Peer Review - Load Balancing im not sure i understand the point. you, seem to creating more overhead in the process. how many transactions do you predict will be hitting the sql servers?what size are the machines, cpu/ram? just wondering. i work in an environment that gets hit with transactional processing at a rate of about 25-40 records per second being processed. ONE MACHINE :)now, if you are expecting more than this, well, i cant speak about it. but on the same note, wouldnt some sort of hardware load balancing or a sql server cluster make more sense? tony -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 10:53 PM To: CF-Talk Subject: Peer Review - Load Balancing I slapped together some code to provide a very simple load balance system for coldfusion servers that are using sql on other boxes. I would appreciate if the experts on this list could have a look at the code (it can be found at http://www.y2kinternet.com/timetest/timetest.zip) and make any suggestions, positive and negative about the code and the concept. Cheers Richard p.s. I'm a lousy sql and coldfusion programmer ! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Peer Review - Load Balancing
just normal traffic from the web servers - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:16 PM Subject: RE: Peer Review - Load Balancing well, blow me down, damn, what kinda app runs that many sql transactions? im sure there are many, but i wonder what kinda app runs that? tony -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:13 PM To: CF-Talk Subject: Re: Peer Review - Load Balancing Hi Tony. Good point, we run about 500-1500 per sec, but we are also very cheap so a hardware solution is out. The overhead of a trivial transaction should be minimal, and I though this code might do an automatic failover. Cheers Richard - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:02 PM Subject: RE: Peer Review - Load Balancing im not sure i understand the point. you, seem to creating more overhead in the process. how many transactions do you predict will be hitting the sql servers?what size are the machines, cpu/ram? just wondering. i work in an environment that gets hit with transactional processing at a rate of about 25-40 records per second being processed. ONE MACHINE :)now, if you are expecting more than this, well, i cant speak about it. but on the same note, wouldnt some sort of hardware load balancing or a sql server cluster make more sense? tony -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 10:53 PM To: CF-Talk Subject: Peer Review - Load Balancing I slapped together some code to provide a very simple load balance system for coldfusion servers that are using sql on other boxes. I would appreciate if the experts on this list could have a look at the code (it can be found at http://www.y2kinternet.com/timetest/timetest.zip) and make any suggestions, positive and negative about the code and the concept. Cheers Richard p.s. I'm a lousy sql and coldfusion programmer ! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Peer Review - Load Balancing
oops that should be per min not sec ! - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:16 PM Subject: RE: Peer Review - Load Balancing well, blow me down, damn, what kinda app runs that many sql transactions? im sure there are many, but i wonder what kinda app runs that? tony -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:13 PM To: CF-Talk Subject: Re: Peer Review - Load Balancing Hi Tony. Good point, we run about 500-1500 per sec, but we are also very cheap so a hardware solution is out. The overhead of a trivial transaction should be minimal, and I though this code might do an automatic failover. Cheers Richard - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:02 PM Subject: RE: Peer Review - Load Balancing im not sure i understand the point. you, seem to creating more overhead in the process. how many transactions do you predict will be hitting the sql servers?what size are the machines, cpu/ram? just wondering. i work in an environment that gets hit with transactional processing at a rate of about 25-40 records per second being processed. ONE MACHINE :)now, if you are expecting more than this, well, i cant speak about it. but on the same note, wouldnt some sort of hardware load balancing or a sql server cluster make more sense? tony -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 10:53 PM To: CF-Talk Subject: Peer Review - Load Balancing I slapped together some code to provide a very simple load balance system for coldfusion servers that are using sql on other boxes. I would appreciate if the experts on this list could have a look at the code (it can be found at http://www.y2kinternet.com/timetest/timetest.zip) and make any suggestions, positive and negative about the code and the concept. Cheers Richard p.s. I'm a lousy sql and coldfusion programmer ! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Peer Review - Load Balancing
two web servers, both dual 2.4 4 gb, going into two sql servers 1st is dual 1.8 4 gb three raid 1 (os, data, freetext catalogs) 2nd sql box (still being built) dual 1gig piii 2 gb ram some raid The database in question is about 5 gb in size, and we have some shitty tables (can't redesign) and some poor queries (probably can't re-do in the near future) The idea for this bit of code was to shove load on to the other box when things got too slow, or it went tits up - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:31 PM Subject: RE: Peer Review - Load Balancing ok, that makes sense... your first answer i would imagine, would be on the scale of hotmail or something like that. okay, that makes more sensethats 1.67 to 2.5 - per sec, ok, thats really not much load...that i would begin to think about scaling, what kinda machine is this on? speed/ram? tw -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:26 PM To: CF-Talk Subject: Re: Peer Review - Load Balancing oops that should be per min not sec ! - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:16 PM Subject: RE: Peer Review - Load Balancing well, blow me down, damn, what kinda app runs that many sql transactions? im sure there are many, but i wonder what kinda app runs that? tony -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:13 PM To: CF-Talk Subject: Re: Peer Review - Load Balancing Hi Tony. Good point, we run about 500-1500 per sec, but we are also very cheap so a hardware solution is out. The overhead of a trivial transaction should be minimal, and I though this code might do an automatic failover. Cheers Richard - Original Message - From: Tony Weeg To: CF-Talk Sent: Thursday, October 30, 2003 8:02 PM Subject: RE: Peer Review - Load Balancing im not sure i understand the point. you, seem to creating more overhead in the process. how many transactions do you predict will be hitting the sql servers?what size are the machines, cpu/ram? just wondering. i work in an environment that gets hit with transactional processing at a rate of about 25-40 records per second being processed. ONE MACHINE :)now, if you are expecting more than this, well, i cant speak about it. but on the same note, wouldnt some sort of hardware load balancing or a sql server cluster make more sense? tony -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 10:53 PM To: CF-Talk Subject: Peer Review - Load Balancing I slapped together some code to provide a very simple load balance system for coldfusion servers that are using sql on other boxes. I would appreciate if the experts on this list could have a look at the code (it can be found at http://www.y2kinternet.com/timetest/timetest.zip) and make any suggestions, positive and negative about the code and the concept. Cheers Richard p.s. I'm a lousy sql and coldfusion programmer ! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfquery performance suggestions
I'm using the following query to find all the catagories in a table that start with a certain letter :- SELECT distinct CATEGORY FROM dbo.mainfile where CATEGORY like 'P%' order by CATEGORY ASC I have an index based on Category but it runs slow (it's a v. large table - and it't can't be redesigned). Any suggestions for a better query to get the results ? - btw I'm very much a SQL novice Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Re:cfquery performance suggestions
thanks for all the great info guys. The table only gets rebuilt once a week (I think) and is running of sql 2000. The table contains about 2.5 mil rows - Original Message - From: alexander sicular To: CF-Talk Sent: Sunday, October 26, 2003 3:10 PM Subject: Re:cfquery performance suggestions maybe you could use category=left(category, 'p', 1) instead of like. depending on your database syntax may vary. i find that like is the slowest operation you can do. gl, alex I'm using the following query to find all the catagories in a table that start with a certain letter :- SELECT distinct CATEGORY FROM dbo.mainfile where CATEGORY like 'P%' order by CATEGORY ASC I have an index based on Category but it runs slow (it's a v. large table - and it't can't be redesigned). Any suggestions for a better query to get the results ? - btw I'm very much a SQL novice Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfquery vs sql view
I was wondering if anyone knew which was more efficient (ie faster) doing the select logic like :- where catagory='catagory name' in a cfquery or doing it in a sql 2000 database view ? Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PayPal integration
agreed the talk back from IPN can do just about everything a regular CC system can do - I'll see if I can find the link too - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:15 PM Subject: RE: PayPal integration Look into paypal IPN. It still isn't perfect, but its more integrated than the options you describe. Gads... Where was that Paypal/CF IPN tutorial again? Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 8:43 PM To: CF-Talk Subject: PayPal integration Slightly off topic: I am looking at adding PayPal as a payment option to a ColdFusion shopping cart we wrote. As far as I can tell, you can't integrate it very tightly. I see two ways: 1) Buy Now Button Method: allows a user to jump from a product detail page to the PayPal checkout form. Only allows one item to be purchased at a time. Bypasses all our checkout pages including shipping and tax calculation. 2) Shopping Cart Method: offers Add To Cart buttons on each product page. Clicking this button opens a new window with a PayPal shopping cart in it. Allows more than one item to be purchased at a time. Bypasses all our checkout pages including shipping and tax calculation. Am I understanding this right? Is there any other way to do it? If we add this feature as an option, when orders are placed using PayPal they wouldn't be in our system because we have no way of knowing if the order went through, or if the user changed quantities, etc. Thanks for any input. -Ryan ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
ot - random sql select
is there an easy way to select say 10 records at random from an sql table ? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: ot - random sql select
Thanks mike I'll give that a try - but out of interest what does that code really mean ? - ok - so I'm an idiot in sql ! Cheers Richard - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:28 AM Subject: RE: ot - random sql select If you are using SQLServer 2K (not sure if it works in 7) you could use SELECT TOP 10 * FROM Foo ORDER BY NewID() HTH -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 07:11 To: CF-Talk Subject: ot - random sql select is there an easy way to select say 10 records at random from an sql table ? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
local/ftp sync
I need to keep a local directory in sync with a directory on an ftp server. As the files are rather large I don't want to download the whole thing every night, just the new ones, and delete old files on the local directory that are not on the ftp. Just wondering if anyone has written anything similar Cheers Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HTTPS
that's probably a question to ask your webmaster or whomever runs your webserver - it depends on the software that you are running - Original Message - From: Jonathan Oblea [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 6:24 PM Subject: HTTPS Hi All, How can I setup my website to make it HTTPS (SSL)? Thank you in advance, Jonathan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Detecting Parasiteware
Does anyone know if there is a way to detect if a visitors macjine is infected with parasite ware (like whenu) from CF ? Cheers Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFM Shopping Cart System
I would be interested is seing it too. - Original Message - From: Manesh Manickam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:35 AM Subject: RE: CFM Shopping Cart System Nice site, do you think I could get the source and try to see if I could get it to work on a computer site? thanks -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:57 AM To: CF-Talk Just the checkout feature. I have shipping features built in but its commented out because they wanted paypal to do shipping as well. -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:58 AM To: CF-Talk Subject: Re: CFM Shopping Cart System Out of curiousity - how much is integrated with paypal? Just checkout? Actual product catalog? Curious to see if it could handle one of my client needs. Thanks, Jason Matt Blatchley ~ Bridgeleaf Studios wrote: Dave, Clean site, I like it. You should make it so the user can add the product to the cart as soon as they see it, not just on the detail page. How many clicks does it take to get them to add it to the cart. If the user has to go to the detail page then it's too many. Other than that, it'd very nice and clean. Clean design and well formatted. Matt -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 7:04 AM To: CF-Talk Subject: RE: CFM Shopping Cart System I just completed a site that uses a shopping cart system with paypal. http://www.savvy-selections.com/catalog.cfm -Original Message- From: Manesh Manickam [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 11:02 PM To: CF-Talk Subject: CFM Shopping Cart System I was wondering if there are any free shopping cart systems for cfm, that are actually good! As in inventory, paypal authoring. Thanks for you help guys and girls! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Calendar App
Count me in too please - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:26 AM Subject: Re: Calendar App At 01:22 PM 6/26/03 -0400, Jason Miller wrote: Definately interested.. I jsut started researching one! I wouldn't mind getting a copy either. T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Database Availability
I hope that this isn't a stipid question but I'm sure it must have been asked before. I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm cfif primary_available cfset use_database=primary cfelseif Secondary_available cfset use_database=secondary cfelse no database available /cfif Any thought on how I can easily check to see which box is available. Cheers Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
the dbs's in quesion are read only and are automatically sync'd - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 12:41 PM Subject: Re: Database Availability I think the bigger issue would be how to keep them synched up if you switch between them :-) - Original Message - From: admin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 3:33 PM Subject: Database Availability I hope that this isn't a stipid question but I'm sure it must have been asked before. I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm cfif primary_available cfset use_database=primary cfelseif Secondary_available cfset use_database=secondary cfelse no database available /cfif Any thought on how I can easily check to see which box is available. Cheers Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
wow - thank you all so much for the useful info. I do like the idea of the external app. I wonder if an app like that could be used for load balancing - but of course my VB and C++ skills suck. Cheers Richard - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 1:13 PM Subject: Re: Database Availability Assuming you're using an ODBC datasource... How about an external application this is constantly checking the availability of the databases in question, and modifies the ODBC DSN to point at a working one? - Original Message - From: admin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 1:33 PM Subject: Database Availability I hope that this isn't a stipid question but I'm sure it must have been asked before. I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm cfif primary_available cfset use_database=primary cfelseif Secondary_available cfset use_database=secondary cfelse no database available /cfif Any thought on how I can easily check to see which box is available. Cheers ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mechanisms for stopping a running script
how would one do that if it was a long running query ? - I've got the same problem but I think it's sql that's causing the problem. Cheers Richard - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:20 PM Subject: Re: Mechanisms for stopping a running script I've been thinking about some ideas on how to stop running scripts, like an ABORT button. This is the first thought I came up with. Any other ideas? This comes up for me because I have several LONG running scripts that occassionally, I might want to stop w/o having to bounce the cf server to do so... ... hrm... I would probably use some sort of progress meter on the long-running page you might want to halt -- which will slow it down some overall also, although probably not a noticeable amount in most cases... What you really need is a way to interract with the running page from the client side -- which means, another page load, which is fine, it's just a matter of figuring out how that is accomplished... The fileexists() isn't a bad idea -- you could for instance have a stop button that produces a popup window that says stopping the process, please wait, which then creates the halt flag on the server. Use cfflush after the button is displayed and before the long running process begins, so that the button is visible and then display the progress below the button. When the long running process sees the flag file it deletes it, aborts the process, closes the popup window and displays a message indicating that the process has been cancelled. I wouldn't worry terribly much about the time it takes to perform the fileexists() function -- it should be unnoticeable. If you'd like an easy to implement progress indicator, there's one in the Tapestry API in my sig file. hth s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Recipes and MealMaster
I was just wondering if anyone has written a parse routine for mealmaster or mastercook formatted recipes ? Cheers Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help SQL Sever CFSTOREDPROC Issue.
try running the cf service logged in as an admin account rather than local system account - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 9:53 AM Subject: Help SQL Sever CFSTOREDPROC Issue. Hello All: I need some help please! Im using a couple of neat stored procedures to call a DTS package and write the output to a UNC path. My issue is that it only works when I output to my local SQL server hard drive or output to the UNC path by executing the DTS package from my SQL server Enterprise Manager. If I try to execute the CFSTOREDPROC from my CF server that goes to the UNC path a get an error from the SQL server. All permissions have been set to gives the 3 machines rights for read and write access. Any Ideas? Regards, James Blaha These are the stored procs. http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS CFSTOREDPROC PROCEDURE=spExecuteDTS DATASOURCE=xx debug=YES returnCode = Yes cfprocresult name=importData cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname= @Server value= mySqlServer null=no cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname= @PkgName value= DTS_HR null=NO cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@ServerPWD value=xx null=NO !--- Note: If you ran this with a local SA account you will need the line below. --- cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@IntSecurity value=1 null=NO /CFSTOREDPROC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
cookies and base64
I need to read a cookie that is written by a php application and encoded base64 - any suggestions ? TIA Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cookies and base64
great ! thanks Ben - Original Message - From: Ben Doom [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 20, 2003 11:53 AM Subject: RE: cookies and base64 tostring() -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: admin [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 20, 2003 2:46 PM : To: CF-Talk : Subject: cookies and base64 : : : I need to read a cookie that is written by a php application and : encoded base64 - any suggestions ? : : TIA : : Richard : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Large Recordset Display Problem
I have a query that returns the results of a search. Potentially this could be a few hundred records. What I want to be able to do is execute the query once (as it's a slow query) but then only display a limited number of records per page (25 or so) and have some navigation to move thru the results, but with out re-doing the search. Any thoughts ? TIA Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large Recordset Display Problem
Thanks all of you for the great info - now the for the stupid question ! do I use cachedwithin to get the data stored as a session variable ? I guess the question really is how do I stick a query in to session vars tia Richard - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 11:11 AM Subject: RE: Large Recordset Display Problem Richard: There are two steps involved in doing this, data retrieval and data display. On the retrieval side, as others have mentioned, you'd be well served caching the results of the query. If the query is user-specific, cache it in SESSION. If the query is not user-specific, you might try adding it to ColdFusion's query cache. If the query is not user-centric and will not change over time, cache it in APPLICATION. On the display side, regardless of how it's cached, you can use the STARTROW and MAXROWS attributes of the CFOUTPUT tag to make a prev/next n style display. Your code would look something like: !--- Init MAXROWS and STARTROW --- CFPARAM NAME=URL.StartRow DEFAULT=1 CFPARAM NAME=URL.MaxRows DEFAULT=10 !--- Output up to MaxRows results starting from StartRow --- CFOUTPUT QUERY=myQuery MAXROWS=#URL.MaxRows# STARTROW=#URL.StartRow# #myQuery.Col1# - #myQuery.Col2#BR /CFOUTPUT !--- Display prev/next MaxRows links --- CFIF myQuery.RecordCount NEQ 0 CFIF URL.StartRow GT URL.MaxRows CFSET tmpStartRow = URL.StartRow - URL.MaxRows A HREF=results.cfm?MaxRows=#URL.MaxRows#StartRow=#tmpStartRow###60; Previous #URL.MaxRows# Results/A | /CFIF CFSET EndRow = URL.StartRow + URL.MaxRows - 1 Results #URL.StartRow# - CFIF EndRow LT myQuery.RecordCount #EndRow# CFELSE #myQuery.RecordCount# /CFIF CFIF EndRow LT myQuery.RecordCount CFSET tmpStartRow = URL.StartRow + URL.MaxRows CFIF EndRow + URL.MaxRows LTE myQuery.RecordCount CFSET nextNum = URL.MaxRows CFELSE CFSET nextNum = myQuery.RecordCount - EndRow /CFIF | A HREF=results.cfm?MaxRows=#URL.MaxRows#StartRow=#tmpStartRow#Next #nextNum# Results ##62;/A /CFIF /CFIF HTH -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 1:36 PM To: CF-Talk Subject: Large Recordset Display Problem I have a query that returns the results of a search. Potentially this could be a few hundred records. What I want to be able to do is execute the query once (as it's a slow query) but then only display a limited number of records per page (25 or so) and have some navigation to move thru the results, but with out re-doing the search. Any thoughts ? TIA Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large Recordset Display Problem
Thank you all very much for this great info. Now maybe I can get on with thos project and stop worrying about th eproblems in the world. - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 11:54 AM Subject: RE: Large Recordset Display Problem My apologies... for locking reason's Barney's method is better: cfquery ... name=searchresult ... /cfquery cfset session.searchresult = searchresult / Make sure, if you're not using CFMX, that the CFSET statement is locked using CFLOCK. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 2:48 PM To: CF-Talk Subject: RE: Large Recordset Display Problem Couldn't be simpler... CFQUERY NAME=SESSION.myQuery -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 2:40 PM To: CF-Talk Subject: Re: Large Recordset Display Problem Thanks all of you for the great info - now the for the stupid question ! do I use cachedwithin to get the data stored as a session variable ? I guess the question really is how do I stick a query in to session vars tia Richard - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 11:11 AM Subject: RE: Large Recordset Display Problem Richard: There are two steps involved in doing this, data retrieval and data display. On the retrieval side, as others have mentioned, you'd be well served caching the results of the query. If the query is user-specific, cache it in SESSION. If the query is not user-specific, you might try adding it to ColdFusion's query cache. If the query is not user-centric and will not change over time, cache it in APPLICATION. On the display side, regardless of how it's cached, you can use the STARTROW and MAXROWS attributes of the CFOUTPUT tag to make a prev/next n style display. Your code would look something like: !--- Init MAXROWS and STARTROW --- CFPARAM NAME=URL.StartRow DEFAULT=1 CFPARAM NAME=URL.MaxRows DEFAULT=10 !--- Output up to MaxRows results starting from StartRow --- CFOUTPUT QUERY=myQuery MAXROWS=#URL.MaxRows# STARTROW=#URL.StartRow# #myQuery.Col1# - #myQuery.Col2#BR /CFOUTPUT !--- Display prev/next MaxRows links --- CFIF myQuery.RecordCount NEQ 0 CFIF URL.StartRow GT URL.MaxRows CFSET tmpStartRow = URL.StartRow - URL.MaxRows A HREF=results.cfm?MaxRows=#URL.MaxRows#StartRow=#tmpStartRow###60; Previous #URL.MaxRows# Results/A | /CFIF CFSET EndRow = URL.StartRow + URL.MaxRows - 1 Results #URL.StartRow# - CFIF EndRow LT myQuery.RecordCount #EndRow# CFELSE #myQuery.RecordCount# /CFIF CFIF EndRow LT myQuery.RecordCount CFSET tmpStartRow = URL.StartRow + URL.MaxRows CFIF EndRow + URL.MaxRows LTE myQuery.RecordCount CFSET nextNum = URL.MaxRows CFELSE CFSET nextNum = myQuery.RecordCount - EndRow /CFIF | A HREF=results.cfm?MaxRows=#URL.MaxRows#StartRow=#tmpStartRow#Next #nextNum# Results ##62;/A /CFIF /CFIF HTH -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 1:36 PM To: CF-Talk Subject: Large Recordset Display Problem I have a query that returns the results of a search. Potentially this could be a few hundred records. What I want to be able to do is execute the query once (as it's a slow query) but then only display a limited number of records per page (25 or so) and have some navigation to move thru the results, but with out re-doing the search. Any thoughts ? TIA Richard ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT Domain registration
I've been using www.24x7dns.com $12 a year and they take paypal includes dns and mail forwarding. I've been very happy with them. - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 9:51 AM Subject: RE: OT Domain registration I've used GoDaddy.com, but through their reseller program at WildWestDomains.com. I've got maybe 200 registered there now, and have been with them for just over a year. As a reseller I am the registrar in the whois records. Since I set my own prices I can set ones that beat register.com and make me a tidy sum in the process. A revenue stream I no longer ignore My domain spam has been reduced to almost nothing. You can pay extra to have a domain proxy thing as has been mentioned already, but they just don't give out whois info period. http://netsol.com/cgi-bin/whois/whois?STRING=mysecretbase.comSearchType =do Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: samcfug [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 8:59 AM To: CF-Talk Subject: Re: OT Domain registration The problem with GoDaddy is that they charge $20. per year extra to use their name servers. I do not need domain names masked. I have several clients with Registerfly, and the problem with them is that every 90 days or so, their DNS servers get corrupted (maybe from Phreakers) and mission critical sites are typically offline and without mail until They can get them fixed up and propagated again. They are the ones asking me to search out a more reliable registrar. Network Solutions are in themselves spammers, and also sell their address lists to other spammers. I use Register.com myself for my own domains, but these clients do not wish to pay their prices although I consider them as the easiest to use and most reliable of all. I do not want to run my own name servers, because they are all on the same network, and DNS is much more reliable with dispersed name servers. I do use DNS caching, however, As for filling in fake information for the WHOIS, There are rules currently in effect that if you cannot be reliably contacted through WHOIS, then upon complaint, your registration can be revoked. There is a rising groundswell of anti-spammer activists that are searching out and filing complaints with ICANN. More info can be found at http://www.dshield.org. As for spam harvested from WHOIS databases, I use a filtering server running Postfix on Linux that effectively blocks all that spam. Anyone with a domain name can subscribe to this filtering server which then sends your email on to you after filtering for open proxy, open relay, spamcop.bl, and virus scanning. It even blocks the Nigerian scam mail. This way you are assured of getting clean email to your server, and there is no delay in delivery. File attachments that are not virus infected are permitted. = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 9:09 AM Subject: Re: OT Domain registration | thats a great reason TO use them i hate putting real info into a domain to | be harvested or given out its nobodies business anyway :). | | But i still like registerfly.com better | | - Original Message - | From: Hugo Ahlenius [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Thursday, March 06, 2003 9:57 AM | Subject: RE: OT Domain registration | | | With GoDaddy -- a reason not to use them: | | They offer a service with the domain registration where the owner is not | presented in any whois, which are being used by shady domains. | | | | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
javascript variables
I've got a need to read a javascript file on another site that contains just variable definitions i.e. numbers.js contains :- /* employee numbers */ var fred_bolggs='12345' var dave_smith='6789' ... etc I can read the file thru cfhttp with out a problem, but I was just wondering if someone know of a quick and dirty way where I could read the file and dump it into a database. I'm afraid I know nothing about javascript. TIA Richard __ 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: Odd OLEDB Error
I never got that working using oledb. I think you will have to stick with odbc for CVS. It seems to be a Cold Fusion 'feature' and has been like that since Cf 4.0 - Original Message - From: Jeff Beer [EMAIL PROTECTED] Hrmm.. I found the problem. It wasn't that query - it was CF trying to use an OLEDB datasource for Client variable storage. I temporarily switched it to the system registry (ack!) and the problem went away. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
query of a query
I'm trying to retrieve a subset from a query cached in memory. I'm using this query: cfquery name=SpotsQuery dbtype=query SELECT BESTNUMBER, SPOTSTART FROM application.allquery WHERE ((SPOTSTART = '01-01-2002' But I receive the error Error: is not a valid date I already tried a few different formats including createodbcdate etc but no luck so far. Anyone here knows what does work, and maybe some extra tips for working with this feature? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
cfgraph and urls
When using cfgraph with the urlcolumn feature, the flash movie creates links like traflog%2Ecfm%3Fip%3D192%2E0%2E76%2E250%20%20%20 instead of traflog.cfm?ip=192.0.76.40 and my server tells me he can't find the page. Any way around that? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: CFDirectory and Network
Jeff, Thanks a million - that did the trick ! Richard - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 7:23 AM Subject: RE: CFDirectory and Network Make sure the account that CF is running under (system by default) has network rights. Typically, the system account on a webserver doesn't have network privs. Change the account that CF runs as using the services control panel to an account that has network rights. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 8:05 AM To: CF-Talk Subject: CFDirectory and Network I'm trying to do a cfdirectory across our network from the server to a mapped drive (i.e. the H:\ drive) Everthing works fine on the locals but I get nothing back on the mapped drive. Am I missing something in the doc about not being able to do this ? TIA Richard ~~ 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 Webstore
great software and easy to modify - we've made major changes with no prblems at all - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 10:41 AM Subject: Re: CF Webstore A good piece of software would not rely on cftransaction at all It's a handy shortcut that's all. jon - Original Message - From: C Runyan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 12:49 PM Subject: CF Webstore Thanks to all for the comments about AbleCommerce. Based on what we're hearing and looking at the CFDJ readers survey CF Webstore looks like a reasonable alternative. If anyone has used CF Webstore and modified the code let me know what you think. Another consideration is whether it can handle a large amount of traffic. Hopefully a good package would use CFTRANSACTION processing for reliability. Chris ~~ 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: signing mail with certificate
Is there any way of 'signing' an e-mail sent from cold fusion (or an other scripting language or by calling an exe) by adding an e-mail certificate like you can get from verisign or thawte ? - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: inFusion Support List [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 8:28 PM Subject: [iMS] iMS POST Server 2.1.5 is now available ~~ 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: Raduis Authentication
Last year I set up a system using the vopcom radius client, this is a com object that you can call from cold fusion: http://www.vircom.com/solutions/vopcom/index.htm - Original Message - From: [EMAIL PROTECTED] I am trying to use CF to authenticate users with their Username and password from the radius server on the Unix side of the network on an ~~ 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: Reservation system suggestions
Thanks Alex I've ben looking around - the problem i've got is how to do the logic for multiple room/room types against dates and customers. - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 5:03 PM Subject: Re: Reservation system suggestions You could search the web. Read some books on system design. Or outsource the project. Anyway, narrow down your question. On Tue, 13 Nov 2001, webmaster wrote: I've got a possible project coming up that would be a web based reservation system for a small hotel. I'm banging my head against a brick wall and have no idea where to start with this - has any one got any suggestions or maybe sample code that I could look at ? TIA ~~ 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: Reservation system suggestions
It is - shame this is one of those xero budget projects - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 3:36 PM Subject: RE: Reservation system suggestions that is a nice looking application... wow -p -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 18:44 To: CF-Talk Subject: Re: Reservation system suggestions Go here: http://www.broadmoor.com then click make a room reservation Play around with the Flash/CF app Then contact Jim Whitney here: [EMAIL PROTECTED] He sells the app for a fee + percentage of the room fees. Might be worth checking out depending on your budget. will (not employed by, nor affiliated with webvertising, not even a client, saw the app demo at DevCon2001, was impressed so I thought I'd throw it in the ring) William H. Bowen Webmaster ALSTOM's Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX Master ColdFusion 4.5 - Brainbench 10/02/2001 http://www.brainbench.com/transcript.jsp?pid=1577915 CONFIDENTIALITY: This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. - Original Message - From: webmaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 3:24 PM Subject: Reservation system suggestions I've got a possible project coming up that would be a web based reservation system for a small hotel. I'm banging my head against a brick wall and have no idea where to start with this - has any one got any suggestions or maybe sample code that I could look at ? TIA ~~ 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: Reservation system suggestions
Lovely system - i'd love to write something just like it - Original Message - From: John Dowdell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 4:27 PM Subject: Re: Reservation system suggestions At 3:24 PM 11/13/1, webmaster wrote: I've got a possible project coming up that would be a web based reservation system for a small hotel. I'm banging my head against a brick wall and have no idea where to start with this - has any one got any suggestions or maybe sample code that I could look at ? I don't know if you need to do this from scratch, or wouldn't mind just having a solution instead... there's been a lot of talk lately about the ColdFusion/Flash based iHotelier system: http://www.ihotelier.com/ I don't know their licensing or customization options, and so don't know how well it fits your situation, sorry. I just know it has received a lot of positive word, that's all. jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ ~~ 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: (OT) Human Click: CF Version?
I would love to check it out as well tx Richard - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 9:58 AM Subject: Re: (OT) Human Click: CF Version? contact me... would love to see it :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Tracy Bost [EMAIL PROTECTED] Date: Tue, 2 Oct 2001 11:44:23 -0500 Subject: Re: (OT) Human Click: CF Version? It was for an extranet. If you really need to see it, i could make arrangements. Just contact me off list. - Original Message - From: Cary Gordon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 11:08 AM Subject: Re: (OT) Human Click: CF Version? Can we see it? At 10:46 AM 10/2/2001 -0500, you wrote: I did a human click in a coldfusion application once using the jabber server and the java applet client ~~ 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: CFMAIL
John, Thank you ever so much !! Richard - Original Message - From: John Lucas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 10:55 AM Subject: Re: CFMAIL cfmail to= from= subject= cfmailparam name=X-Priority value=1 cfmailparam name=X-MSMAIL-Priority value=High John - Original Message - From: webmaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 12:40 PM Subject: CFMAIL Does anyone know how I can send nail with cfmail and flag the message as urgent or hi-priority ? tia Richard ~~ 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: MSN
Thnks Billy, I'l have a look at that. The customer wants to be able to do something like livehelper.com, but in house, and without paying anything for it - usual story ! - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 8:50 AM Subject: RE: MSN If AIM is installed, doesn't it provide support for a proprietary protocol (aim://) in the browser? Also, I know that some software (like Jabber) can talk to a number of these services at a pretty low level. Some of it is even open source - perhaps you could pull some code off of SourceForge and write your own back-end --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:09 AM To: CF-Talk Subject: RE: MSN how can you send it to AIM? -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 11:05 AM To: CF-Talk Subject: RE: MSN From what I have found, MSN is not too friendly when it comes to sending messages unless you use their client software. I know Yahoo, AIM, and ICQ all have a way that you can use HTML to send a message to users. Thank you, Dan Phillips Lead Support Technician/ColdFusion Administrator Express Technologies, Inc. dba CFXhosting.com -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:52 AM To: CF-Talk Subject: Re: MSN AFAIK, they have no API for that. If you find it, please let me know. I've been wanting to add the functionality myself. Rey... - Original Message - From: webmaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 10:49 AM Subject: MSN Does anyone know how to send a MSN message from a CF app ? TIA Richard ~~ 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: Terrorism
Amen - Original Message - From: Scott Van Vliet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 9:41 AM Subject: RE: Terrorism God rest their souls. - SVV -Original Message- From: Matt Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 8:48 AM To: CF-Talk Subject: Terrorism Our thoughts and our prayers are with the victims and the rescue workers in this tragedy. Also for our armed forces who will certainly become involved. Macromedia and I sincerely hope that everyone in our community and their loved ones are safe. I have checked on the Macromedia people that I know are nearby and they seem to be OK and for that at least I am thankful. Today might be a good time to spend with your families and loved ones. ~~ 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: Excel as a datasource .... ?
I've had good luck using an access database with tables linked to the excel sheets. This way you can use all the features of access like views etc and you can swap out the excel file without having to worry about the file being locked by the cf server. - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 11:23 AM Subject: Excel as a datasource ? I have a client who's complaining that the time spent generating a small app using SQL is costing too much and wants to use excel spreadsheets instead. What's your experience using excel as a datasource? Just to clarify what the projects do, they don't write to the datasource, just look up and filter the data customising tables for the user's needs. The volumes aren't great - between a few hundred page views a month to 5000 or so. IS there likely to be implications for the usage of RAM and resources on the server? The System Admin is already complaining that he has to restart the server too often and when the processor usage gets to 100% he panics and complains. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~ 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
Help with cfpop
Can anyone suggest where I could start with debugging this error :- Error,TID=630,08/31/01,07:41:14,Unexpected exception while processing a tag with a general identifier of (CFPOP), occupying document position (21:1) to (21:171), while executing template file Thanks In Advance Richard ~~ 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: Total Fix For Code Red
I tried a few address using net send and they all failed. With a net send you only need the ip address and it will pop-up an alert box on the infected machine, no reverse dns, no guessing admin emails. The only thing is that someone has to look at the screen to see the message. This assumes a couple of things. First, that the target machine is accessible via Windows Networking (NetBIOS over TCP/IP) and second, that the Messenger service is running on the target machine, and finally, that you have rights to connect via Windows Networking and send the message. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT (maybe) : Code Red
Good Point. I've been sending out e-mails when blackice gave me a good name resolution, and have had some replies back - mostly apologetic, although one person informed me that I was crazy, that he had norton and therefore no way could he have a virues and suggested that I do something anotomically impossible to myself.. Ho Hum. I just wonder how much bandwidth/resource loss we all suffer from this damned worm. - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 4:39 AM Subject: RE: OT (maybe) : Code Red Any suggestions ? snort, perl, /bin/mail :-) But seriosuly - you think if their *still* not patched they'll care about you sending them an email ? ~~ 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: Anybody else getting Zachary slammed?
same here - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 1:59 PM Subject: Anybody else getting Zachary slammed? Anybody else getting bombared with duplicate messages from Zachary on leasing SQL? At last count I had received 20 copies. Don ~~ 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: Shopping Cart Software?
Yep CFWebstore is the best. I run it for www.ontvstore.com and managed to covert from a perl based app to cfwebstore in less that a week. easy to customize. Robust and well written. Richard Y2K Internet Technologies - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 8:54 AM Subject: Re: Shopping Cart Software? Have a look at www.cfwebstore.com. Very good product and support. Comes with source (unlike others which charge you additional for source). HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 11:42 AM Subject: Shopping Cart Software? Looking for a robust, full featured Shopping Cart system to integrate into ColdFusion. I've heard a little about AbleCommerce, is this the best option? It's a little on the pricey side at $3000 and $495 per additional store. Anyone know of a good CF Cart application that won't bust the wallet? Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [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: SirCam virus???
it's a nasty little bugger - try and get the folks sending u the emails to apply the fix that is available from SARC - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 10:12 AM Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ 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
Thumbnails
Can anyone recommend the most efficient way to create thumbnail images from a directory dynamically. ~~ 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: Thumbnails
Thanks Mark, and others !
What I wanted to do was genererate the thumbnails at view time. That is loop
through a list of images (bloody large ones!) and produce a thumbnail
gallery on the fly for the visitor. The directory content changes every few
hours so I wanted to it at page view time rather than pre-gen a set of
pages.
- Original Message -
From: Mark Warrick [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 10:27 AM
Subject: RE: Thumbnails
Adobe Photoshop 5.0 and newer versions as well as various other
batch-processing programs can create all the thumbnails for you.
Once you've got the images processed, you can use code such as the
templates below to display the images. For a working example of this code,
take a look at my personal site - photo section, high-bandwidth area.
!-- begin display_photo_list.cfm --
cfinclude template=header.cfm
!--- script language=JavaScript1.1
!-- Begin
function right(e){
if (navigator.appName=='Netscape'
(e.which==3||e.which == 2))
return false;
else if(navigator.appName=='Microsoft Internet Explorer'
(event.button==2||event.button==3)){
alert(Please don't steal my images. Thanks.);
return false;
}
return true;
}
document.onmousedown=right;
if(document.layers)window.captureEvents(Event.MOUSEDOWN);
window.onmousedown=right;
//End--
/script ---
cfset center_color = F4B642
cfset center_align = center
cfset center_valign = middle
center
table width=100% cellpadding=5 cellspacing=0 border=0
CFDIRECTORY
DIRECTORY=#GetDirectoryFromPath(GetTemplatePath())#/photography/small
NAME=myDirectory
cfoutput query=myDirectory
cfif (size neq 0) and (name does not contain .cfm) and (name does not
contain .txt)
cfset enlarged_file_name = #ReplaceNoCase(#name#,_sm,, ALL)#
cfset caption_file_name =
#ReplaceNoCase(#enlarged_file_name#,.jpg,.txt,ALL)#
tr
td valign=middlefont face=#fontface# size=#fontsize#a
href=display_photo.cfm?photo=#enlarged_file_name# target=_windowimg
src=photography/small/#name#/a/font/td
td valign=middlefont face=#fontface# size=#fontsize#
!--- TEST
#session.rootpath#/photography/captions/#caption_file_name# ---
!--- note: comment this out and uncomment the text file initialization
code below to create files automatically for all the thumbnails ---
cfinclude template=photography/captions/#caption_file_name#
/font/td
/tr
!---initialize text files---
!--- cffile action=WRITE
file=#GetDirectoryFromPath(GetTemplatePath())#/photography/captions/#captio
n_file_name# output=#caption_file_name# text addnewline=Yes ---
/cfif
/cfoutput
/table
/center
cfinclude template=footer.cfm
!-- end display_photo_list.cfm --
cfinclude template=header.cfm
script language=JavaScript1.1
!-- Begin
function right(e){
if (navigator.appName=='Netscape'
(e.which==3||e.which == 2))
return false;
else if(navigator.appName=='Microsoft Internet Explorer'
(event.button==2||event.button==3)){
alert(Please don't steal my images. Thanks.);
return false;
}
return true;
}
document.onmousedown=right;
if(document.layers)window.captureEvents(Event.MOUSEDOWN);
window.onmousedown=right;
//End--
/script
form action= method=post onSubmit=self.close()
input type=submit value=Close
/form
CFIF FileExists(#template_path_enlarged_photos_directory#/#photo#)
cfoutput
img src=#web_path_enlarged_photos_directory#/#photo#
/cfoutput
CFELSE
Sorry! An error occured. This file does not exist.
/cfif
form action= method=post onSubmit=self.close()
input type=submit value=Close
/form
cfinclude template=header.cfm
---mark
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 9:39 AM
To: CF-Talk
Subject: Thumbnails
Can anyone recommend the most efficient way to create thumbnail images
from a directory dynamically.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: http server for windoz ME?
sambar is well worth looking at - runs on ME. I think there is a free trial for version 4.4 - Original Message - From: John Allred [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 4:02 AM Subject: Re: OT: http server for windoz ME? I'd be interested to know if another server could be installed, but I know it's not possible to install PWS on ME. If you do decide to get another OS, note that there are certain MS OSes that you can't upgrade to from ME. Check the documentation. If you opt for Win2000 (which includes IIS and PWS), you'll need the full package, not an upgrade. Jeffry Houser wrote: Apache. Or isn't there a version of PWS on ME? At 05:06 PM 07/21/2001 -0700, you wrote: My new notebook came with m$ ME. I was trying to install IBM's http server, but it didn't install (said I needed NT4). Is there any free http server to help develop CF while on the run with a ME notebook? TIA, laszlo If it's too OT, please reply to: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS and the Code Red Worm
at least blackics is seeing it and hopefully stopping it Richard - Original Message - From: Daryl Fullerton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 12:27 PM Subject: IIS and the Code Red Worm Hi guys thought you all should be made aware of this .most of you probably do know. But just in case you are encountering server trouble on IIS 4 The code red worm is causing havok with IIS and stoping IIIS 4 see below Cheers D Thanks -- that's what I was afraid of. We have 3 servers it is happening on right now, and We had the patch installed, but are manually removing the ida and idq entries. Thanks! Tim P. - Original Message - From: Leon Oosterwijk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 1:45 PM Subject: RE: IIS 4 Stopping Unexpectedly Tim, I could not on my first round of investigations find anything unusual. The inbound/outbound traffic on the machine did not jump significantly. the Processor did not see any big jumps of activity, memory levels, all normal. There was a large amount of TCP/IP sockets open, but that seemed normal due to the volume of websites hosted. In other words, No. :( Leon -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 12:38 PM To: [EMAIL PROTECTED] Subject: Re: IIS 4 Stopping Unexpectedly Leon, We are running into something like this right now. Is there any way to tell if in fact that is what is happening on the machine? Tim P. - Original Message - From: Leon Oosterwijk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 1:29 PM Subject: RE: IIS 4 Stopping Unexpectedly I've noticed this on our IIS4 machine. I installed the latest microsoft patch: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/secur ity/ bulletin/MS01-033.asp This seems to have fixed it. (After repeated reboots) You might want to download and install the similar patch for your IIS System. This patch seems to prevent the Code Red worm or other exploits from harming your system. The behavious that I experienced in not consistent with the Code Red worm, but it is possible that there are other worms out there making use of the same security hole. I realize that this message might be off-post, but any feedback people have on this would be welcome on: [EMAIL PROTECTED] Regards, Leon Oosterwijk ISDN-NET Inc. www.isdn.net -Original Message- From: Troy Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 12:11 PM To: [EMAIL PROTECTED] Subject: IIS 4 Stopping Unexpectedly I have IIS 4 running on NT 4 SP 6a. It is a dual Pentium III 800 MHz server with a Gig of RAM. I have installed all of the latest IIS patches. Starting yesterday, the IIS stopped running all on its own. When there is ANY kind of unexpected service stoppage (Dr Watson, etc.) on this server, I get an email from the Compaq Insight Monitors. But that is not happening. It is as if someone is actually stopping the inetinfo process in the Services control panel. I am watching the server when it happens, and no one is logging into the server when it happens. The stoppage frequency has steadily increased from hours apart to mere seconds. Anyone seen this before? I have searched all over the net, including BugTraq, MS, Allaire, and all the major search engines to no avail. I am running a complete Virus scan, but it has not found anything. Any ideas would be greatly appreciated. Troy -- What Boots Up, Must Come Down. Troy L. Allen, Sr. Chief Technology Officer The MAXXIS Group, Inc. Control your subscriptions to ACFUG lists via the ACFUG website at www.acfug.org. Control your subscriptions to ACFUG lists via the ACFUG website at www.acfug.org. Control your subscriptions to ACFUG lists via the ACFUG website at www.acfug.org. Control your subscriptions to ACFUG lists via the ACFUG website at www.acfug.org. Control your subscriptions to ACFUG lists via the ACFUG website at www.acfug.org. Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group
Re: IIS 4 Stopping Unexpectedly: I KNOW WHAT THE PROBLEM IS!!!
what is also strange is that after the initial ISAPI attack it's followed by 15 hits to UDP port 1296. Anyone konw what this port is for - or why the worm is searcing there ? Richard Y2K Internet Technologies - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 2:32 PM Subject: IIS 4 Stopping Unexpectedly: I KNOW WHAT THE PROBLEM IS!!! Ok folks I know what's goin on. It happened to me all day. I use black ice on my server. At first every time i was getting hit it was being recorded at an HTTP OVERFLOW and shutting my web service down. I updated black ice and it now records it as an ISAPI index extension overflow. My updated version of Black Ice ($39.95) now blocks it and it now longer shuts my web service down. They must have JUST updated today. I have a feeling someone found a hole today and broadcast it across the internet. It started here around noon. So if you have black ice get the update. If you don't buy black ice until microsoft comes out with an IIS fix. Here is a page explaining the attack: http://advice.networkice.com/advice/Intrusions/2002608/default.htm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 4:50 PM To: CF-Talk Subject: Re: IIS 4 Stopping Unexpectedly Add me to the list. I got a call this afternoon from an old client, complaining that the web server keeps going down and they need to reboot to get things running again. I've inspected the machine and nothing appears to wrong ... except that periodically IIS 4 service stops. My question is ... how does one check to verify the existence of this worm ... I think IIS stopping on it's own is a pretty good clue. But, if I now have the worm how do I get rid of it? Leon, you mention installing the patch and rebooting a couple of times ... but isn't the patch to keep you from getting the worm? Not to remove it once you get it? Any help in removing this thing would be greatly appreciated! Thanks, Bill In a message dated 7/19/01 4:18:55 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Hi all, Looks like we have the same problems on 4 of our win NT 4 machines Upon trying to shut down we got an error that would not allow shut down on our win nt4 machine. OLE threadworm from what i hear. We have applied the patch on the first and are rebooting at the momnent 3 more to go after that. Hopefully this will fix the problem. Any one else want to share experiences on this worm. does it affect win2k servers? Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: 19 July 2001 19:04 To: [EMAIL PROTECTED] Subject: Re: IIS 4 Stopping Unexpectedly Thanks -- that's what I was afraid of. We have 3 servers it is happening on right now, and We had the patch installed, but are manually removing the ida and idq entries. Thanks! Tim P. - Original Message - From: Leon Oosterwijk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 1:45 PM Subject: RE: IIS 4 Stopping Unexpectedly Tim, I could not on my first round of investigations find anything unusual. The inbound/outbound traffic on the machine did not jump significantly. the Processor did not see any big jumps of activity, memory levels, all normal. There was a large amount of TCP/IP sockets open, but that seemed normal due to the volume of websites hosted. In other words, No. :( Leon -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 12:38 PM To: [EMAIL PROTECTED] Subject: Re: IIS 4 Stopping Unexpectedly Leon, We are running into something like this right now. Is there any way to tell if in fact that is what is happening on the machine? Tim P. - Original Message - From: Leon Oosterwijk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 1:29 PM Subject: RE: IIS 4 Stopping Unexpectedly I've noticed this on our IIS4 machine. I installed the latest microsoft patch: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/secur ity/ bulletin/MS01-033.asp This seems to have fixed it. (After repeated reboots) You might want to download and install the similar patch for your IIS System. This patch seems to prevent the Code Red worm or other exploits from harming your system. The behavious that I experienced in not consistent with
Re: cf_addBusinessDays
try #dateformat(outdate)# - Original Message - From: Adrian Cesana [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] If so what do you use for the output variable? Looks like it would be OUTDATE, but I get a numeric result. cf_addbusinessDays indate=0628/2001 days=-5 gives me: cfoutput#outdate#/cfoutput = 37063 ~~ 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
Reservation System
I know this is a bit bold, but a customers has asked me to knock up a site for him in a hurry. What he needs is a reservation system for his four rental properties. I was just wondering if any one has done anything similar and has some code I could plagiarize. Many thanks in advance Richard Y2K Internet Technologies ~~ 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: Reservation System
Thanks Mark- Just trying to keep my job ! - Original Message - From: Mark Warrick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 6:51 PM Subject: RE: Reservation System You're right. It is rather bold to ask someone to do something for you for free that you're going to profit off of. Have you considered slave labor? I hear in some countries that's still legal. Take my message lightly. I'm playing with you. But you might want to pass along the message to your boss. ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric -Original Message- From: admin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 6:10 PM To: CF-Talk Subject: Reservation System I know this is a bit bold, but a customers has asked me to knock up a site for him in a hurry. What he needs is a reservation system for his four rental properties. I was just wondering if any one has done anything similar and has some code I could plagiarize. Many thanks in advance Richard Y2K Internet Technologies ~~ 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: handling 404 errors with CF?
when doing that, can you find out what path the user was trying to go to originally? - Original Message - From: Bill Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 11:52 PM Subject: Re: handling 404 errors with CF? Here's how to set it up in IIS: http://www.brainbox.tv/404.gif ~~ 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: Credit Card DB Encryption Methodology
Another option would be to use an asymmetric encryption method alongside the process you described before. For this you use a public key stored on the server, but to decrypt the credit card number the operator needs to type in a private key. As this key is not stored on the server there is no security risk. You would then of course have to store the numbers twice, one encrypted with the user password, and one encrypted with the public/private key pair. - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 05, 2001 2:14 AM Subject: Re: Credit Card DB Encryption Methodology Ok, I've been thinking about this. And in the case of returns or credits, I think we could this: On the website as the customer requests a return, they must enter their password. I store this encrypted with the RMA number (or some other associated id) as the key. Once the return is processed, the server uses the RMA number to decrypt the password to decrypt the CC info and process the credit... Now I've comprised the security of those users with pending returns, but that would be a small percentage of users at any given time. And if I'm going to use an easily available key to encrypt the password temporarily, it's almost not even worth the bother... Still thinking. OR, I would have to request the customer to login to the website and check if their return has been received, then enter their password when prompted in order to receive the credit. Another issue is that I'm locked to doing ONLY real-time processing. If the cc processing gateway is down, I can't take orders... So what are you doing in those cases, do you have to contact the customer? Curious... I thought the reason most people kept card numbers around was for handling credits, delayed charges, and other problems (or possibly because of record-keeping requirements of their bank), or because they're doing the credit card charges manually (or at least with some human intervention) rather than in real time. It doesn't seem like your solution would work in that situation. Correct, that wouldn't work here, because we don't have an unecrypted version of the user's password available. Keith C. Ivey [EMAIL PROTECTED] Webmaster, EEI Communications Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ 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
CFX_HTTP thread safe?
I would just like to ask if CFX_HTTP is thread safe? I will be useing it for online processing of credit cards payments so I need to make it work as faultless as possible. ~~ 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: CFERROR Question
Put a base href="/" directive at the top of your page near the body tag. That will tell the browser relative to what folder it has to look for the images. Or just define the images with absolute rather than relative paths. - Original Message - From: "Corrine Clark" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 5:39 PM Subject: CFERROR Question Good Morning, I have been trying to utilize my global error template processing, It does bring up the error page, but not the images if the error is not in the same directory as the error page. Both the application and error page are in the root of my directory. Could someone help me? Here is my code: Application.cfm: cferror template="cferror_exception.cfm" type="EXCEPTION" CFERROR TEMPLATE="cferror_request.cfm" TYPE="REQUEST" cferror_exception.cfm: html head titleFSC Intranet Exception Error Handling/title link rel="STYLESHEET" type="text/css" href="fsccss.css" /head body background="images/fscintranet.gif" table width="100%" cellspacing="2" cellpadding="2" border="0" tr tda href="Index.cfm"img src="images/FSClogohome.gif" width="84" height="63" alt="" border="0"/a/td tdh1An Error Has Occurred/h1/td /tr /table cfoutput#error.DateTime#br #error.Template#br #error.Browser#br #error.HTTPReferer#br #error.diagnostics#br /cfoutput Please contact yadayadayada /body /html Thank you Corrine Clark, FSC IT Dept. Wichita KS -- NOTICE OF CONFIDENTIALITY ~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~ ~~ 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: Mailing Shots in CF
So how should one write the query to pull 100 messages at the time and set a flag so they would not be selected the next time select top 100 id,email from sometable where flag is 0 update sometable set flag = 1 where id in () - Original Message - From: "Victor Chou" [EMAIL PROTECTED] If the emails aren't extremely time critical, a CF schedule that send them in batches of say 100 would do it just fine. ~~ 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
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you for choosing Smart Web Tech your online business provider. We have received you
Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
