File not found error with flash remoting talking to a cfc
We are using AS3 in Flash and trying to get flash remoting working via IIS6 to access a ColdFusion 7 component. The remoting call is failing and producing an error message: File not found: C:\sites\orion\remote\quizEngineProxy.cfm C:\sites\orion is the web root. The actual file we are calling has the same name, but is a CFC and not a CFM, i.e.: C:\sites\orion\remote\quizEngineProxy.cfc Within the AS3 code we don't specify a file extension for the component; the call is similar to: quizService.call(remote.QuizEngineProxy.recordQuizAnswer, responder); Any thoughts on why it is looking for a cfm rather than a cfc? Thanks ~| 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:320429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java Training: moving from CF to Java
I know this is going off into a different area but there is also a big overhead that ColdFusion (note not all CFML engines are this bad) adds to a request. Give a servlet and cfm page that creates the same domain object of the servlet (the java object on both sides and I was not using Mark's Java loader the jar was on the classpath) the servlet consistently returns in 100ms (that's round trip to local host). The cfm upon server startup could take up-to 2000ms but typically at it's fastest I saw 500ms when I ran webLoader on it. Let me put this in perspective though, there was no database interaction no CFC objects and everything was self contained in a single jar. In a real world application you will have CFCs (not a bad thing) and database interactions the network ltency and speed of the DBMS will affect your application as much as the CFML engine will. Some of us get real caught up in these domain model talks and making full blow correct OO architecture. Reality is if you want that then CF is not, has not and will never be the appropriate tool to model your business in. Can CFML provide a wonderful UI layer for HTML based or quick service fronting of a complex domain yes it can and does so very nicely in many respects. I'll also disagree with the comment that groovy is magnitudes slower, from my personal tests groovy is not magnitudes slower...noticeable maybe but not magnitudes. Now back to the training, there is a rather dated book called Java for ColdFusion Developers pick it up pretty good reading, I also recommend Thinking in Java for folks starting out as well. I also think Hal Helms offers training so you might ping him and inquire. The whole XML XSLT thing is a bit odd to me but hey to each thier own, I would recommend looking at something like tapestry or velocity before trying to use straight XML and XSLT (or hell if $ is the issue switch to OpenBD or Railo and use them as the UI layer only). Adam H On Wed, Mar 11, 2009 at 11:37 PM, Jaime Metcher jaime.metc...@medeserv.com.au wrote: I'd want to see some pretty solid benchmarks before I believed that the Java written by CF is 200 times slower than the Java written by a random programmer. The 200 times difference comes from my own comparison of the same domain model implemented idiomatically in both ColdFusion/ColdSpring/Transfer and Java/Spring/Hibernate. Similar experiments conducted by colleagues give similar results. Mark Drew did some testing with a totally different scenario, but the results are in the same ballpark. Not sure why you'd find this surprising. Java code to solve a given problem isn't remotely similar to the bytecode that CF spits out for the same problem, unless that problem happens to be interpreting a dynamic language. The fact that they are both Java is far less significant than the fact that one is dynamic and the other static. There have been similar results from comparisons of Jruby and Java, and Groovy and Java. We're not talking about 20% or 50% performance differences, we're talking about orders of magnitude. Jaime ~| 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:320430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IOException while sending message
hi our cf emails were getting sent fine but they are now they are not getting sent and the logs are showing the following error: IOException while sending message we have tried restarting the server does anyone have any ideas on what may have caused this thanks ~| 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:320431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IOException while sending message
Permissions have changed? Run out of disk space? Adrian -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: 12 March 2009 13:26 To: cf-talk Subject: IOException while sending message hi our cf emails were getting sent fine but they are now they are not getting sent and the logs are showing the following error: IOException while sending message we have tried restarting the server does anyone have any ideas on what may have caused this thanks ~| 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:320432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dynamic SubDomain Creation / Domain Pointing
Hello Chaps, We've been working on some ideas for our new reseller panel and one things which really attracts me at the moment is making the panel they sign-in to brand able. ~| 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:320433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic SubDomain Creation / Domain Pointing
Hello Chaps, We've been working on some ideas for our new reseller panel and one things which really attracts me at the moment is making the panel they sign-in to brand able. I've started so I'll finish ;-) I had an itchy trigger finger this morning. Now in the most part a brandable panel is very simple, allowing users to change the colour scheme, logo and headings in the site is all no problem at all. One thing I have seen done in other applications is the dynamic creation of a subdomain for each user which registers on the server, they can then access the login for that site from that domain, for instance, someone comes and registers with me, and they then have access to their branded panel through thiername.thinkbluemedia.co.uk and they don't have to come through our site. Not only this but they can also mask that subdomain with their own domain such as control.resellersdomain.com or whatever it might happen to be making things even more seamless for the clients which they are reselling too. Now I would assume that the latter part requires them to add CNAME records to their own DNS records and is out of my control, however, the first part is not. How would you guys go about creating these subdomains? presumably I don't want to actually create records in my own domains DNS settings as these would take 72 hours to propagate so can I perhaps do this with some type of URL rewrite? or perhaps a wildcard subdomain and I then use server side code CGI scope variables to to display the correct branding? I'd appreciate your thoughts on this guys, Rob ~| 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:320434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Does String Contain?
I want to know if a string contains a ? or not. Essentially, the string is a link and I need to append some variables at the end, but the string may or may not already contain variables. If the string does not contain any variables there will be no question mark, so I'll append cfset newlink=#curlink#?mynewvars. If it already has variables I'll need to append cfset newlink=#curlink#mynewvars. So how do I tell the string already has variables so I know whether to start a var string or continue the var string? Thanks, Robert Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:320435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Select the last n rows in oracle.
I would like to select the last n records from a table as defined by a sequence field. I tried SELECT stuff FROM aTable WHERE rownum n ORDER BY query_seq desc. But this just sorts the first n records in descending order where I want the last n records. ~| 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:320436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic SubDomain Creation / Domain Pointing
Do you have to create subdomains? It's easy to create subdirectories and if they are masking with a CNAME record they should be able to subdirectory, so instead of: user1.servingdomain.com and user2.servingdomain.com they could have servingdomain.com/user1 and serving domain.com/user2. Couldn't that serve the same purpose? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:320437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does String Contain?
cfif Find(?, curlink) cfset thisDelim = cfelse cfset thisDelim = ? /cfif cfset newlink = ListAppend(curlink, mynewvars, thisDelim) On Thu, Mar 12, 2009 at 8:52 AM, Robert Harrison rob...@austin-williams.com wrote: I want to know if a string contains a ? or not. Essentially, the string is a link and I need to append some variables at the end, but the string may or may not already contain variables. If the string does not contain any variables there will be no question mark, so I'll append cfset newlink=#curlink#?mynewvars. If it already has variables I'll need to append cfset newlink=#curlink#mynewvars. So how do I tell the string already has variables so I know whether to start a var string or continue the var string? Thanks, Robert Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:320438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does String Contain?
I should really reply with RTFM and get you to look this up yourself. :P But because I'm feeling generous: cfif find( '?' , CurLink ) cfset Delim = '' / cfelse cfset Delim = '?' / /cfif cfset NewLink = ListAppend( CurLink , MyNewVars , Delim )/ Any questions? :) ~| 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:320439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
Selct top N stuff from aTable orderby query_seq desc. Rob On Thu, Mar 12, 2009 at 9:59 AM, Ian Skinner h...@ilsweb.com wrote: I would like to select the last n records from a table as defined by a sequence field. I tried SELECT stuff FROM aTable WHERE rownum n ORDER BY query_seq desc. But this just sorts the first n records in descending order where I want the last n records. ~| 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:320440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Select the last n rows in oracle.
TRY SELECT TOP N stuff FROM aTable ORDER BY query_seq desc Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, March 12, 2009 9:59 AM To: cf-talk Subject: Select the last n rows in oracle. I would like to select the last n records from a table as defined by a sequence field. I tried SELECT stuff FROM aTable WHERE rownum n ORDER BY query_seq desc. But this just sorts the first n records in descending order where I want the last n records. ~| 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:320441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does String Contain?
Heh, didn't see your answer when I posted. Nice to see we both gave the same solution. :) ~| 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:320442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
There is no select top n in Oracle. A subquery is necessary: Select * FROM (SELECT stuff FROM aTable ORDER BY query_seq desc) WHERE rownum n http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html You can also use ROW_NUMBER(): http://www.oracle.com/technology/oramag/oracle/07-jan/o17asktom.html mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/12 Rob Parkhill robert.parkh...@gmail.com: Selct top N stuff from aTable orderby query_seq desc. Rob On Thu, Mar 12, 2009 at 9:59 AM, Ian Skinner h...@ilsweb.com wrote: I would like to select the last n records from a table as defined by a sequence field. I tried SELECT stuff FROM aTable WHERE rownum n ORDER BY query_seq desc. But this just sorts the first n records in descending order where I want the last n records. ~| 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:320443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Does String Contain?
Oh Duh. Thanks. I knew that as soon as I saw it, but sometimes your brain overcomplicates something and takes you in the wrong direction. Now that I see this I don't know what the heck I was thinking earlier. Brain freeze. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: Thursday, March 12, 2009 11:00 AM To: cf-talk Subject: Re: Does String Contain? I should really reply with RTFM and get you to look this up yourself. :P But because I'm feeling generous: cfif find( '?' , CurLink ) cfset Delim = '' / cfelse cfset Delim = '?' / /cfif cfset NewLink = ListAppend( CurLink , MyNewVars , Delim )/ Any questions? :) ~| 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:320444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does String Contain?
Great minds... :-) On Thu, Mar 12, 2009 at 10:03 AM, Peter Boughton bought...@gmail.comwrote: Heh, didn't see your answer when I posted. Nice to see we both gave the same solution. :) ~| 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:320445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic SubDomain Creation / Domain Pointing
The subdomains shouldn't take any time to propagate, they should start working instantly. Its when you setup a brand new 2nd level domain (Foo.com) that it can take a while to propagate. When I did this before we dynamically wrote out zone files for the 2nd level domains, and used a wild card for the subdomains. For Apache we just modified one of two apache include files we setup, one for subdomains and one for full domains. I looked at doing it with a rewrite but it didn't work well for us for some reason. Maybe something to do with the logging or something. -Ryan Robert Rawlins wrote: Hello Chaps, We've been working on some ideas for our new reseller panel and one things which really attracts me at the moment is making the panel they sign-in to brand able. I've started so I'll finish ;-) I had an itchy trigger finger this morning. Now in the most part a brandable panel is very simple, allowing users to change the colour scheme, logo and headings in the site is all no problem at all. One thing I have seen done in other applications is the dynamic creation of a subdomain for each user which registers on the server, they can then access the login for that site from that domain, for instance, someone comes and registers with me, and they then have access to their branded panel through thiername.thinkbluemedia.co.uk and they don't have to come through our site. Not only this but they can also mask that subdomain with their own domain such as control.resellersdomain.com or whatever it might happen to be making things even more seamless for the clients which they are reselling too. Now I would assume that the latter part requires them to add CNAME records to their own DNS records and is out of my control, however, the first part is not. How would you guys go about creating these subdomains? presumably I don't want to actually create records in my own domains DNS settings as these would take 72 hours to propagate so can I perhaps do this with some type of URL rewrite? or perhaps a wildcard subdomain and I then use server side code CGI scope variables to to display the correct branding? I'd appreciate your thoughts on this guys, Rob ~| 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:320446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does String Contain?
Now that I see this I don't know what the heck I was thinking earlier. Brain freeze. Yeah, I know that feeling far too well. :( ~| 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:320447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic SubDomain Creation / Domain Pointing
The subdomains shouldn't take any time to propagate, they should start working instantly. Its when you setup a brand new 2nd level domain (Foo.com) that it can take a while to propagate. Neither should take any time to propagate. New entries to existing domains, and new domains themselves, don't have to propagate anywhere - all searches will resolve at the authoritative name server. Changed records may have been cached at intermediate name servers, and you'll have to wait for those records to expire. That's why it's a good idea to set a low time-to-live for records that you plan to change in the near future, because that determines the length of time that records will be cached. 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:320448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Managed Servers vs. Co-Lo Servers
Dave Hatz wrote: I would like to get some feedback from the network gurus on this list. We are currently hosting our servers with a hosting company, but they are now offering us a Managed Server option. I currently have both co-lo servers and managed servers for our hosting. We maintain a private suite at Hostway in Tampa where we run our own network, equipment, etc. Having the flexibility of running your own stuff is nice as you have complete control over the environment (important for some regulatory compliance, etc.). The managed boxes we run are with SoftLayer out of Dallas and Seattle. We have full remote access to them, so we still installed our own ColdFusion servers and manage them. SoftLayer only gets involved if something is wrong with the hardware (disk failure, whatever). One major difference is in the billing models. We own our equipment in Tampa, so once we buy it we just rack it and there isn't any additional monthly cost (except when we need more electricity or bandwidth to power additional equipment). If we need more storage, we add a file server. If we need to further segment the network, we buy another switch or firewall, or whatever we need and deploy it. It's a lot more flexible and the overall cost is lower for co-lo in our environment. In a managed server environment, like the one offered by SoftLayer, everything has a monthly fee attached to it. Need to add a server, that's another $200/mo. You want a hardware firewall? $50/mo. Additional storage? Your monthly just went up. The managed option has a lower barrier to entry, but over the long run you'll pay more for the equipment, especially if you want nicer equipment (hardware raid, redundant power, etc). The other big factor is responsibility for maintenance. In a managed environment, if a hard drive fails, your provider will be monitoring that and resolve the issue on their end (look for response times as part of your agreement with them). If you co-lo your own boxes, well, they're yours. If you have a hardware failure you have to correct it yourself (or have a contract with someone who will come do it for you). If you have the resources (money, time, and knowledge) to co-lo your own equipment, that's the route I would go. If you need something up today and don't want to outlay a lot of money up front or sign a long-term contract, the managed option can be great until you have the ability to move up to your own equipment. -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.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:320449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic SubDomain Creation / Domain Pointing
Robert Rawlins wrote: How would you guys go about creating these subdomains? presumably I don't want to actually create records in my own domains DNS settings as these would take 72 hours to propagate so can I perhaps do this with some type of URL rewrite? or perhaps a wildcard subdomain and I then use server side code CGI scope variables to to display the correct branding? That's how I'd approach it. Put a wildcard entry that points to a dedicated IP for your portal app, then look up the hostname (cgi.server_name) against the database to determine which client it is. If someone wants to mask their own domain, give them a place to specify that in their account so it can find their account against the cgi variable (and they would have to CNAME that host to one of yours in case you have to change the IP at some point as you mentioned). There's really no need to muck with the DNS entries for each new client that joins the system. -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.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:320450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic SubDomain Creation / Domain Pointing
The subdomains shouldn't take any time to propagate, they should start working instantly. Its when you setup a brand new 2nd level domain (Foo.com) that it can take a while to propagate. I can confirm this as well. It is common practice with Hosting CP's like H-sphere to generate a random subdomain of instant access until DNS propagates. Are you using Apache or IIS? I saw a couple of projects for working with IIS http://iisweb.riaforge.org/ http://iisvdir.riaforge.org/ Here are the MS doc on talking to IIS http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/aee71684-36c0-40e1-b387-a19d2d0509f0.mspx?mfr=true G! On Thu, Mar 12, 2009 at 10:14 AM, Ryan Stille r...@cfwebtools.com wrote: The subdomains shouldn't take any time to propagate, they should start working instantly. Its when you setup a brand new 2nd level domain (Foo.com) that it can take a while to propagate. -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:320451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
James Holmes wrote: There is no select top n in Oracle. A subquery is necessary: Select * FROM (SELECT stuff FROM aTable ORDER BY query_seq desc) WHERE rownum n I was afraid of that... That is a huge dataset in that sub select. I mean really 10's of millions of records just to get the top 25. Oh well, at least it is only debugging|testing information and does not need to be high proformance for production purposes. I'll take a look at the Row_number() thing, that is new to me. P.S. Sure shows how many developers don't need to work with Oracles eccentricities. For all you SQL server types, Oracle unfortunately does not understand the TOP command. ~| 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:320452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
Try it out - Oracle is smarter than most DB's and you might be pleasantly surprised. Oracle will only sort the N rows, as it knows that overall you only want that many. It will not generate and sort the entire result set. Seriously, give it a go and check how long it takes. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/13 Ian Skinner h...@ilsweb.com: James Holmes wrote: There is no select top n in Oracle. A subquery is necessary: Select * FROM (SELECT stuff FROM aTable ORDER BY query_seq desc) WHERE rownum n I was afraid of that... That is a huge dataset in that sub select. I mean really 10's of millions of records just to get the top 25. Oh well, at least it is only debugging|testing information and does not need to be high proformance for production purposes. I'll take a look at the Row_number() thing, that is new to me. P.S. Sure shows how many developers don't need to work with Oracles eccentricities. For all you SQL server types, Oracle unfortunately does not understand the TOP command ~| 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:320453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
How about this, using an expression for the ROWNUM test ... not sure it works, but some variation of this may be worth a try? SELECT stuff FROM aTable WHERE ROWNUM (COUNT(*) - n) ORDER BY query_seq DESC ~| 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:320454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select the last n rows in oracle.
That will sort a random n records, not take the top n sorted records. The subquery provides the sort first. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/13 Jason Fisher ja...@wanax.com: How about this, using an expression for the ROWNUM test ... not sure it works, but some variation of this may be worth a try? SELECT stuff FROM aTable WHERE ROWNUM (COUNT(*) - n) ORDER BY query_seq DESC ~| 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:320455 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
No, it shouldn't. There is no subquery, only the aggregate COUNT() function, and that's simply there to get the max number of rows. Max number - n = our starting number for last n, right? so I don't care about sorting within the COUNT(), only the aggregate value. The simple query is still: SELECT stuff FROM aTable ORDER BY query_seq DESC and the WHERE clause is then a simple 'ROWNUM greater than' statement, at least the way I read it. That will sort a random n records, not take the top n sorted records. The subquery provides the sort first. 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:320456 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select the last n rows in oracle.
This should work for you. Select * From (Select rownum rnum, p.* From ( SELECT count(1) Over() totalCount, email, firstname FROM Carma_Contact ) p ) Where rnum = (totalCount - 50); Just replace the 50 with the number of rows back from the total that you want to select. Hope that helps. Nik On Thu, Mar 12, 2009 at 6:59 AM, Ian Skinner h...@ilsweb.com wrote: I would like to select the last n records from a table as defined by a sequence field. I tried SELECT stuff FROM aTable WHERE rownum n ORDER BY query_seq desc. But this just sorts the first n records in descending order where I want the last n records. ~| 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:320457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
Have you tried it? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/13 Jason Fisher ja...@wanax.com: No, it shouldn't. There is no subquery, only the aggregate COUNT() function, and that's simply there to get the max number of rows. Max number - n = our starting number for last n, right? so I don't care about sorting within the COUNT(), only the aggregate value. The simple query is still: SELECT stuff FROM aTable ORDER BY query_seq DESC and the WHERE clause is then a simple 'ROWNUM greater than' statement, at least the way I read it. That will sort a random n records, not take the top n sorted records. The subquery provides the sort first. 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:320458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Yet another web services question
Most of the time, I'm able to muddle through trying to call these wacky .NET webservices with ColdFusion on my own. (With help from blog articles and wsdl2java, of course.) This time, I'm just banging my head against the wall. Here's the WSDL: s:element name=SomeServiceMethod s:complexType s:sequence s:element minOccurs=1 maxOccurs=1 name=foo nillable=true type=s:string/ s:element minOccurs=0 maxOccurs=1 name=bar type=s:string/ s:element minOccurs=0 maxOccurs=1 name=baz s:complexType mixed=true s:sequence s:any/ /s:sequence /s:complexType /s:element /s:sequence /s:complexType /s:element In C#, the web reference auto-generates a method for this that takes three params: a string, a string, and an XmlNode. Easy-peasy. But how do I need to structure the third argument in ColdFusion to make this work? I've tried passing a string with the XML, a parsed XML document, a big nested structure with the shape of the XML... nothing has worked so far. What Axis produces is a class SomeServiceMethodBaz that has one getter/setter pair that look like this: public org.apache.axis.message.MessageElement[] get_any() public void set_any(org.apache.axis.message.MessageElement[] _any) Can anyone help me out with this? Sixten ~| 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:320459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What *exactly* does cgi.server_name return.
I think I can get the answer faster from this helpful and generous group of people then I can write one line of code and try it out on a wide variety of environments. What exactly is cgi.server_name expected to return? Looking at the following examples what would you expect to be in this variable? http://calpip-devsite/index.cfm http://calpip.cdpr.ca.gov/index.cfm http://calpip-devsite.inisde.cdpr.ca.gov/index.cfm http://10.104.106.113/index.cfm http://134.186.118.90/index.cfm/ TIA Ian ~| 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:320460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What *exactly* does cgi.server_name return.
http://134.139.143.25/stompy/server.cfm or http://cfdev.cota.csulb.edu/stompy/server.cfm both return: CGI.SERVER_NAME: cfdev.cota.csulb.edu It looks like it returns the name registered in the web server (apache, in my case). The above addresses both go to the same server. Mike Ian Skinner wrote: I think I can get the answer faster from this helpful and generous group of people then I can write one line of code and try it out on a wide variety of environments. What exactly is cgi.server_name expected to return? Looking at the following examples what would you expect to be in this variable? http://calpip-devsite/index.cfm http://calpip.cdpr.ca.gov/index.cfm http://calpip-devsite.inisde.cdpr.ca.gov/index.cfm http://10.104.106.113/index.cfm http://134.186.118.90/index.cfm/ TIA Ian ~| 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:320461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What *exactly* does cgi.server_name return.
calpip-devsite/index.cfmcalpip-devsite calpip.cdpr.ca.gov/index.cfmcalpip.cdpr.ca.gov calpip-devsite.inisde.cdpr.ca.gov/index.cfm calpip-devsite.inisde.cdpr.ca.gov 10.104.106.113/index.cfm10.104.106.113 134.186.118.90/index.cfm/ 134.186.118.90 But, I did read somewhere that depending on your set up, either SERVER_NAME or the other one that looks like it returns the same thing can include the port. Google for something like difference between SERVER_NAME and [some other CGI var that I can't remember] and you'll come across a post or two that explains what it returns. Or not :OD Adrian -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: 12 March 2009 17:20 To: cf-talk Subject: What *exactly* does cgi.server_name return. I think I can get the answer faster from this helpful and generous group of people then I can write one line of code and try it out on a wide variety of environments. What exactly is cgi.server_name expected to return? Looking at the following examples what would you expect to be in this variable? http://calpip-devsite/index.cfm http://calpip.cdpr.ca.gov/index.cfm http://calpip-devsite.inisde.cdpr.ca.gov/index.cfm http://10.104.106.113/index.cfm http://134.186.118.90/index.cfm/ TIA Ian ~| 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:320462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDIV Navigation
Read the documentation on cflocation. And learn how to ask a question on a technical mailing list, because your post doesn't make any sense. On Thu, Mar 12, 2009 at 1:54 AM, Pranathi Reddy rk.prana...@gmail.comwrote: Any Ideas.? Grid Code: ~| 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:320463 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What *exactly* does cgi.server_name return.
Adrian Lynch wrote: calpip-devsite/index.cfm calpip-devsite calpip.cdpr.ca.gov/index.cfm calpip.cdpr.ca.gov calpip-devsite.inisde.cdpr.ca.gov/index.cfm calpip-devsite.inisde.cdpr.ca.gov 10.104.106.113/index.cfm 10.104.106.113 134.186.118.90/index.cfm/ 134.186.118.90 That is what I thought, but I wasn't 100% certain about the behavior with domains and sub-domains and potential IP addresses. And I just did not have a quick and easy variety of these options for testing to see for myself. ~| 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:320464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What *exactly* does cgi.server_name return.
I thought I'd add to this: http://134.139.143.25/stompy/server.cfm http://cfdev.cota.csulb.edu/stompy/server.cfm http://servername/stompy/server.cfm http://servername.ad.dns.entry/stompy/server.cfm http://localhost/stompy/server.cfm all return: CGI.SERVER_NAME: cfdev.cota.csulb.edu I do have the servername set to cfdev.cota.csulb.edu in the httpd.conf file. Mike Mike Soultanian wrote: http://134.139.143.25/stompy/server.cfm or http://cfdev.cota.csulb.edu/stompy/server.cfm both return: CGI.SERVER_NAME: cfdev.cota.csulb.edu It looks like it returns the name registered in the web server (apache, in my case). The above addresses both go to the same server. Mike Ian Skinner wrote: I think I can get the answer faster from this helpful and generous group of people then I can write one line of code and try it out on a wide variety of environments. What exactly is cgi.server_name expected to return? Looking at the following examples what would you expect to be in this variable? http://calpip-devsite/index.cfm http://calpip.cdpr.ca.gov/index.cfm http://calpip-devsite.inisde.cdpr.ca.gov/index.cfm http://10.104.106.113/index.cfm http://134.186.118.90/index.cfm/ TIA Ian ~| 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:320465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ISO SQL2005 Linked Server Tutorital or Example
Thanks to all! This reallt helped to get me started. ~| 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:320466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What *exactly* does cgi.server_name return.
Ian Skinner wrote: I think I can get the answer faster from this helpful and generous group of people then I can write one line of code and try it out on a wide variety of environments. It depends on the web server. IIS should return whatever is in the domain part of the URL the user used to access the page. Apache uses the host header as set in the server configuration from what I can tell from other responses (I don't use Apache personally). -Justin ~| 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:320467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select the last n rows in oracle.
I don't have access to an Oracle database, so, no. Thankfully, I haven't had to develop on Oracle for the past several years, after spending several years splitting my time between Oracle and SQL Server. Seems like it should work, but I can't verify. ~| 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:320468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What *exactly* does cgi.server_name return.
What exactly is cgi.server_name expected to return? The thing about CGI variables is that these expectations can be pretty vague. CF doesn't control them; they're controlled by the web server and/or the operating system. I would generally expect it to return the server hostname, IP address or DNS alias name used in the URL that got you to the server in the first place, but I wouldn't be completely surprised if it returns something else. If you want to know what it should return generally, you'd go here: http://www.w3.org/CGI/ 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:320469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yet another web services question
In C#, the web reference auto-generates a method for this that takes three params: a string, a string, and an XmlNode. Easy-peasy. But how do I need to structure the third argument in ColdFusion to make this work? I've tried passing a string with the XML, a parsed XML document, a big nested structure with the shape of the XML... nothing has worked so far. Are you specifying TYPE=XML in your CFARGUMENT tag? That's about all I can think of without shelling to Java (as usual). 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:320470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select the last n rows in oracle.
I can verify in 9.i it doesn't work states group by function is not allowed there. On Thu, Mar 12, 2009 at 11:11 AM, Jason Fisher ja...@wanax.com wrote: I don't have access to an Oracle database, so, no. Thankfully, I haven't had to develop on Oracle for the past several years, after spending several years splitting my time between Oracle and SQL Server. Seems like it should work, but I can't verify. ~| 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:320471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Yet another web services question
Are you specifying TYPE=XML in your CFARGUMENT tag? That's about all I can think of without shelling to Java (as usual). Do you mean cfinvokeargument? This isn't my web service: it's a third-party thing that was implemented in .NET. I haven't seen the source, but I strongly suspect that it's declared as taking an XmlNode for that third parameter. (Like the proxy method that .NET generates.) Worse comes to worst, I suppose I can build the (very simple) SOAP envelope myself, and use CFHTTP, but I *really* don't want to do that if I can avoid it. Sixten ~| 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:320472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select the last n rows in oracle.
You could select the rows with sort descending, then use query of queryies to sort them back into the asc order couldnt you?if you're only manipulating 50 records or so the qofq wouldnt take long. Mike Kear Windsor, NSW, Australia http://afpwebworks.com AFP Webworks I tried SELECT stuff FROM aTable WHERE rownum n ORDER BY query_seq desc. But this just sorts the first n records in descending order where I want the last n records. ~| 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:320473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yet another web services question
Whenever I've had to call a .NET web-service, where any of the arguments are complex, I've always had to construct the SOAP envelope manually. In the end, this took less time than trying to call it directly -- and failing, and failing, and failing. Cheers, Kris This isn't my web service: it's a third-party thing that was implemented in .NET. I haven't seen the source, but I strongly suspect that it's declared as taking an XmlNode for that third parameter. (Like the proxy method that .NET generates.) Worse comes to worst, I suppose I can build the (very simple) SOAP envelope myself, and use CFHTTP, but I *really* don't want to do that if I can avoid 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:320474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yet another web services question
Are you specifying TYPE=XML in your CFARGUMENT tag? That's about all I can think of without shelling to Java (as usual). Do you mean cfinvokeargument? No, apparently I meant that I didn't read your question properly. Sorry about that! Worse comes to worst, I suppose I can build the (very simple) SOAP envelope myself, and use CFHTTP, but I *really* don't want to do that if I can avoid it. Yes, that approach is less than optimal. You should be able to resolve this by invoking Axis directly, instead of using CFINVOKE. Rob Munn wrote an example you can see here: http://coldfusion.sys-con.com/node/86131 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:320475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Deploying to multiple production servers
Let's say you have a CF application that needs to run on 100 identical Windows servers. What's the best way to deploy your code from dev to production (without doing 100 manual FTP's...) Setting up my infrastructure and want to make sure I've looked at all options. Thanks! Philip ~| 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:320476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Queries to Linked Server SQL 2005 / Access 2007
Hi -- I am quering against a linked server (access2007) via SQL 2005. When I first started working on this I wrote all of my CF queries against a local copy of the Access2007 database. Each query works fine. Now that I am migrating my code to query against this linked server, queries that contain joins are not working properly. I have tested these with CF debugging and then directly through SQL server management studio. What am i doing wrong here? Here is a query that works directly against the accessdb via CF8: SELECT distinct tblcompanies.[company name] AS company, tblcompanies.[company id] as companyid FROM LINKDB...tblPeopleAddresses, LINKDB...tblPeople INNER JOIN LINKDB...tblCompanies ON tblPeople.[Company ID] = tblCompanies.[Company ID] WHERE tblPeople.[Person ID]= tblPeopleAddresses.[Person id] AND tblPeopleAddresses.state='#state#' AND tblPeopleAddresses.primary = 1 AND tblPeople.showonweb = 1 ORDER by tblcompanies.[company name] Note: If I remove the last WHERE paramter, I get data, but not the data that I want ~| 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:320477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to multiple production servers
I've always used rsync to deploy stuff. It's fast and easy, and since it's all command-line driven it's easy to integrate with pretty much any automation framework you might have. Just a matter of looping over your server list and rsyncing to each one. cheers, barneyb On Thu, Mar 12, 2009 at 12:45 PM, Philip Kaplan pkap...@gmail.com wrote: Let's say you have a CF application that needs to run on 100 identical Windows servers. What's the best way to deploy your code from dev to production (without doing 100 manual FTP's...) Setting up my infrastructure and want to make sure I've looked at all options. Thanks! Philip ~| 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:320478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to multiple production servers
Philip Kaplan wrote: What's the best way to deploy your code from dev to production (without doing 100 manual FTP's...) Scheduled process on each server to check with a master for updated files via robocopy, rsync (there are versions for Windows available), or similar file copy/mirroring tool. Windows Distributed File System may also work for you. If they're all on the same network, you might also direct your web server's home directory to a master file store over the network so you don't have a copy on each server. Either way, update the code once on whatever server is designated the master and it will make its way to all of the nodes automatically. -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.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:320479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What *exactly* does cgi.server_name return.
Since IIS uses the DNS alias in the URL and that can easily be spoof by modifying your HOSTS file, I use a Java class if I need to identify a machine (like for environmental changes). InetAddress = createObject(java, java.net.InetAddress); hostName = InetAddress.getLocalHost().getHostName(); At least in IIS, this returns the fully qualified domain name of the ColdFusion machine. It looks like Mike is using Apache, so this might not be of specific use to him. However, it's here for others to find later. :) Jason ~| 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:320480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to multiple production servers
Barney Boisvert wrote: I've always used rsync to deploy stuff. It's fast and easy, and since it's all command-line driven it's easy to integrate with pretty much any automation framework you might have. Just a matter of looping over your server list and rsyncing to each one. I would do it the other way around, have the server be the one doing the checking, then you don't have to keep a list. If the setup is the same on all of the servers you can add and remove web front-ends at will and know* that all of them will always be up to date. -Justin * Assuming you have monitoring in place independent of the deployment method that makes sure the local copy is up-to-date and notifies you otherwise. ~| 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:320481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Queries to Linked Server SQL 2005 / Access 2007
Hey Jeanmarie, I have always used OpenQuery() for my linked server connections. SELECT * FROM openquery([connectionname], '[query]') The cool thing about this is that you can bring everything from the access dB to the SQL server for joining. Example might be... SELECT * FROM openquery([connectionname], '[query]') a, openquery([connectionname], '[query]') b, WHERE a.[colName] = b.[ colName] Hope this helps, William -- William E. Seiter Need to have your mortgage modified? I charge no fees until I am successful, then I charge almost half the rate you would find elsewhere. Professional. Dedicated. Effective. The Easy 24/7 way to get started: http://www.goldengrove.net/ or you can call: (626) 593 - 5501 -Original Message- From: Jeanmarie Richardson [mailto:jean...@tdai.net] Sent: Thursday, March 12, 2009 1:48 PM To: cf-talk Subject: SQL Queries to Linked Server SQL 2005 / Access 2007 Hi -- I am quering against a linked server (access2007) via SQL 2005. When I first started working on this I wrote all of my CF queries against a local copy of the Access2007 database. Each query works fine. Now that I am migrating my code to query against this linked server, queries that contain joins are not working properly. I have tested these with CF debugging and then directly through SQL server management studio. What am i doing wrong here? Here is a query that works directly against the accessdb via CF8: SELECT distinct tblcompanies.[company name] AS company, tblcompanies.[company id] as companyid FROM LINKDB...tblPeopleAddresses, LINKDB...tblPeople INNER JOIN LINKDB...tblCompanies ON tblPeople.[Company ID] = tblCompanies.[Company ID] WHERE tblPeople.[Person ID]= tblPeopleAddresses.[Person id] AND tblPeopleAddresses.state='#state#' AND tblPeopleAddresses.primary = 1 AND tblPeople.showonweb = 1 ORDER by tblcompanies.[company name] Note: If I remove the last WHERE paramter, I get data, but not the data that I want ~| 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:320482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to multiple production servers
On Thu, Mar 12, 2009 at 8:45 PM, Philip Kaplan wrote: Let's say you have a CF application that needs to run on 100 identical Windows servers. What's the best way to deploy your code from dev to production (without doing 100 manual FTP's...) Merge your code onto the image that gets spooled to install Windows on the 100 servers. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:320483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Deploying to multiple production servers
These are all good ideas. just a reminder to cksum the code after it is installed to verify that the right code was installed on all machines. On Thu, Mar 12, 2009 at 2:45 PM, Philip Kaplan pkap...@gmail.com wrote: Let's say you have a CF application that needs to run on 100 identical Windows servers. What's the best way to deploy your code from dev to production (without doing 100 manual FTP's...) Setting up my infrastructure and want to make sure I've looked at all options. Thanks! Philip ~| 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:320484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to multiple production servers
Justin already mentioned Distributed File System (DFS). This what my company uses. http://www.microsoft.com/windowsserver2003/technologies/storage/dfs/default.mspx Basically you setup a single server as the Master. It knows where your other servers are. You push files to the Master and it distributes the files to the rest automatically. Easy peasy lemon squeezy. -- Adrian Let's say you have a CF application that needs to run on 100 identical Windows servers. What's the best way to deploy your code from dev to production (without doing 100 manual FTP's...) Setting up my infrastructure and want to make sure I've looked at all options. Thanks! Philip ~| 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:320485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to multiple production servers
I love this list. Rsync, Robocopy and DFS all look like awesome solutions. I like Justin's idea of setting a scheduled process for the webservers to check the master and automatically grab the latest version. I should have the process check every couple of minutes, right? That way if there's an emergency bug fix, it goes out pretty quickly. Thoughts? On Thu, Mar 12, 2009 at 2:47 PM, Adrian Moreno amor...@iknowkungfoo.comwrote: Justin already mentioned Distributed File System (DFS). This what my company uses. http://www.microsoft.com/windowsserver2003/technologies/storage/dfs/default.mspx Basically you setup a single server as the Master. It knows where your other servers are. You push files to the Master and it distributes the files to the rest automatically. Easy peasy lemon squeezy. -- Adrian Let's say you have a CF application that needs to run on 100 identical Windows servers. What's the best way to deploy your code from dev to production (without doing 100 manual FTP's...) Setting up my infrastructure and want to make sure I've looked at all options. Thanks! Philip ~| 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:320486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
You really don't need to use analytics in this case. The inline subquery presented by Mr. Holmes is the correct one. See http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/pseudocolumns009.htm#i1006297 Although this is for 11g, it holds for the other verisons as well ~| 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:320487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to multiple production servers
Philip Kaplan wrote: I love this list. Rsync, Robocopy and DFS all look like awesome solutions. I like Justin's idea of setting a scheduled process for the webservers to check the master and automatically grab the latest version. I should have the process check every couple of minutes, right? That way if there's an emergency bug fix, it goes out pretty quickly. Thoughts? If you use DFS replication, you can schedule as often as you like and it will push updates out pretty quickly. If you use something like robocopy to mirror the files, it will crawl through the entire folder structure looking for changes, so it can take a little while to run if you have a lot of files. Be sure to leave enough time in the schedule for it to run all the way through with a reasonable buffer for future growth in the number of files. I'm curious what you're cooking up that would need 100 servers though. -- Justin Scott | GravityFree Member of the Technical Staff 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.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:320488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Yet another web services question
Yes, that approach is less than optimal. You should be able to resolve this by invoking Axis directly, instead of using CFINVOKE. Rob Munn wrote an example you can see here: http://coldfusion.sys-con.com/node/86131 I don't think I really want to go building my own proxies, as that article suggests, but I might be able to instantiate the last parameter with CreateObject() or something. Not great, but I guess it beats CFHTTP. Sixten ~| 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:320489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
I'd much rather deal with Oracle's that SQL Server's. At least my experience has been it is far easier for me to deal with issues with Oracle v. ones with SQL Server. On Mar 12, 2009, at 10:06 AM, Ian Skinner h...@ilsweb.com wrote: P.S. Sure shows how many developers don't need to work with Oracles eccentricities. For all you SQL server types, Oracle unfortunately does not understand the TOP command. ~| 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:320490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion + FFmpeg
Does anyone know of a ColdFusion hosting company that offers ffmpeg as part of it's install base for a shared environment? I want to keep cost down during development and have been looking for a CF hosting solution for ffmpeg. Thanks! ~| 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:320492 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 + FFmpeg
You'll be lucky to find one I reckon. What about Railo hosting, they use ffmpeg under the hood for cfvideo? Adrian -Original Message- From: Bryon Westmoreland [mailto:westmorela...@gmail.com] Sent: 13 March 2009 01:41 To: cf-talk Subject: Re: Coldfusion + FFmpeg Does anyone know of a ColdFusion hosting company that offers ffmpeg as part of it's install base for a shared environment? I want to keep cost down during development and have been looking for a CF hosting solution for ffmpeg. Thanks! ~| 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:320493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion + FFmpeg
Try this again... sorry it my attempts are spamming this thread. Does anyone know of a ColdFusion hosting company that offers ffmpeg as part of it's install base for a shared environment? I want to keep cost down during development and have been looking for a CF hosting solution for ffmpeg. Thanks! ~| 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:320491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Can't Save / display euro character - CF8, Win2003/IIS, MSSQL2005
Hi All, In previous setups, CF4/5 with MSSQL7 on Win2K, I've previously created a basic HTML form, posted it to a CFM processing page, which saved the contents of the form to a MSSQL7 database, nvarchar field. No charset / meta tags or extra instructions was required to save and redisplay a euro character (http://en.wikipedia.org/wiki/Euro). Now, on CF8, Win2003/IIS, MSSQL2005, the same form doesn't save the euro character in the database. What I mean by this, is that it's replaced by ¬ character (in case it doesn't display correctly, it looks like the top-right of a rectangle). If I paste a euro character directly into the database using the MSSQL GUI (not sure what they call it these days), it displays as a rectangular block on the screen. I'd remembered previously, when displaying other languages changing the charset of the page was necessary for them to display correctly. I've tried all the steps above with the same results when adding the following meta tags as the first tag after the opening HEAD tag in the HTML: meta http-equiv=Content-Type content=text/html; charset=utf-8 meta http-equiv=Content-Type content=text/html; charset=iso-8859-15 meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 I'm a little lost now. Are there settings that I'm missing to the database (please don't say it's a field by field change!!)? Happy to provide additional information. Any help is 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:320494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select the last n rows in oracle.
Oracle worries about the where clause before the sort (so it has to sort less rows). I filled ten rows in a table with value from 1 to 10 in random order, then ran this: SELECT STUFF FROM ATABLE WHERE ROWNUM 9 ORDER BY STUFF DESC If it works as you say, I should get 10-3 in order. I didn't. In my case I got 1-7 and 9. Adding the necessary subquery: SELECT * FROM( SELECT STUFF FROM ATABLE ORDER BY STUFF DESC) WHERE ROWNUM 9 I get the right results. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/13 Jason Fisher ja...@wanax.com: No, it shouldn't. There is no subquery, only the aggregate COUNT() function, and that's simply there to get the max number of rows. Max number - n = our starting number for last n, right? so I don't care about sorting within the COUNT(), only the aggregate value. The simple query is still: SELECT stuff FROM aTable ORDER BY query_seq DESC and the WHERE clause is then a simple 'ROWNUM greater than' statement, at least the way I read it. That will sort a random n records, not take the top n sorted records. The subquery provides the sort fir ~| 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:320495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query Group Clause and determining the end of a group
Greetings from the chilly south of NZ, A little background, and I apologise in advance for the length of this post: I have a query which grabs all sponsors from the appropriate tables. There are 8 categories but two different sponsor types - those with images and those that display as text only. Unfortunately on this one I have to meet a specific layout provided by a designer; all the image sponsors need to be on a white background with rounded corners, while all text sponsors are on a black background with white text etc. etc. Without getting into too much more detail on the why and how and the fact that the display has to very accurate (not pixel perfect but pretty close), here's some code to help explain what I'm doing. This works ok, but I'm thinking there may (must??) be an easier way: code_snippet !--- The Query --- cfquery name=qGetSponsors datasource=#request.dsn# SELECT S.ID, S.Category_ID, S.Name, S.URL, S.Image, S.Image_Width, S.Image_Height, SC.Category, SC.Display_Type, SC.FolderName FROM tbl_sponsor_categories SC INNER JOIN tbl_sponsors S ON SC.ID = S.Category_ID WHERE S.Active = Yes ORDER BY S.Category_ID, SC.Display_Type; /cfquery !--- Set a variable to keep track of the combined width total of all images inside the row wrapper so we can close it when the total exceeds allowable content width. If I had it my way I'd just float these bastards and allow them to line wrap naturally, placing some spacing between each image. Not as pretty, but an acceptable trade off in my opinion. Rant done. --- cfset attributes.aggregateImgWidth = 0 / !--- variable to determine start of new rowwrapper div cfset attributes.newRow = true / cfoutput query=qGetSponsors group=Category_ID h3#Category#/h3 cfif Display_Type EQ Images div class=sponsorimgcontainer div class=sponsorimgbox cfoutput cfset attributes.currentCat = qGetSponsors[Category][qGetSponsors.currentRow]/ cfset attributes.nextCat = qGetSponsors[Category][qGetSponsors.currentRow + 1]/ cfif attributes.newRow EQ true div class=rowwrapper /cfif img src=#sponsorsImagePath##FolderName#/#Image# width=#Image_Width# height=#Image_Height# alt=#Name# / cfset attributes.aggregateImgWidth = attributes.aggregateImgWidth + Image_Width / cfif attributes.aggregateImgWidth GT 450 OR attributes.currentCat NEQ attributes.nextCat !--- width reached or last item in cat group so close div and reset --- /div cfset attributes.aggregateImgWidth = 0 / cfset attributes.newRow = true cfelse !--- Not there yet so don't close the row --- cfset attributes.newRow = false /cfif /cfoutput /div /div cfelse div class=sponsorlist cfoutput Stuff for text sponsors here /cfoutput /div /cfif /cfoutput /code_snippet I think the above is reasonably self explanatory with the commenting so I wont repeat myself here. This is all fine and is working, but seems ugly to me. If anyone has an alternative solution to laying out the content, or perhaps even the way I'm grouping or querying, I'm interested to hear from you. Hardly mission critical, but I'm curious. TIA Regards Mark ~| 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:320496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't Save / display euro character - CF8, Win2003/IIS, MSSQL2005
In cfadmin select the datasource, click Show advanced and check: String Format-- Enable High ASCII characters and Unicode for data sources configured for non-Latin characters Paul. On Thu, Mar 12, 2009 at 11:00 PM, Mike L michael.lamb...@hronline.com.au wrote: Hi All, In previous setups, CF4/5 with MSSQL7 on Win2K, I've previously created a basic HTML form, posted it to a CFM processing page, which saved the contents of the form to a MSSQL7 database, nvarchar field. No charset / meta tags or extra instructions was required to save and redisplay a euro character (http://en.wikipedia.org/wiki/Euro). Now, on CF8, Win2003/IIS, MSSQL2005, the same form doesn't save the euro character in the database. What I mean by this, is that it's replaced by ¬ character (in case it doesn't display correctly, it looks like the top-right of a rectangle). If I paste a euro character directly into the database using the MSSQL GUI (not sure what they call it these days), it displays as a rectangular block on the screen. I'd remembered previously, when displaying other languages changing the charset of the page was necessary for them to display correctly. I've tried all the steps above with the same results when adding the following meta tags as the first tag after the opening HEAD tag in the HTML: meta http-equiv=Content-Type content=text/html; charset=utf-8 meta http-equiv=Content-Type content=text/html; charset=iso-8859-15 meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 I'm a little lost now. Are there settings that I'm missing to the database (please don't say it's a field by field change!!)? Happy to provide additional information. Any help is 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:320497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query Group Clause and determining the end of a group
Ooops, sorry about that first post. I hadn't set Outlook 2007 (yes, please keep the comments to yourself!) to automatically send text messages to the list. Settings for cf-talk updated now. Regards Mark ~| 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:320498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem in accessing formfields using CFDIV
Hii All, I really dont know how to post for the technical issues and I will try my best to explain in details. I have a parent Page with the below form fields and using cfdiv to submit the form asynchronously. cfform name =DetailsForm table tr tdFirstName/td tdcfinput type=text name=txt_FirstName id=id_FirstName value=/td /tr tr tdLastName/td tdcfinput type=text name=txt_LastName id=id_LastName value=/td /tr tr tdPhotograph/td tdcfinput type=file name=Image id=id_file value=/td /tr tr tdcfinput type=submit name=submit_Details value=Submit/td /tr /table /cfform cfdiv id=id_details bind=url:New1.cfm?FirstName={DetailsForm.FirstName} /cfdiv New1.cfm cfobject component=Project_Sample name=Project_Sample_Obj cfinvoke component=#Project_Sample_Obj# method=InsertBrandData returnvariable=InsertedBrand/ cfif form.Image neq '' cffile action=upload fileField=image destination=#application.workingPDFDirectory# result=fileUpload nameconflict=overwrite cffile action=readBinary file=#image# variable=FinalImage cfset session.FinalImage =#FinalImage# cfinvoke component=#OAFAdmin_Obj# method=UpdateLogo returnvariable=UpdatedLogo/ cfquery name=Query5 datasource=BankInfo result=result_1 select Logo from tblWebSiteBrand where BankNumber='1221' /cfquery cfimage action=writetobrowser source=#Query5.Logo# / /cfif ~| 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:320499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Thinking of a career change.. how does one get into Technical Recruiting..
Sell your wife, mother, and youngest child. Then have a heart reduction surgery (placing is in a secure storage facility) Rob a whole troop of girlscouts out of their cookie money. Dig a 20 foot hole in a sand trap with a sand wedge. And tell a bar full of Yankee fans that the Red Sox are a better team. Now, add the above items to your resume, and you should be all set. More seriously, know that recruiting is a _hard_ job, and requires a true salesman's ability to pursue leads with dogged determination and boundless energy. And you will need very thick skin, a golden tongue, and the ability to sell your technical knowledge even when out on thin ice experience-wise. Many of my friends and colleagues that have switched from technical track to recruiting and placement did so while pursuing a job. They gradually moved from looking for a job to harassing their recruiters for jobs, to being asked can you do it better, to working for their recruiter. So my advice, from the cheap seats, would be to think about the recruiters YOU liked working with, and contacting them to see if they need help. And don't take the first 5 nos for an answer. On Thu, Mar 12, 2009 at 3:36 PM, Scott Stewart sstwebwo...@bellsouth.netwrote: Hey all, Since there's a large number of recruiters on this list, I've been wondering. How does one break into technical recruiting? I've got years of experience as a ColdFusion developer, but it appears that the CF market in NC has dried up. So I'm entertaining the idea of moving into recruiting, but have no idea where to start. Thanks in advance for any replies sas -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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-jobs-talk/message.cfm/messageid:4183 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: Thinking of a career change.. how does one get into Technical Recruiting..
Steve, go talk to the managers you worked for in previous contracts. Find out what their needs are and tell them you have a great deal of recourses because you have been in IT for so long. Regarding the selling family members and getting a heart reduction surgery email, there is enough of those already. Go get them and don't forget us little people. Thanks David Wilf PMP -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Thursday, March 12, 2009 3:36 PM To: cf-jobs-talk Subject: Thinking of a career change.. how does one get into Technical Recruiting.. Hey all, Since there's a large number of recruiters on this list, I've been wondering. How does one break into technical recruiting? I've got years of experience as a ColdFusion developer, but it appears that the CF market in NC has dried up. So I'm entertaining the idea of moving into recruiting, but have no idea where to start. Thanks in advance for any replies sas -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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-jobs-talk/message.cfm/messageid:4186 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Thinking of a career change.. how does one get into Technical Recruiting..
Jerry Johnson wrote: Sell your wife, mother, and youngest child. Then have a heart reduction surgery (placing is in a secure storage facility) Rob a whole troop of girlscouts out of their cookie money. Dig a 20 foot hole in a sand trap with a sand wedge. And tell a bar full of Yankee fans that the Red Sox are a better team. Now, add the above items to your resume, and you should be all set. That's a good start. I have yet to find a recruiter or agency that didn't ultimately leave me feeling raped in the end. And that's regardless of whether or not I ultimately got a job through them. I know recruiters are busy and are trying to fill openings. But is it SO freaking hard to treat somebody who has just been DQ'd for whatever reason like a human being? Each and every time I have ever been passed over for a job, the recruiter has stopped answering my emails and/or phone calls. Completely. Not a peep from them ever again UNLESS another opening came up. It's like I'm not worth the five seconds of their time since I'm no longer somebody that could make them money at that instant. What's worse, is that they come off all friendly and helpful and everything at the start... but then, as time passes, they become less involved. Even where I am now... the guy handling my position has yet to EVER call me back to ask how things are going, or to take me to lunch as he repeatedly promised at the start. If I email him, I will get a reply usually within 24 hrs with a short response. If I have a followup question, it never gets answered. And I've been dealing with these lowlifes since the late 90's, so it's not like I've encountered a few bad apples. I firmly believe this to be the norm. I think I would sooner try to sell cars than become a recruiter. Rob ~| 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-jobs-talk/message.cfm/messageid:4189 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Thinking of a career change.. how does one get into Technical Recruiting..
I was (mostly) kidding. But many programmers and tech types do not realize how _hard_ placement folk work to get someone into a job. It seems like free money when you see how much they added to your contracting rate, or how much you hear they get paid per permanent placement, but believe it or not it is a difficult job. You _need_ to divorce personal feelings for each client from the equation. It is easy to get paralyzed with I _need_ a job this week, or I lose my house (my children are sick, my mother-in-law lives with us, etc), but you cannot let it get to you. You need to be able to take 30 rejections in stride, and swing just as hard, with as much patience and professionalism as you did on the first. And you need to be able to In the glory days of the dot com era it was an easy job. (pick one resume at random from column a, match with one job opening from column b, profit!) But companies (for the most part) are much smarter in their hiring. and tech staff are much more skittish after bad experiences. So matchmaking is important if you want any follow on placements. The skillset that makes a good recruiter, in my opinion, are very specific. As Rob mentions below, they need to leave the tech staff feeling decent (even if turned down), need to leave the company feeling good (whether you place a person or not, you still want them to keep your card for next time. Because there will be a next time). You need for your recruiting company to feel you are contributing. And you need to feel pretty good about what you are doing (and how you are doing it) or the smudges on your soul get overwhelming and over time very obvious to others. I don't have the right skills, but I respect the skills in others and can recognize people that do have it all when I meet them. On Thu, Mar 12, 2009 at 5:03 PM, Rich Baker ri...@teaminfo.com wrote: Wow... Probably should have exercised better judgment than in sending that email to the whole group... - To each his own Richard E. Baker | TEAM Information Services ~| 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-jobs-talk/message.cfm/messageid:4190 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Thinking of a career change.. how does one get into Technical Recruiting..
Jerry Johnson wrote: I was (mostly) kidding. But many programmers and tech types do not realize how _hard_ placement folk work to get someone into a job. As a business owner for 10 years, who has never been placed by a recruiter; I think I have a general gist of the amount of work that goes into getting clients and keeping them happy. I don't anticipate that work is much harder than recruiting. I haven't looked for a job in about 10 years and haven't spoken to a recruiter for purposes of job hunts in over 8. Yet, recruiters keep contacting me saying they heard I was looking for a job. They obviously haven't done any research into me and have no idea who I am. They will never tell me where / how they found me or what made them think I was looking for a new job. It's always a vague on the internet. Basically, they are screen scraping my e-mail address somehow and contacting me unsolicited under false pretenses. It makes them spammers in my book. In fairness, I have been contacted by at least one person who found me through my blog or other means and seem genuine in their search and do not make assumptions about my current situation. Those are few and far between, though. -- Jeffry Houser, Technical Entrepreneur Adobe Community Expert: http://tinyurl.com/684b5h http://www.twitter.com/reboog711 | Phone: 203-379-0773 -- Easy to use Interface Components for Flex Developers http://www.flextras.com?c=104 -- http://www.theflexshow.com http://www.jeffryhouser.com -- Part of the DotComIt Brain Trust ~| 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-jobs-talk/message.cfm/messageid:4191 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11