OT: SQL Question
It's been a very long day (a very long year in fact :), and I'm severely stumped on something I guess is dead easy. Using CF 4.5.1 and SQL Server, I have a list of names like so (fields firstname and lastname in a db): John Smith Jean Paul Gaultier Jane Doe I construct links like this: who.cfm/JohnSmith who.cfm/JeanPaulGaultier who.cfm/JaneDoe The last bit is caught in a variable "who", and then I'd like to do a query like this SELECT * FROM tblNames WHERE replace(firstname+lastname," ","")='#who#' SQL server chokes on this. Replace() is a valid TSQL function, I guess I need something like DE() in CF... Any ideas? Michel -- Michel Vuijlsteke Managing Director Netpoint NV ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: oracle error
Jason, What kind of firewall? Regards Stew I have just recently moved from test to acceptance... we also moved the database from the DMZ to inside the firewall... 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 the such... included is the error that is logged. 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 on sun with oracle 8i - anyone have some suggestions? Greatly appreciated! Jason Egan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
>SQL server chokes on this. >Replace() is a valid TSQL function, I guess I need something like DE() in >CF... >Any ideas? Just use single quotes. SELECT * FROM tblNames WHERE replace(firstname+lastname,' ','')='#who#' It should work now. Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
German Fusebox.de Mailinglist
Hi, I just started the german Fusebox.de Mailing List - we have already 33 Subscriber. Sign up here: http://www.fusebox.de/ or here: http://www.ecircle.de/circles/fusebox -- MfG Felix Huber --- Felix Huber, Web Application Programmer, Webtopia Guendlinger Str.2, 79241 Ihringen - Germany [EMAIL PROTECTED](07668) 951 156 (phone) http://www.webtopia.de(07668) 951 157 (fax) (01792) 205 724 (mobile) --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MORE VERITY PROBLEMS
Dylan: I think if you are not using the full version of verity that there is a problem with it indexing Word 2000 documents. In fact I think it might have trouble indexing any MS Office 2000 documents. Allaire says they plan to fix that with the newer version of verity that is supposed to ship with the next major release of CF. Andrew Hewitt Web Application Developer webworld studios, inc. www.wwstudios.com -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 12:48 AM To: CF-Talk Subject: MORE VERITY PROBLEMS Now I delete a collection but the files are still on the server so when I try and make a collection with the same name...yep you guessed it...NADA. Anyone out there using Verity a lot? In some ways it's very cool. In other ways...it's stinky. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java to cf
How much of the app are you converting ,can you use some of the Java from ColdFusion??? Using the cfServlet and cfobject tags?? Or chould you wrap some of the Java in cfx_ 's ?? Java is quite easy, don't be afraid (Although it depends on the size of the site) Justin MacCarthy >-Original Message- >From: Rick Lamb [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, November 22, 2000 1:18 AM >To: CF-Talk >Subject: Java to cf > > >I've been handed a site that was written in jhtml using Java, >class, and cgi >for the backend stuff. The task I've been given is to convert this Java >based website into a cf site (we don't support java). Anybody have any >suggestions on how this could be done or if it is even feasible considering >I know nothing about Java? Just wondering if anyone has ever >successfully or >unsuccessfully tried to do something like this and what there experience's >where. > >Thanks, > >Rick > >~~ >Structure your ColdFusion code with Fusebox. Get the official book >at http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MORE VERITY PROBLEMS
I've had this problem. I found I had to restart the CF server after removing a verity collection if it got corrupt or anything. Then I could replace the old colection with a new one. We are using 4.0.1 I hope it may be fixed in 4.5.1 Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: 22 November 2000 06:14 To: CF-Talk Subject: Re: MORE VERITY PROBLEMS Why don't you remove the collection before trying to make a new one? At 09:47 PM 11/21/00 -0800, you wrote: >Now I delete a collection but the files are still on the server so when I >try and make a collection with the same name...yep you guessed it...NADA. > >Anyone out there using Verity a lot? > >In some ways it's very cool. In other ways...it's stinky. > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > >-=-=- >SBG-Priority: 4 (Low) http://www.internz.com/SpamBeGone/ -- Michael She I m a g i n e C o m m u n i c a t i o n s Company E-mail: [EMAIL PROTECTED] Personal E-mail: [EMAIL PROTECTED] ICQ UIN: #243466 Personal Homepage: http://www.michaelshe.com (Under Construction) Imagine Communications: http://www.imagineer.net PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Determining optimum timeout
Some kind of random element in the timeouts could be effective in avoiding contention. Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 21 November 2000 21:59 To: CF-Talk Cc: [EMAIL PROTECTED] Subject: RE: Determining optimum timeout > How do you determine the optimum timeout for a cflock? I > currently have most of mine set to timeout="10" but am > wondering if there is a method to determining timeouts? Unfortunately, there isn't a very good answer for this. I personally tend to keep timeouts for using memory variables around 2-5, but use larger values when locking access to other shared resources, like CFX tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Broadvision [Fraudvision]
Anyone had any experience with Broadvision and (or without) CF? I am just about to embark on a project that will be tightly intergrated with it and as Project Lead I would like to know what everyone thinks - any experiences? I know the general consensus about BV - but that could be just one opinion!? Anyone? Neil http://www.mcbdigital.com ---> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS
On 11/21/00, Ben Forta penned: >CF will not generate an error if the database does not support block >factoring, it's far worse than that. CF has no way to poll the database to >see what it supports, so if you specify a number to high it'll try that, if >that fails it'll try a lesser number, and then a lesser one, all the way >down to 1. And by that time you've lost the entire performance gain, and >probably introduced new lag time. According to the article by Mr. Van Horn, any Oracle or ODBC datasource supports blockfactor. Is that not true? > >Also, setting a block factor too high when it is not needed will hurt >performance because allocating and freeing those larger buffers takes time >(and takes memory away from where it could be more efficiently used). Well, how can you know when it's needed? Obviously, when doing a search, you may return 1,000 records, or you may return 1. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Saved Searches & Cron Job E-mail Results
I am creating a real estate site that allows real estate buyers to search our database of listed homes. The homes are searched by area and price. I would like to have the option for a cron job which runs periodically (once every 3 days or so) that returns new found results via e-mail for each search that was performed (if requested by the client through an e-mail address text box). If no new entries are found, no e-mail is sent. Is this possible with CF? I have done this with PERL before, but it took LOTS of code. This site is nearly completed...I just want to add this feature to the existing code. Below is the existing "search" page:
RE: WAY OT: Mac services and NT
> or you could always try http://www.yaromat.com/macos :P > > SorryI couldn't help myself. That was excellent... glad you couldn't :-) -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Printing mailing labels in a browser -- Joy... :-O
I am currently talking with a company called Loftware who is in the process of developing this sort of capability via HTML from the web for Bar-Code Labels. I would think you could apply the same logic for mailing labels. We are talking to them in order to set up the labeling process for returning products. If you are interested let me know and I will post what I find out. Robert Lehman (Bob) New Horizon Mgmt and Consulting 440-542-0992 Visit our Website at www.nhmac.com Visit the client Website at www.nhmac-user.com - Original Message - From: "Brad Roberts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 21, 2000 11:18 PM Subject: RE: Printing mailing labels in a browser -- Joy... :-O > > > I'm going to have the same challenge with a current project, printing > cassette tape lables. > > If you're using IE, would it work to create a "Avery" label document in M$ > Word, save it as HTML, and use that to make your template? > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 21, 2000 8:25 PM > To: CF-Talk > Subject: RE: Printing mailing labels in a browser -- Joy... :-O > > > Plus you've got a print preview feature in IIS v5.5 SP1 now... :) > > -ron > > > -Original Message- > > From: Michael Thomas [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 21, 2000 5:15 PM > > To: CF-Talk > > Subject: Re: Printing mailing labels in a browser -- Joy... :-O > > > > > > Hmm cant say Ive ever had a job like this BUT CSS 2.0 dedicated a > > good part > > of the spec towards printing. I think its worth a look into at the very > > least. Heres a couple styles to get you started: > > > > Marks: > > Orphans: > > Page: > > Page-Break-After: > > Page-Break-Before: > > Page-Break-Inside: > > Size: > > Widows: > > > > Hope this helps. > > > > Sincerely, > > Mike T. Lakes > > > > > > >From: "Mark W. Breneman" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: CF-Talk <[EMAIL PROTECTED]> > > >Subject: Printing mailing labels in a browser -- Joy... :-O > > >Date: Tue, 21 Nov 2000 15:46:08 -0600 > > > > > > > > >My boss just "gave" me a new project Printing mailing labels from a > > >browser. > > > > > >Any one try anything this odd? > > >Thanks > > >Mark W. Breneman > > >-Cold Fusion Developer > > >-Network Administrator > > > Vivid Media > > > [EMAIL PROTECTED] > > > www.vividmedia.com > > > 608.270.9770 > > > > > >~~ > > >Structure your ColdFusion code with Fusebox. Get the official book at > > >http://www.fusionauthority.com/bkinfo.cfm > > > > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > __ > > ___ > > Get more from the Web. FREE MSN Explorer download : > http://explorer.msn.com > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE CAN'T FIND THE GRID APPLET
Sorry, I don't have any other info on it. We were told by Allaire that this was the way to fix the problem. Bob -Original Message- From: John Grubb [mailto:[EMAIL PROTECTED]] Sent: November 21, 2000 6:06 PM To: CF-Talk Subject: RE: IE CAN'T FIND THE GRID APPLET Thanks, Bob. It looks that way to me, too. I thought I might be missing something in IE. It's unfortunate that I have to add a copy of the folder structure that contains the applet, but I can't very well edit Allaire's java code, can I? Would you happen to know what causes the problem in IE? John -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 1:44 PM To: CF-Talk Subject: RE: IE CAN'T FIND THE GRID APPLET John, I don't know if this applies to your problem, but I recall awhile ago that we had a problem with the CF_TREE applet, and we had to place a copy of the CFIDE directory underneath our application directory - it wouldn't simply pick the applet up from the standard CFIDE location. Bob -Original Message- From: John Grubb [mailto:[EMAIL PROTECTED]] Sent: November 21, 2000 1:10 PM To: CF-Talk Subject: IE CAN'T FIND THE GRID APPLET I am running IIS with a virtual directory under the default directory. I am using a applet in one of the pages. NS Navigator reacts perfectly, but MS IE returns an applet not found error. Upon viewing the HTML source, both browsers show CODE="allaire.controls.cfGridFormApplet CODEBASE="/CFIDE/classes/". Why would NS find it OK and IE not? I don't understand this, since applets are server up by the IIS server to both browsers. Anyone have a fix? Most of my background is with NS, so IE still throws me, sometimes. John Grubb ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Unknown data access error
First, create an SP like this one that only takes one input value; hardcode all the other vars within the SP. This will make debugging easier. Second, I would wonder about the DBVARNAME; maybe it should be DBVARNAME="lr1" instead of "@lr1" ? Third, perhaps SQL Server doesn't believe that what you are passing meets the criteria for a CF_SQL_DATE? If you can verify this, you might pass it as CF_SQL_VARCHAR and convert() to a date within the SP? good luck! -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 5:56 PM To: CF-Talk Subject: Unknown data access error Hi, I am trying to use and I'm passing some variables to a stored procedure via . When I run this CF page which is a simple update statement in SQL I get an 'Unkown data access error'. My code looks fine to me, can you see anything? My CF code: http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY OT: Mac services and NT
I've used both Thursby Systems DAVE and Miramar's PCMacLan. MAcLan is for putting a PC on a Mac network. I use that with our home net work (2 macs 2 PC's) its very simple and easy to use. It also comes with server software so you can use the PC as a server on the AppleTalk network. DAVE is almost as simple, it convinces the PC network that the Mac is just another PC. Fairly seamless, relatively fast. Essentially all you need to do is to enter the Mac's TCP/IP address and make sure the proper permissions are set and it simply works. No complaints and no errors, so far. We can see the mac as another machine on the network and vice versa. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- "Mark W. Breneman" wrote: > > Where do I start...? > > Dave, you have good success with Dave? We find it brings its own issues to > our list of network problems. (I have not toyed with the new version) It > does fix lots of issues. > > What we found that worked really well, better than expected, is windows 2000 > mac services. MUCH better... not perfect, but much better. > > Check out http://www.macwindows.com/NTunsolv.html for answers to some of > your mac - windows problems. > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MORE VERITY PROBLEMS
I can index Excel 2000 docs. -Original Message- From: Andrew [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 2:03 AM To: CF-Talk Subject: RE: MORE VERITY PROBLEMS Dylan: I think if you are not using the full version of verity that there is a problem with it indexing Word 2000 documents. In fact I think it might have trouble indexing any MS Office 2000 documents. Allaire says they plan to fix that with the newer version of verity that is supposed to ship with the next major release of CF. Andrew Hewitt Web Application Developer webworld studios, inc. www.wwstudios.com -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 12:48 AM To: CF-Talk Subject: MORE VERITY PROBLEMS Now I delete a collection but the files are still on the server so when I try and make a collection with the same name...yep you guessed it...NADA. Anyone out there using Verity a lot? In some ways it's very cool. In other ways...it's stinky. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom output tag
Hello, I was able to query an olap cube through cf but didn't get a result. I was told me code should work, I just need to play with the output of the query to put it in a form that cf will understand. I used the querydump tag and it said returned a spaceany suggestions on how I can see the query results? Thanks, Eddie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
permissions problem?
I am attempting to use the AutoResize custom tag to upload pictures to a specified folder on a machine. Everything works correctly on my development machine but the production machine is throwing a what I think is a permissions error: Error processing CFFILE Error attempting to save uploaded file to path 'e:\webclients\domainfolderhere\yourphotos_new\users\59..' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (46:2) to (49:40) in the template file d:\CFUSION\CustomTags\AutoResize.cfm I have verified that write permissions exist on the folder where the pictures are to be uploaded and for the hell of it I changed the permissions to "Full Control" for everyone and I still got the error. Any help or additional suggestions would be much appreciated. The production machine is running NT 4, IIS 4. Shane Witbeck ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Crystal Reports on a separate server?
> Anybody know if you can relocate Crystal Reports to a > separate server, and > call up on your CF server? I'd like to stick the > Crystal Reports > engine on a separate box from the CF box... We have Crystal running on a separate box, however, we do not use CFREPORTS. Our chosen platform is CF, however, because of the integration and performance gain, we use the ASP that ships with Crystal to run reports. So a CF page on an application server will submit a report request to an ASP page on the report server. I've heard we've had a lot of success with this implementation, it really does decrease the load on your main application servers, especially since Crystal is such a resource hog when invoked. -mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts
RE: permissions problem?
1) disk full? 2) is CFFILE enabled in the admin console? -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 6:50 AM To: CF-Talk Subject: permissions problem? I am attempting to use the AutoResize custom tag to upload pictures to a specified folder on a machine. Everything works correctly on my development machine but the production machine is throwing a what I think is a permissions error: Error processing CFFILE Error attempting to save uploaded file to path 'e:\webclients\domainfolderhere\yourphotos_new\users\59..' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (46:2) to (49:40) in the template file d:\CFUSION\CustomTags\AutoResize.cfm I have verified that write permissions exist on the folder where the pictures are to be uploaded and for the hell of it I changed the permissions to "Full Control" for everyone and I still got the error. Any help or additional suggestions would be much appreciated. The production machine is running NT 4, IIS 4. Shane Witbeck ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: permissions problem?
You might need to restart the coldfusion service - NT usually only figures out a user's permissions upon login. -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 9:50 AM To: CF-Talk Subject: permissions problem? I am attempting to use the AutoResize custom tag to upload pictures to a specified folder on a machine. Everything works correctly on my development machine but the production machine is throwing a what I think is a permissions error: Error processing CFFILE Error attempting to save uploaded file to path 'e:\webclients\domainfolderhere\yourphotos_new\users\59..' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (46:2) to (49:40) in the template file d:\CFUSION\CustomTags\AutoResize.cfm I have verified that write permissions exist on the folder where the pictures are to be uploaded and for the hell of it I changed the permissions to "Full Control" for everyone and I still got the error. Any help or additional suggestions would be much appreciated. The production machine is running NT 4, IIS 4. Shane Witbeck ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: permissions problem?
make sure the profile CF Server uses has not only write, but execute permissions, and check the tag execution resstriction settings in the CF Admin. Also, check your Web server's permissions make sure write and execute are allowed in the directory in question (if it's mapped in your web server), and it also doesn't hurt to allow execution permission in the directory holding or calling the custom tag. When I encounter errors like this, I remove all security, then tighten it step by step while testing the code after each permissions change. You might want to do a quick comparison of the test server that it does work on, against the production box what differences are there, if any? ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 9:50 AM To: CF-Talk Subject: permissions problem? I am attempting to use the AutoResize custom tag to upload pictures to a specified folder on a machine. Everything works correctly on my development machine but the production machine is throwing a what I think is a permissions error: Error processing CFFILE Error attempting to save uploaded file to path 'e:\webclients\domainfolderhere\yourphotos_new\users\59..' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (46:2) to (49:40) in the template file d:\CFUSION\CustomTags\AutoResize.cfm I have verified that write permissions exist on the folder where the pictures are to be uploaded and for the hell of it I changed the permissions to "Full Control" for everyone and I still got the error. Any help or additional suggestions would be much appreciated. The production machine is running NT 4, IIS 4. Shane Witbeck ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and iMode/cHTML
Does anyone know of technical sites in english which deal with development for iMode/cHTML? In particular, I'm looking for information regarding browser-detect and any other curve balls thrown by that environment. For anyone who is interested, I've got references to a few basic (technical crumbs, really) pages in english which deal with the topic. Just write me off-list and I'll zap them to you. Mike "A child of five could understand this... Fetch me a child of five!" -Groucho Marx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and iMode/cHTML
If you can get a copy of Adobe GoLive 5 or Dreamweaver 3, there are extensions for i-mode in them you can download for free with documentation. -Original Message- From: Doyle, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 7:18 AM To: CF-Talk Subject: CF and iMode/cHTML Does anyone know of technical sites in english which deal with development for iMode/cHTML? In particular, I'm looking for information regarding browser-detect and any other curve balls thrown by that environment. For anyone who is interested, I've got references to a few basic (technical crumbs, really) pages in english which deal with the topic. Just write me off-list and I'll zap them to you. Mike "A child of five could understand this... Fetch me a child of five!" -Groucho Marx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Java to cf
Rick: I would basically just look at what the java and cgi is doing (even though you don't know java you can figure it out) and just re-write what its trying to do using CF. Hope It Works Out, Greg Wolfinger Certified Uncertified ColdFusion Developer - Original Message - From: Rick Lamb <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Tuesday, November 21, 2000 8:18 PM Subject: Java to cf > I've been handed a site that was written in jhtml using Java, class, and cgi > for the backend stuff. The task I've been given is to convert this Java > based website into a cf site (we don't support java). Anybody have any > suggestions on how this could be done or if it is even feasible considering > I know nothing about Java? Just wondering if anyone has ever successfully or > unsuccessfully tried to do something like this and what there experience's > where. > > Thanks, > > Rick > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom output tag
This is what I do when I want to Query MSOLAP from ColdFusion. set quoted_identifier on SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media Type].[MEMBER_CAPTION]" AS R FROMOPENQUERY(OLAP_TEST, ' select {Measures.[Unit Sales]} on columns, order(except([Promotion Media].[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows from Sales ') as o set quoted_identifier off Unit Sales Media Type #OLAPTEST.C# #OLAPTEST.R# Hope this helps >From Rif PS Where it has OLAP_TEST, that is a link server from my SQL to my OLAP database -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 22 November 2000 14:57 To: CF-Talk Subject: Custom output tag Hello, I was able to query an olap cube through cf but didn't get a result. I was told me code should work, I just need to play with the output of the query to put it in a form that cf will understand. I used the querydump tag and it said returned a spaceany suggestions on how I can see the query results? Thanks, Eddie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CSV-to-Query
Greetings! I am struggling with the notion of trying to query a CSV. For some reason CFHTTP does not work for me. And I am also having trouble setting up a csv file as a datasource in CF Admin. (verify=failed) Do any of you know of a custom tag for this purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
no custom tag, but what's the problem mapping it as a datasource? What drivers are you using to try to connect to the spreadsheet? ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:49 AM To: CF-Talk Subject: CSV-to-Query Greetings! I am struggling with the notion of trying to query a CSV. For some reason CFHTTP does not work for me. And I am also having trouble setting up a csv file as a datasource in CF Admin. (verify=failed) Do any of you know of a custom tag for this purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MORE VERITY PROBLEMS
We're using Verity. I'm able to delete collections using CFCOLLECTION, and it does remove the files. Are you deleting using CFCOLLECTION or through the Administrator? If the former, check the Administrator and see if the collection still exists. Is it, by chance, a mapped collection? From the docs: Deleting a mapped collection unregisters the alias; the base collection is not deleted. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 11:48 PM To: CF-Talk Subject: MORE VERITY PROBLEMS Now I delete a collection but the files are still on the server so when I try and make a collection with the same name...yep you guessed it...NADA. Anyone out there using Verity a lot? In some ways it's very cool. In other ways...it's stinky. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MORE VERITY PROBLEMS
I'm deleting through the Admin. Files are on the server, collection does not exist in the admin. They're not mapped collections. What version of CF are you running? I'm on 4.01 Ent. -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 7:51 AM To: CF-Talk Subject: RE: MORE VERITY PROBLEMS We're using Verity. I'm able to delete collections using CFCOLLECTION, and it does remove the files. Are you deleting using CFCOLLECTION or through the Administrator? If the former, check the Administrator and see if the collection still exists. Is it, by chance, a mapped collection? From the docs: Deleting a mapped collection unregisters the alias; the base collection is not deleted. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 11:48 PM To: CF-Talk Subject: MORE VERITY PROBLEMS Now I delete a collection but the files are still on the server so when I try and make a collection with the same name...yep you guessed it...NADA. Anyone out there using Verity a lot? In some ways it's very cool. In other ways...it's stinky. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C0549C.EDA1C16A Content-Type: text/plain; charset="iso-8859-1" You could do something like this. HTH, Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 9:49 AM To: CF-Talk Subject: CSV-to-Query Greetings! I am struggling with the notion of trying to query a CSV. For some reason CFHTTP does not work for me. And I am also having trouble setting up a csv file as a datasource in CF Admin. (verify=failed) Do any of you know of a custom tag for this purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists --_=_NextPart_001_01C0549C.EDA1C16A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: CSV-to-Query You could do something like this.=20 = HTH, Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]">mailto:Rich@internet4asso= ciations.com] Sent: Wednesday, November 22, 2000 9:49 AM To: CF-Talk Subject: CSV-to-Query Greetings! I am struggling with the notion of trying to query a = CSV. For some reason CFHTTP does not work for me. And I am also having = trouble setting up a csv file as a datasource in CF Admin. = (verify=3Dfailed) Do any of you know of a custom tag for this = purpose? Thanks in advance, Richard ~~ Structure your ColdFusion code with Fusebox. Get the = official book at http://www.fusionauthority.com/bkinfo.cfm" = TARGET=3D"_blank">http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/= Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= --_=_NextPart_001_01C0549C.EDA1C16A-- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists = = = = = = = = = = ensure that you have created a .csv file = with the following fields.
= EmailTo,FirstName,LastName
= #cfcatch.message#">
RE: MORE VERITY PROBLEMS
Dylan, I Have had exactly this problem. It looks like a bug. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: 22 November 2000 15:54 To: CF-Talk Subject: RE: MORE VERITY PROBLEMS I'm deleting through the Admin. Files are on the server, collection does not exist in the admin. They're not mapped collections. What version of CF are you running? I'm on 4.01 Ent. -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 7:51 AM To: CF-Talk Subject: RE: MORE VERITY PROBLEMS We're using Verity. I'm able to delete collections using CFCOLLECTION, and it does remove the files. Are you deleting using CFCOLLECTION or through the Administrator? If the former, check the Administrator and see if the collection still exists. Is it, by chance, a mapped collection? From the docs: Deleting a mapped collection unregisters the alias; the base collection is not deleted. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 11:48 PM To: CF-Talk Subject: MORE VERITY PROBLEMS Now I delete a collection but the files are still on the server so when I try and make a collection with the same name...yep you guessed it...NADA. Anyone out there using Verity a lot? In some ways it's very cool. In other ways...it's stinky. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Apparently I do not have the necessary driver to map it as a datasource through cfadmin. "verification failed" every time. Also, how do I construct a query to a csv? I've never done, and I assume I can't ise standard sql! - Original Message - From: "Simon Horwith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 10:54 AM Subject: RE: CSV-to-Query > no custom tag, but what's the problem mapping it as a datasource? What > drivers are you using to try to connect to the spreadsheet? > > ~Simon > > > Simon Horwith > > Certified ColdFusion Developer > > Fig Leaf Software > > 1400 16th St NW, # 220 > > Washington DC 20036 > > 202.797.6570 (direct line) > > www.figleaf.com > > > > > -Original Message- > From: Richard Gilbert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 10:49 AM > To: CF-Talk > Subject: CSV-to-Query > > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Take a look at: http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP and http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:58 AM To: CF-Talk Subject: Re: CSV-to-Query Apparently I do not have the necessary driver to map it as a datasource through cfadmin. "verification failed" every time. Also, how do I construct a query to a csv? I've never done, and I assume I can't ise standard sql! - Original Message - From: "Simon Horwith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 10:54 AM Subject: RE: CSV-to-Query > no custom tag, but what's the problem mapping it as a datasource? What > drivers are you using to try to connect to the spreadsheet? > > ~Simon > > > Simon Horwith > > Certified ColdFusion Developer > > Fig Leaf Software > > 1400 16th St NW, # 220 > > Washington DC 20036 > > 202.797.6570 (direct line) > > www.figleaf.com > > > > > -Original Message- > From: Richard Gilbert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 10:49 AM > To: CF-Talk > Subject: CSV-to-Query > > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
form passes all fields, except one?
--CF871434F10C748D047F62D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass: Mother's ID number This is the query that I'm using INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '#form.Birthday_DueDate#') This is the error that I get Error resolving parameter FORM.PARENT_ID 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 evaluating the expression: #form.Parent_ID# The error occurred while processing an element with a general identifier of (#form.Parent_ID#), occupying document position (7:10) to (7:25). Any idea what I'm doing wrong? Thanks! Tammy -- personal copy designs better living through computer graphics http://www.personal-copy.com 410 219 5300 --CF871434F10C748D047F62D1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass:
RE: form passes all fields, except one?
I'd remove the spaces, and drop the single quotes from FORM.PARENT_ID unless it's a string ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Tammy Schilling [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 11:06 AM To: CF-Talk Subject: form passes all fields, except one? --CF871434F10C748D047F62D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass: Mother's ID number This is the query that I'm using INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '#form.Birthday_DueDate#') This is the error that I get Error resolving parameter FORM.PARENT_ID 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 evaluating the expression: #form.Parent_ID# The error occurred while processing an element with a general identifier of (#form.Parent_ID#), occupying document position (7:10) to (7:25). Any idea what I'm doing wrong? Thanks! Tammy -- personal copy designs better living through computer graphics http://www.personal-copy.com 410 219 5300 --CF871434F10C748D047F62D1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass:
RE: MORE VERITY PROBLEMS
I've encountered the same thing. Here's what I do when I need to delete and recreate a collection: 1. Delete the collection using either CF Administrator or . 2. Restart the CFAS. 3. Delete the files found under CFUSION/Verity/Collections/{collection name}. Note: it seems that the CFAS will not let you delete these files without the restart in step 2. 4. You may have to restart the CFAS again (I can't remember if I had to). 5. Recreate the collection (via Administrator or CFCOLLECTION). This seems to work, as long as you can afford to restart the CFAS. We usually do it late at night when it isn't likely that anyone is hitting the server. Bob -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: November 22, 2000 10:54 AM To: CF-Talk Subject: RE: MORE VERITY PROBLEMS I'm deleting through the Admin. Files are on the server, collection does not exist in the admin. They're not mapped collections. What version of CF are you running? I'm on 4.01 Ent. -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 7:51 AM To: CF-Talk Subject: RE: MORE VERITY PROBLEMS We're using Verity. I'm able to delete collections using CFCOLLECTION, and it does remove the files. Are you deleting using CFCOLLECTION or through the Administrator? If the former, check the Administrator and see if the collection still exists. Is it, by chance, a mapped collection? From the docs: Deleting a mapped collection unregisters the alias; the base collection is not deleted. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 11:48 PM To: CF-Talk Subject: MORE VERITY PROBLEMS Now I delete a collection but the files are still on the server so when I try and make a collection with the same name...yep you guessed it...NADA. Anyone out there using Verity a lot? In some ways it's very cool. In other ways...it's stinky. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: form passes all fields, except one?
Missing an equal sign in the name attribute. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Tammy Schilling [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 11:06 AM To: CF-Talk Subject: form passes all fields, except one? --CF871434F10C748D047F62D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass: Mother's ID number This is the query that I'm using INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '#form.Birthday_DueDate#') This is the error that I get Error resolving parameter FORM.PARENT_ID 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 evaluating the expression: #form.Parent_ID# The error occurred while processing an element with a general identifier of (#form.Parent_ID#), occupying document position (7:10) to (7:25). Any idea what I'm doing wrong? Thanks! Tammy -- personal copy designs better living through computer graphics http://www.personal-copy.com 410 219 5300 --CF871434F10C748D047F62D1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass:
RE: form passes all fields, except one?
need the = after name Mother's ID number Cheers, Gaston > -Mensaje original- > De: Tammy Schilling [SMTP:[EMAIL PROTECTED]] > Enviado el: Miércoles 22 de Noviembre de 2000 13:06 > Para: CF-Talk > Asunto: form passes all fields, except one? > > > --CF871434F10C748D047F62D1 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hi all, I'm struggling with a form and query problem. There are four form > fields to be inserted into a table. All > seem to pass just fine, except one. I can't figure out why. I've checked > how I've spelled it in both templates > and the database, even to the point of retyping it to be sure. > > This is the form field that won't seem to pass: > > > > Mother's ID number > > This is the query that I'm using > > INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) > VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', > '#form.Birthday_DueDate#') > > > This is the error that I get > Error resolving parameter FORM.PARENT_ID > > 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 evaluating the expression: > > #form.Parent_ID# > > The error occurred while processing an element with a general identifier > of > (#form.Parent_ID#), occupying document position (7:10) to (7:25). > > > Any idea what I'm doing wrong? > > Thanks! > > Tammy > -- > personal copy designs > better living through computer graphics > http://www.personal-copy.com > 410 219 5300 > > > --CF871434F10C748D047F62D1 > Content-Type: text/html; charset=us-ascii > Content-Transfer-Encoding: 7bit > > > > Hi all, I'm struggling with a form and query problem. There are four > form fields to be inserted into a table. All seem to pass just fine, > except one. I can't figure out why. I've checked how I've > spelled > it in both templates and the database, even to the point of retyping it > to be sure. > This is the form field that won't seem to pass: >
RE: form passes all fields, except one?
If you copied and pasted that text from your cfm file, I can see the problem: You have no "=" sign between Name and "Parent_ID". It should say Name="Parent_ID". Bob -Original Message- From: Tammy Schilling [mailto:[EMAIL PROTECTED]] Sent: November 22, 2000 11:06 AM To: CF-Talk Subject: form passes all fields, except one? --CF871434F10C748D047F62D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass: Mother's ID number This is the query that I'm using INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '#form.Birthday_DueDate#') This is the error that I get Error resolving parameter FORM.PARENT_ID 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 evaluating the expression: #form.Parent_ID# The error occurred while processing an element with a general identifier of (#form.Parent_ID#), occupying document position (7:10) to (7:25). Any idea what I'm doing wrong? Thanks! Tammy -- personal copy designs better living through computer graphics http://www.personal-copy.com 410 219 5300 --CF871434F10C748D047F62D1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass:
RE: MORE VERITY PROBLEMS
Snap Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: 22 November 2000 16:12 To: CF-Talk Subject: RE: MORE VERITY PROBLEMS I've encountered the same thing. Here's what I do when I need to delete and recreate a collection: 1. Delete the collection using either CF Administrator or . 2. Restart the CFAS. 3. Delete the files found under CFUSION/Verity/Collections/{collection name}. Note: it seems that the CFAS will not let you delete these files without the restart in step 2. 4. You may have to restart the CFAS again (I can't remember if I had to). 5. Recreate the collection (via Administrator or CFCOLLECTION). This seems to work, as long as you can afford to restart the CFAS. We usually do it late at night when it isn't likely that anyone is hitting the server. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: form passes all fields, except one?
If Parent_ID is a number, remove the single quote marks around #form.Parent_ID# in your query and try that. Chris Montgomery [EMAIL PROTECTED] Web Development & Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 >-Original Message- >This is the query that I'm using > >INSERT INTO Children (Parent_ID , FirstName, LastName, >Birthday_DueDate) >VALUES ('#form.Parent_ID#' , '#form.FirstName#', >'#form.LastName#', '#form.Birthday_DueDate#') > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
lost replies needed: XMLHTTP vs CFHTTP POST - how do you get stuff in the message body of the header?
Hi. Sorry for the repost, but I posted this message yesterday but did not receive a digest so I don't know if there were any answers. I'm kind of in a bind, if there was an answer to this yesterday and you still have it, could you forward it to me? Of course, new replies are always welcome. Thanks. - Mary --- message posted 11/21: Hi. How do I do this in CFHTTP - specifically, line 21 - where do you put the message body? - Mary (I receive this list as a digest.) 10 11 " (etc...rest of my xml request here)> 12 13 14 18 19 20 21 22 P.S. I've been using XMLHTTP from MSXML as a COM object from within ColdFusion with success but it gives and Unspecified error message since we've upgraded to CF 4.5.1. Allaire has been no help so that's why I thought I'd try replacing the XMLHTTP call with a CFHTTP call. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Broadvision [Fraudvision]
Neil: Buy a good seatbelt and install it on your office chair. You are going to need it. It's going to be a wild ride. I didn't know you could integrate CF with Broadvision, or I probably would have stuck with it. I found Broadvision's basic theories solid, but their product is still very buggy. We found conflicting documentation, undocumented bugs, and more. It's been over a year since I have touched any of it, so maybe it is better now. Good luck. Nick Call [EMAIL PROTECTED] - Original Message - From: "Neil Clark" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 4:27 AM Subject: Broadvision [Fraudvision] > Anyone had any experience with Broadvision and (or without) CF? I am just > about to embark on a project that will be tightly intergrated with it and as > Project Lead I would like to know what everyone thinks - any experiences? > > I know the general consensus about BV - but that could be just one opinion!? > > Anyone? > > Neil > > Neil Clark > Senior Web Applications Engineer > mcb digital > Tel. +44 (0)20 8941 3232 > Tel. +44 (0)20 8408 8131 [Direct] > http://www.mcbdigital.com > ---> > > > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: XMLHTTP vs CFHTTP POST - how do you get stuff in the message body of the header?
> How do I do this in CFHTTP - specifically, line 21 - where do > you put the message body? ... > 21 Unfortunately, you can't manipulate the raw request body with CFHTTP; you can only send form data in that message body. You'll need to use a third-party component to do this. > P.S. I've been using XMLHTTP from MSXML as a COM object from within > ColdFusion with success but it gives and Unspecified error message > since we've upgraded to CF 4.5.1. You should be able to diagnose the problem you're having with XMLHTTP, or at least find a workaround. If worst comes to worst, you could write a Windows Script Host wrapper for XMLHTTP, and call the wrapper from CF. Also, in your code sample, I didn't see any property or method setting the target server for the HTTP request. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dave: Kooky Form Field/List question.
> The solution looping over list is working, but I'm not > getting what you're saying about looping over the structure. > I cant seem to access the form as a structure. I'm on > CFServer 4.0. Could that be the problem? Special feature of > 4.5? I think that the Form scope is available as a structure in CF 4.0.1 and higher. I'm not entirely sure about this, as the versions of CF are beginning to run together in my head a bit. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MORE VERITY PROBLEMS
We're using 4.5.1 SP1, Professional. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 9:54 AM To: CF-Talk Subject: RE: MORE VERITY PROBLEMS I'm deleting through the Admin. Files are on the server, collection does not exist in the admin. They're not mapped collections. What version of CF are you running? I'm on 4.01 Ent. -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 7:51 AM To: CF-Talk Subject: RE: MORE VERITY PROBLEMS We're using Verity. I'm able to delete collections using CFCOLLECTION, and it does remove the files. Are you deleting using CFCOLLECTION or through the Administrator? If the former, check the Administrator and see if the collection still exists. Is it, by chance, a mapped collection? From the docs: Deleting a mapped collection unregisters the alias; the base collection is not deleted. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 11:48 PM To: CF-Talk Subject: MORE VERITY PROBLEMS Now I delete a collection but the files are still on the server so when I try and make a collection with the same name...yep you guessed it...NADA. Anyone out there using Verity a lot? In some ways it's very cool. In other ways...it's stinky. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: form passes all fields, except one?
should be Left out the equal sign :) Scott Wolf Goodfriend Computer Training -Original Message- From: Tammy Schilling [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 11:06 AM To: CF-Talk Subject: form passes all fields, except one? --CF871434F10C748D047F62D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass: Mother's ID number This is the query that I'm using INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '#form.Birthday_DueDate#') This is the error that I get Error resolving parameter FORM.PARENT_ID 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 evaluating the expression: #form.Parent_ID# The error occurred while processing an element with a general identifier of (#form.Parent_ID#), occupying document position (7:10) to (7:25). Any idea what I'm doing wrong? Thanks! Tammy -- personal copy designs better living through computer graphics http://www.personal-copy.com 410 219 5300 --CF871434F10C748D047F62D1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass:
RIF Please read concerning Cube
Rif, I tried your code and seem to be able to get to the linked server but I now get an error or incorrect syntax near cube. ** Error Diagnostic Information OLEDB Error Code = 170 Line 3: Incorrect syntax near 'Cube'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:48). * Here is the mdx statement I want to execute: SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [The Cube] '* Here is the code generating the error set quoted_identifier on SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media Type].[MEMBER_CAPTION]" AS R FROMOPENQUERY(My Cube, 'select {Measures.[Unit Sales]} on columns, order(except([Promotion Media].[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows from Sales) ') as o set quoted_identifier off Untitled Unit Sales Media Type #OLAPTEST.C# #OLAPTEST.R# Thanks, Eddie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Anyone have a CF version of CSV-to-Table using SQL7's ability to import a text file? best, paul At 11:07 AM 11/22/00 -0500, you wrote: >Take a look at: >http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP >and >http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP > >~Simon > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS Index Server vs. Verity
Hi, I had to demo how cold fusion works to my I.S. department last week and after showing them how 'verity' works they suggested I look into 'Index Server' as a 'better' alternative. Can I get some of your opinions as to the differences between the two and where I can get more info on 'Index Server' Thanks Sal _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: form passes all fields, except one?
Hi Tammy, Mother's ID number If this is exact the code you used , then you forgot the "=" sign between "Name" and " the Parent_ID" in the tag. Sima Tammy SchillingTo: CF-Talk <[EMAIL PROTECTED]> <[EMAIL PROTECTED]cc: om> Subject: form passes all fields, except one? 11/22/00 10:05 AM Please respond to cf-talk --CF871434F10C748D047F62D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass: Mother's ID number This is the query that I'm using INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', ' #form.Birthday_DueDate#') This is the error that I get Error resolving parameter FORM.PARENT_ID 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 evaluating the expression: #form.Parent_ID# The error occurred while processing an element with a general identifier of (#form.Parent_ID#), occupying document position (7:10) to (7:25). Any idea what I'm doing wrong? Thanks! Tammy -- personal copy designs better living through computer graphics http://www.personal-copy.com 410 219 5300 --CF871434F10C748D047F62D1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass:
RE: MS Index Server vs. Verity
I don't know a lot about index server, but I hazard to guess it's probably going to run faster than verity. I'm sure Mr. Dave Watts will have more to say on the matter. ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 11:46 AM To: CF-Talk Subject: MS Index Server vs. Verity Hi, I had to demo how cold fusion works to my I.S. department last week and after showing them how 'verity' works they suggested I look into 'Index Server' as a 'better' alternative. Can I get some of your opinions as to the differences between the two and where I can get more info on 'Index Server' Thanks Sal _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: TURKEY VS CFHTTP - [in mime format]
I am having the same exact problem. Does anyone have any ideas? John Rice wrote: > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > --_=_NextPart_001_01C053C3.BD22DF62 > Content-Type: text/plain; > charset="iso-8859-1" > > Its a bad time to feel like a turkey so I need some advice in hurry. Anyone > know why this returns "Connection Failure" in CFHTTP.fileContent? > > url="http://www.docboard.org/cgi-shl/nhayer.exe" > resolveurl="Yes" > timeout="30" > method="post" > useragent="Mozilla/4.0 (compatible; MSIE 5.5; Windows Turkey;)" > > > > > > > > > > > The form just as this works fine: > > http://www.docboard.org/cgi-shl/nhayer.exe"> > > > > > > > > > > > What do I need to do? > > Thanks Much > > -Rice > > --_=_NextPart_001_01C053C3.BD22DF62 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > > charset=3Diso-8859-1"> > 5.5.2650.12"> > TURKEY VS CFHTTP - [in mime format] > > > > > Its a bad time to feel like a turkey so I need some = > advice in hurry. Anyone know why this returns "Connection = > Failure" in CFHTTP.fileContent? > > >> > > > What do I need to do? > > > > > Thanks Much > > > -Rice > > > > > --_=_NextPart_001_01C053C3.BD22DF62-- > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=listsSIZE=3D2>url=3D" HREF=3D"http://www.docboard.org/cgi-shl/nhayer.exe" = > TARGET=3D"_blank">http://www.docboard.org/cgi-shl/nhayer.exe" FONT> > SIZE=3D2>resolveurl=3D"Yes" > SIZE=3D2>timeout=3D"30" > SIZE=3D2>method=3D"post" > SIZE=3D2>useragent=3D"Mozilla/4.0 (compatible; MSIE 5.5; Windows = > Turkey;)" > SIZE=3D2>> > > > SIZE=3D2> > > > > The form just as this works fine: > > > >type=3D"FORMFIELD"> > SIZE=3D2> type=3D"FORMFIELD"> > SIZE=3D2> type=3D"FORMFIELD"> > SIZE=3D2> type=3D"FORMFIELD"> > > >
Re: Displaying files in a directory
At 04:35 PM 11/21/00 -0500, you wrote: >I need to display the files in a directory to a web page. This way people >can see the files they can download, and click on them to download. > >Is there a good CF tag that can do this? Im starting to lean towards a list >of the files placed in a database... but making sure the database is up to >date would require a lot of programming. > >CFFTP? >CFCONTENT? action=list is optional, since that is the default. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Index Server vs. Verity
Index server is a security nightmare, never, ever install this dung. Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED] -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: 22 November 2000 17:06 To: CF-Talk Subject: RE: MS Index Server vs. Verity I don't know a lot about index server, but I hazard to guess it's probably going to run faster than verity. I'm sure Mr. Dave Watts will have more to say on the matter. ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 11:46 AM To: CF-Talk Subject: MS Index Server vs. Verity Hi, I had to demo how cold fusion works to my I.S. department last week and after showing them how 'verity' works they suggested I look into 'Index Server' as a 'better' alternative. Can I get some of your opinions as to the differences between the two and where I can get more info on 'Index Server' Thanks Sal _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: permissions problem?
Well...after all of that...the problem was a missing trailing \ in my path statement!!! Someone kick me in the head now. Shane Witbeck -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:07 AM To: CF-Talk Subject: RE: permissions problem? make sure the profile CF Server uses has not only write, but execute permissions, and check the tag execution resstriction settings in the CF Admin. Also, check your Web server's permissions make sure write and execute are allowed in the directory in question (if it's mapped in your web server), and it also doesn't hurt to allow execution permission in the directory holding or calling the custom tag. When I encounter errors like this, I remove all security, then tighten it step by step while testing the code after each permissions change. You might want to do a quick comparison of the test server that it does work on, against the production box what differences are there, if any? ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 9:50 AM To: CF-Talk Subject: permissions problem? I am attempting to use the AutoResize custom tag to upload pictures to a specified folder on a machine. Everything works correctly on my development machine but the production machine is throwing a what I think is a permissions error: Error processing CFFILE Error attempting to save uploaded file to path 'e:\webclients\domainfolderhere\yourphotos_new\users\59..' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (46:2) to (49:40) in the template file d:\CFUSION\CustomTags\AutoResize.cfm I have verified that write permissions exist on the folder where the pictures are to be uploaded and for the hell of it I changed the permissions to "Full Control" for everyone and I still got the error. Any help or additional suggestions would be much appreciated. The production machine is running NT 4, IIS 4. Shane Witbeck ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cferror.....
> http://www.fusionauthority.com/alert/index.cfm?alertid=34#tech1 > The explanation of CFERROR type = Monitor will give you a LOT > of food for thought. Actually, I found the part about the Error scope being a structure interesting - I wasn't aware of that. I don't know if I'll ever use it, but thanks! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Paul: Now you're talking. Can you describe this process to me? I am using SQL7, but have never taken advantage of this feature. Richard - Original Message - From: "paul smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 11:39 AM Subject: RE: CSV-to-Query > Anyone have a CF version of CSV-to-Table using SQL7's ability > to import a text file? > > best, paul > > > At 11:07 AM 11/22/00 -0500, you wrote: > >Take a look at: > >http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP > >and > >http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP > > > >~Simon > > > > > > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Printing mailing labels in a browser -- Joy... :-O
I had the same challenge recently. Printing 4 up labels was not really too bad as long as the label was NOT completely filled edge to edge, you need a little buffer area. Anything more than 4 up was tough. We ended up scrapping the idea for another non-label method which worked well. If I had to do it again I would definitely look into pdf. -Adrian Subject: RE: Printing mailing labels in a browser -- Joy... :-O ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MORE VERITY PROBLEMS
can you make collections of Word 2000 files? - Original Message - From: "Hayes, David" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 8:27 AM Subject: RE: MORE VERITY PROBLEMS > We're using 4.5.1 SP1, Professional. > > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 9:54 AM > To: CF-Talk > Subject: RE: MORE VERITY PROBLEMS > > > I'm deleting through the Admin. Files are on the server, collection does not > exist in the admin. > > They're not mapped collections. > > What version of CF are you running? I'm on 4.01 Ent. > > -Original Message- > From: Hayes, David [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 7:51 AM > To: CF-Talk > Subject: RE: MORE VERITY PROBLEMS > > > We're using Verity. I'm able to delete collections using CFCOLLECTION, and > it does remove the files. > > Are you deleting using CFCOLLECTION or through the Administrator? If the > former, check the Administrator and see if the collection still exists. > > Is it, by chance, a mapped collection? From the docs: > > Deleting a mapped collection unregisters the alias; the base collection is > not deleted. > > > > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 21, 2000 11:48 PM > To: CF-Talk > Subject: MORE VERITY PROBLEMS > > > Now I delete a collection but the files are still on the server so when I > try and make a collection with the same name...yep you guessed it...NADA. > > Anyone out there using Verity a lot? > > In some ways it's very cool. In other ways...it's stinky. > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Dynamic HTML help
Hello all. I want to create a page that loads completely, but then dynamically updates the html updates based on a series of whois queries. I don't think there is a way to make CF stream this data... What I have is a local database of zone files for the .com domain names. This database can be queried, and will immediately show if a domain name is taken. However, if a domain name is not in the local zone file, it may or may not be available for registration (the zone file does not show domains on "hold" status, nor domains without name servers) ... So, I need to do a whois query on these possibly available domain names to determine true availability. However, I don't want the end user to have to wait for this entire process to complete before showing the html result page. For example, let's say the query contains 20 domain names, I perform a local query and determine that 5 of them are possibly available. But since whois queries can take several seconds I want to go ahead and display to the end user an html page with the list of possible domains, but have this page dynamically update as the results of the whois queries completes. I believe this is possible with javascript and data streams, but I just don't have the skills to do this, and have not been able to find good samples or resources online. If anyone has any good web site references or books that would help me accomplish this, OR if anyone has the skills to do this -- I would pay for the job. (please contact me off-list) Thanks, Kelly Britt "Need A Dot Com?" [EMAIL PROTECTED] http://www.needa.com 770-663-1535 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
This tag works great and may suit your needs. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347395-2830-11D4-AA 9700508B94F380&method=Full > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL/Stored Proc Generator
Here is a link to a utility that will. Generate SQL Inserts, Updates, Deletes, Selects Generate Stored Procs (if database selected is sql server) Generate forms based on database tables -Javascript is written for dates, not nulls, numeric fields. -Maxlengths on input fields are calculated from the database table. http://aloha-webdesign.com/sqlgen/ Take a look John Anderson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MORE VERITY PROBLEMS
I just did a quick test. The collection was created and was searchable, although the folder I indexed only had 11 WORD 2000 docs in it. (I just grabbed some from my machine.) Creating and deleting from the Administrator worked; files were deleted as expected. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 11:27 AM To: CF-Talk Subject: Re: MORE VERITY PROBLEMS can you make collections of Word 2000 files? - Original Message - From: "Hayes, David" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 8:27 AM Subject: RE: MORE VERITY PROBLEMS > We're using 4.5.1 SP1, Professional. > > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 9:54 AM > To: CF-Talk > Subject: RE: MORE VERITY PROBLEMS > > > I'm deleting through the Admin. Files are on the server, collection does not > exist in the admin. > > They're not mapped collections. > > What version of CF are you running? I'm on 4.01 Ent. > > -Original Message- > From: Hayes, David [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 22, 2000 7:51 AM > To: CF-Talk > Subject: RE: MORE VERITY PROBLEMS > > > We're using Verity. I'm able to delete collections using CFCOLLECTION, and > it does remove the files. > > Are you deleting using CFCOLLECTION or through the Administrator? If the > former, check the Administrator and see if the collection still exists. > > Is it, by chance, a mapped collection? From the docs: > > Deleting a mapped collection unregisters the alias; the base collection is > not deleted. > > > > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 21, 2000 11:48 PM > To: CF-Talk > Subject: MORE VERITY PROBLEMS > > > Now I delete a collection but the files are still on the server so when I > try and make a collection with the same name...yep you guessed it...NADA. > > Anyone out there using Verity a lot? > > In some ways it's very cool. In other ways...it's stinky. > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at > http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic HTML help
you could put code that does the whois search and then loads it into a wddx packet, into a page that refreshes intself and lives in a hidden frame, and display the recordsets in javascript accesible containers of some sort, then use javascript to change the values of those objects being displayed. Hope that helps. ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Kelly Britt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 12:42 PM To: CF-Talk Subject: OT: Dynamic HTML help Hello all. I want to create a page that loads completely, but then dynamically updates the html updates based on a series of whois queries. I don't think there is a way to make CF stream this data... What I have is a local database of zone files for the .com domain names. This database can be queried, and will immediately show if a domain name is taken. However, if a domain name is not in the local zone file, it may or may not be available for registration (the zone file does not show domains on "hold" status, nor domains without name servers) ... So, I need to do a whois query on these possibly available domain names to determine true availability. However, I don't want the end user to have to wait for this entire process to complete before showing the html result page. For example, let's say the query contains 20 domain names, I perform a local query and determine that 5 of them are possibly available. But since whois queries can take several seconds I want to go ahead and display to the end user an html page with the list of possible domains, but have this page dynamically update as the results of the whois queries completes. I believe this is possible with javascript and data streams, but I just don't have the skills to do this, and have not been able to find good samples or resources online. If anyone has any good web site references or books that would help me accomplish this, OR if anyone has the skills to do this -- I would pay for the job. (please contact me off-list) Thanks, Kelly Britt "Need A Dot Com?" [EMAIL PROTECTED] http://www.needa.com 770-663-1535 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MS Index Server vs. Verity
Index Server is included in SQL Server 7. For my application, I like SQL7 full-text indexing and searching on database fields better than Verity, having directly compared their performance in the same application. I don't use stemming though (and, like Google, don't want to). For my application, SQL full-text is decidedly faster. As always, YMMV. best, paul At 08:45 AM 11/22/00 -0800, you wrote: >I had to demo how cold fusion works to my I.S. department last week and >after showing them how 'verity' works they suggested I look into 'Index >Server' as a 'better' alternative. Can I get some of your opinions as to the >differences between the two and where I can get more info on 'Index Server' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Index Server vs. Verity
I agree... using SQL 'CONTAINS' on full-text indexed database fields has always been a much better search method for doing database searches, in my experience. ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 12:57 PM To: CF-Talk Cc: [EMAIL PROTECTED] Subject: Re: MS Index Server vs. Verity Index Server is included in SQL Server 7. For my application, I like SQL7 full-text indexing and searching on database fields better than Verity, having directly compared their performance in the same application. I don't use stemming though (and, like Google, don't want to). For my application, SQL full-text is decidedly faster. As always, YMMV. best, paul At 08:45 AM 11/22/00 -0800, you wrote: >I had to demo how cold fusion works to my I.S. department last week and >after showing them how 'verity' works they suggested I look into 'Index >Server' as a 'better' alternative. Can I get some of your opinions as to the >differences between the two and where I can get more info on 'Index Server' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Allaire newsgroups
Does Allaire sponsor a news server or are there any usnet groups that are about Cold Fusion? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts
RE: Displaying files in a directory
I too am entering stage left on this type of endeavor and am looking at AppletFile at www.infomentum.com (both upload and download between web-server and local drives. AppletFile works with both ASP and CFM pages. With AppletFile, you can even have progress bars displayed during the file transmission process which is good since some of the files could be quite large. Further, as I understand, files to be transmitted can be compressed before sending and then uncompressed at the other end (a saving of about 50 pct or so in the number of bytes that have to be transmitted). Arden Weiss 410-757-3487 -Original Message- From: Jennifer [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 7:14 PM To: CF-Talk Subject:Re: Displaying files in a directory At 04:35 PM 11/21/00 -0500, you wrote: >I need to display the files in a directory to a web page. This way people >can see the files they can download, and click on them to download. > >Is there a good CF tag that can do this? Im starting to lean towards a list >of the files placed in a database... but making sure the database is up to >date would require a lot of programming. > >CFFTP? >CFCONTENT? action=list is optional, since that is the default. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Well, if you go to EM and select a database, you'll see "import data" as an option in the right pane. Click on that, then click on "Next" and then select "Text file" from the drop down for "Source" This is how you can do it while sitting at a SQL7 box. My question is has anyone developed the script to do it in a CF template. best, paul At 12:22 PM 11/22/00 -0500, you wrote: >Paul: > >Now you're talking. >Can you describe this process to me? >I am using SQL7, but have never taken advantage of this feature. > >Richard > >- Original Message - >From: "paul smith" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, November 22, 2000 11:39 AM >Subject: RE: CSV-to-Query > > > > Anyone have a CF version of CSV-to-Table using SQL7's ability > > to import a text file? > > > > best, paul > > > > > > At 11:07 AM 11/22/00 -0500, you wrote: > > >Take a look at: > > >http://support.microsoft.com/support/kb/articles/Q190/1/95.ASP > > >and > > >http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP > > > > > >~Simon > > > > > > > > > > > ~~ > > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Does this tag use CFFILE? best, paul At 09:44 AM 11/22/00 -0800, you wrote: >This tag works great and may suit your needs. > >http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347395-2830-11D4-AA >9700508B94F380&method=Full > > > > > > Greetings! > > > > I am struggling with the notion of trying to query a CSV. For some reason > > CFHTTP does not work for me. And I am also having trouble setting up a csv > > file as a datasource in CF Admin. (verify=failed) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Allaire newsgroups
There's a mirror of the CF-Talk list at fuseware.com. I'm finishing up a Lyris news server for ALL the lists as we speak. Does Allaire sponsor a news server or are there any usnet groups that are about Cold Fusion? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Index Server vs. Verity
Now that you've stepped up to bat, is there an alternative to the OR in the following? It seems to me that 1 CONTAINS ought to be able to search more than one column, but I haven't figured out how. best, paul SELECT ID FROM orgs (nolock) WHERE City = '#REQUEST.GetClientDataCity.City#' AND ( CONTAINS(org_name,' #VARIABLES_SEARCHTERM# ') OR CONTAINS(classified,' #VARIABLES_SEARCHTERM# ') ) WHERE CONTAINS(org_name,' #VARIABLES_SEARCHTERM# ') OR CONTAINS(classified,' #VARIABLES_SEARCHTERM# ') At 01:08 PM 11/22/00 -0500, you wrote: >I agree... using SQL 'CONTAINS' on full-text indexed database fields has >always been a much better search method for doing database searches, in my >experience. > >~Simon > > > Simon Horwith > > Certified ColdFusion Developer > > Fig Leaf Software > > 1400 16th St NW, # 220 > > Washington DC 20036 > > 202.797.6570 (direct line) > > www.figleaf.com > > > > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, November 22, 2000 12:57 PM >To: CF-Talk >Cc: [EMAIL PROTECTED] >Subject: Re: MS Index Server vs. Verity > > >Index Server is included in SQL Server 7. > >For my application, I like SQL7 full-text indexing and searching on >database fields better than Verity, having directly compared their >performance in the same application. I don't use stemming though (and, >like Google, don't want to). For my application, SQL full-text is >decidedly faster. As always, YMMV. > >best, paul > >At 08:45 AM 11/22/00 -0800, you wrote: > >I had to demo how cold fusion works to my I.S. department last week and > >after showing them how 'verity' works they suggested I look into 'Index > >Server' as a 'better' alternative. Can I get some of your opinions as to >the > >differences between the two and where I can get more info on 'Index Server' > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RIF Please read concerning Cube
Looks like you're trying to query a table called "The Cube". In most RDBMS's, this is not a valid table name. Change it to something like TheCube or The_Cube. -- Billy Cravens [EMAIL PROTECTED] Edward Peloke wrote: > > Rif, > > I tried your code and seem to be able to get to the linked server but I now > get an error or incorrect syntax near cube. > > ** > Error Diagnostic Information > OLEDB Error Code = 170 > > Line 3: Incorrect syntax near 'Cube'. > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (2:1) to (2:48). > * > > Here is the mdx statement I want to execute: > SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [The Cube] > > '* Here is the code generating the error > > > set quoted_identifier on > SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media > Type].[MEMBER_CAPTION]" AS R > FROMOPENQUERY(My Cube, > 'select > {Measures.[Unit Sales]} on columns, > order(except([Promotion Media].[Media Type].members,{[Promotion > Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows > from Sales) > ') > > as o > set quoted_identifier off > > > > Untitled > > > > > > Unit Sales > Media Type > > > > #OLAPTEST.C# > #OLAPTEST.R# > > > > > > > > Thanks, > Eddie > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Dynamic HTML help
Look at cfx_WhoIs. Allows you to communicate with whois servers (like Network Solution) on the TCP/IP level. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34726B-2830-11D4-AA9700508B94F380&method=Full -- Billy Cravens [EMAIL PROTECTED] Kelly Britt wrote: > > Hello all. > > I want to create a page that loads completely, but then dynamically updates > the html updates based on a series of whois queries. I don't think there is > a way to make CF stream this data... > > What I have is a local database of zone files for the .com domain names. > This database can be queried, and will immediately show if a domain name is > taken. However, if a domain name is not in the local zone file, it may or > may not be available for registration (the zone file does not show domains > on "hold" status, nor domains without name servers) ... So, I need to do a > whois query on these possibly available domain names to determine true > availability. However, I don't want the end user to have to wait for this > entire process to complete before showing the html result page. > > For example, let's say the query contains 20 domain names, I perform a local > query and determine that 5 of them are possibly available. But since whois > queries can take several seconds I want to go ahead and display to the end > user an html page with the list of possible domains, but have this page > dynamically update as the results of the whois queries completes. > > I believe this is possible with javascript and data streams, but I just > don't have the skills to do this, and have not been able to find good > samples or resources online. If anyone has any good web site references or > books that would help me accomplish this, OR if anyone has the skills to do > this -- I would pay for the job. (please contact me off-list) > > Thanks, > Kelly Britt > > "Need A Dot Com?" > > [EMAIL PROTECTED] http://www.needa.com 770-663-1535 > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Not that I am aware of. It is a CFX. -Adrian -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 10:12 AM To: CF-Talk Cc: [EMAIL PROTECTED] Subject: RE: CSV-to-Query Does this tag use CFFILE? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Index Server vs. Verity
I effectively use a form term, too, except I modify the term submitted in the form to: (1) Remove noise words (since SQL7 doesn't do it as advertised) (2) Automate proximity matching, and (3) enable wildcard searches: best, paul == SELECT N_Word FROM NoiseWords WHERE N_Word = '#III#' === best, paul At 01:47 PM 11/22/00 -0500, you wrote: >You will have to use OR to do multiple 'CONTAINS' searches (to the best of >my knowledge). I usually use it with syntax like: WHERE db_fieldname >CONTAINS ('form.searchparam'), myself. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Trying to understand deployment wizard
This isn't work and I don't understand the error message. Any help would be appreciated: Using the deployment wizard, I created the following script // === // Project Name: BreakingFolder // Date/Time Generated:11/22/2000 11:10 // // === // Server List: // // ftp://wwwMySite // === function Main() { var app = Application; app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a pf"); // === // Set Deployment Flags... // === app.DeploymentManager.CreateFolder = true; app.DeploymentManager.UploadOnlyIfNewer = true; app.DeploymentManager.EncryptCFML = false; app.DeploymentManager.ForceLowerCase = false; // === // Server ftp://wwwMySite Deployment // === // >>> Folder: BreakingFolder\breaking app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml"," ftp://www.mysite.com:21/www/breaking/breaking.shtml"); app.DeploymentManager.CloseProject(); } The error is: "No Deployment Folder Path for folder: breaking" and "No Deployment Folder Path for folder: images" = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSV-to-Query
Richard, Go to http://www.nateweiss.com/taggallery/ and look at CFX_CSVToQuery - it will put a CSV file into a CF Query. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Richard Gilbert wrote: > > Greetings! > > I am struggling with the notion of trying to query a CSV. For some reason > CFHTTP does not work for me. And I am also having trouble setting up a csv > file as a datasource in CF Admin. (verify=failed) > > Do any of you know of a custom tag for this purpose? > > Thanks in advance, > Richard > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Use End of Line Char as Delimiter?
Is it possible to use the end of line character as a delimiter in a list (I beleive it is Ascii-20)? The I could read an entire text file into The reason I ask is that I need to read a text file line by line, and it would be much easier if I could get a line count as I am going. jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf-studio mailing list? (was Re: Trying to understand deployment wizard)
M. Dinowitz: On that note, is there any demand for a ColdFusion Studio mailing list? Studio is so extendible (VTML, scripting, etc.), has a scope that extends far beyond CFML, and we pretty much all use it on a daily basis, so I think the community would benefit greatly from such a resource. However, if anyone knows of any existing mailing lists for Studio/HomeSite, please let us know! -- Billy Cravens [EMAIL PROTECTED] "Owens, Howard" wrote: > > This isn't work and I don't understand the error message. Any help would be > appreciated: > > Using the deployment wizard, I created the following script > > // === > // Project Name: BreakingFolder > // Date/Time Generated:11/22/2000 11:10 > // > // === > // Server List: > // > // ftp://wwwMySite > // === > > function Main() > { > var app = Application; > > > app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a > pf"); >// === >// Set Deployment Flags... >// === >app.DeploymentManager.CreateFolder = true; >app.DeploymentManager.UploadOnlyIfNewer = true; >app.DeploymentManager.EncryptCFML = false; >app.DeploymentManager.ForceLowerCase = false; >// === >// Server ftp://wwwMySite Deployment >// === >// >>> Folder: BreakingFolder\breaking > > app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml"," > ftp://www.mysite.com:21/www/breaking/breaking.shtml"); > > >app.DeploymentManager.CloseProject(); > > } > > The error is: > > "No Deployment Folder Path for folder: breaking" > and > "No Deployment Folder Path for folder: images" > > = > Howard Owens > Web Producer > InsideVC.com > mailto:[EMAIL PROTECTED] > = > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSV-to-Query
Cool...I always used http://www.icesinc.com/nate/taggallery/ and it disappeared recently. I thought Nate abandoned the CF world. His tags and support to the community have been great, although I have not heard much from Nate in recent days, perhaps he is on the Unix-CF based lists now... -Adrian -Original Message- From: Larry C. Lyons [mailto:[EMAIL PROTECTED]] Go to http://www.nateweiss.com/taggallery/ and look at CFX_CSVToQuery - it will put a CSV file into a CF Query. regards, larry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf-studio mailing list? (was Re: Trying to understand deployment wizard)
I for one, would love to see this group come into existence. jon - Original Message - From: "Billy Cravens" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 2:39 PM Subject: cf-studio mailing list? (was Re: Trying to understand deployment wizard) > M. Dinowitz: > On that note, is there any demand for a ColdFusion Studio mailing list? > Studio is so extendible (VTML, scripting, etc.), has a scope that > extends far beyond CFML, and we pretty much all use it on a daily basis, > so I think the community would benefit greatly from such a resource. > However, if anyone knows of any existing mailing lists for > Studio/HomeSite, please let us know! > > -- > Billy Cravens > [EMAIL PROTECTED] > > > "Owens, Howard" wrote: > > > > This isn't work and I don't understand the error message. Any help would be > > appreciated: > > > > Using the deployment wizard, I created the following script > > > > // === > > // Project Name: BreakingFolder > > // Date/Time Generated:11/22/2000 11:10 > > // > > // === > > // Server List: > > // > > // ftp://wwwMySite > > // === > > > > function Main() > > { > > var app = Application; > > > > > > app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a > > pf"); > >// === > >// Set Deployment Flags... > >// === > >app.DeploymentManager.CreateFolder = true; > >app.DeploymentManager.UploadOnlyIfNewer = true; > >app.DeploymentManager.EncryptCFML = false; > >app.DeploymentManager.ForceLowerCase = false; > >// === > >// Server ftp://wwwMySite Deployment > >// === > >// >>> Folder: BreakingFolder\breaking > > > > app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml"," > > ftp://www.mysite.com:21/www/breaking/breaking.shtml"); > > > > > >app.DeploymentManager.CloseProject(); > > > > } > > > > The error is: > > > > "No Deployment Folder Path for folder: breaking" > > and > > "No Deployment Folder Path for folder: images" > > > > = > > Howard Owens > > Web Producer > > InsideVC.com > > mailto:[EMAIL PROTECTED] > > = > > > > ~~ > > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dave Watts please read - Re: BLOCKFACTOR and MAXROWS
> According to the article by Mr. Van Horn, any Oracle or ODBC > datasource supports blockfactor. Is that not true? I don't know for sure. > > Also, setting a block factor too high when it is not needed > > will hurt performance because allocating and freeing those > > larger buffers takes time (and takes memory away from where > > it could be more efficiently used). > > Well, how can you know when it's needed? Obviously, when doing a > search, you may return 1,000 records, or you may return 1. You won't be able to exactly determine the optimal value for each use. You'll have to estimate. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Use End of Line Char as Delimiter?
yes it is. use the CHR() function ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 2:40 PM To: CF-Talk Subject: Use End of Line Char as Delimiter? Is it possible to use the end of line character as a delimiter in a list (I beleive it is Ascii-20)? The I could read an entire text file into The reason I ask is that I need to read a text file line by line, and it would be much easier if I could get a line count as I am going. jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF COM site
Hello all, For those who haven't already seen this site, check it out. Especially is you use or have tries to use COM objects with CF. http://www.cfcomet.com/cfcomet/ I was going to post this link to the list a while back when someone was talking about creating WORD documents from CF. You can find out how at this site, plus more. Eric ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Use End of Line Char as Delimiter?
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C054C9.763C0AE0 Content-Type: text/plain; charset="iso-8859-1" CHR(13) and CHR(10) I can't remember which is which, but I believe one is line feed, and one is break. E -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 3:50 PM To: CF-Talk Subject: RE: Use End of Line Char as Delimiter? yes it is. use the CHR() function ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 2:40 PM To: CF-Talk Subject: Use End of Line Char as Delimiter? Is it possible to use the end of line character as a delimiter in a list (I beleive it is Ascii-20)? The I could read an entire text file into The reason I ask is that I need to read a text file line by line, and it would be much easier if I could get a line count as I am going. jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists --_=_NextPart_001_01C054C9.763C0AE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Use End of Line Char as Delimiter? CHR(13) and CHR(10) I can't remember which is which, but I believe one is = line feed, and one is break. E -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 3:50 PM To: CF-Talk Subject: RE: Use End of Line Char as = Delimiter? yes it is. use the CHR() function ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]= Sent: Wednesday, November 22, 2000 2:40 PM To: CF-Talk Subject: Use End of Line Char as Delimiter? Is it possible to use the end of line character as a = delimiter in a list (I beleive it is Ascii-20)? The I could read an entire = text file into The reason I ask is that I need to read a text file = line by line, and it would be much easier if I could get a line count as = I am going. jon ~~ Structure your ColdFusion code with Fusebox. Get the = official book at http://www.fusionauthority.com/bkinfo.cfm" = TARGET=3D"_blank">http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/= Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= ~~ Structure your ColdFusion code with Fusebox. Get the = official book at http://www.fusionauthority.com/bkinfo.cfm" = TARGET=3D"_blank">http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/= Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= --_=_NextPart_001_01C054C9.763C0AE0-- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf-studio mailing list? (was Re: Trying to understand deployment wizard)
Such a list is a great idea. Sign me up. I know Studio pretty well, but would like to know it even better. In the mean time, does anybody have an answer to my question? H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS SQL Shortcut?
I've got a table that contains payment detail records and I've found that something like the following workaround is necessary when adding up a column contains the dollar amount. This query always returns a single record, but when there are zero payment records found, the 'total' field returns a zero-length string rather than returning 0. Of course, if I later attempt to user that value in a CF arithmetic expression, CF chokes and gives an 'unable to convert' to numeric error. I've got a lot of these summing queries and was wondering if there's a way within the SQL statement (MS SQL7) to return 0 if there are no records found. SELECT Sum(paymentamt) AS total FROM payments WHERE userid = #form.userid# Thanks, Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:MS SQL Shortcut?
I havn't tested this, but you should be able to do either of the following: SELECT (Sum(paymentamt) + 0) AS total or SELECT CAST(Sum(paymentamt) AS int) AS total Chris -- Original Message From: "Jim McAtee"<[EMAIL PROTECTED]> Subject: MS SQL Shortcut? Date: Wed, 22 Nov 2000 15:14:34 -0700 >I've got a table that contains payment detail records and I've found that >something like the following workaround is necessary when adding up a column >contains the dollar amount. This query always returns a single record, but >when there are zero payment records found, the 'total' field returns a >zero-length string rather than returning 0. Of course, if I later attempt >to user that value in a CF arithmetic expression, CF chokes and gives an >'unable to convert' to numeric error. I've got a lot of these summing >queries and was wondering if there's a way within the SQL statement (MS >SQL7) to return 0 if there are no records found. > > > >SELECT Sum(paymentamt) AS total >FROM payments >WHERE userid = #form.userid# > > > > > > > > >Thanks, >Jim > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfhttp? (tds)
I have a ColdFusion Template, call "getInfo.cfm", that will query a database and return a comma delimited list of records. For example: 1,Abby 2,Jack 3,Suzie I have another ColdFusion Template, called index.cfm, that makes a call to the "getInfo.cfm" template with cfhttp to this list. http://www.server.edu/getInfo.txt" name="XX" columns="id,name"> (#id# - #name#) This works fine with getInfo.txt which is a static text file, but not with getInfo.cfm which is a ColdFusion Template. I can't figure out what to do next or what other approach to take. Please Advise. Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Anyplace to pick up outdated browser versions for testing
I need to get some older versions of MSIE and Netscape in order to test out style sheets that will be dynamically assigned based on browser version as detected by CF. Does anyone know where these can be found? I've searched around on MS and Netscape site but can't find any archives of outdated browser versions. Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
page breaks
Help I know we went over this a while back, but humor me again, please. I need to embed a page break in some HTML code to force the printer to "page break". Thanks in advance. Don't eat too much turkey! Nick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: page breaks
Nick, As far as I know, you can do this with StyleSheets for IE, but not for Netscape. Define a style like this: P.page {page-break-after:always} Then use to force the break. Anyone have any better way? Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Nick Call [mailto:[EMAIL PROTECTED]] Help I know we went over this a while back, but humor me again, please. I need to embed a page break in some HTML code to force the printer to "page break". IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Trying to understand deployment wizard
G'day Howard, Not sure if this is a help to you or not, but I gave up on the deployment wizard in Studio4.5.1 because it only works if all your folders are already created on the host, AND if you are uploading the entire project. It's a bug in the software, and as far as I know nothing's on the slate for a new version yet. It's a pity because I used to use the deployment all the time in Studio4.0.1 and found it one of the most useful features. Nowadays I build a local version and use my reliable CuteFTP to upload it. And CuteFTP doesn't cost nearly A$1000 either. I think it's an outrage, and possibly even an infringement of the Sale Of Goods act to claim Studio v4.5.1 works on Windows95/98 and that it will automatically deploy your project. I've had a few sympathetic calls, and one particularly helpful individual at Allaire in the USA call me over several days to try to fix my Studio problems, but they steadfastly refused to go away, hundreds of other people have the same problems, yet Allaire haven't made any sign they're about to release another version any time soon. I'll continue to attack them until they do. If I built web sites the way they build Studio, I'd be sued out of business by my clients. Cheers, Mike Kear AFP Web Development Windsor, NSW, Australia On Wed, 22 Nov 2000, Owens, Howard wrote: > > This isn't work and I don't understand the error message. Any help would be > appreciated: > > Using the deployment wizard, I created the following script > > // === > // Project Name: BreakingFolder > // Date/Time Generated:11/22/2000 11:10 > // > // === > // Server List: > // > // ftp://wwwMySite > // === > > function Main() > { > var app = Application; > > > app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a > pf"); >// === >// Set Deployment Flags... >// === >app.DeploymentManager.CreateFolder = true; >app.DeploymentManager.UploadOnlyIfNewer = true; >app.DeploymentManager.EncryptCFML = false; >app.DeploymentManager.ForceLowerCase = false; >// === >// Server ftp://wwwMySite Deployment >// === >// >>> Folder: BreakingFolder\breaking > > app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml"," > ftp://www.mysite.com:21/www/breaking/breaking.shtml"); > > >app.DeploymentManager.CloseProject(); > > } > > The error is: > > "No Deployment Folder Path for folder: breaking" > and > "No Deployment Folder Path for folder: images" > > > > = > Howard Owens > Web Producer > InsideVC.com > mailto:[EMAIL PROTECTED] > = > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Trying to understand deployment wizard
Mike, I don't use the deployment wizard, but I wonder if you have tested the soon-to-be-released version of ColdFusion Studio that is currently at Release Candidate level? I am using it and have definitely found some improvements, especially in the way of their FTP engine (they have apparently replaced it altogether with another ftp engine). It is available for download in the beta section of Allaire's website: beta.allaire.com. Eron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Kear Sent: Wednesday, November 22, 2000 6:47 PM To: CF-Talk Subject: Re: Trying to understand deployment wizard G'day Howard, Not sure if this is a help to you or not, but I gave up on the deployment wizard in Studio4.5.1 because it only works if all your folders are already created on the host, AND if you are uploading the entire project. It's a bug in the software, and as far as I know nothing's on the slate for a new version yet. It's a pity because I used to use the deployment all the time in Studio4.0.1 and found it one of the most useful features. Nowadays I build a local version and use my reliable CuteFTP to upload it. And CuteFTP doesn't cost nearly A$1000 either. I think it's an outrage, and possibly even an infringement of the Sale Of Goods act to claim Studio v4.5.1 works on Windows95/98 and that it will automatically deploy your project. I've had a few sympathetic calls, and one particularly helpful individual at Allaire in the USA call me over several days to try to fix my Studio problems, but they steadfastly refused to go away, hundreds of other people have the same problems, yet Allaire haven't made any sign they're about to release another version any time soon. I'll continue to attack them until they do. If I built web sites the way they build Studio, I'd be sued out of business by my clients. Cheers, Mike Kear AFP Web Development Windsor, NSW, Australia On Wed, 22 Nov 2000, Owens, Howard wrote: > > This isn't work and I don't understand the error message. Any help would be > appreciated: > > Using the deployment wizard, I created the following script > > // === > // Project Name: BreakingFolder > // Date/Time Generated:11/22/2000 11:10 > // > // === > // Server List: > // > // ftp://wwwMySite > // === > > function Main() > { > var app = Application; > > > app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a > pf"); >// === >// Set Deployment Flags... >// === >app.DeploymentManager.CreateFolder = true; >app.DeploymentManager.UploadOnlyIfNewer = true; >app.DeploymentManager.EncryptCFML = false; >app.DeploymentManager.ForceLowerCase = false; >// === >// Server ftp://wwwMySite Deployment >// === >// >>> Folder: BreakingFolder\breaking > > app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml"," > ftp://www.mysite.com:21/www/breaking/breaking.shtml"); > > >app.DeploymentManager.CloseProject(); > > } > > The error is: > > "No Deployment Folder Path for folder: breaking" > and > "No Deployment Folder Path for folder: images" > > > > = > Howard Owens > Web Producer > InsideVC.com > mailto:[EMAIL PROTECTED] > = > > ~~ > Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Trying to understand deployment wizard
After many anguished nights rebuilding broken systems years ago, and wrestling with a Windows95 scattered with remnants of the Windows95 betas, I resolved never to use beta software on anything but an experimental machine ever again. So in short, no I haven't, and I won't either until the released version is available. But it is extremely good news that they have developed a new version! Cheers, Mike Kear Windsor, NSW, Australia On Wed, 22 Nov 2000, Eron Cohen wrote: > Mike, > > I don't use the deployment wizard, but I wonder if you > have tested the soon-to-be-released version of > ColdFusion Studio that is currently at Release > Candidate level? I am using it and have definitely > found some improvements, especially in the way of > their FTP engine (they have apparently replaced it > altogether with another ftp engine). > > It is available for download in the beta section of > Allaire's website: beta.allaire.com. > > Eron > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > Behalf Of Michael Kear > Sent: Wednesday, November 22, 2000 6:47 PM > To: CF-Talk > Subject: Re: Trying to understand deployment wizard > > > G'day Howard, > > Not sure if this is a help to you or not, but I gave > up on the deployment > wizard in Studio4.5.1 because it only works if all > your folders are > already created on the host, AND if you are uploading > the entire project. > It's a bug in the software, and as far as I know > nothing's on the slate > for a new version yet. > > It's a pity because I used to use the deployment all > the time in > Studio4.0.1 and found it one of the most useful > features. Nowadays I > build a local version and use my reliable CuteFTP to > upload it. And > CuteFTP doesn't cost nearly A$1000 either. > > I think it's an outrage, and possibly even an > infringement of the Sale Of > Goods act to claim Studio v4.5.1 works on Windows95/98 > and that it will > automatically deploy your project. I've had a few > sympathetic calls, and > one particularly helpful individual at Allaire in the > USA call me over > several days to try to fix my Studio problems, but > they steadfastly > refused to go away, hundreds of other people have the > same problems, yet > Allaire haven't made any sign they're about to release > another version any > time soon. > > I'll continue to attack them until they do. If I > built web sites the way > they build Studio, I'd be sued out of business by my > clients. > > Cheers, > Mike Kear > AFP Web Development > Windsor, NSW, Australia > > On Wed, 22 Nov 2000, Owens, Howard wrote: > > > > > This isn't work and I don't understand the error > message. Any help would be > > appreciated: > > > > Using the deployment wizard, I created the following > script > > > > // > === > > > // Project Name: BreakingFolder > > // Date/Time Generated:11/22/2000 11:10 > > // > > // > === > > > // Server List: > > // > > // ftp://wwwMySite > > // > === > > > > > function Main() > > { > > var app = Application; > > > > > > > app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a > > pf"); > >// > === > > >// Set Deployment Flags... > >// > === > > >app.DeploymentManager.CreateFolder = true; > >app.DeploymentManager.UploadOnlyIfNewer = true; > >app.DeploymentManager.EncryptCFML = false; > >app.DeploymentManager.ForceLowerCase = false; > >// > === > > >// Server ftp://wwwMySite Deployment > >// > === > > >// >>> Folder: BreakingFolder\breaking > > > > > app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml"," > > > ftp://www.mysite.com:21/www/breaking/breaking.shtml"); > > > > > >app.DeploymentManager.CloseProject(); > > > > } > > > > The error is: > > > > "No Deployment Folder Path for folder: breaking" > > and > > "No Deployment Folder Path for folder: images" > > > > > > > > = > > Howard Owens > > Web Producer > > InsideVC.com > > mailto:[EMAIL PROTECTED] > > = > > > > ~~ > > Structure your ColdFusion code with Fusebox. Get the > official book at > http://www.fusionauthority.com/bkinfo.cfm > > > > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > ~~ > Structure your ColdFusion code with Fusebox. Get the > official book at >
Re: Trying to understand deployment wizard
i heard them say that a new version (not sure if it is the one mentioned) will be based on the wsftp engine buy ipswitch, which is in my expereince the most stable one there is i hate the interface, but for years haven't been able to break away from it. every time i see something sexier, i try it out, and then inevitably run into problems and go back to ws. - Original Message - From: "Eron Cohen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 22, 2000 7:53 PM Subject: RE: Trying to understand deployment wizard > Mike, > > I don't use the deployment wizard, but I wonder if you > have tested the soon-to-be-released version of > ColdFusion Studio that is currently at Release > Candidate level? I am using it and have definitely > found some improvements, especially in the way of > their FTP engine (they have apparently replaced it > altogether with another ftp engine). > > It is available for download in the beta section of > Allaire's website: beta.allaire.com. > > Eron > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > Behalf Of Michael Kear > Sent: Wednesday, November 22, 2000 6:47 PM > To: CF-Talk > Subject: Re: Trying to understand deployment wizard > > > G'day Howard, > > Not sure if this is a help to you or not, but I gave > up on the deployment > wizard in Studio4.5.1 because it only works if all > your folders are > already created on the host, AND if you are uploading > the entire project. > It's a bug in the software, and as far as I know > nothing's on the slate > for a new version yet. > > It's a pity because I used to use the deployment all > the time in > Studio4.0.1 and found it one of the most useful > features. Nowadays I > build a local version and use my reliable CuteFTP to > upload it. And > CuteFTP doesn't cost nearly A$1000 either. > > I think it's an outrage, and possibly even an > infringement of the Sale Of > Goods act to claim Studio v4.5.1 works on Windows95/98 > and that it will > automatically deploy your project. I've had a few > sympathetic calls, and > one particularly helpful individual at Allaire in the > USA call me over > several days to try to fix my Studio problems, but > they steadfastly > refused to go away, hundreds of other people have the > same problems, yet > Allaire haven't made any sign they're about to release > another version any > time soon. > > I'll continue to attack them until they do. If I > built web sites the way > they build Studio, I'd be sued out of business by my > clients. > > Cheers, > Mike Kear > AFP Web Development > Windsor, NSW, Australia > > On Wed, 22 Nov 2000, Owens, Howard wrote: > > > > > This isn't work and I don't understand the error > message. Any help would be > > appreciated: > > > > Using the deployment wizard, I created the following > script > > > > // > === > > > // Project Name: BreakingFolder > > // Date/Time Generated:11/22/2000 11:10 > > // > > // > === > > > // Server List: > > // > > // ftp://wwwMySite > > // > === > > > > > function Main() > > { > > var app = Application; > > > > > > > app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a > > pf"); > >// > === > > >// Set Deployment Flags... > >// > === > > >app.DeploymentManager.CreateFolder = true; > >app.DeploymentManager.UploadOnlyIfNewer = true; > >app.DeploymentManager.EncryptCFML = false; > >app.DeploymentManager.ForceLowerCase = false; > >// > === > > >// Server ftp://wwwMySite Deployment > >// > === > > >// >>> Folder: BreakingFolder\breaking > > > > > app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml"," > > > ftp://www.mysite.com:21/www/breaking/breaking.shtml"); > > > > > >app.DeploymentManager.CloseProject(); > > > > } > > > > The error is: > > > > "No Deployment Folder Path for folder: breaking" > > and > > "No Deployment Folder Path for folder: images" > > > > > > > > = > > Howard Owens > > Web Producer > > InsideVC.com > > mailto:[EMAIL PROTECTED] > > = > > > > ~~ > > Structure your ColdFusion code with Fusebox. Get the > official book at > http://www.fusionauthority.com/bkinfo.cfm > > > > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > ~~ > Structure your ColdFusion code with Fu