RE: WARNING: PCAnywhere
on a related note about SP6a... if you're primary drive is on a scsi chain, I wouldn't upgrade... when we installed 6a, our scsi drivers were killed... had to spend a day build the machine with a IDE drive and taking the scsi to another machine to pull off all our data thank god is was only our development server Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader > -Original Message- > From: Richard Colman [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 21, 2001 7:18 PM > To: CF-Talk > Subject: WARNING: PCAnywhere > > > A failed installation (attempting to upgrade ver. 8 to ver. > 10) on an NT4, > sp6 server literally destroyed the server OS, making it > impossible to boot > the OS without a "blue screen." This just happened to be an important > production server without a ghosted system partition. We had > to rebuild from > scratch on another box. Almost lost a Very Important Client or two. > > When I contacted Symantec, they charged me $29.95 to tell me > that I was > "hosed." > > If you are not using PCAnywhere, do not start. If you have an > older version, > upgrade with the greatest of risk. > > > > Rick Colman > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF still relevant?
Joseph, this is certainly not a Macromedia response but a Mike Brunt (a lowly consultant) response. I think your email was well stated and it has generated some really healthy open debate. We all need to place close attention to the marketplace for my part I want whatever is best for the good of the Internet, the Web and all it's users. I am here because I honestly believe the Internet to be a major force in making the world a better place. Thanks for sparking a great debate. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.macromedia.com -Original Message- From: Joseph Grossberg [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 12:28 PM To: CF-Talk Subject: Is CF still relevant? Now, before you dismiss this as a troll, please let me elaborate. This isn't so much an instigation or a whine as it is a call for us to take a step back and reevalutate things periodically. Over the course of my career as a web programmer/developer, I have worked with a variety of sever-side languages and technologies: ColdFusion, ASP, JSP, PHP, Perl and Python. I like some more than others, but I'm not an evangelist for any; they each have their uses. And I recognize some of CF's strengths: easy to learn for people who know only tag-based HTML or don't have significant programming experience; built-in admin tool; specialized editor; comes with pre-built tags and web-based administrator. There are also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively small community; etc. Right now, I work at a web development firm that is primarily "a CF house" (besides me). Our more senior programmers are looking at honing their CF skills, while our less experienced webmasters are trying to learn ColdFusion. But, I can't help but wonder whether they are wasting their time. Would they be better off spending their time learning ASP, Java or another non-CF solution? Why or why not? And how would we tell if and when it was time to give up CF and try something else, as all but the most stubborn experts in also-ran languages (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems (Amiga) have resignedly done? Lastly, why do *you* still use CF? Is it because it's what you're best at, and you don't want to try something new (where, temporarily, you'd be a novice again)? Is it because your ccompany's legacy code is all in CF? Is it because you genuinely think that ColdFusion is, generally speaking, the best solution for web application development in 2001? Joe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WARNING: PCAnywhere
This happened to me too! With Version 9.2. After installing it, I could not boot my NT 4.0 sp6a server without a blue screen of death reporting a Inaccessible boot device if I recall correctly. I had recently installed the same software on 3 of our other servers with the same configuration without any problems. Luckily the problems occurred on one of our dev servers. It was a pain to fix. It seemed to do damage to the master boot record. What did symantec say was the problem? Brook At 04:17 PM 21/04/01 -0700, you wrote: >A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, >sp6 server literally destroyed the server OS, making it impossible to boot >the OS without a "blue screen." This just happened to be an important >production server without a ghosted system partition. We had to rebuild from >scratch on another box. Almost lost a Very Important Client or two. > >When I contacted Symantec, they charged me $29.95 to tell me that I was >"hosed." > >If you are not using PCAnywhere, do not start. If you have an older version, >upgrade with the greatest of risk. > > > >Rick Colman > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
almost every company i know that uses PCA has problems. i've used timbuktu (tried PCA for a few months) for years and it is *great*. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 4:34 PM To: CF-Talk Subject: Re: WARNING: PCAnywhere This happened to me too! With Version 9.2. After installing it, I could not boot my NT 4.0 sp6a server without a blue screen of death reporting a Inaccessible boot device if I recall correctly. I had recently installed the same software on 3 of our other servers with the same configuration without any problems. Luckily the problems occurred on one of our dev servers. It was a pain to fix. It seemed to do damage to the master boot record. What did symantec say was the problem? Brook At 04:17 PM 21/04/01 -0700, you wrote: >A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, >sp6 server literally destroyed the server OS, making it impossible to boot >the OS without a "blue screen." This just happened to be an important >production server without a ghosted system partition. We had to rebuild from >scratch on another box. Almost lost a Very Important Client or two. > >When I contacted Symantec, they charged me $29.95 to tell me that I was >"hosed." > >If you are not using PCAnywhere, do not start. If you have an older version, >upgrade with the greatest of risk. > > > >Rick Colman > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
They didn't. Now using Terminal Server under windows 2000 and seems to be ok. Rick. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 4:34 PM To: CF-Talk Subject: Re: WARNING: PCAnywhere This happened to me too! With Version 9.2. After installing it, I could not boot my NT 4.0 sp6a server without a blue screen of death reporting a Inaccessible boot device if I recall correctly. I had recently installed the same software on 3 of our other servers with the same configuration without any problems. Luckily the problems occurred on one of our dev servers. It was a pain to fix. It seemed to do damage to the master boot record. What did symantec say was the problem? Brook At 04:17 PM 21/04/01 -0700, you wrote: >A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, >sp6 server literally destroyed the server OS, making it impossible to boot >the OS without a "blue screen." This just happened to be an important >production server without a ghosted system partition. We had to rebuild from >scratch on another box. Almost lost a Very Important Client or two. > >When I contacted Symantec, they charged me $29.95 to tell me that I was >"hosed." > >If you are not using PCAnywhere, do not start. If you have an older version, >upgrade with the greatest of risk. > > > >Rick Colman > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
H... I've used PCA for years, on Win 98, NT workstations, on NT 4.0/sp4-sp6 servers, and on Win2k (where it is not recommended) servers with no problems whatsoever. I am up to PCA 9.2. I use it almost everyday. It's my primary means of managing a couple of co-located servers and keeping my grandparents computer up to snuff! Erika "Friendship is never an accident. It is always the result of high intentions, sincere effort, intelligent direction and skillful execution. It represents the wise choice of many alternatives." - unknown -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 7:37 PM To: CF-Talk Subject: RE: WARNING: PCAnywhere almost every company i know that uses PCA has problems. i've used timbuktu (tried PCA for a few months) for years and it is *great*. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 4:34 PM To: CF-Talk Subject: Re: WARNING: PCAnywhere This happened to me too! With Version 9.2. After installing it, I could not boot my NT 4.0 sp6a server without a blue screen of death reporting a Inaccessible boot device if I recall correctly. I had recently installed the same software on 3 of our other servers with the same configuration without any problems. Luckily the problems occurred on one of our dev servers. It was a pain to fix. It seemed to do damage to the master boot record. What did symantec say was the problem? Brook At 04:17 PM 21/04/01 -0700, you wrote: >A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, >sp6 server literally destroyed the server OS, making it impossible to boot >the OS without a "blue screen." This just happened to be an important >production server without a ghosted system partition. We had to rebuild from >scratch on another box. Almost lost a Very Important Client or two. > >When I contacted Symantec, they charged me $29.95 to tell me that I was >"hosed." > >If you are not using PCAnywhere, do not start. If you have an older version, >upgrade with the greatest of risk. > > > >Rick Colman > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
I'm glad this came up. I was about to purchase PC Anywhere (new version, whatever it's up to) for a client so I can manage her SQL and ColdFusion servers. They're running Windows NT Servers, 4.0 SP5. We currently have a VPN setup, which works great, except I need to be able to manage the servers. Any ideas on other programs? Thanks, Andy > -Original Message- > From: Richard Colman [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 21, 2001 8:22 PM > To: CF-Talk > Subject: RE: WARNING: PCAnywhere > > > They didn't. > > Now using Terminal Server under windows 2000 and seems to be ok. > > Rick. > > -Original Message- > From: Brook Davies [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 21, 2001 4:34 PM > To: CF-Talk > Subject: Re: WARNING: PCAnywhere > > > This happened to me too! With Version 9.2. After installing it, I > could not > boot my NT 4.0 sp6a server without a blue screen of death reporting a > Inaccessible boot device if I recall correctly. > > I had recently installed the same software on 3 of our other servers with > the same configuration without any problems. Luckily the problems occurred > on one of our dev servers. It was a pain to fix. It seemed to do damage to > the master boot record. > > What did symantec say was the problem? > > Brook > > > > At 04:17 PM 21/04/01 -0700, you wrote: > >A failed installation (attempting to upgrade ver. 8 to ver. 10) > on an NT4, > >sp6 server literally destroyed the server OS, making it > impossible to boot > >the OS without a "blue screen." This just happened to be an important > >production server without a ghosted system partition. We had to rebuild > from > >scratch on another box. Almost lost a Very Important Client or two. > > > >When I contacted Symantec, they charged me $29.95 to tell me that I was > >"hosed." > > > >If you are not using PCAnywhere, do not start. If you have an older > version, > >upgrade with the greatest of risk. > > > > > > > >Rick Colman > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
Try using VNC (http://www.uk.research.att.com/vnc/). It is a java-based program that was written by AT&T that basically does what PCA does, but it is FREE, FREE, FREE! Seems to work pretty well. You can even to a remote reboot with it. We have been playing around with it after seeing a co-location client of ours using it. It is VERY slick. You may want to do some research on BugTraq to make sure it is safe, but I really like it. John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 7:18 PM To: CF-Talk Subject: WARNING: PCAnywhere A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, sp6 server literally destroyed the server OS, making it impossible to boot the OS without a "blue screen." This just happened to be an important production server without a ghosted system partition. We had to rebuild from scratch on another box. Almost lost a Very Important Client or two. When I contacted Symantec, they charged me $29.95 to tell me that I was "hosed." If you are not using PCAnywhere, do not start. If you have an older version, upgrade with the greatest of risk. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WARNING: PCAnywhere
I'll second the use of VNC. We utilize terminal server with our Win2K servers, but we run VNC as a backup. The reason is that it allows us to remote access the servers through any Internet Browser (i.e. the win98 Laptop while on vacation). It also allows us to access the servers in the event that terminal services locks up. For example, a while back we had a corrupt datasource that caused a large memory leak. We could not remote the server via Terminal Services, but we were able to access it via VNC. It has both a desktop and a web interface and runs pretty smooth. John Lucas [EMAIL PROTECTED] - Original Message - From: "John McKown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 21, 2001 7:29 PM Subject: RE: WARNING: PCAnywhere > Try using VNC (http://www.uk.research.att.com/vnc/). It is a java-based > program that was written by AT&T that basically does what PCA does, but > it is FREE, FREE, FREE! Seems to work pretty well. You can even to a > remote reboot with it. We have been playing around with it after seeing > a co-location client of ours using it. It is VERY slick. You may want > to do some research on BugTraq to make sure it is safe, but I really like > it. > > > John McKown, Owner > Delaware.Net, Inc. > 30 Old Rudnick Lane, Suite 200 > Dover, DE 19901 > phone: 302-736-5515 > toll free: 888-432-7965 > fax: 302-736-5945 > e-mail: [EMAIL PROTECTED] > > > > -Original Message- > From: Richard Colman [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 21, 2001 7:18 PM > To: CF-Talk > Subject: WARNING: PCAnywhere > > > A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, > sp6 server literally destroyed the server OS, making it impossible to boot > the OS without a "blue screen." This just happened to be an important > production server without a ghosted system partition. We had to rebuild from > scratch on another box. Almost lost a Very Important Client or two. > > When I contacted Symantec, they charged me $29.95 to tell me that I was > "hosed." > > If you are not using PCAnywhere, do not start. If you have an older version, > upgrade with the greatest of risk. > > > > Rick Colman > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
This looks great. Thanks for the link and the info. I just downloaded it and will play with it asap (on the development server, of course!) Have a good weekend everyone! Andy > -Original Message- > From: John Lucas [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 21, 2001 8:44 PM > To: CF-Talk > Subject: Re: WARNING: PCAnywhere > > > I'll second the use of VNC. We utilize terminal server with our Win2K > servers, but we run VNC as a backup. The reason is that it allows us to > remote access the servers through any Internet Browser (i.e. the win98 > Laptop while on vacation). It also allows us to access the servers in the > event that terminal services locks up. For example, a while back we had a > corrupt datasource that caused a large memory leak. We could not > remote the > server via Terminal Services, but we were able to access it via > VNC. It has > both a desktop and a web interface and runs pretty smooth. > > > John Lucas > [EMAIL PROTECTED] > > - Original Message - > From: "John McKown" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, April 21, 2001 7:29 PM > Subject: RE: WARNING: PCAnywhere > > > > Try using VNC (http://www.uk.research.att.com/vnc/). It is a java-based > > program that was written by AT&T that basically does what PCA does, but > > it is FREE, FREE, FREE! Seems to work pretty well. You can even to a > > remote reboot with it. We have been playing around with it > after seeing > > a co-location client of ours using it. It is VERY slick. You may want > > to do some research on BugTraq to make sure it is safe, but I > really like > > it. > > > > > > John McKown, Owner > > Delaware.Net, Inc. > > 30 Old Rudnick Lane, Suite 200 > > Dover, DE 19901 > > phone: 302-736-5515 > > toll free: 888-432-7965 > > fax: 302-736-5945 > > e-mail: [EMAIL PROTECTED] > > > > > > > > -Original Message- > > From: Richard Colman [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, April 21, 2001 7:18 PM > > To: CF-Talk > > Subject: WARNING: PCAnywhere > > > > > > A failed installation (attempting to upgrade ver. 8 to ver. 10) > on an NT4, > > sp6 server literally destroyed the server OS, making it > impossible to boot > > the OS without a "blue screen." This just happened to be an important > > production server without a ghosted system partition. We had to rebuild > from > > scratch on another box. Almost lost a Very Important Client or two. > > > > When I contacted Symantec, they charged me $29.95 to tell me that I was > > "hosed." > > > > If you are not using PCAnywhere, do not start. If you have an older > version, > > upgrade with the greatest of risk. > > > > > > > > Rick Colman > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF still relevant?
Joseph, Great questions. If you asked me 6 months ago, I would answer you by saying that the reason I use CF primarily is because it is a great RAD tool. Today, I am thinking about how cool it will be to leverage my CF experience once CF is tied to Flash better (better than Harpoon). The thought of this alone gets my heart racing.A couple of years ago, M$ introduced their "Agent" ActiveX component that allowed you to have a little character (like those annoying M$ Office Assistants) that you could script to make talk. I thought that this was pretty neat, but it required a slow download, and the performance was hideous. Also, you were stuck with the characters that M$ developed. With Flash working better with CF, you could create some compelling agents, IM programs, distance learning tools, training programs, and more. There is probably a lot of potential here that we have not even thought of yet. So the Flash potential and also UltraDev's *potential* have me excited. Those are my hopes for CF. My fears are: - How well will CF be integrated with UltraDev? - How well will CF be integrated with Flash? And I don't mean little Harpoon calendars. - Will MM fix/improve the advanced security features of CF? The "Users --> Groups --> Policies" security model is cludgy. - Will MM or Version 5.0 improve/automate remote file management? By this I mean that I would like for CF to allow me to manage files on the server much like FrontPage extensions do. You rename a file, and all of the links to the file get renamed. FP is a newbie tool, but this is a HUGE time saver when you have a really big site to manage. - Will MM lower the cost of the server? The pro version should cost $599.00. - How will the real world performance be with the Java-based "NEO" (CF version 6.0). I know they say it is faster, but I am just worried. - How soon will 5.0 be out? User defined functions and querying a query will be awesome. The User defined functions alone will add tremendously to the CF community once you can download custom functions (loan calculators, etc.). Just my 2 cents. John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] -Original Message- From: Joseph Grossberg [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 12:28 PM To: CF-Talk Subject: Is CF still relevant? Now, before you dismiss this as a troll, please let me elaborate. This isn't so much an instigation or a whine as it is a call for us to take a step back and reevalutate things periodically. Over the course of my career as a web programmer/developer, I have worked with a variety of sever-side languages and technologies: ColdFusion, ASP, JSP, PHP, Perl and Python. I like some more than others, but I'm not an evangelist for any; they each have their uses. And I recognize some of CF's strengths: easy to learn for people who know only tag-based HTML or don't have significant programming experience; built-in admin tool; specialized editor; comes with pre-built tags and web-based administrator. There are also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively small community; etc. Right now, I work at a web development firm that is primarily "a CF house" (besides me). Our more senior programmers are looking at honing their CF skills, while our less experienced webmasters are trying to learn ColdFusion. But, I can't help but wonder whether they are wasting their time. Would they be better off spending their time learning ASP, Java or another non-CF solution? Why or why not? And how would we tell if and when it was time to give up CF and try something else, as all but the most stubborn experts in also-ran languages (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems (Amiga) have resignedly done? Lastly, why do *you* still use CF? Is it because it's what you're best at, and you don't want to try something new (where, temporarily, you'd be a novice again)? Is it because your ccompany's legacy code is all in CF? Is it because you genuinely think that ColdFusion is, generally speaking, the best solution for web application development in 2001? Joe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is CF still relevant?
Can someone point me to any online articles about NEO? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "John McKown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 21, 2001 8:56 PM Subject: RE: Is CF still relevant? > Joseph, > > Great questions. If you asked me 6 months ago, I would answer you by saying > that the reason I use CF primarily is because it is a great RAD tool. > Today, I am thinking about how cool it will be to leverage my CF experience > once CF is tied to Flash better (better than Harpoon). The thought of this > alone gets my heart racing.A couple of years ago, M$ introduced their > "Agent" ActiveX component that allowed you to have a little character (like > those annoying M$ Office Assistants) that you could script to make talk. I > thought that this was pretty neat, but it required a slow download, and the > performance was hideous. Also, you were stuck with the characters that M$ > developed. With Flash working better with CF, you could create some > compelling agents, IM programs, distance learning tools, training programs, > and more. There is probably a lot of potential here that we have not even > thought of yet. So the Flash potential and also UltraDev's *potential* > have me excited. Those are my hopes for CF. > > My fears are: > > - How well will CF be integrated with UltraDev? > - How well will CF be integrated with Flash? And I don't mean little > Harpoon calendars. > - Will MM fix/improve the advanced security features of CF? The "Users --> > Groups --> Policies" security model is cludgy. > - Will MM or Version 5.0 improve/automate remote file management? By this > I mean that I would like for CF to allow me to manage files on the server > much like FrontPage extensions do. You rename a file, and all of the links > to the file get renamed. FP is a newbie tool, but this is a HUGE time saver > when you have a really big site to manage. > - Will MM lower the cost of the server? The pro version should cost > $599.00. > - How will the real world performance be with the Java-based "NEO" (CF > version 6.0). I know they say it is faster, but I am just worried. > - How soon will 5.0 be out? User defined functions and querying a query > will be awesome. The User defined functions alone will add tremendously to > the CF community once you can download custom functions (loan calculators, > etc.). > > Just my 2 cents. > > John McKown, Owner > Delaware.Net, Inc. > 30 Old Rudnick Lane, Suite 200 > Dover, DE 19901 > phone: 302-736-5515 > toll free: 888-432-7965 > fax: 302-736-5945 > e-mail: [EMAIL PROTECTED] > > > > > -Original Message- > From: Joseph Grossberg [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 20, 2001 12:28 PM > To: CF-Talk > Subject: Is CF still relevant? > > > Now, before you dismiss this as a troll, please let me elaborate. This isn't > > so much an instigation or a whine as it is a call for us to take a step back > > and reevalutate things periodically. > > Over the course of my career as a web programmer/developer, I have worked > with a variety of sever-side languages and technologies: ColdFusion, ASP, > JSP, PHP, Perl and Python. I like some more than others, but I'm not an > evangelist for any; they each have their uses. And I recognize some of CF's > strengths: easy to learn for people who know only tag-based HTML or don't > have significant programming experience; built-in admin tool; specialized > editor; comes with pre-built tags and web-based administrator. There are > also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively > small community; etc. > > Right now, I work at a web development firm that is primarily "a CF house" > (besides me). Our more senior programmers are looking at honing their CF > skills, while our less experienced webmasters are trying to learn > ColdFusion. But, I can't help but wonder whether they are wasting their > time. Would they be better off spending their time learning ASP, Java or > another non-CF solution? Why or why not? > > And how would we tell if and when it was time to give up CF and try > something else, as all but the most stubborn experts in also-ran languages > (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems > > (Amiga) have resignedly done? > > Lastly, why do *you* still use CF? Is it because it's what you're best at, > and you don't want to try something new (where, temporarily, you'd be a > novice again)? Is it because your ccompany's legacy code is all in CF? Is it > > because you genuinely think that ColdFusion is, generally speaking, the best > > solution for web application development in 2001? > > Joe > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www
RE: WARNING: PCAnywhere
> I'll second the use of VNC. I'll third it. :) We've been using VNC exclusively for over 2 years, with nothing but success, on NT and Win2K machines. Copying and pasting between client and server is much more convenient than with PCA, since the clipboard is automatically transferred, and the speed has always been as fast or faster than PCA. Remote reboots are always reliable, unless there's a hardware problem (we use a remote power cycler for that). The new version of VNC allows you to scale the screen, so you can display 4 or more full-size server desktops on one screen (handy if you're addicted to watching the task manager graphs). Final hint: make shortcuts with your VNC connections (there's an option to save your password), put 'em in your Start menu, and you can launch windows with your servers' desktops in about 2 seconds. Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] ..¸_¸.·´¯) http://www.BookCrossing.com ~ Read and Release! (¯`·.¸_¸. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
On a side note. I found this by an e-mail on the WIN-NT list. http://www.famatech.com/ It's called RAdmin. Costs 35.00 per license. It is at least 5 times as fast on screen redraws on NT. Even when the traffic on the server is heavy it's almost as fast as sitting at the server itself. It has a better file transfer mode than pcA, you can reboot the host without logging in and it has Telnet mode. I've stayed connected all day since I installed it. pcA always drops me when the traffic on the server gets heavy and I have to use the cfx_servicecontrol tag to restart it. All in all I'm tickled pink that I found it. I just wish I would have found it before I purchased pcA. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WARNING: PCAnywhere
Dylan Bromby wrote: > almost every company i know that uses PCA has problems. i've used timbuktu > (tried PCA for a few months) for years and it is *great*. I use VNC which has the added benefit of being cross platform (running your NT server on your PowerBook is very cool) and free. -- For decades we always heard that if you gave a million monkeys typewriters and let them bang away on the keyboard that they would ultimately type the complete works of Shakespeare. The Internet has proved that this is not so. -- Robert Wilensky, University of California WWW: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WARNING: PCAnywhere
A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, sp6 server literally destroyed the server OS, making it impossible to boot the OS without a "blue screen." This just happened to be an important production server without a ghosted system partition. We had to rebuild from scratch on another box. Almost lost a Very Important Client or two. When I contacted Symantec, they charged me $29.95 to tell me that I was "hosed." If you are not using PCAnywhere, do not start. If you have an older version, upgrade with the greatest of risk. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WARNING: PCAnywhere
John McKown wrote: > Try using VNC (http://www.uk.research.att.com/vnc/). It is a java-based > program that was written by AT&T that basically does what PCA does, but > it is FREE, FREE, FREE! I believe that there are native clients but that it also has a java client available. -- Optimist This glass is half full Pessimist This glass is half empty Engineer Good thing I put half my water into this redundant glass. email: [EMAIL PROTECTED] WWW: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
So how would it work if I downloaded it to my remote server I manage with VNC? Does RAdmin require a boot after install? If so, I'm not sure I could trust it to come up. best, paul At 09:13 PM 4/21/01 -0400, you wrote: >On a side note. I found this by an e-mail on the WIN-NT list. > >http://www.famatech.com/ > >It's called RAdmin. Costs 35.00 per license. It is at least 5 times >as fast on screen redraws on NT. Even when the traffic on the server >is heavy it's almost as fast as sitting at the server itself. It has >a better file transfer mode than pcA, you can reboot the host without >logging in and it has Telnet mode. I've stayed connected all day >since I installed it. pcA always drops me when the traffic on the >server gets heavy and I have to use the cfx_servicecontrol tag to >restart it. All in all I'm tickled pink that I found it. I just wish >I would have found it before I purchased pcA. >-- > >Bud Schneehagen - Tropical Web Creations > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >ColdFusion Solutions / eCommerce Development >[EMAIL PROTECTED] >http://www.twcreations.com/ >954.721.3452 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
Do you use a VPN or other means of encryption with VNC? At 08:12 PM 21/04/01 -0500, you wrote: > > I'll second the use of VNC. > >I'll third it. :) We've been using VNC exclusively for over 2 years, with >nothing but success, on NT and Win2K machines. Copying and pasting between >client and server is much more convenient than with PCA, since the >clipboard is automatically transferred, and the speed has always been as >fast or faster than PCA. Remote reboots are always reliable, unless >there's a hardware problem (we use a remote power cycler for that). The >new version of VNC allows you to scale the screen, so you can display 4 or >more full-size server desktops on one screen (handy if you're addicted to >watching the task manager graphs). Final hint: make shortcuts with your >VNC connections (there's an option to save your password), put 'em in your >Start menu, and you can launch windows with your servers' desktops in >about 2 seconds. > >Ron Allen Hornbaker >President/CTO >Humankind Systems, Inc. >http://humankindsystems.com >mailto:[EMAIL PROTECTED] > >..¸_¸.·´¯) http://www.BookCrossing.com ~ Read and Release! (¯`·.¸_¸. > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WARNING: PCAnywhere
Hi Zac, > > almost every company i know that uses PCA has problems. i've used timbuktu > > (tried PCA for a few months) for years and it is *great*. > >I use VNC which has the added benefit of being cross platform (running your >NT server on your PowerBook is very cool) and free. Timbuktu is cross platform as well, in fact that is where Timbuktu came from, an engine to allow Macs to drive each other and then they brought in Win boxen later. We have been using Timbuktu here for a couple of years, no hassles whatsoever but we did have problems with VNC, admittedly an earlier version, partly stability but also that fact that you could not turn off backgrounds made it slow and upped the network traffic a _lot_ We also have a couple of clients that insist on having PCA on their co-lo boxes, and it is not unusual for one to ring and ask us to restart things :-) -- Yours, Kym ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
Microsoft Netmeeting 3.x allows remote access to machines securely. Works well and is free. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 April 2001 10:29 To: CF-Talk Subject: RE: WARNING: PCAnywhere I'm glad this came up. I was about to purchase PC Anywhere (new version, whatever it's up to) for a client so I can manage her SQL and ColdFusion servers. They're running Windows NT Servers, 4.0 SP5. We currently have a VPN setup, which works great, except I need to be able to manage the servers. Any ideas on other programs? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
i use VNC. does the job plenty well. From: "John McKown" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: WARNING: PCAnywhere Date: Sat, 21 Apr 2001 20:29:53 -0400 Try using VNC (http://www.uk.research.att.com/vnc/). It is a java-based program that was written by AT&T that basically does what PCA does, but it is FREE, FREE, FREE! Seems to work pretty well. You can even to a remote reboot with it. We have been playing around with it after seeing a co-location client of ours using it. It is VERY slick. You may want to do some research on BugTraq to make sure it is safe, but I really like it. John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 7:18 PM To: CF-Talk Subject: WARNING: PCAnywhere A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, sp6 server literally destroyed the server OS, making it impossible to boot the OS without a "blue screen." This just happened to be an important production server without a ghosted system partition. We had to rebuild from scratch on another box. Almost lost a Very Important Client or two. When I contacted Symantec, they charged me $29.95 to tell me that I was "hosed." If you are not using PCAnywhere, do not start. If you have an older version, upgrade with the greatest of risk. Rick Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server ODBC Errors
Bud, I'm replying off-list, since I lost track of whether you got any response. I'm slow at getting through all of my CF-related email. Here's the MSDN page listing SQL Server 2000 ODBC error messages: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/tr_err_o dbc_5stz.htm If you follow the left-hand-side table of contents back up from this page, you'll see that it falls within the Troubleshooting section, where you may be able to find more help. Dunno if I'm telling you anything you don't already know -David On Wednesday, April 04, 2001 4:58 AM, Bud [SMTP:[EMAIL PROTECTED]] wrote: > Howdy. Anyone have a resource for defining SQL Server ODBC errors, > what they mean and how to fix them? I'm getting occasional errors > that I don't know what they are. Not enough to be concerned, maybe 3 > or 4 a day out of a couple thousand hits, but stuff like: > > Invalid Cursor State > ConnectionWrite (send()) > > Like I found the Invalid Cursor State on MS website, but it says it's > been fixed in MDAC 2.6, but that's what is installed with SQL2000 and > I've gotten the error anyway. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: SQL Server ODBC Errors
Make that "on-list". Fingers, don't fail me now! -David -Original Message- From: David Shadovitz [SMTP:[EMAIL PROTECTED]] Sent: Saturday, April 21, 2001 11:39 PM To: CF-Talk Subject:RE: SQL Server ODBC Errors Bud, I'm replying off-list, since I lost track of whether you got any response. I'm slow at getting through all of my CF-related email. Here's the MSDN page listing SQL Server 2000 ODBC error messages: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/tr_err_o dbc_5stz.htm If you follow the left-hand-side table of contents back up from this page, you'll see that it falls within the Troubleshooting section, where you may be able to find more help. Dunno if I'm telling you anything you don't already know -David On Wednesday, April 04, 2001 4:58 AM, Bud [SMTP:[EMAIL PROTECTED]] wrote: > Howdy. Anyone have a resource for defining SQL Server ODBC errors, > what they mean and how to fix them? I'm getting occasional errors > that I don't know what they are. Not enough to be concerned, maybe 3 > or 4 a day out of a couple thousand hits, but stuff like: > > Invalid Cursor State > ConnectionWrite (send()) > > Like I found the Invalid Cursor State on MS website, but it says it's > been fixed in MDAC 2.6, but that's what is installed with SQL2000 and > I've gotten the error anyway. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WARNING: PCAnywhere
On 4/21/01, Paul Smith penned: >So how would it work if I downloaded it to my remote server I manage with VNC? > >Does RAdmin require a boot after install? If so, I'm not sure I could >trust it to come up. Yes, it does require a reboot. I downloaded it to my computer at home, uploaded it to the server and installed it with pcA then uninstalled pcA after a couple days. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Was AW: WARNING: PCAnywhere -> PCAnywhere functions on a linux box ?
o.k. Beside the discussion of PCA on WIN-Plattform, what can I use to get graphical interface to a linux box ? (I have a KDE running on the linux box) I tried VNC but it only gives me a view on the linux command shell. Ideas ? Uwe -Ursprüngliche Nachricht- Von: Bud [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 22. April 2001 10:25 An: CF-Talk Betreff: RE: WARNING: PCAnywhere On 4/21/01, Paul Smith penned: >So how would it work if I downloaded it to my remote server I manage with VNC? > >Does RAdmin require a boot after install? If so, I'm not sure I could >trust it to come up. Yes, it does require a reboot. I downloaded it to my computer at home, uploaded it to the server and installed it with pcA then uninstalled pcA after a couple days. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
AW: SQL SERVER and IIS on the same machine?
Michael, I did that for years without a problem. Although if you have heavy traffic or/and less memory I wouldn't do it. Uwe -Ursprüngliche Nachricht- Von: Michael Lugassy [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 22. April 2001 11:40 An: CF-Talk Betreff: SQL SERVER and IIS on the same machine? Our hosting company told me they don't support SQL SERVER and IIS on the same NT machine. "Even Microsoft doesn't recommened it", they claim. What do you think? Money is always an issue... Thanks, -Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Updating 1000s of records
Our application is built like that so I'm reciving a daily .txt file with 1000s of lines. each line with a unique number that is userID. userID that is on this text file means he visited our site in the last 24 hours (complex, I know.. bear with me) I'm trying to find the best way to update 1000s rows of SQL 7 DB Table: USERS. with this information so that Colum LASTVISITEDDATE will have now() value for each person that was on that list. Any brighter ideas then loop list UPDATE WHERE userID='x end loop OR UPDATE WHERE userID='x' OR userID='y' OR userID='n...' Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL SERVER and IIS on the same machine?
one of the sites I'm involved in serves about 8 million pages a month, well over half of them requiring a database connection (most of these will have more than one query) and the site runs on a dual processor pentium III with win2000 and SQL Server 7 - no problems. Just make sure you spend a lot of time optimizing the server for performance and most importantly, stick a load of RAM into it, at least 1 GB. Nobody would recommend a single server config for a high traffic web site if the company had money to burn, but who has these days? Mark At 10:40 AM 22/04/2001, you wrote: >Our hosting company told me they don't support SQL SERVER >and IIS on the same NT machine. >"Even Microsoft doesn't recommened it", they claim. > >What do you think? Money is always an issue... > >Thanks, > >-Michael. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WARNING: PCAnywhere
What kind of security/encryption does Timbuktu offer? At least I know pcAnywhere has some decent encryption that can be required on all sessions. Jim - Original Message - From: "Kym Kovan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 21, 2001 10:03 PM Subject: Re: WARNING: PCAnywhere > Hi Zac, > > > > almost every company i know that uses PCA has problems. i've used timbuktu > > > (tried PCA for a few months) for years and it is *great*. > > > >I use VNC which has the added benefit of being cross platform (running your > >NT server on your PowerBook is very cool) and free. > > Timbuktu is cross platform as well, in fact that is where Timbuktu came > from, an engine to allow Macs to drive each other and then they brought in > Win boxen later. > > We have been using Timbuktu here for a couple of years, no hassles > whatsoever but we did have problems with VNC, admittedly an earlier > version, partly stability but also that fact that you could not turn off > backgrounds made it slow and upped the network traffic a _lot_ > > We also have a couple of clients that insist on having PCA on their co-lo > boxes, and it is not unusual for one to ring and ask us to restart things :-) > > -- > > Yours, > > Kym ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OLEDB/ODBC
I'm in a process of updating ALL of our coldfusion tags anyhow, so I would like to know if it's recommened to move into OLEDB. I'm using SQL 7 on NT 5, 512KB RAM Is there something I need to consider? Any tags/functions change? (Other then CreateODBCTime?) Any pointers would be great... Thanks, -Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: syntax for cli execution of a cfm page?
At 08:32 PM 18/04/2001, you wrote: >Thanks for the info guys. In case anyone was wondering: > >cfml.exe c:\path\template.cfm > >does actually work. ;p cool, anyone know if this is new to cf 4.5? I don't know if I ever actually tried just running cfml.exe with the path as a parameter before, I'm gonna be kicking myself if this functionality has always been available. Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL SERVER and IIS on the same machine?
Our hosting company told me they don't support SQL SERVER and IIS on the same NT machine. "Even Microsoft doesn't recommened it", they claim. What do you think? Money is always an issue... Thanks, -Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating 1000s of records
Access or SQL? - Original Message - From: "Michael Lugassy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 3:17 AM Subject: Updating 1000s of records > Our application is built like that so I'm reciving a daily .txt file with 1000s of lines. each line > with a unique number that is userID. userID that is on this text file means he visited our site > in the last 24 hours (complex, I know.. bear with me) > > I'm trying to find the best way to update 1000s rows of SQL 7 DB Table: USERS. > with this information so that Colum LASTVISITEDDATE will have now() value for each > person that was on that list. > > Any brighter ideas then > > loop list > UPDATE WHERE userID='x > end loop > > OR > > UPDATE WHERE userID='x' OR userID='y' OR userID='n...' > > > Thanks, > > Michael Lugassy > Interactive Music Ltd. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating 1000s of records
SQL 7 - Original Message - From: "Brian Thornton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 11:41 AM Subject: Re: Updating 1000s of records > Access or SQL? > - Original Message - > From: "Michael Lugassy" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, April 22, 2001 3:17 AM > Subject: Updating 1000s of records > > > > Our application is built like that so I'm reciving a daily .txt file with > 1000s of lines. each line > > with a unique number that is userID. userID that is on this text file > means he visited our site > > in the last 24 hours (complex, I know.. bear with me) > > > > I'm trying to find the best way to update 1000s rows of SQL 7 DB Table: > USERS. > > with this information so that Colum LASTVISITEDDATE will have now() value > for each > > person that was on that list. > > > > Any brighter ideas then > > > > loop list > > UPDATE WHERE userID='x > > end loop > > > > OR > > > > UPDATE WHERE userID='x' OR userID='y' OR userID='n...' > > > > > > Thanks, > > > > Michael Lugassy > > Interactive Music Ltd. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL SERVER and IIS on the same machine?
- Original Message - From: "Michael Lugassy" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 10:40 AM > Our hosting company told me they don't support SQL SERVER > and IIS on the same NT machine. > "Even Microsoft doesn't recommened it", they claim. I seperate IIS and SQL Server 2000 as a matter of course, but I am not at all convinced you need to on a machine of the right specification - notably 1Gb+ RAM and a couple of fast CPU's. Even redundancy isn't a reason to run two seperate servers, because if either of the servers and/or the ODBC/OLEDB connection across the network goes down, the entire site is down anyway. I would be interested in more views on this issue. Adrian Cooper. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating 1000s of records
you could add a SQL server scheduled task to bulk insert (see BULK INSERT command in SQL server docs) into a temporary table from your text file and then use the data in the temp table to update the user info. Just moves the processing from CF onto SQL server, which will definitely improve performance. Even if you run both the BULK INSERT and UPDATE commands from a CF template, it'll still improve your performance considerably (only two database connections and queries now). Mark At 12:10 PM 22/04/2001, you wrote: >SQL 7 > >- Original Message - >From: "Brian Thornton" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Sunday, April 22, 2001 11:41 AM >Subject: Re: Updating 1000s of records > > > > Access or SQL? > > - Original Message - > > From: "Michael Lugassy" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, April 22, 2001 3:17 AM > > Subject: Updating 1000s of records > > > > > > > Our application is built like that so I'm reciving a daily .txt file >with > > 1000s of lines. each line > > > with a unique number that is userID. userID that is on this text file > > means he visited our site > > > in the last 24 hours (complex, I know.. bear with me) > > > > > > I'm trying to find the best way to update 1000s rows of SQL 7 DB Table: > > USERS. > > > with this information so that Colum LASTVISITEDDATE will have now() >value > > for each > > > person that was on that list. > > > > > > Any brighter ideas then > > > > > > loop list > > > UPDATE WHERE userID='x > > > end loop > > > > > > OR > > > > > > UPDATE WHERE userID='x' OR userID='y' OR userID='n...' > > > > > > > > > Thanks, > > > > > > Michael Lugassy > > > Interactive Music Ltd. > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL SERVER and IIS on the same machine?
Hi Michael, We have been using IIS 5.0 & SQL 7.0 on the same machine for about a year. No real problems, but now our traffic levels are much higher we have had to upgrade the memory to 1GB. We will be looking into moving the SQL to it's own server soon. For lower traffic sites I do not see a problem, however be aware that CPU usage is much higher on server with this configuration. HTH Phil. > -Original Message- > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > Sent: 22 April 2001 10:40 > To: CF-Talk > Subject: SQL SERVER and IIS on the same machine? > > > Our hosting company told me they don't support SQL SERVER > and IIS on the same NT machine. > "Even Microsoft doesn't recommened it", they claim. > > What do you think? Money is always an issue... > > Thanks, > > -Michael. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Updating 1000s of records
Isn't this information already stored under CGLOBALS as a client variable? -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 April 2001 20:18 To: CF-Talk Subject: Updating 1000s of records Our application is built like that so I'm reciving a daily .txt file with 1000s of lines. each line with a unique number that is userID. userID that is on this text file means he visited our site in the last 24 hours (complex, I know.. bear with me) I'm trying to find the best way to update 1000s rows of SQL 7 DB Table: USERS. with this information so that Colum LASTVISITEDDATE will have now() value for each person that was on that list. Any brighter ideas then .loop list UPDATE WHERE userID='x end loop OR UPDATE WHERE userID='x' OR userID='y' OR userID='n...' Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL SERVER and IIS on the same machine?
And you use CF to call database all the time? I've heard that it's possible to have CF connected to the database in a single, stable connection and to avoid the re-connection all the time. will this helps to increase performance, when the database is rapidly accessed? Michael. - Original Message - From: "Mark Woods" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 11:31 AM Subject: Re: SQL SERVER and IIS on the same machine? > one of the sites I'm involved in serves about 8 million pages a month, well > over half of them requiring a database connection (most of these will have > more than one query) and the site runs on a dual processor pentium III with > win2000 and SQL Server 7 - no problems. Just make sure you spend a lot of > time optimizing the server for performance and most importantly, stick a > load of RAM into it, at least 1 GB. > > Nobody would recommend a single server config for a high traffic web site > if the company had money to burn, but who has these days? > > > Mark > > > At 10:40 AM 22/04/2001, you wrote: > >Our hosting company told me they don't support SQL SERVER > >and IIS on the same NT machine. > >"Even Microsoft doesn't recommened it", they claim. > > > >What do you think? Money is always an issue... > > > >Thanks, > > > >-Michael. > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
UPDATE / INSERT
I'm trying to find the best way to have SQL do this:
IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
Currently I'm using SELECT / RecordCount to first find out if the VALUE exists.
There must be a better way...
Michael.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating 1000s of records
Didn't quite understand what you mean. The .txt file was created by an external COM object on a remote server. I got the file to calculate stats on a diffrent machine too. - Original Message - From: "Peter Tilbrook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 12:56 PM Subject: RE: Updating 1000s of records > Isn't this information already stored under CGLOBALS as a client variable? > > > -Original Message- > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 22 April 2001 20:18 > To: CF-Talk > Subject: Updating 1000s of records > > > Our application is built like that so I'm reciving a daily .txt file with > 1000s of lines. each line > with a unique number that is userID. userID that is on this text file means > he visited our site > in the last 24 hours (complex, I know.. bear with me) > > I'm trying to find the best way to update 1000s rows of SQL 7 DB Table: > USERS. > with this information so that Colum LASTVISITEDDATE will have now() value > for each > person that was on that list. > > Any brighter ideas then > > .loop list > UPDATE WHERE userID='x > end loop > > OR > > UPDATE WHERE userID='x' OR userID='y' OR userID='n...' > > > Thanks, > > Michael Lugassy > Interactive Music Ltd. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE / INSERT
Micheal,
Thinking about it, if the value does exist and you simply want to check what
that value is before updating, you could always do an update irrespective of
the value, sure, this will mean doing an un-necessary update sometimes, but
isn't that better than making two connections (select & update) if the
update is required. Only a thought.
Phil.
> -Original Message-
> From: Phil Ewington [mailto:[EMAIL PROTECTED]]
> Sent: 22 April 2001 12:04
> To: CF-Talk
> Subject: RE: UPDATE / INSERT
>
>
> Do you mean if the record exists UPDATE, or if the value in the column is
> specified update?
>
> If the record does not exist, use cftry/cfcatch: try UPDATE, if fails do
> INSERT.
>
> If the record exists but value is NULL, you are probably better
> off setting
> the columns default value to zero, this way you will always be able to
> increment the value by 1 using UPDATE.
>
> HTH
>
> Phil.
>
> > -Original Message-
> > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > Sent: 22 April 2001 13:06
> > To: CF-Talk
> > Subject: UPDATE / INSERT
> >
> >
> > I'm trying to find the best way to have SQL do this:
> > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> >
> > Currently I'm using SELECT / RecordCount to first find out if the
> > VALUE exists.
> >
> > There must be a better way...
> >
> > Michael.
> >
> >
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE / INSERT
but if the value is not exists in "COLUM" I'll need to use INSERT to assign
default values.
I can't predicte all the possible values, so I can't make a
"READY-FOR-UPDATE-ONLY" table.
- Original Message -
From: "Phil Ewington" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, April 22, 2001 1:18 PM
Subject: RE: UPDATE / INSERT
> Micheal,
>
> Thinking about it, if the value does exist and you simply want to check
what
> that value is before updating, you could always do an update irrespective
of
> the value, sure, this will mean doing an un-necessary update sometimes,
but
> isn't that better than making two connections (select & update) if the
> update is required. Only a thought.
>
>
> Phil.
>
> > -Original Message-
> > From: Phil Ewington [mailto:[EMAIL PROTECTED]]
> > Sent: 22 April 2001 12:04
> > To: CF-Talk
> > Subject: RE: UPDATE / INSERT
> >
> >
> > Do you mean if the record exists UPDATE, or if the value in the column
is
> > specified update?
> >
> > If the record does not exist, use cftry/cfcatch: try UPDATE, if fails do
> > INSERT.
> >
> > If the record exists but value is NULL, you are probably better
> > off setting
> > the columns default value to zero, this way you will always be able to
> > increment the value by 1 using UPDATE.
> >
> > HTH
> >
> > Phil.
> >
> > > -Original Message-
> > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > Sent: 22 April 2001 13:06
> > > To: CF-Talk
> > > Subject: UPDATE / INSERT
> > >
> > >
> > > I'm trying to find the best way to have SQL do this:
> > > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> > >
> > > Currently I'm using SELECT / RecordCount to first find out if the
> > > VALUE exists.
> > >
> > > There must be a better way...
> > >
> > > Michael.
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Was AW: WARNING: PCAnywhere -> PCAnywhere functions on a linux box ?
I've set up VNC on a headless box to get XWindows access... you need to make sure you have your server set up and running correctly. I haven't played with it since I got my switchbox working, so that's about the best help I can provide. If memory serves correctly I had to set up the server to create an instance of xWindows. KDE didn't come up directly. Something else *NIX fans might look into is remote xWindows servers. These are programs that access a box directly and connect as an extra terminal. The "servers" (I can't remember why that is the correct syntax, but it confused me too) aren't free, but I know from first hand experience that they can be made to work. You can even set it up so that you log in directly through KDE. HTH Hatton Humphrey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 4:51 AM To: CF-Talk Subject: OT: Was AW: WARNING: PCAnywhere -> PCAnywhere functions on a linux box ? o.k. Beside the discussion of PCA on WIN-Plattform, what can I use to get graphical interface to a linux box ? (I have a KDE running on the linux box) I tried VNC but it only gives me a view on the linux command shell. Ideas ? Uwe -Ursprüngliche Nachricht- Von: Bud [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 22. April 2001 10:25 An: CF-Talk Betreff: RE: WARNING: PCAnywhere On 4/21/01, Paul Smith penned: >So how would it work if I downloaded it to my remote server I manage with VNC? > >Does RAdmin require a boot after install? If so, I'm not sure I could >trust it to come up. Yes, it does require a reboot. I downloaded it to my computer at home, uploaded it to the server and installed it with pcA then uninstalled pcA after a couple days. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WARNING: PCAnywhere
I had a problem like this once on NT4 and switched to Remotely Anywhere (http://www.remotelyanyhwere.com/). Haven't looked back. On Win2k you can use Terminal Services (in Remote Administration mode) and the Termincal Services Client - works great. > A failed installation (attempting to upgrade ver. 8 to ver. 10) on an NT4, > sp6 server literally destroyed the server OS, making it impossible to boot > the OS without a "blue screen." This just happened to be an important > production server without a ghosted system partition. We had to rebuild from > scratch on another box. Almost lost a Very Important Client or two. > > When I contacted Symantec, they charged me $29.95 to tell me that I was > "hosed." > > If you are not using PCAnywhere, do not start. If you have an older version, > upgrade with the greatest of risk. > > > > Rick Colman > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE / INSERT
You need to set your table to have COLUM1 have a value 0 assigned by
default, this is possible in SQL not sure about other dbs. When a record is
created, COLUM1 will be automatically assigned a value of 0 by default. So,
if you always do an update, the value will be updated even if you have not
previously assigned a value. Does this make sense?
Phil.
> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: 22 April 2001 13:59
> To: CF-Talk
> Subject: Re: UPDATE / INSERT
>
>
> but if the value is not exists in "COLUM" I'll need to use INSERT
> to assign
> default values.
> I can't predicte all the possible values, so I can't make a
> "READY-FOR-UPDATE-ONLY" table.
>
>
> - Original Message -
> From: "Phil Ewington" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, April 22, 2001 1:18 PM
> Subject: RE: UPDATE / INSERT
>
>
> > Micheal,
> >
> > Thinking about it, if the value does exist and you simply want to check
> what
> > that value is before updating, you could always do an update
> irrespective
> of
> > the value, sure, this will mean doing an un-necessary update sometimes,
> but
> > isn't that better than making two connections (select & update) if the
> > update is required. Only a thought.
> >
> >
> > Phil.
> >
> > > -Original Message-
> > > From: Phil Ewington [mailto:[EMAIL PROTECTED]]
> > > Sent: 22 April 2001 12:04
> > > To: CF-Talk
> > > Subject: RE: UPDATE / INSERT
> > >
> > >
> > > Do you mean if the record exists UPDATE, or if the value in the column
> is
> > > specified update?
> > >
> > > If the record does not exist, use cftry/cfcatch: try UPDATE,
> if fails do
> > > INSERT.
> > >
> > > If the record exists but value is NULL, you are probably better
> > > off setting
> > > the columns default value to zero, this way you will always be able to
> > > increment the value by 1 using UPDATE.
> > >
> > > HTH
> > >
> > > Phil.
> > >
> > > > -Original Message-
> > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > Sent: 22 April 2001 13:06
> > > > To: CF-Talk
> > > > Subject: UPDATE / INSERT
> > > >
> > > >
> > > > I'm trying to find the best way to have SQL do this:
> > > > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > > > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> > > >
> > > > Currently I'm using SELECT / RecordCount to first find out if the
> > > > VALUE exists.
> > > >
> > > > There must be a better way...
> > > >
> > > > Michael.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE / INSERT
It'll only work if I have all the possible values already placed in COLUM1.
- Original Message -
From: "Phil Ewington" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, April 22, 2001 2:34 PM
Subject: RE: UPDATE / INSERT
> You need to set your table to have COLUM1 have a value 0 assigned by
> default, this is possible in SQL not sure about other dbs. When a record
is
> created, COLUM1 will be automatically assigned a value of 0 by default.
So,
> if you always do an update, the value will be updated even if you have not
> previously assigned a value. Does this make sense?
>
>
> Phil.
>
> > -Original Message-
> > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > Sent: 22 April 2001 13:59
> > To: CF-Talk
> > Subject: Re: UPDATE / INSERT
> >
> >
> > but if the value is not exists in "COLUM" I'll need to use INSERT
> > to assign
> > default values.
> > I can't predicte all the possible values, so I can't make a
> > "READY-FOR-UPDATE-ONLY" table.
> >
> >
> > - Original Message -
> > From: "Phil Ewington" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Sunday, April 22, 2001 1:18 PM
> > Subject: RE: UPDATE / INSERT
> >
> >
> > > Micheal,
> > >
> > > Thinking about it, if the value does exist and you simply want to
check
> > what
> > > that value is before updating, you could always do an update
> > irrespective
> > of
> > > the value, sure, this will mean doing an un-necessary update
sometimes,
> > but
> > > isn't that better than making two connections (select & update) if the
> > > update is required. Only a thought.
> > >
> > >
> > > Phil.
> > >
> > > > -Original Message-
> > > > From: Phil Ewington [mailto:[EMAIL PROTECTED]]
> > > > Sent: 22 April 2001 12:04
> > > > To: CF-Talk
> > > > Subject: RE: UPDATE / INSERT
> > > >
> > > >
> > > > Do you mean if the record exists UPDATE, or if the value in the
column
> > is
> > > > specified update?
> > > >
> > > > If the record does not exist, use cftry/cfcatch: try UPDATE,
> > if fails do
> > > > INSERT.
> > > >
> > > > If the record exists but value is NULL, you are probably better
> > > > off setting
> > > > the columns default value to zero, this way you will always be able
to
> > > > increment the value by 1 using UPDATE.
> > > >
> > > > HTH
> > > >
> > > > Phil.
> > > >
> > > > > -Original Message-
> > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 22 April 2001 13:06
> > > > > To: CF-Talk
> > > > > Subject: UPDATE / INSERT
> > > > >
> > > > >
> > > > > I'm trying to find the best way to have SQL do this:
> > > > > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > > > > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> > > > >
> > > > > Currently I'm using SELECT / RecordCount to first find out if the
> > > > > VALUE exists.
> > > > >
> > > > > There must be a better way...
> > > > >
> > > > > Michael.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE / INSERT
Do you mean if the record exists UPDATE, or if the value in the column is
specified update?
If the record does not exist, use cftry/cfcatch: try UPDATE, if fails do
INSERT.
If the record exists but value is NULL, you are probably better off setting
the columns default value to zero, this way you will always be able to
increment the value by 1 using UPDATE.
HTH
Phil.
> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: 22 April 2001 13:06
> To: CF-Talk
> Subject: UPDATE / INSERT
>
>
> I'm trying to find the best way to have SQL do this:
> IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
>
> Currently I'm using SELECT / RecordCount to first find out if the
> VALUE exists.
>
> There must be a better way...
>
> Michael.
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE / INSERT
Please post your current SELECT/UPDATE code so I can see exactly what you
are doing.
Phil.
> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: 22 April 2001 15:30
> To: CF-Talk
> Subject: Re: UPDATE / INSERT
>
>
> It'll only work if I have all the possible values already placed
> in COLUM1.
>
> - Original Message -
> From: "Phil Ewington" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, April 22, 2001 2:34 PM
> Subject: RE: UPDATE / INSERT
>
>
> > You need to set your table to have COLUM1 have a value 0 assigned by
> > default, this is possible in SQL not sure about other dbs. When a record
> is
> > created, COLUM1 will be automatically assigned a value of 0 by default.
> So,
> > if you always do an update, the value will be updated even if
> you have not
> > previously assigned a value. Does this make sense?
> >
> >
> > Phil.
> >
> > > -Original Message-
> > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > Sent: 22 April 2001 13:59
> > > To: CF-Talk
> > > Subject: Re: UPDATE / INSERT
> > >
> > >
> > > but if the value is not exists in "COLUM" I'll need to use INSERT
> > > to assign
> > > default values.
> > > I can't predicte all the possible values, so I can't make a
> > > "READY-FOR-UPDATE-ONLY" table.
> > >
> > >
> > > - Original Message -
> > > From: "Phil Ewington" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Sunday, April 22, 2001 1:18 PM
> > > Subject: RE: UPDATE / INSERT
> > >
> > >
> > > > Micheal,
> > > >
> > > > Thinking about it, if the value does exist and you simply want to
> check
> > > what
> > > > that value is before updating, you could always do an update
> > > irrespective
> > > of
> > > > the value, sure, this will mean doing an un-necessary update
> sometimes,
> > > but
> > > > isn't that better than making two connections (select &
> update) if the
> > > > update is required. Only a thought.
> > > >
> > > >
> > > > Phil.
> > > >
> > > > > -Original Message-
> > > > > From: Phil Ewington [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 22 April 2001 12:04
> > > > > To: CF-Talk
> > > > > Subject: RE: UPDATE / INSERT
> > > > >
> > > > >
> > > > > Do you mean if the record exists UPDATE, or if the value in the
> column
> > > is
> > > > > specified update?
> > > > >
> > > > > If the record does not exist, use cftry/cfcatch: try UPDATE,
> > > if fails do
> > > > > INSERT.
> > > > >
> > > > > If the record exists but value is NULL, you are probably better
> > > > > off setting
> > > > > the columns default value to zero, this way you will
> always be able
> to
> > > > > increment the value by 1 using UPDATE.
> > > > >
> > > > > HTH
> > > > >
> > > > > Phil.
> > > > >
> > > > > > -Original Message-
> > > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: 22 April 2001 13:06
> > > > > > To: CF-Talk
> > > > > > Subject: UPDATE / INSERT
> > > > > >
> > > > > >
> > > > > > I'm trying to find the best way to have SQL do this:
> > > > > > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > > > > > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> > > > > >
> > > > > > Currently I'm using SELECT / RecordCount to first find
> out if the
> > > > > > VALUE exists.
> > > > > >
> > > > > > There must be a better way...
> > > > > >
> > > > > > Michael.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE / INSERT
something like this.
Thanks!
SELECT DN from logs WHERE DT=#DT#
UPDATE logs
SET DN=DN+#DN# WHERE DT=#DT#
INSERT INTO logs (DN,DT) VALUES (#DN#,#DT#)
- Original Message -
From: "Phil Ewington" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, April 22, 2001 3:20 PM
Subject: RE: UPDATE / INSERT
> Please post your current SELECT/UPDATE code so I can see exactly what you
> are doing.
>
>
> Phil.
>
> > -Original Message-
> > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > Sent: 22 April 2001 15:30
> > To: CF-Talk
> > Subject: Re: UPDATE / INSERT
> >
> >
> > It'll only work if I have all the possible values already placed
> > in COLUM1.
> >
> > - Original Message -
> > From: "Phil Ewington" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Sunday, April 22, 2001 2:34 PM
> > Subject: RE: UPDATE / INSERT
> >
> >
> > > You need to set your table to have COLUM1 have a value 0 assigned by
> > > default, this is possible in SQL not sure about other dbs. When a
record
> > is
> > > created, COLUM1 will be automatically assigned a value of 0 by
default.
> > So,
> > > if you always do an update, the value will be updated even if
> > you have not
> > > previously assigned a value. Does this make sense?
> > >
> > >
> > > Phil.
> > >
> > > > -Original Message-
> > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > Sent: 22 April 2001 13:59
> > > > To: CF-Talk
> > > > Subject: Re: UPDATE / INSERT
> > > >
> > > >
> > > > but if the value is not exists in "COLUM" I'll need to use INSERT
> > > > to assign
> > > > default values.
> > > > I can't predicte all the possible values, so I can't make a
> > > > "READY-FOR-UPDATE-ONLY" table.
> > > >
> > > >
> > > > - Original Message -
> > > > From: "Phil Ewington" <[EMAIL PROTECTED]>
> > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > Sent: Sunday, April 22, 2001 1:18 PM
> > > > Subject: RE: UPDATE / INSERT
> > > >
> > > >
> > > > > Micheal,
> > > > >
> > > > > Thinking about it, if the value does exist and you simply want to
> > check
> > > > what
> > > > > that value is before updating, you could always do an update
> > > > irrespective
> > > > of
> > > > > the value, sure, this will mean doing an un-necessary update
> > sometimes,
> > > > but
> > > > > isn't that better than making two connections (select &
> > update) if the
> > > > > update is required. Only a thought.
> > > > >
> > > > >
> > > > > Phil.
> > > > >
> > > > > > -Original Message-
> > > > > > From: Phil Ewington [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: 22 April 2001 12:04
> > > > > > To: CF-Talk
> > > > > > Subject: RE: UPDATE / INSERT
> > > > > >
> > > > > >
> > > > > > Do you mean if the record exists UPDATE, or if the value in the
> > column
> > > > is
> > > > > > specified update?
> > > > > >
> > > > > > If the record does not exist, use cftry/cfcatch: try UPDATE,
> > > > if fails do
> > > > > > INSERT.
> > > > > >
> > > > > > If the record exists but value is NULL, you are probably better
> > > > > > off setting
> > > > > > the columns default value to zero, this way you will
> > always be able
> > to
> > > > > > increment the value by 1 using UPDATE.
> > > > > >
> > > > > > HTH
> > > > > >
> > > > > > Phil.
> > > > > >
> > > > > > > -Original Message-
> > > > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > > > > Sent: 22 April 2001 13:06
> > > > > > > To: CF-Talk
> > > > > > > Subject: UPDATE / INSERT
> > > > > > >
> > > > > > >
> > > > > > > I'm trying to find the best way to have SQL do this:
> > > > > > > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > > > > > > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> > > > > > >
> > > > > > > Currently I'm using SELECT / RecordCount to first find
> > out if the
> > > > > > > VALUE exists.
> > > > > > >
> > > > > > > There must be a better way...
> > > > > > >
> > > > > > > Michael.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Setting form var with Java
FWIW, it's cleaner to simply pass in the object itself rather than its name.
Here's how I'd write it:
function changevalue(Field) {
var oldvalue;
var newvalue;
oldvalue = Field.value;
TAKE ACTION HERE
Field.value = newvalue;
}
and here's an example of how to pass in the Field object:
-David
On Wednesday, April 18, 2001 12:30 PM, Bruce, Rodney [SMTP:[EMAIL PROTECTED]]
wrote:
> Thanks for all the suggestions
>
> The one I got to work was Mark's below.
>
>
> Thanks again
> -Original Message-
> From: Mark Rowntree [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 9:15 AM
> To: CF-Talk
> Subject: Re: Setting form var with Java
>
>
> try:
>
> document.forms[FormName].elements[FieldName].value
>
> Let me know.
>
> Mark Rowntree
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE / INSERT
OK, u.recordcount could be 0 if the record you are expecting to find does
not exist or if the value of DT in that record does not match your criteria.
Your code will create a new record if either of the above is true. If this
is what you want I can't really see a better way of doing it.
Phil.
> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: 22 April 2001 15:51
> To: CF-Talk
> Subject: Re: UPDATE / INSERT
>
>
> something like this.
>
> Thanks!
>
>
> SELECT DN from logs WHERE DT=#DT#
>
>
>
>
> UPDATE logs
> SET DN=DN+#DN# WHERE DT=#DT#
>
>
>
>
> INSERT INTO logs (DN,DT) VALUES (#DN#,#DT#)
>
>
>
>
> - Original Message -
> From: "Phil Ewington" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, April 22, 2001 3:20 PM
> Subject: RE: UPDATE / INSERT
>
>
> > Please post your current SELECT/UPDATE code so I can see
> exactly what you
> > are doing.
> >
> >
> > Phil.
> >
> > > -Original Message-
> > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > Sent: 22 April 2001 15:30
> > > To: CF-Talk
> > > Subject: Re: UPDATE / INSERT
> > >
> > >
> > > It'll only work if I have all the possible values already placed
> > > in COLUM1.
> > >
> > > - Original Message -
> > > From: "Phil Ewington" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Sunday, April 22, 2001 2:34 PM
> > > Subject: RE: UPDATE / INSERT
> > >
> > >
> > > > You need to set your table to have COLUM1 have a value 0 assigned by
> > > > default, this is possible in SQL not sure about other dbs. When a
> record
> > > is
> > > > created, COLUM1 will be automatically assigned a value of 0 by
> default.
> > > So,
> > > > if you always do an update, the value will be updated even if
> > > you have not
> > > > previously assigned a value. Does this make sense?
> > > >
> > > >
> > > > Phil.
> > > >
> > > > > -Original Message-
> > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 22 April 2001 13:59
> > > > > To: CF-Talk
> > > > > Subject: Re: UPDATE / INSERT
> > > > >
> > > > >
> > > > > but if the value is not exists in "COLUM" I'll need to use INSERT
> > > > > to assign
> > > > > default values.
> > > > > I can't predicte all the possible values, so I can't make a
> > > > > "READY-FOR-UPDATE-ONLY" table.
> > > > >
> > > > >
> > > > > - Original Message -
> > > > > From: "Phil Ewington" <[EMAIL PROTECTED]>
> > > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > > Sent: Sunday, April 22, 2001 1:18 PM
> > > > > Subject: RE: UPDATE / INSERT
> > > > >
> > > > >
> > > > > > Micheal,
> > > > > >
> > > > > > Thinking about it, if the value does exist and you
> simply want to
> > > check
> > > > > what
> > > > > > that value is before updating, you could always do an update
> > > > > irrespective
> > > > > of
> > > > > > the value, sure, this will mean doing an un-necessary update
> > > sometimes,
> > > > > but
> > > > > > isn't that better than making two connections (select &
> > > update) if the
> > > > > > update is required. Only a thought.
> > > > > >
> > > > > >
> > > > > > Phil.
> > > > > >
> > > > > > > -Original Message-
> > > > > > > From: Phil Ewington [mailto:[EMAIL PROTECTED]]
> > > > > > > Sent: 22 April 2001 12:04
> > > > > > > To: CF-Talk
> > > > > > > Subject: RE: UPDATE / INSERT
> > > > > > >
> > > > > > >
> > > > > > > Do you mean if the record exists UPDATE, or if the
> value in the
> > > column
> > > > > is
> > > > > > > specified update?
> > > > > > >
> > > > > > > If the record does not exist, use cftry/cfcatch: try UPDATE,
> > > > > if fails do
> > > > > > > INSERT.
> > > > > > >
> > > > > > > If the record exists but value is NULL, you are
> probably better
> > > > > > > off setting
> > > > > > > the columns default value to zero, this way you will
> > > always be able
> > > to
> > > > > > > increment the value by 1 using UPDATE.
> > > > > > >
> > > > > > > HTH
> > > > > > >
> > > > > > > Phil.
> > > > > > >
> > > > > > > > -Original Message-
> > > > > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > > > > > Sent: 22 April 2001 13:06
> > > > > > > > To: CF-Talk
> > > > > > > > Subject: UPDATE / INSERT
> > > > > > > >
> > > > > > > >
> > > > > > > > I'm trying to find the best way to have SQL do this:
> > > > > > > > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > > > > > > > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> > > > > > > >
> > > > > > > > Currently I'm using SELECT / RecordCount to first find
> > > out if the
> > > > > > > > VALUE exists.
> > > > > > > >
> > > > > > > > There must be a better way...
> > > > > > > >
> > > > > > > > Michael.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthori
Re: UPDATE / INSERT
Will CFCATCH/CFTRY with DATABASE error be a better solution? i.e - TRY TO UPDATE no matter what -> if error occurs (row not exists) -> INSERT. Is this better then SELECT? :) - Original Message - From: "Phil Ewington" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 4:29 PM Subject: RE: UPDATE / INSERT > OK, u.recordcount could be 0 if the record you are expecting to find does > not exist or if the value of DT in that record does not match your criteria. > Your code will create a new record if either of the above is true. If this > is what you want I can't really see a better way of doing it. > > Phil. > > > -Original Message- > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > Sent: 22 April 2001 15:51 > > To: CF-Talk > > Subject: Re: UPDATE / INSERT > > > > > > something like this. > > > > Thanks! > > > > > > SELECT DN from logs WHERE DT=#DT# > > > > > > > > > > UPDATE logs > > SET DN=DN+#DN# WHERE DT=#DT# > > > > > > > > > > INSERT INTO logs (DN,DT) VALUES (#DN#,#DT#) > > > > > > > > > > - Original Message - > > From: "Phil Ewington" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, April 22, 2001 3:20 PM > > Subject: RE: UPDATE / INSERT > > > > > > > Please post your current SELECT/UPDATE code so I can see > > exactly what you > > > are doing. > > > > > > > > > Phil. > > > > > > > -Original Message- > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > > > Sent: 22 April 2001 15:30 > > > > To: CF-Talk > > > > Subject: Re: UPDATE / INSERT > > > > > > > > > > > > It'll only work if I have all the possible values already placed > > > > in COLUM1. > > > > > > > > - Original Message - > > > > From: "Phil Ewington" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Sunday, April 22, 2001 2:34 PM > > > > Subject: RE: UPDATE / INSERT > > > > > > > > > > > > > You need to set your table to have COLUM1 have a value 0 assigned by > > > > > default, this is possible in SQL not sure about other dbs. When a > > record > > > > is > > > > > created, COLUM1 will be automatically assigned a value of 0 by > > default. > > > > So, > > > > > if you always do an update, the value will be updated even if > > > > you have not > > > > > previously assigned a value. Does this make sense? > > > > > > > > > > > > > > > Phil. > > > > > > > > > > > -Original Message- > > > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > > > > > Sent: 22 April 2001 13:59 > > > > > > To: CF-Talk > > > > > > Subject: Re: UPDATE / INSERT > > > > > > > > > > > > > > > > > > but if the value is not exists in "COLUM" I'll need to use INSERT > > > > > > to assign > > > > > > default values. > > > > > > I can't predicte all the possible values, so I can't make a > > > > > > "READY-FOR-UPDATE-ONLY" table. > > > > > > > > > > > > > > > > > > - Original Message - > > > > > > From: "Phil Ewington" <[EMAIL PROTECTED]> > > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > > Sent: Sunday, April 22, 2001 1:18 PM > > > > > > Subject: RE: UPDATE / INSERT > > > > > > > > > > > > > > > > > > > Micheal, > > > > > > > > > > > > > > Thinking about it, if the value does exist and you > > simply want to > > > > check > > > > > > what > > > > > > > that value is before updating, you could always do an update > > > > > > irrespective > > > > > > of > > > > > > > the value, sure, this will mean doing an un-necessary update > > > > sometimes, > > > > > > but > > > > > > > isn't that better than making two connections (select & > > > > update) if the > > > > > > > update is required. Only a thought. > > > > > > > > > > > > > > > > > > > > > Phil. > > > > > > > > > > > > > > > -Original Message- > > > > > > > > From: Phil Ewington [mailto:[EMAIL PROTECTED]] > > > > > > > > Sent: 22 April 2001 12:04 > > > > > > > > To: CF-Talk > > > > > > > > Subject: RE: UPDATE / INSERT > > > > > > > > > > > > > > > > > > > > > > > > Do you mean if the record exists UPDATE, or if the > > value in the > > > > column > > > > > > is > > > > > > > > specified update? > > > > > > > > > > > > > > > > If the record does not exist, use cftry/cfcatch: try UPDATE, > > > > > > if fails do > > > > > > > > INSERT. > > > > > > > > > > > > > > > > If the record exists but value is NULL, you are > > probably better > > > > > > > > off setting > > > > > > > > the columns default value to zero, this way you will > > > > always be able > > > > to > > > > > > > > increment the value by 1 using UPDATE. > > > > > > > > > > > > > > > > HTH > > > > > > > > > > > > > > > > Phil. > > > > > > > > > > > > > > > > > -Original Message- > > > > > > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > > > > > > > > Sent: 22 April 2001 13:06 > > > > > > > > > To: CF-Talk > > > > > > > > > Subject: UPDATE / INSERT > > > > > > > > > > > > > > > > > > > > > > > > > > > I'm trying to find the best way to have SQL do this: > > > > > >
Re: CFExcute doesn't run EXEs
SUBJECT CLOSED. I moved the arj32.exe to a diffrent directory then C:\inetpub worked like a charm! Michael. - Original Message - From: "Craig Dudley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 6:14 PM Subject: RE: CFExcute doesn't run EXEs > Have you tried adding a timeout value to cfexecute ? > > > > > -Original Message- > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > Sent: 19 April 2001 14:33 > To: CF-Talk > Subject: Re: CFExcute doesn't run EXEs > > > Very simple Code: > > > the arjlogs.bat contains this line (which works great when I double click it > from explorer): > > c:\inetpub\arj\arj32.exe a -e -hm1 -i -jm -y c:\inetpub\logs\summary.arj > c:\inetpub\logs\*.log > > > > - Original Message - > From: "Terry Bader" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, April 19, 2001 2:23 PM > Subject: RE: CFExcute doesn't run EXEs > > > > got code? > > > > > > Terry Bader > > IT/Web Specialist > > EDO Corp - Combat Systems > > (757) 424-1004 ext 361 - Work > > [EMAIL PROTECTED] > > > > > > (757)581-5981 - Mobile > > [EMAIL PROTECTED] > > icq: 5202487 aim: lv2bounce > > http://www.cs.odu.edu/~bader > > > > > > > > > > > > > > > -Original Message- > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, April 19, 2001 9:12 AM > > > To: CF-Talk > > > Subject: CFExcute doesn't run EXEs > > > > > > > > > I'm having problems with CFEXCUTE. > > > apperntly I can run stricly bat files that contains > > > commands like: move, copy and such.. > > > > > > but I can't seem to run .exe files (not directly with > > > cfexcute, nor with .bat that runs them). > > > > > > The exe file is stored on a foder where > > > INTERNET USER/SYSTEM have both full rights. > > > Also, I've set IIS to run scripts&excutebals on this > > > directory and the directroy that runs the CF template. > > > > > > > > > Anyone? > > > > > > Thanks, > > > > > > Michael Lugassy > > > Interactive Music Ltd. > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE / INSERT
The method I have used for using CFTRY/CFCATCH is for when I want to update a column if the record exists, if not then create the record. However I would only use this if you expect the update to succeed more than fail, the reason for this is that an entry is made to application.log each time the update fails. Even though your application.log should be checked and cleared regularly, I found that in a short space of time the size of the log increased greatly. Still not sure whether CF should write to the log as the error has been handled, argument here for whether this is bug in CF. This was a problem for me due to very high levels of traffic. Here's the code anyway: UPDATE logs SET DN=DN+#DN# WHERE DT=#DT# INSERT INTO logs (DN,DT) VALUES (#DN#,#DT#) HTH Phil. > -Original Message- > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > Sent: 22 April 2001 16:59 > To: CF-Talk > Subject: Re: UPDATE / INSERT > > > Will CFCATCH/CFTRY with DATABASE error be a better solution? > i.e - TRY TO UPDATE no matter what -> if error occurs (row not exists) -> > INSERT. > Is this better then SELECT? > > :) > > - Original Message - > From: "Phil Ewington" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, April 22, 2001 4:29 PM > Subject: RE: UPDATE / INSERT > > > > OK, u.recordcount could be 0 if the record you are expecting to > find does > > not exist or if the value of DT in that record does not match your > criteria. > > Your code will create a new record if either of the above is > true. If this > > is what you want I can't really see a better way of doing it. > > > > Phil. > > > > > -Original Message- > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > > Sent: 22 April 2001 15:51 > > > To: CF-Talk > > > Subject: Re: UPDATE / INSERT > > > > > > > > > something like this. > > > > > > Thanks! > > > > > > > > > SELECT DN from logs WHERE DT=#DT# > > > > > > > > > > > > > > > UPDATE logs > > > SET DN=DN+#DN# WHERE DT=#DT# > > > > > > > > > > > > > > > INSERT INTO logs (DN,DT) VALUES (#DN#,#DT#) > > > > > > > > > > > > > > > - Original Message - > > > From: "Phil Ewington" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Sunday, April 22, 2001 3:20 PM > > > Subject: RE: UPDATE / INSERT > > > > > > > > > > Please post your current SELECT/UPDATE code so I can see > > > exactly what you > > > > are doing. > > > > > > > > > > > > Phil. > > > > > > > > > -Original Message- > > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > > > > Sent: 22 April 2001 15:30 > > > > > To: CF-Talk > > > > > Subject: Re: UPDATE / INSERT > > > > > > > > > > > > > > > It'll only work if I have all the possible values already placed > > > > > in COLUM1. > > > > > > > > > > - Original Message - > > > > > From: "Phil Ewington" <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Sunday, April 22, 2001 2:34 PM > > > > > Subject: RE: UPDATE / INSERT > > > > > > > > > > > > > > > > You need to set your table to have COLUM1 have a value > 0 assigned > by > > > > > > default, this is possible in SQL not sure about other > dbs. When a > > > record > > > > > is > > > > > > created, COLUM1 will be automatically assigned a value of 0 by > > > default. > > > > > So, > > > > > > if you always do an update, the value will be updated even if > > > > > you have not > > > > > > previously assigned a value. Does this make sense? > > > > > > > > > > > > > > > > > > Phil. > > > > > > > > > > > > > -Original Message- > > > > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > > > > > > > Sent: 22 April 2001 13:59 > > > > > > > To: CF-Talk > > > > > > > Subject: Re: UPDATE / INSERT > > > > > > > > > > > > > > > > > > > > > but if the value is not exists in "COLUM" I'll need to use > INSERT > > > > > > > to assign > > > > > > > default values. > > > > > > > I can't predicte all the possible values, so I can't make a > > > > > > > "READY-FOR-UPDATE-ONLY" table. > > > > > > > > > > > > > > > > > > > > > - Original Message - > > > > > > > From: "Phil Ewington" <[EMAIL PROTECTED]> > > > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > > > Sent: Sunday, April 22, 2001 1:18 PM > > > > > > > Subject: RE: UPDATE / INSERT > > > > > > > > > > > > > > > > > > > > > > Micheal, > > > > > > > > > > > > > > > > Thinking about it, if the value does exist and you > > > simply want to > > > > > check > > > > > > > what > > > > > > > > that value is before updating, you could always do an update > > > > > > > irrespective > > > > > > > of > > > > > > > > the value, sure, this will mean doing an un-necessary update > > > > > sometimes, > > > > > > > but > > > > > > > > isn't that better than making two connections (select & > > > > > update) if the > > > > > > > > update is required. Only a thought. > > > > > > > > > > > > > > > > > > > > > > > > Phil. > > > > > > > > > > > > > > > > > -Orig
Re: Image size
I use cfx_image which automatically creates a thumbnail (or any other size you want). It uses image.dll. The properties tab say it was made by Cap Gemini and copyright by Jukka Manner. It looks to me like CF_GIFGD is the successor to this. It is in the gallery, by the same author, and does thumbnails and lots of other stuff. I haven't used it. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34726E-2830-11D4-AA 9700508B94F380&method=Full - Original Message - From: "Skip Ogden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 1:07 PM Subject: Image size > The Allaire Developers forum used to have a tag called cfx_imagesize (or > something close to that). It isn't there any more, or I can't locate it. > > Does anyone know of ANY way to automatically create a thumbnail from an > image as it is uploaded (with cffile) > > Thanks... > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL SERVER and IIS on the same machine?
Adrian Cooper wrote: > Even redundancy isn't a reason to run two seperate servers, because if either > of > the servers and/or the ODBC/OLEDB connection across the network goes down, the > entire site is down anyway. I believe that the separation is done to ensure data integrity when the web server goes down. -- The fascination of shooting as a sport depends almost wholly on whether you are at the right or wrong end of the gun. P. G. Wodehouse email: [EMAIL PROTECTED] web: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL SERVER and IIS on the same machine?
It really depends I did it for a long time. Never had major problems. HOwever when I finally moved SQL to it's own server I did have performance improvements, used less memories and had fewer errors. Not that there was a major problem while SQL was on the same server it just performs better when it's not. The big thing is to just monitor it. And set your SQL memory not to go over a certain limit, because it really has an appetite for memory otherwise. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 5:40 AM To: CF-Talk Subject: SQL SERVER and IIS on the same machine? Our hosting company told me they don't support SQL SERVER and IIS on the same NT machine. "Even Microsoft doesn't recommened it", they claim. What do you think? Money is always an issue... Thanks, -Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: no buffer space available
It means your system is out of resources. http://www.sockets.com/err_lst1.htm#WSAENOBUFS HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "S R" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 7:00 PM Subject: no buffer space available > Hi, > > This is not really a CF question but if anyone can help that would be > awesome!! I've been using CuteFTP to upload files to my server which is a > windows NT server. All of a sudden when I tried to connect to the server I > get an error message that says Error 10055 in function bind 'No buffer Space > Available'. > > This is scary because I can't upload anything now. Does anyone know how to > fix this??? > > SR > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Good COM resource
I thought this looked like an excellent resource, for those of you who already know this my apologies for duplicating information. http://www.cfcomet.com/cfcomet/ Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.macromedia.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
graphing
Does any one know of a good graphing solution for a cf app? I do not want to use the allaire applets. I would prefer not using an applet at all. I looked at Corda Pop charts (www.popcharts.com). They have a great product (generates flash graphs) just a little out of my price range. Any ideas? Brook Davies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
Brook, CF5, which is just about nearing the end of its beta cycle (due out in June) has graphing built in. So, if you can wait a few weeks, or if you can access the beta version, that's probably your best bet. --- Ben -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 4:11 PM To: CF-Talk Subject: graphing Does any one know of a good graphing solution for a cf app? I do not want to use the allaire applets. I would prefer not using an applet at all. I looked at Corda Pop charts (www.popcharts.com). They have a great product (generates flash graphs) just a little out of my price range. Any ideas? Brook Davies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
The thought had crossed my mind. I wasn't sure about the release date. What are your thoughts on running the Beta in a production environment? Does the beta expire? Brook At 04:12 PM 22/04/01 -0400, you wrote: >Brook, > >CF5, which is just about nearing the end of its beta cycle (due out in June) >has graphing built in. So, if you can wait a few weeks, or if you can access >the beta version, that's probably your best bet. > >--- Ben > > >-Original Message- >From: Brook Davies [mailto:[EMAIL PROTECTED]] >Sent: Sunday, April 22, 2001 4:11 PM >To: CF-Talk >Subject: graphing > > >Does any one know of a good graphing solution for a cf app? I do not want >to use the allaire applets. I would prefer not using an applet at all. I >looked at Corda Pop charts (www.popcharts.com). They have a great product >(generates flash graphs) just a little out of my price range. > >Any ideas? > >Brook Davies > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
There is a package available from the Allaire Tag Gallery called Kava Chart Servlets http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34780E-2830-11D4-AA 9700508B94F380&method=Full) It's not an applet but does require a servlet engine. Your other option is to wait for CF5.0. Kool things happening in the 5.0 version... Jeff Garza Webmaster Spectrum Astro, Inc. [EMAIL PROTECTED] -Original Message- From: Brook Davies To: CF-Talk Sent: 4/22/01 1:10 PM Subject: graphing Does any one know of a good graphing solution for a cf app? I do not want to use the allaire applets. I would prefer not using an applet at all. I looked at Corda Pop charts (www.popcharts.com). They have a great product (generates flash graphs) just a little out of my price range. Any ideas? Brook Davies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
Is the graphing in CF5 applet or flash? btc -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 3:13 PM To: CF-Talk Subject: RE: graphing Brook, CF5, which is just about nearing the end of its beta cycle (due out in June) has graphing built in. So, if you can wait a few weeks, or if you can access the beta version, that's probably your best bet. --- Ben -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 4:11 PM To: CF-Talk Subject: graphing Does any one know of a good graphing solution for a cf app? I do not want to use the allaire applets. I would prefer not using an applet at all. I looked at Corda Pop charts (www.popcharts.com). They have a great product (generates flash graphs) just a little out of my price range. Any ideas? Brook Davies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
enterprise vs pro
Besides the load balancing and clustering support, are there any other significant differences between enterprise and pro besides price? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
The following tables At 03:20 PM 22/04/01 -0500, you wrote: >Is the graphing in CF5 applet or flash? > >btc > >-Original Message- >From: Ben Forta [mailto:[EMAIL PROTECTED]] >Sent: Sunday, April 22, 2001 3:13 PM >To: CF-Talk >Subject: RE: graphing > > >Brook, > >CF5, which is just about nearing the end of its beta cycle (due out in June) >has graphing built in. So, if you can wait a few weeks, or if you can access >the beta version, that's probably your best bet. > >--- Ben > > >-Original Message- >From: Brook Davies [mailto:[EMAIL PROTECTED]] >Sent: Sunday, April 22, 2001 4:11 PM >To: CF-Talk >Subject: graphing > > >Does any one know of a good graphing solution for a cf app? I do not want >to use the allaire applets. I would prefer not using an applet at all. I >looked at Corda Pop charts (www.popcharts.com). They have a great product >(generates flash graphs) just a little out of my price range. > >Any ideas? > >Brook Davies > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
Brook Another one is ChartFX.com We use Popchart Live as well. Both Great tools but a bit pricy. Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: 22 April 2001 21:27 To: CF-Talk Subject: RE: graphing The thought had crossed my mind. I wasn't sure about the release date. What are your thoughts on running the Beta in a production environment? Does the beta expire? Brook At 04:12 PM 22/04/01 -0400, you wrote: >Brook, > >CF5, which is just about nearing the end of its beta cycle (due out in June) >has graphing built in. So, if you can wait a few weeks, or if you can access >the beta version, that's probably your best bet. > >--- Ben > > >-Original Message- >From: Brook Davies [mailto:[EMAIL PROTECTED]] >Sent: Sunday, April 22, 2001 4:11 PM >To: CF-Talk >Subject: graphing > > >Does any one know of a good graphing solution for a cf app? I do not want >to use the allaire applets. I would prefer not using an applet at all. I >looked at Corda Pop charts (www.popcharts.com). They have a great product >(generates flash graphs) just a little out of my price range. > >Any ideas? > >Brook Davies > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: no buffer space available
What are the specifics of your client machine setup? We've been running into similar problems on machines running Windows 2000 Pro machines and Photoshop 6. Complete inability to open new TCP/IP connections, whether FTP, HTTP, lan. We upgraded one machine to Photoshop 6.0.1 and so far it seems like it may have solved the problem. We'll know better after this developers has used the machine for a full day or two. Jim - Original Message - From: "S R" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 5:00 PM Subject: no buffer space available > Hi, > > This is not really a CF question but if anyone can help that would be > awesome!! I've been using CuteFTP to upload files to my server which is a > windows NT server. All of a sudden when I tried to connect to the server I > get an error message that says Error 10055 in function bind 'No buffer Space > Available'. > > This is scary because I can't upload anything now. Does anyone know how to > fix this??? > > SR ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: enterprise vs pro
Native DB drivers. Advanced security. Go here: http://www.allaire.com/handlers/index.cfm?ID=13570&Method=Full&Title=Edition %20Comparison%20Matrix&Cache=False to see a comparison of the products. Rey Bango Team Allaire... - Original Message - From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 4:42 PM Subject: enterprise vs pro > Besides the load balancing and clustering support, are there any other > significant differences between enterprise and pro besides price? > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
uploaded files
I have an application which allows clients to upload various files which can later me accessed via the web. My concern is that if the uploaded file has a .cfm extension, when it is reviewed post upload, it could actually execute malicious code on the server. I guess the same would hole true with a .exe file (except that execute privileges are disabled). I need to allow a wide range of acceptable upload types, so I can't restrict it at the upload stage. What would be the best way to allow some one to access these files post upload while not posing a security threat? How would I enable a download of a .cfm file or a .js or whatever without having it execute on the server as opposed to promoting for a download? Brook Davies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
Ooh, that one sounds like a serious NDA breach. At 01:44 PM 04/22/2001 -0700, you wrote: > type = "Bar" or "HorizontalBar" > query = "query name" > valueColumn = "query column" > itemColumn = "query column" > > showValueLabel = "yes", "no", or "rollover" > valueLabelFont = "Arial", "Courier", or "Times" > valueLabelSize = number of points > valueLocation = "on bar" or "over bar" > scaleFrom = integer maximum value > scaleTo = integer minimum value > > showItemLabels = "yes" or "no" > itemLabelFont = "Arial", "Courier", or "Times" > itemLabelSize = number of points > itemLabelOrientation = "horizontal" or "vertical" > > title = "title text" > titleFont = "Arial", "Courier", or "Times" > > fileFormat = "Flash", "gif" or "jpg" > barSpacing = integer number of pixels > graphHeight = integer number of pixels > graphWidth = integer number of pixels > backgroundColor = "Web color" > borderColor = "Web color" > borderWidth = integer number of pixels > depth = integer number of pixels > colorList = "Web color list" > gridLines = integer number of lines > > > > >The following tables > > >At 03:20 PM 22/04/01 -0500, you wrote: > >Is the graphing in CF5 applet or flash? > > > >btc > > > >-Original Message- > >From: Ben Forta [mailto:[EMAIL PROTECTED]] > >Sent: Sunday, April 22, 2001 3:13 PM > >To: CF-Talk > >Subject: RE: graphing > > > > > >Brook, > > > >CF5, which is just about nearing the end of its beta cycle (due out in June) > >has graphing built in. So, if you can wait a few weeks, or if you can access > >the beta version, that's probably your best bet. > > > >--- Ben > > > > > >-Original Message- > >From: Brook Davies [mailto:[EMAIL PROTECTED]] > >Sent: Sunday, April 22, 2001 4:11 PM > >To: CF-Talk > >Subject: graphing > > > > > >Does any one know of a good graphing solution for a cf app? I do not want > >to use the allaire applets. I would prefer not using an applet at all. I > >looked at Corda Pop charts (www.popcharts.com). They have a great product > >(generates flash graphs) just a little out of my price range. > > > >Any ideas? > > > >Brook Davies > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
> There is a package available from the Allaire Tag Gallery > called Kava Chart > Servlets > http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34780E-2830-11D4-AA 9700508B94F380&method=Full > It's not an applet but does require a servlet engine. And for those not adverse to applets it also comes in an applet version ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploaded files
If you're using IIS then save the file to a folder that does not allow any execution or scripting. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 5:11 PM Subject: uploaded files > I have an application which allows clients to upload various files which > can later me accessed via the web. My concern is that if the uploaded file > has a .cfm extension, when it is reviewed post upload, it could actually > execute malicious code on the server. I guess the same would hole true with > a .exe file (except that execute privileges are disabled). > > I need to allow a wide range of acceptable upload types, so I can't > restrict it at the upload stage. What would be the best way to allow some > one to access these files post upload while not posing a security threat? > > How would I enable a download of a .cfm file or a .js or whatever without > having it execute on the server as opposed to promoting for a download? > > Brook Davies > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploaded files
assuming you are using IIS, create a virtual directory on your web site. Remove all the application mappings for that virtual directory and remove execute permissions, even for scripts. I can't think of a problem with this, but it's Sunday night here and I've just returned from a few drinks down the local so I may not have considered everything. Mark At 10:11 PM 22/04/2001, you wrote: >I have an application which allows clients to upload various files which >can later me accessed via the web. My concern is that if the uploaded file >has a .cfm extension, when it is reviewed post upload, it could actually >execute malicious code on the server. I guess the same would hole true with >a .exe file (except that execute privileges are disabled). > >I need to allow a wide range of acceptable upload types, so I can't >restrict it at the upload stage. What would be the best way to allow some >one to access these files post upload while not posing a security threat? > >How would I enable a download of a .cfm file or a .js or whatever without >having it execute on the server as opposed to promoting for a download? > >Brook Davies > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploaded files
Don't give them direct access to an uploaded file... make them go through a program you write which fetches the file and displays it. HTH Dick At 2:11 PM -0700 4/22/01, Brook Davies wrote: >I have an application which allows clients to upload various files which >can later me accessed via the web. My concern is that if the uploaded file >has a .cfm extension, when it is reviewed post upload, it could actually >execute malicious code on the server. I guess the same would hole true with >a .exe file (except that execute privileges are disabled). > >I need to allow a wide range of acceptable upload types, so I can't >restrict it at the upload stage. What would be the best way to allow some >one to access these files post upload while not posing a security threat? > >How would I enable a download of a .cfm file or a .js or whatever without >having it execute on the server as opposed to promoting for a download? > >Brook Davies > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploaded files
The directory that the files are saved to is dynamically generated. Can I set this attribute with cfdirectory when I create the directory. Or would the sub dir inherent its parents settings? At 05:17 PM 22/04/01 -0400, you wrote: >If you're using IIS then save the file to a folder that does not allow any >execution or scripting. > >HTH, > >Howie Hamlin - inFusion Project Manager >On-Line Data Solutions, Inc. >www.CoolFusion.com >631-737-4668 x101 >inFusion Mail Server (iMS) - the World's most configurable mail server > >- Original Message - >From: "Brook Davies" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Sunday, April 22, 2001 5:11 PM >Subject: uploaded files > > > > I have an application which allows clients to upload various files which > > can later me accessed via the web. My concern is that if the uploaded file > > has a .cfm extension, when it is reviewed post upload, it could actually > > execute malicious code on the server. I guess the same would hole true >with > > a .exe file (except that execute privileges are disabled). > > > > I need to allow a wide range of acceptable upload types, so I can't > > restrict it at the upload stage. What would be the best way to allow some > > one to access these files post upload while not posing a security threat? > > > > How would I enable a download of a .cfm file or a .js or whatever without > > having it execute on the server as opposed to promoting for a download? > > > > Brook Davies > > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploaded files
>Or would >the sub dir inherent its parents settings? providing all the files go into sub-directories of the physical directory set as the root of your virtual directory, yes (oh, assuming none of these sub-dirs are used as the physical root of some other virtual directory) Mark >At 05:17 PM 22/04/01 -0400, you wrote: > >If you're using IIS then save the file to a folder that does not allow any > >execution or scripting. > > > >HTH, > > > >Howie Hamlin - inFusion Project Manager > >On-Line Data Solutions, Inc. > >www.CoolFusion.com > >631-737-4668 x101 > >inFusion Mail Server (iMS) - the World's most configurable mail server > > > >- Original Message - > >From: "Brook Davies" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Sunday, April 22, 2001 5:11 PM > >Subject: uploaded files > > > > > > > I have an application which allows clients to upload various files which > > > can later me accessed via the web. My concern is that if the uploaded > file > > > has a .cfm extension, when it is reviewed post upload, it could actually > > > execute malicious code on the server. I guess the same would hole true > >with > > > a .exe file (except that execute privileges are disabled). > > > > > > I need to allow a wide range of acceptable upload types, so I can't > > > restrict it at the upload stage. What would be the best way to allow some > > > one to access these files post upload while not posing a security threat? > > > > > > How would I enable a download of a .cfm file or a .js or whatever without > > > having it execute on the server as opposed to promoting for a download? > > > > > > Brook Davies > > > > > > > > > > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Image size
There are some command line programs available at fcoder.com which will convert to GIF, JPG, PNG, etc. You can run them with or . You can specify image size, destination name/location, etc. We've been using them with pretty good results. They don't support AI or EPS as source (bummer) but they do support quite a few different source file formats. It would be a pretty easy job to make tags for these. --Bill -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 12:03 PM To: CF-Talk Subject: Re: Image size I use cfx_image which automatically creates a thumbnail (or any other size you want). It uses image.dll. The properties tab say it was made by Cap Gemini and copyright by Jukka Manner. It looks to me like CF_GIFGD is the successor to this. It is in the gallery, by the same author, and does thumbnails and lots of other stuff. I haven't used it. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34726E-2830-11D4-AA 9700508B94F380&method=Full - Original Message - From: "Skip Ogden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 1:07 PM Subject: Image size > The Allaire Developers forum used to have a tag called cfx_imagesize (or > something close to that). It isn't there any more, or I can't locate it. > > Does anyone know of ANY way to automatically create a thumbnail from an > image as it is uploaded (with cffile) > > Thanks... > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: uploaded files
Run all your files through something like this:
// Strip out Bad Tags
// Code adapted from Nathan Dintenfass' and Ben Archibald's CF_SafeText
Custom Tag
Message = TRIM(ThisTag.GeneratedContent);
if (Attributes.AllowHTML) { badtags
"SCRIPT|OBJECT|APPLET|EMBED|FORM|LAYER|ILAYER|FRAME|IFRAME|FRAMESET|PARAM|META|TABLE|TD|TH|TR|HEAD|BODY|FONT";
}
else { badtags
"SCRIPT|OBJECT|APPLET|EMBED|FORM|LAYER|ILAYER|FRAME|IFRAME|FRAMESET|PARAM|META|TABLE|TD|TH|TR|HEAD|BODY|FONT|A|IMG|B|U|I|OL|UL";
}
badevents
"onClick|onDblClick|onKeyDown|onKeyPress|onKeyUp|onMouseDown|onMouseOut|onMouseUp|onMouseOver|onBlur|onChange|onFocus|onSelect|javascript:";
StripperRE = "<[[:space:]]?/?[[:space:]]?(#badtags#|(CF)+)[^>]*>";
Message = REReplaceNoCase(Message, StripperRE, '', 'ALL');
Message = REReplaceNoCase(Message, (badevents), '', 'ALL');
Message = REReplace(Message, '(|)', "'", 'ALL');
> I have an application which allows clients to upload various files which
> can later me accessed via the web. My concern is that if the uploaded file
> has a .cfm extension, when it is reviewed post upload, it could actually
> execute malicious code on the server. I guess the same would hole true with
> a .exe file (except that execute privileges are disabled).
>
> I need to allow a wide range of acceptable upload types, so I can't
> restrict it at the upload stage. What would be the best way to allow some
> one to access these files post upload while not posing a security threat?
>
> How would I enable a download of a .cfm file or a .js or whatever without
> having it execute on the server as opposed to promoting for a download?
>
> Brook Davies
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Business Objects and Cold Fusion
My client has just acquired Business Objects for their WEB based reporting system. Does anyone have any experience with interfacing with this tool from Cold Fusion? I understand it is possible to do so? Business Objects and Cold Fusion are both running on Solaris platforms against Oracle 8i databases. Wally Randall Gaithersburg MD - USA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
I am doing so already :-) -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 4:27 PM To: CF-Talk Subject: RE: graphing The thought had crossed my mind. I wasn't sure about the release date. What are your thoughts on running the Beta in a production environment? Does the beta expire? Brook At 04:12 PM 22/04/01 -0400, you wrote: >Brook, > >CF5, which is just about nearing the end of its beta cycle (due out in June) >has graphing built in. So, if you can wait a few weeks, or if you can access >the beta version, that's probably your best bet. > >--- Ben > > >-Original Message- >From: Brook Davies [mailto:[EMAIL PROTECTED]] >Sent: Sunday, April 22, 2001 4:11 PM >To: CF-Talk >Subject: graphing > > >Does any one know of a good graphing solution for a cf app? I do not want >to use the allaire applets. I would prefer not using an applet at all. I >looked at Corda Pop charts (www.popcharts.com). They have a great product >(generates flash graphs) just a little out of my price range. > >Any ideas? > >Brook Davies > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: graphing
GIF, JPEG, Flash -Original Message- From: Brad Comer [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 4:21 PM To: CF-Talk Subject: RE: graphing Is the graphing in CF5 applet or flash? btc -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 3:13 PM To: CF-Talk Subject: RE: graphing Brook, CF5, which is just about nearing the end of its beta cycle (due out in June) has graphing built in. So, if you can wait a few weeks, or if you can access the beta version, that's probably your best bet. --- Ben -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 4:11 PM To: CF-Talk Subject: graphing Does any one know of a good graphing solution for a cf app? I do not want to use the allaire applets. I would prefer not using an applet at all. I looked at Corda Pop charts (www.popcharts.com). They have a great product (generates flash graphs) just a little out of my price range. Any ideas? Brook Davies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WDDX error
i encountered this error if one of my WDDX field contain an ampersand (&) XML parsing error: not well-formed (error code 4, line 1, column 941, buffer offset 941) The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (21:1) to (21:64). any idea how can i solve this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL SERVER and IIS on the same machine?
I think the most important issue is "Security". If we put IIS and SQL Server on the same machine it could be a dissaster whenever your IIS is being hacked. By separating ISS and SQL Server we make difficult for hacker to exploit what ever we have. Mostly we use local ip address between IIS and SQL server. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX error
> i encountered this error if one of my WDDX field contain an > ampersand (&) > > XML parsing error: not well-formed (error code 4, line 1, > column 941, buffer offset 941) > > The error occurred while processing an element with a general > identifier of (CFWDDX), occupying document position (21:1) to > (21:64). > > any idea how can i solve this? The ampersand is a symbolic character in XML and HTML. You'll need to escape any symbolic characters using the XMLFormat function before using CFWDDX. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WDDX error
i did, but if i use XMLFormat i get this error instead : XML parsing error: not well-formed (error code 4, line 1, column 0, buffer offset 0) The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (21:1) to (21:64). - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 23, 2001 9:06 AM Subject: RE: WDDX error > > i encountered this error if one of my WDDX field contain an > > ampersand (&) > > > > XML parsing error: not well-formed (error code 4, line 1, > > column 941, buffer offset 941) > > > > The error occurred while processing an element with a general > > identifier of (CFWDDX), occupying document position (21:1) to > > (21:64). > > > > any idea how can i solve this? > > The ampersand is a symbolic character in XML and HTML. You'll need to escape > any symbolic characters using the XMLFormat function before using CFWDDX. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX error
> i did, but if i use XMLFormat i get this error instead : > > XML parsing error: not well-formed (error code 4, line 1, > column 0, buffer offset 0) > > The error occurred while processing an element with a general > identifier of (CFWDDX), occupying document position (21:1) to > (21:64). Are you sure you don't have anything other than the WDDX packet in your data stream? No HTML tags or anything? That's the most common cause for this problem, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Repost Cftree and unicode
I have asked this a few days ago but I'm not sure it made it to the list. Is it possible to display unicode in cftree? Based on our tests cftree doesn't properly display unicode (being a Java applet is should) I was wondering if somebody was able to do it. If not, will the Flash components developed by Figleaf display it correctly and if yes when will they be available to the public? Thanks Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WDDX error
here's my WDDX packet data, any problem with it? the error occured on "& MEG. DIATRIAZOTE " 0002729110411IP004400164111JDH PHARMACEUTICAL SDN. BHD.28.3604.01 SOD.& MEG. DIATRIAZOTE 76% INJPCK OF 5 AMPS AMP - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 23, 2001 9:15 AM Subject: RE: WDDX error > > i did, but if i use XMLFormat i get this error instead : > > > > XML parsing error: not well-formed (error code 4, line 1, > > column 0, buffer offset 0) > > > > The error occurred while processing an element with a general > > identifier of (CFWDDX), occupying document position (21:1) to > > (21:64). > > Are you sure you don't have anything other than the WDDX packet in your data > stream? No HTML tags or anything? That's the most common cause for this > problem, I think. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX error
> here's my WDDX packet data, any problem with it? the error > occured on "& MEG. DIATRIAZOTE " Well, the only thing I see wrong is the ampersand, which when escaped should look like this: & Other than that, I don't see anything. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What is WDDX?
I've heard a lot of talk about WDDX but i'am unclear as to what it is, what is it used for? Can anyone explain? Or recomend a site with tutorials and information? Regards, Javier Woodhouse ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL SERVER and IIS on the same machine?
absolutely not. do not put database and webserver on the same box. not good for security or performance. i have both on my laptop for development stuff but that's it. good luck , alex -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 5:40 AM To: CF-Talk Subject: SQL SERVER and IIS on the same machine? Our hosting company told me they don't support SQL SERVER and IIS on the same NT machine. "Even Microsoft doesn't recommened it", they claim. What do you think? Money is always an issue... Thanks, -Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What is WDDX?
Web Distributed Data Exchange - check out http://www.openwddx.org/ DC - Original Message - From: "Javier Woodhouse" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 21:49 Subject: What is WDDX? > I've heard a lot of talk about WDDX but i'am unclear as to what it is, what > is it used for? Can anyone explain? Or recomend a site with tutorials and > information? > > Regards, > Javier Woodhouse > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What is WDDX?
> I've heard a lot of talk about WDDX but i'am unclear as to > what it is, what is it used for? Can anyone explain? Or recomend > a site with tutorials and information? WDDX is an open-source XML DTD originally created by Allaire to describe generic data objects (arrays, structures, recordsets, strings, numbers, dates and so forth). You can take an object in CF and use the CFWDDX tag to create a WDDX packet, which is an XML-compliant document that can be later deserialized back into a native data object in CF or in other languages. That's a pretty buzzword-thick explanation, so here's an example. You might use WDDX to exchange data between servers, by having one server generate WDDX output when a certain URL is requested, and having another server request that URL via CFHTTP, then retrieve and deserialize the data. So, essentially, you could pass the results of a database query between two servers. You can pass nearly anything you like. That's just one thing you can do with WDDX. For more information, visit http://www.openwddx.org/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX error
> if i escaped it change most of the field and it return back > with this error again : > XML parsing error: not well-formed (error code 4, line > 1,column 0, buffer offset 0) > > is there a way where i can change the & only on the WDDX packet? When are you escaping it? Before you serialize it, right? If not, that's your problem. If you want to show some code, that might help. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What is WDDX?
Javier, Go to www.openwddx.org for more information. Rey... - Original Message - From: "Javier Woodhouse" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 9:49 PM Subject: What is WDDX? > I've heard a lot of talk about WDDX but i'am unclear as to what it is, what > is it used for? Can anyone explain? Or recomend a site with tutorials and > information? > > Regards, > Javier Woodhouse > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX error
Dave Isn't handling of these special characters taken care of by the cfml2wddx action of the cfwddx tag? Dick At 9:48 PM -0400 4/22/01, Dave Watts wrote: > > here's my WDDX packet data, any problem with it? the error >> occured on "& MEG. DIATRIAZOTE " > >Well, the only thing I see wrong is the ampersand, which when escaped should >look like this: > >& > >Other than that, I don't see anything. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: syntax for cli execution of a cfm page?
ive been using it since cf3. there is always an exe to be used as a cgi program if there was no api for the webserver of your choice. -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 5:42 AM To: CF-Talk Subject: Re: syntax for cli execution of a cfm page? At 08:32 PM 18/04/2001, you wrote: >Thanks for the info guys. In case anyone was wondering: > >cfml.exe c:\path\template.cfm > >does actually work. ;p cool, anyone know if this is new to cf 4.5? I don't know if I ever actually tried just running cfml.exe with the path as a parameter before, I'm gonna be kicking myself if this functionality has always been available. Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
