Application.cfm whats that ?
hi, We have shifted our service providers and the new people here require us to have an APPLICATION.CFM file in our public_html directory. This is the first time that I have come accross some thing like this .. What should I be doing here ... Yeah ... our site does use a lot of session variavbles ... but is it necessary to have this file .. We are running our site on a shared ColdFusion server on a Solaris box. thanks VIN -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Application.cfm... whats that ?
hi, We have shifted our service providers and the new people here require us to have an APPLICATION.CFM file in our public_html directory. This is the first time that I have come across some thing like this .. What should I be doing here ... Yeah ... our site does use a lot of session variables ... but is it necessary to have this file .. We are running our site on a shared ColdFusion server on a Solaris box. thanks VIN -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Application.cfm... whats that ?
If you are not running a CF site, you don't personally need it. But, if the SP requires it, I would just create a blank file named application.cfm and upload it to where they want it. Jeff - Original Message - From: vince [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 13, 2000 10:34 PM Subject: Application.cfm... whats that ? hi, We have shifted our service providers and the new people here require us to have an APPLICATION.CFM file in our public_html directory. This is the first time that I have come across some thing like this .. What should I be doing here ... Yeah ... our site does use a lot of session variables ... but is it necessary to have this file .. We are running our site on a shared ColdFusion server on a Solaris box. thanks VIN -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Categories tree
Francisco, There is an article on recursion at the Defusion site (http://www.defusion.com/articles/index.cfm?ArticleID=63) that might help. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner NetObjects Reseller 210-490-3249/888-745-7603Fax 210-490-4692 Find a Job in San Antoniohttp://www.sajobnet.com -Original Message- From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:06 PM To: [EMAIL PROTECTED] Subject: Categories tree Hi all, I don=B4t know if it=B4s just me or this is quite tricky. All i want to = do is what CFtree does but without using an applet do it. I=B4ve got a = set of categories and subcategories. Unfortunately the depth of the tree = is not fixed so basically we can add categories under a certain category = forever. I=B4m not aware of any single piece of CF code that uses recursive = principles to achieve tasks. Tried to use a looping version of what i = need instead but i just can=B4t come up with a solution to retrieve = information no matter the depth of the category tree (yes, it=B4s been a = really bad day for me today). I=B4ve already got the code for creating a = nice dhtml tree but i just can=B4t find the way or sequence i need to = generate the whole block of code. Something following a secuence like: Branch - Category 1 Leaf - Category 2 Leaf - Category 3 Branch - Category 4 Leaf - Category 5 Branch - Category 6 Leaf - Category 7 Leaf - Category 8 ... etc. Any ideas? TIA Francisco Montes -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Application.cfm... whats that ?
the cfapplication tag doesn't _have_ to be in the application.cfm file, just ususally is, because thats where it makes sense to put it. [EMAIL PROTECTED] wrote: Yeah ... our site does use a lot of session variables ... but is it necessary to have this file .. How did you set up session scoped variables without using the application.cfm file? Normally you need a cfapplication name="something" sessionmanagement="yes" tag in your application.cfm file to turn on session variables. Or have I completely misunderstood? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Application.cfm... whats that ?
the cfapplication tag doesn't _have_ to be in the application.cfm file, just ususally is, because thats where it makes sense to put it. True enough, but if you know enough CF to use session variables why would you not know what the application.cfm file is? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Application.cfm... whats that ?
*** A BLANK application.cfm file causes problems (not sure if it has been fixed in 4.5.1). At least have something in it even if it is comments. Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: Jeffrey A. Zubeck [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 1:46 AM To: [EMAIL PROTECTED] Subject: Re: Application.cfm... whats that ? If you are not running a CF site, you don't personally need it. But, if the SP requires it, I would just create a blank file named application.cfm and upload it to where they want it. Jeff - Original Message - From: vince [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 13, 2000 10:34 PM Subject: Application.cfm... whats that ? hi, We have shifted our service providers and the new people here require us to have an APPLICATION.CFM file in our public_html directory. This is the first time that I have come across some thing like this .. What should I be doing here ... Yeah ... our site does use a lot of session variables ... but is it necessary to have this file .. We are running our site on a shared ColdFusion server on a Solaris box. thanks VIN -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Success Return Codes
I spent a few minutes looking at SQL Server Books Online, and couldn't find anything which SQL Server would automatically return how many records were updated by a query. You can use the RETURN keyword within a stored procedure to return a value, or you could use RAISERROR to throw an error, but I didn't find what you're looking for, and I don't think it exists, at least not in SQL Server. what about @@ROWCOUNT? it returns the number of rows affected by the last sql statement. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thumbnail tags
Hmmm - so what where these commands that weren't properly formatted? I'm just curious because like I said, for me its working like a champ straight from download. I'm using the other image tags such as CFX_GifGD as well, to establish what can do what best - but AutoResize's thumbnail stuff fitted my needs perfectly -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Brian P. Doyle [mailto:[EMAIL PROTECTED]] Sent: 13 July 2000 19:45 To: [EMAIL PROTECTED] Subject: RE: Thumbnail tags Actually I got CF_AutoResize to work. I came up with numerous bugs but it finally ended up that the commands to cfx_image in the source code for autoresize.cfm were not delimited correctly. As soon as I fixed that it worked like a champ. I also had to add some more error checking so that it will not allow files that are not image files. Basically I just improved upon cfx_imageresize to create a great way to upload all images. Date: Thu, 13 Jul 2000 07:51:26 +0100 From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Thumbnail tags Message-ID: [EMAIL PROTECTED] BTW, what was wrong with CF_AutoResize? I'm using it without any problems whatsoever... What errors where you getting? -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF COM
Steve Bernard wrote: I'm not sure exactly what you mean by registering the component with NT's Scheduler but, if you mean that you have the component started by the Scheduler Service be aware that the component will be running under the System Account. This will give the component, and thereby and script calling it, extremely powerful rights on the local machine. I'd be careful if you are in a multi-user development environment. Steve Thanks for the feedback, Sorry if that wasn't clear - I ran the object's registration function from an 'AT' statement. This was a suggestion from the 'Componenet Dev' CF forum: If CF is running as system, use the (AT) task schedule service to register the component as system. I'll try anything once! Cheers, Cam. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
hide the file name on addressbar
hi all, One of my client asked abt this. Is there any way to execute the Application after user loggedin by hiding the file name on the address bar. i mean, user can see first the login page. after his successful login to the site, he should not see the file names throughout his navigation on the site. if anybody has idea plzz help me. thanx and regards nagesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: FIrmware Design in Australia - anyone else deal with thesepeople?
This is a multi-part message in MIME format. --926ED33E0612753A6B4903EB Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit Hi Mike, I'm also a reseller of Allaire products and have also used their hosting service for many years, while my direct dealings with the likes of Chris Wood, Chris Smoother and Lucas have been pretty good, the same can't be said for the 'front-end' of the business. I too have trouble getting emails and phone calls returned. Two recent episodes have caused me to become very frustrated with them.. mainly to do with sales, and I have had no comment or positive response from Firmware. For example, I purcahsed a few products just before the end of the tax year to beat the introduction of GST, one being a copy of Ultradev, I must have stated half a dozen times that it was to upgrade DreamWeaver 2, yet when the package arrived on Tuesday, it states in big letters on the front of the box 'Special Offer for DW 3 Users'. Great... so I have a copy of Ultradev I can't use, and now I have to fork out for the upgrade, with the additional GST, just to get it to work. This isn't a financial problem, but the sales staff should have known about this, and I feel that being their mistake they should at least provide the upgrade at the pre-GST price as I would have ordered it there and then had I known. Fortunately, it's only a single upgrade of DW 3 that's required, but what if it was 20 copies we were buying or a far more expensive product? As already stated, my experience with ChrisW, ChrisS and Lucas has been mostly positive (although, Lucas, I never received some code from the Spectra course I requested, any response on a bug I submitted, or any reply to a message I sent to you regarding the Allaire Partner Program!!) and I wish that the other areas of the company was as helpful. Mike Kear wrote: I'm a reseller of Allaire products in Australia, trying to build a business round ColdFusion, Spectra etc, and have the greatest difficulty getting any sense out of FIrmware Design, their distributors in Australia They never answer the phone - only a computer answers it. They only call back after I've left a dozen messages. They never follow up. Their support took 40 emails and some VERY IRATE calls to prod them into action to help me with a Studio4.5.1 problem, and even then, it isn't fixed after months of trying. (I've given up on it with my clients - I won't let them waste over A$1000 on a useless shoddy product like Studio) The only people I've talked to at Firmware apologise profusely for the lack of interest, but there's no action to follow it up. It ends with the apology Is this just me?? Is anyone else dealing with Firmware and can claim they're responsive and helpful? Am I going about it the wrong way with them? Or if lots of others are having the same experience, perhaps we ought to form a company ourselves and lobby Allaire to dump them as distributors and let us do it ourselves. Cheers, MIke Kear AFP Web Development Windsor, NSW, Australia Mike Kear [EMAIL PROTECTED] www.afp.zip.com.au Windsor, NSW, Australia AFP Web Development AFP Electronic Forms AFP Models -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --926ED33E0612753A6B4903EB Content-Type: text/x-vcard; charset=us-ascii; name="nickslay.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Nick Slay Content-Disposition: attachment; filename="nickslay.vcf" begin:vcard n:Slay;Nick tel;cell:0414 810284 tel;home:02 4381 0284 tel;work:02 4381 0284 x-mozilla-html:FALSE url:http://www.webbods.com.au org:Webbods Pty Ltd adr:;;PO Box 4054;Copacabana;NSW;2251;Australia version:2.1 email;internet:[EMAIL PROTECTED] title:Technical Director x-mozilla-cpt:;3 fn:Nick Slay end:vcard --926ED33E0612753A6B4903EB-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: hide the file name on addressbar
One way is to use frames and have all navigation done through a NavBar frame. Any links within the same frame are OK (target page is displayed within the same frame/window as the linking frame) Links to another frame/window can be handled with JavaScript. You can see this in action (well mostly) in a development site at: http://.itool.com/db/sgcpbu/www/w/ Suppliers -- M --- Martin Marietta... --- Logo or Link Everything, preserves the original address bar except The banner ad (3rd party package) links (Top right frame) a and in a couple of the main frames. I am working on eliminating these! Dick At 5:31 PM +0800 7/14/2000, Nagesh Kumar Deva wrote: hi all, One of my client asked abt this. Is there any way to execute the Application after user loggedin by hiding the file name on the address bar. i mean, user can see first the login page. after his successful login to the site, he should not see the file names throughout his navigation on the site. if anybody has idea plzz help me. thanx and regards nagesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFX_MAIL port
Hi, Does anyone know which TCP/UDP port is used by CFX_MAIL? Greetings from Amsterdam, Yuri E. Vorontsov, Drs - Language Networks BV Tel 020 33 00 333 Tel 062 278 4728 (cell.) Fax 020 33 00 334 Email: [EMAIL PROTECTED] Visit Aquarius Directory at http://aquarius.net World's largest community of language professionals 12000+ translators and 2000+ translation agencies -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: hide the file name on addressbar
use fusebox methodology and they will never know the names of your files. www.fusebox.org -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: FIrmware Design in Australia - anyone else deal with thesepeople?
G'day Nick, Thanks for your response. My problem right now is I have a spectra sale that's about to happen. 3 competitors are busy as hell in there and I can't get the buggers to even talk to me about it. And no one's told me about any spectra courses. mostly positive (although, Lucas, I never received some code from the Spectra course I requested, any response on a bug I submitted, or any reply to a message I sent to you regarding the Allaire Partner Program!!) "Sent to 'you' ?Nick do you mean me, Mike Kear in that sentence? Did you send me an email about that?I'm sorry, but if you did I dont have it .. it's got lost and I would like you to send it again please. If you meant Lucas by the word "you" in that sentence, that's cool. cheers, Mike Kear [EMAIL PROTECTED] www.afp.zip.com.au Windsor, NSW, Australia AFP Web Development AFP Electronic Forms AFP Models -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Application.cfm... whats that ?
On 7/14/00, Hoffman, Joe (CIT) penned: A BLANK application.cfm file causes problems (not sure if it has been fixed in 4.5.1). At least have something in it even if it is comments. A blank ANY Cold Fusion template can't be parsed. You could just put a comment line in it: !--- Hide me --- -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Forums 2.06 error
Apologies in advance if this is slightly OT, or there is a better forum to post it to, but I have just installed Allaire Forums 2.06 (CF 4.01), and although it installed fine, and everything seems to work OK - admin etc.. - if I try to post a message I get the following: Error occurred in tag CFINDEX Collection failed to open: Forums_CFForums_Messages I haven't been able to fix this yet - any ideas anyone please. Does the ".mdb" file upsize to SQL Server OK? Thanks. Adrian Cooper. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Literate Programming Cold Fusion
Hi all, hows things. Good? Great! * If you don't know about literate programming, * skip the next couple of paragraphs for an explanation. I was `turned onto' literate programming at University using noweb (and some extentions I wrote for it) mainly with C . Anyway I would love to be able to apply literate programming tools and principles to my cold fusion application writing, but I'm not sure of the best way to go about it. I write in fusebox and I know of fusedoc but I don't think it goes far enough, I would like to be able to produce nicely formatted implementation documentation for every inch of a project - not just a brief over-view of each fuse. Has anybody tried, succeeded or failed in an attempt to write CF in a literate style, and if so what tools, techniques and tricks did you use, write or learn in doing so ? Ideally I'd like to use tools to allow me to write literately in Studio and then generate LaTex (or HTML would be OK too) documentation from the source. * Explanation - if you know about literate programming you need not read this * next paragraph. For the un-initiated, literate programming [LP] is a means (invented by the computer scientists god - Knuth himself) by which "the program is the documentation" (and vica versa), basically as you write a program you write the (implementational) documentation about your program in the same files (the method for doing this varies from LP system to LP system and may or may not (the way I prefer) require intermediate weaving step(s) to produce an actual program from the single file). This enables you to describe every little bit of source code as you write it which can then be turned into a nice documentation collection for future reference (when things go bad :-) ). There are a number of LP systems around, noweb, nuweb and cweb come to mind instantly. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Variable IN a list? How to check?
cfif #deptid# contains #session.privileges# Avoid using this on lists The main reason is that if you're looking for "1", then it'll return 10, 11, 21, etc. etc. Try to use the List functions, or extend the CFIf to be; cfif ",#deptID#," contains ",#session.priviliges#," which is faster than the List functions HTH Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFLOCK - HEELLLLPPP!!!
OK. I don't get this. I'm working on a site hosted on Virtualscape. I've never run across this before: ___ An error occurred while evaluating the expression: session.rollcount = "1" Error near line 189, column 7. Symbol session.rollcount is in a scope that contains data shared across threads and cannot be accessed without an active lock ___ Are there any hidden parameters for cflock I don't know about? Could this be because the server is running CF 4.5? I've used my cart on servers running 4.5 though. Could they have something set up in CF Administrator? Below is my cfapplication tag and the block of code that's throwing the error (just testing for cookies and setting cfid and cftoken query string if needed). Anybody see anything askew? cfapplication name="successway" clientmanagement="Yes" sessionmanagement="Yes" sessiontimeout=#CreateTimeSpan(0, 0, 20, 0)# setclientcookies="Yes" CFIF not isdefined('session.rollcount') cflock timeout="60" cfset session.rollcount = "1" /cflock cfcookie name="mycookie" value = "test" expires="1" cflock timeout="60" cfset session.ID = "cfid=#client.cfid#cftoken=#client.cftoken#" /cflock cfelse cflock timeout="60" cfset session.ID = "#IIf(not isDefined('cookie.mycookie'), DE ('cfid=#client.cfid#cftoken=#client.cftoken#'), DE(''))#" /cflock /CFIF -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Success Return Codes
I spent a few minutes looking at SQL Server Books Online, and couldn't find anything which SQL Server would automatically return how many records were updated by a query. You can use the RETURN keyword within a stored procedure to return a value, or you could use RAISERROR to throw an error, but I didn't find what you're looking for, and I don't think it exists, at least not in SQL Server. what about @@ROWCOUNT? it returns the number of rows affected by the last sql statement. That's what I used in the sample trigger I included earlier in this thread, but as far as I know, your query itself has to actually reference @@ROWCOUNT and specifically return it; it won't just "be there" in your application if you don't. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Allaire DevCon Earlybird Registration Ends July 26
Reminder: You only have a few weeks left to save on registration for the upcoming Allaire Developer Conference (November 5-8, Washington, D.C.). Register before July 26, 2000, and save $100 by visiting http://www.allaire.com/conference. Remember - last year's conference sold out! There are lots of reason to attend, including: * Hands-on training and technical workshops * Unveiled Allaire technologies and product demonstrations * Complimentary partner solutions on display in the exhibit area Plus an opportunity to become a Certified ColdFusion Developer! Allaire is offering the Certified ColdFusion (4.5) Developer Exam at the conference. This program is designed to recognize select Web developers for their expertise in developing and deploying Web applications with ColdFusion through a challenging examination process. Pre-registration for the exam begins Friday, July 21 at a discounted fee of $100. If space is available, the onsite registration fee is $150. For prerequisite information, benefits, exam hours, registration information, and more, visit http://www.allaire.com/conference/certification.cfm. We hope to see you in D.C. in November! Regards, Allaire Events -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: For those of us Desperately in Need of CFMail Help
This may be related to your problem and will probably help others sending HTML formatted messages... We were sending HTML formatted e-mails to a distribution list. When we upgraded to CF4.5.1 (from 4.1 or something), all of the people who were on this list using Lotus or Groupwise for their mail clients starting receiving the messages as raw HTML code (no formatting). We compared the headers from previous messages sent by CF4.1 and new messages sent by CF4.5.1 and found the following omissions in the messages... cfmailparam name="MIME-version" value="1.0" cfmailparam name="Content-Type" value="text/html; charset=us-ascii" cfmailparam name="Content-Transfer-Encoding" value="7bit" We added these to the messages (especially the MIME-version header) and the problem was resolved. So now we have to add these headers to every CFMAIL tag we use that contains HTML formatted messages. Hope this is helpful to anyone else having similar problems. Kevin -Original Message- From: Jonathan McGuire [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 12:44 PM To: [EMAIL PROTECTED] Subject: For those of us Desperately in Need of CFMail Help I know that this has been bounced around some, but after much searching, = I have been unable to find any type of solution.=20 I posted the following to the Allaire forums 3 days ago. I have since = posted a rather scathing response to my own message in the futile hope = that someone at Allaire might actually look at it. Anyway, for all of = us that have been trying to make CFMail work like a "Real" mail = client, here is the problem (and a proposed solution). It's very simple = and could be done in a patch.=20 Posting follows:=20 =20 It is apparent that the designers of the CFMail tag, despite their best = intentions, did not fully understand the ramifications of simplifying = certain things in CFMail tag.=20 My personal issue is the fact that MIME Attachments are always sent as = "base64" encoded. This (to the best of my ability to find...) is = preventing me and others from sending combined HTML/Plain Text email.=20 Normally in an SMTP client, the HTML and Plain Text are sent BOTH sent = as "quoted printable" thus allowing a HTML capable mail client able to = grab the HTML MIME Part, and a text mail client the Plain Text Mail = Part.=20 CFMail requires that the attachment be loaded from a file, I can deal = with this. However, why can't I change the Content-Encoding header for = THAT MIME Part? This in and of itself would probably fix about 15% of = the screaming need for help with CFMAIL!=20 Does anyone have a solution to this yet? I have looked at a couple of = third party products, but none of them seems to fix this either. Someone = please respond (Allaire, is anyone in that new building yet?)!!!=20 Email me and I will gladly discuss this by phone if you can help.=20 Frustatedly yours, Jonathan McGuire=20 --=_NextPart_000_00F0_01BFECC7.FB370FC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2 DIVFONT face=3DArial size=3D2 PI know that this has been bounced around some, but after much = searching, I=20 have been unable to find any type of solution.=20 PI posted the following to the Allaire forums 3 days ago.nbsp; I have = since=20 posted a rather scathing response to my own message in the futile hope = that=20 someone at Allaire might actually look at it.nbsp; Anyway, for all of = us that=20 have been trying to make lt;CFMailgt; work like a "Real" mail client, = here is=20 the problem (and a proposed solution).nbsp; It's very simple and could = be done=20 in a patch.=20 PPosting follows:=20 P=20 PIt is apparent that the designers of the CFMail tag, despite their = best=20 intentions, did not fully understand the ramifications of simplifying = certain=20 things in CFMail tag.=20 PMy personal issue is the fact that MIME Attachments are always sent = as=20 "base64" encoded. This (to the best of my ability to find...) is = preventing me=20 and others from sending combined HTML/Plain Text email.=20 PNormally in an SMTP client, the HTML and Plain Text are sent BOTH = sent as=20 "quoted printable" thus allowing a HTML capable mail client able to grab = the=20 HTML MIME Part, and a text mail client the Plain Text Mail Part.=20 PCFMail requires that the attachment be loaded from a file, I can deal = with=20 this. However, why can't I change the Content-Encoding header for THAT = MIME=20 Part? This in and of itself would probably fix about 15% of the = screaming need=20 for help with CFMAIL!=20 PDoes anyone have a solution to this yet? I have looked at a couple of = third=20 party products, but none of them seems to fix this
Re: My solution:Variable IN a list? How to check?
Ok..here is the solution I came up with and Morning everybody =) !--- SECURITY CODE CFIF IsDefined('DeptID') CFLOOP INDEX="x" FROM="1" TO="#ListLen(form.DeptID)#" cfif ListContains(session.currentprivileges,ListGetAt(form.DeptID,x),",") EQ 0 cflocation url="#noclearance#" addtoken="yes" /CFIF /CFLOOP /CFIF !--- End SECURITY CODE Is this the most eloquent solution to the problem? :-) -Gel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFLOCK - HEELLLLPPP!!! Never mind
Hi. I wasn't setting the type or scope in the cflock tag. Nothing in Mr. Forta's book about the scope or type attributes. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Success Return Codes
what about @@ROWCOUNT? it returns the number of rows affected by the last sql statement. That's what I used in the sample trigger I included earlier in this thread, but as far as I know, your query itself has to actually reference @@ROWCOUNT and specifically return it; it won't just "be there" in your application if you don't. my apologies oh hater of black berets, i sort my mail new to old so i didn't see that until long after i'd sent my reply. actually i was a bit surpised that it seemed like you forgot @@ROWCOUNT. i guess i'll know better in the future ;-) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Success Return Codes
I spent a few minutes looking at SQL Server Books Online, and couldn't find anything which SQL Server would automatically return how many records were updated by a query. You can use the RETURN keyword within a stored procedure to return a value, or you could use RAISERROR to throw an error, but I didn't find what you're looking for, and I don't think it exists, at least not in SQL Server. what about @@ROWCOUNT? it returns the number of rows affected by the last sql statement. That's what I used in the sample trigger I included earlier in this thread, but as far as I know, your query itself has to actually reference @@ROWCOUNT and specifically return it; it won't just "be there" in your application if you don't. It *will* just "be there". Nick de Voil ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Application.cfm... whats that ?
Not necessarily. Back when I first started using ColdFusion, I knew I needed state management, but I didn't know a thing about the Application.cfm file. Directions are always the *last* thing you are supposed to read, right? Well, first I just put the cfapplication tag at the start of every page. Then I got creative and put all that stuff in a file and cfincluded it at the top of every page. Boy, I thought I was being slick. Now I just look back and shake my head ... Todd Ashworth - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 2:06 AM Subject: Re: Application.cfm... whats that ? | | | the cfapplication tag doesn't _have_ to be in the application.cfm file, just | ususally is, because thats where it makes sense to put it. | | True enough, but if you know enough CF to use session variables why would you | not know what the application.cfm file is? | | | Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
NEED HELP Encrypt Url ?
How do I encrypt urls, where do i get info on encrypt urls, just want info on encrypt url Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Export to Access
Hi, Thanks for helping me out. I hop you don't mind that I am emailing you directly. I have 3 questions. Firstly, the file in excel leaves a blank line between each record. Also before the first field there is a square character. My last question is that one of the fields that I am exporting to access is like a memo field and whenever I export it (using the code you gave me or someone elses) it splits the memo field into a few records. I see that this does happen by a period, although not all the time. Thanks a lot for your help, Miriam Hirschman -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 4:41 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Export to Access Miriam, Excel/Lotus 123 is easy. Here's a very simple solution that works great for creating CSV files and opening them up into Excel or Lotus (or whatever is handling comma seperated files on the client machine). The gist of this is that CFCONTENT will cause the browser to put up an "Open File or Save" dialog box. If they push OPEN, Excel will open up and display the info that CF outputs: CFSETTING enablecfoutputonly="Yes" CFQUERY name="search_results" Select * from something /CFQUERY CFCONTENT TYPE="text/x-excel-csv" CFHEADER NAME="content-disposition" VALUE="filename=contacts.csv" Report For Someone: CFLOOP QUERY="search_results" cfoutput"#first_name#","#last_name#","#COMPANY_name#","#state#","#country# ","#company_address1#","#company_city#","#state#","#company_postal_code#","# contact_phone_number#","#contact_email_address#" /cfoutput /CFLOOP There are also custom tags that you can get in Allaire's tag gallery that are more specifically tied to Excel, but excel would need to be installed on the server. HTH, Eron -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:10 PM To: CF Forum Subject: Export to Access A client of mine wants to know if there is a way that I can export a CF page to access or excel?? I would appreciate any info Thanks, Â ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Another cflock question
OK. I'm finally going back through the apps I've built and am going to wrap all my cfset session. tags in locks. Question: If I have a block of tags, like so: cfset session.weight = 0 cfset session.sh = 0 cfset session.state_tax = 0 cfset session.subtotal = 0 cfset session.grandtotal = 0 Is it OK to wrap the whole block in a single cflock tag, or should each one be wrapped individually? Also, what's a good cflock timeout= value to use when setting session and/or application variables? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
need help urgent
I know this is probably an easy one but my head is wrecked, basically my uodate form is acting up . my dataentry form is fine passes the vars ok, !-- Display HTML FORM Here with values filled -- form method="POST" action="Poll_update.cfm" input type="hidden" name="pol_id" value="183" pnbsp;/ppPoll: input type="Text" textarea rows="5" cols="45" name="pol_question" size=40 value="What is your favourite colour?" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 1: input type="text" name="answer1" size="45" value="red" here is my update page, i now it's really messy but please help, any other attempts i've made just add another entry to the db, leaving the existing one still in the db cfset pagetitle = "Update Poll" cfoutput html head title#pagetitle#/title /head body bgcolor="CC" link="996633" vlink="CC9966" alink="CC9966" b#pagetitle#/b/font /cfoutput !--- cfupdate datasource="quickpoll" tablename="pol_poll" --- !--- cfupdate datasource="quickpoll" tablename="ans_answer" --- !--- cfquery name="qryGetID" datasource="quickpoll" SELECT @@identity as pol_id /cfquery --- !--- cfoutput query="qryGetID" #pol_id# /cfoutput --- cfquery name="update_Poll" datasource="quickpoll" UPDATE pol_poll SET pol_question = '#Trim(pol_question)#' WHERE pol_id = #pol_id# /cfquery CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer1='#form.ans_answer1#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer2='#form.ans_answer2#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer3='#form.ans_answer3#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer4='#form.ans_answer4#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer5='#form.ans_answer5#' /CFQUERY poll updated PBRP pnbsp;brnbsp;br/p /body /html input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 2: input type="text" name="answer2" size="45" value="blue" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 3: input type="text" name="answer3" size="45" value="green" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 4: input type="text" name="answer4" size="45" value=" " input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 5: input type="text" name="answer5" size="45" value=" " pStatus: select name="pol_status" size="1" option value="All"All/option option value="New"New/option option value="Active"Active/option option value="Archive"Archive/option option value="Hide"Hide/option /select Category: select name="pol_category" size="1" option value="All"All/option option value="sports"sports/option option value="current affairs"current affairs/option option value="general"General/option /select INPUT name=polltype type=radio value=Y Yes/No INPUT name=polltype type=radio value=M Multiple Choice /p p input type="submit" value="Update Poll" name="submit"/form /p pnbsp;brnbsp;br/p /body /html Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Another cflock question
It's OK, and in fact, it's better to use one CFLOCK wrap. As for a good timeout, I always use 30, but have not heard of a 'good' figure. It probably depends on your estimated load. === Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 8:43 AM To: [EMAIL PROTECTED] Subject: Another cflock question OK. I'm finally going back through the apps I've built and am going to wrap all my cfset session. tags in locks. Question: If I have a block of tags, like so: cfset session.weight = 0 cfset session.sh = 0 cfset session.state_tax = 0 cfset session.subtotal = 0 cfset session.grandtotal = 0 Is it OK to wrap the whole block in a single cflock tag, or should each one be wrapped individually? Also, what's a good cflock timeout= value to use when setting session and/or application variables? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(OT)How to parse WORD document ....
Hi all, How to parse a Word document to get some HTML or CFM files ? Depending on the length of the document , we will need to cut the document in x numbers of files. Anyone got information on that topic? Thanks Christian -- FILAMENT COMMUNICATIONS Bright ideas for a new economy Christian Labrecque Web Developer http://www.filamentinc.com 126 York St., Suite 500, Ottawa, Ontario K1N 5T5 (t) 613-241-7200 (f) 613-241-7157 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Keyword Search on Access Database Records
Hi Folks - I'm looking for a simple solution - I need to put a keyword search feature on an internal application I've been working on - I've been reading Ben Forta's book re: Verity, but I don't see where I can use verity with Access mdb? Also... I am only developing the application, I don't have permissions to use the ColdFusion Administrator and only upload and work with my templates via FTP. If it's an ODBC datasource, then Verity will talk directly to it You can use the COLLECTION commands to set-up the source Are you changing the database regularly, or do you have loads of databases? My database has one table that is most important - it contains a few memo boxes - I want to perform a keyword search, and return the primary key of that record as a result. If CF is going to talk to it, then it'll need some sort of connection - If CF can talk to it, so can Verity (as it's part of CF) Just query what you want Indexed, then run CFINDEX to create the Verity index. Note that CF4's Verity does return it's results in reverse of what you index on (not sure about 4.5), so try to create the query with "desc" on your "order by" Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL 7
Is one able to create a comma delimited list in a SQL 7 column. If so, is = this the best solution versus, adding a row. If not, what is the most = efficient way to distinguish the information between two identifiers. If I'm understanding your request, you want a denormalised list in a field - in which case, just use a Text field or a Varchar field. You can put anything you want into those fields, so it can easily contain a comma separated list. If you want to hold 2 lists for 2 different fields, then store 2 different lists in 2 fields - there is no reason to hold them in one field There are problems with denormalised lists, but for small amounts of data they are fine - I would suggest moving to normalising your relationships though, it makes the system a lot more expandable. Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: need help urgent
sorry think my code got a bit mixed uo, here are the 2 files values passed thru CFQUERY NAME="GetPollDetails" DATASOURCE="quickpoll" SELECT pol_ID, pol_Question, pol_Category, pol_Status FROM pol_Poll WHERE pol_ID = #URL.PollID# /CFQUERY CFQUERY NAME="GetAnswers" DATASOURCE="quickpoll" SELECT ans_ID,ans_Ans FROM ans_Answer A WHERE ans_pol_ID = #url.PollID# /CFQUERY !-- Display HTML FORM Here with values filled -- cfoutput query="getpolldetails" form method="POST" action="Poll_update.cfm" !--- textarea rows="5" name="MainText" cols="45" --- input type="hidden" name="pol_id" value="#pol_id#" pnbsp;/ppPoll: input type="Text" textarea rows="5" cols="45" name="pol_question" size=40 value="#pol_question#" /cfoutput CFLOOP QUERY="GetAnswers" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" cfoutputpAnswer #GetAnswers.CurrentRow#: input type="text" name="answer#GetAnswers.CurrentRow#" size="45" value="#GetAnswers.ans_Ans#" /cfoutput /CFLOOP and then update cfquery name="update_Poll" datasource="quickpoll" UPDATE pol_poll SET pol_question = '#Trim(pol_question)#' WHERE pol_id = #pol_id# /cfquery CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer1='#form.ans_answer1#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer2='#form.ans_answer2#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer3='#form.ans_answer3#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer4='#form.ans_answer4#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer5='#form.ans_answer5#' /CFQUERY any help greatly appreciated From: "janey smith" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: need help urgent Date: Fri, 14 Jul 2000 12:46:32 GMT I know this is probably an easy one but my head is wrecked, basically my uodate form is acting up . my dataentry form is fine passes the vars ok, !-- Display HTML FORM Here with values filled -- form method="POST" action="Poll_update.cfm" input type="hidden" name="pol_id" value="183" pnbsp;/ppPoll: input type="Text" textarea rows="5" cols="45" name="pol_question" size=40 value="What is your favourite colour?" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 1: input type="text" name="answer1" size="45" value="red" here is my update page, i now it's really messy but please help, any other attempts i've made just add another entry to the db, leaving the existing one still in the db cfset pagetitle = "Update Poll" cfoutput html head title#pagetitle#/title /head body bgcolor="CC" link="996633" vlink="CC9966" alink="CC9966" b#pagetitle#/b/font /cfoutput !--- cfupdate datasource="quickpoll" tablename="pol_poll" --- !--- cfupdate datasource="quickpoll" tablename="ans_answer" --- !--- cfquery name="qryGetID" datasource="quickpoll" SELECT @@identity as pol_id /cfquery --- !--- cfoutput query="qryGetID" #pol_id# /cfoutput --- cfquery name="update_Poll" datasource="quickpoll" UPDATE pol_poll SET pol_question = '#Trim(pol_question)#' WHERE pol_id = #pol_id# /cfquery CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer1='#form.ans_answer1#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer2='#form.ans_answer2#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer3='#form.ans_answer3#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer4='#form.ans_answer4#' /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" UPDATE ans_answer set answer5='#form.ans_answer5#' /CFQUERY poll updated PBRP pnbsp;brnbsp;br/p /body /html input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 2: input type="text" name="answer2" size="45" value="blue" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 3: input type="text" name="answer3" size="45" value="green" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 4: input type="text" name="answer4" size="45" value=" " input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer 5: input type="text" name="answer5" size="45" value=" " pStatus: select
CF hangs
Hi I'm running cf 4.51 on three win2k-servers using iis5 as web server. Since I put these servers online the cf process hangs about every hour or so and this message is displayed: Error Occurred While Processing Request Error Diagnostic InformationRequest canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Why is this? The applications on the servers have been thourougly tested and running fine on another server 4.51 on winnt4.0server with iis4 with much higher load. ANy ideas? I'm really, really frustrated to say the least. //Nicklas af Ekenstam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
Hi Nille, I had what sounds like the same problem this week. What database are you using? If it's the same problem (check your server.log file for NT Errors) then it seems to be caused by ODBC drivers keeping database connections open. After the timeout period on the db server, CF tries to use the same connection pipe thinking that it's still open, and an error occurs. I disabled the 'maintain database connection' option on my oracle odbc driver and it's now been running fine for about 24 hours (normally it would hang after 1-2 hours). Neil Robinson -Original Message- From: Nille af Ekenstam [mailto:[EMAIL PROTECTED]] Sent: 14 July 2000 14:04 To: [EMAIL PROTECTED] Subject: CF hangs Hi I'm running cf 4.51 on three win2k-servers using iis5 as web server. Since I put these servers online the cf process hangs about every hour or so and this message is displayed: Error Occurred While Processing Request Error Diagnostic InformationRequest canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Why is this? The applications on the servers have been thourougly tested and running fine on another server 4.51 on winnt4.0server with iis4 with much higher load. ANy ideas? I'm really, really frustrated to say the least. //Nicklas af Ekenstam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF hangs
Doesn't that slow down your queries considerably? Todd Ashworth - Original Message - From: "Neil Robinson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 9:13 AM Subject: RE: CF hangs | Hi Nille, | | I had what sounds like the same problem this week. What database are you | using? If it's the same problem (check your server.log file for NT Errors) | then it seems to be caused by ODBC drivers keeping database connections | open. After the timeout period on the db server, CF tries to use the same | connection pipe thinking that it's still open, and an error occurs. I | disabled the 'maintain database connection' option on my oracle odbc driver | and it's now been running fine for about 24 hours (normally it would hang | after 1-2 hours). | | Neil Robinson -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Application.cfm... whats that ?
I would guess that the main reason your Provider wants you to have an Application.cfm file in your own directory, is because, as I am sure you are aware, If CF does not find an application.cfm file in your directory, it will keep climbing the tree until it does find one. You do not want to have your files not working properly because of someone elses different Application.cfm file, DO YOU? That is only my guess as to why they want you to have your own. 'nuff said -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 12:54 AM To: [EMAIL PROTECTED] Subject: Re: Application.cfm... whats that ? Yeah ... our site does use a lot of session variables ... but is it necessary to have this file .. How did you set up session scoped variables without using the application.cfm file? Normally you need a cfapplication name="something" sessionmanagement="yes" tag in your application.cfm file to turn on session variables. Or have I completely misunderstood? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
Neil Robinson skrev: Hi Nille, I had what sounds like the same problem this week. What database are you using? If it's the same problem (check your server.log file for NT Errors) then it seems to be caused by ODBC drivers keeping database connections open. After the timeout period on the db server, CF tries to use the same connection pipe thinking that it's still open, and an error occurs. I disabled the 'maintain database connection' option on my oracle odbc driver and it's now been running fine for about 24 hours (normally it would hang after 1-2 hours). I'm using MSSQL7.0 as bd. Found a gazillion of these in my server.log: "Error","TID=1448","07/13/00","23:15:58","Unable to write reply -- client browser stopped waiting for request. " "Error","TID=1448","07/13/00","23:15:58","Windows NT error number 109 occurred." Look familiar to you? I've just followed your advice on disabling "maintain db con" - hope it helps. Thanks Neil! //Nille -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF hangs
- Original Message - From: "Neil Robinson" [EMAIL PROTECTED] | Hi Nille, | | I had what sounds like the same problem this week. What database are you | using? If it's the same problem (check your server.log file for NT Errors) | then it seems to be caused by ODBC drivers keeping database connections | open. After the timeout period on the db server, CF tries to use the same | connection pipe thinking that it's still open, and an error occurs. I | disabled the 'maintain database connection' option on my oracle odbc driver | and it's now been running fine for about 24 hours (normally it would hang | after 1-2 hours). Todd Ashworth skrev: Doesn't that slow down your queries considerably? I'll take slow queries over crasched application servers any day of the week ;-) //Nille -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: My solution:Variable IN a list? How to check?
Only if it can talk (running and ducking ;-) At 07:56 AM 7/14/00 -0400, you wrote: Is this the most eloquent solution to the problem? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFX_MAIL port
CFX_MAIL uses the standard SMTP port, port 25. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Yuri Vorontsov (Language Networks) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 6:15 AM To: [EMAIL PROTECTED] Subject: CFX_MAIL port Hi, Does anyone know which TCP/UDP port is used by CFX_MAIL? Greetings from Amsterdam, Yuri E. Vorontsov, Drs - Language Networks BV Tel 020 33 00 333 Tel 062 278 4728 (cell.) Fax 020 33 00 334 Email: [EMAIL PROTECTED] Visit Aquarius Directory at http://aquarius.net World's largest community of language professionals 12000+ translators and 2000+ translation agencies -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF and CFELSE
Willy, Your CFIF and CFELSE logic looks fine. I think you need your logic to read: cfif IsDefined("#URL.myvariable#") cfform action="emp_add_action.cfm?myvariable=true" method="post" enablecab="Yes" cfelse cfform action="emp_add_action.cfm" method="POST" enablecab="Yes" /cfif See if that works for you. Chris Ivey MTS Systems Engineer GTE Data Services: Temple Terrace, Florida TSS Distributed - WAN Tools Group Office: (813) 978-4844 Pager: (813) 303-1177 AIM: IveyAtGTEDS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
Nille wrote... I'm using MSSQL7.0 as bd. Found a gazillion of these in my server.log: "Error","TID=1448","07/13/00","23:15:58","Unable to write reply -- client browser stopped waiting for request. " "Error","TID=1448","07/13/00","23:15:58","Windows NT error number 109 occurred." Nille, This is the same issue, but since you're using SQL server there are a few technet articles on how to tackle it: Q109787 Q187370 Q165158 As I'm on oracle it may be a bit more tricky to find the actual cause of the problem, but for now I'm happy as long as it doesn't crash. Neil Robinson -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
-Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: 14 July 2000 14:30 To: [EMAIL PROTECTED] Subject: Re: CF hangs Doesn't that slow down your queries considerably? I hope not! It does sound like a 'quick fix', but I'll see how it copes. Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
session management
Hey all, I am having a serious session management problem. Here is my cfapplication tag ... CFAPPLICATION NAME="xite" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" When I was working with the application last night I had a cfid of 71. This morning when I come back in (machine was shutdown last night) and logged back into the application I had a cfid of 71 and the stuff that I put into the shopping cart last night showed up. What am I doing wrong!!! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Lawyers...
I'd be happy to discuss this with you. I'm the Director of Info. Services for a law firm. I've put up two intranets using CF to drive some of the apps. There are a number of questions that you need to answer before you jump in. For example: 1) How large is the firm (number of attorneys?) 2) Which document manager do they use? (PCDOCS, iManage, Worlddox, other?) I've worked for law firms for about 17 years. (I usually tell folks that I just don't know any better!) And I've learned that this environment is very different from the corporate world. If you'd like to contact me directly, please feel free. Athelene Gieseman [EMAIL PROTECTED] (816) 691-3344 -Original Message- From: ClintonGallagher [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 12:14 PM To: CF-Talk Subject: Lawyers... I have an opportunity to do an intranet for a law firm that is operating two regional offices on the Novell Border Manager platform. They use Word Perfect and some other Document Management solution. Search, Document Management and Workflow are important to them. They've tried a Lotus Notes solution on an NT platform and are dissatisfied - with Notes - likely due to development costs. Their Admin has 'heard about' Cold Fusion and has expressed an interest in Cold Fusion as a solution. What do I say? How do I sell a Cold Fusion solution in this scenario? Obviously I must ask, "are there any CFML 'Intranet in a Box' applications that may be appropriate or other custom solutions for law firms I could sell and support with a development partner"? The project is in Milwaukee and extends to the Madison office, both of course in Wisconsin. %= Clinton Gallagher http://home.att.net/~csgallagher/ http://www.metromilwaukee.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Something weird going on here
tried that, still nothing... the problem is with the other javascript at the bottom of the page, but I dont know what it is. When I take that out (the one performing the location.href), it works fine and I see the entire Successful login message. Sean Renet wrote: is it because you are only passing the username and not the username and password in your NewWindow function? - Original Message - From: "James Taavon" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 13, 2000 11:13 AM Subject: Something weird going on here Below is a cfm file that I am using for validating usernames and passwords from a database. Everything in that respect is working just fine. If the login is successful the user gets a message saying successful login and launches and new window containing the application. The problem is that for some reason the entire "success" message does not appear in the browser window. You will see in the code below after the CFELSE that there is the "Database Login Successful!!..." Well, that is the only part of the message that I see. The remaining text does not appear. The piece of Javascript I have in there where I am relocating to the new window seems to have and effect on wheter it appears or not. If I remove the script, the text appears and when I put it back it disappears. Any ideas?? !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html body SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" cfoutput !-- function newWindow(){ launchWin = window.open('lsar.cfm?user=#form.username#', 'launchWin', 'width=790,height=543,screenX=0,screenY=0,top=0,left=0') } file://-- /cfoutput /SCRIPT cfquery name="Validate" datasource="lsars" select * from taavon.users where username = '#form.username#' and password = '#form.password#' /cfquery cfif validate.recordcount is 0 SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- alert ('Database Login Unsuccessful!! You have typed in an \n invalid Username or Password.'); location.href = ('index.cfm'); file://-- /SCRIPT cfelse font face="arial" strongDatabase Login Successful!! br br font size="2" The Letter Scanning and Routing System has been started in another window. You no longer need this window open. /font /strong /font SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- location.href='javascript:newWindow()' file://-- /SCRIPT /cfif /body /html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Name
Yo, Jedi Master; ColdFusion, name of product, it is ;-) At 08:49 AM 7/14/00 -0400, you wrote: Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Keyword Search on Access Database Records
Try "Indexing Data" p 712 CFWACK4 3rd ed best, paul At 01:01 PM 7/14/00 +0100, you wrote: I've been reading Ben Forta's book re: Verity, but I don't see where I can use verity with Access mdb? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: My solution:Variable IN a list? How to check?
I may be missing a pice of logic, but this may work a little better: !--- SECURITY CODE CFIF IsDefined('DeptID') CFLOOP List="form.DeptID" INDEX="x" cfif NOT ListContains(session.currentprivileges,x) cflocation url="#noclearance#" addtoken="yes" /CFIF /CFLOOP /CFIF !--- End SECURITY CODE -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 7:56 AM To: [EMAIL PROTECTED] Subject: Re: My solution:Variable IN a list? How to check? Ok..here is the solution I came up with and Morning everybody =) !--- SECURITY CODE CFIF IsDefined('DeptID') CFLOOP INDEX="x" FROM="1" TO="#ListLen(form.DeptID)#" cfif ListContains(session.currentprivileges,ListGetAt(form.DeptID,x),",") EQ 0 cflocation url="#noclearance#" addtoken="yes" /CFIF /CFLOOP /CFIF !--- End SECURITY CODE Is this the most eloquent solution to the problem? :-) -Gel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Export to Access
I am having trouble with the following example, in that my output just shows up in the web browser as text. Excel does not open. Any hints as to where to look for the answer? Tim Tim Claremont Xerox Corporation -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 4:41 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Export to Access Miriam, Excel/Lotus 123 is easy. Here's a very simple solution that works great for creating CSV files and opening them up into Excel or Lotus (or whatever is handling comma seperated files on the client machine). The gist of this is that CFCONTENT will cause the browser to put up an "Open File or Save" dialog box. If they push OPEN, Excel will open up and display the info that CF outputs: CFSETTING enablecfoutputonly="Yes" CFQUERY name="search_results" Select * from something /CFQUERY CFCONTENT TYPE="text/x-excel-csv" CFHEADER NAME="content-disposition" VALUE="filename=contacts.csv" Report For Someone: CFLOOP QUERY="search_results" cfoutput"#first_name#","#last_name#","#COMPANY_name#","#state#","#country# ","#company_address1#","#company_city#","#state#","#company_postal_code#","# contact_phone_number#","#contact_email_address#" /cfoutput /CFLOOP There are also custom tags that you can get in Allaire's tag gallery that are more specifically tied to Excel, but excel would need to be installed on the server. HTH, Eron -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:10 PM To: CF Forum Subject: Export to Access A client of mine wants to know if there is a way that I can export a CF page to access or excel?? I would appreciate any info Thanks, Â ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF hangs
| | I had what sounds like the same problem this week. What database are you | | using? If it's the same problem (check your server.log file for NT | Errors) | | then it seems to be caused by ODBC drivers keeping database connections | | open. After the timeout period on the db server, CF tries to use the same | | connection pipe thinking that it's still open, and an error occurs. I | | disabled the 'maintain database connection' option on my oracle odbc | driver | | and it's now been running fine for about 24 hours (normally it would hang | | after 1-2 hours). I had this problem some time ago using a Sybase database. The problem was that I goofed in my code and one of my queries was taking too long to complete. Eventually, it timed out. When the client gave up waiting, it popped up an error message and stopped. This left a connection open on the server, or left a process running, or something. When I would look at the running processes under Task Manager, I would see about 7 - 10 "mtx.exe"'s running. If I killed all of these off except for 1 or 2, then the server would start working again. If I just left them, the sever appeared to be locked up. Seeing as how you say everything works fine on NT4, but not on Win2K, I'm not sure if this is even remotely similar to what is happening to you. I am not at all familiar with Win2K. I've also never used SQL Server, so I don't know what this means: "Error","TID=1448","07/13/00","23:15:58","Unable to write reply -- client browser stopped waiting for request. " "Error","TID=1448","07/13/00","23:15:58","Windows NT error number 109 occurred." but it looks like a runaway query, or a timeout of some sort. Just my .02 ... I'm probably way off. Todd Ashworth -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
Nille wrote... I'm using MSSQL7.0 as bd. Found a gazillion of these in my server.log: "Error","TID=1448","07/13/00","23:15:58","Unable to write reply -- client browser stopped waiting for request. " "Error","TID=1448","07/13/00","23:15:58","Windows NT error number 109 occurred." Neil Robinson skrev: Nille, This is the same issue, but since you're using SQL server there are a few technet articles on how to tackle it: Q109787 Q187370 Q165158 As I'm on oracle it may be a bit more tricky to find the actual cause of the problem, but for now I'm happy as long as it doesn't crash. Neil, thanks for all your help. Here's a stupid question(tm): What's 'technet'? //Nille -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Application.cfm... whats that ?
My idea of what application.cfm. 1)When place in a directory and tried to access directly a cold fusion error occurs stating that this is a reserved file name. Is there a way to make the error not appear I do not know. 2)When place in your directory it is access before accessing any other .cfm in that directory. 3)cfapplication does not have a direct link with application.cfm, but it is good to place the cfapplication tag in the application.cfm so that it may be accessed by each file in your application. Gregory Pekofsky -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: session management
The SessionTimeOut and ApplicationTimeout has a 1 day before they can kill the variables. That's what I think where the problem is. Rob Hey all, I am having a serious session management problem. Here is my cfapplication tag ... CFAPPLICATION NAME="xite" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" When I was working with the application last night I had a cfid of 71. This morning when I come back in (machine was shutdown last night) and logged back into the application I had a cfid of 71 and the stuff that I put into the shopping cart last night showed up. What am I doing wrong!!! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Another cflock question
On 7/14/00, Raymond K. Camden penned: It's OK, and in fact, it's better to use one CFLOCK wrap. As for a good timeout, I always use 30, but have not heard of a 'good' figure. It probably depends on your estimated load. OK, cool. That will save me a couple minutes anyway. :) I'm sure this is a really really stupid question, but, what would happen if you wrapped the whole template in CFLOCK? (ducking the tomatoes thrown from the crowd). -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
Neil Robinson skrev: This is the same issue, but since you're using SQL server there are a few technet articles on how to tackle it: Never mind my technet question. Found it. //Nille -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: My solution:Variable IN a list? How to check?
*drums fingers on desk* Comedians..everyone wants to be a comedian. I meant elegant. I think. *mutters* *sneaks off to the thesaurus* -Gel :-) - Original Message - From: paul smith [EMAIL PROTECTED] Only if it can talk (running and ducking ;-) At 07:56 AM 7/14/00 -0400, you wrote: Is this the most eloquent solution to the problem? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF is 'template based' and ASP is 'object based'?
Upon reading ASP speaker's statement, my first reaction is 'well, that's academically true, but usually not true in practice'. I program in both all the time, so here's my take on it: ASP is *supposed to be* object based. The MS recommendations for architecture are that you separate business rules/logic from presentation rules/logic. You accomplish this by moving the logic of your site into COM objects and database-side code wherever possible. ASP is then simply the glue between plain html and calls to the objects that really handle all the dynamic aspects of your site. It's a wonderful sales pitch. All your dynamic logic is executed quicker than ASP can, in compiled code or by the database, and you can code your html with knowledge of, but separately from your concerns of how the dynamic code works. That's the sales pitch. In practice, you usually execute your dynamic code in ASP itself, since extracting it to COM objects makes it more difficult to revise, means you have to manage source code and compiled objects across multiple servers (supposing you're using a server farm), and it's just plain quicker to code/test/code/test. This puts ASP and Cold Fusion on about the same level. ASP has the theoretical upper hand, since it can work much more easily with COM objects than CF... but in practice, you usually don't run into CF's COM limitations in any way that makes ASP shine. Being tag-based, I feel Cold Fusion is shy of the "agility" ASP has in tying HTML to code objects, and extracting business logic from the presentation logic. However, CF has never failed to provide means to accomplish functionality I've had to write, and is a competitive alternative to ASP in practical use. The theoretical debate can rage on. I have code to write :) Jonathan -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 11:21 AM To: [EMAIL PROTECTED] Subject: RE: CF is 'template based' and ASP is 'object based'? Both CF and ASP are script based (also known as "page based" which I assume is what he means by "template based"). The difference is that ASP does less out of the box, and so COM objects are used for any and all extensions. CF does you the favor of including lots of those extensions (like SMTP, POP, HTTP, FTP, and LDAP support) right in the package, so you don't need to call external objects. But you can indeed do so, and often should. Truth is, from a functional perspective, CF and ASP are very similar. Both are implemented as ISAPI extensions, both are page preprocessors, and both are script driven. --- Ben -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 8:17 AM To: 'Listserv, Cold Fusion' Subject: CF is 'template based' and ASP is 'object based'? An instructor was speaking to a group of our managers and he explained the difference between CF and ASP as CF is 'template based' and ASP is 'object based', therefore he prefers ASP because it is more sophisticated (and because he has used it more). What exactly could he have meant by this? Isn't ASP 'template based'? Aren't CF custom tags 'objects' in the sense that he was referring to ASP's objects? And can't CF call the very same objects that ASP calls? Did this instructor pass along misinformation or is he just confused or am I confused? We are on the cusp of making a decision to go with either CF or ASP and there's lots of hand wringing going on around here . . . Thanks! George [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ADO
Since I'm having troubles (or rather; cf is having trouble with) ODBC and MSSQL7 I figured I'd give ADO a test drive. Anyone here know of any good articles to get this working? I'm a complete novice on the subject. Thanks! //Nille -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: NEED HELP Encrypt Url ?
When you generate your url strings, use encrypt() to encrypt the variables; when you need to reference those url variables, decrypt them using decrypt() -- Billy Cravens [EMAIL PROTECTED] Rif Kiamil wrote: How do I encrypt urls, where do i get info on encrypt urls, just want info on encrypt url Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session management
Sessions are stored in Server Memory. When you shutdown the machine last night, your session data was destroyed. Your CFID was stored in a cookie on your machine, so it was still the same. If you want your session data to persist longer, you might want to investigate client variables. I would strongly recommend thougholy reading the CFDOCS on session and client vars before proceeding. -Cameron Cameron Childress McRae Communications p. 770-460-7277 x.232 f. 770-460-0963 -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 9:55 AM To: Cf-Talk Subject: session management Hey all, I am having a serious session management problem. Here is my cfapplication tag ... CFAPPLICATION NAME="xite" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" When I was working with the application last night I had a cfid of 71. This morning when I come back in (machine was shutdown last night) and logged back into the application I had a cfid of 71 and the stuff that I put into the shopping cart last night showed up. What am I doing wrong!!! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Application.cfm... whats that ?
what the provider might want to do is add a directory between the clients and the application.cfm and include a "blank" application.cfm then it is not an issue. ex. root/application.cfm root/clients/application.cfm (blank) root/clients/clientroot/ Eric From: "Larry Juncker" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Application.cfm... whats that ? Date: Fri, 14 Jul 2000 08:25:13 -0500 I would guess that the main reason your Provider wants you to have an Application.cfm file in your own directory, is because, as I am sure you are aware, If CF does not find an application.cfm file in your directory, it will keep climbing the tree until it does find one. You do not want to have your files not working properly because of someone elses different Application.cfm file, DO YOU? That is only my guess as to why they want you to have your own. 'nuff said -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 12:54 AM To: [EMAIL PROTECTED] Subject: Re: Application.cfm... whats that ? Yeah ... our site does use a lot of session variables ... but is it necessary to have this file .. How did you set up session scoped variables without using the application.cfm file? Normally you need a cfapplication name="something" sessionmanagement="yes" tag in your application.cfm file to turn on session variables. Or have I completely misunderstood? Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: My solution:Variable IN a list? How to check?
Ok..here is the solution I came up with and Morning everybody =) !--- SECURITY CODE CFIF IsDefined('DeptID') CFLOOP INDEX="x" FROM="1" TO="#ListLen(form.DeptID)#" cfif ListContains(session.currentprivileges,ListGetAt(form.DeptID,x),",") EQ 0 cflocation url="#noclearance#" addtoken="yes" /CFIF /CFLOOP /CFIF !--- End SECURITY CODE Is this the most eloquent solution to the problem? :-) This is what I would have suggested. One way to make it slightly more elegant (eloquent, whatever) would be to stuff that code into a custom tag. Then whenever you need to authorize, just call the custom tag: cf_security currentpriveledges="#listofPriveledges#" deptID="#deptID#" - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstream.com http://www.mergernetwork.com tel: 207.439.6030 cel: 978.764.0799 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Developer Conference: Hotel Accommodations
Anyone else having problems with Priceline? The website got hung up in a loop on my request last night (it didn't consider the name of my favorite movie: Blazing Saddles, to have 4 characters in it), and without a request number you can't get anywhere on the web or phone assistance. Very good example of poor customer service. (Undoubtedly because it's an ASP website. ;-) best, paul At 11:17 AM 7/10/00 +, you wrote: I used Priceline for that e-commerce conf and got a room at the Marriot for about $50... Gene Kraybill James Brown wrote: Several people who went to the e-commerce meeting in Rockville a couple of months ago used priceline and got some pretty good deals on both flight and room ($80 a nite for the Rockville Marriot). -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
Nille, It is part of the Microsoft support Knowledge Base. Go to http://support.microsoft.com and go to the Knowledge Base. There, you can retrieve the Q articles. Russel At 04:04 PM 7/14/2000 +0200, you wrote: Nille wrote... I'm using MSSQL7.0 as bd. Found a gazillion of these in my server.log: "Error","TID=1448","07/13/00","23:15:58","Unable to write reply -- client browser stopped waiting for request. " "Error","TID=1448","07/13/00","23:15:58","Windows NT error number 109 occurred." Neil Robinson skrev: Nille, This is the same issue, but since you're using SQL server there are a few technet articles on how to tackle it: Q109787 Q187370 Q165158 As I'm on oracle it may be a bit more tricky to find the actual cause of the problem, but for now I'm happy as long as it doesn't crash. Neil, thanks for all your help. Here's a stupid question(tm): What's 'technet'? //Nille -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: mail transfer agents
I need to set up my own mail transfer agent (MTA) to accept outbound mail from CF, as the local infrastructure only supports authenticated SMTP. My traffic level is relatively low, hundreds of message per day max. I would put it on a dedicated box, and want to configure it to only accept mail from my servers. I'm aware of sendmail qmail IIS smtp service exim smail ssmtp zmailer Any suggestions or opinions? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: My solution:Variable IN a list? How to check?
I think: el·o·quent (l-kwnt) adj. 1.) Characterized by persuasive, powerful discourse 2.) Vividly or movingly expressive is the word. Of course elegant is good too. Eric From: Angél Stewart [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: My solution:Variable IN a list? How to check? Date: Fri, 14 Jul 2000 10:15:22 -0400 *drums fingers on desk* Comedians..everyone wants to be a comedian. I meant elegant. I think. *mutters* *sneaks off to the thesaurus* -Gel :-) - Original Message - From: paul smith [EMAIL PROTECTED] Only if it can talk (running and ducking ;-) At 07:56 AM 7/14/00 -0400, you wrote: Is this the most eloquent solution to the problem? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
New to Cold Fusion
And I would like to see an example of password protection using sessions. I don't understand cf applications yet. :/ Peter -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
re:RE:CFTree
Ok, newbie question, how can I make sure that they can locate the CFIDE dir? I tried the tree on my production server (I am working off a development server) and they could see it there. I found all of the cfide folders and related folders and copied them to the development server but to no avail. -- Date: Fri, 14 Jul 2000 15:29:40 +0800 From: "Ken M. Mevand" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: CFTree Message-ID: 002701bfed65$4634abc0$6400a8c0@OHYEAH make sure your co-workers can locate the CFIDE directory correctly. the applets are stored there. -ken - Original Message - From: Brian P. Doyle [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 2:48 AM Subject: CFTree Has anyone used this tag much? I'm trying to use it to create an easily navigatable lsit of categories and subcategories that will pop up in a window and populate a select list. I have the same thing up and running with javascript instead of CF but I need to make it dynamically created by a query (or multiple queries) and CFTree seemed like an easy way to do that. I copied an example tree from the WACK and uploaded it just to get a feel for it. However I'm the only one that can view it for some reason. I sent the link o one of my coworkers and all he gets is the grey rectangle. Sent it to another co-worker with the same results. When we looked at the diagnostic information for the page it said that the applet could not be found. I tried enablecab but that didn't work. Has anyone run into/overcome this problem? Thanks in advance. -Brian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Another cflock question
I'm sure this is a really really stupid question, but, what would happen if you wrapped the whole template in CFLOCK? You'd increase the likelihood that the lock would interfere with another lock. CFLOCK essentially does something analogous to locking in a database. When you execute a complex database transaction, and that transaction locks all the resources it touches, another person running that transaction will have to wait longer in a queue before their transaction can run, and if it takes too long, their time will run out. This creates a bottleneck. You can have the same problems with CFLOCK, so just like with a database transaction, you want your CFLOCK to be as short and quick as possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF-Talk V1 #78
Have you tried using the Explicit search option and putting quotes marks around the query? Works for me using the English-language version. If you want to try it send me mail off list I will give the URL for an example. Sue I'm working on a resume collection for my recruiting department using Verity. So far the recruiters are pretty pleased with its potential but one of them pointed out that it fails when you search for resumes containing "C++" (finds the "C" but not the "++"). This must be symptomatic of some kind of problem searching for any non-alphanumeric characters but I'm not sure how to solve it. Would appreciate suggestions on possible workarounds. Thanks, Bruce -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Warning: SSL and Windows 2000 Slightly OT
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Windows 2000 only allows a certain amount of SSL connections before it gives up an error message http 403.15 Forbidden: Client Access Licenses Exceeded. The number of SSL connections you can have is the number of CAL's you have. Remember Windows NT CAL's don't count for Windows 2000. Would switching to per seat licensing fix this? As I remember, the server doesn't keep record of how many per seat CALs are in the environment. Or am I completely off? Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOW8pjAraVoMWBwRBEQJw+gCePjwfAoCrfbjrSnk6X/DUMJohHkoAn2MN P7Bqj8SqKO/eJyq4Cn6DqXKO =6iTo -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
rogue SMTP request
The ColdFusion RDS Service on my machine (Win98 *yea, I know*) running on a NAT'ed network, which is connected through a SDSL modem, is apparently sending out SMTP requests, to where I have no idea. The requests are not getting a response nor are they timing out. They are just pilling up in the NAT table, which in turn is bringing our Internet connection down. I have CF running on three basically identical machines and am only having this problem with one. Has anyone ever run into or heard of something like this before? I have no idea why CF is sending out the requests. We have definitely narrowed the problem down to CF, when we shut the RDS Service down on this particular machine all is well again. Thanks for any help/suggestions that you can send my way. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session management
I thought the CreateTimeSpan function syntax was days, hours, minutes, seconds. If this is correct (I am referencing CFML Language Reference in Studio) then I have the Session and Application set to timeout in 1 hour. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: Re: session management The SessionTimeOut and ApplicationTimeout has a 1 day before they can kill the variables. That's what I think where the problem is. Rob Hey all, I am having a serious session management problem. Here is my cfapplication tag ... CFAPPLICATION NAME="xite" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" When I was working with the application last night I had a cfid of 71. This morning when I come back in (machine was shutdown last night) and logged back into the application I had a cfid of 71 and the stuff that I put into the shopping cart last night showed up. What am I doing wrong!!! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Forums 2.06 error
Hi Adrian. The error your getting is because of a messed up Verity collection that gets created during the install of Forums 2.06. Its actually an error that's been around for sometime and hasn't been corrected by Allaire. The Allaire knowledgebase article that discusses how to fix this can be found at: http://www.allaire.com/Handlers/index.cfm?ID=1560Method=Full Forums is now open source and being managed at http://www.forumspot.org so you can always post your questions there. Rey Bango ForumSpot.Org - Curator - Original Message - From: "Adrian Cooper" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 7:07 AM Subject: Forums 2.06 error Apologies in advance if this is slightly OT, or there is a better forum to post it to, but I have just installed Allaire Forums 2.06 (CF 4.01), and although it installed fine, and everything seems to work OK - admin etc.. - if I try to post a message I get the following: Error occurred in tag CFINDEX Collection failed to open: Forums_CFForums_Messages I haven't been able to fix this yet - any ideas anyone please. Does the ".mdb" file upsize to SQL Server OK? Thanks. Adrian Cooper. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL 7
Okay then, let's take this one step further If my DB has 2 table (many to one), such as product---options linked on product ID. Can anyone think of a way to create a view that will show the option row for a given productid as a single delimited list? Jonathan McGuire - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 8:06 AM Subject: RE: SQL 7 Is one able to create a comma delimited list in a SQL 7 column. If so, is = this the best solution versus, adding a row. If not, what is the most = efficient way to distinguish the information between two identifiers. If I'm understanding your request, you want a denormalised list in a field - in which case, just use a Text field or a Varchar field. You can put anything you want into those fields, so it can easily contain a comma separated list. If you want to hold 2 lists for 2 different fields, then store 2 different lists in 2 fields - there is no reason to hold them in one field There are problems with denormalised lists, but for small amounts of data they are fine - I would suggest moving to normalising your relationships though, it makes the system a lot more expandable. Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Export to Access
So where are the questions? Miriam Hirschman wrote: Hi, Thanks for helping me out. I hop you don't mind that I am emailing you directly. I have 3 questions. Firstly, the file in excel leaves a blank line between each record. Also before the first field there is a square character. My last question is that one of the fields that I am exporting to access is like a memo field and whenever I export it (using the code you gave me or someone elses) it splits the memo field into a few records. I see that this does happen by a period, although not all the time. Thanks a lot for your help, Miriam Hirschman -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 4:41 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Export to Access Miriam, Excel/Lotus 123 is easy. Here's a very simple solution that works great for creating CSV files and opening them up into Excel or Lotus (or whatever is handling comma seperated files on the client machine). The gist of this is that CFCONTENT will cause the browser to put up an "Open File or Save" dialog box. If they push OPEN, Excel will open up and display the info that CF outputs: CFSETTING enablecfoutputonly="Yes" CFQUERY name="search_results" Select * from something /CFQUERY CFCONTENT TYPE="text/x-excel-csv" CFHEADER NAME="content-disposition" VALUE="filename=contacts.csv" Report For Someone: CFLOOP QUERY="search_results" cfoutput"#first_name#","#last_name#","#COMPANY_name#","#state#","#country# ","#company_address1#","#company_city#","#state#","#company_postal_code#","# contact_phone_number#","#contact_email_address#" /cfoutput /CFLOOP There are also custom tags that you can get in Allaire's tag gallery that are more specifically tied to Excel, but excel would need to be installed on the server. HTH, Eron -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:10 PM To: CF Forum Subject: Export to Access A client of mine wants to know if there is a way that I can export a CF page to access or excel?? I would appreciate any info Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
re:RE:RE:CFTree
ok I'm officially a moron. figured it out, thanks/ Ok, newbie question, how can I make sure that they can locate the CFIDE dir? I tried the tree on my production server (I am working off a development server) and they could see it there. I found all of the cfide folders and related folders and copied them to the development server but to no avail. -- Date: Fri, 14 Jul 2000 15:29:40 +0800 From: "Ken M. Mevand" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: CFTree Message-ID: 002701bfed65$4634abc0$6400a8c0@OHYEAH make sure your co-workers can locate the CFIDE directory correctly. the applets are stored there. -ken - Original Message - From: Brian P. Doyle [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 2:48 AM Subject: CFTree Has anyone used this tag much? I'm trying to use it to create an easily navigatable lsit of categories and subcategories that will pop up in a window and populate a select list. I have the same thing up and running with javascript instead of CF but I need to make it dynamically created by a query (or multiple queries) and CFTree seemed like an easy way to do that. I copied an example tree from the WACK and uploaded it just to get a feel for it. However I'm the only one that can view it for some reason. I sent the link o one of my coworkers and all he gets is the grey rectangle. Sent it to another co-worker with the same results. When we looked at the diagnostic information for the page it said that the applet could not be found. I tried enablecab but that didn't work. Has anyone run into/overcome this problem? Thanks in advance. -Brian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF hangs
Todd wrote... I had this problem some time ago using a Sybase database. The problem was that I goofed in my code and one of my queries was taking too long to complete. Eventually, it timed out. When the client gave up waiting, it popped up an error message and stopped. This left a connection open on the server, or left a process running, or something. When I would look at the running processes under Task Manager, I would see about 7 - 10 "mtx.exe"'s running. If I killed all of these off except for 1 or 2, then the server would start working again. If I just left them, the sever appeared to be locked up. Looking at the log files after this happened the first time, I also thought it was a lengthy query causing problems. After seeing the same thing happen over and over again, sometimes without even having called a single page from the server, I had to rethink. Most (if not all) of the queries I'm using are pretty lightweight and would take no more than a couple of seconds, but this could be what Nille is experiencing. Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFPop alternative
I've been saving all the lists at House of Fusion over to an archive account on the mail server. The idea was to read out the mail into a DB and provide it online. Problem is, the account has over 45,000 emails in it (way over). CFPOP really doesn't like dealing with this and always returns errors, even when asking for a single message. Does anyone have a CFPOP alternative? Something that could possibly allow me to grab these messages. We're talking a years worth of list data. Alternatively, if anyone has a complete mail archive of CFTALK, I'd be quite happy to convert that. One of the goals is to get a CD archive that people can have. We missed the deadline for the CFUN2K conference, but the hope is to get the Allaire conference. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: hide the file name on addressbar
One of my client asked abt this. Is there any way to execute the Application after user loggedin by hiding the file name on the address bar. i mean, user can see first the login page. after his successful login to the site, he should not see the file names throughout his navigation on the site. 2 solutions off the top of my head: 1) Frames - then they never see the names after the frame page 2) Keep all of your templates called from one master-template This allows you to have sub-templates that do completely different tasks Fusebox is a good methodology for this (www.fusebox.org) HTH Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Variable IN a list? How to check?
Try to use the List functions, or extend the CFIf to be; cfif ",#deptID#," contains ",#session.priviliges#," which is faster than the List functions This would only work if the item were not the first or last element in the list. Either you would have to use a reg expression or ListFind(list, string [, delimiter]) to search a thru the list. Erm, it'd work for any instance - take this example; cfset deptID="1,41,61,143,275,380" cfset session.priliveges="41" cfif ",#deptID#," contains ",#session.priviliges#," works - it expands to; cfif ",1,41,61,143,275,380," contains ",41," While; cfset session.priliveges="4" Fails, as it expands to cfif ",1,41,61,143,275,380," contains ",4," I use the code if I'm checking for lists supplied by CheckBoxes, or and denormalised data If it doesn't work, then my server has been broken for the last 2 and a half years... Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HELP CF Insert Problem
Ok I have a CF Insert statement (its a long one) and then below the statement I will paste the error i am getting. Its appearing that there is a size limit ont he CF Insert statement? Is this true? All of my inserts except the first few are just 1 character. CFQUERY datasource="#DSN#" name="qputsi" Insert Into selfinspection (si_report, si_dt, SI_Ops_Coord, SI_tm, si_Pavement_Lip_gt_3in, SI_Hole_gt_5in_diam_3in_deep, SI_Cracks_Spalling_Bumps, SI_FOD, SI_Rubber, SI_Ponding_Edge_Dams, SI_Obstruction_Lights, SI_Cranes_Trees, SI_Equip_Crew, SI_Comm_Alarm, SI_Ruts_Humps_Erosion, SI_Drainage_Construction, SI_Objects_Vegetation, SI_Visible_Standard, SI_Hold_Lines_Signs, SI_Frangible_Bases, SI_Fencing_Gates, SI_Fencing_Gates_Signs, SI_Fuel_Labeling, SI_Fire_Extinguishers, SI_Grounding_Clips, SI_Obscured, SI_Damaged, SI_Inoperative, SI_Faulty_Aim, SI_Rotating_Beacon, SI_Wind_Indicators, SI_Barricades_Lights, SI_Equipment_Parking, SI_Dead_Birds, SI_Flocks_of_Bird, SI_Animals, SI_Resolved, SI_dt_Resolved, SI_Descrip") Values ('#form.si_report#', '#form.si_dt#', '#form.si_Ops_Coord#', '#form.si_tm#', '#form.si_Pavement_Lip_gt_3in#', '#form.si_Hole_gt_5in_diam_3in_deep#', '#form.si_Cracks_Spalling_Bumps#', '#form.si_FOD#', '#form.si_Rubber#', '#form.si_Ponding_Edge_Dams#', '#form.si_Obstruction_Lights#', '#form.si_Cranes_Trees#', '#form.si_Equip_Crew#', '#form.si_Comm_Alarm#', '#form.si_Ruts_Humps_Erosion#', '#form.si_Drainage_Construction#', '#form.si_Objects_Vegetation#', '#form.si_Visible_Standard#', '#form.si_Hold_Lines_Signs#', '#form.si_Frangible_Bases#', '#form.si_Fencing_Gates#', '#form.si_Fencing_Gates_Signs#', '#form.si_Fuel_Labeling#', '#form.si_Fire_Extinguishers#', '#form.si_Grounding_Clips#', '#form.si_Obscured#', '#form.si_Damaged#', '#form.si_Inoperative#', '#form.si_Faulty_Aim#', '#form.si_Rotating_Beacon#', '#form.si_Wind_Indicators#', '#form.si_Barricades_Lights#', '#form.si_Equipment_Parking#', '#form.si_Dead_Birds#', '#form.si_Flocks_of_Birds#', '#form.si_Animals#', '#form.si_Resolved#', '#form.si_dt_Resolved#', '#form.si_Descrip#') /CFQUERY ERROR: Problem: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with ') Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '', '', '', '', '', '', '', '' is too long. Maximum length is 128. SQL = "Insert Into selfinspection (si_report, si_dt, SI_Ops_Coord, SI_tm, si_Pavement_Lip_gt_3in, SI_Hole_gt_5in_diam_3in_deep, SI_Cracks_Spalling_Bumps, SI_FOD, SI_Rubber, SI_Ponding_Edge_Dams, SI_Obstruction_Lights, SI_Cranes_Trees, SI_Equip_Crew, SI_Comm_Alarm, SI_Ruts_Humps_Erosion, SI_Drainage_Construction, SI_Objects_Vegetation, SI_Visible_Standard, SI_Hold_Lines_Signs, SI_Frangible_Bases, SI_Fencing_Gates, SI_Fencing_Gates_Signs, SI_Fuel_Labeling, SI_Fire_Extinguishers, SI_Grounding_Clips, SI_Obscured, SI_Damaged, SI_Inoperative, SI_Faulty_Aim, SI_Rotating_Beacon, SI_Wind_Indicators, SI_Barricades_Lights, SI_Equipment_Parking, SI_Dead_Birds, SI_Flocks_of_Bird, SI_Animals, SI_Resolved, SI_dt_Resolved, SI_Descrip") Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'This is an AM Test description.')" Data Source = "NOTAM" Any suggestions -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Success Return Codes
It *will* just "be there". Let's pretend I didn't say that. It'll be there in SQL Server but not in CF, just like Dave said. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFTree
I've had this problem before with both the CFTree and CFGrid. It happened when I moved my site to a Win2K server. The problem was in how my IIS was setup to recognize the default server. Apparently, one of those settings let's CF know where to find the directory where those things are stored. Frankly, I did a lot of poking around in the IIS manager and just double-checked all of the port and IP settings. That did the trick. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Brian P. Doyle [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:48 PM To: [EMAIL PROTECTED] Subject: CFTree Has anyone used this tag much? I'm trying to use it to create an easily navigatable lsit of categories and subcategories that will pop up in a window and populate a select list. I have the same thing up and running with javascript instead of CF but I need to make it dynamically created by a query (or multiple queries) and CFTree seemed like an easy way to do that. I copied an example tree from the WACK and uploaded it just to get a feel for it. However I'm the only one that can view it for some reason. I sent the link o one of my coworkers and all he gets is the grey rectangle. Sent it to another co-worker with the same results. When we looked at the diagnostic information for the page it said that the applet could not be found. I tried enablecab but that didn't work. Has anyone run into/overcome this problem? Thanks in advance. -Brian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: New to Cold Fusion
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEDA8.98586D30 Content-Type: text/plain; charset="iso-8859-1" Check out "The Guide to Cold Fusion Login Systems" at http://www.cftutorials.com/ Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 10:41 AM To: '[EMAIL PROTECTED]' Subject: New to Cold Fusion And I would like to see an example of password protection using sessions. I don't understand cf applications yet. :/ Peter -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFEDA8.98586D30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: New to Cold Fusion/TITLE /HEAD BODY PFONT SIZE=3D2Check out quot;The Guide to Cold Fusion Login = Systemsquot; at/FONT BRFONT SIZE=3D2A HREF=3D"http://www.cftutorials.com/" = TARGET=3D"_blank"http://www.cftutorials.com//A/FONT /P BR PFONT SIZE=3D2Scott Becker/FONT BRFONT SIZE=3D2Web Developer : ConnectWise, Inc./FONT BRFONT SIZE=3D2www.ConnectWise.com/FONT /P BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Peter Benoit [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:pbenoit@triton-network= .com/A]/FONT BRFONT SIZE=3D2Sent: Friday, July 14, 2000 10:41 AM/FONT BRFONT SIZE=3D2To: '[EMAIL PROTECTED]'/FONT BRFONT SIZE=3D2Subject: New to Cold Fusion/FONT /P BR PFONT SIZE=3D2And I would like to see an example of password = protection using sessions.nbsp; I/FONT BRFONT SIZE=3D2don't understand cf applications yet. ://FONT /P PFONT SIZE=3D2Peter/FONT BRFONT = SIZE=3D2---= ---/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2To Unsubscribe visit A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli= sts/cf_talk" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= body=3Dlists/cf_talk/A or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body./FONT/P /BODY /HTML --_=_NextPart_001_01BFEDA8.98586D30-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Linux Version of Cold Fusion
Hi Everyone, I am wondering if anyone can comment on the Linux version of ColdFusion. I am particularly wondering about the stability of ColdFusion on that platform. I'd especially like to hear from anyone who's moved away from Windows NT running CF or is running both versions. I have been told by one person that CF is LESS stable at the moment on Linux, and I want to see if that's true before we switch over to that platform. Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Categories tree
Thanks to Chris and Dick... extremely helpful comments! -Mensaje original- De: Chris Montgomery [EMAIL PROTECTED] Para: [EMAIL PROTECTED] [EMAIL PROTECTED] Fecha: viernes 14 de julio de 2000 7:53 Asunto: RE: Categories tree Francisco, There is an article on recursion at the Defusion site (http://www.defusion.com/articles/index.cfm?ArticleID=63) that might help. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner NetObjects Reseller 210-490-3249/888-745-7603Fax 210-490-4692 Find a Job in San Antoniohttp://www.sajobnet.com -Original Message- From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:06 PM To: [EMAIL PROTECTED] Subject: Categories tree Hi all, I don=B4t know if it=B4s just me or this is quite tricky. All i want to = do is what CFtree does but without using an applet do it. I=B4ve got a = set of categories and subcategories. Unfortunately the depth of the tree = is not fixed so basically we can add categories under a certain category = forever. I=B4m not aware of any single piece of CF code that uses recursive = principles to achieve tasks. Tried to use a looping version of what i = need instead but i just can=B4t come up with a solution to retrieve = information no matter the depth of the category tree (yes, it=B4s been a = really bad day for me today). I=B4ve already got the code for creating a = nice dhtml tree but i just can=B4t find the way or sequence i need to = generate the whole block of code. Something following a secuence like: Branch - Category 1 Leaf - Category 2 Leaf - Category 3 Branch - Category 4 Leaf - Category 5 Branch - Category 6 Leaf - Category 7 Leaf - Category 8 ... etc. Any ideas? TIA Francisco Montes --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFHEADER HELP NEEDED
I am trying to allow the end user to open CFOUTPUT in excel. It seems to be working OK to a point. When the download file dialog box pops up it wants to download the cfm file itself. Naturally the cfm file is opening in my ColdFusion studio application. I was under the impression that I could use CFHEADER to assign the filename value to something like icb-dl.xls so that it would open correctly in Excel as a comma delimited file. Can you tell me what is wrong with the following? CFSETTING enablecfoutputonly="No" SHOWDEBUGOUTPUT="Yes" cfquery name="icbdata" datasource="P6Access" dbtype="ODBC" Select * from icbdata /cfquery cfcontent type="msexcel" cfheader name="FILENAME" value="icb-dl.xls" CFLOOP QUERY="icbdata" cfoutput#Ref_Num#,#zone#,#Print_Mode#,#Media_Type#,#Ink#,#Icb# /cfoutput /cfloop -Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: New to Cold Fusion
Hello Peter, http://www.acfug.org/downloads/acfug062399.zip, Check out this link at the Atlanta ColdFusion Usergroup. There are meetings there every month and one month security was covered and there was some demo code there. Check it out this is just what you were asking for. If you want more Information on ColdFusion I suggest looking into a ColdFusion user group such as the Atlanta ColdFusion user group, you can find more info at www.acfug.org . Also the allaire site will have a lot of good information on where to get started. Jeremy Allen [EMAIL PROTECTED] -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 10:41 AM To: '[EMAIL PROTECTED]' Subject: New to Cold Fusion And I would like to see an example of password protection using sessions. I don't understand cf applications yet. :/ Peter -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Slightly OT: Dumb HTML question
At 04:09 PM 7/13/2000 -0700, Gregory Harris wrote: Hello everyone, I was trying to build a table cell TD with it's own border (apart from the rest of the table) in Netscape 4. I tried TD BORDER=1 and that didn't work, I tried a style sheet and that didn't work either, does anyone know how to do this? Thanks! table border=1 As far as I know, you can't assign a border for individual td's. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session management
I'm assuming you were expecting your shopping cart to be gone after an hour? Any session variables are destroyed after an hour, but your CFID is set in a cookie. If your shopping cart was in session variables it would be gone, but I'm assuming you wrote it to a database with an ID of 71, and so it persisted overnight. If you want to "kill" the shopping cart when the session variables timeout, do something like the following: cfif not isdefined("session.active") !--- check for and delete any database records you don't want --- cfset session.active = "True" /cfif Session.active will disappear after an hour of them not using the site. The one thing this won't do is clean up shopping carts that have been abandoned by people who don't return. HTH, Dan -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 6:55 AM To: Cf-Talk Subject: session management Hey all, I am having a serious session management problem. Here is my cfapplication tag ... CFAPPLICATION NAME="xite" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,1,0,0)#" When I was working with the application last night I had a cfid of 71. This morning when I come back in (machine was shutdown last night) and logged back into the application I had a cfid of 71 and the stuff that I put into the shopping cart last night showed up. What am I doing wrong!!! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: mail transfer agents
There is also inFusion Mail Server. iMS is the only mail server that uses ColdFusion templates for mail processing which means that the server is completely customizable if you can code in CFML. iMS supports unlimited users, domains, aliases, etc. It also supports RBL and Authenticated SMTP (both incoming and outgoing) and APOP Authentication. You can also have a look at iMS POST SE Server which is for outgoing mail only. It is a low cost solution for creating your own outbound-only MTA. More info is at http://www.CoolFusion.com/iMS.htm Regards, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 www.CoolFusion.com Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** Check out inFusion Mail Server - the world's most configurable email server - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 14, 2000 10:51 AM Subject: OT: mail transfer agents I need to set up my own mail transfer agent (MTA) to accept outbound mail from CF, as the local infrastructure only supports authenticated SMTP. My traffic level is relatively low, hundreds of message per day max. I would put it on a dedicated box, and want to configure it to only accept mail from my servers. I'm aware of sendmail qmail IIS smtp service exim smail ssmtp zmailer Any suggestions or opinions? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: mail transfer agents
post.office from www.software.com has a 10 user which works great for outbound relay and it is free. - Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 10:52 AM To: [EMAIL PROTECTED] Subject: OT: mail transfer agents I need to set up my own mail transfer agent (MTA) to accept outbound mail from CF, as the local infrastructure only supports authenticated SMTP. My traffic level is relatively low, hundreds of message per day max. I would put it on a dedicated box, and want to configure it to only accept mail from my servers. I'm aware of sendmail qmail IIS smtp service exim smail ssmtp zmailer Any suggestions or opinions? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.