Re: Host provider needed
does he need the shopping solution as well as the hosting? I have a complete store I worked on for most of last year that has been running flawlessly :) -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: "Bryan LaPlante" <[EMAIL PROTECTED]> Date: Wed, 11 Jul 2001 00:29:24 -0500 Subject: Host provider needed > I have a friend that is looking for a Cold Fusion host that supports > a web > based shopping cart client so that he does not need to know > programming to > sell his products. Any body have suggestions. > > Bryan LaPlante > 816-347-8220 > [EMAIL PROTECTED] > http://www.netwebapps.com > Web Development > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Host provider needed
I have a friend that is looking for a Cold Fusion host that supports a web based shopping cart client so that he does not need to know programming to sell his products. Any body have suggestions. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Missing Native Driver Page in CF Server 5.0
I had confirmed my CF 5.0 is the Enterprise Edition. Have anyone else installed CF 5.0 already? Did you see your Native Drivers Page under the Data Source option? -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 11:29 AM To: CF-Talk Subject: Re: Missing Native Driver Page in CF Server 5.0 Native drivers are available only on the Enterprise Edition. Probably you have the Professional one. 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 - Original Message - From: "JAIME HOI" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:57 PM Subject: Missing Native Driver Page in CF Server 5.0 > > hi > i can't seem to find this Native Driver Page under Data Source > setting in my CF Server 5.0. Any one out there tried this already? > > > > Victory is in the mind of those who believe and who believe the longest > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Printing & CFEXECUTE
What's the command line parameter and flag to print a document? Can I choose the printer or is default all I get? I want to use it with CFEXECUTE to print to the web server's printer on our Intranet. 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: OT - Allaire website
> Is anyone else getting *very* slow searches on the Dev-Exchange site? Allaire's ColdFusion is slightly slower than Macromedia's ColdFusion. Positioning your tongue on the right side of your mouth while clicking the form buttons will help some, but keeping your Dev Exchange searches limited to the second Tuesday of each week is the only real work around. It's a known issue and addressed in the support section. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Missing Native Driver Page in CF Server 5.0
oh is it ? I dun remember installing the Professional edition because previously for CF 4.0 & 4.5 i have been using the Enterprise Edition. But i will check it out today again. Thanks! -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 11:29 AM To: CF-Talk Subject: Re: Missing Native Driver Page in CF Server 5.0 Native drivers are available only on the Enterprise Edition. Probably you have the Professional one. 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 - Original Message - From: "JAIME HOI" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:57 PM Subject: Missing Native Driver Page in CF Server 5.0 > > hi > i can't seem to find this Native Driver Page under Data Source > setting in my CF Server 5.0. Any one out there tried this already? > > > > Victory is in the mind of those who believe and who believe the longest > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Missing Native Driver Page in CF Server 5.0
Native drivers are available only on the Enterprise Edition. Probably you have the Professional one. 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 - Original Message - From: "JAIME HOI" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:57 PM Subject: Missing Native Driver Page in CF Server 5.0 > > hi > i can't seem to find this Native Driver Page under Data Source > setting in my CF Server 5.0. Any one out there tried this already? > > > > Victory is in the mind of those who believe and who believe the longest > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Missing Native Driver Page in CF Server 5.0
hi i can't seem to find this Native Driver Page under Data Source setting in my CF Server 5.0. Any one out there tried this already? Victory is in the mind of those who believe and who believe the longest ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF2001 just 2 weeks away
ColdFusion Event - CF2001 -- Will you be ahead in ColdFusion this year? You can get ahead in YOUR ColdFusion skills with CF2001 - The Third Annual TeraTech ColdFusion Conference with MDCFUG and CPCUG! Saturday 7/28/01 and Sunday 7/29/01. NIH, Bethesda MD $149 Places are going fast... tell your CF friends now! http://www.cfconf.org/2001CF_Odyssey/ Two days of ColdFusion Fun, Learning and Networking with your peers. CF knowledge unavailable in books! Registration is just $149.00 - what you learn at CF2001 will save you days of time coding this year! Speakers: * Charlie Arehart "Going from CF to Java" * Matt Brown "Future of CF Studio, UltraDev and the Macromedia community" * Mark Chambers "Flash and ColdFusion" * Steve Drucker "CF 5 js and DHTML tricks and tips" * Tim Nettleton "CF Hosting tips and tricks" * Shlomy Gantz "Cool CF debugging" * Hal Helms "XFB revealed" * Matt Liotta "CF on Linux" * Steve Nelson "Building Windows Applications with HTML and CF" * Robi Sen "CF and big iron" * Dave Watts "Extreme TBA" See the Speaker bios at http://www.cfconf.org/2001cf_odyssey/speakerbios.cfm --- Hotel Info Hotel info is up at http://www.cfconf.org/2001cf_odyssey/nih/NIH-hotels.cfm We have negotiated a discount $79 rate at the Four Points By Sheraton Bethesda Phone: 301-654-1000, Fax: (301) 654-0751 8400 Wisconsin Ave, Bethesda, MD 20814-3164 It is approx 20 minutes walk from NIH and 20 minutes from the nightlife in downtown Bethesda. Identify yourself as a member of the Odyssey group with the following number: 7966C. --- Previous attendee quotes: - "... the CF community owes you a tremendous thanks for putting such a high calibur event together and then making sure that our collective thoughts are transmitted to the appropriate parties at Allaire." "Happy New Year. I want to thank you for being such a great events sponsor. I have certainly learned things from your workshops that I would not have been able to learn anywhere else." Seating is limited - register now http://www.cfconf.org/2001cf_odyssey/ -- Michael Smith, TeraTech Inc VB, CF , SQL, Math programming 12221 Parklawn Dr Ste 200, Rockville MD 20852-1711 USA Voice: +1-301-881-1440 x110, 800-447-9120 Fax:301-881-3586 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Print without bringing print dialogue?
Here's my .02cents worth. I will point out that (at least in IE 5.5 not sure about NS or lower versions of IE) you can print directly to someone's printer when a page loads, without popping up a dialog box and without them having to click on anything. I have been doing this now for sometime internally for printing reports. Keep in mind that formatting using an HTML printed document can be difficult to control with such a wide range of systems and setups but... I think if it's kept simple it can be done. PS you can print anything that prints normally with an HTML page, logos included. ;-) Keep reading if your interested. My situation was as follows: What I needed was to query a db (using CF) and have results printed automatically. I only needed it to work with IE 5.5 and I didn't care if it displayed on screen. I found some code here http://www.javascriptcity.com/forums/index.php3?action=faq#qj6 but had to modify it... This code still popped up the print dialog box and I can do that by putting onload="window.print();" in the tag. What I wanted was to print the cfm (htm) file when it loaded, without popping up the print dialog box. I tweaked the code a little and ended up with this: You also have to put onload="printit();" in the tag for it to print when the page loads or you could associate it with a print button etc (just set whatever you click on to call the printit() function). The modified code prints the cfm (htm) file to the users default printer using default settings without putting up any dialog boxes but it still displays the cfm (htm) file onscreen. Again, I know it works in IE 5.5 not sure about anything else. I haven't tested it in NS. I didn't have a need to support NS or any browser other than IE 5.5. One thing to "get around" displaying onscreen would be to use a hidden frame for the "printing" htm page and put up a generic display page. Hope this helps Stephen -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 9:38 PM To: CF-Talk Subject: RE: Print without bringing print dialogue? actually, you can't. it's a JS security feature. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 12:46 PM To: CF-Talk Subject: Print without bringing print dialogue? Hi, All: I posted this before the list went down a few weeks ago. I don't know if it went though so I re-post it. I need to know how to print a cfm page without bringing up the print dialogue from the browser. If I use window. print() method, the print dialogue will popup. But what I need is to send the displayed information to the printer directly without bringing this print dialogue box. Is this possible? Any hint or suggestion will be appreciated. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: Macromedia release SiteSpring beta
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Macromedia have released the first beta of their news product, SiteSpring. See attp://www.macromedia.com/products/sitespring/ :) Peter Tilbrook Chief Web Developer Lunar Power Internet Technologies Unit 1, 26-28 Winchcombe Court Mitchell, ACT, 2911 AUSTRALIA Phone: (02) 6242 Mobile: 0401 973 415 Fax: (02) 6242 6655 Email: [EMAIL PROTECTED] Web: http://www.lunarpower.com.au -BEGIN PGP SIGNATURE- Version: PGP Personal Edition 6.0.2 iQA/AwUBO0sg4kUmflCFE8qcEQIKgACg5FFmEv/LS3tcykc3PsV5BQyU2HsAn3qo M6W1jVdyZSXF/PP+XPs8C7yI =GFOM -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 builder software
scan into Omniform 4.0 Edit/tweak the OCR results will automatically recognize "MOST" paperform "fields" and assigna generic name. from OmniForm - File save as PDF Open the pdf form in full version of Adobe acrobat and edit form fields names/formatting This is now your online form/template. Use www.activepdf.com's toolkit to pipe data via CF into these form templates, or you can use the Adobe Acrobat FDF activex or java toolkit. All the best, Steve - Original Message - From: "Rick Lamb" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 12:10 PM Subject: SOT: Form builder software > Hi all, > > I need to find a better solution than html forms to meet my clients needs. > My client has a bunch of paper forms and documents that he wants to use > online. I've tried creating these in html but the lack of formatting and > print control is causing some problems. Not to mention the huge amount of > time it's taking. Does anybody know of a better way to create these forms > online. I need them to be able to except input from a database to populate > the fields in the form and to be manually updateable online. I found one > product that may work, it's called Liquid Forms and converts the forms to > editable pdf versions. Any other solutions out there you guys can recommend? > > 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: Mailings that appear to be from humans?
Jeff: You can use this: to="Human<[EMAIL PROTECTED]>" Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com - Original Message - From: "Jeff Green" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 8:24 PM Subject: Mailings that appear to be from humans? > Hi all, > > I want to send mail with cfmail but when receiving the mail I want it to > appear as if its from a human name opposed to an email address. > > Example: > > From: John Doe > > Opposed to > > From: [EMAIL PROTECTED] > > Anyone have any ideas on how to do this? > > btw I understand that the mail still must come from an email address, just > wondering if maybe I could add some sort of header for the human name > part > > Thanks in advance, > > Jeff > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Mailings that appear to be from humans?
Create the "From" as "John Doe <[EMAIL PROTECTED]>". That will handle it for you. Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Jeff Green [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 5:25 PM > To: CF-Talk > Subject: Mailings that appear to be from humans? > > > Hi all, > > I want to send mail with cfmail but when receiving the mail I > want it to appear as if its from a human name opposed to an > email address. > > Example: > > From: John Doe > > Opposed to > > From: [EMAIL PROTECTED] > > Anyone have any ideas on how to do this? > > btw I understand that the mail still must come from an email > address, just wondering if maybe I could add some sort of > header for the human name part > > Thanks in advance, > > Jeff > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mailings that appear to be from humans?
Hi all, I want to send mail with cfmail but when receiving the mail I want it to appear as if its from a human name opposed to an email address. Example: From: John Doe Opposed to From: [EMAIL PROTECTED] Anyone have any ideas on how to do this? btw I understand that the mail still must come from an email address, just wondering if maybe I could add some sort of header for the human name part Thanks in advance, Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Client Variables NOT going away though I try
have you tried the DeleteClientVariable() function? -Original Message- From: Stephen R. Cassady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:59 PM To: CF-Talk Subject: Client Variables NOT going away though I try I'm having the darnedest time trying to delete client files on browser close or after a period of time. I'm even trying to follow Hal Helms great "Tracking State Management with Cold Fusion" to run this correctly. Even running the code below - the CFID and CFTOKEN are exactly the same, and are unforgotten. They are supposed to disappear, but they don't! Here's a chuck of my application file: StructClear(Session); Help! Stephen R. Cassady [EMAIL PROTECTED] http://www.tallylist.com 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: How do I list query results in a random order fashion??
Try this: 1. Pull back the query unsorted. 2. Create a while-do loop that picks a random record from the query 3. Display the record 4. Delete the record from the record set 5. Go back to step 2. Kevin >>> [EMAIL PROTECTED] 07/10/01 03:44PM >>> Dear Cf'ers: I have the below query that gets companies alphabetically (stupid, eh?) - the problem is, the companies don't like it because, being ordered by company name, it gives preference to those that begin with the first letters of the alphabet. Can anyone think of a way to order this list in a random fashion each time it is envoked?? Thank you all for your consideration. Tom SELECT DISTINCT JoinTbl.CategoryID, JoinTbl.CompanyID, CategoryTbl.CategoryName, CategoryTbl.CategoryID, CompanyTbl.CompanyID, CompanyTbl.CompanyName, CompanyTbl.WebAddress FROM CategoryTbl, JoinTbl, CompanyTbl WHERE JoinTbl.CategoryID = CategoryTbl.CategoryID AND JoinTbl.CompanyID = CompanyTbl.CompanyID AND JoinTbl.CategoryID = #CategoryID# AND CompanyTbl.WebAddress IS NOT NULL ORDER BY CompanyTbl.CompanyName * MedMatrix New & Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 list query results in a random order fashion??
Don't know if its the easiest or best, but one way is place your query output into an array say qarray Use RandRange() to generate random numbers use CFloop to loop through array Simple code: mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:45 PM To: CF-Talk Subject: How do I list query results in a random order fashion?? Dear Cf'ers: I have the below query that gets companies alphabetically (stupid, eh?) - the problem is, the companies don't like it because, being ordered by company name, it gives preference to those that begin with the first letters of the alphabet. Can anyone think of a way to order this list in a random fashion each time it is envoked?? Thank you all for your consideration. Tom SELECT DISTINCT JoinTbl.CategoryID, JoinTbl.CompanyID, CategoryTbl.CategoryName, CategoryTbl.CategoryID, CompanyTbl.CompanyID, CompanyTbl.CompanyName, CompanyTbl.WebAddress FROM CategoryTbl, JoinTbl, CompanyTbl WHERE JoinTbl.CategoryID = CategoryTbl.CategoryID AND JoinTbl.CompanyID = CompanyTbl.CompanyID AND JoinTbl.CategoryID = #CategoryID# AND CompanyTbl.WebAddress IS NOT NULL ORDER BY CompanyTbl.CompanyName * MedMatrix New & Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do I list query results in a random order fashion??
Dear Cf'ers: I have the below query that gets companies alphabetically (stupid, eh?) - the problem is, the companies don't like it because, being ordered by company name, it gives preference to those that begin with the first letters of the alphabet. Can anyone think of a way to order this list in a random fashion each time it is envoked?? Thank you all for your consideration. Tom SELECT DISTINCT JoinTbl.CategoryID, JoinTbl.CompanyID, CategoryTbl.CategoryName, CategoryTbl.CategoryID, CompanyTbl.CompanyID, CompanyTbl.CompanyName, CompanyTbl.WebAddress FROM CategoryTbl, JoinTbl, CompanyTbl WHERE JoinTbl.CategoryID = CategoryTbl.CategoryID AND JoinTbl.CompanyID = CompanyTbl.CompanyID AND JoinTbl.CategoryID = #CategoryID# AND CompanyTbl.WebAddress IS NOT NULL ORDER BY CompanyTbl.CompanyName * MedMatrix New & Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: URL Hacks - Solution
Josh, Do keep us all posted as to the outcome of all this. There are those of us who will, no doubt, want to jump right on any solutions you find. If you need a list to keep up with this, let me know and I'll create a temporary (or permanent if needed) list to accommodate. Take care... Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Josh R [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 10:08 PM > To: CF-Talk > Subject: RE: URL Hacks - Solution > > > > >From: "Paris Lundis" <[EMAIL PROTECTED]> > >Subject: RE: URL Hacks - Solution > >I think the script is a good first attempt and seems to > address the URL > >hack threads previously that have gone around. > > Thank you. My feelings exactly. As usual, Dave Watts was > right when he said > this script doesn't cover enough attacks. However, it was > intended to cover > the attack that started this thread. I'll be happy to expand > it's abilities > if I can get some help. > > >so programatically (SQL wise) what else might one post in > the string to > >pickup further data???... May the SQL gods speak... > > The fun part about dealing with hack attacks on a public > forum like this is > that no one wants to dish any details, which is a good thing, > but it does > make projects like this difficult. > > >I think if we all chip in with some specifics this program could get > >furthered and cover perhaps other known hack arounds... > > If anyone has any other info on database hacks that they'd > like to help > defend against, please contact me off list. The more I know > about, the > better this script can be. > > If you have just general comments, please post them here of > course. Maybe > your thought will get someone thinking. > > Thanks again, Paris for the good words and push to continue. > > >From: "Bruce, Rodney" <[EMAIL PROTECTED]> > >Subject: RE: URL Hacks - Solution > >URL hacks I think are easier to handle than form.Variables. > > As far as I'm concerned, variables are variables. These > attacks require > certain language context no matter if they come from urls, > forms, etc., so > filtering out the key phrase(s) the right way *should* repel them. > > >But I like the > >idea of adding the notification by email when an attempted hack is > >tried > >and > >then kicking them off site. > > Thanks, Bruce. That's the real meat of my security concepts. > If anything > unwanted is going on, I want to know about it and get rid of > them. I never > understood why we throw a friendly error message to someone > attacking our > system. > > But that's just me. > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: dbtype=dynamic
I think Dave is right -- it only seems to work with ODBC connection strings, not OLEDB. tom "Deb Dickerson" <[EMAIL PROTECTED]> wrote in message 013401c10987$6b458e40$[EMAIL PROTECTED]">news:013401c10987$6b458e40$[EMAIL PROTECTED]... > You might be able to find something in this Microsoft article that might > help. > http://support.microsoft.com/support/kb/articles/q193/3/32.asp > > Debbie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Client Variables NOT going away though I try
I'm having the darnedest time trying to delete client files on browser close or after a period of time. I'm even trying to follow Hal Helms great "Tracking State Management with Cold Fusion" to run this correctly. Even running the code below - the CFID and CFTOKEN are exactly the same, and are unforgotten. They are supposed to disappear, but they don't! Here's a chuck of my application file: StructClear(Session); Help! Stephen R. Cassady [EMAIL PROTECTED] http://www.tallylist.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Debug output
-Original Message- From: Justin [mailto:[EMAIL PROTECTED]] Subject: RE: Debug output Try putting after your at the end of your pages. Better yet, you could put it in onrequestend.cfm, then you wouldn't have to modify all your pages. Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 U Justin, what's onrequestend.cfm?The way you wrote that makes me think that's another of the many undocumented features of CF that I learn about here rather than in the documentation or the books. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio Preference File
Does anyone know where the CF Studio preference file is located? I'm guessing that maybe it needs to be thrown away and recreated. I'm specifically looking for the one the contains Options>Settings... for RDS or file transfers. Bruce - Original Message - From: "Bruce Holm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 11:52 AM Subject: Re: Turn off double-spacing on rds xfer > But it is set to Unix already. > Any other ideas? > > > Bruce > [EMAIL PROTECTED] > > - Original Message - > From: "Garza, Jeff" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 10, 2001 11:17 AM > Subject: RE: Turn off double-spacing on rds xfer > > > > F8 -> File Settings -> Check Format When Saving = Unix > > > > HTH, > > > > Jeff Garza > > Lead Developer/Webmaster > > Spectrum Astro, Inc. > > 480.892.8200 > > [EMAIL PROTECTED] > > http://www.spectrumastro.com > > > > > > > > -Original Message- > > From: Bruce Holm [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, July 10, 2001 8:53 AM > > To: CF-Talk > > Subject: Turn off double-spacing on rds xfer > > > > > > Short version: > > Does anyone know where the setting is in CF Studio 4.5 for preventing my > > files (that are transfered via RDS) from being converted to double-spacing > > (the lines of code?) > > > > > > Long version? > > When I first loaded CF Studio 4.5 about a year ago, all was fine. But the > > last 4 months, when I xfer my single-spaced .cfm source code file from our > > development server (a Sun UNIX box) to our staging server (also a Sun UNIX > > box), the files end up double-spaced. I have to open the file on the > > staging server, remove double-spacing, and resave it to rid it of the > > every-other (blank) line. > > > > I thought this had to do with the Options>Settings... and selecting File > > Settings where you can specify Unix file types. But mine is already set > to > > Unix. Other teammate's CF Studio isn't behaving this way. Is a > preference > > file corrupted or is there a logical explanation (and cure) for this > > problem??? > > > > - > > Bruce Holm - Web Programmer > > Lattice Semiconductor Corp. > > [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: URL Hacks - Solution
>From: "Paris Lundis" <[EMAIL PROTECTED]> >Subject: RE: URL Hacks - Solution >I think the script is a good first attempt and seems to address the URL >hack threads previously that have gone around. Thank you. My feelings exactly. As usual, Dave Watts was right when he said this script doesn't cover enough attacks. However, it was intended to cover the attack that started this thread. I'll be happy to expand it's abilities if I can get some help. >so programatically (SQL wise) what else might one post in the string to >pickup further data???... May the SQL gods speak... The fun part about dealing with hack attacks on a public forum like this is that no one wants to dish any details, which is a good thing, but it does make projects like this difficult. >I think if we all chip in with some specifics this program >could get furthered and cover perhaps other known hack arounds... If anyone has any other info on database hacks that they'd like to help defend against, please contact me off list. The more I know about, the better this script can be. If you have just general comments, please post them here of course. Maybe your thought will get someone thinking. Thanks again, Paris for the good words and push to continue. >From: "Bruce, Rodney" <[EMAIL PROTECTED]> >Subject: RE: URL Hacks - Solution >URL hacks I think are easier to handle than form.Variables. As far as I'm concerned, variables are variables. These attacks require certain language context no matter if they come from urls, forms, etc., so filtering out the key phrase(s) the right way *should* repel them. >But I like the >idea of adding the notification by email when an attempted hack is tried >and >then kicking them off site. Thanks, Bruce. That's the real meat of my security concepts. If anything unwanted is going on, I want to know about it and get rid of them. I never understood why we throw a friendly error message to someone attacking our system. But that's just me. _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What are YOUR settings? (CF Security)
I'm not sure anyone wants the whole world to know what their CF servers are set to allow/disallow when it comes to tags. But I'm very interested in knowing the suggestions/feelings/examples of others when it comes to the tags that they allow on their servers. Specifically, ISPs/WHPs are my interest. I'm building a report for the board, and thought the input from others would help. Can you reply to me off-list and let me know? It would be GREATLY appreciated! Thanks! Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.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: dbtype=dynamic
You might be able to find something in this Microsoft article that might help. http://support.microsoft.com/support/kb/articles/q193/3/32.asp Debbie - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 5:07 PM Subject: RE: dbtype=dynamic > > Has anyone tried to connect to a database thru the new > > connection string method? I've successfully connected with > > ODBC DSNless connection strings, but when I try an OLE DB > > connection string, the cfquery fails. Does it work only > > with DSNLess connections? > > According to the docs, DBTYPE="DYNAMIC" is only for use with ODBC. I haven't > tried using it with OLEDB, but your problem might be that when you use > DBTYPE="DYNAMIC", by default, CF uses some shared settings. I only vaguely > recall exactly what gets shared, but remember reading about it in release > notes for one of the betas. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Text Field Size Limits?
Don't know why yours is truncating, I also use Access Memo fields and have some that are over 3,000 chars. I also use to enter/edit these fields. Sorry no help, just info -Original Message- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:20 PM To: CF-Talk Subject: Text Field Size Limits? Hi, I'm wondering about size limitations on text fields and/or memo fields. We are using Access to create our table and I was using a text field that I believe limited me to about 255 characters. The boss wanted more so I changed it to a memo field but it seem that the data is still truncating after about 400 or so characters. I am using to populate the field but I don't think the tag is truncating. It seem to truncate during insert into the table. Any info/help would be appreciated. Thanks, Eric Homa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Accessing outlook/exchange folders?
It's possible takes a bit of programming though... I have a site that pulls all .msg files via cold fusion throws them in a verity collection, then sucks some additional information into a SQL database. Completely different from what you are trying to do but thought I would mention it http://www.nunya.com -Original Message- From: Wayne Putterill [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 8:40 AM To: CF-Talk Subject: Accessing outlook/exchange folders? A client has asked if CF can access public folders in Outlook, word and excel documents are held in these folders and they would like them to be available on a private website. I have little experience of Outlook and Exchange so I am stumped on this, I was wondering if anyone had done it before - or if it just isn't possible? Regards, Wayne Putterill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: HTML Question with Netscape 4 and 6
yep netscape doesn't forgive forgetting /td tags... geeezzz -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: HTML Question with Netscape 4 and 6
After your inner table end tag, put an ending row tag also, just a /td CW -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:29 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 and once again, i think we need to do something about that "web developer extraordinaire" in the signature file... -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:21 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 Like you said, you've got a firewall -- I get "cannot find server" with that URL. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 builder software
I would just use adobe acrobat. Will do everything you want... CW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:10 PM To: CF-Talk Subject: SOT: Form builder software Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge amount of time it's taking. Does anybody know of a better way to create these forms online. I need them to be able to except input from a database to populate the fields in the form and to be manually updateable online. I found one product that may work, it's called Liquid Forms and converts the forms to editable pdf versions. Any other solutions out there you guys can recommend? 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
Text Field Size Limits?
Hi, I'm wondering about size limitations on text fields and/or memo fields. We are using Access to create our table and I was using a text field that I believe limited me to about 255 characters. The boss wanted more so I changed it to a memo field but it seem that the data is still truncating after about 400 or so characters. I am using to populate the field but I don't think the tag is truncating. It seem to truncate during insert into the table. Any info/help would be appreciated. Thanks, Eric Homa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
Try tripleing your # signs. I know this sounds crazy, but had a similar instance and table_Name### worked like a charm. CW -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:50 PM To: CF-Talk Subject: Re: Column names containing a # sign Try calling the "#" with its respectebly chr(num) I don't know which asacii code is "#" but try this (although it may sounds silly): (let's say the 19 ASCII code is "#")... UPDATE Registration#chr(19)# SET . bla bla bla It might help because I've seen cases where the char itself and the chr(ASCII_char_num) performed diffrently. Michael. - Original Message - From: "Daniel Lancelot" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 9:31 PM Subject: RE: Column names containing a # sign > have you tried doubling your # > > ie product# = product## etc - cf should convert that to a single # before > passing to db... > > -Original Message- > From: Tristram Charnley [mailto:[EMAIL PROTECTED]] > Sent: 10 July 2001 17:18 > To: CF-Talk > Subject: Column names containing a # sign > > > Hi > > I've been given a database containing column names such as > Product# and Registration# > > I've tried using aliases and backticks on these columns in my query to > no effect - the # sign throws CF each time. Changing the column names > isn't an option unfortunately. > > Any suggestions greatfully received. > > Tristram Charnley > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Accessing outlook/exchange folders?
A client has asked if CF can access public folders in Outlook, word and excel documents are held in these folders and they would like them to be available on a private website. I have little experience of Outlook and Exchange so I am stumped on this, I was wondering if anyone had done it before - or if it just isn't possible? Regards, Wayne Putterill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: dbtype=dynamic
> Has anyone tried to connect to a database thru the new > connection string method? I've successfully connected with > ODBC DSNless connection strings, but when I try an OLE DB > connection string, the cfquery fails. Does it work only > with DSNLess connections? According to the docs, DBTYPE="DYNAMIC" is only for use with ODBC. I haven't tried using it with OLEDB, but your problem might be that when you use DBTYPE="DYNAMIC", by default, CF uses some shared settings. I only vaguely recall exactly what gets shared, but remember reading about it in release notes for one of the betas. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: file uploads without using CFFILE
Hi Joe Does the host have ASP? If so, just incorporate it into your program flow as if you used a stand-alone CFTemplate to perform the upload and save the file: Template1.cfm... Present upload form - Action specifies ASP template Template2.asp... Upload, Save and rename the file & invoke Template3.cfm Template3.cfm... Update database, etc and Present results to user I did things like this at the old iTool before the enabled cffile. HTH Dick At 12:45 PM -0500 7/10/01, Joe Sheble aka Wizaerd wrote: >If hosted at an outside hosting provider, and that provider has CFFILE >turned off, what other alternatives are there for uploading files from >the client to the server. CFFTP won't work because it's expected to work >via FTP server to server. This is for CF 4.5. > >Is there perhaps a free COM object that could be accessed via CF to profide >this functionality? I found a free one, but all the examples give ASP >code, and relies on the REQUEST and FORM collections available in ASP. > >Ideas? Suggestions? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Turn off double-spacing on rds xfer
But it is set to Unix already. Any other ideas? Bruce [EMAIL PROTECTED] - Original Message - From: "Garza, Jeff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 11:17 AM Subject: RE: Turn off double-spacing on rds xfer > F8 -> File Settings -> Check Format When Saving = Unix > > HTH, > > Jeff Garza > Lead Developer/Webmaster > Spectrum Astro, Inc. > 480.892.8200 > [EMAIL PROTECTED] > http://www.spectrumastro.com > > > > -Original Message- > From: Bruce Holm [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 8:53 AM > To: CF-Talk > Subject: Turn off double-spacing on rds xfer > > > Short version: > Does anyone know where the setting is in CF Studio 4.5 for preventing my > files (that are transfered via RDS) from being converted to double-spacing > (the lines of code?) > > > Long version? > When I first loaded CF Studio 4.5 about a year ago, all was fine. But the > last 4 months, when I xfer my single-spaced .cfm source code file from our > development server (a Sun UNIX box) to our staging server (also a Sun UNIX > box), the files end up double-spaced. I have to open the file on the > staging server, remove double-spacing, and resave it to rid it of the > every-other (blank) line. > > I thought this had to do with the Options>Settings... and selecting File > Settings where you can specify Unix file types. But mine is already set to > Unix. Other teammate's CF Studio isn't behaving this way. Is a preference > file corrupted or is there a logical explanation (and cure) for this > problem??? > > - > Bruce Holm - Web Programmer > Lattice Semiconductor Corp. > [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: HTML Question with Netscape 4 and 6
and once again, i think we need to do something about that "web developer extraordinaire" in the signature file... -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:21 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 Like you said, you've got a firewall -- I get "cannot find server" with that URL. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: file uploads without using CFFILE
If your hosting provider allows CFX, there's a CFX_File in the Allaire dev exchange that would do the job. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 10:46 AM To: CF-Talk Subject: file uploads without using CFFILE If hosted at an outside hosting provider, and that provider has CFFILE turned off, what other alternatives are there for uploading files from the client to the server. CFFTP won't work because it's expected to work via FTP server to server. This is for CF 4.5. Is there perhaps a free COM object that could be accessed via CF to profide this functionality? I found a free one, but all the examples give ASP code, and relies on the REQUEST and FORM collections available in ASP. Ideas? Suggestions? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: HTML Question with Netscape 4 and 6
Like you said, you've got a firewall -- I get "cannot find server" with that URL. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Protectiong an application
Hi, I am trying to protect an application using Advanced Security. I'm defining the resource as an Application. I followed various tutorials step by step but still it ignores the NT User group defined in the policy for the rule. I'm just wondering, how does it know which application to apply the policy? Is it the NAME attribute of the CFAPPLICATION tag? Thanks. Frank Mamone ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem calling Oracle stored procedures (PL/SQL functions) by using CFSTOREDPROC
Hello folks, I'm trying to call an Oracle stored procedure (a PL/SQL function) from ColdFusion using and have been unable to do so. When I call the function, I get the following error: Oracle Error Code = 6550 ORA-06550: line 1, column 7: PLS-00221: 'FSELECTSTATE' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored SQL = "TestBed.fSelectState" I have created a procedure similar to the function, saving that it does not return a value to the caller. Using that procedure with succeeds. Questions: 1) Does ColdFusion not support accessing Oracle stored *functions* using , only *procedures*? (I normally think of PL/SQL functions as a subset of Oracle stored procedures, which is why I'm asking about the distinction.) If it does, does anyone have any suggestions as to what I might be doing incorrectly? If it does not, then on to question #2: 2) I know that I can access Oracle stored functions using (because I've done it before), when they (a) take one argument and (b) return a value. However, the function in question returns a reference cursor as well as a function value, so does anyone have an idea as to the syntax required to access a reference cursor returned by a function using the tag, if it can be done at all (my own attempts having miserably failed)? I've appended the package spec code that I'm using as well as the statements for them below. The system we're using for ColdFusion is an NT 4.0 Server running CF 4.5.1 SP2, with the native Oracle 8i driver. Thanks again in advance, and Regards, Joel Parramore P.S. --- In the ColdFusion 4.0 Web Application Construction Kit, by Ben Forta, he states (page 474 of the third edition) that Oracle stored functions are not supported by the CFSTOREDPROC tag. He also states that you can't use the CFPROCRESULT tag with Oracle, either, However, I know that you can use CFPROCRESULT in CF 4.5 and above, so, presumably, these are limitations of 4.0. If someone from Allaire/Macromedia would care to clarify the situation vis-a-vis CFSTOREDPROC and Oracle stored functions, that'd be great. = PL/SQL spec code: CREATE OR REPLACE PACKAGE TestBed AS TYPE GenericCursorType IS REF CURSOR; PROCEDURE SelectStates (inStateAbbrev IN VARCHAR2, qSelectStatesList OUT GenericCursorType); PROCEDURE SelectState (inStateAbbrev IN VARCHAR2, outStateName OUT VARCHAR2); FUNCTION fSelectState (inStateAbbrev IN VARCHAR2, outStateName OUT VARCHAR2) RETURN VARCHAR2; FUNCTION fSelectStates (inStateAbbrev IN VARCHAR2, qSelectStatesList OUT GenericCursorType) RETURN VARCHAR2; END TestBed; / Example 1: No reference cursor returned *** SUCCEEDS *** *** FAILS *** Example 2: Reference cursor returned *** SUCCEEDS *** *** FAILS *** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: Form builder software
Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge amount of time it's taking. Does anybody know of a better way to create these forms online. I need them to be able to except input from a database to populate the fields in the form and to be manually updateable online. I found one product that may work, it's called Liquid Forms and converts the forms to editable pdf versions. Any other solutions out there you guys can recommend? 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: Column names containing a # sign
So much for directly to Tristram. Anyways try the below and then just alias them as another name to reference in your CF code select [product#] as productnumber, [item#] as itemnumber from whatever #productnumber# #itemnumber# CC Casey C Cook/TMG/CSC@CSC on 07/10/2001 02:26:59 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Column names containing a # sign Sometimes it takes forever for my e-mails to show up on cf-talk so Im forwarding this to you directly. Casey Cook -- Forwarded by Casey C Cook/TMG/CSC on 07/10/2001 02:23 PM --- Casey C Cook/TMG/CSC 07/10/2001 02:22 PM To: [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign (Document link: Casey C Cook) Try: select [product#], [item#] from whatever Casey Cook "Tristram Charnley" <[EMAIL PROTECTED]> on 07/10/2001 02:09:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 page call in any IMG tag???
I just want to give DJ a big thanks, this really helped alot! Oh and he ment to say CFContent not CFObject :) Jeff -Original Message- From: DJ Riebesell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:18 AM To: '[EMAIL PROTECTED]' Subject: RE: A page call in any IMG tag??? Yep, just use a CFOBJECT on that page and send it back with a mime type of a JPG or GIF. -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:37 PM To: CF-Talk Subject: A page call in any IMG tag??? Hi all, I was looking at an email the other day and there was a .jsp page url in the src attribute of an image tag. example: I figure that this is how they track if someone read the email, and would like to do something similar. Has anyone ever heard of, or done this? Or if anyone has any ideas on how to track if an email gets viewed, any info would be appreciated. btw I plan on calling a cfm page not jsp ;) Thanks for any info on the subject, Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Verity exclude sub-directories?
I did see a "pathindex" tag at CFHacker.com http://www.cfhacker.com/ > I'm working with Verity and have a questionis there a way to exclude > certain sub-directories from being indexed in the collection? I have a few > 'procedure' directories that I don't want coming up in the user search. > > Thanks for your help! > Deborah > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
try SELECT tblone.[colum##] as colum from tblone; #test.colum# seems to work -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:09 PM To: CF-Talk Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
file uploads without using CFFILE
If hosted at an outside hosting provider, and that provider has CFFILE turned off, what other alternatives are there for uploading files from the client to the server. CFFTP won't work because it's expected to work via FTP server to server. This is for CF 4.5. Is there perhaps a free COM object that could be accessed via CF to profide this functionality? I found a free one, but all the examples give ASP code, and relies on the REQUEST and FORM collections available in ASP. Ideas? Suggestions? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dbtype=dynamic
Has anyone tried to connect to a database thru the new connection string method? I've successfully connected with ODBC DSNless connection strings, but when I try an OLE DB connection string, the cfquery fails. Does it work only with DSNLess connections? tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
Try calling the "#" with its respectebly chr(num) I don't know which asacii code is "#" but try this (although it may sounds silly): (let's say the 19 ASCII code is "#")... UPDATE Registration#chr(19)# SET . bla bla bla It might help because I've seen cases where the char itself and the chr(ASCII_char_num) performed diffrently. Michael. - Original Message - From: "Daniel Lancelot" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 9:31 PM Subject: RE: Column names containing a # sign > have you tried doubling your # > > ie product# = product## etc - cf should convert that to a single # before > passing to db... > > -Original Message- > From: Tristram Charnley [mailto:[EMAIL PROTECTED]] > Sent: 10 July 2001 17:18 > To: CF-Talk > Subject: Column names containing a # sign > > > Hi > > I've been given a database containing column names such as > Product# and Registration# > > I've tried using aliases and backticks on these columns in my query to > no effect - the # sign throws CF each time. Changing the column names > isn't an option unfortunately. > > Any suggestions greatfully received. > > Tristram Charnley > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
Sometimes it takes forever for my e-mails to show up on cf-talk so Im forwarding this to you directly. Casey Cook -- Forwarded by Casey C Cook/TMG/CSC on 07/10/2001 02:23 PM --- Casey C Cook/TMG/CSC 07/10/2001 02:22 PM To: [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign (Document link: Casey C Cook) Try: select [product#], [item#] from whatever Casey Cook "Tristram Charnley" <[EMAIL PROTECTED]> on 07/10/2001 02:09:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
Try: select [product#], [item#] from whatever Casey Cook "Tristram Charnley" <[EMAIL PROTECTED]> on 07/10/2001 02:09:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> cc: Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: HTML Question with Netscape 4 and 6
Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity exclude sub-directories?
I'm working with Verity and have a questionis there a way to exclude certain sub-directories from being indexed in the collection? I have a few 'procedure' directories that I don't want coming up in the user search. Thanks for your help! Deborah ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity exclude sub-directories?
I'm working with Verity and have a questionis there a way to exclude certain sub-directories from being indexed in the collection? I have a few 'procedure' directories that I don't want coming up in the user search. Thanks for your help! Deborah ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QuerySetCell on CF 5
Have any of you had prolems with the QuerySetCell() function on CF Server 5. I just upgraded to CF 5EE this morning, and I am having problems on pages that use this function. Here is the error: Unhandled System exception ! The error occurred while processing an element with a general identifier of (CFSET), occupying document position (51:4) to (51:135) Any help would be greatly appreciated! --> scott van vliet <-- senior web engingeer juxt interactive 949<>752<>5898<>202 [EMAIL PROTECTED] www.juxtinteractive.com "In uniqueness is the preservation of mankind..." - Greg Graffin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ONCR Cybercash
Howdy All Has anyone experienced any problems installing the ONCR-CyberCash tag in CF5? I'm getting errors in the install routine. I've tried contacting ONCR for SEVERAL days now, and I've been unable to reach anyone. Needless to say, I'm a bit miffed by their less-than-prompt response to my various forms of support request. Thanks! Todd A Dancer [EMAIL PROTECTED] http://www.turbosquid.com 504.468.7827 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 - Allaire website
Can't say I've had that happen. Most of my Dev-Exchange searches take less than 20 seconds.. tops. Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation "We ARE the net." http://www.aaawebhosting.com > -Original Message- > From: Zac Belado [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 10:51 AM > To: CF-Talk > Subject: OT - Allaire website > > > Is anyone else getting *very* slow searches on the Dev-Exchange site? > > I've been doing searches for the last few days and routinely > get results that take 2 to 3 minutes to return > > > -- > > Zac Belado > Application Developer > > Bayleaf Software > #300 948 Homer Street, > Vancouver, BC, > V6B 2W7 > Ph: 604.683.1288 x 116 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Debug output
Try putting after your at the end of your pages. Better yet, you could put it in onrequestend.cfm, then you wouldn't have to modify all your pages. Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:26 AM To: CF-Talk Subject: Debug output Is there a way to capture CFAS's debug output and format it? My problem is that if I develop a site that has a dark background, I can't see any debug information because the text is dark too. I am mainly interested in looking at SQL statements, I know you can see most other information (passed vars, etc) using many of the custom tags. 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: Turn off double-spacing on rds xfer
F8 -> File Settings -> Check Format When Saving = Unix HTH, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 8:53 AM To: CF-Talk Subject: Turn off double-spacing on rds xfer Short version: Does anyone know where the setting is in CF Studio 4.5 for preventing my files (that are transfered via RDS) from being converted to double-spacing (the lines of code?) Long version? When I first loaded CF Studio 4.5 about a year ago, all was fine. But the last 4 months, when I xfer my single-spaced .cfm source code file from our development server (a Sun UNIX box) to our staging server (also a Sun UNIX box), the files end up double-spaced. I have to open the file on the staging server, remove double-spacing, and resave it to rid it of the every-other (blank) line. I thought this had to do with the Options>Settings... and selecting File Settings where you can specify Unix file types. But mine is already set to Unix. Other teammate's CF Studio isn't behaving this way. Is a preference file corrupted or is there a logical explanation (and cure) for this problem??? - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [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: CF-TALK
This msg showed up right away...my earlier post finally showed up, nearly 2 hrs after posting it. Strange... - Original Message - From: "Bruce Holm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:26 AM Subject: CF-TALK > This list is acting strange... > I am seeing some duplicate msgs posted. > When I post, it doesn't show up (at least not after about an hour.) > I didn't get any error msgs. > > What's up? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 - Allaire website
Its been like that for a while. Rich -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:51 PM To: CF-Talk Subject: OT - Allaire website Is anyone else getting *very* slow searches on the Dev-Exchange site? I've been doing searches for the last few days and routinely get results that take 2 to 3 minutes to return -- Zac Belado Application Developer Bayleaf Software #300 948 Homer Street, Vancouver, BC, V6B 2W7 Ph: 604.683.1288 x 116 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 - Allaire website
Yes .. I was complaining about that just a few minutes ago. Moving between most of the pages in the devex section are slow .. not just the search. Todd - Original Message - From: "Zac Belado" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 1:51 PM Subject: OT - Allaire website | Is anyone else getting *very* slow searches on the Dev-Exchange site? | | I've been doing searches for the last few days and routinely get results | that take 2 to 3 minutes to return | | | -- | | Zac Belado | Application Developer | | Bayleaf Software | #300 948 Homer Street, | Vancouver, BC, | V6B 2W7 | Ph: 604.683.1288 x 116 | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - Allaire website
Is anyone else getting *very* slow searches on the Dev-Exchange site? I've been doing searches for the last few days and routinely get results that take 2 to 3 minutes to return -- Zac Belado Application Developer Bayleaf Software #300 948 Homer Street, Vancouver, BC, V6B 2W7 Ph: 604.683.1288 x 116 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
A page call in any IMG tag???
Hi all, I was looking at an email the other day and there was a .jsp page url in the src attribute of an image tag. example: I figure that this is how they track if someone read the email, and would like to do something similar. Has anyone ever heard of, or done this? Or if anyone has any ideas on how to track if an email gets viewed, any info would be appreciated. btw I plan on calling a cfm page not jsp ;) Thanks for any info on the subject, Jeff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Need db advice
Hey all, Need some advice here. I have an app that functions somewhat like an old library card catalog index. It allows users to input market studies with an abstract, as well as the location of the material. The customer (our marketing dept.) wants a reference number to be generated in the format of "Continent/CompanySite/SequenceNumber" so that when records are listed, the users can easily scan the reference numbers and see where the item is located (for example, a reference number of "NA/ABH/21" would indicate that the document is located in Auburn Hills (North America). The 21 is simply the next sequence number from the Oracle DB. Okay, great. Now, when a user inputs a study they have to indicate the continent and the site. No problem. I use Nate's TwoSelectsRelated to populate the site list based on the continent selected. Buuut...if a site isn't listed in the picklist, we need to allow the user to add a new site. Okay, no problem. Buuut...here's the problem--our company has acronyms for each site, all over the world. So Auburn Hills might be ABH, Windsor might be WDR, etc. Because the reference numbers need to include the acronyms, those obviously need to be stored in the database. But, if we allow users to add their own locations, we run into the problem of users either A) using the wrong location acronym, or B) typing duplicate site names into the db. It would be nice if there was one central place where I could find all of the correct acronyms, but unfortunately, they aren't always standard. I thought of using just a numbering schema, but this does not prevent one person from adding location "Auburn Hills" and another from adding "Aubern Hils". I'm a little stuck. Can anyone bring their winch and tow me out? Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
Try replacing the single # with a double # in the column name... i.e. field#name would be field##name in your CFQuery block. > -Original Message- > From: Tristram Charnley [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 11:18 AM > To: CF-Talk > Subject: Column names containing a # sign > > > Hi > > I've been given a database containing column names such as > Product# and Registration# > > I've tried using aliases and backticks on these columns in my query to > no effect - the # sign throws CF each time. Changing the column names > isn't an option unfortunately. > > Any suggestions greatfully received. > > Tristram Charnley > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Regex?
If you have linux, use sed. something like: cat something.cfm|sed -e \ 'y/ABCDEFGHIJKLMNOPQRSTUVWXYZ/abcdefghijklmnopqrstuvwxyz/' | \ somethingelse.cfm that will do a character by character transformation. Mike > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 4:54 PM > To: CF-Talk > Subject: SOT: Regex? > > Hi all, > > Sorry for this slightly off topic post - I have exceedingly stupid (and > cheap) clients and need to know if this is possible. > > This client has created a huge site himself, incorporating gallery pages > with hundreds of images, both thumnails and high quality versions. > Considering everything, he hasn't done too bad a job - it looks fairly > good. Except the image files are named in a variety of ways - uppercase, > lowercase and mixed case - and the links to the images do not necessarily > match up with the image filenames with regard to case. This is going to be > deployed on a linux box, so that is obviously not going to work. > > Rather than cross-check each filename with the links, I am going to use a > utility to rename all the image files with all lower case. That's no > problem. What I am not sure about how to do is this: I want to use > extended find and replace in Studio to convert everything to lower case > that is inside a tag. Is this even possible? Not being a regex guru, I'm > hoping it is, because manually editing links in about 500 files does not > sound like my idea of a fun Wednesday afternoon, and something I'm sure > the client does not want to pay for. > > If anyone can help, I'd really appreciate it! > > 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
Turn off double-spacing on rds xfer
Short version: Does anyone know where the setting is in CF Studio 4.5 for preventing my files (that are transfered via RDS) from being converted to double-spacing (the lines of code?) Long version? When I first loaded CF Studio 4.5 about a year ago, all was fine. But the last 4 months, when I xfer my single-spaced .cfm source code file from our development server (a Sun UNIX box) to our staging server (also a Sun UNIX box), the files end up double-spaced. I have to open the file on the staging server, remove double-spacing, and resave it to rid it of the every-other (blank) line. I thought this had to do with the Options>Settings... and selecting File Settings where you can specify Unix file types. But mine is already set to Unix. Other teammate's CF Studio isn't behaving this way. Is a preference file corrupted or is there a logical explanation (and cure) for this problem??? - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [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: Column names containing a # sign
have you tried doubling your # ie product# = product## etc - cf should convert that to a single # before passing to db... -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:18 To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
You can always go back and smack the DB creator Not a solution, but may lower the stress level :o) but seriously, if the person that created the DB is still around, I hope someone explained to him, that you should NEVER put special chars in column names. -Original Message- From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:41 AM To: CF-Talk Subject: RE: Column names containing a # sign Two solutions: 1) Try escaping the names, as in Product##, in the CFQUERY and use a alias SELECT Product## AS ProductNum FROM whatever 2) Create a view on your database server that assigns an alias to each offending column. Always access the table through the view. Craig > -Original Message- > From: Tristram Charnley [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 12:18 PM > To: CF-Talk > Subject: Column names containing a # sign > > Hi > > I've been given a database containing column names such as > Product# and Registration# > > I've tried using aliases and backticks on these columns in my query to > no effect - the # sign throws CF each time. Changing the column names > isn't an option unfortunately. > > Any suggestions greatfully received. > > Tristram Charnley > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Debug output
Just change the font color as the last line in your template, like so: Be sure NOT to include a closing tag. The font color you set here will carry over to all the CF debug stuff at the bottom of the page. Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities - Original Message - From: "stas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 11:26 AM Subject: Debug output > Is there a way to capture CFAS's debug output and format it? My problem is > that if I develop a site that has a dark background, I can't see any debug > information because the text is dark too. I am mainly interested in looking > at SQL statements, I know you can see most other information (passed vars, > etc) using many of the custom tags. > > 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: Debug output
View Source from the browser works for me. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: "stas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 12:26 PM Subject: Debug output > Is there a way to capture CFAS's debug output and format it? My problem is > that if I develop a site that has a dark background, I can't see any debug > information because the text is dark too. I am mainly interested in looking > at SQL statements, I know you can see most other information (passed vars, > etc) using many of the custom tags. > > 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
CF-TALK
This list is acting strange... I am seeing some duplicate msgs posted. When I post, it doesn't show up (at least not after about an hour.) I didn't get any error msgs. What's up? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: Column names containing a # sign
Two solutions: 1) Try escaping the names, as in Product##, in the CFQUERY and use a alias SELECT Product## AS ProductNum FROM whatever 2) Create a view on your database server that assigns an alias to each offending column. Always access the table through the view. Craig > -Original Message- > From: Tristram Charnley [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 10, 2001 12:18 PM > To: CF-Talk > Subject: Column names containing a # sign > > Hi > > I've been given a database containing column names such as > Product# and Registration# > > I've tried using aliases and backticks on these columns in my query to > no effect - the # sign throws CF each time. Changing the column names > isn't an option unfortunately. > > Any suggestions greatfully received. > > Tristram Charnley > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: CFFTP
Here's a simple backup page I have to backup some files of ours daily. I use CF's Scheduler to run this every night. Richard Ramos Network Administrator Softitler Net, Inc. www.softitler.com [EMAIL PROTECTED] --- backup.cfm --- --- End file --- - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 9:16 AM Subject: CFFTP > Anyone have example code for sending a file via CFFTP? > > 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: Column names containing a # sign
Try doing Product## and Registration## HTH -- Original Message -- From: "Tristram Charnley" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Jul 2001 17:17:58 +0100 Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Column names containing a # sign
Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFTP
Anyone have example code for sending a file via CFFTP? 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
Debug output
Is there a way to capture CFAS's debug output and format it? My problem is that if I develop a site that has a dark background, I can't see any debug information because the text is dark too. I am mainly interested in looking at SQL statements, I know you can see most other information (passed vars, etc) using many of the custom tags. 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: Regex?
I'd use a cfm template for this... I'm assuming you have CF running on the server where the image files are at. Do a CFDIRECTORY to get the files. Loop over the file list and to a followed by This should effectively take care of your problem. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 4:54 PM To: CF-Talk Subject: SOT: Regex? Hi all, Sorry for this slightly off topic post - I have exceedingly stupid (and cheap) clients and need to know if this is possible. This client has created a huge site himself, incorporating gallery pages with hundreds of images, both thumnails and high quality versions. Considering everything, he hasn't done too bad a job - it looks fairly good. Except the image files are named in a variety of ways - uppercase, lowercase and mixed case - and the links to the images do not necessarily match up with the image filenames with regard to case. This is going to be deployed on a linux box, so that is obviously not going to work. Rather than cross-check each filename with the links, I am going to use a utility to rename all the image files with all lower case. That's no problem. What I am not sure about how to do is this: I want to use extended find and replace in Studio to convert everything to lower case that is inside a tag. Is this even possible? Not being a regex guru, I'm hoping it is, because manually editing links in about 500 files does not sound like my idea of a fun Wednesday afternoon, and something I'm sure the client does not want to pay for. If anyone can help, I'd really appreciate it! 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: Help needed with CFCONTENT
Jochem Thanks for your suggestions so far. I like to shoot the web browser developers, tho not the customer :o) But I think I have not explained very well, or am not understanding. I am on an NT 4.0/SP6a server, using ColdFusion 4.5.1.(hopefully to upgrade to 5.0 soon) When I add the filename, is looking for the file to already exist, which it does not, the user will be creating it at the time of viewing, saving it on their drive. Maybe I am doing something else wrong. here is a simple look at the process. User is given options to create the graph from, this information is then sent to a custom tag (I down loaded from tag gallery, uses tables to build bar graphs). on the action page I place the call to the tag, with at the top of page: with your suggestions looks like: and as I said, when user chooses to save file, this works fine a PowerPoint file is saved that can be later view in PowerPoint, but when the user chooses to open from present location, it displays fine, just errors when user moves or clicks on scroll bar. I don't need it to display here, just save as a file, if there is another way to get this graph saved as a PowerPoint slide I could use that. I also do the same for creating Excel spreadsheets and Word Docs. I have no problems with them. again thanks for your help in working through this Rodney -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 11:30 PM To: CF-Talk Subject: Re: Help needed with CFCONTENT Bruce, Rodney wrote: > The problem with using "application/octet-stream", is that the user doesn't > get the option to save the file. > > I want the user to be able to save the file just not open it in the browser. > The purpose is for the user to save as PowerPoint slide, to be added to > presentations later. Forgot to mention that you will also need a content-disposition header. If this doesn't work, shoot the customer for using a browser that does not adhere to the suggestions made in RFC 2616, paragraph 19.5.1, which is still the formal definition of the HTTP protocol. Jochem ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: cfloop and group
Bryan Love wrote: > wow. > > First of all it looks like you've forgotten to use #innerloop# anywhere in > your code. The query is hard-coded to use [1] and [2] from the second > dimension of your array. Perhaps each item in the first dimension contains > a sub-array of only two items (documentID and headingID). If this is the > case then why are you looping over the second dimension? This would cause > the exact same query to be run twice, outputting the same single record each > time. If this is the case then just eliminate the inner CFLOOP and remove > GROUP= from the CFOUTPUT. The innerloop was a leftover from the code in Chapter 9 of the Developing Web Applications with ColdFusion book. Where I hard coded the 1 and 2 had been where innerloop would've been. I knew that column 1 was headingids and column 2 was docids, but I needed to loop through all the pairs of ids to find and output the actual names of documents and headings. I took the innerloop and group out and got the same result was before. > > Secondly, putting a query inside a double nested loop is not a very good > idea. CFOUTPUT was given a GROUP attribute to avoid this kind of situation; > it's just a matter of learning to use it correctly. It looks like you are > basically trying to print the collection of documents stored in the > original array. The only reason the query is inside the loop is so I can refer to the elements inside the array in my query. I'm not trying to use cfloop to group it, just use it to retreive the ids for the array so the query can use them to get the names (and other associated information). I don't know how else to retreive the information in the array without looping. > a query like this would be much more efficient: > > SELECT ... > FROM ... > WHERE document.documentid IN (...docID list...) > AND headingid IN (...headingID list...) > AND (join document and heading somehow here so ensure the proper > records are related to each other) > and document.nameno=articlenames.nameno > and document.documentid=article.documentid > order by headingname, articlename > > Then you can use the GROUP attribute in your CFOUTPUT to control the output > > FYI: GROUPs can be nested... > > > > > > That last AND (join document and heading somehow here so ensure the proper records are related to each other) is the problem. I can't figure out how to do it without cfloop. The two columns of the array were originally 2 query-driven lists that I converted into an array. So I thought I'd use listgetat to synchronize the position in the lists, but that would require using a loop to go through the lists. Any ideas on how to sync the lists without looping? Thanks! Jen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: RESERVED/KEYWORDS
Depends on the database, since most vendors have extensions to standard SQL. For MS Access, see "reserved words" in the online Help index. The Oracle SQL Reference (http://helios.a.tu-berlin.de:8000/wg73-doc/server/sql73/ch201.html) lists Oracle- and ANSI-reserved words. -David On Tuesday, July 10, 2001 8:01 AM, James Taavon [SMTP:[EMAIL PROTECTED]] wrote: > I wanted to know if there is somewhere on the web that lists reserved > and keywords to prevent me from using them in my database by accidently. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: ? about CF and Sybase
you *must* have the sybase open client installed on the machine you're connecting with if you want to use the native drivers. and you need version 11.1.0 with update 11.1.1 applied. ODBC does *not* require the sybase open client though. we connect to a remote sybase DS using ODBC. works great. -Original Message- From: Chris Alvarado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 8:09 AM To: CF-Talk Subject: ? about CF and Sybase I am trying to get CF to use the Sybase native drivers and whenever CF tries to verify the connection to the Sybase server it fails. here is what i have in the CF administrator in case maybe im overlooking something or im doing something wrong. Data Source Name: abc123 Description: description Server: 123.123.123.123:1234 (is that how it should be to specify a port number? or should i use a comma?) Default Database: DefaultDB the rest is pretty self explanatory...im just curious to know if i have entered in the Server correctly? thanks for any help -chris ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: MSXML, XML, outputting attributes?
So, "//" should probably be used once to get at the root node? What other methods are faster than using the "//" xpath statement? In my code I used the following effectively: nodeOffer_Id = service.selectSingleNode("Offer_Id"); Offer_Code = service.selectSingleNode("Offer_Id/@Offer_Code"); Offer_Code = Offer_Code.text; Your code also worked the same. Thanks! Carl - Original Message - From: "Edward Smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 10:43 AM Subject: Re: MSXML, XML, outputting attributes? > Just a note, try to avoid using "//" in xpath - its has serious > performance problem potential. > > Its essentially saying, "scan the whole DOM and look for any 'book' > nodes." I don't think that this is what you want. > > In your real code, you are already in the "Service_Availability" node, > so you don't need to use "//Offer_ID" Just use "Offer_ID", as its a > direct child node of the Service Availability. This will prevent the > parser from starting at the top of the DOM again. Also, on my MSXML 3 > SP1, if you use //Offer_ID for the xpath statement, I always get the > first offer_id, which makes sense, since it matches the first one it > finds in the DOM, every time. > > So, the bit of code would be: > > i=i+1; > nodeOffer_Id = service.selectSingleNode("Offer_Id"); > Offer_Id = nodeOffer_Id.text; > Offer_Code = nodeOffer_Id.getAttribute("Offer_Code"); > > > Merging in the previous suggestion: > > > i=i+1; > nodeOffer_Id = service.selectSingleNode("Offer_Id/@Offer_Code"); > Offer_Code = nodeOffer_Id.text; > > > > Carl wrote: > > > > Thanks, Brett! That worked pefect. > > Carl > > - Original Message - > > From: "Brett Suwyn" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Monday, July 09, 2001 3:31 PM > > Subject: RE: MSXML, XML, outputting attributes? > > > > > You can access them directly with XPath or the GetNamedItem method > > > called on the node. > > > > > > For example (using XPath): > > > > > > > > > iBookID = xmlDoc.selectSingleNode("//book/@id"); > > > > > > > > > > > > Brett Suwyn > > > mailto:[EMAIL PROTECTED] > > > http://forums.siteobjects.com > > > > > > |> -Original Message- > > > |> From: Carl [mailto:[EMAIL PROTECTED]] > > > |> Sent: Monday, July 09, 2001 3:08 PM > > > |> To: CF-Talk > > > |> Subject: MSXML, XML, outputting attributes? > > > |> > > > |> > > > |> Hi, > > > |> How do I output attributes from an XML document? I have > > > |> tried using the following example on Microsofts website. > > > |> > > > |> MS EXAMPLE: > > > |> var xmlDoc = new ActiveXObject("Msxml2.DOMDocument"); > > > |> var nodeBook, sIdValue; > > > |> xmlDoc.async = false; > > > |> xmlDoc.load("books.xml"); > > > |> nodeBook = xmlDoc.selectSingleNode("//book"); > > > |> sIdValue = nodeBook.getAttribute("id") > > > |> alert(sIdValue); > > > |> > > > |> Thanks!! > > > |> Carl > > > |> > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: Regex?
Hi all, Sorry for this slightly off topic post - I have exceedingly stupid (and cheap) clients and need to know if this is possible. This client has created a huge site himself, incorporating gallery pages with hundreds of images, both thumnails and high quality versions. Considering everything, he hasn't done too bad a job - it looks fairly good. Except the image files are named in a variety of ways - uppercase, lowercase and mixed case - and the links to the images do not necessarily match up with the image filenames with regard to case. This is going to be deployed on a linux box, so that is obviously not going to work. Rather than cross-check each filename with the links, I am going to use a utility to rename all the image files with all lower case. That's no problem. What I am not sure about how to do is this: I want to use extended find and replace in Studio to convert everything to lower case that is inside a tag. Is this even possible? Not being a regex guru, I'm hoping it is, because manually editing links in about 500 files does not sound like my idea of a fun Wednesday afternoon, and something I'm sure the client does not want to pay for. If anyone can help, I'd really appreciate it! 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: Temporarily disabling DB constraints
In enterprise manager, you can go into the table properties, find the constraint in the dropdown box and uncheck 'ENABLE CONSTRAINT FOR REPLICATION'. That works in SQL 7, I don't know about 2000 -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 16:00 To: CF-Talk Subject: Temporarily disabling DB constraints Hello, I'm using MS SQL2000 and need to replicate data from one box to another. The process is failing because of certain constraints. Is there a non-hack workaround to this issue? 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: RESERVED/KEYWORDS
Access Reserved words can be found at: http://support.microsoft.com/support/kb/articles/q109/3/12.asp SQL Server Reserved words can be found in the SQL Server Books Online. Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -- -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:01 AM To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. 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
? about CF and Sybase
I am trying to get CF to use the Sybase native drivers and whenever CF tries to verify the connection to the Sybase server it fails. here is what i have in the CF administrator in case maybe im overlooking something or im doing something wrong. Data Source Name: abc123 Description: description Server: 123.123.123.123:1234 (is that how it should be to specify a port number? or should i use a comma?) Default Database: DefaultDB the rest is pretty self explanatory...im just curious to know if i have entered in the Server correctly? thanks for any help -chris ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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: RESERVED/KEYWORDS
Ben Forta SQL in 10 minutes lists them all at the back Very very usfull if you've accidently called a field date... Not sure of a web resource tho Mike -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 16:01 To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. 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: RESERVED/KEYWORDS
And for Access 2000 http://support.microsoft.com/support/kb/articles/q209/1/87.asp Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -- -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:01 AM To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. 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: RESERVED/KEYWORDS
Don't think so because each poece of database software will have a different list of keywords as a keyword in one db may not be one in another. Your best bet would be to look at documentation pertaining to your database product. -- Andrew Ewings Project Manager Certified Advanced Coldfusion Developer 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. -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 16:01 To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. 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
RESERVED/KEYWORDS
Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. 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
Temporarily disabling DB constraints
Hello, I'm using MS SQL2000 and need to replicate data from one box to another. The process is failing because of certain constraints. Is there a non-hack workaround to this issue? 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: MSXML, XML, outputting attributes?
Just a note, try to avoid using "//" in xpath - its has serious performance problem potential. Its essentially saying, "scan the whole DOM and look for any 'book' nodes." I don't think that this is what you want. In your real code, you are already in the "Service_Availability" node, so you don't need to use "//Offer_ID" Just use "Offer_ID", as its a direct child node of the Service Availability. This will prevent the parser from starting at the top of the DOM again. Also, on my MSXML 3 SP1, if you use //Offer_ID for the xpath statement, I always get the first offer_id, which makes sense, since it matches the first one it finds in the DOM, every time. So, the bit of code would be: i=i+1; nodeOffer_Id = service.selectSingleNode("Offer_Id"); Offer_Id = nodeOffer_Id.text; Offer_Code = nodeOffer_Id.getAttribute("Offer_Code"); Merging in the previous suggestion: i=i+1; nodeOffer_Id = service.selectSingleNode("Offer_Id/@Offer_Code"); Offer_Code = nodeOffer_Id.text; Carl wrote: > > Thanks, Brett! That worked pefect. > Carl > - Original Message - > From: "Brett Suwyn" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, July 09, 2001 3:31 PM > Subject: RE: MSXML, XML, outputting attributes? > > > You can access them directly with XPath or the GetNamedItem method > > called on the node. > > > > For example (using XPath): > > > > > > iBookID = xmlDoc.selectSingleNode("//book/@id"); > > > > > > > > Brett Suwyn > > mailto:[EMAIL PROTECTED] > > http://forums.siteobjects.com > > > > |> -Original Message- > > |> From: Carl [mailto:[EMAIL PROTECTED]] > > |> Sent: Monday, July 09, 2001 3:08 PM > > |> To: CF-Talk > > |> Subject: MSXML, XML, outputting attributes? > > |> > > |> > > |> Hi, > > |> How do I output attributes from an XML document? I have > > |> tried using the following example on Microsofts website. > > |> > > |> MS EXAMPLE: > > |> var xmlDoc = new ActiveXObject("Msxml2.DOMDocument"); > > |> var nodeBook, sIdValue; > > |> xmlDoc.async = false; > > |> xmlDoc.load("books.xml"); > > |> nodeBook = xmlDoc.selectSingleNode("//book"); > > |> sIdValue = nodeBook.getAttribute("id") > > |> alert(sIdValue); > > |> > > |> Thanks!! > > |> Carl > > |> > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://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 a text file as a datasource
Thanks chaps...spot on. > -Original Message- > From: Philip Arnold - ASP [SMTP:[EMAIL PROTECTED]] > Sent: 10 July 2001 14:49 > To: CF-Talk > Subject: RE: Using a text file as a datasource > > > I'm trying to set up a text or csv file as a datasource in the CF > > administrator. Each time I try to set up an ODBC datasource with the > > Microsoft text driver, the connection to the datasource fails. > > Does anybody > > know how to get this to work? The server is an NT box. > > Text ODBC datasources are actually set to directories, not the file, then > in > the query you use; > select field1, field2 > from myFile.txt > > where "myFile.txt" is the name of the file > > I've used them before - not particularly quick, but they work > > 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
Announcement: CF_ResendUndeliverableMail3 released
In addition to the capabilities of the V2 of this tag, V3 adds the following functionalities: - Respool undelivered mail to a list of different SMTP servers. - Move (not delete) perpetually failing mail after X days. - Admin notification of perpetually failing mail, including number of messages failed, a copy of each failed message, the name of the machine on which they failed, and the directory failed messages were moved into. - Multiple email addresses can be notified on failures. - Ability to scrub bare linefeeds off messages which have been refused by SMTP programs such as Qmail's. - Ability to eliminate zero length files from the spool (CF4.5 bug) - Two new columns on the query returned from this tag Action and Reason, which describe the action taken on the file (moved, deleted, etc) and the reason this action was taken. You can download it here: http://devex.allaire.com/developer/gallery/info.cfm?ID=05D90D06-6C6B-11D5-83 F100508B94F85A -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists