RE: How to Find Hidden Characters -- maybe related to whitesp...
Replace(error.diagnostics,chr(13)&chr(10)," ","ALL") This will convert them to a single whitespace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: donderdag 7 februari 2002 17:02 To: CF-Talk Subject: How to Find Hidden Characters -- maybe related to whitesp... Subject: How to Find Hidden Characters -- maybe related to whitespace issue - Greetings all. I'm having one !@#%$#$^$%^& of a time figuring this out. Can anyone out there help? The Task: Taking the information from the error/cferror variables saving them in a log file which can then be displayed in EXCEL, with one column per variable. The Problem: everything works EXCEPT error.diagnostics, which insists on placing itself in two columns. The Analysis: The diagnostics information is preformatted by coldFusion and contains a hidden cr/lf or paragraph marker(s) that I can not seem "read" programmatically so that I can remove it. The Question: How do I do this... remove these hidden characters? Testing so far has shown that I can remove the hidden marker by removing a block of space in which it is contained, but it requires that I have seen where it occurs and for which type of error and an assumption that it will always "look" the same for each error. If I try to remove just "extra spaces" in a loop, the hidden character does not get "caught" and remains. Anyone have any ideas I've been working on this for several days. Any help would be very much appreciated. Thanks, Carol Carol Bluestein TAAD, Senior Programmer NYS Office of Real Property Services 16 Sheridan Avenue Albany, NY 12210 518-486-6335 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [2] Jeremy Allaire interview on DevX
I never though I'd be defending Flash but so be it. From what I have gathered, and what the beta guys are probably learning right now is that Flash is going to be a big part of CF6. James Sleeman wrote: > > It's called consistency, and that is the driving force behind toolkits in the first >place, it is much easier for the user if one programs "checkbox" > looks and works the same as other program's checkboxes. Not to mention that it >vastly increases code reuse and helps to enforce a modular > approach for the engineer. Sanity is not statistical... > Flash isn't designed to be an interface toolkit >, it is designed to deliver animation and whizzy interactive things, Did you even read the article? "Macromedia plans to make Flash a platform for building applications rather than just animations--and to make the Flash player--rather than the browser itself--the primary target for robust Web application development." > let it do what it's best at, leave the interface display to the various > libraries designed to be interface toolkits (and in the case of web sites, to the HTML). Please let Macromedia know this. I'm sure they will stop their heretical ways immediately. jon __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:[2] Jeremy Allaire interview on DevX
Jon Hall <[EMAIL PROTECTED]> wrote on 2/8/2002 6:24:23 PM: > >stas wrote: >> So you want to design your GUI in Flash > >I want to design a GUI with the tool that gives me the most power, with > the least amount of code. It would take considerably longer I believe to implement a competent gui in flash than to hand code in your toolkit of choice in compiled/interpreted language (eg Swing on Java, GTK in C, TK In Tcl, wxWindows in Python). >> re-invent every little widget? >It's called originality. Take an html select box widget for example. It >takes almost no code to create and stlye to create any kind of look >compared to what it takes to create in say CSharp, which I have been >working with lately. I long for style sheets when doing a form >component, just because it's what I'm used too. It's called consistency, and that is the driving force behind toolkits in the first place, it is much easier for the user if one programs "checkbox" looks and works the same as other program's checkboxes. Not to mention that it vastly increases code reuse and helps to enforce a modular approach for the engineer. Flash isn't designed to be an interface toolkit, it is designed to deliver animation and whizzy interactive things, let it do what it's best at, leave the interface display to the various libraries designed to be interface toolkits (and in the case of web sites, to the HTML). --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFScheduler Logging
In the CF5 Administrator, under Automation Settings, I've got 'Enable Logging' unchecked. This is the default setting, but I'd enabled it while making sure some scheduled tasks were executing. That was about a month ago, and I just noticed that the scheduler log had grown to over 50 megabytes. I've got a couple of very small templates that run every minute. Logging them adds up fast. Does this setting not control whether the results of scheduled tasks get logged in the scheduler log? Jim __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jeremy Allaire interview on DevX
Pete Freitag wrote: > yeah, Java does not suck at GUI design! As far as programming interfac es > go, it's the best I've seen, with Pluggable Look and Feel, and robust f orm > control abstractions. Pluggable Look and Feel and form control abstractions are code concepts. They have nothing to do do with how a widget looks. From a code standpoint Swing is very nice to work with, but the the way the code looks still has absolutely nothing to do with the way it looks on screen. I haven't tried every visual Java IDE, but VisualAge and NetBeans both really are no competition to Visual Studio.net or Delphi, which are decent but, comparing them to the Flash GUI they lose. Admittedly Flash has to do much much less of a scope, but Macromedia has always been a GUI focuesed company. If Macrommedia is looking to broaden Flash's scope into application design, I think it would be very exciting, which was what my whole very speculative post was about. > > The first versions of Java may have sucked, but its WAY better now. Don 't be > close minded about Java, I'll try to remember not to be close minded about java, when I start reading the posts to the Netbeans list I am subscribed to in a bit. > it runs more than applets these days (the next > version of ColdFusion for one). I wasn't aware ColdFusion had an GUI. jon > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 10:07 PM > To: CF-Talk > Subject: Re: Jeremy Allaire interview on DevX > > > JAVA sucks in GUI design?? > Interesting. I think the tools available allow for fast, creative GUIs. > > Could just be because I like JAVA and use JAVA as much as CF. > > > >>-Original Message- >>From: Jon Hall [mailto:[EMAIL PROTECTED]] >> >> >>Java just sucks all around in GUI design. >> > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jeremy Allaire interview on DevX
stas wrote: > So you want to design your GUI in Flash I want to design a GUI with the tool that gives me the most power, with the least amount of code. > with "movies" and "clips" and Where did I say that? > re-invent every little widget? It's called originality. Take an html select box widget for example. It takes almost no code to create and stlye to create any kind of look compared to what it takes to create in say CSharp, which I have been working with lately. I long for style sheets when doing a form component, just because it's what I'm used too. jon > > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > > > What I found extremely interesting was this sentence: > "Allaire says that the next-generation Flash player will be able to run > fully connected, intermittently connected, or as a standalone > application platform... " > > Does this mean that Flash will have the ability to run outside of the > browser in the future? It sure seems to me like that's what he said. > That is pretty cool if so, current application GUI design really really > sucks. Visual Studio.net and Delphi both suffer from the little gray > window syndrome and are not cross platform. Java just sucks all around > in GUI design. The ability to design a GUI in Flash would get me on the > Flash ship...maybe. > > Another very interesting thing... > "Finally, Allaire says the next-generation player "integrates rich > media" by displaying them in a single container rather than the multiple > separate applications commonly used today." > > Does rich media mean video? I include video in my definition of rich > media. If so, then either Macromedia is going out with a video player, > or Flash is going have the ability to integrate other media players, > like WMP. H sounds very cool by itself, and what it may imply > depending on how they allow integration. > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jeremy Allaire interview on DevX
Sheesh lots of negative replies, and I don't even like Flash. I was just speculating that it looks like Flash might start getting interesting to the coder. I did't know you could save Flash as an executable. Thanks for the info, but as I speculated in my post, the integration of "rich media" may mean that other applications could be integrated into flash via COM, dotNet, Javabeans or whatever. That gets crazy speculative to the point of it probably not being true, so I didn't say it. You guys need to learn to read between the lines. kpm Tyler Fitch wrote: > Jon, > > Flash already has a stand alone player that comes with the IDE as well as the ability to save any Flash movie you develop as a .exe. I don't th ink this stand alone concept is necessarily new. > > Whether you can have that exe go out and access live data is another is sue. Maybe if you coded a web service and made it available for access w hen the Flash app ran. But if the user wasn't online or your service was down for some reason it'd make for a poor Flash app. > > tyler > > > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Thu 2/7/2002 6:15 PM > To: CF-Talk > Cc: > Subject: Re: Jeremy Allaire interview on DevX > > > > What I found extremely interesting was this sentence: > "Allaire says that the next-generation Flash player will be able to ru n > fully connected, intermittently connected, or as a standalone applicat ion > platform... " > > Does this mean that Flash will have the ability to run outside of the > browser in the future? It sure seems to me like that's what he said. T hat is > pretty cool if so, current application GUI design really really sucks. > Visual Studio.net and Delphi both suffer from the little gray window > syndrome and are not cross platform. Java just sucks all around in GUI > design. The ability to design a GUI in Flash would get me on the Flash > ship...maybe. > > Another very interesting thing... > "Finally, Allaire says the next-generation player "integrates rich med ia" by > displaying them in a single container rather than the multiple separat e > applications commonly used today." > > Does rich media mean video? I include video in my definition of rich m edia. > If so, then either Macromedia is going out with a video player, or Fla sh is > going have the ability to integrate other media players, like WMP. Hmm mm > sounds very cool by itself, and what it may imply depending on how the y > allow integration. > > Is their an approximate release date for Flash 6 yet? > > jon > - Original Message - > From: "John Dowdell" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 07, 2002 4:50 PM > Subject: fyi: Jeremy Allaire interview on DevX > > > > http://www.devx.com/free/hotlinks/2002/ednote020502/ednote020502.asp > > > > Although this is ostensibly about Flash, it really points out how we 're > > trying to make it more efficient to develop with both ColdFusion and > Flash. > > > > jd > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: OBJECT tag for java plugin and IE
Hi all, I have a system where I have a large amoutn (or will have a large amount :-)) of "distributed front ends" to ecommerce sites, they basically consist of images, and a couple of dummy fusebox files that call a set of shared code sitting away on another server. Anyway, I want to add a java applet I have written into an area of the system, but my problem is that I don't want to have to put the JAR files in with the front-end code. So I thought I'd do something like... http://java.sun.com/products/plugin/1.1.2/jinstall-112-win32.cab##Version=1,1,2,0";> that's obviosuly the OBJECT tag for getting the java plugin in IE to run my applet, notice the codebase, I'm telling it to get the jar files from this "directory" (which is really a search-engine-friendly url to a fuseaction that will do a cfcontent to return the requested jar file). Now, while this works fine in mozilla (with an equivalent applet tag instead of the object tag), IE just doesn't like it. Does anybody have any idea why this wouldn't work ? NB: I've tested the applet in IE and it works fine, it's just when I try and reference the jars in this manner that it fails. --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jeremy Allaire interview on DevX
yeah, Java does not suck at GUI design! As far as programming interfaces go, it's the best I've seen, with Pluggable Look and Feel, and robust form control abstractions. The first versions of Java may have sucked, but its WAY better now. Don't be close minded about Java, it runs more than applets these days (the next version of ColdFusion for one). + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:07 PM To: CF-Talk Subject: Re: Jeremy Allaire interview on DevX JAVA sucks in GUI design?? Interesting. I think the tools available allow for fast, creative GUIs. Could just be because I like JAVA and use JAVA as much as CF. > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > > > Java just sucks all around in GUI design. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CSV To DB Custom Tag
Hello, I am using CSV 2 DB Custom Tag from Dev Exchange to import a CSV spreadsheet into database. It works great on inserting and updating, but errors on any column that has a comma in the data ie. the Name column. I thought that the quotes placed around that column by CSV would prevent the tag from an error on the comma, but that is obviously not true. Any Ideas as to why? TIA __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jeremy Allaire interview on DevX
Jon, Flash already has a stand alone player that comes with the IDE as well as the ability to save any Flash movie you develop as a .exe. I don't think this stand alone concept is necessarily new. Whether you can have that exe go out and access live data is another issue. Maybe if you coded a web service and made it available for access when the Flash app ran. But if the user wasn't online or your service was down for some reason it'd make for a poor Flash app. tyler -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thu 2/7/2002 6:15 PM To: CF-Talk Cc: Subject: Re: Jeremy Allaire interview on DevX What I found extremely interesting was this sentence: "Allaire says that the next-generation Flash player will be able to run fully connected, intermittently connected, or as a standalone application platform... " Does this mean that Flash will have the ability to run outside of the browser in the future? It sure seems to me like that's what he said. That is pretty cool if so, current application GUI design really really sucks. Visual Studio.net and Delphi both suffer from the little gray window syndrome and are not cross platform. Java just sucks all around in GUI design. The ability to design a GUI in Flash would get me on the Flash ship...maybe. Another very interesting thing... "Finally, Allaire says the next-generation player "integrates rich media" by displaying them in a single container rather than the multiple separate applications commonly used today." Does rich media mean video? I include video in my definition of rich media. If so, then either Macromedia is going out with a video player, or Flash is going have the ability to integrate other media players, like WMP. H sounds very cool by itself, and what it may imply depending on how they allow integration. Is their an approximate release date for Flash 6 yet? jon - Original Message - From: "John Dowdell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 4:50 PM Subject: fyi: Jeremy Allaire interview on DevX > http://www.devx.com/free/hotlinks/2002/ednote020502/ednote020502.asp > > Although this is ostensibly about Flash, it really points out how we're > trying to make it more efficient to develop with both ColdFusion and Flash. > > jd > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jeremy Allaire interview on DevX
JAVA sucks in GUI design?? Interesting. I think the tools available allow for fast, creative GUIs. Could just be because I like JAVA and use JAVA as much as CF. - Original Message - From: "stas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 10:05 PM Subject: RE: Jeremy Allaire interview on DevX > So you want to design your GUI in Flash with "movies" and "clips" and > re-invent every little widget? > > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > > > What I found extremely interesting was this sentence: > "Allaire says that the next-generation Flash player will be able to run > fully connected, intermittently connected, or as a standalone > application platform... " > > Does this mean that Flash will have the ability to run outside of the > browser in the future? It sure seems to me like that's what he said. > That is pretty cool if so, current application GUI design really really > sucks. Visual Studio.net and Delphi both suffer from the little gray > window syndrome and are not cross platform. Java just sucks all around > in GUI design. The ability to design a GUI in Flash would get me on the > Flash ship...maybe. > > Another very interesting thing... > "Finally, Allaire says the next-generation player "integrates rich > media" by displaying them in a single container rather than the multiple > separate applications commonly used today." > > Does rich media mean video? I include video in my definition of rich > media. If so, then either Macromedia is going out with a video player, > or Flash is going have the ability to integrate other media players, > like WMP. H sounds very cool by itself, and what it may imply > depending on how they allow integration. > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jeremy Allaire interview on DevX
So you want to design your GUI in Flash with "movies" and "clips" and re-invent every little widget? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] What I found extremely interesting was this sentence: "Allaire says that the next-generation Flash player will be able to run fully connected, intermittently connected, or as a standalone application platform... " Does this mean that Flash will have the ability to run outside of the browser in the future? It sure seems to me like that's what he said. That is pretty cool if so, current application GUI design really really sucks. Visual Studio.net and Delphi both suffer from the little gray window syndrome and are not cross platform. Java just sucks all around in GUI design. The ability to design a GUI in Flash would get me on the Flash ship...maybe. Another very interesting thing... "Finally, Allaire says the next-generation player "integrates rich media" by displaying them in a single container rather than the multiple separate applications commonly used today." Does rich media mean video? I include video in my definition of rich media. If so, then either Macromedia is going out with a video player, or Flash is going have the ability to integrate other media players, like WMP. H sounds very cool by itself, and what it may imply depending on how they allow integration. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Jeremy Allaire interview on DevX
What I found extremely interesting was this sentence: "Allaire says that the next-generation Flash player will be able to run fully connected, intermittently connected, or as a standalone application platform... " Does this mean that Flash will have the ability to run outside of the browser in the future? It sure seems to me like that's what he said. That is pretty cool if so, current application GUI design really really sucks. Visual Studio.net and Delphi both suffer from the little gray window syndrome and are not cross platform. Java just sucks all around in GUI design. The ability to design a GUI in Flash would get me on the Flash ship...maybe. Another very interesting thing... "Finally, Allaire says the next-generation player "integrates rich media" by displaying them in a single container rather than the multiple separate applications commonly used today." Does rich media mean video? I include video in my definition of rich media. If so, then either Macromedia is going out with a video player, or Flash is going have the ability to integrate other media players, like WMP. H sounds very cool by itself, and what it may imply depending on how they allow integration. Is their an approximate release date for Flash 6 yet? jon - Original Message - From: "John Dowdell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 4:50 PM Subject: fyi: Jeremy Allaire interview on DevX > http://www.devx.com/free/hotlinks/2002/ednote020502/ednote020502.asp > > Although this is ostensibly about Flash, it really points out how we're > trying to make it more efficient to develop with both ColdFusion and Flash. > > jd > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Remote Datasource
yepsetup the datasource with the username and password for connecting to the db and the rest should work the same as a local datasource Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 4:15 PM Subject: Remote Datasource > I have two stand-alone servers on our network. One running CF 4.5 and IIS > the other has SQL Server 7.0 on it. I have a datasource on the one machine > that I want to connect to the CF machine. Can someone point me in the right > direction? > > Thanks! > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Remote Datasource
I have two stand-alone servers on our network. One running CF 4.5 and IIS the other has SQL Server 7.0 on it. I have a datasource on the one machine that I want to connect to the CF machine. Can someone point me in the right direction? Thanks! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-based DNS Manager software beta
Agreed | I've used SimpleDNS Plus, it's THE easiest DNS software to | use that I've ever tried. (and I've tried quite a few) | | It also has monitoring features for dns requests, and quite a | few DNS related tools, it's very user friendly. | | I'd recommend it. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query question
Howie Hamlin wrote: > Ah, but when you delete records Access uses the deleted space again AFAIK. Don't think so. That is what the Compact & Repair option is for. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query question
Ah, but when you delete records Access uses the deleted space again AFAIK. So, the records that are physically in the DB may not be in the order that you think... Even when you view the database in Access there is some kind of ordering rule in effect...it's just behind the scenes so that when you view the table in Access, Access is probably ordering it by the first column even though the records are not in that order physically. Howie - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 6:40 PM Subject: RE: Query question > It's in that order in the access database that I use - using autonumber. > And you're right, it is best to use order by. However, I was wondering > what would have happened if I needed information in my database in the > order that I view it, but it has no logical ordering column. > > Thanks, > - Matt Small > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query question
It's in that order in the access database that I use - using autonumber. And you're right, it is best to use order by. However, I was wondering what would have happened if I needed information in my database in the order that I view it, but it has no logical ordering column. Thanks, - Matt Small -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 6:29 PM To: CF-Talk Subject: Re: Query question How do you know what the order is in the database? That is usually a hidden thing that you wouldn't see. At any rate, it's best prctice to use ORDER BY. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 5:59 PM Subject: Query question > I have a query that I run: > > > select * from showorder > > > > and > > > select * from showorder_#form.show# order by id > > > Knowing that the "order by id" is in the order that the data exists in > the table, why does the first query mix things up? > > - Matt Small > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query question
How do you know what the order is in the database? That is usually a hidden thing that you wouldn't see. At any rate, it's best prctice to use ORDER BY. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 5:59 PM Subject: Query question > I have a query that I run: > > > select * from showorder > > > > and > > > select * from showorder_#form.show# order by id > > > Knowing that the "order by id" is in the order that the data exists in > the table, why does the first query mix things up? > > - Matt Small > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Importing Uploaded Excel Data into DB
I have a customer who has no database for his plant inventory, so he keeps it in an Excel worksheet (8,000+ rows and growing). I created an odbc data source using the MS Excel ODBC driver and then put the worksheet in the same folder as the Access mdb and created a link to it within Access, made an upload page the the customer uploads his worksheet with and my form overwrites the existing table and then runs a query that either updates or inserts depending on what the query finds. Has been working flawlessly for quite a while. Terry - Original Message - From: Dave Douglas <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 8:35 AM Subject: Importing Uploaded Excel Data into DB > Hello, > > I have searched past messages to the list and have seen some recommendations > for the csvtoquery custom tag > to put the spreadsheet data into a query. What makes my situation unique (I > think) is that the spreadsheet has > commas in the data in some of the columns. I tried CSVformat and am able to > print out the data on row at a time. Where I am stuck now is how to get > this information into the DB and how to get it in the right fields as right > now it is printing all columns for each employee on one line each and it > blows up the query when I try to insert #item# as the Value. Any Help is > GREATLY appreciated! > > here is my code so far: > > file="#File.ServerDirectory#\#File.ServerFile#" > variable="excelList"> > > > > >list="#NewList#" > delimiters="^"> >#item# > > > A working version, with csv and txt files available is at > http://www.high-techsolutions.net/development/UpLoad.cfm > > TIA, > > Dave > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query question
I have a query that I run: select * from showorder and select * from showorder_#form.show# order by id Knowing that the "order by id" is in the order that the data exists in the table, why does the first query mix things up? - Matt Small __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT Jscrpt question
I have a user that keeps getting an error "opener.form.field is not an object". I don't get that on my browser, and we have the exact same rev of browsers??? Does anyone know why the user would get this message. I am using a pop up window to populate a form field on the openers form. Thanks Ray Bujarski 858-845-7669 858-636-9900 pgr [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS question
They're returning 404's. As I understand it, "/" at the beginning of a relative url means root ie When you click on the link, where does it go to? > > Putting a / before the page in the link will send it one level down. > > So if your in servername/page/index.cfm and you click on a link that > goes to /etc.cfm it will send you to servername/etc.cfm > > __ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > -Original Message- > From: Douglas Jordon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 11:06 AM > To: CF-Talk > Subject: IIS question > > Hi, > > I've been given a site to work on that uses a site root reference in all > of it's links(a href="/etc.cfm"). The links don't work on our > development server where there was only a default web site created. So I > created a website with the snap-on with the home directory as root, but > the links still don't work. Any suggestions about what I'm doing > wrong/not doing? > > TIA, > > Doug Jordon > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weight Loss
Yes. It costs over $2,000. But if you need more graphing capability than comes currently with ColdFusion, it could be worth it. Stephen > Does this app cost money. I don't see on the website where you can > buy it, just a free download. It looks nice, and would be cool to > use, but I'll stick with cfgraph for now if it costs anything. > > Robert Everland III > Dixon Ticonderoga > Web Developer Extraordinaire > > -Original Message- > From: Bruce Sorge [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 1:35 PM > To: CF-Talk > Subject: Re: Weight Loss > > > Although CFGRAPH is pretty cool and a welcome addition to > ColdFusion, there > are still quite a few limitations to that tag. This is one of them. > > What you are wanting to do is to have two valuecolumns on the same > chart, a nd this is something that CFGRAPH does not do. What you can > do is to create > two graphs, one showing weight loss and the other weight goal. You > would h > ave all the people in the database lumped into one chart for each > category. > The code example below gives you two charts, one on top of the > other. If y > ou want to do some really cool things with charts and graphs, for > now you w ill need to get a third party charting application. The > one we use here at Baylor is PopChart by Corda Technologies > (www.corda.com). It is really good > It is a JAVA application that runs on the web server (or any server > for t > hat matter, you just have to point to it in your code). It works > well with CFM, ASP, JSP and HTML. It also comes with a cool builder > tool that is als o a JAVA application. You feed in the necessary > parameters and it creates t he necessary JavaScript for you. > > Code example: > > > > Select * > > WeightLoss > order By F_Name > > > > valuecolumn="Weight > _Lost" itemcolumn="F_Name" showvaluelabel="Yes" > valuelabelfont="Arial " valuelocation="ONBAR" scaleto="300" > itemlabelfont="Arial" itemlabel orientation="HORIZONTAL" > title="Weight Loss Progress Chart" titlefont ="Arial" > fileformat="Flash" depth="5" colorlist="red,green,blue,yel > low,orange"> > > > >valuecolumn="Weight_ > Goal" itemcolumn="F_Name" showvaluelabel="Yes" > valuelabelfont="Arial" > valuelocation="ONBAR" scaleto="300" itemlabelfont="Arial" > itemlabelo > rientation="HORIZONTAL" title="Weight Goal Progress Chart" titlefont > ="Arial" fileformat="Flash" depth="5" colorlist="red,green,blue, yel > low,orange"> > > > Another thing that you can do is to output the information into a > table abo ve the charts, and you can also make it a drill down > chart, then you could pass in the User_ID parameter in the URL and > create another chart for just the individual or a table with the > necessary information. > > > --- Original Message -- > From: "Ann Harrell" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Thu, 7 Feb 2002 11:24:52 -0500 > > I'm in the thinking stage of a small project for a group of friends. > I want > > to keep it fairly simple. It would be in Access > > Person1 > WeightLost (bar graph) > WeightGoal > > Person2 > WeightLost > WeightGoal > > and I would like to display this in cfgraph. Is this possible? > > Ann Harrell, USA > Phone: 219.342.0618 > > A society that will trade a little liberty for a little order will > lose both, and deserve neither. --- Thomas Jefferson, in a letter to > Madison > > > > __ Dedicated Windows 2000 Server > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > Instant Activation · $99/Month · Free Setup > http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
fyi: Jeremy Allaire interview on DevX
http://www.devx.com/free/hotlinks/2002/ednote020502/ednote020502.asp Although this is ostensibly about Flash, it really points out how we're trying to make it more efficient to develop with both ColdFusion and Flash. jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-based DNS Manager software beta
I've used SimpleDNS Plus, it's THE easiest DNS software to use that I've ever tried. (and I've tried quite a few) It also has monitoring features for dns requests, and quite a few DNS related tools, it's very user friendly. I'd recommend it. http://www.jhsoft.com/screen.htm __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 4:39 PM To: CF-Talk Subject: Re: CF-based DNS Manager software beta I'll take a look at it. Thanks Lee. - Original Message - From: "Lee Fuller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 2:41 PM Subject: RE: CF-based DNS Manager software beta > Bill, > > Do take a look at SimpleDNS. They're up and coming, and quite what > their name implies. They are follow all RFC's that we could find, and > also use standard text files for entries/zones. > > Just my .02 ... > > > Lee Fuller > Chief Technical Officer > PrimeDNA / AAA Web Hosting Corporations > > > > > | -Original Message- > | From: Bill Davidson [mailto:[EMAIL PROTECTED]] > | Sent: Thursday, February 07, 2002 11:36 AM > | To: CF-Talk > | Subject: Re: CF-based DNS Manager software beta > | > | > | Hi James.. I am ONLY writing management software. In the > | first release I intend to support at LEAST MS's DNS Server. > | I'll add others as needed. I would be surprised if we offer > | Bind support also in at least some version of 1.x. > | > | Thanks for your interest. > | -Bill > | brainbox > | > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Error
Just some places to look, -Are the threads to the database set up to be kept alive in the CF Admin? -Is TNS configured to disconnect inactive DB threads? -There may be problems with the DNS server. -Also, if 8i works like an Application Server, you may need to check the port range for which it communicates to make sure it has an adequate range to speak through. Greg McDaniel -Original Message- > From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 10:58 AM > To: CF-Talk > Subject: Oracle Error > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-based DNS Manager software beta
I'll take a look at it. Thanks Lee. - Original Message - From: "Lee Fuller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 2:41 PM Subject: RE: CF-based DNS Manager software beta > Bill, > > Do take a look at SimpleDNS. They're up and coming, and quite what > their name implies. They are follow all RFC's that we could find, and > also use standard text files for entries/zones. > > Just my .02 ... > > > Lee Fuller > Chief Technical Officer > PrimeDNA / AAA Web Hosting Corporations > > > > > | -Original Message- > | From: Bill Davidson [mailto:[EMAIL PROTECTED]] > | Sent: Thursday, February 07, 2002 11:36 AM > | To: CF-Talk > | Subject: Re: CF-based DNS Manager software beta > | > | > | Hi James.. I am ONLY writing management software. In the > | first release I intend to support at LEAST MS's DNS Server. > | I'll add others as needed. I would be surprised if we offer > | Bind support also in at least some version of 1.x. > | > | Thanks for your interest. > | -Bill > | brainbox > | > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection - whats wrong with this
After the login button is pressed. Does it give you that error as soon as you go to the page, or after you hit the login button? __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -- Original Message -- From: "Office" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 8 Feb 2002 10:28:23 +1300 Hi Steve yep trying to avoid using cookies. I want to pass people around the private part of the site with security set from an entry in tblUser. Mike - Doh, nevermind, your not using cookies to set the login. *takes another look __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 4:06 PM To: CF-Talk Subject: RE: Password Protection - whats wrong with this Yeah, your using cflocation, which will not set cookies. Try using Or you could use a meta tag, or a javascript redirection. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com Oops! I've taken out the HTML so it won't appear as a web page Mike Hi I can't get this to work.It looks for data from SQL7 table called tblUse r I've been fiddling with it but obviously missing something. Can anyone spot the error - SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. --- - Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due t o the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection - whats wrong with this
I just copy and pasted your source into a template, and changed the SQL to query my dbase, and it works fine. Double check your SQL query. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 3:59 PM To: CF-Talk Subject: Password Protection - whats wrong with this Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error - Login SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection - whats wrong with this
Hi Steve yep trying to avoid using cookies. I want to pass people around the private part of the site with security set from an entry in tblUser. Mike - Doh, nevermind, your not using cookies to set the login. *takes another look __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 4:06 PM To: CF-Talk Subject: RE: Password Protection - whats wrong with this Yeah, your using cflocation, which will not set cookies. Try using Or you could use a meta tag, or a javascript redirection. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com Oops! I've taken out the HTML so it won't appear as a web page Mike Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error - SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection - whats wrong with this
Does it give you that error as soon as you go to the page, or after you hit the login button? __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 3:59 PM To: CF-Talk Subject: Password Protection - whats wrong with this Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error - Login SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFStoredProc cfsqltype="cf_sql_Date" doesn't work with SmallDateTime SQL Type...Why?
Try using CF_SQL_TIMESTAMP. -Original Message- From: Gary Ashbaugh [mailto:[EMAIL PROTECTED]] Sent: February 7, 2002 12:38 PM To: CF-Talk Subject: CFStoredProc cfsqltype="cf_sql_Date" doesn't work with SmallDateTime SQL Type...Why? When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a SmallDateTime SQL field, I get an error...why? ERROR MESSAGE RECEIVED: ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax er ror, COLDFUSION CODE: SQL STORED PROCEDURE: CREATE PROCEDURE [Add_FYSetup] (@FY nvarchar(4)=NULL, @Due_Date smalldatetime=NULL, @Contact_Person nvarchar(50)=NULL, @Contact_Phone nvarchar(14)=NULL, @RetVal int = NULL Output, @RetMsg nvarchar(100) = NULL Output) AS... Here is the database structure: FY nvarchar(4) Due_Date smalldatetime Contact_Person nvarchar(50) Contact_Phone nvarchar(14) Gary _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection - whats wrong with this
Doh, nevermind, your not using cookies to set the login. *takes another look __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 4:06 PM To: CF-Talk Subject: RE: Password Protection - whats wrong with this Yeah, your using cflocation, which will not set cookies. Try using Or you could use a meta tag, or a javascript redirection. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 3:59 PM To: CF-Talk Subject: Password Protection - whats wrong with this Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error - Login SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Password Protection - whats wrong with this
Oops! I've taken out the HTML so it won't appear as a web page Mike Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error - SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Password Protection - whats wrong with this
Yeah, your using cflocation, which will not set cookies. Try using Or you could use a meta tag, or a javascript redirection. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 3:59 PM To: CF-Talk Subject: Password Protection - whats wrong with this Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error - Login SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: porting cf
When you setup your ODBC connection, it allows you to change the ANSI settings, try changing those around. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:20 AM To: CF-Talk Subject: porting cf We're trying to port from NT4, CF4.0 to Sun Solaris 2.8 running CF 4.5. Case has been checked, the datasource is verified. The query referred to in the error is: (about as basic as it can be) select * from dsel The error message is: Error Diagnostic Information ODBC Error Code = S1000 (General error) [MERANT][ODBC SQL Server Driver]Unicode conversion failed The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (13:1) to (13:53). Date/Time: Wed Feb 06 11:00:42 2002 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461) Can this be done or is the Unicode simply easier to deal with by rewriting on the Solaris? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Password Protection - whats wrong with this
Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error - Login SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' Welcome to NZERN Members Website #errMsg# UserName Password Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes --- thanks in advance for any help (I'm a newbee) Mike NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Coldfusion & UNIX Problem ???
Unix errors 146 and 2 mean a server crashed or froze - in my experience it' s usually the CFserver, but it can be the web server. Chris Norloff -- Original Message -- from: "Ian Vaughan" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Thu, 7 Feb 2002 11:36:40 - >Hi Folks, > >Just recently I have been receiving the following error message and the >Coldfusion server needs to be restarted to get rid of the error, have >anybody on the list come across this error ??? I am using CF 4.0 > >Error Occurred While Processing Request > Error Diagnostic Information > An error occurred while attempting to establish a connection to the >server. > > The most likely cause of this problem is that the server is not >currently running. Verify that the server is running and restart it if >necessary. > > Unix error number 146 occurred: Connection refused > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS question
When you click on the link, where does it go to? Putting a / before the page in the link will send it one level down. So if your in servername/page/index.cfm and you click on a link that goes to /etc.cfm it will send you to servername/etc.cfm __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:06 AM To: CF-Talk Subject: IIS question Hi, I've been given a site to work on that uses a site root reference in all of it's links(a href="/etc.cfm"). The links don't work on our development server where there was only a default web site created. So I created a website with the snap-on with the home directory as root, but the links still don't work. Any suggestions about what I'm doing wrong/not doing? TIA, Doug Jordon __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFContent Download Mime
I use the inline value, and it works fine for me, pops up a dialog to open or save. If you don't use the cfheader, then the excel file will open in your browser, but I still believe it will show the dialog box. One problem I've run into, is if you reload the page that your trying to display a new mime type on, it won't load right, just close your browser, then open it back up, and type the URL in again. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:44 AM To: CF-Talk Subject: CFContent Download Mime I've worked all morning on this, and can't figure this out. This is my first time working with CFContent. When I load this page, the excel document loads in the browser (as text). I would like to start a download, or just go ahead and load in IE as an Excel document like a "http://tflweb/managersinvites3.xls"; call. What am I missing? Start Of Template End Of Template Start Display in Browser >> ÐÏࡱ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weight Loss
Does this app cost money. I don't see on the website where you can buy it, just a free download. It looks nice, and would be cool to use, but I'll stick with cfgraph for now if it costs anything. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 1:35 PM To: CF-Talk Subject: Re: Weight Loss Although CFGRAPH is pretty cool and a welcome addition to ColdFusion, there are still quite a few limitations to that tag. This is one of them. What you are wanting to do is to have two valuecolumns on the same chart, a nd this is something that CFGRAPH does not do. What you can do is to create two graphs, one showing weight loss and the other weight goal. You would h ave all the people in the database lumped into one chart for each category. The code example below gives you two charts, one on top of the other. If y ou want to do some really cool things with charts and graphs, for now you w ill need to get a third party charting application. The one we use here at Baylor is PopChart by Corda Technologies (www.corda.com). It is really good It is a JAVA application that runs on the web server (or any server for t hat matter, you just have to point to it in your code). It works well with CFM, ASP, JSP and HTML. It also comes with a cool builder tool that is als o a JAVA application. You feed in the necessary parameters and it creates t he necessary JavaScript for you. Code example: Select * > WeightLoss order By F_Name Another thing that you can do is to output the information into a table abo ve the charts, and you can also make it a drill down chart, then you could pass in the User_ID parameter in the URL and create another chart for just the individual or a table with the necessary information. --- Original Message -- From: "Ann Harrell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 7 Feb 2002 11:24:52 -0500 I'm in the thinking stage of a small project for a group of friends. I want to keep it fairly simple. It would be in Access Person1 WeightLost (bar graph) WeightGoal Person2 WeightLost WeightGoal and I would like to display this in cfgraph. Is this possible? Ann Harrell, USA Phone: 219.342.0618 A society that will trade a little liberty for a little order will lose both, and deserve neither. --- Thomas Jefferson, in a letter to Madison __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Looping...
Below is a list of files which is generated from a database by selecting in input box from my index.cfm. #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# The results are then passed to another template with the below code: #REReplace(FORM.select,",","","ALL")# Below are the results. My question is how can I use this listing to grab fields from my database that has the corresponding .pfb files and display them based on matching the font name (Ex. "century"). I'm not sure how to go about this. Do I have to loop through the list? [19] borderpi-15159 [22] bundesbahn-pi [25] carta [30] century [197] custom [196] euro [58] european-pi [69] garamond [82] helvetica [106] linotype-decoration-pi [109] lucida-math-extension [114] mathematical-pi [127] old-style-seven [178] symbol [180] times [181] times-serials [192] wood-ornaments [194] zapf-chancery-dingbats __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Encrypting
Doug - the "/2" switch is not a valid switch. If you are trying to do the mandatory version switch its [ /v "2" ] -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 12:10 PM To: CF-Talk Subject: Re: Encrypting I keep getting an invalid switch error. I am doing this C:\CFUSION\BIN>cfencode /r /2 c:\testfiles There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 11:22 AM Subject: RE: Encrypting > Use cfencode with the /r flag, which means recursive, which will encrypt > all files in a folder, including subdirectories. > > __ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > > -Original Message- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 2:28 PM > To: CF-Talk > Subject: Encrypting > > > What is the best way to encrypt a entire application? > > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > BSD. We don't believe this to be a coincidence. > > > > Doug Brown > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio Error: The Connection With The Server Was Reset
Hi Everyone, I continue to have this problem with ColdFusion Studio 5 not being able to save to a particular server with RDS. When I try to save, I IMMEDIATELY get an error message "The Connection With The Server Was Reset". Here are a few peculiar things about it: 1) I can open files and view databases on this server with no trouble. 2) I have tried deleting and recreating the server with a new name, same thing still happens. 3) A collegue of mine isn't having the same problem with the same server. 4) The message comes up immediately and doesn't seem to depend on what my RDS timeout settings are. 5) I've restarted my computer and the server. Any ideas would be appreciated. Thanks. __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Encrypting
I keep getting an invalid switch error. I am doing this C:\CFUSION\BIN>cfencode /r /2 c:\testfiles There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 11:22 AM Subject: RE: Encrypting > Use cfencode with the /r flag, which means recursive, which will encrypt > all files in a folder, including subdirectories. > > __ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > > -Original Message- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 2:28 PM > To: CF-Talk > Subject: Encrypting > > > What is the best way to encrypt a entire application? > > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > BSD. We don't believe this to be a coincidence. > > > > Doug Brown > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFStoredProc cfsqltype="cf_sql_Date" doesn't work with SmallD ateTime SQL Type...Why?
Since you are using ODBC, try doing a CreateODBCDateTime(NewDueDate) and use that as your date parameter. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Gary Ashbaugh [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 12:38 PM To: CF-Talk Subject: CFStoredProc cfsqltype="cf_sql_Date" doesn't work with SmallDateTime SQL Type...Why? When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a SmallDateTime SQL field, I get an error...why? ERROR MESSAGE RECEIVED: ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error, COLDFUSION CODE: SQL STORED PROCEDURE: CREATE PROCEDURE [Add_FYSetup] (@FY nvarchar(4)=NULL, @Due_Date smalldatetime=NULL, @Contact_Person nvarchar(50)=NULL, @Contact_Phone nvarchar(14)=NULL, @RetVal int = NULL Output, @RetMsg nvarchar(100) = NULL Output) AS... Here is the database structure: FY nvarchar(4) Due_Date smalldatetime Contact_Person nvarchar(50) Contact_Phone nvarchar(14) Gary __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-based DNS Manager software beta
Bill, Do take a look at SimpleDNS. They're up and coming, and quite what their name implies. They are follow all RFC's that we could find, and also use standard text files for entries/zones. Just my .02 ... Lee Fuller Chief Technical Officer PrimeDNA / AAA Web Hosting Corporations | -Original Message- | From: Bill Davidson [mailto:[EMAIL PROTECTED]] | Sent: Thursday, February 07, 2002 11:36 AM | To: CF-Talk | Subject: Re: CF-based DNS Manager software beta | | | Hi James.. I am ONLY writing management software. In the | first release I intend to support at LEAST MS's DNS Server. | I'll add others as needed. I would be surprised if we offer | Bind support also in at least some version of 1.x. | | Thanks for your interest. | -Bill | brainbox | __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-based DNS Manager software beta
Odd.. Can you please try again and let me know if you can't get there? Thanks. -Bill brainbox - Original Message - From: "Rick Eidson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:44 AM Subject: RE: CF-based DNS Manager software beta > Can't get to the site. I have been talking with some others about > building a > webbased DNS control panel to handle hosting and Colo clients. I would > like > to see this. > > Rick > > -Original Message- > From: Christopher Olive [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 8:37 AM > To: CF-Talk > Subject: RE: CF-based DNS Manager software beta > > > does this work against 2000 or BIND servers? > > christopher olive, cto, vp of web development > atnet solutions, inc. > 410.931.4092 > http://www.atnetsolutions.com > > > -Original Message- > From: Bill Davidson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 11:39 PM > To: CF-Talk > Subject: CF-based DNS Manager software beta > > > Hello. I mentioned a few days ago that we've been developing CF-based > DNS > management. I am looking for a small group of beta program > participants. > If you are interested, read on, otherwise please disregard this > message. > > If you are interested: > > Please fill out the following form: > http://www.brainbox.net/idnsm_beta/ > > (excuse the form, its not pretty...;) ) > > Beta testers will be entitled to free 1.x software, and opt-in for > future > releases, and the likelihood of your feature requests being implemented > will > be much greater. > > Thanks ya'll. > > -Bill > brainbox > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFStoredProc cfsqltype="cf_sql_Date" doesn't work with SmallDateTime SQL Type...Why?
When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a SmallDateTime SQL field, I get an error...why? ERROR MESSAGE RECEIVED: ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error, COLDFUSION CODE: SQL STORED PROCEDURE: CREATE PROCEDURE [Add_FYSetup] (@FY nvarchar(4)=NULL, @Due_Date smalldatetime=NULL, @Contact_Person nvarchar(50)=NULL, @Contact_Phone nvarchar(14)=NULL, @RetVal int = NULL Output, @RetMsg nvarchar(100) = NULL Output) AS... Here is the database structure: FY nvarchar(4) Due_Date smalldatetime Contact_Person nvarchar(50) Contact_Phone nvarchar(14) Gary __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-based DNS Manager software beta
Hi James.. I am ONLY writing management software. In the first release I intend to support at LEAST MS's DNS Server. I'll add others as needed. I would be surprised if we offer Bind support also in at least some version of 1.x. Thanks for your interest. -Bill brainbox - Original Message - From: "James Curran" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 10:39 AM Subject: RE: CF-based DNS Manager software beta > Are you building your own DNS server too or are you just building the CF to > integrate with Windows 2k's built in DNS? > > - j > > -Original Message- > From: Bill Davidson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 11:39 PM > To: CF-Talk > Subject: CF-based DNS Manager software beta > > > Hello. I mentioned a few days ago that we've been developing CF-based DNS > management. I am looking for a small group of beta program participants. > If you are interested, read on, otherwise please disregard this message. > > If you are interested: > > Please fill out the following form: > http://www.brainbox.net/idnsm_beta/ > > (excuse the form, its not pretty...;) ) > > Beta testers will be entitled to free 1.x software, and opt-in for future > releases, and the likelihood of your feature requests being implemented will > be much greater. > > Thanks ya'll. > > -Bill > brainbox > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Encrypting
Use cfencode with the /r flag, which means recursive, which will encrypt all files in a folder, including subdirectories. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:28 PM To: CF-Talk Subject: Encrypting What is the best way to encrypt a entire application? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Encrypting
What is the best way to encrypt a entire application? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Client Variables
Hi I am using a DB for Clientvars. In cold fusion first I am setting Then after redirecting to certain pages I set But problem is that for same CFID in CGLOBAL table, coldfusion is overriding previous data which is for UserID. So when I am using Client.UserID afterwards it is getting Defaultone which i've set in root circuit (Using CFParam) not the one I set it as it is being overridden. I am using FB3. Can someone suggest me what exactly is going wrong with it. Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7763 114 328 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Client Variables
Hi I am using a DB for Clientvars. In cold fusion first I am setting Then after redirecting to certain pages I set But problem is that for same CFID in CGLOBAL table, coldfusion is overriding previous data which is for UserID. So when I am using Client.UserID afterwards it is getting Defaultone which i've set in root circuit (Using CFParam) not the one I set it as it is being overridden. I am using FB3. Can someone suggest me what exactly is going wrong with it. Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7763 114 328 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (ot) Talking JavaScript
Try this one.. pretty good. > You may unsubscribe anytime by sending a blank email to > [EMAIL PROTECTED] The message archives > are at http://groups.yahoo.com/group/JS-Jive/messages > I thought there was a list for CF programmers to get JavaScript help??? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (ot) Talking JavaScript
JS-Jive is listed on the House of Fusion site, but I believe it is a Yahoo list, not a HouseOfFusion one. I'm not actually on it, but I'm aware of it's existence. http://groups.yahoo.com/group/JS-Jive ( In my resolution, 1024 x 768 you do have to scroll to see the list on the house of fusion site with only the mailing lists menu item open ) It looks a bit misleading because the line underneath NYCFUG is almost flush with the scroll bar on the bottom. At 10:27 AM 02/07/2002 -0800, you wrote: >I thought there was a list for CF programmers to get JavaScript help??? > >I was just looking on the HoF site and didn't see mention of it, so either >it isn't a HoF list or such list doesn't exist. > >If there is a list, can sombody send me the subscribe info please -- >[EMAIL PROTECTED] > >H. > > > >Howard Owens >Internet Operations Coordinator >www.insidevc.com >[EMAIL PROTECTED] >AIM: GoCatGo1956 > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC
I agree. It simply can't be beat when it comes to speed and usability! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 12:37 PM To: CF-Talk Subject: RE: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC John, CF Studio is like going from a hand saw to a chain saw. It's the best tool for hand coding I've ever used. Mark -Original Message- From: John B. White [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:19 AM To: CF-Talk Subject: Re: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC Okay...slightly off topic, but this sounds like I should seriously consider purchasing CF Studio? Right now I hand code everything (since I'm trying to learn). What advantages are there to using Studio? Currently I use: 1st Page 2000 by EvrSoft - Which has some CF tags and the ability to add more...and is free! Arachnophilia - Also free and a nice little interface for Tidy HTML Netscape Composer - Yes it writes crappy code but for initial page layout, its quick and simple. And its free! This is not a production environment. I'm teaching myself CF so I can give my informatics students a taste of dynamic page generation and the use of a web app for patient information etc. Suggestions on making this easier are welcome, probably off list ([EMAIL PROTECTED]). BTW, I've learned alot from watching this list and viewing the of posts. :) --JW "Earl, George" wrote: > > Mark, > > You are right that HomeSite is a scaled down version of CF Studio, although > I like to think of it as CF Studio is a pumped up version of HomeSite . . __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(ot) Talking JavaScript
I thought there was a list for CF programmers to get JavaScript help??? I was just looking on the HoF site and didn't see mention of it, so either it isn't a HoF list or such list doesn't exist. If there is a list, can sombody send me the subscribe info please -- [EMAIL PROTECTED] H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Unwanted extraneous text being inserted by Studio 5?
Howdy, folks -- A colleague of mine recently upgraded her CF Studio from 4.52 to 5 and since then has noticed a couple of odd problems: (1) On some File, Save operations, Studio 5 appears to have added in an extraneous greater-than sign, changing a " " sequence into a " >" sequence. (2) And on some other File, Save operations, Studio 5 appears to have replaced a substantial chunk of the tail end of the file with an odd string, "tion/cfoutput23:09:13:13pm 02/06/20029:read only". There's really nowhere on her system that she could have accidentally picked up this string via a copy-and-paste sort of operation. If it makes a difference, she uses the Allaire FTP Service to move files back and forth between the server and Studio. I looked in the Studio section of the Forums, and though some folks have made non-specific references to Studio 5 as being buggy, I haven't seen this particular problem described. Has anyone else encountered something like this yet with Studio 5? -- Larry Afrin Med. Univ. of S.C. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC
John, CF Studio is like going from a hand saw to a chain saw. It's the best tool for hand coding I've ever used. Mark -Original Message- From: John B. White [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:19 AM To: CF-Talk Subject: Re: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC Okay...slightly off topic, but this sounds like I should seriously consider purchasing CF Studio? Right now I hand code everything (since I'm trying to learn). What advantages are there to using Studio? Currently I use: 1st Page 2000 by EvrSoft - Which has some CF tags and the ability to add more...and is free! Arachnophilia - Also free and a nice little interface for Tidy HTML Netscape Composer - Yes it writes crappy code but for initial page layout, its quick and simple. And its free! This is not a production environment. I'm teaching myself CF so I can give my informatics students a taste of dynamic page generation and the use of a web app for patient information etc. Suggestions on making this easier are welcome, probably off list ([EMAIL PROTECTED]). BTW, I've learned alot from watching this list and viewing the of posts. :) --JW "Earl, George" wrote: > > Mark, > > You are right that HomeSite is a scaled down version of CF Studio, although > I like to think of it as CF Studio is a pumped up version of HomeSite . . . __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: capture email address
the ONLY way to capture an email address is by having the use type it in... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:08 AM To: CF-Talk Subject: capture email address Hello, Is there a way to capture a user's email adress after tey submit a form? Is there a CGI or other variable that can do this and then it can be inserted into a variable field on the form? I.E. #cgi.REMOTE_ADDR#, #cgi.HTTP_USER_AGENT#, #cgi.REMOTE_USER# Our email server requires a valid email address to be in the FROM field in a cfmail tag. Thanks. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weight Loss
Although CFGRAPH is pretty cool and a welcome addition to ColdFusion, there are still quite a few limitations to that tag. This is one of them. What you are wanting to do is to have two valuecolumns on the same chart, a nd this is something that CFGRAPH does not do. What you can do is to create two graphs, one showing weight loss and the other weight goal. You would h ave all the people in the database lumped into one chart for each category. The code example below gives you two charts, one on top of the other. If y ou want to do some really cool things with charts and graphs, for now you w ill need to get a third party charting application. The one we use here at Baylor is PopChart by Corda Technologies (www.corda.com). It is really good It is a JAVA application that runs on the web server (or any server for t hat matter, you just have to point to it in your code). It works well with CFM, ASP, JSP and HTML. It also comes with a cool builder tool that is als o a JAVA application. You feed in the necessary parameters and it creates t he necessary JavaScript for you. Code example: Select * > WeightLoss order By F_Name Another thing that you can do is to output the information into a table abo ve the charts, and you can also make it a drill down chart, then you could pass in the User_ID parameter in the URL and create another chart for just the individual or a table with the necessary information. --- Original Message -- From: "Ann Harrell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 7 Feb 2002 11:24:52 -0500 I'm in the thinking stage of a small project for a group of friends. I want to keep it fairly simple. It would be in Access Person1 WeightLost (bar graph) WeightGoal Person2 WeightLost WeightGoal and I would like to display this in cfgraph. Is this possible? Ann Harrell, USA Phone: 219.342.0618 A society that will trade a little liberty for a little order will lose both, and deserve neither. --- Thomas Jefferson, in a letter to Madison __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC
Okay...slightly off topic, but this sounds like I should seriously consider purchasing CF Studio? Right now I hand code everything (since I'm trying to learn). What advantages are there to using Studio? Currently I use: 1st Page 2000 by EvrSoft - Which has some CF tags and the ability to add more...and is free! Arachnophilia - Also free and a nice little interface for Tidy HTML Netscape Composer - Yes it writes crappy code but for initial page layout, its quick and simple. And its free! This is not a production environment. I'm teaching myself CF so I can give my informatics students a taste of dynamic page generation and the use of a web app for patient information etc. Suggestions on making this easier are welcome, probably off list ([EMAIL PROTECTED]). BTW, I've learned alot from watching this list and viewing the of posts. :) --JW "Earl, George" wrote: > > Mark, > > You are right that HomeSite is a scaled down version of CF Studio, although > I like to think of it as CF Studio is a pumped up version of HomeSite . . . __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Error
See if you can get the networking people to configure the firewall to log all traffic, both allowed and disallowed, from the CF server to the Oracle db, for a period of time that includes success and CF errors; that is likely to show something interesting. Without specific configuration, the Oracle client on the CF server may try to use different ports on the server side, which could confuse the firewall or be rejected. > -Original Message- > From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 10:58 AM > To: CF-Talk > Subject: Oracle Error > > > Hi everyone, > I keep getting these weird errors with Oracle 8i that of > course are being > blamed on ColdFusion. Here goes. > Our webserver sits in the DMZ and our database server is inside the > firewall. All traffic going from the webserver goes through > the firewall to > talk to the database. > I seem to be able to access the database through coldfusion > 90% of the time, > but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to > connect to destination error, both of which result in massive > errors in the > application and the eventual rebooting of the machine. > I am thinking it may be a network issue, but because > coldfusion is new to > this company they want to blame it. If I log in with sql+ (an > oracle client) > I can access the datasource w/o trouble, although cf can't > even verify the > datasource. This usually happens after several moderate hits to the > datasource. > We are running CF 4.5.2 with all the appropriate patches > applied on a Compaq > Windows 2000 machine with all the appropriate service packs applied to > Win2K. Our database is Oracle 8i - anyone have some suggestions? > Greatly appreciated! > Debbie M. > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
capture email address
Hello, Is there a way to capture a user's email adress after tey submit a form? Is there a CGI or other variable that can do this and then it can be inserted into a variable field on the form? I.E. #cgi.REMOTE_ADDR#, #cgi.HTTP_USER_AGENT#, #cgi.REMOTE_USER# Our email server requires a valid email address to be in the FROM field in a cfmail tag. Thanks. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: COncurrent Users
Sorry misread the question...thought you were trying to figure out the
setting for simultaneous request in the CF Admin.
-Original Message-
From: Keen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:26 AM
To: CF-Talk
Subject: RE: COncurrent Users
The best way to do this is with a load test tool. Create a script that
walks through your site and then run the test with different settings for
the number of concurrent users. Compare the results to determine the best
setting for that application. That is also a good time to enable debugging
and get a good idea of where your bottlenecks might be - go through the site
manually while it is under load and examine the execution times. Microsoft
has a free tool that you can use for putting the load against the site -
http://webtool.rte.microsoft.com/. Ballpark figures seem to be between 5-10
per processor depending on who you speak with. If you have more questions
feel free to contact me offline.
-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:17 AM
To: CF-Talk
Subject: COncurrent Users
Hi,
Is there a way to test system performance based on differenet number of
concurrent users? Are there any guidelines from macroMedia on the
maximum number of concurrent users CF server supports? I realise this is
quite ballpacrk but basically need to presnet some figures to our
client.
Regards,
Nick
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation
Maybe this? Loop around the
INSERT INTO Table
(Field)
VALUES ('#theQuery.FieldValue#')
At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
wasgr ;-)
>
>Thanks
>
>Bryan Stevenson
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>p. 250.920.8830
>e. [EMAIL PROTECTED]
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>
>- Original Message -
>From: "Steve Oliver" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, February 06, 2002 5:06 PM
>Subject: RE: looping inside cfquery - brain on vacation
>
>
>> Oh nevermind, your not looping over the columns of the query (long
day
>> as well)
>>
>> I think you need a semi-colon at the end of your query, since that
will
>> put multiple inserts in one cfquery.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:02 PM
>> To: CF-Talk
>> Subject: RE: looping inside cfquery - brain on vacation
>>
>>
>> Hmmm, well if one of your fields is numeric, then that wouldn't work,
>> since numeric values don't need 's around them, you could use the
>> isNumeric() function for that.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:01 PM
>> To: CF-Talk
>> Subject: looping inside cfquery - brain on vacation
>>
>>
>> OK..long day..CF whining about syntax...help!
>>
>> The situation:
>>
>> CF doesn't like my syntax for this bit of looping over a query to
insert
>> muliple records. It's
>> complaining about the final ")" closing bracket for the insert. Any
>> ideas? I'm sure I've done it
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>>
>>
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>
>>
>>
>> TIA
>>
>> Bryan Stevenson
>> VP & Director of E-Commerce Development
>> Electric Edge Systems Group Inc.
>> p. 250.920.8830
>> e. [EMAIL PROTECTED]
>> -
>> Macromedia Associate Partner
>> www.macromedia.com
>> -
>> Vancouver Island ColdFusion Users Group
>> Founder & Director
>> www.cfug-vancouverisland.com
>>
>>
>>
>>
>
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive
RE: Release Database
Just put this in a template and view it in your browser, it will unlock your dbase connections. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Graham Lewis [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 12:56 PM To: CF-Talk Subject: Release Database I find that I cannot overwrite a database file since it appears that CF has it locked. How can I release it so I can overwrite it? Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Release Database
If you're using an Access database, and that's the lock you're trying to release, just run a query that will definitely fail, and that will release the lock on the file. Example: SELECT badColumn FROM badTable Since that table (hopefully!) doesn't exist, the lock will be released on the database file and you will be able to overwrite it. Hope this helps, Dave. Original Message Follows From: "Douglas Brown" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: Release Database Date: Thu, 7 Feb 2002 10:18:22 -0800 What are you using for you DB? You can simply right click on the DB in SQL and choose take offline. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Graham Lewis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:56 AM Subject: Release Database > I find that I cannot overwrite a database file since it appears that CF > has it locked. How can I release it so I can overwrite it? > > Graham > > Graham Lewis > Centre for Academic Practice > University of Warwick > CV4 7AL > Tel: 024 765 73109 > Mobile: 07733450022 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Release Database
sounds like you are using Access? is there a .ldb file? If so then all you have to do is run a bad query against the database (mabye a few times). Create a file with the bad query (SELECT Something FROM Nothing) and run it in a browser.that will kill the lock file when it creates an error (if it doesn't work the first time...try again). You could also simply try restarting CF Server if you have access to it. HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Graham Lewis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:56 AM Subject: Release Database > I find that I cannot overwrite a database file since it appears that CF > has it locked. How can I release it so I can overwrite it? > > Graham > > Graham Lewis > Centre for Academic Practice > University of Warwick > CV4 7AL > Tel: 024 765 73109 > Mobile: 07733450022 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Release Database
You need to do one of two things: 1) go the cfadmin and to the ODBC connection to your database (Access I am guessing) then turn off the "keep connections alive" until you are ready to go live with the whole thing. 2) copy the db, paste the copy and append a "_a" or whatever to the end - then go to the cfadmin (as above) and append the "_a" to the end of the path, wait for a while then work on the "old" version, then when you are ready swap them back... HTH J -Original Message- From: Graham Lewis [mailto:[EMAIL PROTECTED]] Sent: 07 February 2002 17:56 To: CF-Talk Subject: Release Database I find that I cannot overwrite a database file since it appears that CF has it locked. How can I release it so I can overwrite it? Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion and Networks
Look for the Intranet Hosting Tool Kit on www.intrafoundation.com. It's a series of CFX custon tags that should be able to achieve what you are looking for. Lewis Sellars released this as freeware awhile back... Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:35 AM To: CF-Talk Subject: RE: Cold Fusion and Networks I don't know of anybody who's done it, but I'm sure that it can be done - write a custom tag in C++ or java that does the job. - Matt Small -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:51 AM To: CF-Talk Subject: Cold Fusion and Networks Sorry for the double post..I wasn't sure if the subject was descriptive enough. :-) Has anyone done the following: Accessed their domain and got a list of machine names on their network? Also, I want to know if it is possible to not only access the list of names, but to add machine names, and remove all using CF. I knwo this can be done in PERL using the win32 API. Anyone have some thoughts?? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Release Database
What are you using for you DB? You can simply right click on the DB in SQL and choose take offline. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Graham Lewis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:56 AM Subject: Release Database > I find that I cannot overwrite a database file since it appears that CF > has it locked. How can I release it so I can overwrite it? > > Graham > > Graham Lewis > Centre for Academic Practice > University of Warwick > CV4 7AL > Tel: 024 765 73109 > Mobile: 07733450022 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Release Database
I find that I cannot overwrite a database file since it appears that CF has it locked. How can I release it so I can overwrite it? Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion and Networks
I don't know of anybody who's done it, but I'm sure that it can be done - write a custom tag in C++ or java that does the job. - Matt Small -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:51 AM To: CF-Talk Subject: Cold Fusion and Networks Sorry for the double post..I wasn't sure if the subject was descriptive enough. :-) Has anyone done the following: Accessed their domain and got a list of machine names on their network? Also, I want to know if it is possible to not only access the list of names, but to add machine names, and remove all using CF. I knwo this can be done in PERL using the win32 API. Anyone have some thoughts?? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: COncurrent Users
The best way to do this is with a load test tool. Create a script that
walks through your site and then run the test with different settings for
the number of concurrent users. Compare the results to determine the best
setting for that application. That is also a good time to enable debugging
and get a good idea of where your bottlenecks might be - go through the site
manually while it is under load and examine the execution times. Microsoft
has a free tool that you can use for putting the load against the site -
http://webtool.rte.microsoft.com/. Ballpark figures seem to be between 5-10
per processor depending on who you speak with. If you have more questions
feel free to contact me offline.
-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:17 AM
To: CF-Talk
Subject: COncurrent Users
Hi,
Is there a way to test system performance based on differenet number of
concurrent users? Are there any guidelines from macroMedia on the
maximum number of concurrent users CF server supports? I realise this is
quite ballpacrk but basically need to presnet some figures to our
client.
Regards,
Nick
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation
Maybe this? Loop around the
INSERT INTO Table
(Field)
VALUES ('#theQuery.FieldValue#')
At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
wasgr ;-)
>
>Thanks
>
>Bryan Stevenson
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>p. 250.920.8830
>e. [EMAIL PROTECTED]
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>
>- Original Message -
>From: "Steve Oliver" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, February 06, 2002 5:06 PM
>Subject: RE: looping inside cfquery - brain on vacation
>
>
>> Oh nevermind, your not looping over the columns of the query (long
day
>> as well)
>>
>> I think you need a semi-colon at the end of your query, since that
will
>> put multiple inserts in one cfquery.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:02 PM
>> To: CF-Talk
>> Subject: RE: looping inside cfquery - brain on vacation
>>
>>
>> Hmmm, well if one of your fields is numeric, then that wouldn't work,
>> since numeric values don't need 's around them, you could use the
>> isNumeric() function for that.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:01 PM
>> To: CF-Talk
>> Subject: looping inside cfquery - brain on vacation
>>
>>
>> OK..long day..CF whining about syntax...help!
>>
>> The situation:
>>
>> CF doesn't like my syntax for this bit of looping over a query to
insert
>> muliple records. It's
>> complaining about the final ")" closing bracket for the insert. Any
>> ideas? I'm sure I've done it
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>>
>>
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>
>>
>>
>> TIA
>>
>> Bryan Stevenson
>> VP & Director of E-Commerce Development
>> Electric Edge Systems Group Inc.
>> p. 250.920.8830
>> e. [EMAIL PROTECTED]
>> -
>> Macromedia Associate Partner
>> www.macromedia.com
>> -
>> Vancouver Island ColdFusion Users Group
>> Founder & Director
>> www.cfug-vancouverisland.com
>>
>>
>>
>>
>
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Possible bug in StructFindKey() in CF Ent 4.5.1 SP-2 on Win NT4/2000 Server?
Hi Raymond, Another quick update for you on my progress on this issue. I've knocked up a recursive (eugh...) custom tag for our 4.5.1 installation which mirrors the interface to StructFindKey in that in the first instance it takes in the top level structure, the key name and the scope and then returns an array of results showing the owner, the path and the value. I think I have isolated the steps to reproduce/invoke the problem: I tried altering the WDDX packet in a few ways - I cut the number of rows down, reduced the number of columns and I replaced the nested structs with one-layer structs but all to no avail. When there was only one row it worked fine, but I know CF is capable of storing multiple query rows in a WDDX packet and I need to store multiple rows anyway. The only thing that seemed to improve the situation where multiple rows were concerned was removing the WDDX packets contained in the WDDX file, i.e. the content! But, and this is a big BUT, I found that the problem vanished when the first field in each nested structure was not empty. As the first field in the test structs is always "ALIGN", I popped "left" into the pairs in the WDDX packet and lo and behold it worked! My thinking here was that the FILENAME (the key I was searching for) could not be empty but placing values in there didn't fix the problem. Next I tried the first element and that fixed it. So, is this a bug in CFWDDX de-serialising nested WDDX packets or a bug in StructKeyFind()? Thanks again and hope this updated information helps you guys out, Colin __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fixed: finding hidden characters
Hi Carol, I used to struggle mightily with these issues, too. Then, I realized that I can do all my formatting in html, and excel will "get it." In other words, dump the whole error.diagnostics into one and it will show up in one column, regardless of whether or not there are weird characters. (You may span rows, though.) Make sense? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Server on a separate machine
set username and password for the datasource in CF Admin Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Kay Smoljak" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 9:52 PM Subject: SQL Server on a separate machine > Hi all, > > Our development environment has CF4.5 and SQL Server 2K on an SBS2K > machine on a LAN. Some of my clients are on CF5 hosting, and there are > some features of CF5 I would like use for these clients. I have the > Developers edition of CF5 on my Win2K machine, and I would like it to > connect to databases on the SQL Server (over the LAN). I can set up a > DSN on my machine, but when I try to run a CFQuery it errors out because > I'm not using a "trusted connection". How do I set the server up so it > will allow my machine to connect? Can I even do this on SBS2K? > > Thanks, > Kay. > __ > Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd > > Level 9/105 St George's Terrace - Perth - Western Australia > Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au > > http://developer.perthweb.com.au - Tools for Developers > cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFSERVER and security
I currently run CF with a non-system account. a) breaking current applications is certainly an issue. I have figured out how to set permissions that work for me (documented at http://www.defusion.com/articles/index.cfm?ArticleID=89) but, depending on what databases and other components you use you may have to experiment. b) new security holes: I regard using a non-system account as an overall security improvement, because someone who gets control of CF doesn't necessarily get control of the box. However, someone who gets control of CF may, in a non-system account situation, get some sort of access to other machines. Exactly what access they obtain depends on how you set up the account. > -Original Message- > From: Brian L. Wolfsohn [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 11:47 AM > To: CF-Talk > Subject: CFSERVER and security > > > At 12:48 PM 5/8/2001 -0400, you wrote: > > >Is this "T:" drive physically on your server, or is it on > another server? If > >it is on another server, the CF Service must be run in the > context of a user > >that would have access to that other server. Just because > you can see the > >drive share doesn't mean CF can. > > This response was originally part of a discussion on > accessing files using > cffile, and the need to run cfserver under a user account as > opposed to the > system account. > > I'm concerned with the ramifications of running cfserver as a > user account > as opposed to the system account. Are there security issues > that don't > exist when it's run under the system account ? We've got a > pretty heavily > used existing live box that has been running cfserver under > the system > account. I'm concerned about A:breaking existing applications and > B:creating security holes that didn't exist before. > > Any advice would be appreciated. > > > Brian L. Wolfsohnhttp://www.cus.com > CUS Business Systems Ft.Lauderdale,FL > Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED] > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSERVER and security
At 12:48 PM 5/8/2001 -0400, you wrote: >Is this "T:" drive physically on your server, or is it on another server? If >it is on another server, the CF Service must be run in the context of a user >that would have access to that other server. Just because you can see the >drive share doesn't mean CF can. This response was originally part of a discussion on accessing files using cffile, and the need to run cfserver under a user account as opposed to the system account. I'm concerned with the ramifications of running cfserver as a user account as opposed to the system account. Are there security issues that don't exist when it's run under the system account ? We've got a pretty heavily used existing live box that has been running cfserver under the system account. I'm concerned about A:breaking existing applications and B:creating security holes that didn't exist before. Any advice would be appreciated. Brian L. Wolfsohnhttp://www.cus.com CUS Business Systems Ft.Lauderdale,FL Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Importing Uploaded Excel Data into DB
Ok, right now I am finishing up development on the app with Access, b ut it will be SQL 7 in production. - Original Message - From: "C. Hatton Humphrey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 11:40 AM Subject: RE: Importing Uploaded Excel Data into DB > What kind of DB are you using? One way we've accomplished this in the past > is to actually create a "floating" Excel data source. We upload th e file > and use CFFile to copy it into the right position and give it the r ight > name. Once in place, we query the Excel data source and then inser t into > the SQL Server one. > > That was an old solution and we have a looping process in place as well that > limits the number of records dealt with to 100 per load. If you're using > SQL Server there are DTS packages or Bulk Insert options available as well. > > HTH > Hatton > > > > -Original Message- > > From: Dave Douglas [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 07, 2002 11:35 AM > > To: CF-Talk > > Subject: Importing Uploaded Excel Data into DB > > > > > > Hello, > > > > I have searched past messages to the list and have seen some > > recommendations > > for the csvtoquery custom tag > > to put the spreadsheet data into a query. What makes my > > situation unique (I > > think) is that the spreadsheet has > > commas in the data in some of the columns. I tried CSVformat and > > am able to > > print out the data on row at a time. Where I am stuck now is how to get > > this information into the DB and how to get it in the right > > fields as right > > now it is printing all columns for each employee on one line each and it > > blows up the query when I try to insert #item# as the Value. Any Help is > > GREATLY appreciated! > > > > here is my code so far: > > > > > file="#File.ServerDirectory#\#File.ServerFile#" > > variable="excelList"> > > > > > > > > > > > list="#NewList#" > > delimiters="^"> > >#item# > > > > > > A working version, with csv and txt files available is at > > http://www.high-techsolutions.net/development/UpLoad.cfm > > > > TIA, > > > > Dave > > > ___ ___ > Get Your Own Dedicated Windows 2000 Server > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > Instant Activation · $99/Month · Free Setup > http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFContent Download Mime
I've worked all morning on this, and can't figure this out. This is my first time working with CFContent. When I load this page, the excel document loads in the browser (as text). I would like to start a download, or just go ahead and load in IE as an Excel document like a "http://tflweb/managersinvites3.xls"; call. What am I missing? Start Of Template End Of Template Start Display in Browser >> ÐÏࡱ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Importing Uploaded Excel Data into DB
What kind of DB are you using? One way we've accomplished this in the past is to actually create a "floating" Excel data source. We upload the file and use CFFile to copy it into the right position and give it the right name. Once in place, we query the Excel data source and then insert into the SQL Server one. That was an old solution and we have a looping process in place as well that limits the number of records dealt with to 100 per load. If you're using SQL Server there are DTS packages or Bulk Insert options available as well. HTH Hatton > -Original Message- > From: Dave Douglas [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 11:35 AM > To: CF-Talk > Subject: Importing Uploaded Excel Data into DB > > > Hello, > > I have searched past messages to the list and have seen some > recommendations > for the csvtoquery custom tag > to put the spreadsheet data into a query. What makes my > situation unique (I > think) is that the spreadsheet has > commas in the data in some of the columns. I tried CSVformat and > am able to > print out the data on row at a time. Where I am stuck now is how to get > this information into the DB and how to get it in the right > fields as right > now it is printing all columns for each employee on one line each and it > blows up the query when I try to insert #item# as the Value. Any Help is > GREATLY appreciated! > > here is my code so far: > > file="#File.ServerDirectory#\#File.ServerFile#" > variable="excelList"> > > > > >list="#NewList#" > delimiters="^"> >#item# > > > A working version, with csv and txt files available is at > http://www.high-techsolutions.net/development/UpLoad.cfm > > TIA, > > Dave > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Importing Uploaded Excel Data into DB
Hello, I have searched past messages to the list and have seen some recommendations for the csvtoquery custom tag to put the spreadsheet data into a query. What makes my situation unique (I think) is that the spreadsheet has commas in the data in some of the columns. I tried CSVformat and am able to print out the data on row at a time. Where I am stuck now is how to get this information into the DB and how to get it in the right fields as right now it is printing all columns for each employee on one line each and it blows up the query when I try to insert #item# as the Value. Any Help is GREATLY appreciated! here is my code so far: #item# A working version, with csv and txt files available is at http://www.high-techsolutions.net/development/UpLoad.cfm TIA, Dave __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to Find Hidden Characters -- maybe related to whitesp...
Try Searching for the following: chr(13) & chr(10) or any combo of the two. - j . jim.curran technical.director nylon.technology six.west.fourteenth.street new.york.ny.10011 212.691.1134 [EMAIL PROTECTED] .. -Original Message- From: Carol Bluestein [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:02 AM To: CF-Talk Subject: How to Find Hidden Characters -- maybe related to whitesp... Subject: How to Find Hidden Characters -- maybe related to whitespace issue - Greetings all. I'm having one !@#%$#$^$%^& of a time figuring this out. Can anyone out there help? The Task: Taking the information from the error/cferror variables saving them in a log file which can then be displayed in EXCEL, with one column per variable. The Problem: everything works EXCEPT error.diagnostics, which insists on placing itself in two columns. The Analysis: The diagnostics information is preformatted by coldFusion and contains a hidden cr/lf or paragraph marker(s) that I can not seem "read" programmatically so that I can remove it. The Question: How do I do this... remove these hidden characters? Testing so far has shown that I can remove the hidden marker by removing a block of space in which it is contained, but it requires that I have seen where it occurs and for which type of error and an assumption that it will always "look" the same for each error. If I try to remove just "extra spaces" in a loop, the hidden character does not get "caught" and remains. Anyone have any ideas I've been working on this for several days. Any help would be very much appreciated. Thanks, Carol Carol Bluestein TAAD, Senior Programmer NYS Office of Real Property Services 16 Sheridan Avenue Albany, NY 12210 518-486-6335 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
Hi, This is a continuation from yesterday. I have a file index.cfm with the below code in it: SELECT sti, ID FROMfontsti ORDER BY sti #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# [#GetFontFamily.ID#] #LCase(ListGetAt(GetFontFamily.sti,1,'.'))# This gets submitted to "create-list.cfm" which creates a list of the following: Euro European-Pi Garamond Helvetica #REReplace(FORM.select,",","","ALL")# How can I loop through the above results using a http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC
Mark, You are right that HomeSite is a scaled down version of CF Studio, although I like to think of it as CF Studio is a pumped up version of HomeSite . . . I install HomeSite even though I have Studio because I am the point person for the copies we distribute to our developers. I need to see what they see when they have questions about HomeSite. George [EMAIL PROTECTED] > ... snipped ... > In any case, I'd be interested > to know what Homesite gives you that CF studio does not? > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need ideas for resource available calendar
Hatton, I'm presuming that you've already got a database developed which stores the relevant info for resource availability etc and are basically looking to create Gantt charts from the data. With this presumption, you could download a 30 day trial copy of Popchart Image Server from www.corda.com then use the stacked horizontal barchart option to create your gantt charts as per your data. This solution wouldn't quite give you the calendar effect as in Outlook. HTH, Dave -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: 07 February 2002 13:45 To: CF-Talk Subject: Need ideas for resource available calendar Hey folks, I'm working on a calendar module for our Project/Task/Time tracking system and have hit a brain freeze... I know there's got to be code out there to generate a monthly calendar, but either I'm not looking for the right thing or I'm not seeing the right response. Basically what I need to build is a monthly calendar view that shows bars across dates that have task information in the date... sort of like what the Outlook calendar looks like for multi-day events. Right now we have something like this that works for a single week... they want it expanded to offer month, quarter and day views. Oh what fun! Anyone have any suggestions of where to look? TIA Hatton __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
porting cf
We're trying to port from NT4, CF4.0 to Sun Solaris 2.8 running CF 4.5. Case has been checked, the datasource is verified. The query referred to in the error is: (about as basic as it can be) select * from dsel The error message is: Error Diagnostic Information ODBC Error Code = S1000 (General error) [MERANT][ODBC SQL Server Driver]Unicode conversion failed The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (13:1) to (13:53). Date/Time: Wed Feb 06 11:00:42 2002 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461) Can this be done or is the Unicode simply easier to deal with by rewriting on the Solaris? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Weight Loss
I'm in the thinking stage of a small project for a group of friends. I want to keep it fairly simple. It would be in Access Person1 WeightLost (bar graph) WeightGoal Person2 WeightLost WeightGoal and I would like to display this in cfgraph. Is this possible? Ann Harrell, USA Phone: 219.342.0618 A society that will trade a little liberty for a little order will lose both, and deserve neither. --- Thomas Jefferson, in a letter to Madison __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle Error
Have you checked the limitations on your firewall? We ran into a similar situation (with a similar network configuration), and we discovered that it was because our firewall (Raptor) only supported 30 concurrent Oracle connections at a time, which essentially made all of our DMZ CF/Oracle sites non-functional. To alleviate the situation, we used Connection Manager to set up the connections, and everything has been fine since. Debbie McDaniel -line.com> cc: Subject: Oracle Error 02/07/2002 09:57 AM Please respond to cf-talk Hi everyone, I keep getting these weird errors with Oracle 8i that of course are being blamed on ColdFusion. Here goes. Our webserver sits in the DMZ and our database server is inside the firewall. All traffic going from the webserver goes through the firewall to talk to the database. I seem to be able to access the database through coldfusion 90% of the time, but sometimes I will get an ORA-0 error or an ORA-12203:TNS:unable to connect to destination error, both of which result in massive errors in the application and the eventual rebooting of the machine. I am thinking it may be a network issue, but because coldfusion is new to this company they want to blame it. If I log in with sql+ (an oracle client) I can access the datasource w/o trouble, although cf can't even verify the datasource. This usually happens after several moderate hits to the datasource. We are running CF 4.5.2 with all the appropriate patches applied on a Compaq Windows 2000 machine with all the appropriate service packs applied to Win2K. Our database is Oracle 8i - anyone have some suggestions? Greatly appreciated! Debbie M. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to Find Hidden Characters -- maybe related to whitesp...
Subject: How to Find Hidden Characters -- maybe related to whitespace issue - Greetings all. I'm having one !@#%$#$^$%^& of a time figuring this out. Can anyone out there help? The Task: Taking the information from the error/cferror variables saving them in a log file which can then be displayed in EXCEL, with one column per variable. The Problem: everything works EXCEPT error.diagnostics, which insists on placing itself in two columns. The Analysis: The diagnostics information is preformatted by coldFusion and contains a hidden cr/lf or paragraph marker(s) that I can not seem "read" programmatically so that I can remove it. The Question: How do I do this... remove these hidden characters? Testing so far has shown that I can remove the hidden marker by removing a block of space in which it is contained, but it requires that I have seen where it occurs and for which type of error and an assumption that it will always "look" the same for each error. If I try to remove just "extra spaces" in a loop, the hidden character does not get "caught" and remains. Anyone have any ideas I've been working on this for several days. Any help would be very much appreciated. Thanks, Carol Carol Bluestein TAAD, Senior Programmer NYS Office of Real Property Services 16 Sheridan Avenue Albany, NY 12210 518-486-6335 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
newgroup
Hi Everyone, I was wondering if those that use the newgroup version of this great list have been able to find a solution for the incorrect dates. I've tried 3 different newsgroups [Forte Freeagent, Netscape, and Xnews]. All the readers have the wrong dates. The exception seems to be if someone else posts to the through the newsgroup. Those posts display the right date. I know this is a real small problem...but somehow it really bugs. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help required on CF Performance....
Thanks Deanna! Nick -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: 07 February 2002 15:47 To: CF-Talk Subject: Re: Help required on CF Performance The answer was www.opensta.org. You can set up a script to run with multiple virtual users and see how performance degrades (or doesn't) with additional users. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: evil error>>>
We've had this error reported a couple of times with CF 5 users. Try unchecking the Load JVM when ColdFuion starts option in the Administrator under JVM settings. You may need unregister the Java CFX tag, restart and register again. This seems to occur only after a large number of calls to a Java CFX tag. We have not been able to replicate the problem, but I wonder if it might be related to this tech note: http://www.macromedia.com/v1/handlers/index.cfm?ID=21872&Method=Full This above concerns a problem when a user logs off and then logs back on when the JVM is being used. It suggests updating to JRE 1.3.1_01 and adding -Xrs to the implementation options. Greg Alton CFDev - Original Message - From: "Tyler Silcox" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:48 AM Subject: evil error>>> > I'm getting a very naughty error on a page that I have been running 25+ > times a day for the last two months. It's a page that is scheduled to > run every hour and can also be initiated by a link. It grabs all the > user names and passwords from the db for some pop accounts, cfpops thei r > mailboxes, and throws all their messages into our db, where they are > filtered and marked as sorted. All of a sudden I can't get past the > first cfpop. I keep getting the error below. I even changed the amoun t > of messages to download from 100 to 5 (while only hitting one mailbox), > and it's still dying on me immediately after running without a hitch fo r > 2 months (while downloading up to 100 messages per mailbox). I know > y'all don't have all the specifics, but is this likely due to some othe r > nasty server problem, or is it probably my page? I've watched the > server task manager as I've hit the page and the ColdFusion process > never really rises above 15% or so in CPU time on the Processes tab, bu t > it maxes out the CPU Usage History on the Performance tab. In my cf > logs, I get this error: > > Unknown error threshold reached. Restarting service. > > And then, this is the error I get returned to me on the page I'm trying > to hit: > Error Diagnostic Information > Request canceled or ignored by serverServer busy or unable to fulfill > request. The server is unable to fulfill your request due to extremely > high traffic or an unexpected internal error. Please attempt your > request again (if you are repeatedly unsuccessful you should notify the > site administrator). (Location Code: 26) > > Everything is still running pretty smoothly around here, except for our > java-based cfx_activmail tag hasn't been completing it's duties. I'm > wondering if the jvm could be churning itself inside out, and affecting > cfpop? I'm running out of ideas... > > What are my options here? Reinstall the server, set up a Java mail > popper, just go home and watch some oprah and pretend this never > happened? > > Thanks again for any help y'all can provide-> > > Tyler > email | [EMAIL PROTECTED] > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IIS question
Hi, I've been given a site to work on that uses a site root reference in all of it's links(a href="/etc.cfm"). The links don't work on our development server where there was only a default web site created. So I created a website with the snap-on with the home directory as root, but the links still don't work. Any suggestions about what I'm doing wrong/not doing? TIA, Doug Jordon __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Installing HomeSite/CF Studio 5.0 when 4.5.2 is on PC
At 10:54 AM 02/07/2002 -0500, you wrote: >1. I want HomeSite 5 to detect and bring in the settings I have with >HomeSite 4.5.2 and then I want to uninstall 4.5.2 but if I do that I then >have to reinstall 5 but my 4.5.2 will be gone, along with all it's settings, >so I won't be able to migrate over my settings again? Does this mean that to >migrate my settings I have to leave 4.5.2 on my PC after I install 5? >Forever? Same thing with CF Studio 4.5.2 and 5.0? Well, you can check out the UserData folder in your installation directory. For CF Studio, I believe it contains all your user settings. Back it up and you should be able to restore your settings just by replacing the directory and re-loading home-site. Although, I can't say for certain, I'd also look for some sort of HomeSite.Ini file >2. I don't want to install JRun Studio 3.0.1 (or JRun 3.0.1, I'm confused >about which one they mean, studio or the app server or both?). At least not >now. But I might want to later. If I do it later then I will have to >reinstall both HomeSite 5 and CF Studio 5 and I'll lose my settings again? I'd guess they mean JRun studio, although I can't say for certain. >3. Does the shared files paragraph really mean that if I ever uninstall >HomeSite 5.0/CF Studio 5.0 and I want to reinstall them I first have to >reinstall versions 4.5.2 or make sure they are still on my PC? Are versions >4.5.2/5.0 of HomeSite/Studio forever joined at the hip if I want to retain >my settings? I bet they mean that HomeSite / Studio 4.5.2 uses old versions of a specific DLL. HomeSite/ CF Studio 5 uses newer versions. 5 won't work on the older versions, but 4.5.2 will work on the newer versions. If you re-install 4.5.2 then you over-write the new versions. Of course, this is all speculation. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- Need a Web Developer? Contact me! My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com My New Book: ColdFusion: A Beginner's Guide February 2002 -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
