Re: SES urls on CFMX 6.1
> Indeed, as long as you don't mind I'll try to get that rolled in to the > version I release under the CPL. > As I stated in the original email, the code is public domain. You can do with it as you will. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
Indeed, as long as you don't mind I'll try to get that rolled in to the version I release under the CPL. Spike Matt Liotta wrote: >>Something I have been planning to add to the Servlet is the ability to >>perform 'traditional' SES URL rewriting. My lack of time for making >>these and other changes was the main reason for deciding to release the >>code to the community. >> > > I imagine it wouldn't take that long to incorporate the code I just > shared. > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.MontaraSoftware.com > (888) 408-0900 x901 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
> I've had great success with IIS using a custom 404 page. Just create a > template to parse the url, place it in an out-of-the-way-folder, and > configure IIS to use that template to handle 404's in that folder. > Doesn't doing something like that cause the server to log successful page responses as 404s? Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
> Something I have been planning to add to the Servlet is the ability to > perform 'traditional' SES URL rewriting. My lack of time for making > these and other changes was the main reason for deciding to release the > code to the community. > I imagine it wouldn't take that long to incorporate the code I just shared. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SES urls on CFMX 6.1
I've had great success with IIS using a custom 404 page. Just create a template to parse the url, place it in an out-of-the-way-folder, and configure IIS to use that template to handle 404's in that folder. Michael Wolfe [EMAIL PROTECTED] -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 7:09 AM To: CF-Talk Subject: RE: SES urls on CFMX 6.1 Under IIS, I think you need a third party extension - I use one from Helicon, which is free for one server. For Apache, it's super simple and part of the server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
This is a good point. Something I have been planning to add to the Servlet is the ability to perform 'traditional' SES URL rewriting. My lack of time for making these and other changes was the main reason for deciding to release the code to the community. Spike Matt Liotta wrote: >>The point of the FriendlyURL Servlet is that the URL typed by the user >>does not need to have any variables encoded in it, so you can have a >>URL >>of the form: >> > > The whole concept of a search engine safe (SES) URL is the passing of > URL parameters in a way that works well with search engines. While some > people may find the URLs nicer that is simply a side effect as SES URLs > aren't concerned with users at all; otherwise they would be called user > friendly search engine safe (UFSES) or something equally stupid. Don't > get me wrong, I am not saying there one shouldn't concern themselves > with how friendly their URLs are for users, but again that isn't the > point of SES URLs. What you are describing is just URL mapping. > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.MontaraSoftware.com > (888) 408-0900 x901 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
> The point of the FriendlyURL Servlet is that the URL typed by the user > does not need to have any variables encoded in it, so you can have a > URL > of the form: > The whole concept of a search engine safe (SES) URL is the passing of URL parameters in a way that works well with search engines. While some people may find the URLs nicer that is simply a side effect as SES URLs aren't concerned with users at all; otherwise they would be called user friendly search engine safe (UFSES) or something equally stupid. Don't get me wrong, I am not saying there one shouldn't concern themselves with how friendly their URLs are for users, but again that isn't the point of SES URLs. What you are describing is just URL mapping. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Peer Review - Load Balancing
ahhh i see. well, i guess your design limitations are the problem really, not the machines they seem fine. plenty fine. but ok, you know your layout/setup better, but the machines should be able to handle WAY more than the load they are getting now... tw -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 12:35 AM To: CF-Talk Subject: 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]
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]
RE: SES urls on CFMX 6.1
Just to clarify for everyone here: The FriendlyURL servlet will be released under the CPL as soon as I get time to look back over the code and put some comments in it. I provided Daemon with a license to use the servelt in FarCry without limitation, but I have been too busy to get round to updating the CFC for the standalone version, and comment the code properly. The 'quick and dirty' code that Matt provided will give you SES URLs, but they might not be very friendly. The point of the FriendlyURL Servlet is that the URL typed by the user does not need to have any variables encoded in it, so you can have a URL of the form: http://www.spike.org.uk/go/friendly-urls Which is mapped to the real url: http://www.spike.org.uk/index.cfm?objectid=E0D92039-22AB-07A9-6076142DCF72107F With Matt's Servlet the above URL would appear as: http://www.spike.org.uk/ses/objectid/E0D92039-22AB-07A9-6076142DCF72107F This is more search engine safe, but not so friendly for users to type or remember. Which you prefer to use is up to you. Until I manage to get the source code and CFC updated and publised on spike.org.uk, anyone who wants a copy of the source code under the CPL can mail me off list. Spike Stephen Milligan http://www.spike.org.uk/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Anybody have an opinion on hostmysite.com?
8 sites. All excellent accounts. Host My Site ROCKS -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:38 PM To: CF-Talk Subject: Anybody have an opinion on hostmysite.com? Anybody have an opinion on hostmysite.com? Balance of rate/features/support/reliability seems good. Can't find any negative reviews anywhere... Researching CF MX, mySQL, SQL Server hosting solutions... -- Les Mizzell - "Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo." _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Anybody have an opinion on hostmysite.com?
HostMySite.com Rocks! We have used most of their services, starting first with some small hosting solutions, then a shared SQL Server and now we have multiple dedicated servers in their facility and are getting ready to add another very soon. We also have servers at RackShack, RackSpace and Vortech and as soon as possible will be moving them to HostMySite.com Not only are their rates very reasonable, but their support is second to none - they have some of the most knowledgeable technicians I've had the pleasure of working with. Best of all, they're honest. If there ever is an issue (rare), they do not take the low-road and blame another vendor - they admit to the snafu and follow it up with their action plan to take care of the situation. If you have the opportunity to use HostMySite.com I would strongly advise you do. And for the record, good luck finding anyone with a negative review of HostMySite.com ... we discovered that when researching their service as well. Enjoy On Thu, 2003-10-30 at 23:37, Les Mizzell wrote: > Anybody have an opinion on hostmysite.com? > > Balance of rate/features/support/reliability seems good. Can't find > any > negative reviews anywhere... > > Researching CF MX, mySQL, SQL Server hosting solutions... > > -- > Les Mizzell > - > Mihi placent, O Pincerna! > Virent ova! Viret perna! > Dapem posthac non arcebo. > Gratum tibi me praebebo. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
> Unfortunately, significant legal issues can arise when you use code
> without
> a clear license or some similar provenance, if you put that code into
> your
> client's application. These issues are unlikely to arise, but
> unpleasant
> when they do, from what I've seen and heard. On the bright side, these
> issues are resolved through civil courts rather than criminal, so you
> don't
> end up with mates named "Bubba", if you know what I mean.
>
Thanks Dave for clarifying why it is not a good idea to use unlicensed
code. For the sake of completeness though, let me provide the contents
of my last email on the subject of SES URLs, which contains source code
for an example Servlet. Again, the below code is public domain.
The best solution I have found to handling SES URLs is to use a Servlet
request dispatcher. Here is the idea...
Create a Servlet that will transform directories in a URL to query
parameters and then forward the request to a CFM for processing. You
then create a Servlet mapping that allows that servlet to respond to
all URLs that match the pattern you use for SES. For example, let's say
you want your URLs to look like the following.
http://www.domain.com/ses/foo/true/bar/1
You would then deploy your servlet with a mapping of /ses/* and the
above URL would be transformed into the following.
http://www.domain.com/ses.cfm?foo=true&bar=1
Below is the source code to a quick and dirty Servlet that handles the
above.
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class SES extends HttpServlet
{
public void doGet (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, java.io.IOException
{
String query = request.getQueryString();
StringTokenizer st = new
StringTokenizer(request.getPathInfo(), "/");
Vector tokens = new Vector();
while(st.hasMoreTokens())
tokens.add(st.nextToken());
//the first token is always "ses"
if(tokens.size() > 1)
{
for(int itr = 1; itr < tokens.size(); itr += 2)
query += "&" + tokens.get(itr) + "=" +
tokens.get(itr + 1);
}
this.getServletContext().getRequestDispatcher("/ses.cfm?" +
query).forward(request, response);
}
}
Matt Liotta
President & CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Anybody have an opinion on hostmysite.com?
Anybody have an opinion on hostmysite.com? Balance of rate/features/support/reliability seems good. Can't find any negative reviews anywhere... Researching CF MX, mySQL, SQL Server hosting solutions... -- Les Mizzell - Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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]
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: Wierd CFC Path Problem - Question on CFC types
This is basically it.
Root/caller
Root/com/depressedpress/component.cfc
I've "solved" this problem by ignoring it - I created a new directory to
hold my CFCs ("com" works fine on dedicated servers, but just doesn't
cut it for shared servers). I'd still like to figure out the original
problem. it's really driving me crazy. ;^)
Jim Davis
-Original Message-
From: Mauricio Giraldo [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 12:03 PM
To: CF-Talk
Subject: Re:Wierd CFC Path Problem - Question on CFC types
is the calling file in a folder above the CFC? i mean, which is the most
similar dir struct for your files:
1)
/root/caller.cfm
/root/cfc/component.cfc
2)
/root/html/caller.cfm
/root/cfc/component.cfc
- mga
_
[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
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
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: text files
if you are re-writing as a line by line csv file, you can write the data, into a cfsavecontent variable and then write that whole variables to a file, its basically like a loop within a cfsavecontent, write a whole lotta lines, then make one big file system dump to a file, using #asc(10)##asc(13)# for your line breaks, and commas to separate the values. make sure to use cfsetting enablecfoutputonly so that you dont get any unexpected spacing or tabs or anything like that. thats what i would do. if you are re-writing as a csv. later tony -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:09 PM To: CF-Talk Subject: text files Hey guys, i'm having coldfusion read data from a file (comma delimited csv file), and reformat the data and put that in a new file for the user to download. So far, it takes it about 50 seconds to write over 9000 rows worth of data (it's also doing some minor calculations for each row). I was wondering if having SQL Server do that would be quicker. Or if there's some other way to make it quicker. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
text files
Hey guys, i'm having coldfusion read data from a file (comma delimited csv file), and reformat the data and put that in a new file for the user to download. So far, it takes it about 50 seconds to write over 9000 rows worth of data (it's also doing some minor calculations for each row). I was wondering if having SQL Server do that would be quicker. Or if there's some other way to make it quicker. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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]
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: How to secure CF ADMIN PAGE NOT TO beat a dead horse PART 4
Hmm, thinking about this I realized the most most obvious way to restrict access to this directory is go to IIS in Admin tools and browse to the CFIDE directory, then go to Directory Security and then only allow my machine to have access as in : all computers denied access except the one you want to , duh, LOL this should work. Don't know why I didn't think of this before. L Marcus -Original Message- From: Larry [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 8:20 PM To: CF-Talk Subject: How to secure CF ADMIN PAGE Hey Folks: I got Windows (IIS) to ask for a login but if you cancel it enough times it it just goes away and you can then get to the CF admin. What do I have To do write an LDAP app in CF? This seems silly. There must be a way to secure the CF Administration page using windows. Thanks L Marcus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Project / Task Manager Collaboration
Don't recall who on the list was interested. I've got a Project / Task manager that I'm ready to make available in a collaborative open-source initiative. If you're interested let me know. We'll coordinate. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Parsing 1000 emails
If the emails are in a directory that you can access, use cfdirectory to get a listing of all those email... then If you are on MX (CF 5 has a 24KB limit or around there on what can be read in on swoop), use cffile to read the email into a variable, then search that variable for your 5 variables. Get the next file, so on.. Nice time for a CFC :-) MailParse -->readDir() -->parseCollection() -->updateRecord() Just an idea... -Original Message- From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 10:39 PM To: CF-Talk Subject: Parsing 1000 emails Got over 1000 emails that need to be parsed to grab five variables that then need to be used to update a SQL server table. Are there and Custom tags out there to do this? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Parsing 1000 emails
Got over 1000 emails that need to be parsed to grab five variables that then need to be used to update a SQL server table. Are there and Custom tags out there to do this? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to secure CF ADMIN PAGE Part 3 oh well
Actually Im using Windows 2000. I am crossing my fingers on this one. Windows is one big security flaw, LOL Thanks for your help Dave! Ive always been just a developer and never had to worry about this stuff until Now when I became a Sys admin L Marcus -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 9:11 PM To: CF-Talk Subject: RE: How to secure CF ADMIN PAGE Part 2 > > > What do I have To do write an LDAP app in CF? This seems > > > silly. There must be a way to secure the CF Administration > > > page using windows. > > > > LDAP has nothing to do with this. > > Thanks Dave, I hope this works! I apprecicate your post, but > you got one thing wrong, you can use LDAP written in Cold > fusion to secure an application. No, its not part of Windows > or IIS per se, but yes It works better than any of that Windows > junk! LDAP has nothing to do with web server authentication when using IIS. I assumed that was what you meant by "this". If you want to use LDAP to secure your application, you will have to do that through your application code, using a forms-based authentication interface. As for "better", that'll depend on your circumstances. If you want to authenticate users against an NT 4 domain, LDAP won't work nearly as well as Windows authentication through IIS. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF treatment of queries inside CFCs
I never claimed that my solution is very OO. However, I treat DB interaction CFCs as objects - the more general cfc is inherited by child CFC and all cfcs encapsulate some functionality (like variable caching). Granted that I only need a single instance of my object and not much manipulation is done to that object. I am curious as to how other people deal with database interaction issues, does anyone take similar approach to mine? TK - Original Message - From: Dave Watts To: CF-Talk Sent: Thursday, October 30, 2003 8:56 PM Subject: RE: CF treatment of queries inside CFCs Well, it sounds like you couldn't leverage OO any less, actually. As Matt said, that's not necessarily bad, but putting functions in CFCs does not make something OO. If you were using objects in the OO sense of the word, those objects would represent individual entities that your program describes. For example, if you had a program that dealt with cars, when your program talked about a new car you'd create a Car object, which you'd treat more or less like any other variable. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF treatment of queries inside CFCs
I suppose so.. I'd have to tinker with the idea a bit before deciding one way or the other obviously; but it seems that sometimes we try make CFCs for everything, while potentially ideal in an OO text-book sense, my experience has always been that there is a line you walk with reagrds to performance and level of abstraction; I was just curious if the DB CFC was nearing that line. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 8:43 PM To: CF-Talk Subject: RE: CF treatment of queries inside CFCs > I would be interested to see what the imapct on performance > is in regards to having "DB" CFCs that handle DB operations. In my (admittedly limited) experience, it hasn't made a significant difference. It's usually a pretty thin abstraction layer, actually. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to secure CF ADMIN PAGE Part 2
> > > What do I have To do write an LDAP app in CF? This seems > > > silly. There must be a way to secure the CF Administration > > > page using windows. > > > > LDAP has nothing to do with this. > > Thanks Dave, I hope this works! I apprecicate your post, but > you got one thing wrong, you can use LDAP written in Cold > fusion to secure an application. No, its not part of Windows > or IIS per se, but yes It works better than any of that Windows > junk! LDAP has nothing to do with web server authentication when using IIS. I assumed that was what you meant by "this". If you want to use LDAP to secure your application, you will have to do that through your application code, using a forms-based authentication interface. As for "better", that'll depend on your circumstances. If you want to authenticate users against an NT 4 domain, LDAP won't work nearly as well as Windows authentication through IIS. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to secure CF ADMIN PAGE Part 2
Thanks Dave, I hope this works! I apprecicate your post, but you got one thing wrong, you can use LDAP written in Cold fusion to secure an application. No, its not part of Windows or IIS per se, but yes It works better than any of that Windows junk! Thanks L Marcus -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 8:42 PM To: CF-Talk Subject: RE: How to secure CF ADMIN PAGE > I got Windows (IIS) to ask for a login but if you cancel it > enough times it it just goes away and you can then get to > the CF admin. In that case, you haven't set it up correctly. You can certainly do this using IIS and Windows filesystem ACLs, together, but you have to do it correctly. > What do I have To do write an LDAP app in CF? This seems > silly. There must be a way to secure the CF Administration > page using windows. LDAP has nothing to do with this. Assuming that your web server's root directory is c:\inetpub\wwwroot (which, of course, it really shouldn't be), these steps (which may not be exact, as I'm typing them from memory) should get you where you need to go: 1. Find your CFIDE directory in Windows Explorer within c:\inetpub\wwwroot. 2. Find the "administrator" subdirectory. 3. Right-click on that directory, and select "Properties". 4. Remove all rights for the IUSR_MACHINENAME, IWAM_MACHINENAME, "Everyone" and "Authenticated Users" accounts and contextual groups, if they exist. 5. Within the IIS MMC, find your virtual server. Make sure there's no CFIDE virtual directory for it, if in fact you have the physical directory CFIDE within the web root folder already. 6. Open the CFIDE directory within IIS MMC, and find the administrator subdirectory. 7. Right-click on it within IIS MMC, and select "Properties". 8. Select the "Directory Security" tab. 9. Disable "Anonymous" access, and enable either Basic or Windows Authentication. 10. Cycle your virtual web server if necessary; in some cases, I've had to actually reboot the server (!) to get permissions changes to take effect in IIS. It's worth noting that there are additional steps you can (and probably should) take to secure access to the CF Administrator, such as configuring it to run within its own virtual server, limiting access to that server to allow only LAN access, requiring client certificates in conjunction with HTTPS, and so on. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: To MAXLENGTH or not that is the question?
> Isn't the whole point of "maxlength" to keep SQL commands from > being passed in the query string? The size dictated by the > database isn't going to matter much when it gets a ";drop table > users;" passed along with a regular query. No, the MAXLENGTH parameter isn't required to stop this. Simply using CFQUERYPARAM to separate bind parameters from the actual SQL statement accomplishes this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF treatment of queries inside CFCs
> I forgot to say that this DB CFC extends another which is > more general DB library (contains server wide DB functions). > Also in my CFC I have a number of private functions that do > common DB operations. I don't see any way that I could > leverage OO more, any suggestions? Well, it sounds like you couldn't leverage OO any less, actually. As Matt said, that's not necessarily bad, but putting functions in CFCs does not make something OO. If you were using objects in the OO sense of the word, those objects would represent individual entities that your program describes. For example, if you had a program that dealt with cars, when your program talked about a new car you'd create a Car object, which you'd treat more or less like any other variable. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SES urls on CFMX 6.1
> In the mean time, me and me mates will be enjoying the > benefits of a great little utility that does more than > we could have asked for. Unfortunately, significant legal issues can arise when you use code without a clear license or some similar provenance, if you put that code into your client's application. These issues are unlikely to arise, but unpleasant when they do, from what I've seen and heard. On the bright side, these issues are resolved through civil courts rather than criminal, so you don't end up with mates named "Bubba", if you know what I mean. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF treatment of queries inside CFCs
> I would be interested to see what the imapct on performance > is in regards to having "DB" CFCs that handle DB operations. In my (admittedly limited) experience, it hasn't made a significant difference. It's usually a pretty thin abstraction layer, actually. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to secure CF ADMIN PAGE
> I got Windows (IIS) to ask for a login but if you cancel it > enough times it it just goes away and you can then get to > the CF admin. In that case, you haven't set it up correctly. You can certainly do this using IIS and Windows filesystem ACLs, together, but you have to do it correctly. > What do I have To do write an LDAP app in CF? This seems > silly. There must be a way to secure the CF Administration > page using windows. LDAP has nothing to do with this. Assuming that your web server's root directory is c:\inetpub\wwwroot (which, of course, it really shouldn't be), these steps (which may not be exact, as I'm typing them from memory) should get you where you need to go: 1. Find your CFIDE directory in Windows Explorer within c:\inetpub\wwwroot. 2. Find the "administrator" subdirectory. 3. Right-click on that directory, and select "Properties". 4. Remove all rights for the IUSR_MACHINENAME, IWAM_MACHINENAME, "Everyone" and "Authenticated Users" accounts and contextual groups, if they exist. 5. Within the IIS MMC, find your virtual server. Make sure there's no CFIDE virtual directory for it, if in fact you have the physical directory CFIDE within the web root folder already. 6. Open the CFIDE directory within IIS MMC, and find the administrator subdirectory. 7. Right-click on it within IIS MMC, and select "Properties". 8. Select the "Directory Security" tab. 9. Disable "Anonymous" access, and enable either Basic or Windows Authentication. 10. Cycle your virtual web server if necessary; in some cases, I've had to actually reboot the server (!) to get permissions changes to take effect in IIS. It's worth noting that there are additional steps you can (and probably should) take to secure access to the CF Administrator, such as configuring it to run within its own virtual server, limiting access to that server to allow only LAN access, requiring client certificates in conjunction with HTTPS, and so on. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
Matt Liotta wrote: >> Ray, you gotta check out Spikes FriendlyURL servlet: >> http://www.spike.org.uk/go/friendly-urls. It works effectively the >> same >> as Apache mod_rewrite (but will run on IIS and Apache and the CFMX >> built-in server for that matter). You can resolve the URL to any other >> URL including dynamic parameters etc. There is a CFC to help manage >> the URL cache. > > > I personally don't like using software that is available for download > in non-source form without any kind of license, but that is just me. > For those looking for a Servlet to handle SES URLs that is open source > and available in the public domain, please search any of the major > lists for the Servlet source code that I have shared over and over; > most recently on BlueDragon-interest. Of course, we are talking three > lines of code here, so maybe people will just want to write their own > Servlet. Well for those who don't want to write their own servlet -- and actually want something that goes beyond a three line regex -- I'd vouch for Spikes code any day. In any event, I believe he's releasing the source under CPL (which is an open source license) in the next couple of weeks. In the mean time, me and me mates will be enjoying the benefits of a great little utility that does more than we could have asked for. -- geoff bowers Managing Director Daemon Internet Consultants Macromedia Premier Solutions Partner http://www.daemon.com.au/ p. 02 9380 4162 f. 02 9380 4204 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How to secure CF ADMIN PAGE
Hey Folks: I got Windows (IIS) to ask for a login but if you cancel it enough times it it just goes away and you can then get to the CF admin. What do I have To do write an LDAP app in CF? This seems silly. There must be a way to secure the CF Administration page using windows. Thanks L Marcus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF treatment of queries inside CFCs
I would be interested to see what the imapct on performance is in regards to having "DB" CFCs that handle DB operations. -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 5:49 PM To: CF-Talk Subject: RE: CF treatment of queries inside CFCs I forgot to say that this DB CFC extends another which is more general DB library (contains server wide DB functions). Also in my CFC I have a number of private functions that do common DB operations. I don't see any way that I could leverage OO more, any suggestions? TK -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 4:41 PM To: CF-Talk Subject: Re: CF treatment of queries inside CFCs Sounds like you are using a CFC as a function library instead of as an object. This isn't necessarily bad, but you don't get any benefits of an OO design. -Matt On Thursday, October 30, 2003, at 04:04 PM, Tom Kitta wrote: > Hello, > > I would like you guys to give me some feedback as to my recent > programming > practice. What do you think of it, how can it be improved etc. > > I decided to place all of my CF application database access into a > single > CFC, i.e. every query that the application ever uses is inside this > cfc. > There are only functions that implement queries in this CFC, it is > called > 'DBgateway'. I initialize this CFC in the application.cfm file if it > is not > already present, CFC is loaded into application scope with 2 day > timeout. > Each time I use a function from this CFC I execute some query (or a > transaction). I don't lock calls to these functions since I don't > think that > a race condition is possible (I have though of many possible scenarios > and I > don't see any race condition possibility or dirty reads or anything > like > that). > > Inside the CFC there are about 100+ functions and the CFC is over > 150kb in > size. Each function encapsulates the query(s) with cftry block and if > a DB > error occurs another function (only function lucking a query within it > in > the whole CFC) generates debug e-mail that is sent to me. Each insert, > update and delete operation is recorded to an audit table. > > I use cftransaction tag if more than one query has to be executed > inside a > function and queries depend on each other. For insert operations I > always > return inserted record id (zero on error). > > What do you think, good, bad or between? I don't really have anyone in > the > office to criticize me so I need to ask outside. > > TK > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting Algorithm ala Netflix
Why not make it an array, then do those useful array functions on it. a = ArrayNew(1); a[1] = 1234; a[2] = 2345; a[3] = 3456; a[4] = 4567; a[5] = 5678; then move #4 to #2: temp = a[4]; ArrayDeleteAt(a,4); ArrayInsertAt(a,2,temp); the form stuff wouldn't be too hard to figure out, form.movie1=1 form.movie2=2 form.movie3=3 form.movie4=2 (this one doesn't match, so do your stuff) form.movie5=5 It's not all necessarily flawless, but the sorting thing does make more sense using arrays. Then, after sorting, re-insert them all into the DB in the new order. -nathan strutz -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 3:39 PM To: CF-Talk Subject: Re: Sorting Algorithm ala Netflix No, there would only be one item as #2, one as #3, etc. The query runs for ALL items in the database and adds one where the sort order is Greater Than or Equal To the number you pass. So if you add "2" then the current 2 becomes 3, 3 becomes 4 and so on. On Thu, 2003-10-30 at 13:59, Randell B Adkins wrote: > problem would then be what is two items were listed with the #2 > then the sortorder would be 3 for both items > > >>> [EMAIL PROTECTED] 10/30/03 01:55PM >>> > I do this with menu items in our application, when you add a new item > you can select its sort order and if it's inserted at 15, then a small > SQL query simply sets everything greater than or equal to 15 to > increment by one. > > UPDATE tblMenuItems SET > sortorder=sortorder + 1 > WHERE sortorder >= #val(form.sortorder)# > > Pretty simple method, but it works! > > On Thu, 2003-10-30 at 13:31, Sandy Clark wrote: > > Does anyone know offhand what sorting algorithm Netflix uses to sort > > their > > queue? > > > > Specifically, when I resort the queue in Netflix, I might change an > > item > > from number 25 to 15 , which means that the item which was > originally > > 15 is > > renumbered to 16, etc. > > > > I've got to implement the same thing (not for DVD's), but thought I > > would > > ask before re-inventing the wheel. > > > > Sandy > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
> Ray, you gotta check out Spikes FriendlyURL servlet: > http://www.spike.org.uk/go/friendly-urls. It works effectively the > same > as Apache mod_rewrite (but will run on IIS and Apache and the CFMX > built-in server for that matter). You can resolve the URL to any other > URL including dynamic parameters etc. There is a CFC to help manage > the > URL cache. > I personally don't like using software that is available for download in non-source form without any kind of license, but that is just me. For those looking for a Servlet to handle SES URLs that is open source and available in the public domain, please search any of the major lists for the Servlet source code that I have shared over and over; most recently on BlueDragon-interest. Of course, we are talking three lines of code here, so maybe people will just want to write their own Servlet. Matt Liotta President & CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF treatment of queries inside CFCs
I forgot to say that this DB CFC extends another which is more general DB library (contains server wide DB functions). Also in my CFC I have a number of private functions that do common DB operations. I don't see any way that I could leverage OO more, any suggestions? TK -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 4:41 PM To: CF-Talk Subject: Re: CF treatment of queries inside CFCs Sounds like you are using a CFC as a function library instead of as an object. This isn't necessarily bad, but you don't get any benefits of an OO design. -Matt On Thursday, October 30, 2003, at 04:04 PM, Tom Kitta wrote: > Hello, > > I would like you guys to give me some feedback as to my recent > programming > practice. What do you think of it, how can it be improved etc. > > I decided to place all of my CF application database access into a > single > CFC, i.e. every query that the application ever uses is inside this > cfc. > There are only functions that implement queries in this CFC, it is > called > 'DBgateway'. I initialize this CFC in the application.cfm file if it > is not > already present, CFC is loaded into application scope with 2 day > timeout. > Each time I use a function from this CFC I execute some query (or a > transaction). I don't lock calls to these functions since I don't > think that > a race condition is possible (I have though of many possible scenarios > and I > don't see any race condition possibility or dirty reads or anything > like > that). > > Inside the CFC there are about 100+ functions and the CFC is over > 150kb in > size. Each function encapsulates the query(s) with cftry block and if > a DB > error occurs another function (only function lucking a query within it > in > the whole CFC) generates debug e-mail that is sent to me. Each insert, > update and delete operation is recorded to an audit table. > > I use cftransaction tag if more than one query has to be executed > inside a > function and queries depend on each other. For insert operations I > always > return inserted record id (zero on error). > > What do you think, good, bad or between? I don't really have anyone in > the > office to criticize me so I need to ask outside. > > TK > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
Greg Luce wrote: > OK, then let's get right to the point. What stats package can handle > fusebox urls? I know with the right combination of filtering and activating URL parameters, funnelweb does a very good job of handling fusebox params. regards, larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting Algorithm ala Netflix
Wouldn't it be easier to just do (in similarly bad pseudo code): Loop over each form item (sortorder) to update ... Insert or Update this item ... (then) UPDATE tblMenuItems SET sortorder=sortorder + 1 WHERE sortorder >= #val(sortorder)# Loop On Thu, 2003-10-30 at 14:15, Sandy Clark wrote: > The other issue is that a user can set more than one item at a time in > the > form. > > > I think I have the basics of it, using two form variables for each > row > (newsort and origsort) (in really bad pseudo code) > while reset == true > reset = false > for x = 1 to number of rows > If newsort[x] != origsort[x] > find origsort[n] that is equal to the newsort[x] > set the newsort[n] to newsort[x] + 1] > set reset = true > end for > end while > > _ > > From: Randell B Adkins [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 30, 2003 2:00 PM > To: CF-Talk > Subject: Re: Sorting Algorithm ala Netflix > > problem would then be what is two items were listed with the #2 > then the sortorder would be 3 for both items > > >>> [EMAIL PROTECTED] 10/30/03 01:55PM >>> > I do this with menu items in our application, when you add a new item > you can select its sort order and if it's inserted at 15, then a small > SQL query simply sets everything greater than or equal to 15 to > increment by one. > > UPDATE tblMenuItems SET > sortorder=sortorder + 1 > WHERE sortorder >= #val(form.sortorder)# > > Pretty simple method, but it works! > > On Thu, 2003-10-30 at 13:31, Sandy Clark wrote: > > Does anyone know offhand what sorting algorithm Netflix uses to sort > > their > > queue? > > > > Specifically, when I resort the queue in Netflix, I might change an > > item > > from number 25 to 15 , which means that the item which was > originally > > 15 is > > renumbered to 16, etc. > > > > I've got to implement the same thing (not for DVD's), but thought I > > would > > ask before re-inventing the wheel. > > > > Sandy > > > > > > _ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sorting Algorithm ala Netflix
No, there would only be one item as #2, one as #3, etc. The query runs for ALL items in the database and adds one where the sort order is Greater Than or Equal To the number you pass. So if you add "2" then the current 2 becomes 3, 3 becomes 4 and so on. On Thu, 2003-10-30 at 13:59, Randell B Adkins wrote: > problem would then be what is two items were listed with the #2 > then the sortorder would be 3 for both items > > >>> [EMAIL PROTECTED] 10/30/03 01:55PM >>> > I do this with menu items in our application, when you add a new item > you can select its sort order and if it's inserted at 15, then a small > SQL query simply sets everything greater than or equal to 15 to > increment by one. > > UPDATE tblMenuItems SET > sortorder=sortorder + 1 > WHERE sortorder >= #val(form.sortorder)# > > Pretty simple method, but it works! > > On Thu, 2003-10-30 at 13:31, Sandy Clark wrote: > > Does anyone know offhand what sorting algorithm Netflix uses to sort > > their > > queue? > > > > Specifically, when I resort the queue in Netflix, I might change an > > item > > from number 25 to 15 , which means that the item which was > originally > > 15 is > > renumbered to 16, etc. > > > > I've got to implement the same thing (not for DVD's), but thought I > > would > > ask before re-inventing the wheel. > > > > Sandy > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
Raymond Camden wrote: > Under IIS, I think you need a third party extension - I use one from > Helicon, which is free for one server. For Apache, it's super simple and > part of the server. Ray, you gotta check out Spikes FriendlyURL servlet: http://www.spike.org.uk/go/friendly-urls. It works effectively the same as Apache mod_rewrite (but will run on IIS and Apache and the CFMX built-in server for that matter). You can resolve the URL to any other URL including dynamic parameters etc. There is a CFC to help manage the URL cache. If you set it up right you can even get URL clipping to work. For example, in FarCry we can do the following... These URLs are equivalent: http://farcry.daemon.com.au/index.cfm?objectid=007E73A5-D0B7-4CD6-F99F852D4199F0DF http://farcry.daemon.com.au/go/downloads/farcry-plugins/friendly-urls http://farcry.daemon.com.au/go/downloads/farcry-plugins/friendly-urls/ http://farcry.daemon.com.au/go/downloads/farcry-plugins/friendly-urls/index.cfm The URL can be clipped to go higher in the site hierarchy: http://farcry.daemon.com.au/go/downloads/farcry-plugins/ http://farcry.daemon.com.au/go/downloads/ Now if that ain't nanna-goat sweet, what is? -- geoff bowers Managing Director Daemon Internet Consultants Macromedia Premier Solutions Partner http://www.daemon.com.au/ p. 02 9380 4162 f. 02 9380 4204 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
For what its worth, if you use the FriendlyURL servlet developed by Spike (http://www.spike.org.uk/go/friendly-urls) you get the following answers: ** Does using SES make web stats work better? Yes, absolutely. Your logs are populated with entries that for all intensive purposes are identical to users accessing flat pages. That means that pretty much any standard log analysing tool will work without modification. (Many stats package fall down badly with dynamic params). ** Does your Google ranking improve? Yes, without doubt. Although dynamic urls are indexed to a degree by Google it is picky about the type of URL params it uses to dsistinguish pages -- there are no details so don't ask. The most significant improvement is that google puts emphasis on the keywords it finds in the URL. With this method you get keywords in the URL that bump up your ranking nicely. We've integrated FriendlyURL servlet directly into the FarCry CMS Opensource -- it works like a charm, is cross platform and cross webserver. If you want to see it in action see the URLs at http://farcry.daemon.com.au/ -- geoff bowers Managing Director Daemon Internet Consultants Macromedia Premier Solutions Partner http://www.daemon.com.au/ p. 02 9380 4162 f. 02 9380 4204 Greg Luce wrote: > OK, then let's get right to the point. What stats package can handle > fusebox urls? > > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 30, 2003 1:50 PM > To: CF-Talk > Subject: Re: SES urls on CFMX 6.1 > > On Thursday 30 Oct 2003 17:10 pm, Matt Robertson wrote: > > Thomas wrote: > > >> Does using SES make web stats work better? > > >No. > > > > Yes. Some stats programs just can't handle parameters. > > I wouldn't call a 'stats' package with such a bug a stats package :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF treatment of queries inside CFCs
Sounds like you are using a CFC as a function library instead of as an object. This isn't necessarily bad, but you don't get any benefits of an OO design. -Matt On Thursday, October 30, 2003, at 04:04 PM, Tom Kitta wrote: > Hello, > > I would like you guys to give me some feedback as to my recent > programming > practice. What do you think of it, how can it be improved etc. > > I decided to place all of my CF application database access into a > single > CFC, i.e. every query that the application ever uses is inside this > cfc. > There are only functions that implement queries in this CFC, it is > called > 'DBgateway'. I initialize this CFC in the application.cfm file if it > is not > already present, CFC is loaded into application scope with 2 day > timeout. > Each time I use a function from this CFC I execute some query (or a > transaction). I don't lock calls to these functions since I don't > think that > a race condition is possible (I have though of many possible scenarios > and I > don't see any race condition possibility or dirty reads or anything > like > that). > > Inside the CFC there are about 100+ functions and the CFC is over > 150kb in > size. Each function encapsulates the query(s) with cftry block and if > a DB > error occurs another function (only function lucking a query within it > in > the whole CFC) generates debug e-mail that is sent to me. Each insert, > update and delete operation is recorded to an audit table. > > I use cftransaction tag if more than one query has to be executed > inside a > function and queries depend on each other. For insert operations I > always > return inserted record id (zero on error). > > What do you think, good, bad or between? I don't really have anyone in > the > office to criticize me so I need to ask outside. > > TK > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF treatment of queries inside CFCs
Hello, I would like you guys to give me some feedback as to my recent programming practice. What do you think of it, how can it be improved etc. I decided to place all of my CF application database access into a single CFC, i.e. every query that the application ever uses is inside this cfc. There are only functions that implement queries in this CFC, it is called 'DBgateway'. I initialize this CFC in the application.cfm file if it is not already present, CFC is loaded into application scope with 2 day timeout. Each time I use a function from this CFC I execute some query (or a transaction). I don't lock calls to these functions since I don't think that a race condition is possible (I have though of many possible scenarios and I don't see any race condition possibility or dirty reads or anything like that). Inside the CFC there are about 100+ functions and the CFC is over 150kb in size. Each function encapsulates the query(s) with cftry block and if a DB error occurs another function (only function lucking a query within it in the whole CFC) generates debug e-mail that is sent to me. Each insert, update and delete operation is recorded to an audit table. I use cftransaction tag if more than one query has to be executed inside a function and queries depend on each other. For insert operations I always return inserted record id (zero on error). What do you think, good, bad or between? I don't really have anyone in the office to criticize me so I need to ask outside. TK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import of Text File
this goes quite a bit faster if you turn your return seperated list into an array. listtoarray. then just loop thru the array. DRE -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 1:24 PM To: CF-Talk Subject: RE: Import of Text File use to read the file into a variable. Use LEN(trim(yourvar)) to see if the file is empty. Then use the list functions to break it up into the data elements to be entered into your database. use listlen() to determine how many elements then loop thru the list using listgetat() to pull out each element and place in a var, then do an insert query to place each record in your database. You didn't mention how each record would be separated out. CR/LN or if you know that every Nth element would be the start of a new record. Hope this helps point you in the right direction. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 12:38 PM To: CF-Talk Subject: Import of Text File Hello All, I need to import a tab delimited text file in to an access database. I know that this is possible just don't know how to go about it. One more thing is that sometimes the file may be empty. Can someone point me in the right direction? Thanks Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC from App to Request scope?
You shouldn't need to worry about that. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Import of Text File
Thanks Bruce, That does help a lot. I will have to look up list functions I have never used them. Thanks for the help. MIke - Original Message - From: Bruce, Rodney S HQISEC/Veridian IT Services To: CF-Talk Sent: Thursday, October 30, 2003 3:24 PM Subject: RE: Import of Text File use to read the file into a variable. Use LEN(trim(yourvar)) to see if the file is empty. Then use the list functions to break it up into the data elements to be entered into your database. use listlen() to determine how many elements then loop thru the list using listgetat() to pull out each element and place in a var, then do an insert query to place each record in your database. You didn't mention how each record would be separated out. CR/LN or if you know that every Nth element would be the start of a new record. Hope this helps point you in the right direction. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 12:38 PM To: CF-Talk Subject: Import of Text File Hello All, I need to import a tab delimited text file in to an access database. I know that this is possible just don't know how to go about it. One more thing is that sometimes the file may be empty. Can someone point me in the right direction? Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC from App to Request scope?
Thanks for taking the time to respond. I got all of your points except
for one sentence, so I'll pick it apart:
>However, if you lock the intantiation of the component without
>requiring read locks
You lost me there. Sorry, if it's a couple-liner, would you show me in
code?
>then you can pull all the CFLOCK tags inside the CFC
>(when it manipulates instance data)
Actually, is it only instance data that I have to worry about? As a
matter of fact, none of my methods modifies instance data, they only
read the instance variables.
>so your code isn't littered with CFLOCKs.
My CFC follows, in case it helps.
Thanks again,
Jamie
returntype="helpDef">
// the following querySim has been shortened for this example
request.querySim("
definitionQry
termId, type, term, definition, example
communityResults | component | Community Results | Measureable,
long-term outcomes achieved by individuals, families, and communities.
|
programResults | component | Program Results | Short-term outcomes
related to unit leadership, informal networks, and program agencies. |
communityCapacity | component | Community Capacity | The extent to
which community members demonstrate a sense of shared responsibility
for their community and a collective competence (i.e., a community's
belief in its capability) to respond to community challenges. |
");
// cache queries for a long time (30 days)
cacheSpan = createTimeSpan(30,0,0,0);
// alternate nil span for clearing query caches
nilSpan = createTimeSpan(0,0,0,0);
returntype="query">
default="all">
default="false">
SELECT term
FROM definitionQry
WHERE 0=0
AND termId = '#termId#'
AND type = '#type#'
returntype="string">
default="false">
cachedwithin="#cacheSpan#">
SELECT definition
FROM definitionQry
WHERE termId = '#termId#'
AND type = '#type#'
returntype="query">
default="all">
default="false">
SELECT term, definition
FROM definitionQry
WHERE 0=0
AND termId = '#termId#'
AND type = '#type#'
output="true" returntype="string">
default="all">
default="false">
clearCache="#clearCache#")>
#term# - #definition#
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFC from App to Request scope?
>The reason I tried to duplicate into the request scope: To minimize >the need for locks on the application-scope reads. (Feel free to >refute that one, too. :) Love to... You don't need to lock variables in CFMX to keep from memory fragmentation and server crashing. This is done for you by Java. You do need to lock if there is potential for a race condition, where 2 people could write to the same variable and cause general application havoc (for instance, 2 people selecting the same unique record accidentally). If your application scoped CFC reads and writes variables that can make changes to all users on your site and can cause race conditions, you should lock, however, do the locking IN the CFC, around the lines that require the locks, not outside and around it. -nathan strutz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF/Access/SQL query - solved
Laura, please do NOT reject the use of CFQUERYPARAM !!! Your code will break the first time it encounters a name like "O'Brien" or "D'Aprile" CFPARAM is NOT a substitute for CFQUERYPARAM -Original Message- From: Laura Schlee [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 8:29 AM To: CF-Talk Subject: CF/Access/SQL query - solved Hi all, Thanks to everyone who helped out with my issue. After incorporating practically all of the suggested changes (except for the person whose email I accidentally deleted before I had a chance to try your changes -- my apologies, since you were nice enough to test your solution for me) my query is now running. Here's the edited code: datasource="CMISPersonnel"> Select Personnel.FirstName, Personnel.MiddleInitial, Personnel.LastName, Personnel.Zip, Personnel.SpaceNumber, Vehicles.TagNumber, Vehicles.DecalNumber, Vehicles.PermitNumber from Personnel, Vehicles where Personnel.PersonnelKey = Vehicles.PersonnelKey and LastName like '%#form.LastName#%' and Zip = '#form.Zip#' and PermitNumber = '#form.PermitNumber#' and SpaceNumber = '#form.SpaceNumber#' and TagNumber = '#form.TagNumber#' and DODDecalNumber = '#form.DODDecalNumber#' order by LastName > > -Original Message- > From: Laura Schlee [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 29, 2003 11:15 AM > To: CF-Talk > Subject: CF/Access/SQL query > > > Hi all, > > I'm having a problem with a query and I think it > might > be Access-related. Here's the text: > > > datasource="CMISPersonnel"> > Select FirstName, MiddleInitial, LastName, Zip, > SpaceNumber, TagNumber, DecalNumber, PermitNumber > from Personnel, Vehicles > where Personnel.PersonnelKey = Vehicles.PersonnelKey > > > and LastName like '%#form.LastNameSearch#%' > > > > and Zip = #form.ZipCodeSearch# > > > > and PermitNumber = #form.PermitNbrSearch# > > > > and SpaceNumber = #form.SpaceNbrSearch# > > > > and TagNumber = #form.TagSearch# > > > > and DecalNumber = #form.DecalSearch# > > order by LastName > > > Here's the error message: > > Invalid use of '.', '!', or '()'. in query > _expression_ > 'Personnel.PersonnelKey = Vehicles.PersonnelKey '. __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql difficulty
Hi Mark, I should of mentioned that this is on an oracle db. DRE -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:23 AM To: CF-Talk Subject: RE: sql difficulty You can do this using aggregates and case statements (assuming your db can handle it... you didn't say what you were using) select checkno, total=count(*), -- I have no idea how you determine what is "unprocessed", so this is an made-up example unprocessed=sum(case when is_processed<>'Y' then 1 else 0 end), -- repeat for other counts from thetable group by checkno The idea is that you have a case statement that yields 1 or 0 depending on the particular state you want to count and use sum() to count them. Mark -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 12:42 PM To: CF-Talk Subject: sql difficulty Hi, I'm wondering if there is a difffernet way to do this. Basically I have a table that has lots of records. I need to show in a list multiple agregates on this table. It pretty much has to be live to reflect the current data. One of the fields is a checkno. This is main group. So everything groups on this. So I might have 10 with check no a, 20 with check no b and 30 with check no c. The list that the user sees would then have 3 entries. There is additinal information in the table that I need to agregate. I need counts on other fields in that group where the other field is this or that and sums on another field where that other field is that or this. So basically, it will look like this. checkno | total | unprocessed | success | failure | sum | preped | unprepped a10 72 1 65 3 4 B20 72 2 44 2 5 C1 72 3 28 4 3 So, should I simply run 5 agregate queries and mix the results into one query result set? Or is there another way? Thanks in advance DRE [Andre Turrettini] -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 8:23 AM To: CF-Talk Subject: UniData ODBC connectivity Hi, I've posted a similar question some time ago about UniData ODBC connectivity. This time, it's more specific. I'm new to UniData. I'd like to set up an ODBC connection to the UniData database hosted on an NT box on the network. I read some documentation. Is the following understanding correct? Two key pieces: 1) uci.conf file, an entry pointing to the train(training) database; 2) install Unidata ODBC driver, making the ODBC datasource setup matches that. UniData questions (not ODBC), after login to Unidata, a) how to find the current database, most likely default to production (Main), then, how to switch to Train database? b) how to find what accounts are available/associated with Train database? c) how to create an account for Train database? ODBC connection questions: when using VSG to map schema, one has to call UniData file/data to do table mapping, one file name is called IM (for Item Master), how to find all other file names? Of which, what would seem to be more important? Many thanks. Don Li _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import of Text File
use to read the file into a variable. Use LEN(trim(yourvar)) to see if the file is empty. Then use the list functions to break it up into the data elements to be entered into your database. use listlen() to determine how many elements then loop thru the list using listgetat() to pull out each element and place in a var, then do an insert query to place each record in your database. You didn't mention how each record would be separated out. CR/LN or if you know that every Nth element would be the start of a new record. Hope this helps point you in the right direction. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 12:38 PM To: CF-Talk Subject: Import of Text File Hello All, I need to import a tab delimited text file in to an access database. I know that this is possible just don't know how to go about it. One more thing is that sometimes the file may be empty. Can someone point me in the right direction? Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Striping URL (SOLVED)
I don't have the cgi.url available that you do, but cgi.script_name is easy enought to substitute. You have to use listlast on that part instead of listfirst: Thats one heck of a lot simpler than what I've been using. --- Matt Robertson MSB Designs, Inc. [EMAIL PROTECTED] --- An honest politician is one who, when bought, stays bought. - Unknown [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: html entities
Jerry, Thanks. But, line feeds are taken care of in other parts of the code and weren't the issue. I actually figured it out. Doh. Helps to actually call the function on ALL the output. *sigh* Is it Friday yet? -d - Original Message - From: "Jerry Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 30, 2003 1:55 PM Subject: Re: html entities > Chances are, you aren't handling the fancier versions of things. > > You've handled the hyphen, but not the mdash or the ndash, for example. > > It probably uses carraige return/line feeds (chr(13) and chr(10)), so you need to handle both of those. > > Just some gueses. > > Jerry Johnson > > >>> [EMAIL PROTECTED] 10/30/03 02:11PM >>> > Okay, I'm trying to strip out html entity codes that don't play nicely with > RTF for a "download as word doc" feature. I have it working for a bunch of > them, but this one doesn't work: > str = replace(str, '&##61623;', 'chr(10)', 'All'); > > And this one only works sometimes: > str = replace(str, '&##8211;', '-', 'ALL'); > > Where as all these work: > str = replace(str,"&##8217;", "'", "ALL"); > str = replace(str,'&##8220;', '"', 'ALL'); > str = replace(str,'&##8221;', '"', 'ALL'); > str = replace(str, '&##8212;', '--', 'ALL'); > str = replace(str, '-', '-', 'ALL'); > str = replace(str, '&##8230;', '...', 'ALL'); > str = replace(str, "&##8216", "'", "ALL"); > > > I'm going a little nuts here. What am I missing? > > - > Deanna Schneider > UWEX-Cooperative Extension > Interactive Media Developer > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC from App to Request scope?
[Whoops, replied to the newsgroup only the first time] On Thu, 30 Oct 2003 13:38:40 -0600, "Raymond Camden" <[EMAIL PROTECTED]> wrote: >Simply put - you can't duplicate a CFC. Why do you need the duplicate? Okay, that explains that, then. Thanks. The reason I tried to duplicate into the request scope: To minimize the need for locks on the application-scope reads. (Feel free to refute that one, too. :) Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Non-Stick Session Variables?
> I am assuming you mean something like the Client.URLToken or > Session.URLToken? While searching for the aforementioned I > stumbled across the Cfapplication SetDomainCookies attribute. Those things allow you to manage session tokens for your users' browsers, and don't affect your use of CFHTTP to talk to another server. If you're using CFHTTP, your CF code IS the browser, and will be responsible for reading cookies set by the remote server, and for returning those cookies on subsequent requests. You can see these cookies by looking in either CFHTTP.Header or CFHTTP.ResponseHeader, and you can set these cookies on subsequent requests using CFHTTPPARAM. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Non-Stick Session Variables?
Thanks, Mosh. I am assuming you mean something like the Client.URLToken or Session.URLToken? While searching for the aforementioned I stumbled across the Cfapplication SetDomainCookies attribute. From what I read the SetDomainCookies attributed places cookies on the host. I suspect there are advantages/disadvantages to this different approaches. Like maybe some hosts don't allow cookies, etc.? Any comments from others? Anyone aware of a trap and restore cookie tag/snippet Thanks, Nick At 02:06 PM 10/30/2003 -0500, you wrote: >Nick: > >SESSION variables are client-specific. Clients are identified by specifying >a unique identifier either via cookies or URL parameters. > >In order to maintain a session while using multiple CFHTTP requests, you'll >have to trap any cookies set in one request and specify them in all later >requests. > >-- >Mosh Teitelbaum >evoch, LLC >Tel: (301) 942-5378 >Fax: (301) 933-3651 >Email: [EMAIL PROTECTED] >WWW: http://www.evoch.com/ > >-Original Message- >From: Nick Baker [mailto:[EMAIL PROTECTED] >Sent: Thursday, October 30, 2003 1:59 PM >To: CF-Talk >Subject: Non-Stick Session Variables? > > >Is there a trick to keeping session variables alive when a Web page is >called via and CFHTTP, i.e., from another Web site? The session variables >stick when I called the Web page directly from a browser, but not via >CFHTTP. > >Does this mean the session variables are relying on Cookies? Below is the >CFAPPLICATION code. > > > CLIENTMANAGEMENT="Yes" > SETCLIENTCOOKIES="Yes" > SESSIONMANAGEMENT="Yes" > SESSIONTIMEOUT=#CreateTimeSpan(0, 2, 0, 0)# > APPLICATIONTIMEOUT=#CreateTimeSpan(0, 2, 0, 0)# > > > >Thanks, > >Nick > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC from App to Request scope?
There isn't a need to duplicate() it then. Request.myCFC=Application.myCFC -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 3:01 PM To: CF-Talk Subject: Re: CFC from App to Request scope? On Thu, 30 Oct 2003 13:38:40 -0600, "Raymond Camden" <[EMAIL PROTECTED]> wrote: >Simply put - you can't duplicate a CFC. Why do you need the duplicate? Okay, that explains that, then. Thanks. The reason I tried to duplicate into the request scope: To minimize the need for locks on the application-scope reads. (Feel free to refute that one, too. :) Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Non-Stick Session Variables?
Had to come up with a solution to this for a project I just finished a couple of weeks ago. I appended the appropriate CFID and CFTOKEN to the url called by cfhttp. This was something where the user was grabbing something belonging to their own session, so it worked out fine. The obvious rub here here is you have to know the user's cfid and cftoken to get the job done this way. --- Matt Robertson MSB Designs, Inc. [EMAIL PROTECTED] --- In the strict scientific sense we all feed on death -- even vegetarians. - Spock, "Wolf in the Fold," stardate 3615.4. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC from App to Request scope?
On Thu, 30 Oct 2003 13:38:40 -0600, "Raymond Camden" <[EMAIL PROTECTED]> wrote: >Simply put - you can't duplicate a CFC. Why do you need the duplicate? Okay, that explains that, then. Thanks. The reason I tried to duplicate into the request scope: To minimize the need for locks on the application-scope reads. (Feel free to refute that one, too. :) Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Mapped drives on server not displaying...why?
> What happens if the server running CF and my application are > not on the same domain as the other two servers directories > I'm trying to access? Then you will have to use an account that either has rights to resources in the other domain (for example, if your domain is trusted by the other) or you will have to use different authentication when you create the drive mappings from that account: net use driveletter: \\server\share password /user:domainname\username Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: html entities
Chances are, you aren't handling the fancier versions of things. You've handled the hyphen, but not the mdash or the ndash, for example. It probably uses carraige return/line feeds (chr(13) and chr(10)), so you need to handle both of those. Just some gueses. Jerry Johnson >>> [EMAIL PROTECTED] 10/30/03 02:11PM >>> Okay, I'm trying to strip out html entity codes that don't play nicely with RTF for a "download as word doc" feature. I have it working for a bunch of them, but this one doesn't work: str = replace(str, '&##61623;', 'chr(10)', 'All'); And this one only works sometimes: str = replace(str, '&##8211;', '-', 'ALL'); Where as all these work: str = replace(str,"&##8217;", "'", "ALL"); str = replace(str,'&##8220;', '"', 'ALL'); str = replace(str,'&##8221;', '"', 'ALL'); str = replace(str, '&##8212;', '--', 'ALL'); str = replace(str, '-', '-', 'ALL'); str = replace(str, '&##8230;', '...', 'ALL'); str = replace(str, "&##8216", "'", "ALL"); I'm going a little nuts here. What am I missing? - Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC from App to Request scope?
You can't use duplicate on a CFC and get a CFC. Instead, you get some bizarre CFC/Struct hybrid. You have to use the CFC in the application scope directly, along with the locks. However, if you lock the intantiation of the component without requiring read locks, then you can pull all the CFLOCK tags inside the CFC (when it manipulates instance data), so your code isn't littered with CFLOCKs. Basically, the idea of locking the instantiation is to ensure that no request can get past the instantiation code without having an instance available to it, and that multiple instances will never be instantiated. Here's some code to do it: If you need to instantiate multiple application variables, that'll work too. You only need to check the existance of one of them (ideally a single-purpose flag variable), and set them all in the same place as the component instantiation. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:25 AM To: CF-Talk Subject: CFC from App to Request scope? The following doesn't seem to work: I'm trying to get my object to persist, but (I think) I would prefer to access the object via the request scope to reduce the number of locks needed. If I call a method on request.def, it's missing instance variables (and throwing an error, since they're required by the method), whereas with the application.def, it works fine. scope="APPLICATION"> I'm fairly new to CFCs, so any tips, critiques, or debunkings of my assumptions are welcome. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mapped drives on server not displaying...why?
What happens if the server running CF and my application are not on the same domain as the other two servers directories I'm trying to access? --Original Message Text--- From: David Delbridge Date: Thu, 30 Oct 2003 10:27:23 -0800 Here's an Active Directory approach (and, actually, the non-AD approach is almost identical): Create a domain user, "ColdFusion." Add 'Domain\ColdFusion' user to your CF server's 'Administrators' group. Assign this user to the 'ColdFusion Application Server Service' service a la "Log On as:" and "This Account: [EMAIL PROTECTED]" There is no need to modify the other CF services (Executive & RDS). Restart. Now, you can assign granular permissions for your ColdFusion server as any other user or group throughout your Windows network. For example, add [EMAIL PROTECTED] to the target server's 'Users' or 'Guests' groups, as appropriate. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Dave Watts wrote: > > ? No...CF service is running with Administrator account. I used > ? a different account for the mapped drive letters. I doubt I > ? can mapped them using the administrator password on the other > ? server since its a IT box. Should I get them to create a > ? generic username to use for the drive letter mappings and > ? change the CF service to the new account/password? > > If you want the CF service to be able to use the drive mappings, > you'll have > to create them with the same account used to run the CF service. By > default, > the CF service runs as SYSTEM, which doesn't have any rights to > network > resources. The account that you do use will need to have the > appropriate > user rights and ACL permissions assigned to it, as well. Ideally, this > account should be significantly less privileged than SYSTEM or > Administrator. > > But again, if you're still trying to solve your previous problem of > having > your clients work with mapped drives, CF is probably not the best > solution > for that problem. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Quick Jrun Mem Usage ?
Installed 6.1 on a Win 2000/IIS 5 machine that was running 5 for a year. Worked well. I do see, though, with just this instance running...that Jrun takes up 99 MB of resources alone. Is this common, or should I be more suspect of this number and worry about tweaking. We have plenty of memory available, so more of a learning task than anything immediately of concern. Thanks for sharing your experience!! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Books on advanced CF Topics
Techspedition.com "Discovering CFC's" Hal Helms and Ben Edwards (available from Amazon) _ From: Michael Hodgdon [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 2:28 PM To: CF-Talk Subject: FW: Books on advanced CF Topics Hey there CF Talk. Was wondering if anyone recommends books on CFC's and UDF's. Michael S. Hodgdon Harvard Graduate School of Education, PPE Web Developer P: 617-496-8341 AOL: michaelshodgdon Y!: michaelhodgdon _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC from App to Request scope?
Simply put - you can't duplicate a CFC. Why do you need the duplicate? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Import of Text File
Hello All, I need to import a tab delimited text file in to an access database. I know that this is possible just don't know how to go about it. One more thing is that sometimes the file may be empty. Can someone point me in the right direction? Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
accents
Do you guys know of a function for converting accented characters into their ascii equivalents or from é to é Gabriel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
FW: Books on advanced CF Topics
Hey there CF Talk. Was wondering if anyone recommends books on CFC's and UDF's. Michael S. Hodgdon Harvard Graduate School of Education, PPE Web Developer P: 617-496-8341 AOL: michaelshodgdon Y!: michaelhodgdon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Mapped drives on server not displaying...why?
> Create a domain user, "ColdFusion." Add 'Domain\ColdFusion' > user to your CF server's 'Administrators' group. Assign this > user to the 'ColdFusion Application Server Service' service > a la "Log On as:" and "This Account: [EMAIL PROTECTED]" > There is no need to modify the other CF services (Executive > & RDS). Restart. I would generally recommend that you avoid the unnecessary use of Administrator rights. With CF - especially CFMX - you can run the server as a user with fewer privileges, with a little bit of work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFC from App to Request scope?
The following doesn't seem to work: I'm trying to get my object to persist, but (I think) I would prefer to access the object via the request scope to reduce the number of locks needed. If I call a method on request.def, it's missing instance variables (and throwing an error, since they're required by the method), whereas with the application.def, it works fine. scope="APPLICATION"> I'm fairly new to CFCs, so any tips, critiques, or debunkings of my assumptions are welcome. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Book to learn MS SQL 2000
In my last position, I really needed a crash course in the basics of Transact SQL, SQL administration, and SQL Server's IDE. I found the following book very helpful http://www.amazon.com/exec/obidos/tg/detail/-/0782126278/qid=1067541349/sr=8 -3/ref=sr_8_3/103-3226193-8224602?v=glance&n=507846 It covers a wide array of topics. Coverage is basic and will get you up and running. I think once you get used how SQL server operates, you will feel right at home. BOL, and HTH Michael S. Hodgdon Harvard Graduate School of Education, PPE Web Developer P: 617-496-8341 AOL: michaelshodgdon Y!: michaelhodgdon -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 10:09 PM To: CF-Talk Subject: RE: Book to learn MS SQL 2000 Good question. I am currently using Access and I have a general book on writing SQL. So perhaps I am looking for recommendations of those of you who may have gone thru similar transitions. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 6:22 PM To: CF-Talk Subject: RE: Book to learn MS SQL 2000 Are you talking administration or writing sql? -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 6:22 PM To: CF-Talk Subject: OT: Book to learn MS SQL 2000 What books do folks recommend to learn MS SQL 2000. Looking for basics at this point. Thanks, Andy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting Algorithm ala Netflix
The other issue is that a user can set more than one item at a time in the form. I think I have the basics of it, using two form variables for each row (newsort and origsort) (in really bad pseudo code) while reset == true reset = false for x = 1 to number of rows If newsort[x] != origsort[x] find origsort[n] that is equal to the newsort[x] set the newsort[n] to newsort[x] + 1] set reset = true end for end while _ From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 2:00 PM To: CF-Talk Subject: Re: Sorting Algorithm ala Netflix problem would then be what is two items were listed with the #2 then the sortorder would be 3 for both items >>> [EMAIL PROTECTED] 10/30/03 01:55PM >>> I do this with menu items in our application, when you add a new item you can select its sort order and if it's inserted at 15, then a small SQL query simply sets everything greater than or equal to 15 to increment by one. UPDATE tblMenuItems SET sortorder=sortorder + 1 WHERE sortorder >= #val(form.sortorder)# Pretty simple method, but it works! On Thu, 2003-10-30 at 13:31, Sandy Clark wrote: > Does anyone know offhand what sorting algorithm Netflix uses to sort > their > queue? > > Specifically, when I resort the queue in Netflix, I might change an > item > from number 25 to 15 , which means that the item which was originally > 15 is > renumbered to 16, etc. > > I've got to implement the same thing (not for DVD's), but thought I > would > ask before re-inventing the wheel. > > Sandy > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
html entities
Okay, I'm trying to strip out html entity codes that don't play nicely with RTF for a "download as word doc" feature. I have it working for a bunch of them, but this one doesn't work: str = replace(str, '&##61623;', 'chr(10)', 'All'); And this one only works sometimes: str = replace(str, '&##8211;', '-', 'ALL'); Where as all these work: str = replace(str,"&##8217;", "'", "ALL"); str = replace(str,'&##8220;', '"', 'ALL'); str = replace(str,'&##8221;', '"', 'ALL'); str = replace(str, '&##8212;', '--', 'ALL'); str = replace(str, '-', '-', 'ALL'); str = replace(str, '&##8230;', '...', 'ALL'); str = replace(str, "&##8216", "'", "ALL"); I'm going a little nuts here. What am I missing? - Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Non-Stick Session Variables?
Nick: SESSION variables are client-specific. Clients are identified by specifying a unique identifier either via cookies or URL parameters. In order to maintain a session while using multiple CFHTTP requests, you'll have to trap any cookies set in one request and specify them in all later requests. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 1:59 PM To: CF-Talk Subject: Non-Stick Session Variables? Is there a trick to keeping session variables alive when a Web page is called via and CFHTTP, i.e., from another Web site? The session variables stick when I called the Web page directly from a browser, but not via CFHTTP. Does this mean the session variables are relying on Cookies? Below is the CFAPPLICATION code. CLIENTMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT=#CreateTimeSpan(0, 2, 0, 0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0, 2, 0, 0)# > Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MX Admin-Runtime Log Errors
Hello, I upgraded our production server to CFMX from CF5 last friday. After some initial hiccups, things seemed to settle down and I was impressed by the speed. I have one concern though, in the CFusionMX\runtime\logs\ directory, my default-err log has a ton of errors--it's 16MB in just a week. Now the server seems to be responsive, the standard CF Logs aren't showing anything out of the ordinary, but these errors just keep coming. I've included a few of the errors below, and the entire log file seems full of similar errors. (sorry for the length, wasn't sure what would help troublehsooting this) Any idea where to look to fix these errors? Thanks john --- John Venable Director of Web Architecture Epilepsy Foundation 10/30 13:36:58 error Connection reset java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) at java.io.BufferedInputStream.read1(BufferedInputStream.java:222) at java.io.BufferedInputStream.read(BufferedInputStream.java:277) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:530) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:522) at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:540) at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:229) at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:144) at jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.java:32 0) at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:433) at jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(ThreadPool.java:280) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:76) 10/30 13:17:28 error Error while reading header S_DATE_TIME java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124) at jrun.servlet.jrpp.ProxyEndpoint.getHeader(ProxyEndpoint.java:694) at javax.servlet.http.HttpServletRequestWrapper.getHeader(HttpServletRequestWra pper.java:124) at javax.servlet.http.HttpServletRequestWrapper.getHeader(HttpServletRequestWra pper.java:124) at coldfusion.runtime.CgiScope.resolve(CgiScope.java:123) at coldfusion.runtime.CgiScope.containsName(CgiScope.java:265) at coldfusion.runtime.CgiScope.search(CgiScope.java:298) at coldfusion.runtime.NeoPageContext.searchScopes(NeoPageContext.java:540) at coldfusion.runtime.NeoPageContext.findAttribute(NeoPageContext.java:465) at coldfusion.runtime.PageScope.resolveName(PageScope.java:51) at coldfusion.runtime.Scope.put(Scope.java:63) at coldfusion.runtime.CfJspPage._arrayset(CfJspPage.java:601) at coldfusion.runtime.NeoPageContext.SymTab_setSplitNameInMap(NeoPageContext.ja va:1081) at coldfusion.runtime.NeoPageContext.SymTab_setValidatedSplitNameInString(NeoPa geContext.java:1051) at coldfusion.runtime.NeoPageContext.SymTab_setValidatedDottedName(NeoPageConte xt.java:1127) at coldfusion.runtime.NeoPageContext.setValidatedAttribute(NeoPageContext.java: 408) at coldfusion.runtime.NeoPageContext.setAttribute(NeoPageContext.java:276) at coldfusion.runtime.CfJspPage._set(CfJspPage.java:229) at cfsavecontent2ecfm1186756816.runPage(C:\CFusionMX\wwwroot\WEB-INF\cftags\sav econtent.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java: 60) at coldfusion.tagext.lang.ModuleTag.doAfterBody(ModuleTag.java:334) at cfexception_en2exml1987932571.runPage(C:\CFusionMX\wwwroot\WEB-INF\exception \exception_en.xml:33) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfdetail2ecfm1487115729.runPage(C:\CFusionMX\wwwroot\WEB-INF\exception\detai l.cfm:33) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java: 60) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256) at cfTemplateException2ecfm755365794.runPage(C:\CFusionMX\wwwroot\WEB-INF\excep tion\coldfusion\runtime\TemplateException.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ExceptionFilter.runBuiltInHandler(ExceptionFilter.java:462 ) at coldfusion.filter.ExceptionFilter.handleException(ExceptionFilter.java:263) at coldfusion.filter.Exce
Re: Sorting Algorithm ala Netflix
problem would then be what is two items were listed with the #2 then the sortorder would be 3 for both items >>> [EMAIL PROTECTED] 10/30/03 01:55PM >>> I do this with menu items in our application, when you add a new item you can select its sort order and if it's inserted at 15, then a small SQL query simply sets everything greater than or equal to 15 to increment by one. UPDATE tblMenuItems SET sortorder=sortorder + 1 WHERE sortorder >= #val(form.sortorder)# Pretty simple method, but it works! On Thu, 2003-10-30 at 13:31, Sandy Clark wrote: > Does anyone know offhand what sorting algorithm Netflix uses to sort > their > queue? > > Specifically, when I resort the queue in Netflix, I might change an > item > from number 25 to 15 , which means that the item which was originally > 15 is > renumbered to 16, etc. > > I've got to implement the same thing (not for DVD's), but thought I > would > ask before re-inventing the wheel. > > Sandy > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Non-Stick Session Variables?
Is there a trick to keeping session variables alive when a Web page is called via and CFHTTP, i.e., from another Web site? The session variables stick when I called the Web page directly from a browser, but not via CFHTTP. Does this mean the session variables are relying on Cookies? Below is the CFAPPLICATION code. CLIENTMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT=#CreateTimeSpan(0, 2, 0, 0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0, 2, 0, 0)# > Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sorting Algorithm ala Netflix
I do this with menu items in our application, when you add a new item you can select its sort order and if it's inserted at 15, then a small SQL query simply sets everything greater than or equal to 15 to increment by one. UPDATE tblMenuItems SET sortorder=sortorder + 1 WHERE sortorder >= #val(form.sortorder)# Pretty simple method, but it works! On Thu, 2003-10-30 at 13:31, Sandy Clark wrote: > Does anyone know offhand what sorting algorithm Netflix uses to sort > their > queue? > > Specifically, when I resort the queue in Netflix, I might change an > item > from number 25 to 15 , which means that the item which was originally > 15 is > renumbered to 16, etc. > > I've got to implement the same thing (not for DVD's), but thought I > would > ask before re-inventing the wheel. > > Sandy > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX and variables available on error
Hey All, I'm adjusting an old site wide error handler tag (written for CF 5) and I'm seeing some differences in error messages in CFMX. So are there any new vars available on error in CFMX? My old tag just uses the cfcatch structure and some CGI vars. I noticed that in CFMX there is a new "Exceptions" output and that info is not making it to my tag. thoughts/comments? Thanks Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SES urls on CFMX 6.1
OK, then let's get right to the point. What stats package can handle fusebox urls? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 1:50 PM To: CF-Talk Subject: Re: SES urls on CFMX 6.1 On Thursday 30 Oct 2003 17:10 pm, Matt Robertson wrote: > Thomas wrote: > >> Does using SES make web stats work better? > > > >No. > > Yes. Some stats programs just can't handle parameters. I wouldn't call a 'stats' package with such a bug a stats package :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Directory tag
Check out CF_DirectoryTree or CF_DirectoryExplorer, available in the Developer's Exchange. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 brob wrote: > > Hey guys is there a coldfusion tag that displays the Directory of the > server, that looks like a CFTREE thingy. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sorting Algorithm ala Netflix
Does anyone know offhand what sorting algorithm Netflix uses to sort their queue? Specifically, when I resort the queue in Netflix, I might change an item from number 25 to 15 , which means that the item which was originally 15 is renumbered to 16, etc. I've got to implement the same thing (not for DVD's), but thought I would ask before re-inventing the wheel. Sandy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mapped drives on server not displaying...why?
Here's an Active Directory approach (and, actually, the non-AD approach is almost identical): Create a domain user, "ColdFusion." Add 'Domain\ColdFusion' user to your CF server's 'Administrators' group. Assign this user to the 'ColdFusion Application Server Service' service a la "Log On as:" and "This Account: [EMAIL PROTECTED]" There is no need to modify the other CF services (Executive & RDS). Restart. Now, you can assign granular permissions for your ColdFusion server as any other user or group throughout your Windows network. For example, add [EMAIL PROTECTED] to the target server's 'Users' or 'Guests' groups, as appropriate. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Dave Watts wrote: > > ? No...CF service is running with Administrator account. I used > ? a different account for the mapped drive letters. I doubt I > ? can mapped them using the administrator password on the other > ? server since its a IT box. Should I get them to create a > ? generic username to use for the drive letter mappings and > ? change the CF service to the new account/password? > > If you want the CF service to be able to use the drive mappings, > you'll have > to create them with the same account used to run the CF service. By > default, > the CF service runs as SYSTEM, which doesn't have any rights to > network > resources. The account that you do use will need to have the > appropriate > user rights and ACL permissions assigned to it, as well. Ideally, this > account should be significantly less privileged than SYSTEM or > Administrator. > > But again, if you're still trying to solve your previous problem of > having > your clients work with mapped drives, CF is probably not the best > solution > for that problem. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql difficulty
You can do this using aggregates and case statements (assuming your db can handle it... you didn't say what you were using) select checkno, total=count(*), -- I have no idea how you determine what is "unprocessed", so this is an made-up example unprocessed=sum(case when is_processed<>'Y' then 1 else 0 end), -- repeat for other counts from thetable group by checkno The idea is that you have a case statement that yields 1 or 0 depending on the particular state you want to count and use sum() to count them. Mark -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 12:42 PM To: CF-Talk Subject: sql difficulty Hi, I'm wondering if there is a difffernet way to do this. Basically I have a table that has lots of records. I need to show in a list multiple agregates on this table. It pretty much has to be live to reflect the current data. One of the fields is a checkno. This is main group. So everything groups on this. So I might have 10 with check no a, 20 with check no b and 30 with check no c. The list that the user sees would then have 3 entries. There is additinal information in the table that I need to agregate. I need counts on other fields in that group where the other field is this or that and sums on another field where that other field is that or this. So basically, it will look like this. checkno | total | unprocessed | success | failure | sum | preped | unprepped a10 72 1 65 3 4 B20 72 2 44 2 5 C1 72 3 28 4 3 So, should I simply run 5 agregate queries and mix the results into one query result set? Or is there another way? Thanks in advance DRE [Andre Turrettini] -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 8:23 AM To: CF-Talk Subject: UniData ODBC connectivity Hi, I've posted a similar question some time ago about UniData ODBC connectivity. This time, it's more specific. I'm new to UniData. I'd like to set up an ODBC connection to the UniData database hosted on an NT box on the network. I read some documentation. Is the following understanding correct? Two key pieces: 1) uci.conf file, an entry pointing to the train(training) database; 2) install Unidata ODBC driver, making the ODBC datasource setup matches that. UniData questions (not ODBC), after login to Unidata, a) how to find the current database, most likely default to production (Main), then, how to switch to Train database? b) how to find what accounts are available/associated with Train database? c) how to create an account for Train database? ODBC connection questions: when using VSG to map schema, one has to call UniData file/data to do table mapping, one file name is called IM (for Item Master), how to find all other file names? Of which, what would seem to be more important? Many thanks. Don Li _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF/Access/SQL query - solved
Might I suggest that instead of you try or if you like to be clearer len(trim(form.spacenumber)) GT 0>? The former would not stop a user entering an empty space, " ", while the later would. -Patti > Hi all, > > Thanks to everyone who helped out with my issue. After > incorporating practically all of the suggested changes > (except for the person whose email I accidentally > deleted before I had a chance to try your changes -- > my apologies, since you were nice enough to test your > solution for me) my query is now running. Here's the > edited code: > > > > > > > > > > > > datasource="CMISPersonnel"> > Select Personnel.FirstName, Personnel.MiddleInitial, > Personnel.LastName, Personnel.Zip, > Personnel.SpaceNumber, Vehicles.TagNumber, > Vehicles.DecalNumber, Vehicles.PermitNumber > from Personnel, Vehicles > where Personnel.PersonnelKey = Vehicles.PersonnelKey > > > and LastName like '%#form.LastName#%' > > > > and Zip = '#form.Zip#' > > > > and PermitNumber = '#form.PermitNumber#' > > > > and SpaceNumber = '#form.SpaceNumber#' > > > > and TagNumber = '#form.TagNumber#' > > > > and DODDecalNumber = '#form.DODDecalNumber#' > > order by LastName > > > > > >> -Original Message- >> From: Laura Schlee [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, October 29, 2003 11:15 AM >> To: CF-Talk >> Subject: CF/Access/SQL query >> Hi all, >> I'm having a problem with a query and I think it >> might >> be Access-related. Here's the text: >> >> datasource="CMISPersonnel"> >> Select FirstName, MiddleInitial, LastName, Zip, >> SpaceNumber, TagNumber, DecalNumber, PermitNumber >> from Personnel, Vehicles >> where Personnel.PersonnelKey = Vehicles.PersonnelKey >> >> >> and LastName like '%#form.LastNameSearch#%' >> >> >> >> and Zip = #form.ZipCodeSearch# >> >> >> >> and PermitNumber = #form.PermitNbrSearch# >> >> >> >> and SpaceNumber = #form.SpaceNbrSearch# >> >> >> >> and TagNumber = #form.TagSearch# >> >> >> >> and DecalNumber = #form.DecalSearch# >> >> order by LastName >> >> Here's the error message: >> Invalid use of '.', '!', or '()'. in query >> _expression_ >> 'Personnel.PersonnelKey = Vehicles.PersonnelKey '. > > > __ > Do you Yahoo!? > Exclusive Video Premiere - Britney Spears > http://launch.yahoo.com/promos/britneyspears/ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Striping URL (SOLVED)
Hey guys...
Thanks... I think I figured it out. I was trying to make it way to
complicated.
Using the code below does what I need.
Not sure if this is the best way but it works...
Thanks,
- Neal
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 11:40 AM
To: CF-Talk
Subject: RE: Striping URL
Way overcomplicated but it works and I've gotten lazy just plugging it
in as an include. There's gotta be an easier way, and Critter's
certainly looks like the ticket if you know the extension is 3 chars.
Anyone know a better way if you don't know the file extension length
(i.e. '.html')?
Left(Reverse(cgi.Script_Name),(FindOneOf("/",Reverse(cgi.Script_Name),1)
-1))>
Reverse(RemoveChars(variables.FileStrip,1,FindOneOf(".",variables.FileSt
rip,1)))>
--
Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.
--
An unbreakable toy is useful for breaking other toys.
- Helpful Hints
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re:Wierd CFC Path Problem - Question on CFC types
is the calling file in a folder above the CFC? i mean, which is the most similar dir struct for your files: 1) /root/caller.cfm /root/cfc/component.cfc 2) /root/html/caller.cfm /root/cfc/component.cfc - mga [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SES urls on CFMX 6.1
On Thursday 30 Oct 2003 17:10 pm, Matt Robertson wrote: > Thomas wrote: > >> Does using SES make web stats work better? > > > >No. > > Yes. Some stats programs just can't handle parameters. I wouldn't call a 'stats' package with such a bug a stats package :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Striping URL
Way overcomplicated but it works and I've gotten lazy just plugging it
in as an include. There's gotta be an easier way, and Critter's
certainly looks like the ticket if you know the extension is 3 chars.
Anyone know a better way if you don't know the file extension length
(i.e. '.html')?
Left(Reverse(cgi.Script_Name),(FindOneOf("/",Reverse(cgi.Script_Name),1)
-1))>
Reverse(RemoveChars(variables.FileStrip,1,FindOneOf(".",variables.FileSt
rip,1)))>
--
Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.
--
An unbreakable toy is useful for breaking other toys.
- Helpful Hints
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
sql difficulty
Hi, I'm wondering if there is a difffernet way to do this. Basically I have a table that has lots of records. I need to show in a list multiple agregates on this table. It pretty much has to be live to reflect the current data. One of the fields is a checkno. This is main group. So everything groups on this. So I might have 10 with check no a, 20 with check no b and 30 with check no c. The list that the user sees would then have 3 entries. There is additinal information in the table that I need to agregate. I need counts on other fields in that group where the other field is this or that and sums on another field where that other field is that or this. So basically, it will look like this. checkno | total | unprocessed | success | failure | sum | preped | unprepped a10 72 1 65 3 4 B20 72 2 44 2 5 C1 72 3 28 4 3 So, should I simply run 5 agregate queries and mix the results into one query result set? Or is there another way? Thanks in advance DRE [Andre Turrettini] -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 8:23 AM To: CF-Talk Subject: UniData ODBC connectivity Hi, I've posted a similar question some time ago about UniData ODBC connectivity. This time, it's more specific. I'm new to UniData. I'd like to set up an ODBC connection to the UniData database hosted on an NT box on the network. I read some documentation. Is the following understanding correct? Two key pieces: 1) uci.conf file, an entry pointing to the train(training) database; 2) install Unidata ODBC driver, making the ODBC datasource setup matches that. UniData questions (not ODBC), after login to Unidata, a) how to find the current database, most likely default to production (Main), then, how to switch to Train database? b) how to find what accounts are available/associated with Train database? c) how to create an account for Train database? ODBC connection questions: when using VSG to map schema, one has to call UniData file/data to do table mapping, one file name is called IM (for Item Master), how to find all other file names? Of which, what would seem to be more important? Many thanks. Don Li _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFTP - putfile problem (Solved and Thank You)
Just to let you know I solved the problem. I had a cfftp tag opening the connection and another one just doing the putfile. Once I included the connection (server, username and password) as attributes of the cfftp putfile tag, it worked immediately. Now I have a nice template that extracts BLOB files from a table to a directory, sends them via ftp to a remote server, and deletes them from the local directory. Thank you all for your tips. They have been gold! Pedro [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
