Re: Two CF 8.01 Clustering problems
We're hoping to set up some monitoring to work that out. If there's a verbose log level I can turn on at the server end it might help. I'll dig around for that. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/2 AJ Mercer <[EMAIL PROTECTED]> > for point 2there maybe some timeout setting on the network - if it cant see > it for a period of time it may think the cluster is dead. > > Is the newtowrk under load when it drops out? > > > On Thu, Oct 2, 2008 at 2:28 PM, James Holmes <[EMAIL PROTECTED]> > wrote: > > > We have two problems with clustering our CF 8.01 Multiserver (i.e. JRun) > > installs. > > > > 1) Session replication is broken. When we turn off an instance in a > cluster > > that has session replication and stickiness turned on, the next server > that > > gets the request throws a null pointer error when trying to run > > Application.cfc to establish the session. We've confirmed this by > clearing > > the session cookies on the browser; this enables the server to respond > > correctly as it can then set up its own session. Turning off session > > replication makes this go away. Any ideas what might be wrong with our > > setup > > to cause session replication to fail? > > > > 2) Half way through yesterday, our clustering started to fail. Up until > now > > all the servers have behaved properly, all joining the cluster correctly. > > Now, servers will drop out of the cluster for no reason, only to re-join > > later on. They intermittently drop in and out of the cluster. The > > most interesting part is that when they drop out, they do it in pairs. > Each > > pair of servers in the same datacentre stay clustered; they seem to lose > > the > > connection with the servers in the other datacentre (we have four > servers, > > two in each datacentre, all on the same VLAN subnet). I've tried adding > the > > servers as unicast peers rather than letting the multicast discovery find > > them, but it didn't help. If anyone has ideas about how best to monitor > the > > connections between the servers and get an idea of why the servers are > > dropping out of the cluster, please let me know. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Two CF 8.01 Clustering problems
for point 2there maybe some timeout setting on the network - if it cant see it for a period of time it may think the cluster is dead. Is the newtowrk under load when it drops out? On Thu, Oct 2, 2008 at 2:28 PM, James Holmes <[EMAIL PROTECTED]> wrote: > We have two problems with clustering our CF 8.01 Multiserver (i.e. JRun) > installs. > > 1) Session replication is broken. When we turn off an instance in a cluster > that has session replication and stickiness turned on, the next server that > gets the request throws a null pointer error when trying to run > Application.cfc to establish the session. We've confirmed this by clearing > the session cookies on the browser; this enables the server to respond > correctly as it can then set up its own session. Turning off session > replication makes this go away. Any ideas what might be wrong with our > setup > to cause session replication to fail? > > 2) Half way through yesterday, our clustering started to fail. Up until now > all the servers have behaved properly, all joining the cluster correctly. > Now, servers will drop out of the cluster for no reason, only to re-join > later on. They intermittently drop in and out of the cluster. The > most interesting part is that when they drop out, they do it in pairs. Each > pair of servers in the same datacentre stay clustered; they seem to lose > the > connection with the servers in the other datacentre (we have four servers, > two in each datacentre, all on the same VLAN subnet). I've tried adding the > servers as unicast peers rather than letting the multicast discovery find > them, but it didn't help. If anyone has ideas about how best to monitor the > connections between the servers and get an idea of why the servers are > dropping out of the cluster, please let me know. > > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com.au/blog/ > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Parse .html files with Coldfusion
The most important implication is that every request for an HTML file will now take a thread in CF for the life of the request. It really does depend on the demand on the box. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/2 Scott Stevens > If that's the case, is there a huge processing increase by running the > standard .html files through CF? > > There's no CF code in the .html files for most of the domains on the > server, but is it still a big processing hit to the server to run all those > files through CF? It would probably add about 1000 new files being sent to > CF. > > I'm guessing, of course, that the traffic to those pages a something to do > with it. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Two CF 8.01 Clustering problems
We have two problems with clustering our CF 8.01 Multiserver (i.e. JRun) installs. 1) Session replication is broken. When we turn off an instance in a cluster that has session replication and stickiness turned on, the next server that gets the request throws a null pointer error when trying to run Application.cfc to establish the session. We've confirmed this by clearing the session cookies on the browser; this enables the server to respond correctly as it can then set up its own session. Turning off session replication makes this go away. Any ideas what might be wrong with our setup to cause session replication to fail? 2) Half way through yesterday, our clustering started to fail. Up until now all the servers have behaved properly, all joining the cluster correctly. Now, servers will drop out of the cluster for no reason, only to re-join later on. They intermittently drop in and out of the cluster. The most interesting part is that when they drop out, they do it in pairs. Each pair of servers in the same datacentre stay clustered; they seem to lose the connection with the servers in the other datacentre (we have four servers, two in each datacentre, all on the same VLAN subnet). I've tried adding the servers as unicast peers rather than letting the multicast discovery find them, but it didn't help. If anyone has ideas about how best to monitor the connections between the servers and get an idea of why the servers are dropping out of the cluster, please let me know. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Parse .html files with Coldfusion
If that's the case, is there a huge processing increase by running the standard .html files through CF? There's no CF code in the .html files for most of the domains on the server, but is it still a big processing hit to the server to run all those files through CF? It would probably add about 1000 new files being sent to CF. I'm guessing, of course, that the traffic to those pages a something to do with it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Parse .html files with Coldfusion
> Any thoughts on how to get CF to NOT parse the .html or .htm files on all the > domains except 1? You can't, really, if you're running a single instance of CF. You'd have to run at least two instances, with web.xml configured in one instance to allow this but not in the other. You'd then have to map the one CF instance to the one Apache virtual server, and map the other instance to all the other Apache virtual servers. I'm not exactly sure how this would be set up within httpd.conf, but you'd basically need to point to different wsconfig directories. This kind of thing is fairly simple to set up with IIS, so I imagine it can be done for Apache. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Parse .html files with Coldfusion
After playing around with this I discovered that the entries in the web.xml file (#2 above) were case sensitive (probably a linux thing). I changed the "CFMServlet" to "CfmServlet" and the server started processing .html & .htm files asif they were .cfm files. The problem now is that it's doing this for all the domains on our server (100+), which I can only imagine increases the server load. I complete undid the edits to the domain's vhost.conf (#1 above), and undid the "-map" line in the apache_connector.sh file, and undid the edits to the httpd.conf file that Cutter suggested. So the only edit I made was to the web.xml file, and now CF parses the .html & .htm files. Any thoughts on how to get CF to NOT parse the .html or .htm files on all the domains except 1? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Parse .html files with Coldfusion
You can adjust your httpd.conf file. In the section for JRun, specify ..html as one of the file types to be parsed by your coldfusion instance (you'll see a line with .cfm, .cfc, .cfr, etc). Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Scott Stevens wrote: > I'm running CF 7.02 on a Linux server (Red Hat,Plesk 8, Apache) and would > like to have Coldfusion parse .html files as it would .cfm files. I have > root access to the server, and am hosting about 100 domains on the box. I > only want Coldfusion to process .html files as .cfm for one particular site. > > Through many searches I've found some answers, but can't quite get it to work. > > Here's what I've done. Can someone tell me if I missed something. > > > 1. Added the following to the specific domain's vhost.conf file: > > AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf .htm .html > > > 2. Added the following to the web.xml file in the cf_root/wwwroot/WEB-INF > directory > > > >CFMServlet >*.html > > >CFMServlet >*.html/* > > > >CFMServlet >*.htm > > >CFMServlet >*.htm/* > > > > 3. Added the following "-map" switch to the apache_connector.sh file in the > cf_root/bin/connectors folder. Below is the full apache_connector.sh code. > > #!/bin/sh > > # > # Configure the Apache connector. > # -dir should be the *directory* which contains httpd.conf > # -bin should be the path to the apache *executable* > # -script should be the path to the script which is used to > # start/stop apache > # > .../../runtime/bin/wsconfig \ > -server coldfusion \ > -ws apache \ > -dir /usr/local/apache2/conf \ > -bin /usr/local/apache2/bin/httpd \ > -script /usr/local/apache2/bin/apachectl \ > -coldfusion > -map ".htm,.html" > exit $# > > 4. Restarted httpd and coldfusion. > > When I try to access a .html file, it gives me a page with the title "JRun > Servlet Error", and body "404 null" > > I referenced the link below, which was for IIS, but I guess there's more to > it on linux. > > http://www.talkingtree.com/blog/index.cfm/2006/2/17/CF-Custom-File-Extensions > > Thanks for any help! > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unresponsive server
> We have a production CFMX server with approx 20 oracle datasources(all coming > from the same server, yes I know single point of failure). > > Anyways, whenever our DB server crashes here's what happens: > > 10/01 19:37:09 metrics Web threads (busy/total): 0/1 Sessions: 3848 Total > Memory=468992 Free=280550 > 10/01 19:38:09 metrics Web threads (busy/total): 0/3 Sessions: 3833 Total > Memory=468992 Free=254816 > 10/01 19:39:09 metrics Web threads (busy/total): 25/40 Sessions: 3827 Total > Memory=469824 Free=273703 > 10/01 19:40:09 metrics Web threads (busy/total): 25/100 Sessions: 3805 Total > Memory=469888 Free=240330 > 10/01 19:41:09 metrics Web threads (busy/total): 25/156 Sessions: 3785 Total > Memory=469312 Free=240488 > 10/01 19:42:09 metrics Web threads (busy/total): 25/219 Sessions: 3757 Total > Memory=469504 Free=247857 > 10/01 19:43:09 metrics Web threads (busy/total): 25/256 Sessions: 3737 Total > Memory=466624 Free=268661 > 10/01 19:44:09 metrics Web threads (busy/total): 25/256 Sessions: 3712 Total > Memory=466624 Free=246657 > > The CFMX server grinds to a halt and nothing works until the db comes back > up. Many of the cfm pages we have are static. > I am assuming CFMX is holding onto to all the datasource dependant threads > and not releasing them. What can I do to > help the server weather the outage better? (second db yes I know). Any > feedback/ideas would be appreciated. Disabling the "maintain connections" option for all Oracle datasources would probably prevent this problem. Of course, that will incur a performance penalty. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unresponsive server
We see the same thing. We're trying Oracle RAC. In the meantime we haven't found any way to ease the problem; the connections are probably coming from the pool so the login timeout won't help. You could run a page that programatically sets all the datasources to disabled. Of course you need to be able to make that page run while the other pages are blocking up the server; that's where something like FusionReactor might help. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/2 Alex DeMarco <[EMAIL PROTECTED]> > Hello All, > > We have a production CFMX server with approx 20 oracle datasources(all > coming from the same server, yes I know single point of failure). > > Anyways, whenever our DB server crashes here's what happens: > > 10/01 19:37:09 metrics Web threads (busy/total): 0/1 Sessions: 3848 Total > Memory=468992 Free=280550 > 10/01 19:38:09 metrics Web threads (busy/total): 0/3 Sessions: 3833 Total > Memory=468992 Free=254816 > 10/01 19:39:09 metrics Web threads (busy/total): 25/40 Sessions: 3827 Total > Memory=469824 Free=273703 > 10/01 19:40:09 metrics Web threads (busy/total): 25/100 Sessions: 3805 > Total Memory=469888 Free=240330 > 10/01 19:41:09 metrics Web threads (busy/total): 25/156 Sessions: 3785 > Total Memory=469312 Free=240488 > 10/01 19:42:09 metrics Web threads (busy/total): 25/219 Sessions: 3757 > Total Memory=469504 Free=247857 > 10/01 19:43:09 metrics Web threads (busy/total): 25/256 Sessions: 3737 > Total Memory=466624 Free=268661 > 10/01 19:44:09 metrics Web threads (busy/total): 25/256 Sessions: 3712 > Total Memory=466624 Free=246657 > > The CFMX server grinds to a halt and nothing works until the db comes back > up. Many of the cfm pages we have are static. I am assuming CFMX is holding > onto to all the datasource dependant threads and not releasing them. What > can I do to help the server weather the outage better? (second db yes I > know). Any feedback/ideas would be appreciated. > > - Alex > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Unresponsive server
Hello All, We have a production CFMX server with approx 20 oracle datasources(all coming from the same server, yes I know single point of failure). Anyways, whenever our DB server crashes here's what happens: 10/01 19:37:09 metrics Web threads (busy/total): 0/1 Sessions: 3848 Total Memory=468992 Free=280550 10/01 19:38:09 metrics Web threads (busy/total): 0/3 Sessions: 3833 Total Memory=468992 Free=254816 10/01 19:39:09 metrics Web threads (busy/total): 25/40 Sessions: 3827 Total Memory=469824 Free=273703 10/01 19:40:09 metrics Web threads (busy/total): 25/100 Sessions: 3805 Total Memory=469888 Free=240330 10/01 19:41:09 metrics Web threads (busy/total): 25/156 Sessions: 3785 Total Memory=469312 Free=240488 10/01 19:42:09 metrics Web threads (busy/total): 25/219 Sessions: 3757 Total Memory=469504 Free=247857 10/01 19:43:09 metrics Web threads (busy/total): 25/256 Sessions: 3737 Total Memory=466624 Free=268661 10/01 19:44:09 metrics Web threads (busy/total): 25/256 Sessions: 3712 Total Memory=466624 Free=246657 The CFMX server grinds to a halt and nothing works until the db comes back up. Many of the cfm pages we have are static. I am assuming CFMX is holding onto to all the datasource dependant threads and not releasing them. What can I do to help the server weather the outage better? (second db yes I know). Any feedback/ideas would be appreciated. - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL Scope and Form Scope
2008/10/2 Dave Watts <[EMAIL PROTECTED]> > > Up until know I thought that scoping variables with form. that you were > > guaranteed those variables were coming from a form post. > > This is one of those things that has varied from one version of CF to > another, if I recall correctly. > Yes, bits of this have changed from version to version. I remember back when you could inject a URL variable called SESSION.username, for example, and isDefined(SESSION.username) would return true; this is when I started using structKeyExists() exclusively. This has since been fixed for the session scope. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfcookie tempermental setting: Long Post
Hello, Following is as detailed a description as i can give as to my problem: Problem: I am making a sign in form that will allow my customers access to a private page populated with information specifically targeted toward them and their account info. Within this form I have a set of 3 cookies that are being set which remembers the users username, ID number, and the word "Confirmed" which, of course, Confirms that the user wants to be remembered. Now this all happens, at this point, whether the user wants to be remembered, or not (for testing purposes). This version of the form works just fine. The cookies all set, and the test information I want displayed after sign in comes up with no problem. I have it so that the welcome page just says "Welcome, you are logged in as #cookie.username# ID: #cookie.ID#." The issue that comes up is when I try to put a conditional statement within the cookie part of the template. When I surround the cookies with , that is when all goes down the drain. The form just refreshes itself. It will not display the welcome page. I changed the welcome page to say the same as I wrote above, but I write this as well: Welcome, you are logged in as #cookie.username# ID: #cookie.ID# Welcome, you are logged in as #session.Auth.username# ID: #session.Auth.ID# Unfortunately this does not show up. The form just resets itself and refreshes the sign in form. I have no idea what I'm doing wrong or what part of my code is wrong. Can someone see any obvious problems with this code that I'm overlooking? I've been staring at this code for a week and my eyes hurt. Any help would be very much appreciated. The full code is below. Thank you for reading this long email, and I'm sorry to have taken so much time explaining. Phil SELECT * FROM admin WHERE username = '#Form.UserLogin#' AND password = '#Form.password#' location.replace('index.cfm'); ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Parse .html files with Coldfusion
I'm running CF 7.02 on a Linux server (Red Hat,Plesk 8, Apache) and would like to have Coldfusion parse .html files as it would .cfm files. I have root access to the server, and am hosting about 100 domains on the box. I only want Coldfusion to process .html files as .cfm for one particular site. Through many searches I've found some answers, but can't quite get it to work. Here's what I've done. Can someone tell me if I missed something. 1. Added the following to the specific domain's vhost.conf file: AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf .htm .html 2. Added the following to the web.xml file in the cf_root/wwwroot/WEB-INF directory CFMServlet *.html CFMServlet *.html/* CFMServlet *.htm CFMServlet *.htm/* 3. Added the following "-map" switch to the apache_connector.sh file in the cf_root/bin/connectors folder. Below is the full apache_connector.sh code. #!/bin/sh # # Configure the Apache connector. # -dir should be the *directory* which contains httpd.conf # -bin should be the path to the apache *executable* # -script should be the path to the script which is used to # start/stop apache # .../../runtime/bin/wsconfig \ -server coldfusion \ -ws apache \ -dir /usr/local/apache2/conf \ -bin /usr/local/apache2/bin/httpd \ -script /usr/local/apache2/bin/apachectl \ -coldfusion -map ".htm,.html" exit $# 4. Restarted httpd and coldfusion. When I try to access a .html file, it gives me a page with the title "JRun Servlet Error", and body "404 null" I referenced the link below, which was for IIS, but I guess there's more to it on linux. http://www.talkingtree.com/blog/index.cfm/2006/2/17/CF-Custom-File-Extensions Thanks for any help! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL Scope and Form Scope
> Up until know I thought that scoping variables with form. that you were > guaranteed those variables were coming from a form post. This is one of those things that has varied from one version of CF to another, if I recall correctly. > So now my question is how do you guarantee that the variable came from > the form scope? > > is using form["firstname"] sufficient? Well, to be honest, I wouldn't even worry about this as a problem. You don't really need to care whether something came from the form scope, only that it contains an acceptable value. If someone's built an alternative interface that sends URL parameters named "form.somethingorother", that by itself is not a security vulnerability. > What about checking > > cgi.REQUEST_METHOD > > for post? Can that variable be spoofed? No, that variable will be accurate in all cases. You could also check for the existence of Form.fieldnames. But again, it's not a big concern in my opinion. It's easy enough for someone to build a mechanism that actually posts the data, and you can't really do much about that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Scope and Form Scope
> So now my question is how do you guarantee that the variable came from > the form scope? -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Scope and Form Scope
Up until know I thought that scoping variables with form. that you were guaranteed those variables were coming from a form post. So now my question is how do you guarantee that the variable came from the form scope? is using form["firstname"] sufficient? What about checking cgi.REQUEST_METHOD for post? Can that variable be spoofed? Thanks! Randy Dave Watts wrote: >> I was surprised today that the following code actually displayed a value: >> >> http://www.cftools.test/formtest.cfm?form.test=test >> >> Here is the code: >> >> >> #form.test# >> >> >> >> Why does this work? Is it considered a bug? >> >> I did find that if I referenced the form variable like this >> #form["test"]#, it doesn't work as above. > > You're creating a variable named URL.form.test, and CF 8 is relaxed > enough to not give you a hard time about it. However, there's no form > scope there really, just the URL scope, which is why the second > reference doesn't work. My guess is that if you referenced > URL.form["test"], it would work fine. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RegEx (REMatch) experts?
I think the important part is everything between the pound signs. So your RegEx is (?:"([^"]+)")|([^ ]+) just use this with your favorite function Just use the ReFindNoCase(), or ReFind() functions with the returnsubexpressions attribute set to true. then it's a matter of using other functions (mid, left etc) to grab the values and slam them into an array. Maybe someone will be more elegant, i'm do busy crashing servers to work it all out :) jonese http://www.jonese.us http://twitter.com/jonese On Wed, Oct 1, 2008 at 5:36 PM, Charlie Griefer <[EMAIL PROTECTED]> wrote: > On Wed, Oct 1, 2008 at 2:09 PM, Developer MediaDoc > <[EMAIL PROTECTED]>wrote: > >> Hi All, >> >> Have NOT ventured into regular expressions much at all. Now I have the need >> for one, and wonder if anyone has one made for this scenario. >> >> Search engine, want user to be able to enter multiple words, also phrases. >> Want my SQL to loop over the phrases and words with an AND... (the SQL I can >> handle!). >> >> For example, user types in "Healthy Eating" kids schools "Ontario Canada" >> >> ReMatch would produce an array of >> Healthy Eating >> kids >> schools >> Ontario Canada >> >> my SQL search would loop over these 4 words/phrases. >> >> I've found a PHP regex that does this exact thing.. but the syntax must be >> different in CF and PHP for the regex part. >> >> preg_match_all('#(?:"([^"]+)")|([^ ]+)#', trim($keywords), $match_words); >> >> Anyone have a CF equivalent? >> > > listToArray(keywords, ' ') :) > > -- > I have failed as much as I have succeeded. But I love my life. I love my > wife. And I wish you my kind of success. > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Scope and Form Scope
> I was surprised today that the following code actually displayed a value: > > http://www.cftools.test/formtest.cfm?form.test=test > > Here is the code: > > > #form.test# > > > > Why does this work? Is it considered a bug? > > I did find that if I referenced the form variable like this > #form["test"]#, it doesn't work as above. You're creating a variable named URL.form.test, and CF 8 is relaxed enough to not give you a hard time about it. However, there's no form scope there really, just the URL scope, which is why the second reference doesn't work. My guess is that if you referenced URL.form["test"], it would work fine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
URL Scope and Form Scope
Hello, I was surprised today that the following code actually displayed a value: http://www.cftools.test/formtest.cfm?form.test=test Here is the code: #form.test# Why does this work? Is it considered a bug? I did find that if I referenced the form variable like this #form["test"]#, it doesn't work as above. -Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RegEx (REMatch) experts?
On Wed, Oct 1, 2008 at 2:36 PM, Charlie Griefer <[EMAIL PROTECTED]>wrote: > On Wed, Oct 1, 2008 at 2:09 PM, Developer MediaDoc < > [EMAIL PROTECTED]> wrote: > >> Hi All, >> >> Have NOT ventured into regular expressions much at all. Now I have the >> need for one, and wonder if anyone has one made for this scenario. >> >> Search engine, want user to be able to enter multiple words, also phrases. >> Want my SQL to loop over the phrases and words with an AND... (the SQL I can >> handle!). >> >> For example, user types in "Healthy Eating" kids schools "Ontario Canada" >> >> ReMatch would produce an array of >> Healthy Eating >> kids >> schools >> Ontario Canada >> >> my SQL search would loop over these 4 words/phrases. >> >> I've found a PHP regex that does this exact thing.. but the syntax must be >> different in CF and PHP for the regex part. >> >> preg_match_all('#(?:"([^"]+)")|([^ ]+)#', trim($keywords), $match_words); >> >> Anyone have a CF equivalent? >> > > listToArray(keywords, ' ') :) > ah crap i oughtta read the question better, eh? that won't work with the quoted phrases in the string. maybe it'll kinda give a jumpstart at least :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RegEx (REMatch) experts?
On Wed, Oct 1, 2008 at 2:09 PM, Developer MediaDoc <[EMAIL PROTECTED]>wrote: > Hi All, > > Have NOT ventured into regular expressions much at all. Now I have the need > for one, and wonder if anyone has one made for this scenario. > > Search engine, want user to be able to enter multiple words, also phrases. > Want my SQL to loop over the phrases and words with an AND... (the SQL I can > handle!). > > For example, user types in "Healthy Eating" kids schools "Ontario Canada" > > ReMatch would produce an array of > Healthy Eating > kids > schools > Ontario Canada > > my SQL search would loop over these 4 words/phrases. > > I've found a PHP regex that does this exact thing.. but the syntax must be > different in CF and PHP for the regex part. > > preg_match_all('#(?:"([^"]+)")|([^ ]+)#', trim($keywords), $match_words); > > Anyone have a CF equivalent? > listToArray(keywords, ' ') :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: hoping someone is up!
On Wed, Oct 1, 2008 at 10:14 AM, Torrent Girl wrote: > Anyone, soomeone, help please It's not as fun as one big solution, but you could break it up into smaller chunks, and put those chunks together. Sometimes that's fastest, even if it's not the most efficient. Sorry no instant "ah ha!" when looking at the query. :-/ =] -- Hence the end of the world should be awaited with all longing by all believers. William Ames ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Consultant as a Java Consultant?
On Wed, Oct 1, 2008 at 8:07 AM, Adam Haskell wrote: > On Tue, Sep 30, 2008 at 7:00 PM, denstar wrote: > >> >> Well, I guess my question to you would be, what is a "java app" to you? >> >> How does JSP, Tapestry, Faces, Groovy, etc. fit into your picture there? >> > > JSP and Faces are both part of the Java spec so its java (JSF 2.0 I > suppose). Tapestry is a framework and does not really do code generation as > compared to something like CFML. You'll note that I suggested selling CFML > as a Java framework earlier. Groovy is a completely different story and much > closer to CFML except that it needs no runtime nor the servlet container to > work. It really does compile down to bytecode and run. CFML on the other > hand compiles down to bytecode but can not exist or function on its own. All > CFML code requires a CFML runtime engine to actually provide functionality > (unless Railo is doing something different I have not looked at 3.x > extensively I figure I'll just wate for the source). Groovy, or even pure Java, don't equal JEE, as such. See, I think JEE doesn't really mean much. More marketing speak than anything. Seam is a JEE 5 framework, and it fits the "spec test", along the lines of Tapestry, but from a support/coding perspective, there is a difference between Seam and Tapestry. >> I bet there are JSP, etc., "powered" apps that tout themselves as >> being "JEE", neh? Although it's all sorta the same, there's a world >> of difference, from a "can I jump into this thing's source?" >> perspective. >> > > Well they are JEE apps if they are JSP, it is part of the spec. I don't think saying something is JEE "compatible" or whatever really says much, to a Source-erer. Struts and JSF, for example. Both could fit your definition of a JEE app, which still leaves you not knowing some vital information, from a coding perspective. What about using Spring and Hibernate, which might be seen as violating the ee specs? >> I get your point though, and I would not be touting my CF-based JEE >> app as having "pure" Java sources. I don't think that's exactly what >> we were talking about tho, neh? :-) >> > > Sort of it. The original comment was give them a war and say it is a JEE > app, to which I think there are implications there to most people. The > implication (right or wrong) being JEE == Java [source]. I wouldn't infer very much, personally, from someone saying their app met the JEE specs, other than the idea that maybe I could get the thing to run in a JEE container of some sort. There are EE apps that don't exactly run in "any" JEE compliant container, neh? :-) And still, if you're coming from a "use the source" perspective, there are worlds and worlds of "java source" that, while all 100% pure java, would still require an investment in time to be modify. Sometimes significant amounts of time. Think of a CF dev with no experience with X framework. Sure, it's all "pure" CF, but, from a practical perspective, it's quite different. You couldn't toss a CFer with no experience at a framework driven app and expect them to instantly be able to grasp what's going on. Am I being misleading by touting my application as a "ColdFusion application", in those instances? I think you'd say no, but you'd probably want to know, if you're buying the source to extend and maintain yourself, right? JEE is a spec, it's not actually saying much about source code, per se. More like requirements to be met, or some such, right? If you were at all concerned with being able to extend or customize some EE app yourself, you would want to know more than "is it JEE?", which we've covered. > If a company finds they are given CFML and not the > "standard" JEE app (which is rapidly degrading away as a standard) would > they come back? Heh, you nailed it right there. What does JEE *really* mean? I posit that unless they're paying for the source itself, it's a moot point. If they're paying for a solution, period, and you provide that solution, then it's gravy, as far as I can tell. And that seems to be the way it works, more than the way you posit, where they are concerned about the underlying technology driving the solution. Most people just want something that will do what they need it to do, and that's what they pay you for. All that said, I'm a source monger myself, and pay attention to that "long tail", so I always investigate *wince* solutions *wince* before we buy them (when I know we're buying them). Not that it seems to make much of a difference, as most people just care about the short term (if that, even), apparently. Freaking pointy heads. :-) -- Hearing the word is the devout receiving of the will of God. William Ames ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-t
RegEx (REMatch) experts?
Hi All, Have NOT ventured into regular expressions much at all. Now I have the need for one, and wonder if anyone has one made for this scenario. Search engine, want user to be able to enter multiple words, also phrases. Want my SQL to loop over the phrases and words with an AND... (the SQL I can handle!). For example, user types in "Healthy Eating" kids schools "Ontario Canada" ReMatch would produce an array of Healthy Eating kids schools Ontario Canada my SQL search would loop over these 4 words/phrases. I've found a PHP regex that does this exact thing.. but the syntax must be different in CF and PHP for the regex part. preg_match_all('#(?:"([^"]+)")|([^ ]+)#', trim($keywords), $match_words); Anyone have a CF equivalent? Thanks a bunch, Matts ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem editing task schedule
Did you ever consider giving open-source answers? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 4:30 PM To: cf-talk Subject: Re: Problem editing task schedule > Too late, it's already on BitTorrent! :O. You are in violation of DMCA. My lawyers will contact you shortly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem editing task schedule
> You are in violation of DMCA. My lawyers will contact you shortly. Don't forget to send a notice to Michael also to remove it from the archive before Google gets it into their cache . -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem editing task schedule
> Too late, it's already on BitTorrent! :O. You are in violation of DMCA. My lawyers will contact you shortly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form Challenge?
>>When processing this form I need to check for the existence of any of the check boxes. Yeah, this is really a design problem in HTML, the name of an unchecked checkbox is not passed by the browser in the HTTP protocol. IMHO some default value would pretty useful, ie: Personnaly, I've developped my own workaround this way: 1. every form calls a function onSubmit that creates a list (defaultList) of all checkbox and select INPUTs in a hidden field. Note that it is done by Javascript, but the hidden field could be generated by CF as well. 2. each action template includes a template that verifies every item in that defaultList and set its value to 0 if the item is not found in the form scope. Pretty simple (if you always use 0 as default value) : ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem editing task schedule
Too late, it's already on BitTorrent! :O. -Original Message- From: Dave Watts Sent: 01 October 2008 18:24 To: cf-talk Subject: Re: Problem editing task schedule > Hi Dave, >Ach! Tried to send you 65 cents, but apparently my Paypal > Account has been suspended... Then I must insist you return the unpaid answer at once and forget you ever read it, you welcher. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem editing task schedule
> Hi Dave, >Ach! Tried to send you 65 cents, but apparently my Paypal > Account has been suspended... Then I must insist you return the unpaid answer at once and forget you ever read it, you welcher. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem editing task schedule
Hi Dave, Ach! Tried to send you 65 cents, but apparently my Paypal Account has been suspended... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 9:21 AM To: cf-talk Subject: Re: Problem editing task schedule > CF5.0 Problem for all you old guys out there (actually, a problem for > me, an OPPORTUNITY for you): Assuming your web server is listening on TCP/80, you can just go ahead and put in 80. Now, please send 65 cents to the below address ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing out the query cache
annn it's fixed. It so wasn't a caching issue. I dumped the query and it was right... just me being stupid and trying to DateFormat a four digit numeric value. cfdump is my friend.. Thanks to all for your help... sas Scott Stewart wrote: > Hey all, > > Is there a way to force a CF Server to clear it's query cache? > > thanks > sas > > -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument and eps graphics
I looked at other server-side PDF creation tools and almost none of them support vector graphics, even though vector graphics are recommended to keep file sizes down and they make for better looking logos. The latest version of iText doesn't support EPS, so unless iText is upgraded with this support I doubt that this feature will be in CF9. Might as well make the feature request: http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform -Mike Chabot On Wed, Oct 1, 2008 at 11:20 AM, Matthew VanderMeer <[EMAIL PROTECTED]> wrote: > Thanks for the replies, I didn't figure I would be able to do this at this > time. Maybe a future release of CF will inlucde this type of feature. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing out the query cache
I'll have to check on that but... it should be... Dave Watts wrote: >> It's a plain ol' vanilla query >> >> >>select cycle_id, >>... >>from cycle >>left joinweek on cycle.id = week.cycle_id >>left joinstudy onweek.id =study.week_id >>left joinperson onstudy.person_id = person.id >>where(study.id = '#url.id#') >> >> >> >> >> If I run this in SQL server Enterprise Manager I get a fiscal year = 2009 >> If it's run in a CF Template fiscal year comes back as null/1905 >> > > Are you sure you're passing the same value for URL.id in both places? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hoping someone is up!
It sounds like you are going to need to look at your join syntax. Since you are join your users to courses you are going to get 9 records for that one user. Then when you sum those up you are going to get nine!. But I am unclear on what to do about it. One would need to know a lot more your data design and requirements. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: remote proxy object security
thanks for your help, and thanks for rays link on ajax security we will have to read around this some more. thanks again richard >Richard, > >We recently implemented a few webservices for our parent company. When >doing these I took a multi-tier approach: > >1) folder of service requires authentication (web server) >2) Application in folder required the request be made over SSL >3) Application took authentication credentials from server auth, and >also verified against: > a) List of authorized users > b) DB check of authentication to system >This applied a role to the authenticated user, for which certain >services required specific roles for access as well. > >This is how we've handled this particular access. A lot of the data >being returned from the service is also encrypted, providing another >layer of security. > >Using Ajax for these services, you may also want to review this article >from Ray Camden, >http://www.coldfusionjedi.com/index.cfm/2007/7/31/ColdFusion-8-Ajax-Security-Features. > >Steve "Cutter" Blades >Adobe Certified Professional >Advanced Macromedia ColdFusion MX 7 Developer >_ >http://blog.cutterscrossing.com > >Richard White wrote: >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: hoping someone is up!
Anyone, soomeone, help please >hello all > >I tried my hardest to figure this one out by myself, but here goes. > >I have a query that returns sums of a few columns. I need to count the number >of >people with certain occupations and count the number of classes they took by a >certain course ID. > >The problem is there are only 4 people. 1 of the took 9 courses, the other 3 >too >none. > >Because of the 9 courses, the query is showing 9 teachers versus 4. > >I know that the problem is I need to somehow not included the course id or I >am >grouping the wrong way. Grouping by courseID won't work as there are 9 >different >courses id's for the one user. > >here is my query: any suggests are appreciated as i have been working on this >all >night and is has to be done by 8 am. > > > >SELECT >p.Program_name, >p.program_ID, >p.Program_City, >SUM(CASE p.occupationID WHEN '4' THEN 1 ELSE 0 END) AS teacher, >SUM(CASE p.occupationID WHEN '1003' THEN 1 ELSE 0 END) AS leadTeacher, >SUM(CASE p.participant_ladder_level WHEN 1 THEN 1 ELSE 0 END) AS level1, >SUM(CASE p.participant_ladder_level WHEN 2 THEN 1 ELSE 0 END) AS level2, >SUM(CASE p.participant_ladder_level WHEN 3 THEN 1 ELSE 0 END) AS level3, >SUM(CASE p.participant_ladder_level WHEN 4 THEN 1 ELSE 0 END) AS level4, >SUM(CASE p.participant_ladder_level WHEN 5 THEN 1 ELSE 0 END) AS level5, >SUM(CASE p.participant_ladder_level WHEN 6 THEN 1 ELSE 0 END) AS level6, >SUM(CASE p.participant_ladder_level WHEN 7 THEN 1 ELSE 0 END) AS level7, >SUM(CASE p.participant_ladder_level WHEN 8 THEN 1 ELSE 0 END) AS level8, >SUM(CASE p.participant_ladder_level WHEN 9 THEN 1 ELSE 0 END) AS level9, >SUM(CASE p.participant_ladder_level WHEN 10 THEN 1 ELSE 0 END)AS level10, >SUM(CASE p.participant_ladder_level WHEN 11 THEN 1 ELSE 0 END) AS level11, >SUM(CASE p.participant_ladder_level WHEN 12 THEN 1 ELSE 0 END) AS level12, >SUM(CASE p.participant_ladder_level WHEN 13 THEN 1 ELSE 0 END) AS level13, >SUM(CASE p.participant_ladder_level WHEN 14 THEN 1 ELSE 0 END) AS level14, >SUM(CASE p.participant_ladder_level WHEN 15 THEN 1 ELSE 0 END) AS level15, >SUM(CASE WHEN courseTypeID IN ('18', '19') AND participant_ladder_level IN >('11', >'12') THEN 1 ELSE 0 END) AS teacherCertificate1, >SUM(CASE WHEN courseTypeID IN ('18', '19') AND participant_ladder_level IN >('13', >'14', '15') THEN 1 ELSE 0 END) AS teacherCertificate2 >FROM dbo.REPORT_PROGRAMS_WITH_PARTICIPANTS p >LEFT OUTER JOIN dbo.ccac_user_courses c ON p.participant_ID = c.userID >LEFT OUTER JOIN dbo.ccac_courses cc ON c.courseID = cc.courseID >WHERE (p.Program_sde_funded = 1) >AND (p.Occupation_in_program IN ('Lead teacher', 'Classroom Teacher')) >AND (p.program_ID = 194) >GROUP BY p.program_ID, p.Program_name, p.Program_City >ORDER BY p.Program_name, p.program_ID ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form Challenge?
Whoops. Sorry I mistyped. I *DO* (thank you for no starbucks this AM) know the name of the check boxes and they are generated from a DB. So yes, I will have the names. Adrian Lynch Your post just came in the gmail as I was typing this.. I will try that approach. Thanks all On Wed, Oct 1, 2008 at 11:49 AM, Randy <[EMAIL PROTECTED]> wrote: > Kind of hard to check for a form value if you are unsure the name of the > element. > > Pure Curosity: Why would you not know the name of the field? Is it pulled > from a database when the form page is created? > > > > On Wed, Oct 1, 2008 at 11:41 AM, Mallory Woods <[EMAIL PROTECTED] > >wrote: > > > What is the best way of coding this: I have a form that currently has 4 > > check boxes. > > When processing this form I need to check for the existence of any of the > > check boxes. > > > > Now, there are 4 values now but there could be more in the future. > > > > I tried to loop over the form variable with "isdefined" by I ran into > > problems as I won't always know the > > name of the check box to check. > > > > Any suggestions on how to approach this problem? > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Form Challenge?
If the names are from the DB you can either get them again on the action page or pass them to the action page from the form. Then in a query or list loop: IsDefined("FORM.#yourQuery.fieldName#") or IsDefined("FORM.#aListIndex#") Adrian -Original Message- From: Randy [mailto:[EMAIL PROTECTED] Sent: 01 October 2008 16:50 To: cf-talk Subject: Re: Form Challenge? Kind of hard to check for a form value if you are unsure the name of the element. Pure Curosity: Why would you not know the name of the field? Is it pulled from a database when the form page is created? On Wed, Oct 1, 2008 at 11:41 AM, Mallory Woods <[EMAIL PROTECTED]>wrote: > What is the best way of coding this: I have a form that currently has 4 > check boxes. > When processing this form I need to check for the existence of any of the > check boxes. > > Now, there are 4 values now but there could be more in the future. > > I tried to loop over the form variable with "isdefined" by I ran into > problems as I won't always know the > name of the check box to check. > > Any suggestions on how to approach this problem? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Form Challenge?
You have to have some knowledge of the checkbox names. Are they in any way similar? If so, you can check in a loop: Or if you don't want to limit the loop: Adrian -Original Message- From: Mallory Woods [mailto:[EMAIL PROTECTED] Sent: 01 October 2008 16:41 To: cf-talk Subject: Form Challenge? What is the best way of coding this: I have a form that currently has 4 check boxes. When processing this form I need to check for the existence of any of the check boxes. Now, there are 4 values now but there could be more in the future. I tried to loop over the form variable with "isdefined" by I ran into problems as I won't always know the name of the check box to check. Any suggestions on how to approach this problem? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form Challenge?
Kind of hard to check for a form value if you are unsure the name of the element. Pure Curosity: Why would you not know the name of the field? Is it pulled from a database when the form page is created? On Wed, Oct 1, 2008 at 11:41 AM, Mallory Woods <[EMAIL PROTECTED]>wrote: > What is the best way of coding this: I have a form that currently has 4 > check boxes. > When processing this form I need to check for the existence of any of the > check boxes. > > Now, there are 4 values now but there could be more in the future. > > I tried to loop over the form variable with "isdefined" by I ran into > problems as I won't always know the > name of the check box to check. > > Any suggestions on how to approach this problem? > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Clearing out the query cache
> It's a plain ol' vanilla query > > >select cycle_id, >... >from cycle >left joinweek on cycle.id = week.cycle_id >left joinstudy onweek.id =study.week_id >left joinperson onstudy.person_id = person.id >where(study.id = '#url.id#') > > > > > If I run this in SQL server Enterprise Manager I get a fiscal year = 2009 > If it's run in a CF Template fiscal year comes back as null/1905 Are you sure you're passing the same value for URL.id in both places? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Clearing out the query cache
Is URL.id correct? Are you sure your hitting the right DB? Without you asking CF to cache anything it won't. -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 01 October 2008 16:39 To: cf-talk Subject: Re: Clearing out the query cache It's a plain ol' vanilla query select cycle_id, cycle.cycle_month, cycle.cycle_year, week_id, week.start_date, week.fiscal_year, study.id, study.pre_pretransplant, study.pre_pediatric_clinic, study.notes, study.pre_ahec, study.pre_univ, study.pre_absent, study.checked_in, study.contract_number, study.last_updated, person.fname, person.mname, person.lname, person.full_time, person.pid, person.physician_number, person.dept_no, person.study_group_id, person.dept from cycle left joinweek on cycle.id = week.cycle_id left joinstudy onweek.id =study.week_id left joinperson onstudy.person_id = person.id where(study.id = '#url.id#') If I run this in SQL server Enterprise Manager I get a fiscal year = 2009 If it's run in a CF Template fiscal year comes back as null/1905 Dave Watts wrote: >> unfortunately their not, it's the server's query cache that has them, >> is it possible to force them to not cache in the first place (without >> setting the query cache setting in the CF server to 0) >> > > Are you saying they're cached within the Server scope, and you > reference them as Server.yourqueryname? > > If so, you can manage them just like you would any other variable. You > can delete them using StructDelete, or overwrite them. > > The query cache setting in the CF Administrator affects queries cached > with CACHEDWITHIN/CACHEDAFTER. > > CF doesn't cache queries automatically. You must either use > CACHEDWITHIN/CACHEDAFTER or place your queries in Session, Application > or Server variables. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form Challenge?
When you add a new checkbox, add logic for checking it? Mallory Woods wrote: > What is the best way of coding this: I have a form that currently has 4 > check boxes. > When processing this form I need to check for the existence of any of the > check boxes. > > Now, there are 4 values now but there could be more in the future. > > I tried to loop over the form variable with "isdefined" by I ran into > problems as I won't always know the > name of the check box to check. > > Any suggestions on how to approach this problem? > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form Challenge?
What is the best way of coding this: I have a form that currently has 4 check boxes. When processing this form I need to check for the existence of any of the check boxes. Now, there are 4 values now but there could be more in the future. I tried to loop over the form variable with "isdefined" by I ran into problems as I won't always know the name of the check box to check. Any suggestions on how to approach this problem? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:31 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Clearing out the query cache
It's a plain ol' vanilla query select cycle_id, cycle.cycle_month, cycle.cycle_year, week_id, week.start_date, week.fiscal_year, study.id, study.pre_pretransplant, study.pre_pediatric_clinic, study.notes, study.pre_ahec, study.pre_univ, study.pre_absent, study.checked_in, study.contract_number, study.last_updated, person.fname, person.mname, person.lname, person.full_time, person.pid, person.physician_number, person.dept_no, person.study_group_id, person.dept from cycle left joinweek on cycle.id = week.cycle_id left joinstudy onweek.id =study.week_id left joinperson onstudy.person_id = person.id where(study.id = '#url.id#') If I run this in SQL server Enterprise Manager I get a fiscal year = 2009 If it's run in a CF Template fiscal year comes back as null/1905 Dave Watts wrote: >> unfortunately their not, it's the server's query cache that has them, >> is it possible to force them to not cache in the first place (without >> setting the query cache setting in the CF server to 0) >> > > Are you saying they're cached within the Server scope, and you > reference them as Server.yourqueryname? > > If so, you can manage them just like you would any other variable. You > can delete them using StructDelete, or overwrite them. > > The query cache setting in the CF Administrator affects queries cached > with CACHEDWITHIN/CACHEDAFTER. > > CF doesn't cache queries automatically. You must either use > CACHEDWITHIN/CACHEDAFTER or place your queries in Session, Application > or Server variables. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing out the query cache
> He might also mean the execution plan. Maybe, but CF doesn't cache the execution plan. The database does that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Clearing out the query cache
He might also mean the execution plan. Adrian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 01 October 2008 16:24 To: cf-talk Subject: Re: Clearing out the query cache > unfortunately their not, it's the server's query cache that has them, > is it possible to force them to not cache in the first place (without > setting the query cache setting in the CF server to 0) Are you saying they're cached within the Server scope, and you reference them as Server.yourqueryname? If so, you can manage them just like you would any other variable. You can delete them using StructDelete, or overwrite them. The query cache setting in the CF Administrator affects queries cached with CACHEDWITHIN/CACHEDAFTER. CF doesn't cache queries automatically. You must either use CACHEDWITHIN/CACHEDAFTER or place your queries in Session, Application or Server variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing out the query cache
> unfortunately their not, it's the server's query cache that has them, > is it possible to force them to not cache in the first place (without > setting the query cache setting in the CF server to 0) Are you saying they're cached within the Server scope, and you reference them as Server.yourqueryname? If so, you can manage them just like you would any other variable. You can delete them using StructDelete, or overwrite them. The query cache setting in the CF Administrator affects queries cached with CACHEDWITHIN/CACHEDAFTER. CF doesn't cache queries automatically. You must either use CACHEDWITHIN/CACHEDAFTER or place your queries in Session, Application or Server variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfdocument and eps graphics
Thanks for the replies, I didn't figure I would be able to do this at this time. Maybe a future release of CF will inlucde this type of feature. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing out the query cache
unfortunately their not, it's the server's query cache that has them, is it possible to force them to not cache in the first place (without setting the query cache setting in the CF server to 0) thanks sas Dave Watts wrote: >> Is there a way to force a CF Server to clear it's query cache? >> > > If they're cached with CACHEDWITHIN/CACHEDAFTER, use ACTION="CLEAR">. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFdocument and CSS: page-break-inside
Has anyone been able to use the css property "page-break-inside:avoid" with in a CFDOCUMENT tag. I am using CF8 and I am dynamically generating a PDF report with a variety of sections. One section contains user modifiable recomendations that can be as short as one line and each recomendations has a title. I would like to avoid a page break between the title and the recomendation. Any advice would be appreciated? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing out the query cache
> Is there a way to force a CF Server to clear it's query cache? If they're cached with CACHEDWITHIN/CACHEDAFTER, use . Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Clearing out the query cache
Hey all, Is there a way to force a CF Server to clear it's query cache? thanks sas -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting this task to run
> I would prefer to get this running directly from CF, simply because it's > less complicated... I'm not sure what you mean by this. Scheduled tasks by default run as SYSTEM. They're never going to be run "directly from CF" because CF isn't the scheduler service. > When I try to add /u *localUserName* /p *password* I get this: > ERROR: Invalid syntax. Cannot specify user name without specifying > system name. Are you adding the name as "domain\user" or "localmachinename\user"? > So... when I add /s //*machineName* I get this: > ERROR: C:\WINDOWS\system32\kernel32.dll I think it's just /s machinename, without any slashes. If you did add slashes, Windows uses backslashes for UNC notation, not forward slashes. But again, I don't think they're needed at all here. I'll qualify all this by saying I haven't used schtasks in a long time. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to Invoke Simple .Net Web Service
> My bad, again :[ , it's the Temp method, the one without any parameters. OK, that accepts an empty document/literal value. I suspect you might have to pass in an empty argument. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Consultant as a Java Consultant?
On Tue, Sep 30, 2008 at 7:00 PM, denstar <[EMAIL PROTECTED]> wrote: > > Well, I guess my question to you would be, what is a "java app" to you? > > How does JSP, Tapestry, Faces, Groovy, etc. fit into your picture there? > JSP and Faces are both part of the Java spec so its java (JSF 2.0 I suppose). Tapestry is a framework and does not really do code generation as compared to something like CFML. You'll note that I suggested selling CFML as a Java framework earlier. Groovy is a completely different story and much closer to CFML except that it needs no runtime nor the servlet container to work. It really does compile down to bytecode and run. CFML on the other hand compiles down to bytecode but can not exist or function on its own. All CFML code requires a CFML runtime engine to actually provide functionality (unless Railo is doing something different I have not looked at 3.x extensively I figure I'll just wate for the source). Very general! Which is why, if you care about The Source, you're > going to be asking a lot more than "is it Java", right? > > I bet there are JSP, etc., "powered" apps that tout themselves as > being "JEE", neh? Although it's all sorta the same, there's a world > of difference, from a "can I jump into this thing's source?" > perspective. > Well they are JEE apps if they are JSP, it is part of the spec. > I make it clear at the outset that we're using a whole slew of various > technologies, and that it's all open source, so I provide the code, as > well, but I'm not selling code, I'm providing a service. > Right and that to me makes perfect sense! > I get your point though, and I would not be touting my CF-based JEE > app as having "pure" Java sources. I don't think that's exactly what > we were talking about tho, neh? :-) > Sort of it. The original comment was give them a war and say it is a JEE app, to which I think there are implications there to most people. The implication (right or wrong) being JEE == Java [source]. Again if it is a product and thats that, no extnetion points, then yeah who cares. But if there is any extensibility or source code investment calling it a JEE app is sort of underhanded due to my stance on what that implies. To your earlier question yes I'd like to think a company would be smart enough ti interigate further when purchasing an app + source. Ultimately it's the company that has to support the source so they should damn well be investigating it further that sort of where my original question of how much repeat business do you get comes from. If a company finds they are given CFML and not the "standard" JEE app (which is rapidly degrading away as a standard) would they come back? Adam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem editing task schedule
> CF5.0 Problem for all you old guys out there (actually, a problem for > me, an OPPORTUNITY for you): How is this an opportunity? Should I invoice you for the answer? > I have a few scheduled tasks that run fine, but I want to cease for a > while. When I try to edit them I get "The value specified for Port must > be between 1 and 65535"; I get this error even if port isn't specified > when I open it, and make no changes. I'm wondering why this is needed > now - can I just pick some arbitrary port, and can it be the same for > all scheduled tasks? > > I know I can just delete them, but would rather not. Assuming your web server is listening on TCP/80, you can just go ahead and put in 80. Now, please send 65 cents to the below address ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313320 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem editing task schedule
CF5.0 Problem for all you old guys out there (actually, a problem for me, an OPPORTUNITY for you): I have a few scheduled tasks that run fine, but I want to cease for a while. When I try to edit them I get "The value specified for Port must be between 1 and 65535"; I get this error even if port isn't specified when I open it, and make no changes. I'm wondering why this is needed now - can I just pick some arbitrary port, and can it be the same for all scheduled tasks? I know I can just delete them, but would rather not. Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to Invoke Simple .Net Web Service
My bad, again :[ , it's the Temp method, the one without any parameters. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam within a cfc
Thanks for the suggestions. I drastically shorten the code/query to get my question across. However, you make very good points! Thanks! Mike -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2008 5:51 AM To: cf-talk Subject: Re: cfqueryparam within a cfc >Add to that list, locally scope the query. > > > Very good point - probably the most critical change to make. I can't believe I missed that. :'( ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam within a cfc
>Add to that list, locally scope the query. > > > Very good point - probably the most critical change to make. I can't believe I missed that. :'( ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfqueryparam within a cfc
Add to that list, locally scope the query. Adrian -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: 01 October 2008 00:01 To: cf-talk Subject: Re: cfqueryparam within a cfc > > > > > > SELECT * FROM TABLE WHERE field = cfsqltype="cf_sql_integer"> > > > > > Is this over-kill or good practice? Use it always - it's safer and simpler that way. Since you're asking about good practice, I want to pick on a couple of things in your example. ;) First, the "SELECT *" - bad! You shouldn't ever use "SELECT *" in code. (Name just the fields you need; even if you need them all, name them anyway - it also helps readability and I've heard a couple of times of obscure bugs caused by "SELECT *" use.) Second, that should be Arguments.field_value - always scope variables. (Again, scoping helps performance, helps readability, and helps avoid annoying bugs.) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4