RE: Database Design Challenge!
A family Tree ? Say that word again tree . That is exactly what you want a tree structure. Go out and buy Joe Clecko book SQL for Smarties... He has examples of the exact thing you are after.. with optimised querys etc... Basically you need to de-normalise the tables a bit , Joe adds a row called left and Right You then use these values to get data . For eg select * from tree where left = 1 gets you the root node., Buy the book, lots of great tip in there... Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 3:30 PM To: CF-Talk Subject: Database Design Challenge! If anyone can solve this one, I'll give you a million bucks. Or maybe not, but I'll certainly be impressed... Let's say, for instance, I'm storing data about a family tree. Every person has a record in the People table. Every person has a Mother and a Father, linked with their unique ID. Now the challenge: How can I create the list of all male ancestors, all the way back to the root level (i.e. Adam Eve)? I've managed to do this with a CFLOOP that keeps running a query, going up the tree, until the FatherID is zero, but this is expensive on the database end. For the record, I'm not actually keeping track of people all the way back to Adam Eve, but this is the best way to explain this database design issue. Thank you very much! Norman Elton Jefferson Labs ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Scripting The Visual Tools Object Model
Check out http://www.wilk4.com/asp4hs/ Justin -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 5:45 AM To: CF-Talk Subject: Scripting The Visual Tools Object Model Hi all, I have been trolling through the Studio docs to find info on creating VTML files - fun stuff! I came across the chapter Scripting The Visual Tools Object Model and it seems pretty comprehensive. Amazing what you come across in those back chapters. Is anyone actually creating customised applications for Studio? I think it seems cool but can't think of any practical uses. K. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Brown Bear's iCal
are you trying to parse iCal data?? use lex/yacc + a cCFX or jacc + java cfx look here http://www.imc.org/ Justin -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 3:01 AM To: CF-Talk Subject: Brown Bear's iCal Does anyone have or know of a custom tag that interacts with Brown Bear's iCal calendar server. If not, does anyone know where I can get a good reference for parsing through a CFHTTP pull? TIA! Hatton Humphrey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Netscape 6
I said it before and I'll say it again Mozilla is a great browser. Netscape built NS6 on a 0.8 branch of Mozilla. When the next version of Netscape come out you should a good browser, with a great JavaScript debugger , Mail client etc . Justin (wearing a black beret) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 4:29 PM To: CF-Talk Subject: RE: Netscape 6 And people wunder why no one bothers to suport it :-) -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: 25 April 2001 14:52 To: CF-Talk Subject: RE: Netscape 6 That is a known bug in Netscape 6. The latest updates have not yet fixed the problem. Benjamin S. Rogers ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Tunneling, Firwall?
How do you mean only IE ??? If you want to pretend to be IE from any client all you need to do is send a http__user_agent value in the request, easy... Justin -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 10:59 AM To: CF-Talk Subject: Tunneling, Firwall? We're sending HTTP request to a CF server from within a client that is not a browser (It's our own Visual C++ application). We're having a problem with firewalls. Personal/Enterprise firewalls just don't seem to let us throgh (only IE is permitted). Can someone suggest a technical way to Tunnel from within a Firewall? I would like to research this subject. Thanks, -Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Synchronize between CF-Forums NNTP
If you look at min's site www.intrafoundation.com, he has a TCP cfx you can use for NNTP , also this list is on a NNTP, you chould email Michael. Justin -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 1:15 PM To: CF-Talk Subject: Synchronize between CF-Forums NNTP We created a forum for our site (forums.imvamp.com). We now want to synchronize every message that is sent to the forum to be automaticlly sent to a NNTP Server too (thus creating a news.imvamp.com on IIS server and vice versa). I saw DEVX.COM uses this method with their ASP forum by sending a special unique header for the message. How can this be done? Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need Help for cfhttp
Look at cfx_http in the taggallery... Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:50 PM To: CF-Talk Subject: Need Help for cfhttp Hi, I have a cfm page that needs access to https site to get files back to my server, here is my problem and question. In order for me to get the file, I will need to login to https site first then click one submit form to get the file. I am able to use cfhttp to send username and password and Logon successful. BTW on the https site is use Servelt to verify username and password,the servelt is running on JRUN. But, in order for me to get the file, I will need to send another cfhttp to access the 2nd page, but it tells me that I am not logged on when I try to access the 2nd page. here is my questions: 1. when I use cfhttp to access to either http or https, is that a new instance to the server that I am try to access to it? 2. Actually, JRUN Server is the server that I am try to use cfhttp to get access to it, is there a way for me to use 2 cfhttp and it will knows that is one instance instead of 2 instances. Is there a way to catch the jrunsessionid and the value so I can attached that jrunsessionid and value on my 2nd cfhttp? Thank you for any suggestion YC I'm currently using CF Webstore, and also found that the site is currently down. Notwithstanding, the product appears to be well written and in its 4th iteration, fairly mature. Documentation is just fair - I'm struggling with some issues with customization (I wish we had access to a map of the files so we could see the interaction between files). I too use CrystalTech in Arizona for most of my hosting. Their support is top notch - I can get a live network support person in the server room any hour of the day, even 3 and 4 AM EDT, and they solve problems nearly immediately. They are also very responsive on email support as well. I will caution you, the CF Webstore (to use images) requires that the CFX_ImgInfo tag be put on the server (CrystalTech will charge you $10 per month to do it). Does someone with CF Webstore experience know how to use a CFModule call for this tag so that I can avoid having to place the custom tag in CF Admin? Thanks, Mark Leder -Original Message- From: Hawkins, Tim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 4:34 PM To: CF-Talk Subject: CF Shopping Cart Solution? Does anyone have experience with CF EZ CART or other CF based Shopping Cart software? Im a Mid-Level Developer who is looking for a shopping cart solution. Crystaltech www.crystaltech.com is a great ISP which has Cold Fusion in their most basic monthly plans but their standard Cart is Miva Merchant, which isn't currently very stable on 2000. Thanks in Advance. Tim Hawkins Web Developer Spectrum Astro Inc. www.spectrumastro.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: CFML not being executed
Sure the template is being called via the webserver? You got IIS log entries? Does cf administrator work Justin -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 6:24 PM To: CF-Talk Subject: CFML not being executed Just had a box put together with Win2k, IIS, CF 4.5.1 sp2 and for some reason it is not executing the CFML code. When I view the source the CFML code is still in the contained in the returned html. I've tried everything even reinstalling both CF and the OS. I checked the ISAPI filters, execute, everything I can think of, but nothing works. Any ideas TIA, Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Transferring 1-3Kb data
2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Delimiters
chr(7) Justin -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 3:11 PM To: CF-Talk Subject: Re: Delimiters use a series of hard to find types. something like: "~%~" this will guarntee NO ONE will type it. - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:54 PM Subject: Delimiters Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [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: W2K Pro, IE5.5, .doc files and duplicate file extensions
Register the doc extension in File Types in your IIS console. extension : doc mimetype : application/msword JUstin -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 10:58 AM To: CF-Talk Subject: RE: W2K Pro, IE5.5, .doc files and duplicate file extensions Just read this... Word 2000 is installed on my machine, yet I'm still getting the duplicate extension. Seems a bit daft... does anyone know of a way around it, *other* than zipping up the file (don't want to have to explain to users how to unzip it) or saving it as a different file type? == Extra File Extension May Be Added to Downloaded Files [Q231755] PSS ID Number: Q231755 Article last modified on 01-04-2001 WINDOWS:5 == -- -- --- The information in this article applies to: - Microsoft Internet Explorer version 5 for Windows 95 - Microsoft Internet Explorer version 5 for Windows 98 - Microsoft Internet Explorer version 5 for Windows NT 4.0 - Microsoft Windows 98 Second Edition -- -- --- SYMPTOMS When you download a file using Internet Explorer, a duplicate file extension may be added to the file name. CAUSE = This problem can occur for file types that are not registered in Microsoft Windows. RESOLUTION == To resolve this problem, use any of the following methods: Rename the Downloaded File -- Rename the file to include only one extension. For example, if you downloaded a file named myfile.doc.doc, rename it to myfile.doc. For information about how to rename a file, click Start, click Help, click the Index tab, type "renaming files" (without the quotation marks), and then click Display. Hide the File Extensions for Known File Types - To hide the file extensions for known file types, follow these steps: 1. Double-click My Computer, and then click Folder Options on the View menu. 2. Click the View tab. 3. Under Files and Folders, click to select the "Hide file extensions for known file types" check box. 4. Click OK. Register the File Type in Windows - To register the file type in Windows after you rename the file, follow these steps: 1. Click Start, point to Programs, and then click Windows Explorer. 2. Browse to the downloaded file that includes the extension you want to register. 3. Press and hold down the SHIFT key, and then right-click the file. 4. Click Open With. 5. If you are prompted to enter a description for the file type, do so. In the "Choose the program you want to use" box, click the program you want to use to register this file type. 6. Click to select the "Always use this program to open this file" check box. 7. Click OK. STATUS == Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. Additional query words: == Keywords : kbenv msiew95 msient msiew98 Version : WINDOWS:5 Issue type: kbprb == == = Copyright Microsoft Corporation 2001. -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Email Questions
Check out iMS from coolfusion.com ~ Justin -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 2:04 PM To: CF-Talk Subject: RE: Email Questions On the same topic, but a question(ish), I've thought about setting up a mailing list (listserv) and using CF to send one message to the listserv. I haven't put this in practice, but in theory you could set up the list to only relay e-mails from one account and then set up CF to send the e-mails using that address as the "from". Then you only send one e-mail from CF Server and let the listserv software handle all the rest. Has anyone put this into practice? Thanks! Hatton -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 10:00 AM To: CF-Talk Subject: Re: Email Questions Break your query up. Run all the email for the last names that start with the letters A-C, D-F, and so on. Run them one at a time. Finding a way to make your query results smaller and thus sending fewer emails ought to do the trick. - Original Message - From: "Brian Peddle" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 7:55 AM Subject: Email Questions I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: compare files??
use diff, diff3 (windows port at cygwin.com ), or windiff (MS Visual studio / or win2000 REsource KIT ) or CVS source control, or VSS??? Justin -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:45 PM To: CF-Talk Subject: compare files?? hi, i was just wondering whether CF studio has any facility to compare 2 ..cfm files and list out the differences. coz i need it very much in my work and if its not there, is there any other way i can do the compare? TIA akbar ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: directories off of inetpub...
it? Is it synonymous to cgi-bin in Unix? Yes it is IIS installs a lot of crap, and the more you upgrade/ service pack the more crap you get ... You can remove the scripts directory , the reference to it in IIS Also remove any documentation directories, CFDOCS etc.. FRontpage also installs many _vti_* directories. Get rid of them too. Make sure your MDAC to up to date too... Make sure NT has service packs at least to sp5. Checkout http://www.sans.org/infosecFAQ/win/IIS_vulnerabilities.htm for a nice roundup and all the other usually sec. sites... Justin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: IIS extension mapping to script engine
I got to ask, why ?? Justin. -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 12:00 AM To: CF-Talk Subject: IIS extension mapping to script engine I wish to map all file extensions to te Cold Fusion scripting engine. Is there a way to do this using wildcards? I have only been able to set this up one extension at a time. NT4 SP6a CF 4.5.1 SP1 IIS 4 Thank you, Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 Variables not being passed on selected machines
Are you sure the field names are all legal ? You should log what you are getting as input if there is an error, at least then you can figure out the problem. Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:57 AM To: CF-Talk Subject: Form Variables not being passed on selected machines All of a sudden, I have a situation where form variables are not being passed to the action template of a fairly basic form. Out of 300 users, I guess a handful of them get an error when the action template tries to evaluate the variables. I've checked the security settings in Explorer and they seem ok. Some have IE4 some have IE5 running on NT4. There is no pattern with the browser version. Any ideas? Craig Wilson Business Analyst Business Applications VOLKSWAGEN FINANCIAL SERVICES (UK) LIMITED Work: +44 (0)1908 485229 Fax: +44 (0)1908 549296 Mail: mailto:[EMAIL PROTECTED] *** *** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients *** *** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Weird CFFile behaviour with Mac IE5 upload
Actually IE5 on Mac adds a return char to every form fields... Justin -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 12:52 PM To: CF-Talk Subject: RE: Weird CFFile behaviour with Mac IE5 upload Problem is caused by MAC putting space in instead of an empty field - try using trim() when checking the field to see if it has been filled. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Studio on Linux??
Check out jEdit.sourceforge.net, xPlatform editor with some cf support , install all the plugins similar to cfstudio stuff. + java c perl etc.. HomeSite might reach *nix , with Klix etc and MacOSX = BSD Justin -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 2:22 AM To: CF-Talk Subject: RE: Studio on Linux?? I've looked into Quanta. From what I understand it is fairly customizable. Are there any customizations available for CF developers? I certainly don't hate Windows nor Microsoft. They're certainly the driving force behind lots of cool stuff out there. I would; however, like to learn more Linux. Thanks Norman -Original Message- From: Javier Woodhouse [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 7:50 PM To: CF-Talk Subject: RE: Studio on Linux?? hating windows does not mean hating good UI... What most people dont like about windows is Microsofts bussiness tactics... Followed by the operating systems instability and security holes.. -Original Message- From: zac [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 10:44 AM To: CF-Talk Subject: Re: Studio on Linux?? Michael Rosario wrote: You may want to check out http://quanta.sourceforge.net/ Which begs the question: If Linux users hate Windows so much why do they clone windows apps and use the same UI conventions as Windows? -- Don't blame me. I voted for Kodos. email: [EMAIL PROTECTED] WWW: http://www.pixelgeek.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfugmay2000 :: VCalendar :: Outlook :: permission to use
BTW there is a vcard buffer overflow issues / exploit in outlook, santitize your forms, patch outlook Justin -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:53 PM To: CF-Talk Subject: cfugmay2000 :: VCalendar :: Outlook :: permission to use hello all. i found some code i must have grabbed from some cfug zip for may 2000. it has a neat vcalendar to insert instances from a db into your outlook calendar. just wanted to know if there are more examples like this. Also if i can modify the code for my own use in local Intranet apps"? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: cfugmay2000 :: VCalendar :: Outlook :: permission to use
sanitize my forms? i don't understand. I just mean make sure you get correct field lenghts etc.. where can i get more info? do you have a url? Here is a link with some details about the issue http://www.securityfocus.com/bid/1633. thank you -paul ~J ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Good Books on JSP?
You can learn the basics of JSP in a couple of hours but to learn Java ... Starting Java2 by WROX - good starting book for non-programmers Java Server Programming by Wrox - good starting book for using java server side All the Java in a Nutshell books by OReilly for reference java.sun.com docs and tutorials and the JavaDocs stuff.. I'd say the Wrox , and OReilly book on JSP are pretty but the more generic java book would be better value, especially since the JSP book probably spend half the page telling you how to install a webserver , how HTTP work , which you know already etc. etc Justin :-) -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 3:08 PM To: CF-Talk Subject: OT: Good Books on JSP? Good Morning All! it is once again time to learn something new. what is the WACK equivalent to JSP books out there? just got a bug to learn something new! thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax: 614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Using javascript to create an Undo - the return
You should look at design patterns. The command pattern as it is known is the most used pattern for undo/ redo operations. It is used natively in java, but chould be used in a JavaScript lib. Check out: http://www.amazon.co.uk/exec/obidos/ASIN/0201633612/o/qid=984585622/sr=8-1/2 02-1404477-4361464 Justin -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:37 PM To: CF-Talk Subject: Using javascript to create an Undo - the return Hi - posted this recently but still no resolution: Have a cf forum we have written, with javascript "Word" like buttons that output html for b, i and u in the input textarea - would like to include an "undo" function with acts like ctrl+Z from the keyboard - in that it will remove either the last piece of text written, or the inputted b/b (etc) tags - any suggestions? James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: com wddx
Are you sure you are putting the wddx com in the References (in your vba) Justin -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 6:53 PM To: CF-Talk Subject: com wddx Dear all (Its been a while since I was on the list) It occurred to me that it might be a clever thing to be able to send data in wddx packets directly from excel 2000 (win 95) up to the server (if you were online)... BUT In my experimentations I have done as asked in the wddx.org SDK which comes with CF 4.5 ref installing registering wddx_com.dll but when I run the VBA code (code taken verbatim from Forta) it fails on the first line! Set MyDeser = CreateObject("WDDX.Deserializer.1") Run-time error '438': Object doesn't support this property or method wddx_com.dll seems OK in the OLE/COM OBject viewer (No idea what I'm looking for though!) There does seem to be some sort of problem with xmlparse.dll and xmltok.dll in as much that I get the message xmltok.dll was loaded but the DLLRegisterServer entry point was not found etc. when I run regsvr32 xmltok.dll I've tried deleting Reinstalling these files but no diff. ANY Ideas Please! -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Problem with CFFILE (sort of)
You should really use UNC instead a mapped drive . Check out some links from http://www.cffaq.org/cfserveruseraccount.cfm Justin [EMAIL PROTECTED] -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:38 PM To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Problem with CFFILE (sort of)
If you create a domain account with access to the shared drive that will work. (running cf under that account) Otherwise if you create an account with the same username password on each box that will work too I do this with out problem.. Justin -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:54 PM To: CF-Talk Subject: RE: Problem with CFFILE (sort of) You should really use UNC instead a mapped drive . Check out some links from http://www.cffaq.org/cfserveruseraccount.cfm Justin [EMAIL PROTECTED] -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:38 PM To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Problem with CFFILE (sort of)
Have a look at the link I sent you, they will give you info you need , for the permissions etc.. Justin -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 2:22 PM To: CF-Talk Subject: RE: Problem with CFFILE (sort of) OK I can't seem to restart cold fusion as anything other than the local system account. I have created a new user which is part of Domain users and Users but when I try to start Cold Fusion I get an "Internal NT error" number 2140 "Unable to start ColdFusion Service" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFFILE with UNC Paths.
Hi Check out the links from http://www.cffaq.org/cfserveruseraccount.cfm Justin [EMAIL PROTECTED] -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 4:12 PM To: CF-Talk Subject: CFFILE with UNC Paths. Anyone know a way to write a file via a UNC path? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Run CF on one server and write to another server?
Look here : http://www.cffaq.org/cfserveruseraccount.cfm Justin -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 5:57 PM To: CF-Talk Subject: Re: Run CF on one server and write to another server? I'd look at the CFFTP tag. Although, I haven't actually used it, I believe it should do the trick. At 09:26 AM 02/23/2001 -0500, you 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_01C09DA4.997A2450 Content-Type: text/plain; charset="iso-8859-1" I am currently using CF to create static html pages on a daily basis. Once they are created, I want to write or move them to another server. Any suggestions as to how to get the files moved or written over to the other server? I am having no luck here, Thanks in advance, Basia --_=_NextPart_001_01C09DA4.997A2450 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" Run CF on one server and write to another server? I am currently using CF to create static html pages = on a daily basis. Once they are created, I want to write or move = them to another server. Any suggestions as to how to get the = files moved or written over to the other server? I am having no luck = here, Thanks in advance, Basia --_=_NextPart_001_01C09DA4.997A2450-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've got the brains, you've got the looks, let's make lots of money ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Cheaper Alternative to SQL Server 2000
You could look at MySql -Free Justin -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 8:21 PM To: CF-Talk Subject: Re: OT: Cheaper Alternative to SQL Server 2000 Well, depending on your resources... You can get the developer version for ~$500. Or spend $1000 to subscribe to MSDN. Either of these copies, however, will be strictly for development. Since you quoted $5,000 as the price I imagine you are not looking into hosting yourself, but outsourcing it. I'd highly recommend against using MS Access, although it is an option. At 08:49 AM 02/22/2001 -0700, you wrote: Sorry about the OT post. I was wondering if someone could give me some feedback on a cheaper alternative to SQL Server. I am on a limited budget to create my own webserver and I have only experience in developing with CF and SQL Server. I really can't afford the $5,000 that Microsoft wants for SQL Server 2000. Anybody have any suggestions? Thanks for your time Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFX_ZIP on Linux?
A java version should be very easy, there is a java/zip example tag supplied with CF Justin -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 3:05 PM To: CF-Talk Subject: RE: CFX_ZIP on Linux? Yippee. Thanks. Michel -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 3:38 PM To: CF-Talk Subject: RE: CFX_ZIP on Linux? It is easier than you think Michel. The unix philosophy is using many small programs to achieve the effect of much larger ones ;) So.. if you wanted to create a zip file with max compression zip -9 foo.zip file1.txt file2.txt file3.txt Voila you now have foo.zip Just drop down to the good ole command line using a CFEXECUTE or some such and there you go. No Forta tags needed with Unix.. :) Jeremy Allen elliptIQ Inc. -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 3:54 AM To: CF-Talk Subject: CFX_ZIP on Linux? We're migrating a CF application from NT to Linux. One of the things it does is allow the user to tag a number of files which it then packs in one zip file for him to download. This is done with Ben Forta's cfx_zip. Is there any way at all to duplicate this functionality easily on Linux? In other words: is there a Linux equivalent, or do I need to do stuff with cfexecute? Michel Vuijlsteke 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: Adding CF Template to File:New in Windows
Download TweakUI from microsoft's web site. IT Allows you to this + a lot more besides Justin MacCarthy -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 12:08 PM To: CF-Talk Subject: OT: Adding CF Template to File:New in Windows Does anyone know how to add file types under "FILE : NEW" in Windows Explorer (same as right click, new). I'd like to have the ability to right click in folder view and add a CF template. Just to make this clear, you usually use FILE : NEW to add a new folder, shortcut, etc. Thanks in advance for any help, Brad Roberts [EMAIL PROTECTED] BTW, I did search the web (and the m$ site) and didn't find anything. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail -- Good Substitute???
CHeck out iMS mail from coolfusion.com Justin -Original Message- From: Melissa Fraher [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 7:40 PM To: CF-Talk Subject: CFMail -- Good Substitute??? Hello. Does anyone know of a good custom tag to use instead of CFMAIL? Any input on this would be appreciated. Thank you. Melissa Fraher ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Admin .htaccess files
YEah , there are 1000's of perl scripts to just that. http://www.google.com/search?q=perl+htaccess+cgibtnG=Google+Search Justin -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 2:51 PM To: CF-Talk Subject: Admin .htaccess files Hello, Is it possible to build an interface to administer .htaccess files from the browser? I've never tried, but can't think of a reason why it would not work. Any thoughts? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: how to launch a windows app from a web page?
On the client or server?? Signed Java or activeX or signed javascript(maybe) are the only ways to go Pretty easy code to it Justin -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 1:48 PM To: CF-Talk Subject: RE: how to launch a windows app from a web page? Try writing a batch file to start your application and call the batch file with cfexecute -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: 15 February 2001 02:30 To: CF-Talk Subject: OT: how to launch a windows app from a web page? Has anyone ever successfully launched a Windows application from a web page? If so, how? The only way I've found so far is using an ActiveX component--but only in theory. I'm looking for source code I could modify to launch a particular application. Is it possible to simply use an object tag to launch the application? Anyone know anything about this sort of thing? Thanks, James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: can anyone help?
cfif ProdCount LTE "3" AND GTE "1" should be cfif ProdCount LTE "3" AND ProdCount GTE "1" Justin -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 5:40 PM To: CF-Talk Subject: can anyone help? Hello all, Im getting an error that i cant figure out here... everything looks fine to me but maybe someone else can see something. here is the error.. Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 98 at position 30. ColdFusion was looking at the following text: GTE Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFIF tag occupying document position (98:2) to (98:6). AND HERE IS MY CODE: cfquery datasource="#datasource#" name="find_subcats" SELECT * FROM SubCats WHERE TopCatID = #URL.CategoryID# ORDER BY SubCat /cfquery cfset ProdCount = prodpage.RecordCount cfoutputcenterfont class="boldtext"#prodpage.Category# /font/center/cfoutputbr center table cellspacing="0" cellpadding="4" border="0" width="30%" CFPARAM NAME="URL.StartRow" DEFAULT="1" cfloop query="prodpage" cfoutput query="prodpage" startrow=#URL.StartRow# maxrows=6 !! this is line 98!! cfif ProdCount LTE "3" AND GTE "1" cfif ProdCount EQ "0" tr /cfif td colspan="4" align="center" valign="bottom" a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID #"img src="images/#ItemPic#" border="0"/abr font class="boldtext"a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID #"#ItemName#/a/font/td cfif ProdCount EQ "3" /tr /cfif /cfif cfif ProdCount LTE "6" AND GTE "4" cfif ProdCount EQ "4" tr /cfif td colspan="4" align="center" valign="bottom" a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID #"img src="images/#ItemPic#" border="0"/abr font class="boldtext"a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID #"#ItemName#/a/font/td cfif ProdCount EQ "6" /tr /cfif /cfif cfset ProdCount = ProdCount + 1 /cfoutput /cfloop /table /center Any help would be much appreciated. Thanks, Jay Patton Web Design / Application Design Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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: Parsing Headache (Removing Multiple Images)
REreplace(page,"img.*[^]","","ALL") or something??? Justin -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 5:44 PM To: CF-Talk Subject: Parsing Headache (Removing Multiple Images) OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: PDFs, Linotronic PS Drivers, Forms and Adobe Licensing
Check out : ActivePDF.com GhostViewer Justin -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 7:37 PM To: CF-Talk Subject: PDFs, Linotronic PS Drivers, Forms and Adobe Licensing So this guy says to me. It's be cool if ... I think I heard some comments on using Adobe Distiller on an Internet Server is in violation of the Adobe license for Distiller? Is this true? Here is what I am thinking. We create a basic site with an info centre to post how to's and help etc. We have downloads for people to use, basically we'll kick start a community driven file sharing centre. The documents available for download will be document design templates in the myriad of available formats, quark, word, whatever. We want to be able to create a printable format document and have decided on PDF. We want to dynamically generate the print document on the server, as a proof to the creator, and as a distributable print document to the digital printer. And also include a basic work docket as well, type of paper, shipping information etc. More or less, without actually seeing it work is to output to a common post script format (created using a free linotronic PS driver?) to be uploaded to the server using a form. Distiller can be used to watch the upload directory, and automatically create the PDF. After creation, a ticket is sent to the creator to approve the PDF for printing. Once approved we distribute to the printer for printing. So Question 1: What are the licensing issues regarding the use of Distiller on a public Server? Question 2: Performance? Question 3: Other Alternatives? Question 4: Current examples of people doing something similar. Question 5: Is there a way to programmatically enhance the print driver to automatically post the PS to the Internet Server? Other Alternatives? Implementations? Thanks 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: CFPOP unknown error
Use cfx_pop or cfx_imap Justin -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 9:35 PM To: CF-Talk Subject: CFPOP unknown error Hi people, I've been trying to fix my long-standing CFPOP problem by writing a page to remove the bad messages from the mailbox. However, it seems unknown errors cannot be caught by try and catch. Hmmm... The only thing I can think of is relying upon client side Javascript to autorefresh to a "delete message" page if the page isn't fully output. Can anyone better this? I find this horribly ugly because I can't schedule it, I'd have to run it manually. Anybody... an alternative please??? David Cummins -- David Cummins Systems Developer Ubiquity Software Ltd. Ph: (09) 309-1921 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 to find tables
You would be better off using the sp_tables Sproc. Justin [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 12:00 PM To: CF-Talk Subject: Re: SQL to find tables Thanks . . . - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 12, 2001 6:44 AM Subject: RE: SQL to find tables Is there an SQL command I can use to look into a database and dynamically return all of the table names and output them to a page? Use either Information_Schema.Columns or SysObjects Select distinct Table_Name from Information_Schema.Columns order by Table_Name Select name from SysObjects where xType='U' I wouldn't recommend using SysObjects too often as knowing M$, they'll change how it works... Also, these return the system tables as well as the generated tables Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a way to run a server side executable through CF?
I think you would be better off using "AT" from the command line to run batch job , assuming they are not cfm.. Of course it depends your access / privilgies on the box . Justin -Original Message- From: Edward Smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 8:23 PM To: CF-Talk Subject: Re: Is there a way to run a server side executable through CF? CFEXECUTE for newer versions of CF, and I think there's a couple of CFX tags in the taggallery for earlier platforms. Paul Begovich wrote: We have created several scripts written for NT Server that perform various server side tasks. What we want to do is execute these scripts using the CF scheduler. Is there a way to run a server side executable through CF? - 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: CF-NT-Server hangs: no interaction possible
One thing that really confused me recently was an exception within an error template, resulting in infinite loop.. and the server dying (on a Linux box) Quite confusing at first look though ... Justin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Batch Image Upload
Use wddx over http??? Justin -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 4:35 PM To: CF-Talk Subject: Batch Image Upload I was wondering if anyone has a custom cf tag, or some ideas to accomplish a batch image upload. I have a client that will be taking about 10 pictures a day on 10 different construction projects. They want to have the capability to upload the images in a batch process without using a FTP utility, for the sake of saving time. I have been brewing this over the last couple of days and any suggestions on how to accomplish this would be of great help. Thanks Jason Larson [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
WOT: was RE: Allaire on a Mac? now IE v's Mozilla :-)
oh no, I see a Win/Mac thread looming.. Wait here is a Mozilla / IE one to finally kill them off (just my $0.02) oh and for Crapscape to go. Utopia indeed. Anyone who has not tried Mozilla 0.7 should have a look. Finally getting there. Some get features. / V fast SSL etc working Justin in Black Beret mode. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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)RE: ALLR/MACR Merger - ColdFusion to be repositioned ?????
Interesting considering the recent Lawsuit settlement http://www.sun.com/smi/Press/sunflash/2001-01/sunflash.20010123.1.html;$sess ionid$L2N3UHYAACQZ5AMTA1LU45Q Justin -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 3:32 PM To: CF-Talk Subject: Re: (OT)RE: ALLR/MACR Merger - ColdFusion to be "repositioned" ? Concern? I'd think not. Besides, Microsoft has announced support for Java in .net: http://msdn.microsoft.com/visualj/jump/default.asp -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] "Belfiori, Ross" wrote: Since you mentions the app srvr. Is there any concern about CF going Java backend and the whole Java versus M$ .Net issues that have picked up steam? -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 12:40 PM To: CF-Talk Subject: RE: ALLR/MACR Merger - ColdFusion to be "repositioned" ? That was double good business double speak. What it sounds like to me is that the Cold Fusion server line will not be affected by the merger. It will continue to progress down the path it is currently on independantly of the going on with the Macromedia server products. Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Stephen M Aylor [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 11:23 To: CF-Talk Subject: ALLR/MACR Merger - ColdFusion to be "repositioned" ? Sands Brothers Investment Research Covering MACR Hears the link - hears the paragraph causing me some "kun-fusion" http://investor.cnet.com/investor/news/newsitem/0-9900-1028-459963 2-1.html?t ag=yhoo In the past, Macromedia has made a point of NOT participating directly in the application server business but rather to partner with leader's in the space. Management is aware of this issue and pointed out that Allaire's flagship product, ColdFusion, would be repositioned such that Allaire's CFML technology would be maintained and that applications built with CFML will run on top of application servers from other vendors. Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 Error
It's impossible to completely get rid of this error however you can minimize the chances of it happening. Look at the SQL books on line for advice on how to do this Justin -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 3:27 PM To: CF-Talk Subject: SQL Error Has anyone seen this error here before? What is the cause and the fix? ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #17) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. TIA, Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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)RE: ALLR/MACR Merger - ColdFusion to be repositioned ?????
I'm a programmer, not a disciple. Quick! someone get Ben Forta, and a high powered lamp.. ASP Bad CF Good.. J :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Releasing COM Objects from Memory
AFAIK , cf releases COM at the end of script execution. YOu chould do cfset myobj = nothing but I don't think there is any difference Justin -Original Message- From: Sandra Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 5:14 PM To: CF-Talk Subject: Releasing COM Objects from Memory Anyone know a good way to force CF to release a COM object from memory when we are finished with 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: How do I put the little image in the address bar in IE?
create a image called favorite.ico in the web root of the site. Justin -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 6:39 PM To: CF-Talk Subject: OT:How do I put the little image in the address bar in IE? Hi, I have a client who is hell-bent on having his logo appear in the IE address bar and when people bookmark his site. How is this done? It is IE only, right? Thanks, James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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-Talk FAQ
Well anyone interested I have the cffaq.org and cffaq.net domains If anyone to to a design, or write a section (eg XML, Oracle ,cfx ,MS Access) Let me know thanks Justin -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 10:11 AM To: CF-Talk Subject: RE: CF-Talk FAQ There was an attempt to do so on the HoF site itself but was never really used by anyone. http://www.houseoffusion.com/hof/faq/index.cfm Now, are we talking about FAQ for the CF-Talk list, or CF FAQ? Michael's done the List FAQ at this locn, but I definitely think we should do a CF FAQ to help stop the same-old-same-old questions Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Alphabetic List
What would you suggest ?? :-) Justin -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 4:36 PM To: CF-Talk Subject: RE: Alphabetic List I would recommend against using this method even if the field is indexed as this causes a full table scan to occur which will greatly degrade as it is used a lot and as the table grows in size. Jeremy Allen elliptIQ Inc. -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 12:27 PM To: CF-Talk Subject: Re: Alphabetic List You can do this in your SQL SELECT People Info WHERE LastName LIKE 'A%' This would be for people with last names that start with A. Kevin - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 26, 2001 10:13 AM Subject: Alphabetic List Hi, In Yahoo address book, they have this list for finding a particular person easily by the first letter of their last name: All - A B C D E F G H I J K L M N O P Q R S T U V W X Y Z - Lists Does anyone have any insights on how the algorithm of implementing this feature? For example, I have a user database, and I want to use this feature to find persons whose last name start with a particular letter. Thanks! Hong ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Slackware, CF, and MySQL
Dennis, there is a cf-linux list small amounts of msg - good quality mails [EMAIL PROTECTED] Lots of guys running that combo... Justin -Original Message- From: dennis baldwin [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 4:22 PM To: CF-Talk Subject: Slackware, CF, and MySQL Anyone runnin' CF with MySQL on Linux? I'm having problems setting up MySQL datasources through CF administrator. Every time I try to verify I get a failed connection. Any pointers would be greatly appreciated. Thanks, Dennis Baldwin ZAP Designs www.zapdesigns.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: Continuous Clock
or JavaScript as below script !-- function tick() { var hours, minutes, seconds, ap; var intHours, intMinutes, intSeconds; var today; today = new Date(); intHours = today.getHours(); intMinutes = today.getMinutes(); intSeconds = today.getSeconds(); if (intHours == 0) { hours = "12:"; ap = "Midnight"; } else if (intHours 12) hours = intHours+":"; ap = "A.M."; } else if (intHours == 12) { hours = "12:"; ap = "Noon"; } else { intHours = intHours - 12 hours = intHours + ":"; ap = "P.M."; } if (intMinutes 10) { minutes = "0"+intMinutes+":"; } else { minutes = intMinutes+":"; } if (intSeconds 10) { seconds = "0"+intSeconds+" "; } else { seconds = intSeconds+" "; } timeString = hours+minutes+seconds+ap; Clock.innerHTML = timeString; window.setTimeout("tick();", 100); } window.onload = tick; -- /script br div id=ReplaceMe style="font-family: verdana; font-size: 20;"What you type in below will replace this HTML/div Justin -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 5:09 PM To: CF-Talk Subject: RE: Continuous Clock Java is the only way - and even that is rusty at the best of times - the worst I've seen involved http refresh every second James -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: 25 January 2001 16:50 To: CF-Talk Subject: Continuous Clock I have a display clock that shows the time the user accessed the page but now they want a clock that shows the current time continuously. I have figured out countdown timers but is there an easy way to display the current time continuously? TIA cami ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: case sensitivity in stored procedures
Hi I'm not sure if you got this yesterday so I'm sending again Select * from MyTbl where convert(varbinary, column1) = convert(varbinary, 'ABCD') Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:55 PM To: CF-Talk Subject: RE: case sensitivity in stored procedures Nick, this was helpful, thanks - I didn't realize it was an installation option, and I've never seen it installed except with the default setting. I looked it up in BOL and it gives pretty good details. I'm sure I've been lazy enough with object names, etc. that I wouldn't want case-sensitivity ON - half my queries or code might fail. Well maybe not half, but some. I had been trying out some code with tests of exact (case-sensitive) words, such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems that the case-sensitivity setting relates to this too. As a result, SEcret, seCRET, SeCrEt, etc. all come up as LIKE the above expression. So it might be better to say that SQL Server is case-insensitive by default, period. Mark [EMAIL PROTECTED] Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql /8_ar_da_ 10.htm 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: Allaire on a Mac?
I'd say that CF will run on the mac , consider CF5 - Java base Java runs "anywhere" sortof :-) The new MRJ is quite fast. Cf runs on most *nixs MacOSx is pretty much *nix (sort of) Cfstudio is built on delphi Delphi is been ported to *nix (klix) OsX is *nix (sort of ) Justin -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 2:56 PM To: CF-Talk Subject: RE: Allaire on a Mac? I doubt it. Generator Server doesn't work on a Mac, and THAT's a Macromedia product. Besides, extending CF to a Mac Platform just seems WAY out in left field to me (and I *like* macs). And when I say left field... I mean on Mars. Maybe, possibly in the future if the OSX becomes the main mac platform and they can really starte treating the Mac OS more like a *nix platform. *** Maybe *** ... and still I'd say not for a few years even then. |-Original Message- |From: Randy Zeitman [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, January 23, 2001 8:58 AM |To: CF-Talk |Subject: Allaire on a Mac? | | |Anyone have any insight as to whether Allaire's apps will soon run on |Macintosh as a result of the merger with Macromedia? |-- |**This signature sponsored by GuitarList.com - the most powerful |musical instrument search engine on the net!** | |"I've gotten so out of shape sittin' at the computer all day that I |get out of breath when I have to reach for the percent key!" - |Zeitman | |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: HELP! - CFMAIL, Security and mail server
Check out iMS mail server free for the Special Edition , integrates perfectly with CF www.coolfusion.com Works great Justin -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:56 PM To: CF-Talk Subject: HELP! - CFMAIL, Security and mail server Hi All, I have a client whose internal IT department is unable to provide me with a name or IP address of a mail server to point my CF Server at. So now, I am on my own and not a network/mail guy. I have a CF box that is outside of the firewall, and I am faced with installing something to generate e-mail. I don't want something as big as exchange, and found some neat freeware for this. However, I don't want spammers getting the address, and using my gateway. Can I/How do I set up CFMAIL to use a username and password when accessing this mail server? Or do I just rely on "security by obscurity"? Any help appreciated... 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: case sensitivity in stored procedures
Yes, check out the SQL faq http://www.swynk.com/faq/sql/sqlserverfaq.asp Justin -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 5:34 PM To: CF-Talk Subject: RE: case sensitivity in stored procedures Can you do a case sensitivity comparison within a SQL Server stored procedure? Yes. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 on a Mac?
How do you do 3 button emulation on a one button Mac Mouse ??? :-) ~Justin Of course... But why would you buy a mac just to run Linux to finally make it useful? G Jeremy Allen elliptIQ Inc. -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 11:43 AM To: CF-Talk Subject: RE: Allaire on a Mac? http://www.yellowdoglinux.com/ Or just run linux on your Mac and make it real useful. Dave -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 9:30 AM To: CF-Talk Subject: RE: Allaire on a Mac? It is actually not that far fetched when one considers what OS X is. Granted its not needed since OS X will be a fringe OS for some time.. But the technical feasability of it is definately easy. In fact I bet you could get it working in OS X with VERY little coding at all. OS X is built on FreeBSD and a BSD kernel which have excellent Linux emulation. Take linux version of CF, run on OS X under emulation. A native port to another Unix is cake, they have three already, HP/UX, Solaris, Linux, moving to a BSD would not be much trouble at all (in relative terms to say porting it to MacOS) OS X *IS* another Unix.. Jeremy Allen elliptIQ Inc. -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 9:56 AM To: CF-Talk Subject: RE: Allaire on a Mac? I doubt it. Generator Server doesn't work on a Mac, and THAT's a Macromedia product. Besides, extending CF to a Mac Platform just seems WAY out in left field to me (and I *like* macs). And when I say left field... I mean on Mars. Maybe, possibly in the future if the OSX becomes the main mac platform and they can really starte treating the Mac OS more like a *nix platform. *** Maybe *** ... and still I'd say not for a few years even then. |-Original Message- |From: Randy Zeitman [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, January 23, 2001 8:58 AM |To: CF-Talk |Subject: Allaire on a Mac? | | |Anyone have any insight as to whether Allaire's apps will soon run on |Macintosh as a result of the merger with Macromedia? |-- |**This signature sponsored by GuitarList.com - the most powerful |musical instrument search engine on the net!** | |"I've gotten so out of shape sittin' at the computer all day that I |get out of breath when I have to reach for the percent key!" - |Zeitman | |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 IDE for *nix Mac etc ...was RE: Allaire on a Mac?
Anyone wants a nice cfstudio like IDE for *nix , Mac Windows Sun ?? Check out http://jedit.sourceforge.net don't dismiss it because is java - it's very fast. Make sure you install the plugins (tabs, cmd and project, ftp...) is you want a real cfstudio type interface .. You can customise it (eg add close buffer to right click) I'm working on a DB plugin for it... Justin -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:53 PM To: CF-Talk Subject: Re: Allaire on a Mac? I don't know if I'd like CFserver on a Mac or not, but I'd like to see the IDE's (Studio/HomeSite) ported over (to Linux as well, though I know there are some code issues there) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Randy Zeitman wrote: Anyone have any insight as to whether Allaire's apps will soon run on Macintosh as a result of the merger with Macromedia? -- **This signature sponsored by GuitarList.com - the most powerful musical instrument search engine on the net!** "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman 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: chmod
chmod o=rwx filename JUstin -Original Message- From: Yvette Ingram [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 4:06 PM To: CF-Talk Subject: Re: chmod Jay: From back in my Unix days, I think that's 777 Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: ingramrecruiting@erols or [EMAIL PROTECTED] ICQ: 21200397 - Original Message - From: Jay Patton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 7:28 PM Subject: chmod does anyone remember or know the chmod number to make a file readable writeable and executable by everyone? i cant remember it thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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: chmod
You are going to get someone in trouble :-) no /dev/null jokes please Justin -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 11:07 AM To: CF-Talk Subject: Re: chmod rm -rf / sorry couldn't resist ;-) jon - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 22, 2001 5:59 AM Subject: RE: chmod chmod o=rwx filename JUstin -Original Message- From: Yvette Ingram [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 4:06 PM To: CF-Talk Subject: Re: chmod Jay: From back in my Unix days, I think that's 777 Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: ingramrecruiting@erols or [EMAIL PROTECTED] ICQ: 21200397 - Original Message - From: Jay Patton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 7:28 PM Subject: chmod does anyone remember or know the chmod number to make a file readable writeable and executable by everyone? i cant remember it thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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: CF Server Error
Can we see the code that gives you this ? Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 1:55 PM To: CF-Talk Subject: FW: CF Server Error Anyone ideas on this one? Mike Connolly Web Developer New Media Rocom Group Limited Tel: 01937 84 74 96 Web: http://www.rocom.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 22 January 2001 09:16 To: CF-Talk Subject: CF Server Error Has anyone ever come across this error with CF Server 4.5.. "CFMLInterpreterImp::executepcode" If so, what measures were taken to alleviate it? Regards Mike Connolly ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 Server Error
Some things Non treadsafe CFX tags File locking issues Reading / writing session application variables underload with locks. + Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 2:25 PM To: CF-Talk Subject: RE: CF Server Error It's more of a generic question, as we cannot uniquely identify the erroneous code. To re-word the question slightly, Does anyone know what CF tags / scenarios maybe causing this error to appear? -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: 22 January 2001 14:16 To: CF-Talk Subject: RE: CF Server Error Can we see the code that gives you this ? Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 1:55 PM To: CF-Talk Subject: FW: CF Server Error Anyone ideas on this one? Mike Connolly Web Developer New Media Rocom Group Limited Tel: 01937 84 74 96 Web: http://www.rocom.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 22 January 2001 09:16 To: CF-Talk Subject: CF Server Error Has anyone ever come across this error with CF Server 4.5.. "CFMLInterpreterImp::executepcode" If so, what measures were taken to alleviate it? Regards Mike Connolly ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Perl Question
use CGI qw(:standard); print redirect('http://www.houseoffusion.com'); Justin [EMAIL PROTECTED] -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 2:50 PM To: CF-Talk Subject: Fw: Perl Question - Original Message - From: "Kevin Schmidt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 11:09 AM Subject: OT: Perl Question Got a perl cgi and after I am finished processing I want to redirect the user to another URL similar to the Cflocation tag. Anybody know how? Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.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: CF games
There is a vbscript version of hangman on the MS scripting site. Java or DHTML would be best for the crossword Depends in the browsers you need to support Justin -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 2:49 PM To: CF-Talk Subject: CF games We have a new project that requires "Games". I need to find a few classic English teaching games, Hangman, crossword puzzles and the like. Has anyone seen or written these game in CF? Or for that matter in java script? 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: Variable Names with -
Hack: Select XML_F52E2B61-18A1-11d1-B105-00805F49916B as myxml From table Now use #myxml# in CF Justin -Original Message- From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 2:58 PM To: CF-Talk Subject: RE: Variable Names with "-" The problem with this is that I am working with a Microsoft product that has a mind of its own. The SQL statement looks like this: SELECT * FROM TABLE for xml auto,elements It returns a one column result whose name is XML_F52E2B61-18A1-11d1-B105-00805F49916B and the xml is broken up to a certain number of characters per line. What I want to do is to put that back together as a single xml string that I can get my hands on, but because of the name that Microsoft creates, I can't loop through it with Cold Fusion. If anyone has any suggestions on how to get at this strange Microsoft column with Cold Fusion, I would greatly appreciate it. Thanks. -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 9:37 PM To: CF-Talk Subject: RE: Varaible Names with "-" You could do the following if you don't have control of the DB:-) cfquery name="qtest: datasource="datasource" select `field-name` as FieldName from TableName /cfquery Notice the ` which is located under the tilda(~) key this will return the fieldname as it was written in the DB. However you can't use this with CF, so using the as command this will rename the field to anything you want it to be. So you could then reference it instead of qtest.field-name, but as qtest.FieldName instead. Hope this helps:-) regards Andrew Scott Senior Cold Fusion Application Developer ANZ Business eCommerce * Ph 8615 6018 * [EMAIL PROTECTED] --- This e-mail and any attachments to it (the "Communication") is confidential and is for the use only of the intended recipient. The Communication may contain copyright material of Australia and New Zealand Banking Group Limited ABN 11 005 357 522 ("ANZ"), or any of its related entities or of third parties. If you are not the intended recipient of the Communication, please notify the sender immediately by return e-mail, delete the Communication, and do not read, copy, print, retransmit, store or act in reliance on the Communication. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of ANZ. ANZ does not guarantee the integrity of the Communication, or that it is free from errors, viruses or interference. -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 10:09 To: CF-Talk Subject: RE: Varaible Names with "-" This probably isn't the answer you're looking for, but you should rename the column. That's just plain bad database design to begin with. And there's no need to add on another layer of unnecessary programming when all you've gotta do is rename the field. ---mark -- Mark Warrick Phone: (714) 547-5386 Fax: (714) 972-2181 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 10:00 AM To: CF-Talk Subject: Varaible Names with "-" Is there any way to pull out the information about a query column that has a "-" in it? The problem is that with SQL Server 2000, when you do a "for xml" select statement, the column name that is returned has "-"s in it. From the documentation in SQL Server 2000, I am not seeing a name to rename that. I am trying to pull out the xml from this query, but in order to do this, I need to get at the data with a column name that has a "-" in it. If anyone has any suggestions, please let me know. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server export/import preserving diagrams
You can get a script to export diagrams from http://www.swynk.com/sqlhome/7library.asp Justin -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 2:11 PM To: CF-Talk Subject: SQL Server export/import preserving diagrams If you import/export databases between two SQL Server 7 boxes, you seem to always lose the diagrams. If you go in and recreate the diagram on the new machine, all the relationship information seems to have been preserved, however. Are the diagrams the only thing you lose? And is there any way to retain them whilst importing/exporting? Thanks -- 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
FW: Running a MS SQL Server DTS Package from ColdFusion
-Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 8:50 PM To: [EMAIL PROTECTED] Subject: RE: Running a MS SQL Server DTS Package from ColdFusion options: use cfexeccute and rundts use xp_cmdshell create a job run it or you can run that code using cfobject as per the MS example cfset DTSReposFlag_Default = 0 cfset DTSReposFlag_UseTrustedConnection = 256 CFOBJECT ACTION="Create"TYPE="COM"CLASS=DTS.Package NAME="oPackage" cfset oPackage.LoadFromSQLServer ('servername','','',256,'','','','MyPackage','') cfset oPackage.Execute() Justin -Original Message- From: Percy E Perez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 6:14 PM To: CF-Talk Subject: Running a MS SQL Server DTS Package from ColdFusion Anyone has any suggestions on how to run a DTS package from a coldfusion page? I found article# Q252987 on technet on how to do this using ASP, but I would rather implemented in ColdFusion. Thank you for any suggestions. Percy E Perez -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 11:59 AM To: CF-Talk Subject: RE: SQL Manager Yep, this will be taken care of soon. -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 10:44 AM To: CF-Talk Subject: RE: SQL Manager yep, I would NEVER want anyone connecting to the Master DB. I always keep my SQL Servers on the inside of the firewall allowing no access from the outside world - only from the cf server. Neil ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] 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
RE: Short Circuit Evaluation
CFIF (isDefined("somevar") AND somevar IS "something") do something cfelse do nothing /CFIF JUstin -Original Message- From: Ruslan Sivak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 3:12 PM To: CF-Talk Subject: Short Circuit Evaluation I have had to write this kind of code over and over, and was wondering if there is a better way like in c++, where it does lazy evaluation. This is what I want: CFIF isDefined("somevar") AND somevar IS "something" do something /CFIF Of course this fails, since if the variable is not defined, CF stil checks the second condition. In languages like C++, it did lazy evaluation, so if the first condition was false, it didn't bother checking the second condition. This let people write things like open(FILE,"file") || die "Can't open file"; So in CF I have to rewrite my above IF statement as 2 statements CFIF isDefined("somevar") CFIF somevar IS "something" do something /CFIF /CFIF Is there a better way? Ruslan Sivak Technologist ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Storing/Encrypting Credit Cards
hi Do you know whats is the deal on the cfx_vpn ?? Also are these c++ or Java tags?? Of course doing the 128bit etc in Java wouldn't be too difficult Justin Just a note on encrypting. I know of a company getting ready to release a strong encryption tag that will use 128bit ryndahl encryption algorithm. look at www.cfxworks.com for more info. Actually there site is still under construction, but will be ready soon. It should be released very ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Window 95 Log?
If you got a firewall you could check the log of that. Or if you are talking about a webservice there is a log for personal webservice Justin -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 4:25 PM To: CF-Talk Subject: Re: OT: Window 95 Log? At 09:25 1/17/01 -0600, you wrote: What Log file will tell me if someone has logged into a windows 95 computer? What other then a cmos password can protect a windows? Nothing, unless there is some third party tool, which still would not be very secure, Win9X (or ME I imagine) is just not a very secure OS. R ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: cfobject question
Nick you might like to use CreateObject("COM", dmoObj) etc so you can do all your COM stuff in cfscript block cfscript x = CreateObject("COM", dmoObj); strEntityType = ; strEntityName = ; thisDatabase = dmoObj.Databases(strDb); /cfscript or whatever... Justin -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 11:16 AM To: CF-Talk Subject: RE: cfobject question Clint, Something like this should do it cfobject.. name="dmoObj" cfset strDb = ... cfset strEntityType = ... cfset strEntityName = ... cfscript thisDatabase = dmoObj.Databases(strDb); /cfscript cfswitch expression="#strEntityType#" cfcase value="Tables" cfset dmoCollection = thisDatabase.Tables cfset strImage = "images/table.gif" cfif strEntityName is not "" cfscript dmoEntities = dmoCollection(strEntityName).Columns; /cfscript /cfif /cfcase cfcase value="Views" cfset dmoCollection = thisDatabase.Views cfset strImage = "images/view.gif" /cfcase cfcase value="Stored_Procedures" cfset dmoCollection = thisDatabase.StoredProcedures cfset strImage = "images/sp.gif" /cfcase cfcase value="Users" cfset dmoCollection = thisDatabase.Users cfset strImage = "images/users.gif" /cfcase cfdefaultcase /cfdefaultcase /cfswitch -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 4:46 PM To: CF-Talk Subject: cfobject question I need to find out if cfboject can an equivalent to this ASP code: With dmoServer.Databases(strDb) Select Case strEntityType Case "Tables": Set dmoCollection = .Tables strImage = "images/table.gif" if strEntityName "" then set dmoEntities = dmoCollection(strEntityName).Columns end if Case "Views": Set dmoCollection = .Views strImage = "images/view.gif" Case "Stored_Procedures": Set dmoCollection = .StoredProcedures strImage = "images/sp.gif" Case "Users": Set dmoCollection = .Users strImage = "images/user.gif" End Select Basically what this is doing is using the SQLDMO object to get a list of tables,views,sprocs,or users depending on what the strEntityName is. I cannot reproduce this in CF. Can someone help me? -Clint ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: How do I work with XML?
Get started here http://www.siteobjects.com/index.cfm?fuseaction=showproducts Justin -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 4:46 PM To: CF-Talk Subject: How do I work with XML? I'm going to be getting database updates as xml doc's from a third party. Can somebody give me some direction on working with this? I need to know how I can first import the data into a SQL 7.0 database, then how to work with it using CF. Any direction would be very helpful. 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
RE: Copying tables thru ODBC
I believe there is a article on this very topic on cfadvisor Justin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: How do I work with XML?
Hey Jeremy, You checked out JAXP?? It's real nice. Justin -Your own custom CFX using SAX in Java or C++, or a third party solution. Jeremy Allen elliptIQ Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Running a MS SQL Server DTS Package from ColdFusion
options: use cfexeccute and rundts use xp_cmdshell create a job run it or you can run that code using cfobject as per the MS example cfset DTSReposFlag_Default = 0 cfset DTSReposFlag_UseTrustedConnection = 256 CFOBJECT ACTION="Create"TYPE="COM"CLASS=DTS.Package NAME="oPackage" cfset oPackage.LoadFromSQLServer ('servername','','',256,'','','','MyPackage','') cfset oPackage.Execute() Justin -Original Message- From: Percy E Perez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 6:14 PM To: CF-Talk Subject: Running a MS SQL Server DTS Package from ColdFusion Anyone has any suggestions on how to run a DTS package from a coldfusion page? I found article# Q252987 on technet on how to do this using ASP, but I would rather implemented in ColdFusion. Thank you for any suggestions. Percy E Perez -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 11:59 AM To: CF-Talk Subject: RE: SQL Manager Yep, this will be taken care of soon. -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 10:44 AM To: CF-Talk Subject: RE: SQL Manager yep, I would NEVER want anyone connecting to the Master DB. I always keep my SQL Servers on the inside of the firewall allowing no access from the outside world - only from the cf server. Neil ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] 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
RE: cfobject question
If you are using SQL Server check out the system stored procedures sp_tables (returns view or tables) sp_columns sp_stored_procedures sp_helplogins Haven't got time to get into the SQLDMO stuff ~ Justin -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 4:46 PM To: CF-Talk Subject: cfobject question I need to find out if cfboject can an equivalent to this ASP code: With dmoServer.Databases(strDb) Select Case strEntityType Case "Tables": Set dmoCollection = .Tables strImage = "images/table.gif" if strEntityName "" then set dmoEntities = dmoCollection(strEntityName).Columns end if Case "Views": Set dmoCollection = .Views strImage = "images/view.gif" Case "Stored_Procedures": Set dmoCollection = .StoredProcedures strImage = "images/sp.gif" Case "Users": Set dmoCollection = .Users strImage = "images/user.gif" End Select Basically what this is doing is using the SQLDMO object to get a list of tables,views,sprocs,or users depending on what the strEntityName is. I cannot reproduce this in CF. Can someone help me? -Clint ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Calling JavaScript when loading custom tag.
Yeah you can just do script Function() /script from where-ever in your page. Justin -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 3:40 PM To: CF-Talk Subject: Calling JavaScript when loading custom tag. I'm working on a custom tag that has a JavaScript function in it that needs to be called when the tag is loaded. I tried using body onload="function();", but that doesn't work. Is there another way to call a function on load from a 'page' nested inside another page? My knowledge of JavaScript isn't all the great :( Todd Ashworth ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFMail Time Stamp
Is this the second error of this type I've seen on the list? 2001 bug ? ~ Justin -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 6:20 PM To: CF-Talk Subject: CFMail Time Stamp I have a problem with the time stamp on messages sent through cfmail. My servers clock is set at GMT -0500 but CFMail messages are being stamped with + 0400 wich is affecting the time sent by about 9 hours. Anyone have any insight as to why this is happening or where I go to correct it? Thanks, Chris Stoner ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Distributed Processing regarding CF and a separate Web Server
I agree with all that Eric said regarding this. Just to add I heard that proformance is dreadful using this method There is a stub called(?) cfdist.exe to allow you do this. ~ Justin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX for Cobol
David , doing WDDX in java isn't too hard.. there are examples in wddx SDK. Otherwise there is Perl wddx? Using | could get ugly.. some sort of encoded is going to be needed... Justin -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 3:10 PM To: CF-Talk Subject: Re: WDDX for Cobol In production we will not have ODBC connectivity to the database, but will only be calling a stored procedure which executes a COBOL routine. Right now I am getting a huge string back, delimited by the | character. The downside is that the client side of this is in JSP. My parsing skills in Java just aren't what they are in CF. DC - Original Message - From: "Robert Everland" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 10:04 Subject: RE: WDDX for Cobol Well if you have Client access to connect to the AS/400 and it's using an offshoot of DB2 somewhere which AS/400 usually uses, you should be able to query the database with an odbc connection. We do this now with AS/400 and RPG. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 9:59 AM To: CF-Talk Subject: WDDX for Cobol I know this sounds like a completely lame question, but has anyone attempted to create a WDDX component for COBOL? I have a legacy system integration project that would be greatly simplified with the ability to have WDDX or other XML component to deal with some data transfer. This is on an AS400. DC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: cfquery
Thats Sql Server only (access too?) . cfquery maxrows=1 might be better Justin cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC" Select top 1 * from UnitPages where ArticleUnit = '#form.units#' order by ArticleDate DESC /cfquery This will literally return the top row, and nothing else ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Query confusion - CF not recognising query name
Why not put debugging on for your IP only??? I can't put debugging on as it's a production server - I don't have the data on my test machine to use, and the amount of data is huge to download As I said - it's confusing the hell out of me. Philip Arnold Also you chould RUN SQLtrace to see whats going on. These kind of issues Usually are a result of silly mistakes. I know mind are. Get someone else there to look at the code, might pick it up staight away. Justin MacCarthy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: aliasing using cfmail
By compliant I sure Howie means "compliant with the mail RFCs" , but Howie is the resident email expert :-) Check out http://www.tac.nyc.ny.us/mail/rfc-index.html Some mail server will "fix" the address though ... Justin cf-talk Mail 19 number of 2001 :-) -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:40 PM To: CF-Talk Subject: Re: aliasing using cfmail Could you elaborate on what you mean by 'compliant.' I ask because my test worked both with and without quotes. Is it an issue of different mail servers and clients? -- Owen - Athens County Library Services http://www.athenscounty.lib.oh.us - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] Subject: Re: aliasing using cfmail To be compliant, the "friendly name" needs to be delimited by quotes and the actual address needs to be delimited by brackets as follows: "friendly name" [EMAIL PROTECTED] HTH, Howie Hamlin - inFusion Project Manager - Original Message - From: "Rick Lamb" [EMAIL PROTECTED] Subject: aliasing using cfmail Do any of you guys know how to alias the "from" parameter as to include a display name along with the email address? EG: cfmail from="Rick [[EMAIL PROTECTED]]" /cfmail Thx! 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
RE: Contract work??? OT
There is a cf-jobs mailing list @ houseoffusion, also I believe there is a JobPosting section at the http://www.acfug.org/ web site. Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:39 PM To: CF-Talk Subject: Contract work??? OT Hello all, I have been developing in ColdFusion, Sql Server, DB400(AS/400), Oracle, ASP, JavaScript, Html on NT/2000 Platforms.. Do you guys know any website/company that outsources/sub-contracts Projects/Contracts. Preferably Remote Development. Appreciate it. Sorry for the OT question. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFHEADER
You could use "application/unknown" as your content type ??? Justin -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 6:34 PM To: CF-Talk Subject: CFHEADER It seems the following won't work, well in at least IE5.5. CFHEADER NAME="Content-Disposition" VALUE="attachment;filename=#attributes.fname#" CFCONTENT TYPE="application/pdf" FILE="#fnp#" It instead opens the page up for download instead of the file. So lets say I have peter.pdf as my attributes.fname and download.cfm is the page the above code is on. And lets say that it's called from index.cfm. Well index.htm appears in the download file box, not peter.pdf. It seems to work ok in Netscape, so I can't believe I'm the only one having this problem. I've seen similar looking code on the Allaire site, but it's still not working. Can anyone help with this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion controlled CD-RW
If I were you I'd look for some Open Source CD-RW software , that has been ported to Windows. That will give you the most options.. Try , freshmeat.org and gnu.org etc.. Justin -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 12:53 AM To: CF-Talk Subject: RE: Cold Fusion controlled CD-RW Know of any software that takes command line commands? I don't. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 11:49 AM To: CF-Talk Subject: RE: Cold Fusion controlled CD-RW cfexecute and sw that takes command line parameters -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: 04 January 2001 17:12 To: CF-Talk Subject: Cold Fusion controlled CD-RW I was just wondering if anyone knows a way to control a CD-RW drive in Cold Fusion? Just think it would be cool to be able to burn cds over the intranet or internet on my server. If anyone knows a way to do this even without cold fusion, I am willing to take suggestions. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Calendar Question
Here you are. cfscript // replace now() with whatever date you are using. year = year(now()); month = month(now()); FirstDateOfMonth = CreateDate(year,month,1); LastDateOfMonth = CreateDate(year,month,DaysInMonth(FirstDateOfMonth)); FirstDayOfMonth = DayOfWeek(FirstDateOfMonth); StartPadding = FirstDayOfMonth - 1; FirstDateToShow = DateAdd('d',-StartPadding,FirstDateOfMonth); LastDayOfMonth = DayOfWeek(LastDateOfMonth); EndPadding = 7 - LastDayOfMonth; LastDateToShow = DateAdd('d',EndPadding,LastDateOfMonth); DaysInMonthToShow = DateDiff('d',FirstDateToShow,LastDateToShow) + 1; NumberOfRows = DaysInMonthToShow / 7; /cfscript There is a slightly faster way to do this. Hope this is helpful Justin MacCarthy Ireland -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 10:17 PM To: CF-Talk Subject: Calendar Question 1) Does anyone have a fool proof formula from coming up with the number of rows in a calendar for a month. I've tried a couple of things but with no luck. TIA, Duane Boudreau CEO/CTO, CFExperts ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Cold Fusion controlled CD-RW
Check out http://www.cfcomet.com/ for lots of CF - COM examples Justin -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 1:25 AM To: CF-Talk Subject: RE: Cold Fusion controlled CD-RW I haven't dealt with COM objects before. Will have to look in to learning about doing that. Thanx Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 12:47 PM To: CF-Talk Subject: Re: Cold Fusion controlled CD-RW This would be a simple matter of controlling a COM object. If there's already a burner app (like Adaptec Easy CD) installed, you may be able to tap into it's objects.. otherwise, it wouldn't be too hard to tie into the ASPI drivers with your own solution. -- Billy Cravens [EMAIL PROTECTED] Bernd VanSkiver wrote: I was just wondering if anyone knows a way to control a CD-RW drive in Cold Fusion? Just think it would be cool to be able to burn cds over the intranet or internet on my server. If anyone knows a way to do this even without cold fusion, I am willing to take suggestions. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Regular Expression Gurus Please Help!
Try this instead of a re #Replacelist("+44 (0) 7799 657093","+, ,(,)","")# Justin -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 10:47 AM To: CF-Talk Subject: OT: Regular Expression Gurus Please Help! I'm really bad at these so maybe one of you has some ideas, basically I'm trying to create a reg ex to run against a list of cell phone numbers. I need to strip out + signs as well as brackets () and spaces " " the expression I'm using is: cfoutput #REReplace("+44 (0) 7799 657093","+| |(|)","","ALL")# /cfoutput It only takes out the spaces when I run it :-( I bet the answer is really simple but I just can't figure it out... Thanks in advance, - =Ed ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Slightly OT
A couple of comments on this: I used to work for one of the first ISP on Europe, we used mostly Linux + Gnu etc. We supplied Mosaic and then Netscape 1.2 , Netscape 3 etc . Then of course Microsoft looked at the WEB. They gave us IDC (awful) and huge amounts of money / support etc... They gave us IE, to distribute for free. (Netscape wanted a license fee). As time went on we used ASP, Commerce Server, etc...mostly for costly , Microsoft supported projects. etc .etc One problem their products were for the most part crap, even for free. We mapped ..asp files to Perl on Linux and reported our servers as NT. Generally we used Perl, C Scripting Linux Sendmail etc to our work. CF made appearance internally around CFv1.5 (It's come a long way :-) and we used from then on for various stuff ) Having said all that ASP is pretty good now, ASP+ even better. Win2000 is starting to mature and in general MS Web products are getting better. As for ASP being difficult, well it's all relative. There are some things that are "easier" to do in ASP, the same way the things that are easier in Java or C or assembly etc... For a non-programmer the tagged syntax of CF might be easier , more natural; but for a programmer well why can't I do cfset x++ for example ??? Is it easier to do cfset x = x + 1 As for maintainable code well you can write crap code in any language. It all comes down to the problem and the resources you have. I think in Europe there is a tradition of using open source products , maybe because European Companies don't demand that there is "a company" to support languages they use. They trust the community more than one company (i.e. Microsoft). Also the Cost of the product used to be an issue on Europe (not really any more). This is different in the states. As for the impact of CF Allaire in Europe, well it's exploding from I've seen since v1.5 . The JRun purchase will definitely add to those interested in Allaire. Maybe you are using Linux yourself bflynn??? :-) "Flames/dev/null"? A lot of people call that arcane. (and for the end user (my dad) they might still be right but I love it as a programmer ) Anyway just my thoughts Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 1:14 PM To: CF-Talk Subject: RE: Slightly OT Sorry, but I have to comment - (engage soapbox mode) Managers that choose ASP over CF are showing that they have no business being a manager. I've done both. My first reaction to ASP was "Why is this so difficult?" My first reaction to CF was "Wow, someone finally made it simple." Anyone that chooses the cheap implementation over something that is maintainable is not someone that I want to work with/for. Software development is hard enough already...we don't need to make it harder by choosing arcane scripting languages. (ok, I'm done) Thanks - I feel better now. Flames/dev/null. Brian -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 5:28 AM To: CF-Talk Subject: RE: Slightly OT The problem with this is that often, the people controlling the purse strings are not developers, they are BIS managers brought in to control budgets and strategy. I am pretty sure that this is why. They don't see a difference as long as the functionality is the same. Try asking a senior manager what RAD is. -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] But ... in my humble opinion you can easily justify the purchase of a CF server license when your development time is reduced AND THAT IS A FACT! My 5 cents! Allan Pichler Machine Dreams Inc. -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 2:18 AM To: CF-Talk Subject: RE: Slightly OT I think that possibly Microsoft (therefore ASP) has a stronger marketing machine here because our technology centres are not as guided. European countries are behind the US in software development and also in pricing. As an indication, CF Server Pro costs £1300 ish over here. It is $1200(?) in the US, so yes, thats a big difference, even for a one time purchase. -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: 05 January 2001 10:16 To: CF-Talk Subject: RE: Slightly OT That's actually a very interesting point to bring up It seems that almost all european countries uses php/asp whereas over here the market has room for all of the scripting languages is it the price for a license that scares companies in europe ?? Allan Pichler Machine Dreams Inc. -Original Message- From: Martin Sutton [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 2:07 AM To: CF-Talk Subject: RE: Slightly OT Do UUnet have a CF hosting service? Jason, any ISP that allows dedicated servers (if thats what you require) will host CF. The only problem you may come across is in the use of RDS which some
RE: And the award goes to ......
Damn DWatt's I'll get him this year - Dave remember it's quality not quantity :-) Justin ([EMAIL PROTECTED]) -Original Message- From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]] CF-talk posts for the year 2000 total 48,444 [EMAIL PROTECTED] 1,644 others in the top 20 are : [EMAIL PROTECTED] 517 [EMAIL PROTECTED]460 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Anybody using CF 4.5.1 sp2 on RedHat 7.0 with Sybase 11.9.2
Marcus there is a Cf-linux list @ houseoffusion.com. You would get more help there. Also I'm not sure if you looked here http://www.allaire.com/developer/TechnologyReference/linux.cfm Justin -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 2:28 AM To: CF-Talk Subject: OT:Anybody using CF 4.5.1 sp2 on RedHat 7.0 with Sybase 11.9.2 and can share some info. I am interested in any problems, unusual setup procedures etc Thank you Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: a cry out for help
Hi Nick, you using IIS5 or Apache ? If you are you could use webDav which would do all that stuff for, and allow them to save file directly from Word excell etc using web Folders. As for Upper management has given me 6 hours No is an important word in programming. Justin -Original Message- From: Nick Call [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 3:35 PM To: CF-Talk Subject: a cry out for help Hi: I have a good one for you. Upper management has given me 6 hours to come up with (basically) a CF version of Source Safe. They want to be able to publish important company docs, like the strategic business plan for 2001 (in MS Word), and allow certain members of management to check it out, download it, revise it, and re-upload it without overwriting old versions. It has to track revision dates, author, etc. And it has to be idiot-proof, becuase they admit that they are Internet idiots. Has anyone built this system before in CF? If so, how much? Help. Nick [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: oracle/SQL7 migration... keep finding little tricks - HELP
Hi there, for example, SQL7 will order a column with NULL values at the top, while Oracle will order them at the bottom. sorted by MSSQL7: NULL, NULL, NULL, 1, 2, 3 sorted by Oracle: 1, 2, 3, NULL, NULL, NULL In SQL7 server: Null values are treated as the lowest possible values.To reverse this you use DESC ASC case sensitivity also throws off ordering, oracle will order all uppercase before ordering lowercase: sorted by MSSQL7: jones, Smith, thomas, White sorted by Oracle: Smith, White, jones, thomas SQL 7 has the following ordering options: Dictionary order, case-insensitive Binary2 Dictionary order, case-sensitive Dictionary order, case-insensitive, uppercase preference Dictionary order, case-insensitive, accent-insensitive Some Oracle stuff http://www.cffaq.net/cf_and_oracle.cfm http://www.cffaq.org/procparam.htm Justin MacCarthy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: coldfusion xml guru wanted for a small job
As far as I know the DMOZ stuff is RDF not XML ??? Justin -Original Message- From: Martin Orth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 4:42 PM To: CF-Talk Subject: coldfusion xml guru wanted for a small job Hi, I am searching for a coldfusion xml guru for a small job. TODO: 1. Import a xml directory structue like the one from yahoo to a database. 2. Import the directory entrys into a database. 3. Write a short documentation, so that it is possible to import all the data again. Please first take a short look at www.quendo.com. It is a link directory like www.dmoz.org or www.yahoo.com. All the categories and the links with descriptions are from www.dmoz.org. It is not the whole directory. It´s only http://www.dmoz.org/World/Deutsch/ and so on. The problem is that all the data is in two verry big xml files. I want the data in two or maybe three database tables. The solution for me would be a kind of import tool writen in coldfusion and of course a dll or a cfx_customtag for deserialisation. I think I need two main tables: 1. categories 2. links The categories table should have the following columns: id, parent_id, categorie_name and alias_id. The links table should have the following columns: id, categorie_id, url, title, description. Please write me a short eMail if you can do this job and please write some words about the time and money you need to do this. Thanks Martin -- Martin Orth - CFSOLUTIONS Oberblissenbach 30 - 51515 Kuerten Tel. 02207 700652 - [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: Executing SQL server DTS packages from CF...
You could run them using "dtsrun" with xp_cmdshell or create a job and run it using sp_start_job Justin MacCarthy -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 5:02 PM To: CF-Talk Subject: Executing SQL server DTS packages from CF... Hi, I have a number of DTS packages written for importing multiple text files into SQL Server (part of a process which sets up indexes/relationships for a temp copy of the db, then imports a number of table in a specified order from text files, checking referential integrity, and if they imported without any errors, drop the Live tables, rename the temp tables, indexes, and relationships to the names of the live ones...) Now, the SQL for dropping and renaming works fine, and I can put all that into stored procedures which I can execute from cf. The problem comes with running the DTS packages in CF - looking at the SQL documentation, I dont see quite how it could be done - they seem to need to run through Enterprise manager Can anyone help me? The alternative of using CFFILE to import and manually checking all the referential integrity does not thrill me - it would take much longer to create, and be far less efficient in execution... Any Ideas would be much appreciated... Cheers Dan. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Re[2]: Generating unique values
But it doesn't create values which are not easy to guess. Two consecutive UUID will have similar values + 1 Justin -Original Message- From: listmb [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 31, 2000 10:01 PM To: CF-Talk Subject: Re[2]: Generating unique values Thanks Nick, That was just what I was looking for! Best, WayGee Hello Nick, Sunday, December 31, 2000, 4:00:40 PM, you wrote: NM You can use the CreateUUID function. NM It generates a Universally Unique ID. It does contain both letters and numbers. NM At 03:58 PM 12/31/2000 -0500, you wrote: Hi, Being new to cold fusion (1 week), can anyone let me know if there is a way to create unique random numbers or strings in cold fusion? It should not be iterative or easily guessed. This would help alot! -- Best regards, WayGee mailto:[EMAIL PROTECTED] NM ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[4]: Generating unique values
Depends what you want to do but something like : cfset keylength = 10 ! length of key - cfset key ="" !--- the key "" to start cfloop from=1 to=keylength index=idx !--- you might want to change this, to use a different set of charactors if being used in a url for example--- cfset chrindex = RandRange(65, 126) ! build the key - cfset key = key Chr(chrindex) /cfloop !--- output the key --- cfoutput #key# /cfoutput Justin MacCarthy -Original Message- From: listmb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:50 PM To: CF-Talk Subject: Re[4]: Generating unique values Thanks this sounds like they are using a guid call to generate this. Is there some other algorihth i could use or ways I could do this? Thanks, WayGee Hello JustinMacCarthy, Tuesday, January 02, 2001, 6:15:41 AM, you wrote: J But it doesn't create values which are not easy to guess. J Two consecutive UUID will have similar values + 1 J Justin -Original Message- From: listmb [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 31, 2000 10:01 PM To: CF-Talk Subject: Re[2]: Generating unique values Thanks Nick, That was just what I was looking for! Best, WayGee Hello Nick, Sunday, December 31, 2000, 4:00:40 PM, you wrote: NM You can use the CreateUUID function. NM It generates a Universally Unique ID. It does contain both letters and numbers. NM At 03:58 PM 12/31/2000 -0500, you wrote: Hi, Being new to cold fusion (1 week), can anyone let me know if there is a way to create unique random numbers or strings in cold fusion? It should not be iterative or easily guessed. This would help alot! -- Best regards, WayGee mailto:[EMAIL PROTECTED] NM J ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Admin E-mail (newbie level question)
CFERROR TYPE="Request" or "Validation" or "Monitor" or "Exception" TEMPLATE="template_path" MAILTO="email_address" EXCEPTION="exception_type" Justin -Original Message- From: Scott Wolf [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 2:46 PM To: CF-Talk Subject: Admin E-mail (newbie level question) My brain has completely locked up on me (must had a bit too much to drink on Sunday), but I can't remember how to change the admin e-mail for a specific application. The CF-Administrator says it's possible, but I can't find it in the docs. If someone could help me, I'd really appreciate it. Thanks in advance, and Happy New Year! Scott Wolf ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preparing for CF certification...
Just make sure who know the blink tag :-) ~Cynical Justin Hi folks. I'm thinking about going for my Allaire CF Certification in the moderately near future. What are some of the things I can do to help prepare? Thanks and hope you all had a happy and safe New Year's! Jamie ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists