Re: hosting
I vouch for GoDaddy's PHP hosting. I have a couple of PHP projects and happy endings. I am not sure about CF though. Regards, Ravi. On Thu, Jan 14, 2010 at 3:04 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I hear that Scott...I just had to go with GoDaddy because I realty can't afford anything else. Eric -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Thursday, January 14, 2010 8:41 AM To: cf-talk Subject: RE: hosting Ray, I appreciate the sentiment, but right now cheap is all I can do -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Thursday, January 14, 2010 9:20 AM To: cf-talk Subject: Re: hosting Please consider how cheap you want to go. Your host is like the foundation of your business. Would you set up your store on top of a volcano? Quicksand? Cheap isn't always the way you want to go for hosts. On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com wrote: I've used atoz before, and it was just an aweful experience all around. I'd vote no to atoz. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329698 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 and Linux
Hello Raul, I run Linux on my box. I am not sure what your problem is. My cffile writes without a problem with or without accents. Can you send your code through or paste it on pastebin.com? Regards, Ravi. On Fri, 2009-12-04 at 00:34 -0500, Raul Riera wrote: rierar...@gmail.com Ravi Gehlot http://www.ravigehlot.net r...@ravigehlot.net Computer Science Student Computer Programmer ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328853 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 - Purchasing .bm domain names
Adrian, Try a search on Google. Ravi. Adrian Lynch wrote: I'm building a site for a charity in Bermuda and I've told them a great .bm domain name is available. Can anyone recommend a place to buy such domain names. I've done all my purchases through 123-reg.co.uk up until now. I've sent an email to bermudanic.bm but have not heard back from them yet. I'm mainly wondering about price. Thanks and sorry for the OT. Adrian ~| 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:321958 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 - Purchasing .bm domain names
http://www.101domains.com/ Adrian Lynch wrote: You know after nine years doing this web stuff, that never occurred to me! I've done that, I've seen prices over $200. Short of hearing back from bermudanic.bm, I was hoping someone out there would know of a place that has them cheaper or if that's the going rate for one. My fault for not stating this in the first email I suppose... Adrian -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: 26 April 2009 14:03 To: cf-talk Subject: Re: OT - Purchasing .bm domain names Adrian, Try a search on Google. Ravi. Adrian Lynch wrote: I'm building a site for a charity in Bermuda and I've told them a great .bm domain name is available. Can anyone recommend a place to buy such domain names. I've done all my purchases through 123-reg.co.uk up until now. I've sent an email to bermudanic.bm but have not heard back from them yet. I'm mainly wondering about price. Thanks and sorry for the OT. Adrian ~| 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:321960 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 - Purchasing .bm domain names
Hello Adrian, Registering domains outside of our jurisdiction may not be an easy process. You must be familiar with a countries policy in registering TLDs. For example, in order for someone to register a domain in Brazil, they must have Brazilian documentation and in some instances you may even need to have a company established in Brazil. I am not sure about Bermuda. I am also not sure how 101domains manages to get around and register domains from other countries. I would do a research before proceeding with registration just to make sure that you will have full access to your newly purchased domain in the future. Make sure to read the policies with your registrar and understand what they are doing. Just because you may be able to buy a domain for a different country does NOT mean that you may own all rights to it. Ravi. Adrian Lynch wrote: Thanks Ravi, I'd seen that site already, $350 for a year seems a bit much. Maybe that's the going rate though. Adrian -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: 26 April 2009 14:40 To: cf-talk Subject: Re: OT - Purchasing .bm domain names http://www.101domains.com/ Adrian Lynch wrote: You know after nine years doing this web stuff, that never occurred to me! I've done that, I've seen prices over $200. Short of hearing back from bermudanic.bm, I was hoping someone out there would know of a place that has them cheaper or if that's the going rate for one. My fault for not stating this in the first email I suppose... Adrian -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: 26 April 2009 14:03 To: cf-talk Subject: Re: OT - Purchasing .bm domain names Adrian, Try a search on Google. Ravi. Adrian Lynch wrote: I'm building a site for a charity in Bermuda and I've told them a great .bm domain name is available. Can anyone recommend a place to buy such domain names. I've done all my purchases through 123-reg.co.uk up until now. I've sent an email to bermudanic.bm but have not heard back from them yet. I'm mainly wondering about price. Thanks and sorry for the OT. Adrian ~| 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:321963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best ways to find projects
You are welcome. Ravi. Anirudh Apsingekar wrote: Ravi and Everyone, Thanks for all the inputs and knowledge sharing.I really liked the way people express their views here even i am one of those like other people out there in Sales and Business Development.I always love to meet new people and understand what every one is talking which helps in me in the growth of my career. to be honest i joined browse this to find some new opportunities or projects after seeing this discussion i felt that's not all i want to build my network which gives me more knowledge. I follow one thing Knowledge is the prime factor and working honestly with commitment after all this, money flows by its own means. Regards, Anirudh. Evoke Technologies. anir...@evoketechnologies.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-jobs-talk/message.cfm/messageid:4234 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: How do you get motivated at work?
My way of keeping motivated is to make money while I code. Money is a big motivator. It keeps one happy and motivated to take the next step. Just my $0.02, Ravi. Larry Lyons wrote: After writing CFC's after CFC's, CFM's after CFM's, what are things that really motivate you at work? my blog entry of the day: http://henrylearnstorock.blogspot. com/2009/03/how-do-you-get-motivated-at-work.html I like to use short intellectual diversions, such as plotting to take over the world, collapse the financial system, etc. Seriously though I have a picture of my 4 year old daughter beside my monitor, that's a great motivator. I also use other sorts of coding and design to keep things varied, Java, CSS, etc., as well as looking at other areas not necessarily directly related to coding, such as cognitive and perceptual psychology. regards, larry ~| 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:320799 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..
http://www.foxnews.com/politics/2009/03/19/economy-slumps-firms-line-hire-skilled-foreign-workers/ Aaron Rouse wrote: Or even themselves for the long run but in the shortrun it will make the stock holders happy. On Mon, Mar 16, 2009 at 12:43 PM, Jeffry Houser j...@farcryfly.com wrote: RobG wrote: I like Ravi's positive outlook, but I have to somewhat disagree and say that there are lots of companies that will, without hesitation, do what's best for them, regardless of how loyal you've been or how hard you've worked. If it is a publicly traded company, it is illegal (in the US) to do anything else. The only responsibility the company has is to its shareholders. It is not uncommon for companies to change or do things that are not in the best interests of their employees, partners, or customers. -- 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:4230 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..
Hello Jeffry, I hear that a lotI believe that there is good and bad everywhere. In my opinion, if you are really good and you do your job honestly, no matter who you are (native or foreigner), that you will get paid fairly and you will not be treated as servants (not sure about other countries). Be it a foreigner or a native, it does not really matter anymore. It may have mattered in the past but not anymore. I do not believe that foreigners are taking away the jobs natives can do (I refer to computer related jobs). I believe that natives are choosing the best work force for their current needs. Do I think that it is somewhat harder for foreigners than it is for natives? Yes. I do think that it is but this is a country of opportunity. The kind of opportunity that you will never find elsewhere. So I would take any hardness that I find here for a chance to better myself. H1B Visas are HARDLY being issued (so I hear). Its almost unheard of these days. Either you come here on a student visa (I-20 co-op program) or you better have a Green Card. H1B Visas can cost a LOT of money to companies and it is ONLY worth in exceptional cases. I heard about a company that brought this Chinese dude that was phenomenal. He could do virtually anything you can imagine. He was one of a kind programmer...very smart...later got admitted at MIT and today if I am not mistaken he works for NASA. The company sponsored his Green Card and everything. Only those kind of people are getting H1B Visas these days (so I heard). It is very selective these days. My sister is a Canadian citizen and she was telling me about Canadian immigration laws the other day. She told me that in order for anyone to enter Canada that they need to be qualified. The Canadians have a score system. You need to have a certain score in order to enter Canada. So for example, if you have a bachelors degree you automatically get more points. If you have a valid work history then that also counts towards your score. This way only the qualified people get in. What I love about Canada is that once they filtered everyone, they make it easy for you to get the Canadian citizenship. Forget about this bullshit of Green Card. There are no talks about foreigners being servants in Canadians (so I hear). I just think that we should implement some type of score system or qualification measurement so to only let those who are qualified into the country. Indeed, make it easy for newcomers to get their Green Cards. woww...OK! I gotta work now...got carried away...anyways...cya Ravi. http://ravigehlot.wordpress.com/ Jeffry Houser wrote: Personally I'd rather have smart people being brought into this country than them being sent elsewhere. I believe having intelligent people here it is a good long-term strategy for making this country better; no matter where they were born. I understand that many of the criticisms of such programs, such as H1B Visa, is that companies are bringing in foreigners to jobs that native USA-residents are qualified to do; and the workers brought in are treated as indenture servants. I do not know enough about said programs to tell whether that is a valid concern of a bunch of FUD. ~| 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:4212 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..
Hello Rob, I agree with you. Companies will always do whats best for them no matter what. This is the nature of capitalism. One should never take anything for granted especially in this ever changing field of work. Ravi. RobG wrote: I like Ravi's positive outlook, but I have to somewhat disagree and say that there are lots of companies that will, without hesitation, do what's best for them, regardless of how loyal you've been or how hard you've worked. It's up to you to keep your eyes open, so if you see it happening, you can react accordingly. A few years ago, I had taken a remote job with a company out of San Diego. They were a computer hardware/software reseller similar to CDW (but it was NOT CDW). I was one of four developers, only one of which worked on-site. The company flew us all out and we had a great time for the week meeting each other, going over systems, making plans, etc, etc, etc, while listening to the CEO and his right-hand-man make promises for the future. A few months later, my job got cut because they decided to cut one of the four developer positions and outsource that position to CHINA. They could get TEN chinese developers for what they were paying me (which wasn't much to begin with). When I spoke to the CEO's right-hand-man about this, and the promises made while we were all in San Diego, he said, hey, it's business. Nice. I've kept in touch with some of the people there, and as we all figured, the outsourcing came back to bite them in the ass, and I've even seen them advertise for developers on cf-jobs. So I guess the bottom line is this... NEVER take anybody's word unless it's in writing, and even then, doubt it. 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:4219 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..
Hello Aaron, You are right. There are outsourced jobs in Brazil as there are their own created jobs. This is what I meant to say. I also know of a Brazilian guy that has been working for a company in the US while living in Brazil. But he tells me that his job is somewhat vulnerable. Usually companies prefer to have work force on-site. Ravi. Aaron Rouse wrote: From what I gathered last week it is not just within their boarders. Like I mentioned someone here is already looking into outsourcing work to an outfit out of Brazil. About 7 years ago I worked on a project here that was with a Brazilian. Shared an office with him for about a year before he moved back and he has been working remotely from there ever since. On Mon, Mar 16, 2009 at 10:57 AM, Ravi Gehlot r...@ravigehlot.net wrote: Hello Aaron, Right. I read that on the Washington Post the other day. I heard that Brazil has had an increase in tech jobs and more people are employed there these days. However, their jobs are not so much outsourced jobs from other countries but jobs created within their boundaries. Not sure how that's working though. Brazil is investing big bucks on education. They are creating more private schools than they ever created before which is good. Hopefully in years to come there will be more qualified Brazilians and more research coming from there. I have lived and worked in Brazil, Portugal, Canada and US. I have never experienced a market as aggressive as the US market. You work a lot here and you stress a lot. They take the milk out of you here. There is nothing like a laid back job in the US but we get remunerated and we learn a lot. The more the demand, the more one works and researches. Indeed, you become a better employee you are always going something here. Ravi. ~| 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:4220 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..
Just my $0.02 cents...I think that recruiters do help one get a job. Yes, most recruiters are all about business but who is not? They try to get you in and if they can not then they go on to the next one. This is just the nature of their business. They gotta make it work and in order to make it work they have to move fast and find the right candidate for the right position. That's fine. However, what I do not agree with is the fact that most of these recruiters are extremely friendly at first and then it all changes afterwards. I have heard this from most programmers. This is not just coming from me. Also, if they can not get you the job that they have been trying to then they also vanish without a trace (this does not apply to all recruiters). They don't even send you an e-mail to say go look for a new opportunity. I mean, it only takes 5 seconds right? I took 1 week of my time to talk to you and you do not have 5 seconds to say...Hey, it did not work but maybe next time? AlsoI had one recruiter call me every 2 weeks to have me rely information about the company hiring procedures. He wanted to know if anyone was being hired directly by the company instead of his recruiting company. SoI try not to be on either side..I am neutral. But man...you come to me to ask me questions but when I go to you to ask you questions you just ignore me? What kind of recruiter-to-programmer relationship is that? This is not an attack on recruiters. My experience with recruiting companies is OK. Will I work with recruiters in the future. YES. Everybody is entitled to making mistakes right? I am sure they also have a lot to tell about programmers too. This is just my $0.02 cents, Ravi. 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. 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:4192 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..
Correct. There are good recruiters as there are bad ones. There are good and bad everywhere. So it is important to work with someone that you trust. Every programmer must do their own research. Ravi. Scott Stewart wrote: I've worked with both, if I do go down this road I know who I don't want to be and that the guy who recruits by attrition. I've been the recipient of the fishing email and phone calls dozens of times, and it's never panned out. Someone with horribly broken English calls about a job half way across the country and my first response is are they considering telecommuters, the answer is usually no, or what?. My next question is is your client willing to contract a relocation company to move myself and my wife and buy our house. The answer again is usually no, and then they ask if I'm willing to rent an apartment wherever the job is, my answer is always no, because by this point, their asking me to take a financial loss to work for their client. On the other hand there are a handful of recruiters with whom I have had very very successful relationships with, and one in particular who has become a pretty good friend.. why, because they're honest stand up people who look at prospective employment candidates as something more than just an email address or a means to fulfill US State Department guidelines, to bring in H1B Visas candidates. -- 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:4202 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..
Qasim, There is no problem with H1B Visas. I have no clue why Scott mentioned it. Who cares... Ravi. Qasim Rasheed wrote: What's wrong with H1B visa if used appropriately. I came to this country based on that facility and have been able to become a permanent citizen. On Fri, Mar 13, 2009 at 3:07 PM, Ravi Gehlot r...@ravigehlot.net wrote: Correct. There are good recruiters as there are bad ones. There are good and bad everywhere. So it is important to work with someone that you trust. Every programmer must do their own research. Ravi. Scott Stewart wrote: I've worked with both, if I do go down this road I know who I don't want to be and that the guy who recruits by attrition. I've been the recipient of the fishing email and phone calls dozens of times, and it's never panned out. Someone with horribly broken English calls about a job half way across the country and my first response is are they considering telecommuters, the answer is usually no, or what?. My next question is is your client willing to contract a relocation company to move myself and my wife and buy our house. The answer again is usually no, and then they ask if I'm willing to rent an apartment wherever the job is, my answer is always no, because by this point, their asking me to take a financial loss to work for their client. On the other hand there are a handful of recruiters with whom I have had very very successful relationships with, and one in particular who has become a pretty good friend.. why, because they're honest stand up people who look at prospective employment candidates as something more than just an email address or a means to fulfill US State Department guidelines, to bring in H1B Visas candidates. -- 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:4205 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..
Scott, I have always been a Green Card holder so I am not familiar with other visas. I can't give you a formed opinion on this onesorry Ravi. Scott Stewart wrote: Ravi, I mentioned it because the way that I understand the program to work is that you have to provide proof to the State Department that you attempted to hire a citizen for the position. All that's required is a stack of resumes, and someone to say that they weren't right for the job. I feel like many of the fishnet recruiters are collecting resumes for the sole purpose of providing that proof. IE: there is no intent to actually attempt to hire a citizen for the position. I could be wrong about how the program works, but this is how it was explained to me a few years ago. -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: Friday, March 13, 2009 4:42 PM To: cf-jobs-talk Subject: Re: Thinking of a career change.. how does one get into Technical Recruiting.. Qasim, There is no problem with H1B Visas. I have no clue why Scott mentioned it. Who cares... Ravi. Qasim Rasheed wrote: What's wrong with H1B visa if used appropriately. I came to this country based on that facility and have been able to become a permanent citizen. On Fri, Mar 13, 2009 at 3:07 PM, Ravi Gehlot r...@ravigehlot.net wrote: Correct. There are good recruiters as there are bad ones. There are good and bad everywhere. So it is important to work with someone that you trust. Every programmer must do their own research. Ravi. Scott Stewart wrote: I've worked with both, if I do go down this road I know who I don't want to be and that the guy who recruits by attrition. I've been the recipient of the fishing email and phone calls dozens of times, and it's never panned out. Someone with horribly broken English calls about a job half way across the country and my first response is are they considering telecommuters, the answer is usually no, or what?. My next question is is your client willing to contract a relocation company to move myself and my wife and buy our house. The answer again is usually no, and then they ask if I'm willing to rent an apartment wherever the job is, my answer is always no, because by this point, their asking me to take a financial loss to work for their client. On the other hand there are a handful of recruiters with whom I have had very very successful relationships with, and one in particular who has become a pretty good friend.. why, because they're honest stand up people who look at prospective employment candidates as something more than just an email address or a means to fulfill US State Department guidelines, to bring in H1B Visas candidates. -- 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:4207 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: Best ways to find projects
I have experienced the same here especially with IT. But since I like programming more, I kind of drifted away from the whole IT scene. But you are correct, word of the mouth is also a good selling point. Great you mentioned it. Ravi. Jacob wrote: Word of mouth... I been in IT for 14 years now. 100% of my side jobs are word of mouth. Sometimes, I have to turn down side jobs because I have too many. People start mentioning my name to other people and it snowballs from there -Original Message- From: Jenny [mailto:jenn...@jennysplace.org] Sent: Monday, December 22, 2008 4:59 PM To: cf-jobs-talk Subject: Best ways to find projects Having seen replies as expected regarding on line project sites, I'd be interested in hearing about everyone's most popular/successful way of finding projects. I currently get some work through my web site www.fasttrackonline.co.uk, but not nearly as much as i would like to see. Traffic to my site has also reduced considerably since the economic downturn, so I need to find other routes to landing projects. I'd also very much appreciate any feedback on the web site. Thanks in advance, Jenny ~| 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:4163 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
We Do Three Types of Jobs Here
At times, I get requests from people wanting me to build websites for them. Such websites range from a simple layout, in css without any server side scripting, to complex websites like those of social networks. These same people want the work to be done in an unbelievably short amount of time and with little to no budget. So I kept thinking on how to approach these people and explain this would cost time and money to deliver quality work. In turn, the old saying A picture is worth a thousand words comes to mind and this picture surely explains my feelings towards this situation. Check it out: * http://tinyurl.com/humorFreelance *Ravi.* * ~| 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:4165 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: We Do Three Types of Jobs Here...
Vicky, I wasn't able to find the presentation but I did find the notes of a person(http://www.philduba.com/index.cfm/2008/6/21/CFUnited--Changing-the-Game) who attended it. Here are his notes from the presentation Changing the Games by Helms. - Concentrating only on your rates = commoditizing yourself, at least without adding value and/or establishing relationships - Acquiring a new customer costs 6 times as much as keeping one - put the best interests of clients first, even if it isn't in your immediate best interests - message you put out is the types of clients you will attract (ie., if you say you build what is wanted and are cheap, those are the types of clients you will get) - build a portfolio before going off on own, take on jobs you have no problem referring future clients too - look deeper when responding to potential clients, keep their interests at heart - keep up to date on competition across the client's industry to see if there are other ideas that may be applicable to a client's needs or other things the competitors do not have - get as much information about a client as you can before meeting with them - remember that to a business person, software is expensive and risky. ideally, you need to develop a process and/or methodology that helps to mitigate the risk - Great comment from the audience: customers want programs done good, cheap, and quick and that most can only achieve two of the three - help to define the risk about the project, make the customer realize what could go wrong. it makes you stand out and differentiates yourself from others - goal is to be not just a commodity developer or coder, but become someone they can rely on that has their interests in heart Ravi. Vicky wrote: Hal Helms Clark Valberg gave a good preso at ColdFusion United called Changing the Game. It was about how to win more profitable work. The materials may still be on the CF United 2008 website, if not on Hal's own site/blog. It was very interesting and worthwhile. On Tue, Dec 23, 2008 at 12:19 PM, Ravi Gehlot r...@ravigehlot.net wrote: At times, I get requests from people wanting me to build websites for them. Such websites range from a simple layout, in css without any server side scripting, to complex websites like those of social networks. These same people want the work to be done in an unbelievably short amount of time and with little to no budget. So I kept thinking on how to approach these people and explain this would cost time and money to deliver quality work. In turn, the old saying A picture is worth a thousand words comes to mind and this picture surely explains my feelings towards this situation. Check it out: * http://tinyurl.com/humorFreelance *Ravi.* * ~| 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:4167 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: CF Job Market
Hello Adam, I couldn't agree more with you. Ravi. Adam Reynolds wrote: Or better still learn Flex/Air. Look at upcoming technologies where the number of skilled individuals is low. Don't go down the I'll learn Java route because honestly you need 3+ years commercial experience. Ravi Gehlot wrote: Dave, As we all know the economy is not doing so well. It does not matter how much one can say that it is unfair to blame the economy (as I have heard) but there have been many job cuts. Many programmers are out of their jobs because either companies are afraid to expand or just don't have the money to hire more work force. So there are fewer jobs and there will be even more cuts as the next president tries to fix this mess that the current president left (lets not get into politics here). I will give you an example, about 2 to 3 years ago, I used to search for CF jobs on monster.com and I would often get impressed with the amount of available positions that that search used to return. It felt like employers were seeking candidates at all times and everywhere. If you try to do a search now, you will not get many jobs. You try to contact the fewer ones left and they are already interviewing 3 to 5 other candidates for that spot. Here is what I recommend you. Do not get stuck with just one language. Regardless of its popularity, try to learn another skill. For instance, for as much as people complain that PHP is nothing but a mess, it is the one that offers the most jobs. If you know PHP really well chances are that you will find a job somewhere or even an outsourced position (Yes, people also outsource jobs to the U.S.). I am have been trying to learn Ruby and PHP. Why not? Always remember: Don't let others say you can't do just because they can't do it Good Luck, Ravi Gehlot. Hi all, My job will be ending sometime next year due to a merger. I'm a Senior level CF Developer with 10+ years experience. I am wondering what the job market is looking like out there for us senior type CF developers with the economy the way it is here in the US. What I'm concerned about most that I see is more job descriptions asking for mid-level and junior developers, and lower salaries for those as well. I'm wondering if I might have trouble finding a job when the time comes because my salary demands would be too high and/or the employer would rather pay someone a lower salary for less experience, thinking they are getting the same efficiency. Please share whatever your thoughts are on this topic. I think this thread will be useful for anyone visiting it in the next 12-18 months, so let's really try to provide some good 'intel', if you will on the 'near future' CF market. Thanks! Dave Phillips ~| 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:4145 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: Best ways to find projects
Jenny, There are many ways to attract potential clients/projects. But freelancing has its drawbacks as you might already know. I prefer a job over freelancing because I get benefits and a steady pay. But back to your question, in order for you to get more clients/projects you need to build your presence on the Internet. It was a great idea of yours to start your own business website. That's a great start but it will not attract people(clients/projects) if it is not being advertised somehow. So try to market your name or your business name (Fast Track Online). For instance, your name(Jenny Gavin-Wear) is very powerful. Try to build a BLOG and give people what they want. They want quality articles that they can learn a bunch from. Try to get a domain name after your name and build a BLOG. Thats where you will post articles and people will read about it. If you can do that, you can build traffic. If you can build traffic that trusts your information, you can build prospects that may hire you later on. Take for instance my BLOG at http://www.ravigehlot.net/ . I have been getting about 500 visits daily just because I wrote 1 good article on SVN. My BLOG has only been around for 3 weeks and it is already getting some attention. Yesterday, I had a guy from France pay me $200 dollars to step up SVN for him. While, $200 dollars is not a lot of money, if more people ask me to do the same then it will great. So blogging is one way to draw more projects/client. However, bear in mind, put your heart into your blog. I mean, do it with attention to detail not just to try to make money. Do it because you can have fun with it too. My BLOG is sort of diary where I keep everything I have been looking at lately. Try to get on Social News networks like Digg, DZone, Delicious, StumbleUpon, Reddit. Also try to get on Social Networks like Facebook, Twitter, LinkedIn, MySpace and Hi5. You will network with people that share yours interests and they may need your services in the future. Another way to draw more prospects is to try to rank well on the search engines. This falls back on Search Optimization Techniques but being able to be found on search engines is not enough. More and more people are not reading text. What they is to experience and try your services. So for Fast Track Online, you should try to build demo sites and stuff that you have been doing. People will want to go back there to test a feature you have done. Not to read the text. The text is good for search engines to find you. Good Luck, Ravi Gehlot Jenny wrote: Having seen replies as expected regarding on line project sites, I'd be interested in hearing about everyone's most popular/successful way of finding projects. I currently get some work through my web site www.fasttrackonline.co.uk, but not nearly as much as i would like to see. Traffic to my site has also reduced considerably since the economic downturn, so I need to find other routes to landing projects. I'd also very much appreciate any feedback on the web site. Thanks in advance, Jenny ~| 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:4155 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: On line project site
Dave, True. I heard about Guru.com as well. I think Guru.com has more long-term projects with better opportunities for pay. But I was heard that it is hard to get work there. Ravi. Dave Phillips wrote: Guru.com was good for me a few years ago. Some clients post projects looking for US only coders and therefore are willing to pay a normal hourly range. I picked up a client that I kept for about 2 years until she stopped doing the business. Dave -Original Message- From: C. Hatton Humphrey [mailto:chumph...@gmail.com] Sent: Monday, December 22, 2008 8:02 PM To: cf-jobs-talk Subject: Re: On line project site I got one project on Rent-a-Coder that was less than encouraging. Maybe it was my lack of experience in managing client expectations at the time or maybe it was what this particular client had dealt with (and gotten away with) in the past but I ended up terminating the project before completion. ~| 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:4157 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: CF Job Market
Dave, As we all know the economy is not doing so well. It does not matter how much one can say that it is unfair to blame the economy (as I have heard) but there have been many job cuts. Many programmers are out of their jobs because either companies are afraid to expand or just don't have the money to hire more work force. So there are fewer jobs and there will be even more cuts as the next president tries to fix this mess that the current president left (lets not get into politics here). I will give you an example, about 2 to 3 years ago, I used to search for CF jobs on monster.com and I would often get impressed with the amount of available positions that that search used to return. It felt like employers were seeking candidates at all times and everywhere. If you try to do a search now, you will not get many jobs. You try to contact the fewer ones left and they are already interviewing 3 to 5 other candidates for that spot. Here is what I recommend you. Do not get stuck with just one language. Regardless of its popularity, try to learn another skill. For instance, for as much as people complain that PHP is nothing but a mess, it is the one that offers the most jobs. If you know PHP really well chances are that you will find a job somewhere or even an outsourced position (Yes, people also outsource jobs to the U.S.). I am have been trying to learn Ruby and PHP. Why not? Always remember: Don't let others say you can't do just because they can't do it Good Luck, Ravi Gehlot. Hi all, My job will be ending sometime next year due to a merger. I'm a Senior level CF Developer with 10+ years experience. I am wondering what the job market is looking like out there for us senior type CF developers with the economy the way it is here in the US. What I'm concerned about most that I see is more job descriptions asking for mid-level and junior developers, and lower salaries for those as well. I'm wondering if I might have trouble finding a job when the time comes because my salary demands would be too high and/or the employer would rather pay someone a lower salary for less experience, thinking they are getting the same efficiency. Please share whatever your thoughts are on this topic. I think this thread will be useful for anyone visiting it in the next 12-18 months, so let's really try to provide some good 'intel', if you will on the 'near future' CF market. Thanks! Dave Phillips ~| 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:4143 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: CF-based freelancer time/billing system?
I also tried it out and it is neat. I haven't seen anything that simple, complete and yet sofisticated. great job. Ravi Gehlot. J.J. Merrick wrote: +1003 for freshbooks. They hve a great time tracker and i LOVE their invoicing stuff. Support is some of the best in the biz. ~| 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:317016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element SESSIONTIMEOUT is undefined in APPLICATION.
Richard, You can define your variables outside the onApplicationStart method. However, they will not be on the application scope. Usually, what I do, I set my DSN with the method onApplicationStart and then I set this.name = 'ModelGolfLLC'; this.applicationTimeOut = createTimeSpan(0,1,0,0); this.clientManagement = 'Yes'; this.loginStorage = 'session'; this.sessionManagement = 'Yes'; this.sessionTimeOut = createTimeSpan(0,0,60,0); this.setClientCookies = 'Yes'; this.setDomainCookies = 'No'; this.scriptProtect = 'all'; all of these variables outside the method and this way it works. Ravi Gehlot. Richard White wrote: hi, we worked out it was because the variables where being defined outside the onapplication start method and of course must be inside richard Hi we had a working version of coldfusion application on one site, and another working version of coldfusion on a sub domain of that site. We swapped these version over and now one of the applications is producing the error: Element SESSIONTIMEOUT is undefined in APPLICATION. does anyone know what the cause of this may be? thanks richard ~| 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:316964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IT IS TOTALLY possible to skip js with cfif
Hello, I didn't follow this thread closely. But I am curious as to what you guys were discussing. How would I customize my webserver settings so that .js files are parsed by CF and why would I want to do that? I know that JS files are only text files and as far as I know there aren't any special settings to parse it. Ravi Gehlot. Robert Harrison wrote: You cannot do it if you have the script in a .js file. Not with a default install... You can do that however if you customize your webserver settings so that .js files are parsed by CF. That's interesting. I didn't know that, but I'm still not sure I'd want to do that. Seems like there might be some performance issues having CF parse all the .js files. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:316967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IT IS TOTALLY possible to skip js with cfif
Ian, Excellent explanation. You could not have been more clear. However, can you provide me with instructions in how to accomplish this? So CF will process the request and spit HTML with a html extension? Thanks, Ravi. Ian Skinner wrote: Ravi Gehlot wrote: Hello, I didn't follow this thread closely. But I am curious as to what you guys were discussing. How would I customize my webserver settings so that .js files are parsed by CF and why would I want to do that? I know that JS files are only text files and as far as I know there aren't any special settings to parse it. It is possible to configure the web server and the ColdFusion application server to pass *any* file to ColdFusion for processing other then the default normal, cfm, cfc, cfr, etc file extensions. This is sometimes done so that ColdFusion processes normal htm|html files, usually for server obscurification, i.e. to hide that the server is making use of ColdFusion. It can also be done to preserve established links to an older html site that is converted to cfml. It would be rather unusual to do this for JavaScript files, but it is technically possible. The benefit is that you could have linked JavaScript files dynamically built with CFML. The downside is that it interferes with normal browser caching of linked script and|or style files, the same thing can be done with CSS files. Sometimes it is worth the trade off and|or there are ways to mitigate the downside with cfheaders... etc. ~| 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:316985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IT IS TOTALLY possible to skip js with cfif
Ian, You did shed a light. I appreciate it. Thanks, Ravi Gehlot Ian Skinner wrote: Ravi Gehlot wrote: Ian, Excellent explanation. You could not have been more clear. However, can you provide me with instructions in how to accomplish this? So CF will process the request and spit HTML with a html extension? Thanks, Ravi. Sorry, not me personally. I have never actually had the need to do this. I have just read about it and keep the possibility in the back of my mind if the need should ever arise. I know there are Adobe knowledge base and blog articles out there that lay out the process. That is where I have read about it in the past. It is a bit more involved in the Java based MX versions of ColdFusion then it was back in the pre-MX days. A few more settings that need to be tweaked to tell the web server to pass the desired files to ColdFusion and to have ColdFusion understand that it is supposed to do something with such files. ~| 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:317004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: finding dynamic form fields after submission
Scott, What is the widget called? Ravi. Scott Stewart wrote: Hey all, I have a form with one of those wonderful dynamic ad form row widgets. Because of this I never will know exactly what fields will be sent for processing... the original four fields in the row are called play, po, role, and year, the javascript generates play1, po1, role1 and year1 or 2, or 3 ad Infinitum based on how many rows the user has selected. on the processing side I need to write the form field values to a structure because there will be credit card processing before I write to the database. How can I loop over the form structure and find the dynamically generated form fields and their values. ~| 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:317005 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 32bit or 64bit, that is the question.
Hello Pete, It is interesting that you mentioned about the 64-bit ODBC drivers. I was thinking about moving my server to a 64-bit platform. So I have been asking around what people think of ColdFusion running on a 64-bit platform. Most people say that it is faster especially if you have lots of RAM memory. Which makes a lot of sense since RAM memory makes a big difference. But these people have not complained about any of the functionality of CF8 on a 64-bit. I would think that CF8 for 64-bit would have everything that the CF8 for 32-bit has including all the ODBC drivers. What do you mean by lack of drivers? Wouldn't those drivers come with CF8? Please excuse my ignorance if any, Ravi. Pete Ruckelshaus wrote: The only downside I've experienced so far with running CF64 on my 64-bit Vista workstation is the lack of 64 bit ODBC drivers for Excel and Access. Not something that would normally concern someone building enterprise-level apps, but in my case, I was using Access as a front end to a CSV file for some data import routines. Pete ~| 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:316890 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 32bit or 64bit, that is the question.
Hello Dave, I had suspected that. But thanks for making it clear. Ravi Gehlot. Dave Watts wrote: I would think that CF8 for 64-bit would have everything that the CF8 for 32-bit has including all the ODBC drivers. What do you mean by lack of drivers? Wouldn't those drivers come with CF8? CF doesn't provide ODBC drivers at all. Those are provided by the operating system. CF provides an ODBC-JDBC bridge, which lets you use those drivers from CF. 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:316901 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Slightly OT - JVM memory usage
Hello Craig, You will need an utility for monitoring and troubleshooting ColdFusion application. If you can see how you server is processing request in real time then you can tell what is going on. Try SeeFusion from http://www.seefusion.com/ Good Luck, Ravi Gehlot. Craigsell wrote: It's more than just varring or cfc's -- i know we have issues with that but not to the extent where 1gb of memory is consumed in no time flat. Problem is this is a corporate box -- lots of developers at varying levels of experience with thousands of pages. I can't tell what the heck is causing the problem since I don't know what the memory breakdown is. This is running on Windows 2003 server. ~| 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:316907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Slightly OT - JVM memory usage
Craig, Take a look on their demo version at http://www.seefusion.com/index.cfm?do=c.livedemo They let you monitor Thread usage and memory load. Ravi Gehlot Craigsell wrote: We've been having a problem with our cfmx7 server. Something is grabbing all the memory and refusing to release it. The memory just spikes right up and sticks. The only way we have been able to fix this is to restart. We are trying to use FusionReactor to figure out the cause but so far unsuccessfully. There are a lot of developers and code on this box any one of which could be causing the problem. Does anyone know of a tool we can use to show memory usage versus thread ? If we can isolate the thread, then we stand a chance of finding the cause. Warren Koch ~| 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:316908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Slightly OT - JVM memory usage
Craig, I think that SeeFusion has it broken down by thread. I might be mistaken as to what you mean by Thread in actuality but if you look at the demo it says there on the label Thread for Active Requests. It then shows you the file name asked by the request. Correct me if I am wrong. Ravi Gehlot. Craigsell wrote: We are running Jrun version 4. Our plan is to try and tune the JVM -- it needs it. We have folks who specialize in that and will be bringing them on board as soon as they are available. Immediate problem is whatever is grabbing the memory is not releasing it so the GC can clean it up. Or the GC is ignoring it. Exactly right - uncontrolled queries, etc. can all kill memory. I've been watching the server with FusionReactor, have seen some of those issues, and was able to get them fixed since it was obvious what thread was causing it. Once I know the thread, I can find the developer and get the code changed. What we need is some way to figure out excatly what memory is being allocated where so when the memory pegs and holds (I'm talking forever), we stand a shot at diagnosing the problem -- otherwise it is like finding a needle in a haystick. FusionReactor is SeeFusion on steriods. Problem is that Fusion Reactor monitors memory utilization but does not break it down by individual thread. From what I've seen of SeeFusion -- i don't think it does either. What I'm trying to accomplish is to enhance our current monitoring capability with another cheap tool so we can identify the immediate issue and possibly prevent it from occuring in the future by making it available on our development instance. ~| 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:316912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simply Amin Panel
Hello Steve, You want to update and not insert if you want to replace the text. Good Luck, Ravi Gehlot. Steve LaBadie wrote: I created a simple (I thought) admin panel to update specific text on a page. But to my surprise when I update the text it adds it at the end instead of replacing the existing text. Not sure what I need to do so it adds and deletes existing text. This is the panel code: cfset CurrentPage=GetFileFromPath(GetTemplatePath()) cfif IsDefined(FORM.MM_InsertRecord) AND FORM.MM_InsertRecord EQ frmAddAlert cfquery datasource=text INSERT INTO alert (alert) VALUES ( cfif IsDefined(FORM.alert) AND #FORM.alert# NEQ '#FORM.alert#' cfelse NULL /cfif ) /cfquery cflocation url=../../status1.cfm?msg=Alert+Title+added+successfully. /cfif form action=cfoutput#CurrentPage#/cfoutput method=post name=frmalert id=frmAddAlert textarea name=alert cols=70 rows=10 id=alert class=formveld/textarea input name=Reset type=reset id=Reset value= Reset class=formveldnbsp;input name=Submit type=submit id=Submit value= Submit class=formveld input type=hidden name=MM_InsertRecord value=frmAddAlert /form This is the insertion page code: cfquery name=GetAlert datasource=text SELECT * FROM alert /cfquery cfoutput query=GetAlert#GetAlert.alert#/cfoutput Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu slaba...@po-box.esu.edu ~| 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:316916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simply Amin Panel
Hello Steve, Set your table to accept NULL and wrap your cfquery around with a cfif. This way, you will only run the query if you need to. You will save unnecessary trips to the database if there is no value being passed by the form variable. Example: cfparam name=FORM.alert default= / cfif len(FORM.alert) cfquery name=qryUpdate datasource=text update alert set alert = '#FORM.alert#' where alert = '#FORM.alert#' /cfquery cflocation url=../../status1.cfm?msg=succeed. cfelse cflocation url=../../status1.cfm?msg=fail. /cfif Also, make sure your method is set to POST on your form in order for the form variables to be passed correctly. Also, your table will not update if alert is not equal to FORM.alert. Ravi Gehlot. Steve LaBadie wrote: Is this correct? I am not getting any errors, but the updated text is not showing on the page. cfquery datasource=text UPDATE alert SET alert = 'cfif IsDefined(FORM.alert) AND #FORM.alert# NEQ ' WHERE alert = '#FORM.alert#'; cfelse NULL /cfif /cfquery cflocation url=../../status1.cfm?msg=Alert+Title+added+successfully. /cfif Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu slaba...@po-box.esu.edu -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: Thursday, December 18, 2008 1:59 PM To: cf-talk Subject: Re: Simply Amin Panel Hello Steve, You want to update and not insert if you want to replace the text. Good Luck, Ravi Gehlot. ~| 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:316928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simply Amin Panel
Steve...just for your information. It is good practice and almost imperative for your to use cfqueryparam with your cfquery to avoid sql injection attacks. This is a security measure that you should start getting yourself in the habit of doing it. Also, once you get this query to update, look into cftry and cfcatch. Every time you make a trip to the database, you are better off having a cftry/cfcatch around your cfquery to catch on possible errors. It makes life easier when you need to debug. For now, I know you are trying to get this work but once you do get this query to work, get back at me and I will show you some error handling and security tips for your query. Ravi Gehlot. Ravi Gehlot wrote: Hello Steve, Set your table to accept NULL and wrap your cfquery around with a cfif. This way, you will only run the query if you need to. You will save unnecessary trips to the database if there is no value being passed by the form variable. Example: cfparam name=FORM.alert default= / cfif len(FORM.alert) cfquery name=qryUpdate datasource=text update alert set alert = '#FORM.alert#' where alert = '#FORM.alert#' /cfquery cflocation url=../../status1.cfm?msg=succeed. cfelse cflocation url=../../status1.cfm?msg=fail. /cfif Also, make sure your method is set to POST on your form in order for the form variables to be passed correctly. Also, your table will not update if alert is not equal to FORM.alert. Ravi Gehlot. ~| 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:316930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simply Amin Panel
Hello Robert, I mentioned that he set the value on the database side to default to NULL so even if nothing is passed it defaults to NULL. It is also a good practice to default the value to NULL since NULL has no value/spaces and it is less likely to cause an error. Thanks, Ravi Gehlot. Robert Bailey wrote: But it seems like what he is doing is if the form value is blank, he wants to make the database value null, not skip processing. Thanks! Robert Bailey ~| 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:316931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simply Amin Panel
Robert, You are right. If you default the value to NULL on the database, NULL only comes into play when you first create a record. So you are correct when you say that he can pass an empty string and it will be empty and not NULL on the database. What you are saying is that the query should run anyways because might want to just wipe out what he has on the database opposed to inserting some other string or number. With the code I had before, he would only run the query if he had value length which makes it impossible to update it with an empty value. Good Thought, Ravi Gehlot. Robert Bailey wrote: Ravi, He can use an empty string '' if he does not want to use a NULL. Your suggestion, to set the database to default to NULL would only apply if he was doing an INSERT. Now think about this What if the alert (in the database) was Help Me Now he is on his form, he deletes help me to be empty in the text field, and he wants this change to be reflected in the database. With what you are suggesting, it will remain Help Me if he wipes it out of the text field (or whatever he is using) since it would not update. Thanks! Robert Bailey ~| 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:316935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simply Amin Panel
Steve, Before you can update the database you need a match. What I mean by a match is that you need to pass an ID to your query that matches that of the record you wish to update. Example: cfif isDefined(alertId) and len(form.alert) cfquery name=qryUpdate datasource=text update alert set alert = '#FORM.alert#' where alertId = '#FORM.alertId#' /cfquery /cfif form name=updateForm method=post action=thisFile.cfm AlertId: input type=text name=alertId value= /br /br / Alert: input type=text name=alert value= /br /br / input type=submit value=submit / /form On the alertId text field, you will pass the Id that corresponds that of the primary key of the row you wish to update on the database. So look at your database and try to find the row you need to update. Let's say that the row number is number 4. So you type number 4 on the form for AlertId field. Then type some text for the Alert field and hit submit. This should work without a problem. Ravi. Steve LaBadie wrote: Sorry Ravi no dice. This should be a simple thing to do. There are no errors when the page loads and no update to the DB. ~| 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:316936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF-based freelancer time/billing system?
Jason, If you do *not* have a lot people to manage then I would say try Basecamp to manage your projects and use Paypal for your invoicing. Back in 2004 when I used to have my own business, I would use Basecamp for my project management and then I would invoice people through Paypal. Paypal has a pre built template for invoicing and it e-mails it to the person. If you do have a lot of people to manage then you might be looking at something more complete. This kind of system is not hard to develop. If you wish to develop something like this let me know. Ravi Gehlot. Jason Durham wrote: I'm looking for an inexpensive tool to keep track of time logs for side work. Specifically, I'd like to be able to setup automated billing and allow the customer to view progress on their project. Google landed me on ProWorkFlow.com which seems to fit the bill, however it might be a little more than I need. 5GB of storage at $200 a month is excessive, IMO. Are there any other less expensive (or open source) projects out there? 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:316941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Browsing files and directories on the server?
Wil, That's great. However, can you make the cftree show all subdirectories? Ravi. Wil Genovese wrote: If you dig into the cfform world there is cftree and cftreeitem. This can be built and is used in the Coldfusion Adminitrator cfdirectory action=list directory=/var/www/dev/wil/src name=webroot sort=asc recurse=true cfform action= cftree name=myfiles lookandfeel=metal format=flash width=300 cftreeitem value=name query=webroot queryAsRoot=yes img=folder,document /cftree /cfform Wil Genovese Sr. Web Application Developer On Wed, Dec 17, 2008 at 8:51 AM, Ravi Gehlot r...@ravigehlot.net wrote: Hello Pete, You will be better off with using a Java management applet of some kind. If you do a search on Google, you may find some free applets. You can also achieve it with cfdirectory and AJAX but it will be time consuming since you gotta make it work cross platform and watch out for security issues. The Java applets run on the Java runtime engine and are cross platform compatible with a fair amount of security. Good Luck, Ravi. Mike Chabot wrote: This would be a relatively common feature that many developers have implemented. I would guess that the manual or the Ben Forta book has sample code in the cfdirectory chapter. There is a file explorer in cfadmin on the screen where you apply CF updates, although it uses a Java applet. Plenty of Ajax solutions are on the Web. Often HTML text area editor controls (like FCKeditor) have file explorers with them to allow for inserting images into the HTML, but these would likely be overkill to what you are asking for. -Mike Chabot On Tue, Dec 16, 2008 at 9:44 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I need to create an interface that will allow a user to browse directories and files in a specific path on the server, preferably with an Explorer-style interface. Anyone here done such a thing? Thanks, Pete ~| 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:316868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse Show Line Numbers
Hello Phillip, 1) Locate the workspace directory for your projects 2) On your workspace directory, there is a subdirectory called .metadata 3) Go to *.metadata\.plugins\org.eclipse.core.runtime\.settings\org.cfeclipse.cfml.prefs *4) If org.cfeclipse.cfml.prefs is not present, go ahead and create it 5) insert lineNumberRuler = true I found that the plugin XML Buddy tends to mess up CFEclipse. I think that the two don't really go together. Ravi. * * Phillip Molaro wrote: My CFEclipse doesn't have the show line numbers option. My General- Editor panel does, and it's turned on, but in CFEclipse- Editor I do NOT have a line numbers option. I am running version 1.3.2 beta as a plugin into standard Eclipse. ~| 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:316872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Browsing files and directories on the server?
Hello Pete, You will be better off with using a Java management applet of some kind. If you do a search on Google, you may find some free applets. You can also achieve it with cfdirectory and AJAX but it will be time consuming since you gotta make it work cross platform and watch out for security issues. The Java applets run on the Java runtime engine and are cross platform compatible with a fair amount of security. Good Luck, Ravi. Mike Chabot wrote: This would be a relatively common feature that many developers have implemented. I would guess that the manual or the Ben Forta book has sample code in the cfdirectory chapter. There is a file explorer in cfadmin on the screen where you apply CF updates, although it uses a Java applet. Plenty of Ajax solutions are on the Web. Often HTML text area editor controls (like FCKeditor) have file explorers with them to allow for inserting images into the HTML, but these would likely be overkill to what you are asking for. -Mike Chabot On Tue, Dec 16, 2008 at 9:44 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I need to create an interface that will allow a user to browse directories and files in a specific path on the server, preferably with an Explorer-style interface. Anyone here done such a thing? Thanks, Pete ~| 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:316862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Browsing files and directories on the server?
Hello Wil, This was a question originally asked by someone else but I took interest in it. I will try to come up with the solution to show subdirectories. But thanks for mentioning cftree. Ravi Gehlot. Wil Genovese wrote: I suppose I could, but that would require me to read the cfdocs and experiment. Which at this point is really what you should be doing since it will benefit you far more than me. Wil Genovese On Wed, Dec 17, 2008 at 9:49 AM, Ravi Gehlot r...@ravigehlot.net wrote: Wil, That's great. However, can you make the cftree show all subdirectories? Ravi. Wil Genovese wrote: If you dig into the cfform world there is cftree and cftreeitem. This can be built and is used in the Coldfusion Adminitrator cfdirectory action=list directory=/var/www/dev/wil/src name=webroot sort=asc recurse=true cfform action= cftree name=myfiles lookandfeel=metal format=flash width=300 cftreeitem value=name query=webroot queryAsRoot=yes img=folder,document /cftree /cfform Wil Genovese Sr. Web Application Developer On Wed, Dec 17, 2008 at 8:51 AM, Ravi Gehlot r...@ravigehlot.net wrote: Hello Pete, You will be better off with using a Java management applet of some kind. If you do a search on Google, you may find some free applets. You can also achieve it with cfdirectory and AJAX but it will be time consuming since you gotta make it work cross platform and watch out for security issues. The Java applets run on the Java runtime engine and are cross platform compatible with a fair amount of security. Good Luck, Ravi. Mike Chabot wrote: This would be a relatively common feature that many developers have implemented. I would guess that the manual or the Ben Forta book has sample code in the cfdirectory chapter. There is a file explorer in cfadmin on the screen where you apply CF updates, although it uses a Java applet. Plenty of Ajax solutions are on the Web. Often HTML text area editor controls (like FCKeditor) have file explorers with them to allow for inserting images into the HTML, but these would likely be overkill to what you are asking for. -Mike Chabot On Tue, Dec 16, 2008 at 9:44 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I need to create an interface that will allow a user to browse directories and files in a specific path on the server, preferably with an Explorer-style interface. Anyone here done such a thing? Thanks, Pete ~| 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:316878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF / Javascript question
Jenny, Great question. It is not really easy to accomplish what you have in mind. I understand that you want the user to scroll down in order to show a button for continue. Dzone.com has a great example of how you can scroll down using javascript. If you can get the position where it stops, perhaps you can pass that as an argument to enable your button. I am not sure how to do it though. This is just my thought. Check this article for more information: http://www.jaisenmathai.com/blog/2008/02/18/eliminate-paging-results-by-using-javascript-ala-dzone/ Just my $0.02 cents, Ravi. Jenny Gavin-Wear wrote: Hi all, In a registration procedure, I need to do a verification that the person registering has read a large piece of text. The way I thought about doing is is with a scrolling div area which enables a continue to next page option when the user has scrolled to the bottom of the text. How could I best go about this using CF and/or javascript, please? Grateful for any ideas ... Jenny ~| 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:316866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CTO Opportunity
Just my $0.02 cents. Aaron, The problem begins when you try to find a job while still on a job. If your boss finds out that you are indeed on the look out for a new opportunity then it may sparkle misunderstandings and misconceptions. I had a friend once that did really well on his project and he had gotten bonuses and all the good stuff. The contract was at its final stage and he needed to make more money because his wife was pregnant with twins. It so happens that he sent an e-mail to a mailing list of which his boss was also a subscriber. The e-mail had information about his skills, a link for his resume and that he was looking for a new opportunity to make more money. His resume was open to the public.. His boss called him 5 minutes after he sent that e-mail and cursed him to death saying that it was unethical to say that my friend was not well paid after all the bonuses and everything. It sparkled so much trouble that he got out of the company. Indeed, my friend had done his job well. The project had been 95% delivered and he was looking for a better opportunity. With his wife pregnant, it was a perfect time to look for a new chance to make more money. Instead, because of a misunderstanding with having his public resume open to the public, he ended in a bad situation. His boss later told him that it will be harder to find programmers because people may think that he does not pay well. Whih in part, is true. Just my $0.02 cents, Ravi. On Fri, 2008-09-26 at 14:56 -0500, Aaron Rouse wrote: What is so wrong with having publicly viewable resumes? I come across people's personal websites all the time that have that. I could understand how maybe having them viewable to lord and everyone else and containing perhaps a home address might be a mistake. On Fri, Sep 26, 2008 at 2:53 PM, Phillip M. Vector [EMAIL PROTECTED] wrote: I know and I'm sorry Adam. I meant that as a private message to you as well. As for permissions, you can set your document to only be readable by certain people. He can put in the email of the person who he wants to see it and block out everyone else. Heh.. Yes, I do see the irony of not cutting and pasting your email when you forgot as well. Again, I'm sorry. Levi Wallach wrote: It's pretty obvious this was a goof on Adam's part by just hitting reply rather than copying in the original sender's email address. This happens to everyone and there's no reason to call attention to it - I'm sure Adam is already embarrassed and perhaps a little concerned that his current employer might see the message. I don't understand what you mean by permissions. It has nothing to do with permissions, just a mistake that all of us make from time to time, to varying degrees of consequence... From: Phillip M. Vector [EMAIL PROTECTED] Sent: Friday, September 26, 2008 3:42 PM To: cf-jobs-talk Subject: Re: CTO Opportunity Perhaps putting your resume online for all to see isn't the smartest idea. Was this intended as a reply to the person? If so, I'd recommend you check out the permissions setting. ~| 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:4019 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: Junior to Intermediate CF Developer (Greater Toronto Area)
Hi Virginia, I have lived in the United States for about 9 years and I am a green card holder. How hard would it be to sponsor a VISA to work in Canada? Thanks, R.G. On Fri, 2008-09-26 at 14:23 -0400, [EMAIL PROTECTED] wrote: I am working with a client in the Greater Toronto Area that is looking for a Junior or Intermediate Coldfusion 8 developer (CF 7 is alright as well) with solid Oracle 9i or 10g experience. Minimum 2 years experience. Other desirables: -javascript -CSS This company designs webpgages and applications for SMBs and first tier healthcare companies. If you like working in a small environment (team size is approximately 10), multi-task, and would like the opportunity to grow your skills, then please contact me. This position is full time and will pay up to 60K, however, depending on how strong one is, they are willing to pay more. They want to hire the selected candidate by the end of next week (Oct 3/08). Contact information: w: 416-225-5599 x 297 c: 416-432-2807 [EMAIL PROTECTED] Virginia Davidson Professional Placement Consultant Manpower Professional 4950 Yonge Street, Suite 706 Toronto, Ontario M2N 6K1 T: 416-225-5599 x297 F: 416-225-9096 C: 416-432-2807 [EMAIL PROTECTED] www.manpowerprofessional.ca This e-mail and its attachments may contain Manpower Inc. proprietary information, which is PRIVILEGED, CONFIDENTIAL, or subject to COPYRIGHT belonging to Manpower Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this e-mail is STRICTLY PROHIBITED and may be UNLAWFUL. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. Thank you. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ~| 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:4026 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: NEGATIVE COMMENTS RE: FLASH ARCHITECT POSITION IN TX
I am not sure what Mr. Vincent is trying to accomplish by sending these kind of e-mails but I can talk for my own experience. I have worked with recruiting companys like Robert Half Technology, Signature Consulting, TekSystems, AppleOne among others and all I have to say to the recruiters is THANK YOU. They went out of their way to help me get a job. Besides they were patient enough to help me get my resume right. They even spoke in my behalf to work a deal and they sure did their job well. Up to this day I have good friends in the recruiting business. People that take me not only as a professional but also as a collegue and partner. If someone had a bad experience with recruiting companys then fine. There is always 2 sides of a coin but do not come on a mailing list saying all kind of nonsense about people that actually tried to help you out when you needed the most. You never know. Thanks, RG. On Thu, Jul 3, 2008 at 1:37 PM, Andrea Skinner [EMAIL PROTECTED] wrote: As most of the professional users of this site know, there are always 2 sides to every story. This site is to be used for professionals looking for work. As many of you have seen, this is not the first negative post from this individual. Slanderous comments posted are definitely considered negative by future employees and candidates seeking new opportunities. This should be taken in account by the individual posting the negative comments that are only half-truths. Aptude has been in business for many years and the individuals that own and operate the company have several years of industry experience. - Original Message - From: Vincent Cannady [EMAIL PROTECTED] To: CF-Jobs-Talk cf-jobs-talk@houseoffusion.com Sent: Thursday, July 03, 2008 12:05 PM Subject: re:Watchout for this job FLASH ARCHITECT POSITION IN TX That was the whole point Scott, To tell the truth to people who might not take the time to email or even read this message. I am a man of courage and honor. I don't lie or hide behind my woman's skirts. So if a company does not want me because I told the truth about a bad experience with another company who was soliciting my fellow IT Professionals then I do not want to work for them. Since there are no shortage of work and the fact that I usually do not take contracts of this site anyway because of things just like this, I don't have to worry about work. And hey if you dragged your family 600 Miles and 10 hours of driving for a company that did not set up the interview right then maybe you would not care if some other fly by the seat of their pants company decides you are not what they want then that is just fine. I have enough telecommute work that I don't have to apply to any of these contracts unless I know the employer, had a friend who worked for them, or the recruiter is from a company like TekSystems, Matrix, RHT, or Yoh IT . These are companies big enough that mistakes don't cost ME $500 and if they do make them THEY PAY FOR IT not me!!! Thanks for the Input Scott but I knew what I was doing when I posted my horror story. Beside if it is bad enough to post about then it is bad enough to tell the whole truth and nothing but the truth, So help me God(hand on Bible)! -Original Message- From: cf-jobs-talk [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2008 12:00 PM To: cf-jobs-talk Subject: ColdFusion Jobs Talk (CF-Jobs-Talk): Digest every 2 hours ColdFusion Jobs Talk (CF-Jobs-Talk) 03-Jul-08 Issue:362 In this issue: Watchout for this job FLASH ARCHITECT POSITION IN TX Watchout for this job FLASH ARCHITECT POSITION IN TX ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3897 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: Senior CF Developer - Designer Available Now
Can you please post any future FLEX and ColdFusion jobs also at: http://groups.google.com/group/adogo-jobs . Thanks, RG. On Tue, Jul 1, 2008 at 11:42 AM, Stephen Hoskins [EMAIL PROTECTED] wrote: I am seeking a FT telecommute position as ColdFusion Developer. Having 10 years of programming experience, I am capable of entry into any phase of a project, whether it be from conception through QA or from QA through launch, as well as various aspects of work including: migrations, schema development/enhancement, code revision, documentation, graphical design and user-interface framework. I have experience as Lead Designer, Lead Developer and Project Manager. I hold a BFA and have worked with all formats of multimedia. Scripting I have used: ColdFusion, HTML, DHTML, Java, Javascript, SQL, Actionscript 3, ASP, ASP.NET http://asp.net/, C# and probably a few more over the years... I am adept with Adobe Creative Suite products, hand coding, Eclipse, Server set-up, Access, SQL Server, some Oracle. I have created e-commerce solutions, goverment intranet and public sites and marketing websites and online systems. Having telecommuted for the past few years and would prefer to telecommute, travel is fine. Please find resume and contact information at http://www.Andonia.comhttp://www.andonia.com/ Stephen Hoskins [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3890 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: freelance web developer
Hello, I am interested in your job position but first I would like to know what the compensation is then we could talk further. I am available for 20 hours a week. Can you send me a job description in more details? I have been programming in ColdFusion for almost 3 years now. I feel pretty comfortable working with HTML, CSS, ColdFusion, Fusebox, JavaScript and also XML. Will wait on your response to send you my resume. Ravi. On Fri, May 16, 2008 at 3:49 PM, site mgt [EMAIL PROTECTED] wrote: Hello, Looking for a U.S. based freelance CF programmer to work offsite for an e-commerce company by telecommuting. Individual must be able to contribute at least 20 hours a week. Developer should have experience working with CF8 thru CF5. Developer must feel comfortable working with legacy code. Knowledge of procedural and OO programming is a plus. Developer should have strong MSSQL skills. Experience with payment gateways such as Google checkout and PayFlow Pro is also a plus. Knowledge of XML and SQL 2005 is helpful as well. Looking for someone who will document their work and be able to work with a team of programmers if necessary. Must understand the concept of developing sustainable applications that can be maintained by other individuals if necessary. If you know how to build applications that scale and perform well under load your services are needed. Development environment need to be CF ECLIPSE and Subversion for version control. Please reply with your credentials ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3770 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: freelance web developer
Hey Phillip, Please accept my apologizes. I made a mistake. Should have e-mailed that person not the list. Ravi. On Sat, May 17, 2008 at 11:22 AM, Phillip M. Vector [EMAIL PROTECTED] wrote: Hey Ravi... Few things.. 1) You are responding on the talk list.. Not the Jobs list.. 2) Emails like this should be sent directly to the client. 3) Asking for the rate of pay before giving your resume is... tacky IMHO. [BWW] Ravi Gehlot wrote: Hello, I am interested in your job position but first I would like to know what the compensation is then we could talk further. I am available for 20 hours a week. Can you send me a job description in more details? I have been programming in ColdFusion for almost 3 years now. I feel pretty comfortable working with HTML, CSS, ColdFusion, Fusebox, JavaScript and also XML. Will wait on your response to send you my resume. Ravi. On Fri, May 16, 2008 at 3:49 PM, site mgt [EMAIL PROTECTED] wrote: Hello, Looking for a U.S. based freelance CF programmer to work offsite for an e-commerce company by telecommuting. Individual must be able to contribute at least 20 hours a week. Developer should have experience working with CF8 thru CF5. Developer must feel comfortable working with legacy code. Knowledge of procedural and OO programming is a plus. Developer should have strong MSSQL skills. Experience with payment gateways such as Google checkout and PayFlow Pro is also a plus. Knowledge of XML and SQL 2005 is helpful as well. Looking for someone who will document their work and be able to work with a team of programmers if necessary. Must understand the concept of developing sustainable applications that can be maintained by other individuals if necessary. If you know how to build applications that scale and perform well under load your services are needed. Development environment need to be CF ECLIPSE and Subversion for version control. Please reply with your credentials ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3772 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: Spry Eclipse Plugin?
Where do I get JSDT? Rav. On Sat, May 10, 2008 at 5:54 AM, denstar [EMAIL PROTECTED] wrote: 3.4 hasn't been released yet, but it's getting close. I've been using 3.4M6 ( http://phoenix.eclipse.org/packages/ ), the EE package, and it's wonderful. Some great improvements have been made in many places. I think cfeclipse needs to be installed as a drop in, which is the new way of installing plugins the old way (much cleaner). Holler if you've got any questions. There's a link for equinox somewhere around here (the new plugin update manager). denstar On Fri, May 9, 2008 at 9:01 PM, Gerald Guido [EMAIL PROTECTED] wrote: And Eclipse 3.4 has a WYSIWYG HTML editor, for those pesky table-based layouts. @denstar Could you point me to that wonderful nugget of joy? With that, CF studio will become just another text editor (though awesome). I think the only other thing I use it for is the change tag case feature... G On Fri, May 9, 2008 at 8:18 PM, denstar [EMAIL PROTECTED] wrote: On Fri, Apr 27, 2007 at 8:30 PM, Aaron Roberson [EMAIL PROTECTED] wrote: Really, are we throwing the baby (DW) out with the bathwater (commercial license)? Nope. Eclipse just plain destroys dreamweaver, from a coder's perspective. I'm liking JSDT for Eclipse javascript development. W00t3rZ! And Eclipse 3.4 has a WYSIWYG HTML editor, for those pesky table-based layouts. But, no, there is no question in my mind, Eclipse is where it's at. Even if both were free (as in beer) and open, I'd be using Eclipse. Denny ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Country/City/Province List for DB import
Thanks Richard. On Wed, Apr 30, 2008 at 12:52 PM, Richard Dillman [EMAIL PROTECTED] wrote: theirs an sql script at http://forums.asp.net/t/1045550.aspx appears to have all countries and provinces/states for Canada, US, and UK On 4/30/08, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question has already been asked and I unfortunately I lost my bookmarks and now I am here asking it again. What's that website with the list of country/cities to import to the database? Someone had passed through a FREE site with a complete list of countries/cities with link to download it. I had used that to add it to one of my databases. Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Business Venture
I am interested in starting my own business once again doing hosting but the main goal here is to have a server in which we have total access and own it. Also, the goal is to focus on web development rather than hosting. The person(s) interested in the venture should be able to come up with money as well. The server cost, the monthly cost and also a license for ColdFusion. We could stick with Linux for the time being using Webmin as the web panel. Is anyone interested in the venture? You can email me at [EMAIL PROTECTED] Ravi -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304581 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Business Venture
Sorry...you are right. My bad! Ravi. On Thu, May 1, 2008 at 11:01 AM, Bryan Stevenson [EMAIL PROTECTED] wrote: Wow is this the wrong place to post that message!! - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Thu, 2008-05-01 at 10:53 -0400, [STS] Ravi Gehlot wrote: I am interested in starting my own business once again doing hosting but the main goal here is to have a server in which we have total access and own it. Also, the goal is to focus on web development rather than hosting. The person(s) interested in the venture should be able to come up with money as well. The server cost, the monthly cost and also a license for ColdFusion. We could stick with Linux for the time being using Webmin as the web panel. Is anyone interested in the venture? You can email me at [EMAIL PROTECTED] Ravi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Country/City/Province List for DB import
I know this question has already been asked and I unfortunately I lost my bookmarks and now I am here asking it again. What's that website with the list of country/cities to import to the database? Someone had passed through a FREE site with a complete list of countries/cities with link to download it. I had used that to add it to one of my databases. Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: getex replace
Thanks Bobby! Ravi. On Fri, Apr 18, 2008 at 9:31 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: #replace(str, '#char(13)##chr(10)#memberUserName', '|memberUserName', 'all')# -Or- #replace(str, '#char(13)##chr(10)##char(13)##chr(10)#', '|', 'all')# With 18,000 blocks... you are bound to run into some data discrepancies so look it over well. And for the love of god... if you are feeding that list back to CF... use an array of structures or something instead of a list :-) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: [STS] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Thursday, April 17, 2008 8:22 PM To: CF-Talk Subject: getex replace I have a list I obtained from export ldap members out of a ldap directory in LDIF format that looks like this: memberUserName: John Doe memberAge: 34 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Mary Doe memberAge: 44 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Jack Doe memberAge: 86 memberLocation: US memberEmail: [EMAIL PROTECTED] I need to import this list of almost 18,000 members onto an SQL database. So what I want to do is to convert this LDIF file into one big list pipe delimited, then loop through it and add it to the database. So I got: 1) File is read cffile action=read variable=cffileRead file=#expandPath(/imports/testList.ldif)# / 2) Replace all new lines for commas cfset newLine = chr(13) chr(10) / cfset commaList = replace(cffileRead, newLine, ',', 'All' / Question here: How do I replace all EMPTY (BLANK LINES) like the ones between memberUserName for pipes? Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303800 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
getex replace
I have a list I obtained from export ldap members out of a ldap directory in LDIF format that looks like this: memberUserName: John Doe memberAge: 34 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Mary Doe memberAge: 44 memberLocation: US memberEmail: [EMAIL PROTECTED] memberUserName: Jack Doe memberAge: 86 memberLocation: US memberEmail: [EMAIL PROTECTED] I need to import this list of almost 18,000 members onto an SQL database. So what I want to do is to convert this LDIF file into one big list pipe delimited, then loop through it and add it to the database. So I got: 1) File is read cffile action=read variable=cffileRead file=#expandPath(/imports/testList.ldif)# / 2) Replace all new lines for commas cfset newLine = chr(13) chr(10) / cfset commaList = replace(cffileRead, newLine, ',', 'All' / Question here: How do I replace all EMPTY (BLANK LINES) like the ones between memberUserName for pipes? Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfhttp stopped working, anyone experienced this
Cool. On Thu, Apr 17, 2008 at 5:39 PM, Scott Mulholland [EMAIL PROTECTED] wrote: Trapping it just showed me it was a connection timeout. Oddly (or not) a reboot seems to have fixed this. -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 8:05 PM To: CF-Talk Subject: Re: cfhttp stopped working, anyone experienced this are you happy with the URL being used, if it is being generated dynamically it may be malformed or incorrect. Is it in a cf try? Also, try dumping CFHTTP after the call - it will have a status code and other info that my help On Wed, Apr 16, 2008 at 9:03 PM, Scott Mulholland [EMAIL PROTECTED] wrote: Yes on the browse, yes on the ping, I have an inquiry in on the firewall settings. -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 3:18 AM To: CF-Talk Subject: Re: cfhttp stopped working, anyone experienced this if you log onto the server, can you browse to the URL? Can you ping the domain? Have firewall settings changed? On Wed, Apr 16, 2008 at 7:05 AM, Scott Mulholland [EMAIL PROTECTED] wrote: I have a piece of code that has always worked that does a cfhttp to create a static file. The file it calls is on the same server/domain. Today the cfhttp just keeps timing out. cfhttp calls to other urls not on the server work without issue though. Anyone else experience anything like this? Thanks, Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfhttp stopped working, anyone experienced this
Try using cfsetting timeout=3600 Ravi. On Wed, Apr 16, 2008 at 9:26 PM, Cutter (CFRelated) [EMAIL PROTECTED] wrote: If you can browse and ping then I doubt your firewall is at fault, unless your calling in a file whose MIME type isn't registered with the firewall. CFHTTP uses port 80 by default. If you can browse it from the server then the port isn't the issue (or the MIME type for that matter). Definitely use a try/catch. Or better, if on CF8, use the step debugger (if not in production and that's an option). Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com AJ Mercer wrote: are you happy with the URL being used, if it is being generated dynamically it may be malformed or incorrect. Is it in a cf try? Also, try dumping CFHTTP after the call - it will have a status code and other info that my help On Wed, Apr 16, 2008 at 9:03 PM, Scott Mulholland [EMAIL PROTECTED] wrote: Yes on the browse, yes on the ping, I have an inquiry in on the firewall settings. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using tags with CFSCRIPT
I found a way to cheat HostMySite's 1 domain per account set up. What this does is it checks the URL for the domain typed and it redirects it to a directory specific for that domain. That way I am able to host all my sites with the CF+ Builder package. My question is...I was about to achieve this with cfswitchcfcase but when I switched it over to a cfscript block I started getting errors. Can anyone tell me where I made a mistake? Before anyone asks...yes...I am sticking with CFSCRIPT. CODE: cfoutput cfscript switch(cgi.http_host) { case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'www.sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com/'); break; case 'sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com/'); break; case 'www.sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologySolutions.com/'); break; case 'sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologySolutions.com/'); break; case 'www.ravigehlot.com':cflocation(theURL:'ravigehlot.com/'); break; case 'ravigehlot.com':cflocation(theURL:'ravigehlot.com/'); break; case 'www.ravigehlot.net':cflocation(theURL:'ravigehlot.net/'); break; case 'ravigehlot.net':cflocation(theURL:'ravigehlot.net/'); break; case 'www.lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'www.falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'www.amadosgest.com':cflocation(theURL:'amadosgest.com'); break; case 'amadosgest.com':cflocation(theURL:'amadosgest.com'); break; default:cflocation(theURL:'76.12.205.99'); } /cfscript /cfoutput Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Scott, You made an excellent observation about CFScript. It does process faster because it reads a whole block instead of reading tag by tag. Well, the code doesn't work because it says that the cflocation is an undefined variable. I have searched Google to find out how to use CFTags with CFScript and it looks like I got the correct syntax. Can you replicate this error? Ravi. On Mon, Apr 14, 2008 at 9:09 AM, Scott Stewart [EMAIL PROTECTED] wrote: Ravi, I know you don't have to surround CFScript tags with CFOutput tags. What errors are you getting. I've used a similar script with HMS hosting. Using CFScript should be a bit faster as CF processes the CFScript block all at once as opposed to processing each tag individually. sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: [STS] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 8:57 AM To: CF-Talk Subject: Using tags with CFSCRIPT I found a way to cheat HostMySite's 1 domain per account set up. What this does is it checks the URL for the domain typed and it redirects it to a directory specific for that domain. That way I am able to host all my sites with the CF+ Builder package. My question is...I was about to achieve this with cfswitchcfcase but when I switched it over to a cfscript block I started getting errors. Can anyone tell me where I made a mistake? Before anyone asks...yes...I am sticking with CFSCRIPT. CODE: cfoutput cfscript switch(cgi.http_host) { case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; case 'www.sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com /'); break; case 'sunshineTechSolutions.com':cflocation(theURL:'sunshineTechSolutions.com/'); break; case 'www.sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologyS olutions.com/' http://olutions.com/%27); break; case 'sunshineTechnologySolutions.com':cflocation(theURL:'sunshineTechnologySolut ions.com/' http://ions.com/%27); break; case 'www.ravigehlot.com':cflocation(theURL:'ravigehlot.com/'http://ravigehlot.com/%27); break; case 'ravigehlot.com':cflocation(theURL:'ravigehlot.com/'http://ravigehlot.com/%27); break; case 'www.ravigehlot.net':cflocation(theURL:'ravigehlot.net/'http://ravigehlot.net/%27); break; case 'ravigehlot.net':cflocation(theURL:'ravigehlot.net/'http://ravigehlot.net/%27); break; case 'www.lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'lookForAStripper.com':cflocation(theURL:'lookForAStripper.com'); break; case 'www.falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'falacidade.com':cflocation(theURL:'falacidade.com'); break; case 'www.amadosgest.com':cflocation(theURL:'amadosgest.com'); break; case 'amadosgest.com':cflocation(theURL:'amadosgest.com'); break; default:cflocation(theURL:'76.12.205.99'); } /cfscript /cfoutput Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Variable CFLOCATION is undefined. The error occurred in C:\Websites\156945dm2\index.cfm: line 4 2 : cfscript 3 : switch(cgi.http_host) { 4 : case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; 5 : 6 : } On Mon, Apr 14, 2008 at 9:13 AM, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: Scott, You made an excellent observation about CFScript. It does process faster because it reads a whole block instead of reading tag by tag. Well, the code doesn't work because it says that the cflocation is an undefined variable. I have searched Google to find out how to use CFTags with CFScript and it looks like I got the correct syntax. Can you replicate this error? Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using tags with CFSCRIPT
Scott, The getPageContext() is more a java function. I didn't want to go that far in. It should work with cflocation though. Ravi. On Mon, Apr 14, 2008 at 9:39 AM, Scott Stewart [EMAIL PROTECTED] wrote: Ravi, I did a quick google search and came up with this getPageContext().forward(/path/page.cfm); or GetPageContext().getResponse().sendRedirect('PageName.cfm') -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: [STS] Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 9:29 AM To: CF-Talk Subject: Re: Using tags with CFSCRIPT Variable CFLOCATION is undefined. The error occurred in C:\Websites\156945dm2\index.cfm: line 4 2 : cfscript 3 : switch(cgi.http_host) { 4 : case 'www.brightWebWorks.com':cflocation(theURL:'brightWebWorks.com/'); break; 5 : 6 : } On Mon, Apr 14, 2008 at 9:13 AM, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: Scott, You made an excellent observation about CFScript. It does process faster because it reads a whole block instead of reading tag by tag. Well, the code doesn't work because it says that the cflocation is an undefined variable. I have searched Google to find out how to use CFTags with CFScript and it looks like I got the correct syntax. Can you replicate this error? Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Hi Dominic, Thank you for clarifying this whole thing. I had done a couple of searches on Google and I didn't read anything about creating an UDF. Obviously creating an UDF for this matter is not necessary when you can use cfswitch and cfcase but for the sake of learning lets say I were to create these UDFs; Where would I place these UDFs so that whenever I needed them I could just call the function? Ravi. On Mon, Apr 14, 2008 at 9:42 AM, Dominic Watson [EMAIL PROTECTED] wrote: Yes, this is the problem: cflocation(theURL:'brightWebWorks.com/') cflocation is a tag, not a function. To do the cflocation from within a cfscript block you will need to create a UDF. I.e. cffunction name=scriptLocation cfargument name=location cfargument name=addToken required=false default=false cflocation url=#arguments.location# addtoken=#arguments.addtoken# /cffunction Then, in your script block: switch(cgi.http_host) { case 'www.brightWebWorks.com': scriptLocation('brightWebWorks.com/'); break; } HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Gotcha, would it be better to put these UDFs in CFCs and then instantiate them on Application.CFC? Ravi. On Mon, Apr 14, 2008 at 10:22 AM, Dominic Watson [EMAIL PROTECTED] wrote: Where would I place these UDFs so that whenever I needed them I could just call the function? Yeh, I often use UDFs for this kind of thing where I want to use cfscript but there is the odd tag I need to use but I doubt you'd ever get a google result for this kind of thing. For UDFs, I usually create a folder in my project called '_udfs' and have a single cfm file for each udf. Then, in the page that needs to use the udf, just include the file. So: cfinclude template=/_udfs/scriptLocation.cfm cfscript switch(cgi.http_host) { case 'www.brightWebWorks.com http://www.brightwebworks.com/': scriptLocation('brightWebWorks.com/'); break; } /cfscript Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using tags with CFSCRIPT
Thanks. This issue is now resolved. Ravi. On Mon, Apr 14, 2008 at 10:35 AM, Dominic Watson [EMAIL PROTECTED] wrote: Gotcha, would it be better to put these UDFs in CFCs and then instantiate them on Application.CFC? I don't think so because then you would have to call them with: myUDFsObject.udfName() As opposed to just: udfName() You could just include all your udfs in application.cfc in OnRequestStart() using a regular cfinclude. Putting the functions in a cfc is perfectly valid though and will work (I just don't like to use cfcs in this way). Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using tags with CFSCRIPT
Hi Raymond, I am just being cheap. But the workaround with cfswitch/case works for now with HMS and it lets me have multiple domains in a shared hosting account. I don't have any hard feelings towards HMS; They have been good to me. But I would imagine that the cheat would only work with IIS validating hostnames. In my case, it doesn't validade letting me use different domains. Weird. Any insights? Ravi. On Mon, Apr 14, 2008 at 12:59 PM, Scott Stewart [EMAIL PROTECTED] wrote: Use cfscript Instead of Three or More cfsets The reason is this: When you use cfscript, the entire block gets sent to the engine at once. So, ColdFusion has to make only one read. When you send three or more cfset statements, ColdFusion gets to interpret them once each, or three times. Therefore, it's faster and cleaner. From: http://www.informit.com/articles/article.aspx?p=24131seqNum=3 Always use cfscript for blocks of variable assignments for values greater than one. It is significantly faster than cfset. Example: cfscript a=1; b=2; c=3; /cfscript Not: cfset a=1 cfset b=2 cfset c=3 http://www.adobe.com/devnet/server_archive/articles/coding_for_performance.h tmlhttp://www.adobe.com/devnet/server_archive/articles/coding_for_performance.html pre-MX6.1 there was a performance gain. Now, if I understand correctly, it all compiles down to the same java bytecode, so there's no performance gain to speak of. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:43908 While it may not be true for CFMX 7 8 it was a documented best practice for CF 5 and back. I've continued to use this method, especially when declaring multiple variables. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 12:11 PM To: CF-Talk Subject: RE: Using tags with CFSCRIPT Using CFScript should be a bit faster as CF processes the CFScript block all at once as opposed to processing each tag individually. I strongly doubt this, and have seen no evidence (load tests) that it's true now, even if it may have been true in the past (which I also doubt). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using tags with CFSCRIPT
Hey Scott, I spoke to a couple of my senior developer friends and they told me that back in the days of CF5 cfscript was faster than tags but that doesn't hold true with CF7 and 8 so it doesn't really matter. I prefer to code in cfscript/cfscript blocks when I do imports...just my way of doing things. Ravi. On Mon, Apr 14, 2008 at 12:59 PM, Scott Stewart [EMAIL PROTECTED] wrote: Use cfscript Instead of Three or More cfsets The reason is this: When you use cfscript, the entire block gets sent to the engine at once. So, ColdFusion has to make only one read. When you send three or more cfset statements, ColdFusion gets to interpret them once each, or three times. Therefore, it's faster and cleaner. From: http://www.informit.com/articles/article.aspx?p=24131seqNum=3 Always use cfscript for blocks of variable assignments for values greater than one. It is significantly faster than cfset. Example: cfscript a=1; b=2; c=3; /cfscript Not: cfset a=1 cfset b=2 cfset c=3 http://www.adobe.com/devnet/server_archive/articles/coding_for_performance.h tmlhttp://www.adobe.com/devnet/server_archive/articles/coding_for_performance.html pre-MX6.1 there was a performance gain. Now, if I understand correctly, it all compiles down to the same java bytecode, so there's no performance gain to speak of. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:43908 While it may not be true for CFMX 7 8 it was a documented best practice for CF 5 and back. I've continued to use this method, especially when declaring multiple variables. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 12:11 PM To: CF-Talk Subject: RE: Using tags with CFSCRIPT Using CFScript should be a bit faster as CF processes the CFScript block all at once as opposed to processing each tag individually. I strongly doubt this, and have seen no evidence (load tests) that it's true now, even if it may have been true in the past (which I also doubt). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:30 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to write this query?
Rick, You can use FROM and immediately use ON. That's why you have a syntax error. ON is used with joins. Ravi. On Sun, Apr 13, 2008 at 7:23 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the reply, Azadi. However, your solution has the same problem I encountered with a regular JOIN statement: the limit 1 part of the interior select statement limited my results to only 1 property with 1 photo, instead of all properties, but only 1 photo each. I tried: select sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price from smlc_acr sa inner join select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap on sa.mls_number = sap.photo_mls_number order by list_price but that gives me this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap ' at line 4 I can't see the error in my syntax. But then, again, I'm not the most experienced join writer, having avoided them when I could. Thanks, again. Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 1:45 AM To: CF-Talk Subject: Re: How to write this query? something like the following (note: mysql syntax): SELECT sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price, SAP_SQ.photo_filename FROM smlc_acr sa INNER JOIN (SELECT photo_filename, photo_mls_number FROM smlc_acr_photos sap WHERE photo_filename '' LIMIT 1) SAP_SQ ON sa.mls_number = SAP_SQ.photo_mls_number ORDER BY sa.list_price Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to write this query?
I meant to say can not Ravi. On Sun, Apr 13, 2008 at 7:30 AM, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: Rick, You can use FROM and immediately use ON. That's why you have a syntax error. ON is used with joins. Ravi. On Sun, Apr 13, 2008 at 7:23 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the reply, Azadi. However, your solution has the same problem I encountered with a regular JOIN statement: the limit 1 part of the interior select statement limited my results to only 1 property with 1 photo, instead of all properties, but only 1 photo each. I tried: select sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price from smlc_acr sa inner join select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap on sa.mls_number = sap.photo_mls_number order by list_price but that gives me this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select sap.photo_filename, sap.photo_mls_number from smlc_acr_photos sap ' at line 4 I can't see the error in my syntax. But then, again, I'm not the most experienced join writer, having avoided them when I could. Thanks, again. Rick -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 1:45 AM To: CF-Talk Subject: Re: How to write this query? something like the following (note: mysql syntax): SELECT sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks_03, sa.list_price, SAP_SQ.photo_filename FROM smlc_acr sa INNER JOIN (SELECT photo_filename, photo_mls_number FROM smlc_acr_photos sap WHERE photo_filename '' LIMIT 1) SAP_SQ ON sa.mls_number = SAP_SQ.photo_mls_number ORDER BY sa.list_price Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: weird issue in browser with cf8 and long execution times
It is weird that it asks you to save the index.cfm file. The only time I had that problem was when IIS was not configured to open CFM files. Same had happened with Apache. But since you are saying that the process are running on the background with data being inserted into the database it makes me think that this is not a problem of adding CFM to IIS/Apache Index Directory. Ravi. On Sun, Apr 13, 2008 at 7:30 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I remember getting that error when trying to complete a long-running cfftp request. It's been awhile, and I'm not sure what actually solved the issue, but I did look back at the file and remember adding cfsetting requesttimeout=6 to the code at the top of the page. Perhaps setting a high requesttimeout will help. If I think of something else, I'll pass it on to you. Rick -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 12:15 AM To: CF-Talk Subject: weird issue in browser with cf8 and long execution times Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFDAP won't retrieve data from Directory
Problem: LDAP program written in ColdFusion WILL NOT retrieve data from a LDAP Directory. Script: cfldap server=127.0.0.1 port=1003 action=query name=results start=ou=Members, o=CompuSport scope=onelevel attributes=cn sort=ou maxrows=100 timeout=2 cfoutput#results.recordCount#/cfoutput Environment: Windows 2000 running a LDAP Directory on port 1003, not in a domain controller, not in an active directory Access: Through Windows 2000 Console Root/Membership Directory Manager done ANONYMOUSLY. Error Message from logs: The request has exceeded the allowable time limit Tag: cfoutput The specific sequence of files included or processed is: C:\ColdFusion8\wwwroot\scripts\ldap.cfm, line: 23 -- -- Ravi Gehlot Web Programmer [EMAIL PROTECTED] United States of America -- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLDAP question
Hey Nate, Thanks for your interest in trying to solve this problem. How do I ping the LDAP with Coldfusion? LDAP Browser and LDAP Administrator can access the LDAP Directory without a problem. Ravi. On Thu, Mar 27, 2008 at 9:59 AM, Nathan Smith [EMAIL PROTECTED] wrote: Can the ColdFusion Server ping the LDAP server/directory machine? Can you access the LDAP information from another machine on the network or the CF server through other tools such as the softerra LDAP browser? -Nate -Original Message- From: Ravi Gehlot [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2008 12:11 PM To: CF-Talk Subject: CFLDAP question I want to express my frustration here by telling all of you that read this post that I have tried this for 3 days without any success. I have an LDAP Directory which is in a remote computer that I have remove desktop access to. This LDAP Directory is in a Windows 2000 operating system that does NOT use domain controllers OR Active Directory. The only information I have is that the LDAP Directory can be accessed by using the Windows 2000 Console Root under Membership Directory Manager. Also. THERE IS NO USERNAME or PASSWORD. IT connects ANONYMOUSLY. Yes. NO LOGIN/PASSWORD. I am trying to retrieve all data from the directory with the following coldfusion code executed on LOCALHOST: cfldap server=127.0.0.1 port=1003 action=query name=results start=ou=Members, o=CompuSport scope=onelevel attributes=cn sort=ou maxrows=100 timeout=2 cfoutput#results.recordCount#/cfoutput Problem IS...it doesn't DO anything. It HANGs forever and it retrieve no Information. The Log files only tell me: The request has exceeded the allowable time limit Tag: cfoutput The specific sequence of files included or processed is: C:\ColdFusion8\wwwroot\scripts\ldap.cfm, line: 23 I am clueless...please help... Ravi. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLDAP question
I want to express my frustration here by telling all of you that read this post that I have tried this for 3 days without any success. I have an LDAP Directory which is in a remote computer that I have remove desktop access to. This LDAP Directory is in a Windows 2000 operating system that does NOT use domain controllers OR Active Directory. The only information I have is that the LDAP Directory can be accessed by using the Windows 2000 Console Root under Membership Directory Manager. Also. THERE IS NO USERNAME or PASSWORD. IT connects ANONYMOUSLY. Yes. NO LOGIN/PASSWORD. I am trying to retrieve all data from the directory with the following coldfusion code executed on LOCALHOST: cfldap server=127.0.0.1 port=1003 action=query name=results start=ou=Members, o=CompuSport scope=onelevel attributes=cn sort=ou maxrows=100 timeout=2 cfoutput#results.recordCount#/cfoutput Problem IS...it doesn't DO anything. It HANGs forever and it retrieve no Information. The Log files only tell me: The request has exceeded the allowable time limit Tag: cfoutput The specific sequence of files included or processed is: C:\ColdFusion8\wwwroot\scripts\ldap.cfm, line: 23 I am clueless...please help... Ravi. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Hey Mike, You are right. But the TRIAL version did the conversion. So thanks to Sean Corfield for pointing that out. However, I am not happy yet. I don't want to use that software, I want to write the XML myself. What is the fun of having a software do the job? I have been doing a lot of reading on XML. Ravi. Mike Kear wrote: Strictly speaking it's not free, but you might already have MS Excel. Later versions can save as XML. If you have such a version, you could read your CSV file in to excel, then save it as XML. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 7/8/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Sean, I never asked you to do my homework. I have always worked for my salary. Sorry to have bother. Thank You. Ravi. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
from CSV to XML
Hi, I was asked to convert a CSV file to XML. Is there free a converter out there? Also, is there a free XML plugin for Eclipse? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: from CSV to XML
Hey Sean, If I use CFHTTP to produce a query from that CSV file what other tool could I use to generate the file. You are completely correct when you say that the question didn't make any sense since with XML we can produce our own tags depending on the type of content structure given. But using CFHTTP to produce the query from the CSV file is quite possible and then having it imported some how in XML format. I never used the CFWDDX tag so will research on that. Also, is XMLBuddy free? Didn't find it for FREE. Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I was asked to convert a CSV file to XML. Is there free a converter out there? Since XML can have any format, that question doesn't really make sense. Conversion of CSV to XML is going to depend on what format XML you want to produce. For example, you *could* use CFHTTP to read in the CSV file as a query and then convert that to simple XML by any number of tricks. Heck, you could use CFWDDX to turn the query into very basic XML but I wouldn't like the output much. Also, is there a free XML plugin for Eclipse? Yes. XML Buddy is the one I use but there may be others. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Cool, so I got the query successfully in the memory. It works just as nice as I thought it would. How do I go about generating the whatever XML I need? YES! Thank you for pointing out XMLBuddy. I downloaded and placed it on my plugins directory and then re-started Eclipse and then XML was immediately available for use. Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: But using CFHTTP to produce the query from the CSV file is quite possible and then having it imported some how in XML format. Once you have a query in memory, you can easily generate whatever XML you need from it in a few lines of CFML. Also, is XMLBuddy free? Yes, That's why I recommended it when you asked for a *free* plugin :) Didn't find it for FREE. Look harder :) -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: from CSV to XML
How could I better answer your question? Could you be more specific? The XML needs to be one that it can be used to import those delimited column fields in the previous XML file. I know you might be thinking...well...why don't they just import it to the SQL database. Well, that's the boss that wants it in XML. He got his reasons. Raiv. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Cool, so I got the query successfully in the memory. It works just as nice as I thought it would. How do I go about generating the whatever XML I need? Well, that depends on the XML you need to generate... -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
from CSV to XML
How could I better answer your question? Could you be more specific? The XML needs to be one that it can be used to import those delimited column fields in the previous CSV file. I know you might be thinking...well...why don't they just import the CSV into the SQL database. Well, that's the boss that wants it in XML. He got his reasons. Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: from CSV to XML
Hey Sean, I never asked you to do my homework. I have always worked for my salary. Sorry to have bother. Thank You. Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: How could I better answer your question? Could you be more specific? No, *you* need to be more specific. XML can be *any* format. Depending on the XML format *you* want, you will have to write code a particular way. Well, that's the boss that wants it in XML. He got his reasons. Then ask the boss what XML format he wants... (BTW, I am not going to do your homework for you... you have to write *some* code to earn your salary, you know!) -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Hey Sean, I will do a little research on the type of XML I need and then will get back at you. As far as tag-wise would use CFWDDX? Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: How could I better answer your question? Could you be more specific? No, *you* need to be more specific. XML can be *any* format. Depending on the XML format *you* want, you will have to write code a particular way. Well, that's the boss that wants it in XML. He got his reasons. Then ask the boss what XML format he wants... (BTW, I am not going to do your homework for you... you have to write *some* code to earn your salary, you know!) -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: from CSV to XML
Hey Dave, Is there a list of specific XML languages? They company has a portal that knows how to treat XML data so it let's the end user upload an XML file that is then imported into a SQL database through their portal. Ravi. Dave Watts wrote: No, *you* need to be more specific. XML can be *any* format. Depending on the XML format *you* want, you will have to write code a particular way. To elaborate on this a little bit, XML isn't a language. Saying you want something in XML doesn't really make sense. What you really want is something in some specific XML language. XML is essentially a meta-language - a set of rules for building a language. You would have to determine the specific XML language you want to use - or create your own - to get where you need to go. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: from CSV to XML
So in this case, the XML type is tables. Correct? After I read the CSV file with CFFILE action set to read, built a query in memory with CFHTTP what would be the next step in building this XML file? Ravi. Claude Schneegans wrote: To elaborate on this a little bit, XML isn't a language. Saying you want something in XML doesn't really make sense. You are right that XML is not a language, it is rather a format, a format able to represent about anything. But Ravi told use he has a CSV file he wants to be formated in XML. For me it is clear: a CSV file is a format to represent a table. A table can be formated in XML, and there are not thousands of ways to represent a table in XML. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Aaron, I want to choose a format and get this done by Monday. They want to see something done by Monday. Whether it will work or not with the Portal I will have to see it with them on Monday. I understand that the Portal understands a type of XML construct and it will brake if another fashion is used. I just want to format it in XML so they know I know what I am doing. Later on Monday, I can adapt it to what it needs to be. There will be a meeting and I will bring this up. It was a piece of work so far to get where I got. First, the CSV file was delimited by pound signs so I had to use the replace function to replace it with commas then to REreplace it to get rid of unwanted spaces. Before this replace could be possible CFDIRECTORY and CFFILE was used to read only CSV type of files. Then CFHTTP was used to read the delimited CSV file and build a query in memory. All I need is to use that query in memory built from CFHTTP to build an XML file. Any suggestions? Ravi. Aaron Rouse wrote: There are a few ways to do this and a simple google search should return them. You still need to know what the format of the XML needs to be in, in order for it to work with the portal. The portal is going to be designed to work with XML laid out in a certain fashion. On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: So in this case, the XML type is tables. Correct? After I read the CSV file with CFFILE action set to read, built a query in memory with CFHTTP what would be the next step in building this XML file? Ravi. Claude Schneegans wrote: To elaborate on this a little bit, XML isn't a language. Saying you want something in XML doesn't really make sense. You are right that XML is not a language, it is rather a format, a format able to represent about anything. But Ravi told use he has a CSV file he wants to be formated in XML. For me it is clear: a CSV file is a format to represent a table. A table can be formated in XML, and there are not thousands of ways to represent a table in XML. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: from CSV to XML
Hey Claude, That helps. Thanks! CFHTTP is already in use. What would WDDX stand for? Just curious...gotta google. it. Ravi. Claude Schneegans wrote: what would be the next step in building this XML file? I would rather try to read the table using CFHTTP to build a query, although CFHTTP will not read ANY CSV format. Then have a look at the tag cfwddx action = CFML2WDDX This would convert the query to a WDDX format which is actually XML-based . -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Hey Sean, Yes, I am a beginner in the ColdFusion world. You shouldn't be worried about providing me the straight solution so that I could get by. If you think that my interest here is to get by using your knowledge then please deviate from this thinking. My sole goal is to learn and become a better programmer. What may seem simple and straight forward for you may not be for others. So I would say don't worry about baking the cake so I can eat it alone. I know how to find my food. Sincerely, Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: It was a piece of work so far to get where I got. First, the CSV file was delimited by pound signs so I had to use the replace function to replace it with commas then to REreplace it to get rid of unwanted You really should check the ColdFusion docs more often. CFHTTP lets you specify the delimiter in the file - it doesn't have to be comma, it could be pound sign. You're just making work for yourself. delimited CSV file and build a query in memory. All I need is to use that query in memory built from CFHTTP to build an XML file. Any suggestions? You're just being lazy. Use Google as others have suggested and several solutions will be evident. Assuming you know how to loop over a query, producing *some* format of XML ought to be trivial for you. The code is so simple that anyone who provides it for you is essentially writing your project for you - hence my comment about your homework. Is it fair to say you are a complete beginner with programming and/or ColdFusion? I ask in all seriousness so that we can establish what level of help is appropriate. So far people have been pretty patient with you but what you're trying to do is extremely simple and you don't seem prepared to do any work on your side to provide more details about what you need from us... -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Hey Sean, Thanks for the patience and thanks for putting the time in showing me how to be a better programmer. Also, I have looked over your BLOG and I have to see you did an awesome job with it. Your last e-mail was printed out and well kept for future consults. Thanks, Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: My sole goal is to learn and become a better programmer. In my first response to you in this thread I suggested CFHTTP and CFWDDX as possible solutions. You can learn and become a better programmer by looking them up in the documentation and seeing whether they fit your needs. That will also tell you what WDDX stands for. I know this seems to belabor the point but the documentation provided with ColdFusion is really very good. The Reference Manual is good for basic stuff like figuring out the attributes on tags but the Developer's Guide is a tremendous resource for learning about many common tasks in ColdFusion. And it's free! It comes with the product. You can also read all the documentation online, either on http://livedocs.adobe.com or http://cfquickdocs.com/ (which a lot of people prefer for reference material). And then there's Google. Let's ask Google: http://www.google.com/search?q=generate+XML+from+coldfusion+query The third response is this one: http://www.developer.be/index.cfm/fuseaction/tutorialDetail/GroupID/71/tutorialName/Generating_XML_with_ColdFusion_-_A_Rough_Guide.htm (watch line wrap on the URL) Let's ask Google a simpler question: http://www.google.com/search?q=convert+CSV+to+XML This is your original question. The number one result is: http://www.stylusstudio.com/csv_to_xml.html# And they have a free trial download: Try Stylus CSV to XML Conversion Utility Download a free trial of our award-winning CSV to XML data integration tool today! Here's the download link: http://www.stylusstudio.com/xml_download.html So, a moment on Google would have gotten you an answer. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Aaron, You are right on that. I will ask them the proper format. It is useless to put time into something and then change it later. Maybe I wasn't clear here but all I want is to know how to do it so that when I get there on Monday it be easier. Thanks, Ravi. Aaron Rouse wrote: Sorry, but I do not think you know how to find your food because the questions you are asking could VERY EASILY be answered via some google searches. If it does not matter if what you do works with the portal or not then just take any of the available web based examples for building XML via CFM and modify the example to work with the data you have via your data file. Of course that makes no sense to do, you should just be able to show the managers the web based examples and prove to them that yes it can be done then ask for more information on how things should be formated so you could then make a working example. On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Sean, Yes, I am a beginner in the ColdFusion world. You shouldn't be worried about providing me the straight solution so that I could get by. If you think that my interest here is to get by using your knowledge then please deviate from this thinking. My sole goal is to learn and become a better programmer. What may seem simple and straight forward for you may not be for others. So I would say don't worry about baking the cake so I can eat it alone. I know how to find my food. Sincerely, Ravi. Sean Corfield wrote: On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: It was a piece of work so far to get where I got. First, the CSV file was delimited by pound signs so I had to use the replace function to replace it with commas then to REreplace it to get rid of unwanted You really should check the ColdFusion docs more often. CFHTTP lets you specify the delimiter in the file - it doesn't have to be comma, it could be pound sign. You're just making work for yourself. delimited CSV file and build a query in memory. All I need is to use that query in memory built from CFHTTP to build an XML file. Any suggestions? You're just being lazy. Use Google as others have suggested and several solutions will be evident. Assuming you know how to loop over a query, producing *some* format of XML ought to be trivial for you. The code is so simple that anyone who provides it for you is essentially writing your project for you - hence my comment about your homework. Is it fair to say you are a complete beginner with programming and/or ColdFusion? I ask in all seriousness so that we can establish what level of help is appropriate. So far people have been pretty patient with you but what you're trying to do is extremely simple and you don't seem prepared to do any work on your side to provide more details about what you need from us... -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Wow! This makes a lot more sense now Dave. So the WDDX from the CFWDDX means the type of XML struct used. Great. Thanks, Ravi. Dave Watts wrote: But Ravi told use he has a CSV file he wants to be formated in XML. For me it is clear: a CSV file is a format to represent a table. A table can be formated in XML, and there are not thousands of ways to represent a table in XML. Sure there are. I can think of several offhand; WDDX, the Query object returned by invoking a SOAP CFC, and the .NET representation of a recordet in XML. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: from CSV to XML
Sean, I have to say THANK YOU! I got the file converted in seconds with the software you indicated me. Now I know what wddx means and I also know how the XML file needs to look like. I won't sleep tonight till I read and learn about XML. Will try the ColdFusion tags also. Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: from CSV to XML
Cool. That's why they say that XML is not a language but a meta-language. Unlike HTML that it has its own tags, XML can have tags created by the developer accordingly by creating DTD or schemas. Ravi. Dave Watts wrote: Is there a list of specific XML languages? No, because anyone can create their own language by creating a DTD or schema. They company has a portal that knows how to treat XML data so it let's the end user upload an XML file that is then imported into a SQL database through their portal. You will need to learn their language. 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! This email has been processed by SmoothZap - www.smoothwall.net ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web Developers soon to be extinct?
They need to start participating in meetings like the CFUnited happening in Washington and soon enough they will change their minds. Ravi. Claude Schneegans wrote: OK, I know everyone is already familiar with the age old argument stirred up once again by the a href=http://www.computerworld.com/action/article.do?command=viewArticleBasicamp;articleId=9020942;recent Computer World article/a There have always been such articles about extinct technologie, even in now extinct magazines, like Byte ;-)) ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Error
Hey Pete, Check to see if your version of access works fine with ColdFusion 7.0.2. Sometimes, you have to download a special driver and install it on your ColdFusion directory so that your datasources may work ok. Just a thought, Ravi. Peter Tanswell wrote: Hi there I have recently installed ColdFusion 7.02 on Windows Vista. It all appeared to be working fine, until I had to go an set up datasource for a microsoft access database. Then I tried setting up a mapping. When I tried both of these I get the following error. IO error on server communication. Basically it doesnt seem to be able to browse to folders on the server. I have googled this and found information on the Adobe website saying I had to make a change to the web.xml file in the web-inf folder. I checked this file and it looked fine. I'm stumped on this one. Just wondering if anyone else might have experienced this problem and if so how they resolved it. I can set up datasource if its a MySQL database. Thanks in advance for feedback. Pete ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server Error
Pete, You can also try to connect to your datasource using a JDBC driver like this: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[Full path to your database file];DriverID22; Ravi. [Sunshine Tech Solutions] Ravi Gehlot wrote: Hey Pete, Check to see if your version of access works fine with ColdFusion 7.0.2. Sometimes, you have to download a special driver and install it on your ColdFusion directory so that your datasources may work ok. Just a thought, Ravi. Peter Tanswell wrote: Hi there I have recently installed ColdFusion 7.02 on Windows Vista. It all appeared to be working fine, until I had to go an set up datasource for a microsoft access database. Then I tried setting up a mapping. When I tried both of these I get the following error. IO error on server communication. Basically it doesnt seem to be able to browse to folders on the server. I have googled this and found information on the Adobe website saying I had to make a change to the web.xml file in the web-inf folder. I checked this file and it looked fine. I'm stumped on this one. Just wondering if anyone else might have experienced this problem and if so how they resolved it. I can set up datasource if its a MySQL database. Thanks in advance for feedback. Pete ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server Error
Pete, I am a Linux user. I haven't even given Vista a try yet but I heard that it has many permissions issues. Ravi. Peter Tanswell wrote: Hi there I dont think its an access problem - it was working with CF7.02 previously without any problems. I think it has to be a CF7-Vista issue and quite likely a CF error or permission setting. I get the same error message when I try to browse for files when trying to set up mappings. Regards Pete On 6/24/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: Hey Pete, Check to see if your version of access works fine with ColdFusion 7.0.2. Sometimes, you have to download a special driver and install it on your ColdFusion directory so that your datasources may work ok. Just a thought, Ravi. Peter Tanswell wrote: Hi there I have recently installed ColdFusion 7.02 on Windows Vista. It all appeared to be working fine, until I had to go an set up datasource for a microsoft access database. Then I tried setting up a mapping. When I tried both of these I get the following error. IO error on server communication. Basically it doesnt seem to be able to browse to folders on the server. I have googled this and found information on the Adobe website saying I had to make a change to the web.xml file in the web-inf folder. I checked this file and it looked fine. I'm stumped on this one. Just wondering if anyone else might have experienced this problem and if so how they resolved it. I can set up datasource if its a MySQL database. Thanks in advance for feedback. Pete ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL question
I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL question
Hey Barney, Yes. Can you provide me with an example in how to use it? Ravi. Barney Boisvert wrote: I'm not really sure what you're asking. You can use the LAST_INSERT_ID() function to get the last auto-generated ID you've inserted on your current connection, if that's what you mean? cheers, barneyb On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL PROTECTED] Cell Phone: (407) 860-3775 Business Line: (407) 745-1433 --- Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL question
Oh God...it must be all of that pot I have been smoking. SorryI knew that... ;-) Ravi. Casey Dougall wrote: On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question is prolly out topic but he it goes. How do I sort by the last inserted Id on a sql query? Ravi. -- cfquery Select col names from table Order By tblID DESC /cfquery ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4