Re: Feature request: macro recorder
erm... Having looked at dwmx, there is such a thing under commands but it's grayed out... Paul - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 4:35 PM Subject: RE: Feature request: macro recorder would you bite my head off if I said copy and paste? :O) Ade -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: 07 May 2002 15:46 To: CF-Talk Subject: Feature request: macro recorder Do any of the MM IDEs offer a macro reporder? I've been asking for a simple marco recorder since I started using the original HomeSite (and even after moving to CF Studio), but to no avail! The Redo function isn't enough. I regularly need to do a repeateable sequence of keystrokes and I wish I had a simple macro recorder like the one in Programmer's File Editor (PFE). It's just a simple record toggle and a hot key to replay the keystrokes. In fact, I usually copy over to PFE, do the edits using the macro recorder and paste the edits back into CF Studio. This would be such a great feature to include in CF Studio (and the rest of the MM IDEs, if they don't have it). How about it, MM? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Reference on Cold Fusion 5
go and download the cf5 help files upgrade from the macromedia website. Very helpful. Paul -Original Message- From: Norman Elton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 15 June 2001 11:19 Subject: RE: Reference on Cold Fusion 5 I believe there's a great run-down in the recent edition of the ColdFusion Developer's Journal, if you can acquire a copy. Otherwise, it seems like I saw a decent one in the online help when I was trying out the beta, but I'm not exactly sure on that one. Norman -Original Message- From: Greg Czechowicz [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 5:12 PM To: CF-Talk Subject: Reference on Cold Fusion 5 Does anyone have a good reference on all the new features of cold fusion 5? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session time out = never ? Bad?
If the registry starts to get clogged, just store the data in a database instead. This is set from CF Administrator. Never use the registry with client variables. Always set up client variables to work with a database. Just makes sense. Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Custom tag dilemma
Custom tags will work if they are in the same directory as the file. So two files a.cfm and b.cfm in same dir and you can call cf_a in b.cfm (and vice versa if needs be). Also, you can create your own custom tags folder in the web root somewhere, and you can call it via cfmodule template=a.cfm Enjoy! Paul PS Custom Tags folders only serve the purpose of hiding custom tags outside of the webroot. After that, they aren't much use! -Original Message- From: Guy McDowell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 14 June 2001 14:31 Subject: RE: Custom tag dilemma I could really use some custom tag functionality. Problem is, our host will not install or support any custom tags period. Add to that, that my organization is practically married to our host and won't change hosting. So...is there a way to implement a custom tag without it having to be in the CustomTags directory? Yours In Conservation, Guy J. McDowell Webmaster Ontario Federation of Anglers Hunters (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Protect CF from SQL/Oracle errors?
I am not sure if what you want is something to stop CF being brought down (ie crashing) or it just returning errors. If it's just errors, try this: cftry cfcatch type=database ... do whatever you want in here ... /cfcatch /cftry Otherwise, check your Oracle and CF installs... Paul -Original Message- From: Chris Norloff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 12 June 2001 16:49 Subject: Protect CF from SQL/Oracle errors? I've got a Solaris server with CF 4.5.2 that's being brought down by multiple Oracle Error Code = 936 . missing expression errors in the SQL statements passed to Oracle. It's a Development box, so it's going to get lots of errors. Maybe the Developers could ease up on this, but I sure would like to protect the CF server. Any ideas? thx Chris Norloff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: sorting by IP addresses...
wouldn't sorting them using the bitwise functions make more sense on this one? They are binary after all. Paul PS Otherwise, just recreate the ip address with leading zeros, then sort them as text and it may well sort out the problem e.g.: 216.56.6.245- 216.056.006.245 216.66.132.134 - 216.066.132.134 24.16.140.8 - 024.016.140.008 24.165.85.118 - 024.165.85.118 24.178.211.39 - 024.178.211.039 -Original Message- From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 07 June 2001 07:53 Subject: sorting by IP addresses... So I am writing some log reporting for my enjoyment... well to make things a little easier to quantify... one thing I want to be ablt to do is ORDER queries by the value stored of the viewers IP ADDRESS... It doesn't work without some modification of the IP address... anyone worked on anything to do this right... for instance I get this in order: 216.56.6.245 216.66.132.134 24.16.140.8 24.165.85.118 24.178.211.39 not exactly right :) ideas please... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: sorting by IP addresses...
Try running this code from CF (obviously): ---code--- cfset iplist = 216.56.6.245,216.66.132.134,24.16.140.8,24.165.85.118,24.178.211.39 cfset newiplist = cfset num = 1 cfloop list=#iplist# index=addr cfset newip = cfloop list=#addr# index=part delimiters=. cfset newpart = part cfif part lt 100 cfset newpart = 0 part cfelseif part lt 10 cfset newpart = 00 part /cfif cfset newip = ListAppend(newip, newpart, .) /cfloop cfset newiplist = ListAppend(newiplist, newip, ,) cfset num = num + 1 /cfloop cfloop from=1 to=#ListLen(iplist)# index=i cfoutput #ListGetAt(iplist, i)# : #ListGetAt(newiplist, i)# /cfoutputbr /cfloop brbr cfloop list=#ListSort(newiplist, text)# index=j cfoutputb#j#/b/cfoutputbr /cfloop ---code--- Enjoy! Paul -Original Message- From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 07 June 2001 07:53 Subject: sorting by IP addresses... So I am writing some log reporting for my enjoyment... well to make things a little easier to quantify... one thing I want to be ablt to do is ORDER queries by the value stored of the viewers IP ADDRESS... It doesn't work without some modification of the IP address... anyone worked on anything to do this right... for instance I get this in order: 216.56.6.245 216.66.132.134 24.16.140.8 24.165.85.118 24.178.211.39 not exactly right :) ideas please... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: KILL THE COOK!
I have to agree that you need to post some code. Are you sure that the cookies are not getting deleted by a logout thing (if that's what it's about) or that they aren't getting re-written every request by something called int he application.cfm or equivalent... You have to check the entire page request not just the one page. Post something to the list that gives us a better idea of the problem. Paul -Original Message- From: Dylan Bromby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 05 June 2001 17:27 Subject: Re: KILL THE COOK! Why don't you post ALL the code in question rather than snippets. I think it's safe to say a lot of us have used CFCOOKIE without problem(s) for some time, so the problem you're having isn't very obvious. If you want to email me your files off-list, I'd be happy to review them. You can send them to [EMAIL PROTECTED] --Dylan On 6/5/01 9:40 AM, Michael Lugassy [EMAIL PROTECTED] wrote: Please try to look into this again. this thread has been reviewd and partially answered by many (actually 13 people) but still - no answer. can anyone try to help out? I'm getting really frustrated from this CFCOOKIE thing. Apparently, after I assign the cookie with Timeout=Never the cookie is deleted and terminated every time the user closes the browser. I tried to change Timeout to 14 days, but it didn't help. Closing the browser terminates the cookie. Is there a diffrent way to assign cookies? PLEASE HELP!!! -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: html as xml for asp :)
If you're using ASP, why not use the MSXML object directly? Have a look at CF_SOXML and reverse engineer (it's really not that hard!). I hope you are successful. Paul -Original Message- From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 03 June 2001 14:10 Subject: OT: html as xml for asp :) I'm trying to locate a code or object that will easily convert/create xml document from asp structre or variable. something easy like the CF_SOXML tag, just for ASP. Thanks, Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
session and client variables
Anyone, I have come up with a slight issue in the past, and it is this: If you are using client variables for a secure section of a website and they have a timeout (say 10 minutes). The users closes the browser thinking that they have logged out (when they haven't) and the cookies (let's assume cookies here) get destroyed by an onunload= event. The logout script destroys the cookies when the user leaves the secure section, so we don't worry about that. Bearing in mind that an onunload event doesn't work consistently in all browsers (it's a known bug in Netscape) does anyone have a solution (barring recoding of the site to use the urltoken), for destroying the cookies in the users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape 6)? The problem is that it is entirely possible (and sensible) that the cookie should stay on the user machine if they come back to the site so that they are logged in (assuming the ten minutes isn't up), but what if they are in an internet cafe and the ten minutes aren't up? (Let's assume we're using a clustered server here so session variables become virtually pointless... or do they?) Any replies welcome (ie sensible ones). Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Brain isn't working yet...
how about a regular expression? cfif REFind(192[.]168[.]5[.][12]?[0-9]?[0-9], cgi.remote_addr) /cfif or something like that! Paul -Original Message- From: Marcus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 01 June 2001 16:14 Subject: Brain isn't working yet... I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. cfif #cgi.remote_addr# is '192.168.5.0' Allow action /cfif The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session and client variables
All you appear to be doing is reading and writing the cookies. Exactly how does this stop the user closing the browser and not having the cookie's destroyed? When the user re-starts the browser and goes to that page, the cookies still exist (as far as I can tell). Paul -Original Message- From: Andy Ewings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 01 June 2001 16:47 Subject: RE: session and client variables Paul Put this in your application.cfm: cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset cfid_local = Cookie.CFID cfset cftoken_local = Cookie.CFTOKEN cfcookie name=CFID value=#cfid_local# cfcookie name=CFTOKEN value=#cftoken_local# /cfif This will ensure that whenever they close the broswer the session is killed (or rather their link to the set of client vars is broken). The client vars weill then get destroyed when the timeout is reached. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 16:02 To: CF-Talk Subject: session and client variables Anyone, I have come up with a slight issue in the past, and it is this: If you are using client variables for a secure section of a website and they have a timeout (say 10 minutes). The users closes the browser thinking that they have logged out (when they haven't) and the cookies (let's assume cookies here) get destroyed by an onunload= event. The logout script destroys the cookies when the user leaves the secure section, so we don't worry about that. Bearing in mind that an onunload event doesn't work consistently in all browsers (it's a known bug in Netscape) does anyone have a solution (barring recoding of the site to use the urltoken), for destroying the cookies in the users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape 6)? The problem is that it is entirely possible (and sensible) that the cookie should stay on the user machine if they come back to the site so that they are logged in (assuming the ten minutes isn't up), but what if they are in an internet cafe and the ten minutes aren't up? (Let's assume we're using a clustered server here so session variables become virtually pointless... or do they?) Any replies welcome (ie sensible ones). Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Brain isn't working yet...
or the numerous ways you could do it: cfif ListFirst(cgi.remote_addr, .) eq 192 AND ListGetAt(cgi.remote_addr, 2, .) eq 168 AND ListGetAt(cgi.remote_addr, 2, .) eq 5 /cfif or cfif Left(cgi.remote_addr, 3) eq 192 AND Mid(cgi.remote_addr, 4, 3) eq 168 AND Mid(cgi.remote_addr, 9, 1) eq 5 /cfif or cfset a = ListToArray(cgi.remote_addr, .) cfset b = 192.168.5 cfset ip_ok = TRUE cfloop from=1 to=3 index=i cfif a[i] neq ListGetAt(b, i, .) cfset ip_ok = FALSE /cfif /cfloop cfif ip_ok /cfif and I can't be bothered to think of more as it's getting very silly! Enjoy Paul ;-) -Original Message- From: Paul Johnston [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 01 June 2001 16:54 Subject: Re: Brain isn't working yet... how about a regular expression? cfif REFind(192[.]168[.]5[.][12]?[0-9]?[0-9], cgi.remote_addr) /cfif or something like that! Paul -Original Message- From: Marcus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 01 June 2001 16:14 Subject: Brain isn't working yet... I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. cfif #cgi.remote_addr# is '192.168.5.0' Allow action /cfif The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dhtml menu
I did notice that there was a cf_hiermenus tag just uploaded to the developers exchange. Paul -Original Message- From: C Frederic Valone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: 30 May 2001 12:50 Subject: Re: dhtml menu Try Hiermenus http://www.webreference.com/dhtml/ If you need to use cf to dynamically create the menus I have gotten it to work this way... you will need to modify the scripts a bit though. Email me off list if you want to see what I have done to integrate this with cf. Thanks, Frederic Mak Wing Lok wrote: did anyone know is there any dhtml menu CF tags that can work in IE and Netscape, i tried CF_dhtmlMenu but it only works on IE, i need a CF tag that will work on both browser. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: databases for CF on Solaris?
The best database to use on Solaris (after Oracle) is Sybase, but failing that there are several different databases that work on **nix systems that are worth a look. Probably the best two to evaluate are Postgres and MySQL (both sort of free without support). However, this is more a question for a Solaris list (where you'll find infinite amounts of geeks and techie's willing to tell you what you need!!!). Make sure you know exactly what you want it for before you ask though. This is a situation where overkill is very easy, and so if you just need a simple web DB, probably best to use something like MySQL although it doesn't necessarily do everything you want! Anything more, and be careful that you are going to have enough memory/processors etc. Solaris boxes are a lot more stable and robust, but they don't come from the Teletubby land of computing like some OS's and boxes do. Paul On Friday, May 04, 2001 9:11 AM, Kay Smoljak [SMTP:[EMAIL PROTECTED]] wrote: Hi, I have to quote on a CF site that will be hosted on a Solaris box. Trouble is, as an NT-bunny I have no idea what databases there are available for Solaris. Could anyone could suggest a decently robust one and give me an idea of the price range? I'm looking for something roughly equivalent to MS SQL Server or Borland Interbase - ie I know Oracle is available but that's gonna be overkill I think. Thanks, Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problem writing to a file
A couple of things... * Are you sure that the access denied is not the HTTP call on the webserver? Check the the CFHTTP call is working from the page before trying to write to the file... * Are you sure that CFFIle can do a write to that directory? Again check from a dummy page... If this is working (I assumed you checked it) then the problem will be file permissions somewhere along the line, but it looks like those are fixed. So the server side issue looks sorted. For this reason, I would expect that the problem would lie in the webserver HTTP call. Check that the file can be written and that you can access the webserver internally (ie that it allows calls from the webserver itself because it doesn't have to). Check the firewall settings and the HTTP settings. Apart from that, there isn't enough info in your post to go further (ie webserver, cf version etc). HTH Paul -Original Message- From: Andy Ewings [SMTP:[EMAIL PROTECTED]] Sent: 30 April 2001 12:18 To: CF-Talk Subject:problem writing to a file I made a post some time ago along these lines but the problem stiull remains so I though I might try again: I have a site sat on 2 web servers with load balancing. I have a page that when called uses HTTP and CFFile to wirte info to a file on a shared drive on the server using a mapped drive. The problem is when I call this page and look at the subsequent file that is created all that is in it is Access Denied. both CFServers are running as a user account which has full access permission to the folder containing the file. The file is also owned by this user. Has anyone come accross this before? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another regular expression question
using a ^ says not one of these and using [] says group these together how about saying if you find something that is not a number or a letter: cfif REFindNoCase('^[A-Z0-9]', variable) ERROR cfelse do processing /cfif what you said is: find 0 or more alpha chars and 0 or more digits next to it which works with any string on the planet! I hope this helps! Paul On Tuesday, April 24, 2001 11:24 AM, JAAV [SMTP:[EMAIL PROTECTED]] wrote: Hi, Yes, I'm a newbie :) but it's a short question: How can I check if an string contains alpha-numeric characters only? I'm trying to check if a login name (given by the user) is valid or not. I'm using something like: #REFindNoCase('[[:alpha]]*|[[:digit]]*',attributes.usuario)# but it doesn't work. BTW, some links of POSIX regular expression are welcome. thanks in advance ~JAAV ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does Studio have Built-in Scripting?
Just a quick question... has anyone else built any useful little helper applications or stuff like that with the Windows Scripting Engine? I have built things like a button that you click that creates a new document, asks you for various things like the name of the file, the author (there is a default for this), and asks for some documentation for the page, and then it saves it with the correct filename in the current directory. It's really useful for pre-documenting your pages (at least it helps if something goes wrong with the page and another developer looks at it!). This was written in javascript (style). Has anyone else done stuff like this? Paul Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: 07866 573013 CV: http://pjnetsolutions.cfdeveloper.co.uk/cv/ - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 6:57 PM Subject: RE: Does Studio have Built-in Scripting? I was looking at the figleaf downloaded slides from the Using VTOM presentation by Mr. Powers and was wondering - what language is the code on 4th slide? Normally I think of Windows Scripting Host as being something like Visual Basic. What is on page 4 appears to be Javascript; and in fact, the example files are all *.js , which is what I know I use for javascript. Windows Script Host isn't a language, it's a scripting engine. You can use lots of languages with it, including JavaScript and VBScript "out-of-the-box", and Perl and Python with extra add-ons. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML
Well... XML is an excellent way of structuring your content into sections. It's not an output language of any sort (for that use CSS or XSLT). It can be very useful as a data interchange language. By specifying a DTD for XML sent between two computers/systems/programs/networks/etc, you can set up excellent and simple data transferral systems. Advantages in CF apps. There are many advantages, although I wouldn't necessarily say that it's the only way of doing some things. Again, data interchange is the most common use. Unless you want to start dynamically creating XML pages with DTD's and XSLT then I would say don't go XML completely. An example of when I have used it is to send data to and from a remote database (actually at another company altogether who were providing the data in XML format). XML can also be used as a kind of text database, but it isn't necessarily the best way to do things! Easy to learn? Depending on your perspective and what you want to do. For a simple XML application, take a look at a wddx packet! Create some kind of data structure, create a WDDX packet and then output the packet to a file (or the screen but remember that you must escape the with lt; and with gt; or whatever way round it is). Simple application of XML. There are some excellent XML resources on the web. Take a look in the google directory and you'll find hundreds of links. As far as integrating CF with XML, have a look at http://www.siteobjects.com and the cf_soxml tag (I think that's what it's called now). Very useful stuff using the MS XMLDOM COM object. XML will become more important, but not necessarily for website development. I see it more as a backend type of tool for at least the next couple of years. Anyone disagree? Paul PS I am not an authority on XML and all views expressed are my own. Please listen to other people too! Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: 07866 573013 - Original Message - From: "Phoeun Pha" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 9:21 PM Subject: XML what are the advantages of using XML with my coldfusion web apps? like what cool stuff can I do? and is XML hard to learn? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP and creating csv recordset problems...
Note: CFX_secFile (basically same thing) has no limit beyond your current virtual memory. Thanks! But it doesn't help if you're on a shared server and the ISP allow you to use CFX_File though! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Outputting Mac Characters
Is there a tag or something that can parse Mac characters and make them something sensible before outputting them to the screen? I have a whole database full of articles that are all written on a Mac, and I want to output them to the screen as is (there are 3000 of them, and parsing them when entered is not an option because they could upload several hundred at a time!). Anyone? Paul Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: 07866 573013 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: nesting queries
At the risk of having seventeen other people tell you how to do it... All that this code... cfoutput query="myQuery" /cfoutput does is: cfoutput cfloop query="myQuery" /cfloop /cfoutput Try using cfloop instead. Also if you want to create a query based on another query, you have to loop over the first query, create the new query, and then output that query: cfquery name="Query1" datasource="#dsn#" SELECT * FROM myTable ORDER BY myField asc /cfquery cfoutput cfloop query="Query1" cfquery name="Query2" datasource="#dsn#" SELECT * FROM table WHERE aField = '#query1.myfield#' /cfquery cfloop query="Query2" #Query2.aField#br /cfloop /cfloop /cfoutput However, this is not efficient as there are going to be the same number of database calls as there are records returned in the first query! Try to use the database to return a much more useful result set (if you're using MS SQL Server that means a stored procedure - ask if you're not sure). If you can then output the resultset once, you only need to go to the database once and you only need to output it once (and it's a lot easier on ColdFusion too!). I hope this makes sense! Paul Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: 07866 573013 - Original Message - From: "Jones, Becky" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 1:57 PM Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. !--- Query to get all User's info. --- cfquery name="qryAllEmp" datasource="ITData" SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' cfif office eq "All Offices" AND tblEmployees.Office LIKE '%' cfelse AND tblEmployees.Office LIKE '#office#%' /cfif ORDER BY tblEmployees.lname /cfquery !--- Query to get the users Equipment info. Setting iEquipID eq the previous query's results. --- cfset iEquipID = qryAllEmp.EmpID cfquery name="qryEquipment" datasource="ITData" SELECT * from tblEquipment WHERE EquipID = #iEquipID# /cfquery I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP and creating csv recordset problems...
Not a problem I have had as yet... There is a documented feature of CFHTTP that allows you to load up a comma-delimited file into memory via CFHTTP. This is useful if (and this is the case) you can't use CFFile to load up a comma-delimited file (CFX_File has a max size of 64KB for a read) and you can't set up a csv datasource in the CF Administrator. Using CFHTTP you can load up a comma-delimited file into a recordset like this: cfhttp url="http://www.myurl.com/mytextfile.csv" method="GET" name="data" columns="title,keywords,mytext,x" /cfhttp and this then loads the cfhttp.filecontent as a query, and you can reference that query via: cfoutput cfquery name="data" b#title#/bbr#keywords#br#mytext# /cfquery /cfoutput "Hooray" you might think! This means that if someone disables the CFFile tag, you can still load up data from a comma-delimited list! Problem: The documentation says that if you don't specify the columns, CF ignores the first line of the page and uses those values as the column names. I run this with column names, and it ignores the first line anwyay and just goes to the second line. It also seems to ignore the last line. I have tried several things like adding a line break and/or carriage return at the start and end. I have tried testing on just one record... It seems to think that the first line has the wrong number of comma-delimited fields and so it won't put it into the recordset. However, I have checked the missing records, and they have the same number of fields as every other one (it's a database export - from a database I don't have any access to, so I need an export - so it should do!). If you've got this far, then you've done well. If you can think of anything else then please tell me. If you know of any problems, then let me know! Paul Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: 07866 573013 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX_File problem
I have started and stopped the services, the machine and nothing works. I downloaded it off the developers exchange a few days ago, and tried it on and off for several days. I have followed the instructions on how to install the CFX_File tag, and as far as I can tell, I have nothing in the setup that doesn't work. Anyone know of any problems with the tag? Paul - Original Message - From: "Vano, Carl G, SITS" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 5:53 PM Subject: RE: CFX_File problem Paul, did you startstop cf services? -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:46 AM To: CF-Talk Subject: CFX_File problem Anyone? Am using CFX_File downloaded from the allaire developers exchange and can't seem to get it to work! It just returns an error of Unknown Action: "READ" or some such other action (that is blatantly obvious cos it's in the docs). The code I am using is (for a copy): cfx_file username="test" password="test" action="copy" source="C:\inetpub\wwwroot\index.cfm" destination="C:\inetpub\wwwroot\index_copy.cfm" Win2k Pro, CF Pro 4.5.1 SP2 Anyone? Am I missing something in Win2k or is it the tag? Paul Paul Johnston PJ Net Solutions Ltd (UK) E: [EMAIL PROTECTED] M: 07866 573013 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX_File problem
Anyone? Am using CFX_File downloaded from the allaire developers exchange and can't seem to get it to work! It just returns an error of Unknown Action: "READ" or some such other action (that is blatantly obvious cos it's in the docs). The code I am using is (for a copy): cfx_file username="test" password="test" action="copy" source="C:\inetpub\wwwroot\index.cfm" destination="C:\inetpub\wwwroot\index_copy.cfm" Win2k Pro, CF Pro 4.5.1 SP2 Anyone? Am I missing something in Win2k or is it the tag? Paul Paul Johnston PJ Net Solutions Ltd (UK) E: [EMAIL PROTECTED] M: 07866 573013 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression to parse incoming data stream?
There are various messages in the archives relating to this. Have a search and it will tell you. It's a common problem that for the life of me I can't remember what the solution is. Paul -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 8:45 PM To: CF-Talk Subject: RE: Regular expression to parse incoming data stream? Thanks, Paul. Here is the output I'm getting. The first few lines are me checking to see if the http request was successful (200=yes); 69 is the length of the file being returned; MIME type unknown (???); and then me trying to print the cfhttp.filecontent in a variety of ways. The rest is the output from your code. Any ideas on why I'm getting the "not ASCII test" message, or what I can do about it? Is there some way to make CF think it's getting ASCII text (b/c I _know_ the xml coming is really is ASCII!!!)? Much thanks, James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
Thats very interesting, because doing a view source indicates that they are using CF:-) I mean how many other scripting languages generate that much whitespace! Erm... Loads of languages generate that much whitespace! Which ones? Perl (if badly written), PHP (if badly written), ASP (if badly written), CF (if badly written), Mason (if badly written), and everything else under the sun (if it's badly written). CF, however is a bit more interesting... The point about CF is that it uses the approach of "Anything written in CF changes to whitespace when processed" as a default, instead of treating CF as a programming language and compiling etc (prepare to flame me...). That's what produces the whitespace. This can of course be turned off, and can mean faster page loading. The CFML processor is effectively only a parser (a fast one, but still a parser) so any other language that is parsed like this will produce similar output. Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: wddx/java
Let's not forget that all WDDX is, is an XML packet. If you want to do something funky with it, just treat it as XML and use the numerous XML COM/Java/CORBA/man/and/his/dog type objects that are available. After all, that's all Allaire do, and they haven't dropped support for it. It's used extensively in Spectra. It's just a very simple schema for lobbing data around between applications in text form rather than in CF code form. Paul -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 11:16 PM To: CF-Talk Subject: RE: wddx/java Is there wddx for ASP or Com look wddx.org and could not find it does anyone know exactly where it is ? There's a WDDX COM component in the WDDX SDK, along with a bit of documentation. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
Thats very interesting, because doing a view source indicates that they are using CF:-) I mean how many other scripting languages generate that much whitespace! Erm... Loads of languages generate that much whitespace! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression to parse incoming data stream?
Erm... CF on Linux - use James Clarks Expat Parser for XML. There isn't currently a simple CF interface for this though (one day...) There is a simple Perl interface, and since you're on Linux, pass the processing to something that can handle it. My best guess would be Perl. The reason is that there are numerous XML modules for Perl, and they are excellently supported by a mailing list. Otherwise, if you are not getting complex data back (ie no CDATA sections) then for the regex (bear in mind you can't really check whether it's an XML packet beforehand so it's really only a hack) you need to take everything in the and find everything up to the / with the same name. 1) Create a structure to hold the XML (can store the whole thing as a structure) 2) Then, find the first tag name (ie find a and then the next bit of text up to a "" or a " ") and then find the attributes (everything up to the next ""... 3) Find the end tag for it (/__name__) 4) everything in between is the data (which can contain XML) 5) pass the rest of the packet through the "parser" Anyway, that's the way I'd do it. Maybe I'll try and do this! Paul PS: CDATA sections look like this: -- mydata ![CDATA[ DOCUMENT NAMEPaul Johnston/NAME EMAIL[EMAIL PROTECTED]/EMAIL /DOCUMENT ]] /mydata -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 2:52 PM To: CF-Talk Subject: RE: Regular expression to parse incoming data stream? I'm running CF under Linux; I think SOXML only works with Windows. Also, my incoming data stream is so small, I'm not sure it's worthwhile to go with a full XML parsing solution. If anyone out that can lead me to the light on regular expressions, I'd really appreciate it. Thanks, James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 12:47 AM To: CF-Talk Subject: RE: Regular expression to parse incoming data stream? Could I recommend the CF_SOXML custom tag, which is an alternative to CF_WDDX. This is available via Allaire's tag gallery. Mike. -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: 30 January 2001 01:05 To: CF-Talk Subject: Regular expression to parse incoming data stream? I am sending an http request to a server (using CFHTTP and CFHTTPPARAM ) which is responding with some xml of the form: tag 353 tag anothertag 100 /anothertag where the numbers are just examples of what comes back. Can anyone give me an example of what I'd need to do to use regular expressions to parse the incoming data stream (the server response) to just take out the numbers and assign them to variables in CF? I've explored the WDDX solution but it turns out not to be viable in this case. Thanks, James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression to parse incoming data stream?
Adding to my previous post (if you can understand the code) here is my idea of what you should do. Just cut and paste it into a cfm file and run it. Paul -code- cfset myStruct = StructNew() cfset myStruct.blah = "This is fun isn't it!" cfwddx action="CFML2WDDX" input="#myStruct#" output="mywddx" cfset xml = StructNew() cfoutput #Replace(Replace(mywddx, "", "lt;", "all"), "", "gt;br", "all")# /cfoutput cfscript xmlpacket = mywddx; xml.root = StructNew(); xml.root.namestart = Find("", xmlpacket, 1) + 1; xml.root.nameend = REFind("(| )", xmlpacket, xml.root.namestart); temp_count = xml.root.nameend - xml.root.namestart; xml.root.name = Mid(xmlpacket, xml.root.namestart, temp_count); xml.root.datastart = Find("", xmlpacket, xml.root.namestart) + 1; xml.root.dataend = Find("/" xml.root.name "", xmlpacket, xml.root.datastart); temp_count = xml.root.dataend - xml.root.datastart; xml.root.data = Mid(xmlpacket, xml.root.datastart, temp_count); /cfscript h3Data/h3 cfoutput cfloop list="#StructKeyList(xml.root)#" index="i" bxml.root.#Lcase(i)#/b: #Replace(Replace(Evaluate("xml.root." i), "", "lt;", "all"), "", "gt;br", "all")#br /cfloop /cfoutput -code- -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 2:52 PM To: CF-Talk Subject: RE: Regular expression to parse incoming data stream? I'm running CF under Linux; I think SOXML only works with Windows. Also, my incoming data stream is so small, I'm not sure it's worthwhile to go with a full XML parsing solution. If anyone out that can lead me to the light on regular expressions, I'd really appreciate it. Thanks, James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 12:47 AM To: CF-Talk Subject: RE: Regular expression to parse incoming data stream? Could I recommend the CF_SOXML custom tag, which is an alternative to CF_WDDX. This is available via Allaire's tag gallery. Mike. -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: 30 January 2001 01:05 To: CF-Talk Subject: Regular expression to parse incoming data stream? I am sending an http request to a server (using CFHTTP and CFHTTPPARAM ) which is responding with some xml of the form: tag 353 tag anothertag 100 /anothertag where the numbers are just examples of what comes back. Can anyone give me an example of what I'd need to do to use regular expressions to parse the incoming data stream (the server response) to just take out the numbers and assign them to variables in CF? I've explored the WDDX solution but it turns out not to be viable in this case. Thanks, James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF IDE for *nix Mac etc ...was RE: Allaire on a Mac?
To be honest, all I want from an IDE to write code on is the tag/function completion. If someone wants to build this into jedit (or is it already there?) then I would use it. What would be even more useful would be the ability to add in my own tags/functions etc for future use. That way you can make the editor do completion for any language coding you want in the world. Whatever language, the editor helps. Anyone? Paul PS As long as you can turn on and off certain completion schemes, then it would work fantastically well! -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 7:14 PM To: CF-Talk Subject: CF IDE for *nix Mac etc ...was RE: Allaire on a Mac? Anyone wants a nice cfstudio like IDE for *nix , Mac Windows Sun ?? Check out http://jedit.sourceforge.net don't dismiss it because is java - it's very fast. Make sure you install the plugins (tabs, cmd and project, ftp...) is you want a real cfstudio type interface .. You can customise it (eg add close buffer to right click) I'm working on a DB plugin for it... Justin -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:53 PM To: CF-Talk Subject: Re: Allaire on a Mac? I don't know if I'd like CFserver on a Mac or not, but I'd like to see the IDE's (Studio/HomeSite) ported over (to Linux as well, though I know there are some code issues there) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Randy Zeitman wrote: Anyone have any insight as to whether Allaire's apps will soon run on Macintosh as a result of the merger with Macromedia? -- **This signature sponsored by GuitarList.com - the most powerful musical instrument search engine on the net!** "I've gotten so out of shape sittin' at the computer all day that I get out of breath when I have to reach for the percent key!" - Zeitman Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio Projects
I have a project set up that contains a whole website to go onto a shared server. However, I cannot create a script to upload that project to the correct directory, because I do not have FTP access, only RDS access to the server. What I am confused about, is how it knows where to put the uploaded files. Is it in the webroot or does it give you some options? So in reality the question is, how do you create a script to upload a project to a specific directory with only rds access? pAUL ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: case sensitivity in stored procedures
It can be done! You can bypass the case-insensitivity, although it's a bit long winded (but it works). What you need to do is use the ASCII character number to make a string case sensitive (ie convert it into ASCII characters and test against those!). there are two functions, ASCII and CHAR. Here's an example (from the Transact-SQL Help) and note that D and d have different numbers: SET TEXTSIZE 0 SET NOCOUNT ON -- Create the variables for the current position of the character string -- and for the character string. DECLARE @position int, @string char(15) -- Initialize the variables. SET @position = 1 SET @string = 'Du monde entier' WHILE @position = DATALENGTH(@string) BEGIN SELECT ASCII(SUBSTRING(@string, @position, 1)), CHAR(ASCII(SUBSTRING(@string, @position, 1))) SET @position = @position + 1 END SET NOCOUNT OFF GO Here is the result set: --- - 68 D --- - 117 u --- - 32 --- - 109 m --- - 111 o --- - 110 n --- - 100 d --- - 101 e --- - 32 --- - 101 e --- - 110 n --- - 116 t --- - 105 i --- - 101 e --- - 114 r Enjoy! Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:55 PM To: CF-Talk Subject: RE: case sensitivity in stored procedures Nick, this was helpful, thanks - I didn't realize it was an installation option, and I've never seen it installed except with the default setting. I looked it up in BOL and it gives pretty good details. I'm sure I've been lazy enough with object names, etc. that I wouldn't want case-sensitivity ON - half my queries or code might fail. Well maybe not half, but some. I had been trying out some code with tests of exact (case-sensitive) words, such as "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems that the case-sensitivity setting relates to this too. As a result, SEcret, seCRET, SeCrEt, etc. all come up as LIKE the above expression. So it might be better to say that SQL Server is case-insensitive by default, period. Mark [EMAIL PROTECTED] Sebastian Apologies, not a very helpful answer. What I meant was SQL Server is case-sensitive, period. But actually that's not always true, only if SQL Server is installed with a case sensitive sort order. http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/ sql/8_ar_da_ 10.htm Nick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
The strength of this merger is in database driven application development. Macromedia bought Drumbeat, which was very ASP oriented, and has now been absorbed into UltraDev. If we can end up with a product for CF/JRun, which does everything from Studio to UltraDev - that would be quite something. Of course it would need to do ASP(.net) as well for the whole market. Problem being that now everyone will think they are a CF programmer, like all people using Dreamweaver think they are HTML/DHTML programmers (when half the time they haven't got a clue!). I think this is a good merger, but lets not get carried away. The worst thing is that the developer base is certain to increase from the increased exposure that the Macromedia name brings. That means more coders, more sites, less money for those who've been in it for longer! Not thinking just about money though, also thinking about the perception from managers and things. Still not sure about that yet... Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Cross Browser DHTML Menu
Guys, I need a cross browser DHTML menu asap that can do drop down, and slide menus. Menu |-Item1 |-Item2 |-Item3--|-Item5 |-Item4 |-Item6 Does anyone know of a good simple API or generator, that has been tested (the important part of the question) on NN4+ and IE4+, that they would recommend? Please don't suggest CF_DHTMLMenu as it specifically states that it's not for NN. Thanks Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom Tag for creating Forms...
Both correct, but... There is such a thing as CSS. If you think about it, the most useful thing about HTML is that some of the attributes are defaulted on the client machine. Bear this in mind, and you could easily create a form. BTW a form generator is something that takes some data and generates a form. If I'm not mistaken, creating a structure to hold some data and then generating a form from it is exactly that. The way I see it is that if you want something like this, then you have to create certain basic form types with specific defaults. The best way to do this would be to have a server side process to create the form with various defaults. Here we go into the realms of CSS which is a perfectly good client side technology. Why try and create something that isn't really going to save a huge amount of time. The only solution I can come up with, is to create a custom tag to generate the custom HTML tags we want from a limited source, and then we get back to: "Why not ignore CF for the most part and just write it in HTML". For the amount of control we want, creating a CSS and using the client side is far more sensible, especially as you can change everything you want! I hope that's clear. Paul PS Has anyone created a dynamic stylesheet yet? What I mean is, has anyone made a CFM page that is a stylesheet (and would it be worthwhile?). -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 7:11 AM To: CF-Talk Subject: Re: Custom Tag for creating Forms... Why not write a form generator? zero administration. just cuz you asked. doesn't mean you can't cashe the generated form. (wait a minute aren't both scenarios "form generators". (i mnow what you mean though). E From: David Cummins [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Custom Tag for creating Forms... Date: Thu, 11 Jan 2001 10:42:03 +1300 I think a custom tag is going about it the wrong way... extra processing time, limited formatting... Why not write a form generator? Creates the CF code for you, then you just tailor? What would be even better is if its generated code were delimited into sections, and it could detect if you inserted extra code, so if you changed the formatting, you wouldn't lose your custom code. David Cummins Peter Theobald wrote: So the real trick is making it extensible so you can use it to lay out a "basic default" form, but override certain things to customize it. The design I had worked out didn't assume you only had one field per row. It let you put as many fields as you liked in a row. It would add up the number of fields on each row, multiply them all for a "common" denominator, and use that as the number of columns in a table. Each table cell would use rowspan to use up the appropriate space. Everything would come out neat and lined up... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does Studio have Built-in Scripting?
There is such a thing as ActiveScript in Studio so that you can build little code things to do whatever you want. It's not hugely functional but you can pull in COM objects to do whatever you want. I wrote some ActiveScript to put documentation into pages that didn't have any. Click a button, fill in a few dialogue boxes to put in specific information then outputted as a CF comment at the end of the file. This was then read by a browser I created. A whole documentation system. Very easy (when you know how!). Have a look in the Help Files in Studio at "Scripting the Visual Tools Object Model" and then have a go. It's a bit limited and the documentation isn't wondefully clear, but is useful when you get used to it. Paul PS If you want an example, here it is! Set it up as a button on a custom toolbar, and then (it asks if you want to use a script) point the button at the script. I hope it works! - code example - function Main() var app = Application; //create application object variable // if any text is selected, then don't continue message = "This is a pre-alpha version of cfdoc vtom.\n"; message = message + "This will add in cfdoc documentation at the end of the file.\n"; message = message + "If you do not want this, press cancel. Otherwise, enjoy!"; // ask if you want to continue check = app.MessageBox(message,"",1); if (check == 1) { // set up the start and end of cfdoc variables that we will be using start_cfdoc = "\n\n!---\n=cfdoc\n"; end_cfdoc = "\n=endcfdoc\n ---\n"; // get head_text user input default_head_text = "Insert Heading"; head_text = app.InputBox("Please insert a cfdoc heading:","Input Heading",default_head_text); head = "\n=head '" + head_text + "'\n"; // if head_text is nothing or is "Heading" (default) then end if ( head_text == default_head_text ) { head_text = ""; app.MessageBox("You have not entered a heading. An empty header will be inserted.","",48); } // add in subheadings no_more_cfdoc = "continue"; body_text = ""; sub_head = "\n\n=subhead '"; end_sub_head = "'\n"; i = 0; i_max = 10; next = ""; app.MessageBox("This dialogue will allow you to add subheading and text for up to " + i_max + " subheadings.","",48); for (i = 0; i i_max; i++) { if (i != 0) { next = ""; } sub_head_text = app.InputBox("Please add " + next + "sub-heading.", "Please add " + next + "sub-heading.", ""); next_sub_head = sub_head + sub_head_text + end_sub_head; next_sub_head_body = app.InputBox("Please input the text for the subheading","Please input the text for the subheading",""); body_text = body_text + next_sub_head + next_sub_head_body; // see if they want to add more documentation add_more_documentation = app.MessageBox("Add more cfdoc?","Add more cfdoc?",4); if (add_more_documentation == 7 ) { i = i_max; } } // while (no_more_cfdoc != "yes"); // retrieve text of file file_text = app.ActiveDocument.Text; // set up cfdoc documentation cfdoc_documentation = start_cfdoc + head + body_text + end_cfdoc; // output entire text app.ActiveDocument.Text = file_text + cfdoc_documentation; err_msg = ""; } // wait 1/2 second and then output thank you message app.Wait(500); check = app.MessageBox("Thank you for your interest in cfdoc documentation system.\n For more information, contact:\n\nPaul Johnston\n\[EMAIL PROTECTED]","",1); // get rid of the object reference app = ""; } - code example - -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:16 PM To: CF-Talk Subject: RE: Does Studio have Built-in Scripting? I use Note Tab because of it's internal scripting language or I use my DevAssistant. The DevAssistant is CF based and can build forms,stored procedures, and more. -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 3:15 PM To: CF-Talk Subject: Re: Does Studio have Built-in Scripting? I just wish that Studio had an "on the fly" MACROS capability to capture and replay keystrokes or mouse clicks -- man would that save a big bunch of time (and brain cells) when doing detailed, redundant, repetitive work. I ususally end up writing small vb aps that use the windows api functions to create macros. Sure, it takes a little bit more time than if there were macros, but you have more flexibility and much more power that way. Visual Basic isn't a difficult language to learn either. Go down to your local software store and pick up Microsoft's Learn Visual Basic 6
RE: Slightly OT: CF in Europe
Lets put it this way. I have been doing web development work since coming out of the University of Bath (for all you Americans, it's an old Roman City in England that has Roman Bath's in it hence the name) not too many years ago. Since then I have done HTML then Perl, then CF. As far as I'm concerned the lack of penetration in CF means that there are not too many developers out there (although this is increasing). The jobs are there (if you look in the right places and are good enough) but such is the perceived value of ASP in the development market that you would find it easier to get an ASP job (and for that matter a PHP job if you have the skills). However the financial implications of this here are huge! Financially it's good to be a CF programmer in the UK - especially a good one. It's even better to be a Spectra programmer (doesn't really matter how good yet as long as you've done the course or have experience). Don't be put off that CF hasn't penetrated the market yet. I firmly believe that it could (no guarantees), but the worst thing that could happen is that the CF programmers move away from CF! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: deleting session variables
We do have one reason for not using session vars. Clustering. It takes out the need to worry about the variables being held in memory. Paul -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 07, 2001 7:57 AM To: CF-Talk Subject: RE: deleting session variables On first impression using client and session in the same app could be viable if; 1. client requires accessing client storage while session "stays within" the CFAS memory space. 2. if there are vars that need to persist after a session and that are useful to have readily available for a next session 3. assuming session is faster than client {1] On second impression the question needs to be answered whether once client are read if the values also reside in the CAFS memory space - if so, for how long, and how granular is the rentention - i.e. assuming storage is in a db, does one read of any client's vars cause all client's vars to persist in memory or is the clientmanagement selective to retrieving just the particular client vars relative to that client's current session/http request? If every reference to a client var causes a db read or write, then I would say that the only reason to mix client and session is to initialize a client session with client vars, but run the session with session vars. I doubt that client vars are kept in memory for a defined timeout period (or any other undocumented timeout period other than possibly applicationtimeout) like session vars so each reference to a client var will cause a db write or read. That has to mean session vars, once set, are faster. I can see an app organized so that upon logIn client vars in storage are used to intialize the current session, then these values are moved into a session layer for speed with any subsequent client value assignments done only for the purpose of preserving values that need to persist past the end of the current session. I would appreciate any clarification of any of this thinking. (above is not meant to cover clustering issues and assumes no design inhibitions due to ram constraints) Client variables are kept in memory for the duration of the page request. They're retrieved from the repository for every subsequent page request (except when they're stored in cookies - there's no retrieval required then, since the browser simply returns them to the server). As for using Client variables for initialization of values, I'd argue that you'd be better off retrieving values from a normalized database structure (where they usually are anyway for most applications) to populate Session variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
One thing though...there is a severe lack of GOOD CF developers in the UK. It's amazing the number of people that attempt to blag it. If I interview, I use a simple questionaire that I walk through with the potential...sometimes it really is quite embarrassing. I have to agree with this. There are lots and lots and lots of developers who try to blag it. I have come across many of them and worked for some. I have worked with developers who have come from HTML (and maybe a little Javascript), and think that doing the Allaire FastTrack to ColdFusion course (ie not the advanced course) means know ColdFusion back to front. WRONG!!! They also don't know anything about mailing lists and the community of developers which in the Unix/Linux (esp. OpenSource) world is understood and used to it's full potential. It really does amaze me sometimes how incredibly naive some people are! IMHO the most important thing is to know why you do something and what is happening in the background (something a *nix person would have a massive headstart on). An example would be the CFHTTP tag. Not understanding HTTP and it's little intricacies can catch out some normal programmers, but as CF is such an abstracted language (ie it simplifies everything) - sometimes to abstracted - some programmers can get caught out. Works well most of the time, but can be a right (insert favourite expletive here) to debug if you don't understand what's actually going on. Paul PS A potential developer questionnaire like that could well catch out a lot of people. PPS Most *nix people love to do everything from the ground up. I don't advocate this but I do think it is useful to be able to understand why things are done in certain ways. If it's already built, use that and modify it. Programmers who are keen to build programmes from the ground up all the time waste huge amounts of time (IMHO) however, it can be very useful in the long run. Adam -Original Message- From: Paul Johnston [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:00 AM To: CF-Talk Subject:RE: Slightly OT: CF in Europe Lets put it this way. I have been doing web development work since coming out of the University of Bath (for all you Americans, it's an old Roman City in England that has Roman Bath's in it hence the name) not too many years ago. Since then I have done HTML then Perl, then CF. As far as I'm concerned the lack of penetration in CF means that there are not too many developers out there (although this is increasing). The jobs are there (if you look in the right places and are good enough) but such is the perceived value of ASP in the development market that you would find it easier to get an ASP job (and for that matter a PHP job if you have the skills). However the financial implications of this here are huge! Financially it's good to be a CF programmer in the UK - especially a good one. It's even better to be a Spectra programmer (doesn't really matter how good yet as long as you've done the course or have experience). Don't be put off that CF hasn't penetrated the market yet. I firmly believe that it could (no guarantees), but the worst thing that could happen is that the CF programmers move away from CF! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Xml and SQL?
It has to be said, that if you want to get into XML, go and have a look at the Siteobjects tags http://www.siteobjects.com It's an excellent starting point. Paul -Original Message- From: Gilles Ratté [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 3:54 PM To: CF-Talk Subject: Re: Xml and SQL? I would be very interested the see some cold fusion code samples. Thanks - Original Message - From: "Neil Giarratana" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 05, 2001 8:10 AM Subject: RE: Xml and SQL? Not sure where (if anywhere) you are with the process. My first suggestion would be to take a look at the xmldom COM object from Microsoft. It will allow you to walk the XML document and/or search out and loop through desired nodes. The good news is that any machine installed with IE5 already has the XMLDOM installed so it's fairly easy to find and use. I can send you some code snippets of using the XMLDOM with Cold Fusion if you need. Regards, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom Tag for creating Forms...
Well, I am enjoying reading your responses. It's very good to get some kind of feedback (I'll have a look at databaseblocks but I haven't a clue what it is!). The thing I am working on now is to use the database to hold certain information, and to let HTML default as much as possible. So (using a CF structure as a v. simple db): !--- create the form structure --- cfset tpform = StructNew() !--- insert name field --- cfset tpform.name = StructNew() cfset tpform.name.position = 1 cfset tpform.name.type = "text" This code would say "Put a text field with the title "Name" (defaults to name of structure key) into the form with name "tpform". Let HTML handle the defaults (ie size = 40) or give preset defaults that can be changed, and the output is: table form... tr tdName/td tdinput type="text" name="name"/td /tr tr td colspan="2"input type="submit"/td /tr /form /table Simple form with a submit button by default etc... ! May even be sensible to default all the possible attributes to something and allow the defaults to be created by the user! Then if you add any more structure keys to the structure "tpform.name" (ie like tpform.name.value) it will insert this to the form as an attribute to that field. Works well for type="text" and type="dropdown" (ie select) and haven't got much further. waffle Of course, you can extract the data from a DB or from XML and put it into a structure format to output the form and then you have a form stored in a database. If you also allow the user to create the table the form goes in... /waffle Don't want to go into detail, but what you can see is that you can produce a very flexible HTML form system that can be created on the fly from a database (and therefore produced from a webpage so that a client can create their own form...) Anyway, tell me what you think! Paul PS The bare bones are there for this, I just haven't uploaded the files anywhere yet! -Original Message- From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 8:22 PM To: CF-Talk Subject: Re: Custom Tag for creating Forms... Take a look at DatabaseBlocks, guys! Download the new Beta we just uploaded early this morning, not the commercial release (some bugs). Enjoy! At 03:36 PM 1/3/01 +, you wrote: This may sound a little bit odd, but I am surprised that I can't find such a tool. --SNIP!-- Respectfully, Adam Phillip Churvis Productivity Enhancement, Inc. Publishers of the CommerceBlocks line of modular ColdFusion development tools Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: Allaire Developer Certification
Erm, has anyone noticed who isn't certified? It's much more fun than looking at people that are! Paul PS I don't think we should necessarily post their names here though... should we? PPS I know I'm not certified! I haven't had the time yet! -Original Message- From: Scott Wolf [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 1:56 PM To: CF-Talk Subject: RE: Slightly OT: Allaire Developer Certification There's an alphabetical list of Certified CF Developers at: http://www.allaire.com/Handlers/index.cfm?ID=16642 Just click on the first letter of the last name and find your person. :P Scott Wolf Goodfriend Computer Training -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 9:24 AM To: CF-Talk Subject: Re: Slightly OT: Allaire Developer Certification You could also ask for the validation number off their grade sheet and confirm that at www.vue.com - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 04, 2001 5:03 AM Subject: RE: Slightly OT: Allaire Developer Certification To all Allaire Certified Developers: If you came to me and told me you were Allaire certified, how would I verify that you really are? I cannot find anything on Allaire's site related to certification. If there's something on Allaire's site for me to read, please give me a link. Thanks! Or you could ask to see the certificate - mine sits behind me on the wall g Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom Tag for creating Forms...
Good point! So if I can allow the user to specify a style sheet, then a lot more comes from it. A couple of problems I am having with it: 1) I don't know what format the user wants for the form (ie is it in a table or not) 2) I can't really say exactly what the defaults should be without a style sheet Although this one could be tackled by telling the user to specify a style for the form and then parsing the data first. This has brought a lot of questions up. The Browser generally uses a style sheet to display the data and most people can't be bothered to change the default style sheet much. Style sheets effectively say what the defaults are (specified by the developer) for the given HTML. Effectively all this kind of system for producing forms would then do is create a table with a form and a specific style sheet. Not saving much time in my view. Development has ceased on this for a while. I may come back to it later. Paul -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 4:05 PM To: CF-Talk Subject: RE: Custom Tag for creating Forms... It would be helpful to allow as much of the formatting as possible to be defined by Style Sheets to make the forms customizable. At 12:30 PM 1/4/01 +, Paul Johnston wrote: Well, I am enjoying reading your responses. It's very good to get some kind of feedback (I'll have a look at databaseblocks but I haven't a clue what it is!). The thing I am working on now is to use the database to hold certain information, and to let HTML default as much as possible. So (using a CF structure as a v. simple db): !--- create the form structure --- cfset tpform = StructNew() !--- insert name field --- cfset tpform.name = StructNew() cfset tpform.name.position = 1 cfset tpform.name.type = "text" This code would say "Put a text field with the title "Name" (defaults to name of structure key) into the form with name "tpform". Let HTML handle the defaults (ie size = 40) or give preset defaults that can be changed, and the output is: table form... tr tdName/td tdinput type="text" name="name"/td /tr tr td colspan="2"input type="submit"/td /tr /form /table Simple form with a submit button by default etc... ! May even be sensible to default all the possible attributes to something and allow the defaults to be created by the user! Then if you add any more structure keys to the structure "tpform.name" (ie like tpform.name.value) it will insert this to the form as an attribute to that field. Works well for type="text" and type="dropdown" (ie select) and haven't got much further. waffle Of course, you can extract the data from a DB or from XML and put it into a structure format to output the form and then you have a form stored in a database. If you also allow the user to create the table the form goes in... /waffle Don't want to go into detail, but what you can see is that you can produce a very flexible HTML form system that can be created on the fly from a database (and therefore produced from a webpage so that a client can create their own form...) Anyway, tell me what you think! Paul PS The bare bones are there for this, I just haven't uploaded the files anywhere yet! -Original Message- From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 8:22 PM To: CF-Talk Subject: Re: Custom Tag for creating Forms... Take a look at DatabaseBlocks, guys! Download the new Beta we just uploaded early this morning, not the commercial release (some bugs). Enjoy! At 03:36 PM 1/3/01 +, you wrote: This may sound a little bit odd, but I am surprised that I can't find such a tool. --SNIP!-- Respectfully, Adam Phillip Churvis Productivity Enhancement, Inc. Publishers of the CommerceBlocks line of modular ColdFusion development tools Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
session and clients
I have just started working on a spectra client site, that has been written using session variables in several major places. Unfortunately this is to be a clustered site, so we need to move to client variables. The actual changing of the code is fine (ie session. to client.) but there are still some session variables out there that appear to be necessary. Can the two co-exist? I can't remember ever needing to do it? There is also one client variable that we seem to be unable to change the value of. It doesn't appear to be written at any point, and we are unable to delete it. Am I right in thinking that StructDelete() should work (because it hasn't yet), or what? Is this another problem with the sessions? Code: in application.cfm: cfa_applicationInitialize name="PL_Something" mode="#variables.mode#" setClientCookies="YES" clientManagement="YES" clientStorage="clientData" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT=#CreateTimeSpan(0,1,0,0)# cfparam name="client.pagechannel" default="" cfparam name="client.thepageID" default="" cfparam name="client.outpage" default="" cfparam name="session.editMode" default="" Anything wrong here (I didn't write it I just turned up!). In advance - thanks! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom Tag for creating Forms...
This may sound a little bit odd, but I am surprised that I can't find such a tool. At the moment I am in development of a custom tag that will take a CF structure, and create a form from it. Nothing new, except that I intend to give the user control of the output to as great an extent as possible. I have seen custom tags that you can put in fieldnames, and out comes a terrible form (ie no possibility of adding classes field names, or the table is formatted badly). I have also seen custom tags that use a database to hold lots of information and you can do surveys and statistics and everything like that. There isn't a "Take a structure and make a form" kind of tag. The only reason I feel this could be important is that it takes out another bit of UI from the programmer (a bit like using XML) and gives it more to the designed. In other words, you pass in a structure and you get out the form. The other reason it's important is that if you want 40 different forms all emailed to the same place (which is why I'm making it), you can create these forms on the fly and change them all at once (ie if you need to add in a field to every one of them). What do you think? Anyone done this? Do I make sense? Is it just to late in the day (in the UK) and I didn't get enough sleep last night or what? Paul PS I know you can create dynamic forms in various ways. The whole point of this is to provide a common interface (ie a CF structure) to a decent "Form Creator" type of tag. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
URGENT: Not OT: SQL Server Problems...
Guys, We have a SQL Server 7 implementation with three CF servers using it as a database server. The problem is that it's falling over regularly (and the technical guys can't figure it out). That's not the problem though. We are now setting up a second SQL Server 7 for use as a failover. It will replicate all of the data. My boss wants to know if it is possible for CF to use one or other of the database servers depending on what is up! So the idea is: For each query - check which server is up and choose one to use (assuming we can replicate all data) This doesn't make very much sense to me (it's not my idea, I just got asked to ask the list) as I would do it differently anyway! So situation (again) 2 SQL servers Q: can we replicate the data so they effectively are the same? 2 CF Server Q: without having to change EVERY cfquery can we make something that will use one or other to retrieve data depending on which one is up. Is this possible? Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Timeout Indicator
I am sure there is a way that has been talked about, but the way I would do it (off the top of my head) is to use javascript to output a message box just before (30 seconds say) the session expires (nothing back to the server) saying "Your session is about to expire. Continue?" that when clicked would open up a pop-up window that says "Thank you" and then the pop-up window closes itself. The opening of the pop-up window keeps the session open. If the message box is clicked after the 30 seconds or however long it is, then the window comes up saying "Your session expired" and anything else you want to say and you can lob the user back to the login screen. Paul -Original Message- From: MIKE GEORGE [mailto:[EMAIL PROTECTED]] Sent: 14 December 2000 11:56 To: CF-Talk Subject: Session Timeout Indicator I have read somewhere (dont remember where) about how you can notify a user that their session is about to expire and let them say whether they want to continue or not. This prevents the user from getting timed if they are completing a page with a long form on it. Can someone please point me in the right direction? Thanks Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: new cf version
Yes it would be useful to know a bit of Java, but I would not go as far to say beneficial. What Jeremy Allaire said in his speech to the UKCFUG last week is that we (CF programmers) will not need to know Java to use Neo (the Java based CF server as opposed to CF5 which will still be CF based). The advantage of Neo is that it compiles the CFML pages into Java Bytecode and then runs the bytecode - the pages are quicker than the C++ CF5 version which uses Just In Time Compilation (after compilation which can take a while!). As far as "flavor" (or flavour if we are using proper spelling) of Java goes, just make sure it's the Sun version of Java (http://java.sun.com) and not some M$ or other version that doesn't comply to the J2EE standard. I do not see it as important that you should know Java though. CF5 and Neo will have CF custom functions which will make everyone's life a lot easier. Paul -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2000 21:05 To: CF-Talk Subject: RE: new cf version True... true, but I had heard that being java based knowing some flavor of java may be very beneficial...??? yes/no? thanks! je -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 10:17 AM To: CF-Talk Subject: RE: new cf version no preperation necessary at this point.. the CFML language is going to remain the same as it is now, with enhancements and new featuresjust as you'd expect from any new version release. ~Simon Simon Horwith Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 11:00 AM To: CF-Talk Subject: new cf version The new cf version is on the horizon and is to have java as a backed if I understand correctly... anyone recommend a starting point to prepare for this new version and all it may offer? A particular language, books, references... anything at all would be extremely helpful! Thank you, Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Summary: A CF limitation in building a spider?
cf_rant I still come back to my point (see the summary). CF is not the correct tool to build a spider. It's oriented for web applications and effectively parsing and inserting HTML/WAP/A.N.other text (although CF5 will probably change all that). For spiders, using it for anything other than a simple spider is not sensible at all. Look out the Java spiders (or better still write one!). It's really not that difficult to see how you can extend CF using Java to do this. Of course you can use cfschedule to stop crashing and infinite loops. Still, when you build an http spider, it should be very quick indeed. The process should be: 1: send out an http request for the url 2: receive information (ie error message or text) back from the server 3: parse the text to get all info needed and put into an array 4: start the process again with the next url Doing this in CF takes up time and CF's resources that it doesn't need to take up. Leave it to some other tool to handle outside the "web serving" environment. Bear in mind that CF's Regular Expressions are not the best, and as far as parsing text goes, there are much better languages to parse text in. CF should not handle too much text parsing. /cf_rant Paul -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 06 December 2000 11:07 To: CF-Talk Subject: RE: Summary: A CF limitation in building a spider? depends on the settings in cfadmin - you can set pages to time out after so many min/sec to prevent the server from ccrashing on infinite loops. (bad programming) : -Original Message- : From: Bruce Heerssen [mailto:[EMAIL PROTECTED]] : Sent: 05 December 2000 23:43 : To: CF-Talk : Subject: RE: Summary: A CF limitation in building a spider? : : : Does anyone know if a template will timeout if called from : the command line (eg : as a sceduled task). I'm thinking that it will only timeout : when called from the : browser, and then only because the browser stops waiting. : Can someone confirm or : deny this? : : Thanks : : -- Bruce : : -Original Message- : From: Phill Gibson [mailto:[EMAIL PROTECTED]] : : !-- snip -- : I will probably also eventually put the CFHTTP one to : work with cfschedule. : : : Phill Gibson : Velawebs Web Designs : www.Velawebs.com : [EMAIL PROTECTED] : : : : ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: MYSQL
go and have a look at the tag gallery. There's a new custom tag to help connect mysql database to CF. Search on mysql. Paul -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 06 December 2000 11:42 To: CF-Talk Subject: RE: OT: MYSQL Anybody have experience with this DB? In particular I'm attempting to insert a new item into a table and retrieve the item_id which is defined as an autonumber. Is there a way of getting this information in MySQL. The other option is to create a id table and create a next_id function, but as MySQL does not support database transactions and I'm unfamiliar with the intracacies of MySQL, I'm curious what people do. I had considered using the LOCK command, but I'd prefer an atomic action, rather than locking of the table in such a fashion. Best Regards, Adam Reynolds ColdFusion Web Developer ISMG Development, Unilever London ( +44 20 7822 x5450 m: +44 7973 386620 * [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing XML content back as XML
Doug, WDDX does not answer the question. What you want to use is CFCONTENT. example: cfcontent type="text/xml"?xml version="1.0"? html head titleThis is a title/title /head body h1Hello/h1 /body /html Paul -Original Message- From: Doug Powell [mailto:[EMAIL PROTECTED]] Sent: 06 December 2000 13:53 To: CF-Talk Subject: RE: Passing XML content back as XML WDDX -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 6:51 AM To: CF-Talk Subject: Passing XML content back as XML is there anyway in cf to pass am xml packet back, so that the browser knows it is XML? I assume its somthing to do with mime types an CFCONTENT? Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-based management-tool for a great number of web-sites
Had this conversation several times on the cf-server list. FYI You can put CF on an Intel/AMD based machine, but not a MIPS based machine (ie not a cube). Therefore Cobalt RaQ's are possible CF hosts (and there are some good RaQ hosting services out there)! Paul -Original Message- From: John Foulds [mailto:[EMAIL PROTECTED]] Sent: 15 September 1999 05:09 To: CF-Talk Subject: Re: CF-based management-tool for a great number of web-sites Has anyone put CF-Linux on a cobalt cube? - Original Message - From: "John McKown" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 27, 2000 12:50 AM Subject: RE: CF-based management-tool for a great number of web-sites Isn't that what a Cobalt server is for? ;) John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 eMail: [EMAIL PROTECTED] Phone: 302-736-5515 Fax: 302-736-5945 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 26, 2000 3:26 PM To: CF-Talk Subject: CF-based management-tool for a great number of web-sites Hi list, a company called Trident Inc. ( www.trident.net ) has got a neat product. It is called Domain Master. (At least it sounds nice on their Web-Site) It is based on ColdFusion. They write: --- We have designed Domain Master to ease the burden of Web site management for Internet Service Providers, Commerce Service Providers, Associations or Organizations with multiple web sites. Domain Master enables these organizations to manage their eCommerce storefronts, their customers' web sites, the e-mail accounts, web statistics and web accounting from any location in the world using a simple web browser. If Trident's OSM eCommerce software is purchased with Domain Master, it establishes a totally integrated eCommerce hosting operation. Does anybody know this product ? I sent them out an E-Mail two weeks ago and asked for an eval-copy but didn't get any answer. Does someone know of any other products doing the same ? Thank you. Uwe Mail: [EMAIL PROTECTED] WWW: www.sdsolutions.de ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Caching CFHTTP results
How about storing the cfhttp.filecontent variable in a database (which you can cache the query on) or in a server variable or something? Then you can just overwrite it whenever you want and it's always there! Paul -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: 15 November 2000 22:06 To: CF-Talk Subject: Caching CFHTTP results I would like to use CFHTTP to pull an HTML page from one server to another (we own both servers ... one Unix, the other NT -- I'm pulling from the NT to the Unix -- too complicated to explain why.) and have the output cached so that we cut down on the number of actual requests passing from the Unix server to the NT. We really need to cut the load to the NT. As far as I can tell, using cfcache at the top of my cfhttp page doesn't do the trick. What happens is that if the NT is overloaded with requests, this page outputs a "connection failure" error. I thought if I could cache a good clean output then the page would then display the output on the Unix box even if the NT isn't responding. This isn't happening. Any suggestions? H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: A CF limitation in building a spider?
I have to agree completely. Using CF as a spider is really not very sensible. If I was suggesting a way to do this, I would use cfexecute with some program that can dump results to a text file which CF can then use. There is no point in using up CF's resources on something it's not really designed for. Until we get custom functions (which we all hope will be in CF 5) then we can't really do recursion very easily. This is because calling a custom tag (even though it's 'cached' by the CF server) is effectively calling a file and if it's more than one file in size, it is an absolute nightmare scenario as far as load on the file system goes. As for using it as a spider, I seriously wouldn't. My suggestion: Get a C++/Perl/Java spider from somewhere (there are lots out there) that you can set running that dumps all the data you need (maybe in a WDDX packet) to a text file. Paul PS Did a search on google for "web spider" and got this immediately: http://www.tardis.ed.ac.uk/~skx/java/Spider/ . It may be awful, but it goes to show there are lots out there. -Original Message- From: Paul Mone [mailto:[EMAIL PROTECTED]] Sent: 15 November 2000 08:40 To: CF-Talk Subject: RE: A CF limitation in building a spider? I don't think that CF is the right tool for this task. In my eyes, this falls under the category of 'offline processing', meaning that you're not giving a user instant feedback or up to the moment data according to the user's input. Instead, you're assembling data that will be indexed and used by some seperate process that interacts directly with the user. My experience with CFHTTP has led me to use it sparingly. When it was being called frequently (as well a recursively) I found it to be a real server-hog, and occasinally it made CFServer crash. This may have been resolved with the latest releases of 4.5.1. This task is going to be doing alot of recursive calls and alot of file parsing. If possible, you might want to do something like this in Java. I think you will get much better performance. -Original Message- From: Phill Gibson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 9:54 AM To: CF-Talk Cc: Phill Gibson (E-mail) Subject: A CF limitation in building a spider? Hi All, I'm putting together a spider to be used with a search engine, and have come up to what looks like a limitation in using CF for the task. Here's what's going on: I'm using cfhttp to extract links from specific sites. It loops through, collecting all hyperlinks that are within the site and adds them to a list to be visited. In visiting/indexing these links, however, it is still looping through only in one CF page, hence it times out (set to about ten minutes on our server). This won't do it if I'm indexing a site of several hundred pages. Does anyone know of a better way to do the recursive call to cfhttp? Anyway I see it, you are still calling one page, and it eventually times out. Thanks for any ideas! Phill Gibson [EMAIL PROTECTED] Velawebs Web Design www.Velawebs.com -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: 2 instances of Studio
Does anybody know how I can I have two CF Studio Windows open at the same time? I'd love to take advantage of my duel monitor setup. Thanks! so is it guns or swords? ;-) Paul PS I don't know how to have two up! Would be nice to be able to split screens over two files though! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Netscape 6 out UGH!!!!
Has anyone noticed that when downloading netscape from IE (I know it seems a bit wierd), it says: - You are currently using Internet Explorer 5.5 There is an upgrade available Netscape 6 Download Now - Hmm... Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 November 2000 15:34 To: CF-Talk Subject: Re: Netscape 6 out UGH - Original Message - From: "Scott, Andrew" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, November 14, 2000 10:42 PM Subject: RE: Netscape 6 out UGH Correct me if I am wrong, but mozilla being the very first offical browser. Has set the standard others have to face and is where the w3c use to filter the standards across the board. I think you mean Mosaic, which was one of the first browsers (anyone remember Cello?), Mosaic was free but was customised and improved by several companies including spyglass whose browser later became MS Internet Explorer. Mosaic was programmed by Marc Andresson (sp?) who later became a founder of Netscape, when the Netscape browser went open source the working/code title of the new browser was Mozilla - this is also known as Netscape 6 although anybody can use the rendering engine to build their own browser. As far as Netscape 6 having JavaScript problems, they are almost certainly caused by code which doesn't conform to standards, it is supposed to be the most standards compliant browser ever - although until all the reviews and tests are done I will reserve judgement ;) -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Another: Send HTML email through CFMAIL
Of course, you could always write a frameset that calls in the relevant page (just like a load of companies do - mp3.com is an example). This would mean you could send both a frames and a non-frames version and a link at the top for those with just text based email readers! Just my two pennyworth (being English and all!) Paul -Original Message- From: Aaron Johnson [mailto:[EMAIL PROTECTED]] Sent: 10 November 2000 21:36 To: CF-Talk Subject: RE: Another: Send HTML email through CFMAIL Do a cfhttp url="somesite" method="GET" resolveurl="true" and then in your cfmail reference #cfhttp.filecontent# AJ -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Friday, November 10, 2000 4:18 PM To: CF-Talk Subject: Another: Send HTML email through CFMAIL If I want to embed one of my CF Page's output ENTIRELY in the CFMAIL, how would I reference it? Would I run a call to the page within the CFMAIL tag? Thanks ahead of time, Andrew From: "Daniel J O'Keefe" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Send HTML email through CFMAIL Date: Thu, 9 Nov 2000 13:09:23 -0500 TYPE="HTML" in the CFMAIL tag. Dan -Original Message- From: Hong [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 12:27 PM To: CF-Talk Subject: Send HTML email through CFMAIL Dear list, This is a simple question. I want to send a HTML page to a list of people in HTML format though CFMAIL, like the HTML newsletter we get from certain websites. How to do that? Any required parameters, attributes, etc. Thanks! Hong _ Do You Yahoo!? Get your free @yahoo.com address at ttp://mail.yahoo.com -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] - -- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: XML / XSL
Nice! I like it! Anyway, if you want a zip file with some basic (and I mean simple) examples of XML and XSL with speed testing then you can download them (if you're lucky) from: http://www.cfm-resources.com/c/cfdoc/downloads/xslstuff.zip These again use MSXMLDOM object. Please use them how you wish! Paul -Original Message- From: Gary Davidson [mailto:[EMAIL PROTECTED]] Sent: 09 November 2000 21:35 To: CF-Talk Subject: RE: XML / XSL This is the XSLT tag I wrote for the MS IIS platform and that I use, I am sure there is room for improvement. cfobject type="COM" name="objXMLdoc" class="microsoft.xmldom" action="CREATE" cfobject type="COM" name="objXSLdoc" class="microsoft.xmldom" action="CREATE" cfscript Err = 0 XMLdoc = attributes.xml; XSLdoc = attributes.xsl; objXMLdoc.ValidateOnParse = -1; objXSLdoc.ValidateOnParse = -1; objXMLdoc.load(XMLdoc); If (objXML.parseError.errorCode 0) Err = 1; objXSLdoc.load(XSLdoc); If (objXSL.parseError.errorCode 0) Err = Err + 2; switch(err) { case 0: { Caller.Results = objXMLdoc.transformNode(objXSLdoc); break; } case 1: { a = objXML.parseError.errorCode; b = objXML.parseError.reason; Caller.error = true; Caller.errorreason = "XML ERROR! Error Code " + a + " Description " + b; break; } case 2: { Caller.error = true; a = objXML.parseError.errorCode; b = objXML.parseError.reason; Caller.error = true; Caller.errorreason = "XSL ERROR! Error Code " + a + " Description " + b; break; } } //end switch /cfscript This is the calling page CF_XSLT XML="c:\inetpub\wwwroot\OnlineSalesReporting\sample.xml" XSL="c:\inetpub\wwwroot\OnlineSalesReporting\sample.xsl" cfoutput#XSLTResults#/cfoutput -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 1:36 PM To: CF-Talk Subject: RE: XML / XSL Good grief! That's a lot of errors! It would be nice if there was a custom tag that did the following: CF_XSLPROCESS XML = "[path]myfile.xml" XSL = "[path]myfile.xsl" VAR = "nameOfCFVariableToStoreResultIn" Then you could output the variable "nameOfCFVariableToStoreResultIn" to the user's browser. The Lotus version seems to be close to this but requires output to a file which means doing a file write and then a read as well as a delete for housekeeping purposes. That's very inefficient for page processing. Any suggestions? --Doug -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 4:17 AM To: [EMAIL PROTECTED] Subject: RE: XML / XSL To use Lotusxsl for transformations, the classpath in the CF Administrator needs to include full paths to these files: xalan.jar Lotusxsl.jar For instance: c:\lotusxsl\lotusxsl.jar;c:\lotusxsl\xalan.jar As Sean Renet pointed out awhile back, the KB article has some fatal errors. Here are the fixes you need to apply to get it working: 1. If you copy the example XSL file from the website, the xsl:stylesheet tag's xmlns:xsl attribute value is broken into 2 lines, causing the xsl processor to fail completely. Instead of doing the transformation, it just outputs the content of the original xsl file. The namespace needs to be in a continuous line, as follows: xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 2. The printWriter class isn't being closed, so the file containing the wddx isn't being flushed to disk. Add the following to the end of the code: cfset printWriter.close() 3. The resulting processed file isn't being read into a CF variable, so add: cffile action="read" file="[path]wddx_test.wddx" variable="wddx" 4. When you try to run cfwddx to transform the wddx to a structure, you'll get: Error Diagnostic Information unknown exception condition TagCFWddx::execute There is an error in the XSL file. The "item" element is being mapped to a named structure. Since it's a structure within an array, it can't take a name, causing the WDDX parser to fail. Here's the corrected XSL file: xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" !-- Match invoice root emit WDDX packet wrapper -- xsl:template match="/invoice" wddxPacket version="1.0" header/ data struct xsl:apply-templates/ /struct /data /wddxPacket /xsl:template !-- Process all elements that map to array variables -- xsl:template match="billableHours" var name="{name(.)}" array length="{count(*)}"
RE: HTTP PUSH
Okay, probably the easiest thing would be to use a frame of some sort. Either that, or use a javascript pop-up window to say "stuff's happening, hang on!" when the user goes to the page (not when they get there!) Maybe that's easiest, because you can give them something to do while they are waiting! Paul -Original Message- From: Cold Fusion [mailto:[EMAIL PROTECTED]] Sent: 10 November 2000 14:57 To: CF-Talk Cc: [EMAIL PROTECTED] Subject: RE: HTTP PUSH [EMAIL PROTECTED] writes: You will find that all CF pages are synchronous in their execution, in that the entire page must be pre-compiled to HTML before any content can be see by the client's browser. Thanks for the response Mike. There are numerous ways to optimize your CF code, who such way is to minimize the number of records returned in a query by using the BLOCKFACTOR option. You could switch on the debugging funcitons in your CF administrator to see exactly how long it takes your page to execute. This information will help you optimize the page loading speed. Actually, I don't have a code performance problem. (at least, not in this bit!!) In a nutshell - and unfortunately I can't go into detail here - part of my CF app goes to extract data from a (number of) remote server(s). The amount of data varies and so does the amount of time to get the data (no matter its size). The times can get quite long. In the most simple sense, I want the user on my site to get some feedback that things are still happening, not spinning balls and blank screens. Even if my site just steps thru a display which says "contacting remote server", "logging in", "starting data retrieval"... etc etc... Then I'd like to be able to 'stream' the data to them as it comes in, until it stops. That's kind of the objective in a few words. One additional reason for using PUSH is so that if the data set is then VERY large and/or slow, the user's browser will still cope with it's single connection to my site and NOT timeout, even after say ten minutes or more (don't ask!). CF not supporting push... kind of sucks a bit? It's a fairly standard HTTP feature which has been around for a long time. It has it's uses, albeit not that many... As a (describable!) PUSH example, for those of you with LAN/WAN/IP knowledge: the various web-based network tool sites (that do ping, traceroute etc so you can test IP connectivity) often use PUSH to return the current response step, so you can see what is happening as-it-happens. In the case of the traceroute example, a site not using push might, for example, report an error on a non-traceroutable destination, but NOT show you, or be able to show you, where in the trace it actually failed (depending on the developer!). I know of one specific example site like that (which shall remain nameless!) - suffice to say that when needed I now web traceroute from a site which uses PUSH... ;-) Regards, SB Scott Bartlett ([EMAIL PROTECTED]) BTA Limited 100 High Street Wandsworth London SW18 4LA United Kingdom Tel:020 8871 4240 Fax:020 8871 4584 http://www.bta.com Network Consultancy and Support for Windows 9x/NT and MacOS. Internet connectivity, solutions, and business services. This message is intended only for the use of the person(s) ("The intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by BTA. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF editing software - vote
I certainly agree that you'll find it's what most people are using. As to "everything else is inferior" the only things I find useful about CF Studio are the Help Files and the Tag/Function Completion. It crashes quite a bit and is not perfect. If there was a different, more stable editor out there with the ability to add in the tag completion and function completion stuff, I would consider switching to it. Paul PS Don't forget that loads of Perl/C/C++/Java programmers get on just fine using stuff like emacs and vi (and if you don't know what vi is then I don't think you know about editors IMHO)! PPS Personal preference CF Studio, but I use it only because I have to. If there was such a thing as tag completion in vi or vim, I'd switch immediately. -Original Message- From: Peter Alexandrou [mailto:[EMAIL PROTECTED]] Sent: 09 November 2000 13:56 To: CF-Talk Subject: Re: CF editing software - vote You'll find that the majority all user Cold Fusion Studio. Its the only thing to use as everything else is inferior. - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 09, 2000 10:56 PM Subject: CF editing software - vote Hi, I thought it would be interesting to see who's using what to develop their CF apps. I'm using HomeSite 4.5 happily here. Anyone? Cheers Will -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF editing software - vote
Good! It was meant to be tongue in cheek (that's an english expression meaning not serious for anyone who doesn't understand!)... ;-) Any macros or anything for CF that you know of? Paul -Original Message- From: Peter Alexandrou [mailto:[EMAIL PROTECTED]] Sent: 09 November 2000 14:19 To: CF-Talk Subject: Re: CF editing software - vote Of course I know what emacs and VI is! :-) I'm a Linux buff all the way but use Studio when developing in Cold Fusion. I use Cold Fusion Server on Linux these days so have been using VI quite a bit. - Original Message - From: "Paul Johnston" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 09, 2000 11:09 PM Subject: RE: CF editing software - vote I certainly agree that you'll find it's what most people are using. As to "everything else is inferior" the only things I find useful about CF Studio are the Help Files and the Tag/Function Completion. It crashes quite a bit and is not perfect. If there was a different, more stable editor out there with the ability to add in the tag completion and function completion stuff, I would consider switching to it. Paul PS Don't forget that loads of Perl/C/C++/Java programmers get on just fine using stuff like emacs and vi (and if you don't know what vi is then I don't think you know about editors IMHO)! PPS Personal preference CF Studio, but I use it only because I have to. If there was such a thing as tag completion in vi or vim, I'd switch immediately. -Original Message- From: Peter Alexandrou [mailto:[EMAIL PROTECTED]] Sent: 09 November 2000 13:56 To: CF-Talk Subject: Re: CF editing software - vote You'll find that the majority all user Cold Fusion Studio. Its the only thing to use as everything else is inferior. - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 09, 2000 10:56 PM Subject: CF editing software - vote Hi, I thought it would be interesting to see who's using what to develop their CF apps. I'm using HomeSite 4.5 happily here. Anyone? Cheers Will -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Passing PWs via URL bar
Jake, I would suggest using javascript to encrypt the pw string if you HAVE to pass it through the URL string (I am assuming here that it has been inputted in a text field and it can't be passed any other way). If you are only going to store the variable and don't need to know what the string is then I suggest one-way hashing with the MD5 algorithm. If you need to know the password string, then I suggest that you find some way of not passing it into the URL. Passing it through the HTTP header as a form variable would be more secure at the very least. Moral of story: do your best never to pass passwords through the URL string. Paul PS You can ensure that the user is using Javascript by writing a Javascript redirect to itself with an added URL string of js=yes and a timestamp of some sort so that CF can stop it if the user tries to hack into the page at a later time. If you want to know what I mean, email me off list. -Original Message- From: Jake Hileman - Patmos [mailto:[EMAIL PROTECTED]] Sent: 06 November 2000 16:06 To: CF-Talk Subject: Passing PWs via URL bar Any idea how I can encode/encrypt a pw to be passed via the URL bar? Encrypt and URLEncode don't play nice together. :-) Any ideas? jake -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Passing PWs via URL bar
Okay. I use IE. It has something called "inline autocomplete" for web addresses. Lets say someone else uses my machine. They could type in "http://www." and get all the urls beginning with "www." and then put in "a" then "b" then "c" etc... and at some point they would be able to see a url with a password in it! If the URL did not contain the password, they would not be able to see it. They may (and it's only may depending on coding) be able to see the page using the posted form contents. Lets say it was passed in the form variable. At the very least, this would stop a casual user being able to accidentally see "http://www.somewhere.com/admin/login.cfm?username=myuserpassword=mypass" That is why I used the term "at the very least". Lets just say that it is the least the programmer should do. Paul -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: 07 November 2000 12:34 To: CF-Talk Subject: RE: Passing PWs via URL bar "Passing it through the HTTP header as a form variable would be more secure at the very least." I wouldn't say so. If the value is passed either via URL or by form field the data is still plaintext and can be intercepted either way. Jake, I would suggest using javascript to encrypt the pw string if you HAVE to pass it through the URL string (I am assuming here that it has been inputted in a text field and it can't be passed any other way). If you are only going to store the variable and don't need to know what the string is then I suggest one-way hashing with the MD5 algorithm. If you need to know the password string, then I suggest that you find some way of not passing it into the URL. Passing it through the HTTP header as a form variable would be more secure at the very least. Moral of story: do your best never to pass passwords through the URL string. Paul PS You can ensure that the user is using Javascript by writing a Javascript redirect to itself with an added URL string of js=yes and a timestamp of some sort so that CF can stop it if the user tries to hack into the page at a later time. If you want to know what I mean, email me off list. -Original Message- From: Jake Hileman - Patmos [mailto:[EMAIL PROTECTED]] Sent: 06 November 2000 16:06 To: CF-Talk Subject: Passing PWs via URL bar Any idea how I can encode/encrypt a pw to be passed via the URL bar? Encrypt and URLEncode don't play nice together. :-) Any ideas? jake -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: about favico fusebox (?)
IE (to try and be clever) looks for a file called favicon.ico in the same directory as the page being browsed IF the user bookmarks that page. If they don't it won't search for the file. Just as an example in IE go to http://www.google.com and bookmark it. Then refresh the page. This will then change the little icon in the address bar (ie next to "http://") to the google icon. This is the favicon.ico file for google. It's not a problem. It's just Micros**t trying to make everybodies browsing experience more complete (or some such other marketing speak). Paul -Original Message- From: Juan Andres Alvarez Valenzuela [mailto:[EMAIL PROTECTED]] Sent: 06 November 2000 08:54 To: CF-Talk Subject: about favico fusebox (?) Hi, We have a problem with the "marvelous" Favico. I use a fusebox for change the URL to a friendly one. Recently, I noted a weird thing, I get many times this web request: http://mydomain.com/news/index.cfm/idnews/favicon.ico I don't know what is the problem with IE explorer. or it is my problem ? someone had the same problem ? thanks, ~Juandres -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Paranoid programming...
How about storing some of the information using a one way hash (ie MD5)? This can't be unencoded (or at least, it's pointless to try). This encrypts a string the same way each time, so if you have a password, you can put the same one in, and you always get the same result. The problem is that you need to get the information from somewhere, so it has to be stored somewhere secure. This has to be protected in some way, and either PGP encryption or one way hashing are the most effective ways of doing this. Having a SPARC (ie UNIX) is very useful because you can create a file with permissions for a certain user and group. Maybe you could hold all of the information (encrypted) in there. This can sit behind the webroot and therefore isn't accessible except via the file system. Maybe you could use a berkeley database to hold the information (access via Perl or something)? Permissions are definitely the way to go on this one. Make the file and directory it is in readable only by one user, and maybe use CFX_TCPClient to ssh into machine and read the file only it can read. The problem you have is that you cannot access the database except with the username and password. Maybe you could set up a system of temporary usernames and passwords in the database that only have extremely limited access to the database. These could then be used on a rolling basis (the user would never see them). IMPORTANT BIT - At some point you HAVE to pass in a username and password to CF otherwise database access is impossible. The issue IS NOT "how do I do this without storing them", but "how do I store the information without anyone else getting access?". Two ways of doing this. Store it encrypted in an uncommon encryption format (or use PGP or something) or store it in format that can only be accessed using a specific type of access (ie database, ssh, etc) or both of course. If someone is that desparate to hack into the database, it is unlikely that they will get the usernames and passwords from trawling around the site and finding a file that they reside in (make sure you don't name the file "thepasswords.encrypted" or something silly). The most likely form of hacking is through code exploits, so as long as you are careful in your coding, you won't have a problem. Enjoy! Paul -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: 02 November 2000 09:41 To: CF-Talk Subject: Paranoid programming... Okay - bear with me here folk! Imagine one has a database (for example Oracle) which requires a user id and password to access. Now, imagine writing an application to let joe user to look up and insert info into this table. HOWEVER, we do not want to generally publish the user id and password; we want the coldfusion app as the 'gateway' into the table. So far, so good. However, because of the gateway issue, hard coding the userid and password into the cfm files is out - the cfm files are in general accessible by someone browsing the directories. The database itself is sensitive enough that the owner does not want the userid and password put into the ColdFusion admin area either... If you had to write an app where the database userid and password: could not be hard coded, could not be put into the admin area, could not be entered via prompting what approach would you use? Putting it into a file - encrypted or not - doesn't work; the files are readable and so someone could just copy them and build their own 'pseudo' app that accesses the data, right? Looking for 'outside the box' possible solutions. If it helps, the platform for the server is SPARC Solaris. -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Paranoid programming...
This is not a secure solution (which is what I assume you are after). What is to stop someone malicious getting/intercepting the email? Sending a username and password over email is a hackers dream! You cannot pass any variables to anyone except the cold fusion server. There has to be some form of authentication to be able to insert into the database though. Paul -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: 02 November 2000 13:02 To: CF-Talk Subject: RE: Paranoid programming... Create a separate user/pass and authenticate through email? i.e. they supply a user/pass to get the db user/pass sent to them via email. -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 02, 2000 4:41 AM To: CF-Talk Subject: Paranoid programming... Okay - bear with me here folk! Imagine one has a database (for example Oracle) which requires a user id and password to access. Now, imagine writing an application to let joe user to look up and insert info into this table. HOWEVER, we do not want to generally publish the user id and password; we want the coldfusion app as the 'gateway' into the table. So far, so good. However, because of the gateway issue, hard coding the userid and password into the cfm files is out - the cfm files are in general accessible by someone browsing the directories. The database itself is sensitive enough that the owner does not want the userid and password put into the ColdFusion admin area either... If you had to write an app where the database userid and password: could not be hard coded, could not be put into the admin area, could not be entered via prompting what approach would you use? Putting it into a file - encrypted or not - doesn't work; the files are readable and so someone could just copy them and build their own 'pseudo' app that accesses the data, right? Looking for 'outside the box' possible solutions. If it helps, the platform for the server is SPARC Solaris. -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: generating random passwords for a db field
There are many ways to do it. There are custom tags to do it. Just to show how easy it is, here is a random password generator you can do what you want with: watch for the text wrapping! The textstring is one line. You can make this a custom tag if you want. -CF Code- !--- create this string with random values (make sure there are no string values you don't want --- !--- make it long so that you create randomised letters --- cfset textstring = "kljhw4+e-_5987s!df898+fs.gnOI$SUDFN!9A+87GFN_ASDF$!M09AYSFYA09S.$DF_PLAOQWO I=ZM$NXC$KJ=J!KURU=+TK-JSDHGFJ-UYATWBlkajsdf098a0984ngagsalkj0923845jknlvmap sd98rqpo32$!sldfkj87." !--- set password to nothing --- cfset pw = "" !--- randomize the random number generator (this extra bit really randomizes it) --- cfset temp = Randomize(Right(GetTickCount()*57,6)) !--- create a string of between 8 and 12 characters --- cfloop from="1" to="#RandRange(8,12)#" index="i" cfset pw = pw Mid(textstring, RandRange(1, len(textstring)), 1) /cfloop !--- output password --- cfoutput#pw#/cfoutput -CF Code- Paul -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: 02 November 2000 13:59 To: CF-Talk Subject: generating random passwords for a db field What is the BEST way to generate random passwords to populate an existing field in a db. I tried using the RandRange(1, 1) function to do this but wound up generating the same random number for every record instead of a different random number for every record. The passwords generated do not nec. have to be a number, it could be alphanumeric. TIA Shane Witbeck -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Project documentation
I have done a presentation to the UK CFUG on "Documentation in Cold Fusion" which describes some issues around documenting code (specifically), but people have said that it's useful for project management issues and the like. If you want to take a look, check these links out (copy of message sent to UK CFUG): ---copied message--- In case some of you weren't there Thursday night , here is the presentation I did on "Documentation in Cold Fusion". http://www.cfm-resources.com/c/cfdoc/presentation.zip and further to a half discussion that came out of the night, here are some pre-alpha vtom scripts for cfstudio which you can use with cfdoc: http://www.cfm-resources.com/c/cfdoc/cfdoc-vtom.zip Please tell me if you make any revisions. I don't mind you hacking just so long as I know about it. If you want the cfdoc browser please download it from: http://www.cfm-resources.com/c/cfdoc/cfdoc-v0.03.zip all of the downloads are small, so even a 56K modem shouldn't have a problem (although cfm-resources might have some problems). I hope you enjoy this! Paul PS It only implements a bit of the cfdoc thang, but I hope you can see where it's going. PPS If anyone has more experience with VTOM etc, then I would be eternally grateful. I can't work out how to make functions work in it. ---copied message--- -Original Message- From: Roger Lim [mailto:[EMAIL PROTECTED]] Sent: 31 October 2000 01:26 To: CF-Talk Subject: Project documentation Hi, Anyone has any idea where can I find examples or format on how to go about doing documentation for web projects? Documentation like Database Design, Site Design, Test Script, etc? Thanks, roger -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Capitalize First Letter of Each Word
Neither does mine! And please note I commented it, so it looks long but is actually only a few lines! Paul -Original Message- From: Jeff Bevill [mailto:[EMAIL PROTECTED]] Sent: 27 October 2000 09:32 To: CF-Talk Subject: RE: Capitalize First Letter of Each Word Rich, My "over complicated" code below (l33t w3rd fixer v1.0) doesn't fail on 1 character. For some reason I still have KR style programming habits, heh. Jeff Bevill -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 2:10 AM To: CF-Talk Subject: RE: Capitalize First Letter of Each Word Steve, This code dies if single letter words are present in the string eg "i". Parameter 2 of function Right which is now "0" must be a positive integer, as CF so succinctly puts it. Added this: cfset newword="" cfloop index="word" list="#stringvar#" delimiters=" " cfif Len(word) eq 1 cfset newword=ListAppend(newword, UCase(word), " ") cfelse cfset newword=ListAppend(newword, UCase(Left(word, 1)) Right(word, Len(word)-1), " ") /cfif /cfloop And then, as cf_capitalize found - what about surnames Celtic stylee eg " O'Connolly ". cfset newword="" cfloop index="word" list="#stringvar#" delimiters=" " cfif Len(word) eq 1 cfset newword=ListAppend(newword, UCase(word), " ") cfelseif Find(Chr(39), word) cfset newword=ListAppend(newword, UCase(Left(word, 3)) Right(word, Len(word)-3), " ") cfelse cfset newword=ListAppend(newword, UCase(Left(word, 1)) Right(word, Len(word)-1), " ") /cfif /cfloop --- 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: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 5:32 PM To: CF-Talk Subject: RE: Capitalize First Letter of Each Word Or: cfset variable="Some text to convert here" cfset newword="" cfloop list="#variable# index=word delimiter=" " cfset newword=ListAppend(newword, UCase(Left(word, 1)) Right(word, Len(word)-1), " ") /cfloop Steve -Original Message- From: Jeff Bevill [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 14:50 To: CF-Talk Subject: RE: Capitalize First Letter of Each Word John McKown, Here ya go man. I only had about 10 mins to write this, hope it works. :) !--- l33t w3rd fixer v1.0 --- !--- Jeff Bevill - [EMAIL PROTECTED] --- cfset Variable="UnBeLiEvAbLe" cfif isDefined("Variable") and Len(Variable) GT 0 cfset in="1" cfset out="0" cfset word_state=out cfset NewStr="" cfset is_space=false cfloop index=i from=1 to=#Len(Variable)# cfset Character=Mid(Variable, i, 1) cfif Character is " " cfset word_state=out cfset NewStr=NewStr Character cfelseif Asc(Character) GE Asc("a") and Asc(Character) LE Asc("z") and word_state EQ out cfset word_state=in cfset NewStr=NewStr UCase(Character) cfelseif Asc(Character) GE Asc("A") and Asc(Character) LE Asc("Z") and word_state EQ in cfset NewStr=NewStr LCase(Character) cfelse cfset word_state=in cfset NewStr=NewStr Character /cfif /cfloop cfset Variable=NewStr /cfif cfoutput#Variable#/cfoutput Jeff Bevill -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 6:35 AM To: CF-Talk Subject: Capitalize First Letter of Each Word Can someone share a script that will capitalize the first letter of every word entered into a form field? John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE
RE: Custom Tag w/JS functions
bear in mind that no cfcode within script/script tags will get processed. To get round this, put the code into a page, and then cfinclude the code in between to script/script tags: script cfinclude template="mytemplate.cfm" /script script cf_mytemplate /script Enjoy Paul -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: 25 October 2000 06:55 To: CF-Talk Subject: Custom Tag w/JS functions I'm writing a plain CF Custom Tag which also contains some JavaScript functions. I'm thinking of using CFHTMLHEAD to write the JS functions into the calling document's head. Any opinions as to where to write the JS functions? * At whatever point the tag is called * In the head via CFHTMLHEAD * Other? Thanks. -David YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Custom Tag w/JS functions
Do you know something, you're right. I did some code a while back and I couldn't get CF to do what I wanted in the javascript. It makes sense that you should be able to. I can't remember exactly what it is (I left that job) but I do remember that it didn't work. Oh well, I look stupid! Thanks Paul -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: 26 October 2000 13:25 To: CF-Talk Subject: Re: Custom Tag w/JS functions on 10/26/00 10:15 PM, Paul Johnston at [EMAIL PROTECTED] wrote: bear in mind that no cfcode within script/script tags will get processed. Hmmm. Works fine for me, always has... -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Calling custom tags from within CFSCRIPT?
You can't call custom tags from within CFSCRIPT which I think is utterly stupid. Call to Allaire: Make a function called Tag() with this syntax: Tag(tagname, attribute list); ie For CFOBJECT TYPE="COM" ACTION="action" CLASS="program_ID" NAME="text" CONTEXT="context" SERVER="server_name" Tag(cfobject, action, program_id, text, context, server_name); And then for cfmodule (or whatever) where you may need an endtag you have Tag(cfmodule, filename); EndTag(cfmodule); Anyway, just wanted to lob that one in! It means you could create custom functions by creating custom tags and calling them! Hooray! Paul -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: 26 October 2000 14:07 To: CF-Talk Subject: Calling custom tags from within CFSCRIPT? CFSCRIPT is generally faster than a bunch of tags, right? So I'm trying to use that when possible. But can you call custom tags from within CFSCRIPT? I didn't see any mention of it in my books. Seems like something you should be able to do, doesn't it? Ryan -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: GUUID? - The only reply that needs to happen
Oh, let me see... Tough one... Oh! Have you tried putting apostophes round the variable (it being a varchar and all!)? Paul PS Expect about 20 more replies like this one! -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: 26 October 2000 14:29 To: CF-Talk Subject: GUUID? Okay, strange behaviour with a GUUID in a WHERE clause. I have a GUUID (varname = url.ObjectID) : BBD17F3C-9ED3-11D4-845B00E0293D68BB which is in a SQLServer 7 table with varchar as a type - length 50 (it is trimmed on return, though not needed) In my CFQUERY I have thus : SELECT * FROMObjects WHERE ObjectID = #Trim(url.ObjectID)# when it runs, I get this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near 'D3'. anyone? It is probably staring me in the face - like a data type is wrong or an apostrophe missing here and there, but I can't see it. Neil ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Capitalize First Letter of Each Word
Either that or... -- !--- Sentence Capitaliser --- !--- Paul Johnston --- !--- to capitalise all words in a sentence --- cfset Variable="YoUr UnBeLiEvAbLe" cfoutputbr#Variable#/cfoutputbr !--- put the sentence into an array (convert from a list of space delimited words) --- cfset text = ListToArray(variable, " ") !--- create new array to hold all changed words --- cfset new_text = ArrayNew(1) !--- loop over the array (each word) --- cfloop from="1" to="#ArrayLen(text)#" index="i" !--- get length of variable --- cfset length = len(text[i]) !--- put first letter as capital into variable --- cfset first_letter = UCase(Left(text[i],1)) !--- if length of word is greater than one (it could be "A"), then lower case the rest --- cfif length gt 1 !--- find length of rest of word --- cfset rest_length = length - 1 !--- lower case it --- cfset rest = Lcase(Right(text[i],rest_length)) /cfif !--- set new_text to the changed word --- cfset new_text[i] = first_letter rest /cfloop !--- loop over new array and output --- cfloop from="1" to="#ArrayLen(new_text)#" index="j" cfoutput#new_text[j]#/cfoutput /cfloop -- The loop is unnecessary for only one word, but this will capitalise ALL words in one sentence. Paul -Original Message- From: Jeff Bevill [mailto:[EMAIL PROTECTED]] Sent: 26 October 2000 14:50 To: CF-Talk Subject: RE: Capitalize First Letter of Each Word John McKown, Here ya go man. I only had about 10 mins to write this, hope it works. :) !--- l33t w3rd fixer v1.0 --- !--- Jeff Bevill - [EMAIL PROTECTED] --- cfset Variable="UnBeLiEvAbLe" cfif isDefined("Variable") and Len(Variable) GT 0 cfset in="1" cfset out="0" cfset word_state=out cfset NewStr="" cfset is_space=false cfloop index=i from=1 to=#Len(Variable)# cfset Character=Mid(Variable, i, 1) cfif Character is " " cfset word_state=out cfset NewStr=NewStr Character cfelseif Asc(Character) GE Asc("a") and Asc(Character) LE Asc("z") and word_state EQ out cfset word_state=in cfset NewStr=NewStr UCase(Character) cfelseif Asc(Character) GE Asc("A") and Asc(Character) LE Asc("Z") and word_state EQ in cfset NewStr=NewStr LCase(Character) cfelse cfset word_state=in cfset NewStr=NewStr Character /cfif /cfloop cfset Variable=NewStr /cfif cfoutput#Variable#/cfoutput Jeff Bevill -Original Message- From: John McKown [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 6:35 AM To: CF-Talk Subject: Capitalize First Letter of Each Word Can someone share a script that will capitalize the first letter of every word entered into a form field? John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CFHTTP and XML
This isn't quite true. Ensure that the MIME type is correct for sure, but also ensure that the file returned is an XML file NOT just an XML packet ie: ?xml version="1.0"? myxmldoc textHello/text /myxmldoc instead of myxmldoc textHello/text /myxmldoc If there is no identifier, it can get very messy! Have a look at a WDDX packet (ie sump one to the screen) and you'll see what I mean. Paul PS It can also be useful to strip out any whitespace at the top of the XML file. Use cf_lesswhitespace custom tag for this. Very useful. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 23 October 2000 23:33 To: CF-Talk Cc: '[EMAIL PROTECTED]' Subject: RE: CFHTTP and XML Does anybody know why CFHTTP reports that an XML file is not an ASCII file, and how you can actually get the content back? All you get back is the error message, and I thought CF was meant to be good for stuff like that. If the remote server doesn't return a MIME content type that CF recognizes as text, then CF won't let you reference the FileContent variable. Your only recourse in that situation is to save it to the file system, then open it with CFFILE. According to the 4.5.1 SP 1 release notes, this "feature" has been fixed in SP 1. 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Cobaly RAQ's and Cold Fusion
I am interested to see whether anyone on the list has tried to put CF 4.5 for Linux on any RAQ server or not. Please see below for what Cobalt says may be possible. Paul -- This comes from the Cobalt website. Quite interesting I think you'll find! Although, there is still no real clue as to whether you can do use CF with a RAQ or not. COBALT RAQ Support: -- These instructions refer to the RaQ3 ONLY! Do not attempt to use these instructions with other products QuestionNum: 660 Product: RaQ3 Category Admin Creation Date: Thu Dec 16 15:11:14 1999 PST Question Is the RaQ 3i binary compatible with Redhat 6.0, and if so does it support Allaire Cold Fusion 4.5 for Linux? Response NOTE: UNSUPPORTED. Cobalt Networks currently does not offer support for third party software or modified systems. Please contact the appropriate software vendor for further assistance. Modifications through root shell access could potentially void your warranty. A fee will be assessed by Cobalt for fixes or rebuilds on systems with unsupported modifications. Yes, the RaQ3i is binary compatible with RedHat 6. Although Cobalt has not tested Cold Fusion with the RaQ3i, we have received reports from customers that it does work. -- -- This document refers to all products QuestionNum: 335 Product: All Category Software Creation Date: Thu Oct 29 00:00:00 1998 PST Question Is Cold Fusion supported on the Cobalt servers? Response Currently there is no support currently for Cold Fusion. We are looking into porting Cold Fusion but have no formal timeframe yet. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Storing passwords in database as one way hash
Just to let you all know, I DID NOT WRITE THIS BIT OF CODE. It is another Paul Johnston somewhere else in England. Paul (CF Master) Johnston ;) -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: 18 October 2000 23:59 To: CF-Talk Subject: RE: Storing passwords in database as one way hash Hi all, The JavaScript code I am using is publicly available: /* * A JavaScript implementation of the RSA Data Security, Inc. MD5 Message * Digest Algorithm, as defined in RFC 1321. * Copyright (C) Paul Johnston 1999 - 2000. * See http://pajhome.org.uk/site/legal.html for details. */ I must admit that I haven't tried it with a Mac browser, because that does not apply in our Intranet environment. No problem on PC and Linux, Netscape and IE. If JavaScript is disabled, then the password is sent in clear. What happens then depends on whether JavaScript was enabled when the password was originally set. Interesting, Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Dirk De Bock [mailto:[EMAIL PROTECTED]] Show us the code! :-) Or more politely, I'd love to have a look a that. Is this javascript code publicly available? Of course the effect is that the hash is sent across the wire instead of the clear text password, so it could still be sniffed I guess. - Original Message - From: "BORKMAN Lee" [EMAIL PROTECTED] You can do better than hashing on the server side. I use a JavaScript MD5 hash on the client-side. This prevents the password being sent over the network in clear, and alleviates the need for SSL in some circumstances. IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Extension to custom functions...
Can anyone think of a way of calling custom tags from within functions or cfscript? I think it's possible using a variation of Michael Dinowitz custom functions. Just set up a page full of custom tags, and set up a function that you pass in various values to and it returns a value. This value is then used in a cfswitch to pull in certain cfcase statements. It's just an idea at the moment, but I think it may work. Anyone see any deliberate mistakes? The only problem I can see (possibly) is how to move from the cfscript/functions to the tag. ... at this point my mind is going a bit into overdrive ... This could be got round by creating a temporary file and sticking cf code in there. The function could then output a variable, which gets written to a file, is cfincluded into the page and then it is cold fusion code ... Maybe I'll try and write something... Paul Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Extension to custom functions...
Sorry. I was having a bit of a mare there! The only thing that you would need for this to happen is a variable that if it was changed within the page could call a function at any point. This cannot happen, because all variables are set at the time of execution (unless you can think of a workaround). Effectively, all you need is to put in a load of code if something changes (maybe you could use error checking to include it with cftry). Paul -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 18 October 2000 12:15 To: CF-Talk Subject: Extension to custom functions... Can anyone think of a way of calling custom tags from within functions or cfscript? I think it's possible using a variation of Michael Dinowitz custom functions. Just set up a page full of custom tags, and set up a function that you pass in various values to and it returns a value. This value is then used in a cfswitch to pull in certain cfcase statements. It's just an idea at the moment, but I think it may work. Anyone see any deliberate mistakes? The only problem I can see (possibly) is how to move from the cfscript/functions to the tag. ... at this point my mind is going a bit into overdrive ... This could be got round by creating a temporary file and sticking cf code in there. The function could then output a variable, which gets written to a file, is cfincluded into the page and then it is cold fusion code ... Maybe I'll try and write something... Paul -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Extra records in CSV file generation
How about sending us the code again with a sample output? Paul -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 October 2000 08:28 To: CF-Talk Subject: RE: Extra records in CSV file generation Well, have you checked there are no empty records in the db at all? Paul PS I assume you have, but it's only polite to ask! Thanks Paul, but yeah - I have :D --- 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: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 6:17 PM To: CF-Talk Subject: RE: Extra records in CSV file generation Well, have you checked there are no empty records in the db at all? Paul PS I assume you have, but it's only polite to ask! -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 17:11 To: CF-Talk Subject: RE: Extra records in CSV file generation Why not wrap it in a tag (see tag gallery) like cf_stripwhitespace or cf_lesswhitespace (see below) Unfortunately that didn't help either.. :( I think the problem may lie elsewhere... thanks for the help though. --- 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: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 5:05 PM To: CF-Talk Subject: RE: Extra records in CSV file generation Why not wrap it in a tag (see tag gallery) like cf_stripwhitespace or cf_lesswhitespace (see below) They take out all whitespace from a cf document after it's been processed. It may sort it out, it may not. Paul PS cf_lesswhitepace from http://www.bjork.net/taggallery/index.htm is my personal favourite. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 16:43 To: CF-Talk Subject: RE: Extra records in CSV file generation Maybe wrap the entire thing in cfsetting enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" [sic] Hi Aaron, Unfortunately that didn't work either. h I even tried putting the whole code on one line. Difficult to read in studio, and didn't work either! --- 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 c
RE: Extra records in CSV file generation
Well I'm stuck! Anyone else care to try? Paul PS Maybe you could create a variable and write that out to a file and strip out any blank lines? Then you could locate the user to a page that downloads the file as a csv... Dunno! It's a solution, but a bit scrappy, but it should work! -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 October 2000 12:27 To: CF-Talk Subject: RE: Extra records in CSV file generation Paul, I tried repositioning the cfsetting tag as you said - but am still getting the extra fields... Here is the code - all on one line. CFHEADER NAME="Content-Disposition" VALUE="inline; filename=mangobase_#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv"CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputcfsetting enablecfoutputonly="yes"CFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_ data#"#chr (13)#/CFOUTPUTcfsetting enablecfoutputonly="no" Again, it doesn't matter what records are pulled out of the db, it could be none, one or 27000 + etc - always 7 blank records at the end This says to me that its not data in the db - I've looked for that anyway. The fact that I've tried Cfsetting and cf_lesswhitespace and putting the code all on one line says to me that its not spurious carrige returns or code formatting I've tried it using OLEDB and ODBC - same result... I've tried putting the whole SQL statement on 1 line - same result... (I'm getting desperate now you can tell!) ay ay ay... I mean, its only a cosmetic problem, right? Or is it? Perhaps those 7 records could kill the customer's queries on that data or affect his/her insertion into their accounting etc... must...findanswer *gasp* --- 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: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 12:00 PM To: CF-Talk Subject: RE: Extra records in CSV file generation Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place I've put it: Your code: CFHEADER NAME="Content-Disposition" VALUE="inline; filename=#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv" CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_ data#"#chr (13)#/CFOUTPUT My code (put it all into one line): CFHEADER NAME="Content-Disposition" VALUE="inline;filename=#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv" CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputCFSETTING ENABLECFOUTPUTONLY="YES" CFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_ data#"#chr(13)#/CFOUTPUT I ran this with some of my data, and it worked fine without any extra spaces (also check there are no extra lines at all by putting it all into one line! I hope this works! Paul -- 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: Extra records in CSV file generation
I am guessing that there are some line breaks or something in your fields. Either that or that the fields contain whitespace and nothing else and are still coming out. Maybe check for that when pulling the data out? It doesn't seem to be outputting anything it shouldn't (or that it doesn't think it should). Other than that, I'm confused. Paul -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 October 2000 13:37 To: CF-Talk Subject: RE: Extra records in CSV file generation I'll stick the last few lines of a sample file up at http://www.funjunkie.co.uk/csv/b0rked.csv (personal site) so that you can see whats happening... not quite sure where its getting this stuff from... --- 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: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 12:00 PM To: CF-Talk Subject: RE: Extra records in CSV file generation Try putting CFSETTING ENABLECFOUTPUTONLY="YES" in the place I've put it: Your code: CFHEADER NAME="Content-Disposition" VALUE="inline; filename=#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv" CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_ data#"#chr (13)#/CFOUTPUT My code (put it all into one line): CFHEADER NAME="Content-Disposition" VALUE="inline;filename=#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv" CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputCFSETTING ENABLECFOUTPUTONLY="YES" CFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#item_ data#"#chr(13)#/CFOUTPUT I ran this with some of my data, and it worked fine without any extra spaces (also check there are no extra lines at all by putting it all into one line! I hope this works! Paul -- 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: Browser Detection
see cf_browser in the allaire tag gallery. Paul -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: 17 October 2000 16:48 To: CF-Talk Subject: Browser Detection Now i feel dumb for recently deleating all of that past browser detection talk this is all i want to do: verify that whomever is using IE 5.0 or greater so if I use CGI.http_user_agent Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) How can I just look for the MSIE 5.0, or is there something else I should be looking for? -- 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: Cookies and CFLOCATION
Done both to be on the safe side! I wish they'd document this. I suppose it makes sense if you think about it, but it's not clear that you can't set a cookie like any other CF variable and expect it to work. Oh well, we all know now! Thanks Paul -Original Message- From: Rob Keniger [mailto:[EMAIL PROTECTED]] Sent: 15 October 2000 01:41 To: CF-Talk Subject: Re: Cookies and CFLOCATION on 10/15/00 9:07 AM, Reed Powell at [EMAIL PROTECTED] wrote: Yep, you cannot use a CFLOCATION after trying to set a cookie (actually it's the other way around), so instead of using the CFLOCATION, use this: script language="javascript" document.location="pageyouwanttogoto"; /script This executes on the browser, which means that the cookie will get set. If you're not setting a cookie, use CFLOCATION because it's faster (no trip to the browser and back). This works well unless the user has javascript turned off. Best to also add a Reresh meta tag to the head section of the page: meta http-equiv="refresh" content="0;URL=nextpage.cfm" HTH -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au -- 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: manipulating variables
try Cfset A = B C D E F Putting the quotes round treats them as a string not a variable. Paul -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 10:02 To: CF-Talk Subject: manipulating variables This is a multi-part message in MIME format. --=_NextPart_000_000D_01C03760.71E05810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am at an impass on how to take a series of variables and create a single variable composed of them. I have a 15 digit variable that I need to create from 5 other variables of different lengths. varA (15 digits) B = varB (1 digit) C = varC (5 digits) D = varD (3 digits) E = varE (5 digits) F = varF (1 digit) varA should look like this: BCDDDEF all are integers. I have looked at codeing it like this: A='B''C''D''E''F' but I am not sure that it would work. Any suggestions? Thanks Dominic --=_NextPart_000_000D_01C03760.71E05810 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IiEJAQaQCAAEAAABAAEAAQeQBgAI5AQAAADoAAEIgAcAGE lQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAgACAAEGgAMADgAAANAHCgAQAAsAAQ EA/gAB A5AGAFQGAAAlCwACAAELACMAAAMAJgAACwApAAADADYAAA AAAB4AcAAB FwAAAG1hbmlwdWxhdGluZyB2YXJpYWJsZXMAAAIBcQABFgHAN0+uDr R4kBejKRHU st0AAQIOjbgAAAIBHQwBGgAAAFNNVFA6RE9NSU5JQ0BHUkVOTEFORC5DT00AAA ALAAEO AEAABg4A7nmaTzfAAQIBCg4BGAAqJT+3KF7UEajOAAECDo24wo sAHw4B AgEJEAEAAADzAQAA7wEAAA4DAABMWkZ1RrCJ3AMACgByY3BnMTI1FjIA+Atgbg4QMD MzTwH3AqQD 4wIAY2gKwHOwZXQwIAcTAoB9CoGSdgiQd2sLgGQ0DGAOYwBQCwMLtSBJIGH+bRPgBU ADkQdwCrAE EQIgSCBobwfgdG8VUGF0a2UT4CARIAiBFNFmfCB2CsAHMAJgB5EAcGS6IAUAZRQgFc MLgGcXAOcW lxdwA3BwbxEgF2AWccB0aGVtLiATwRDwAnYVwjE1IGRpZ75pBUAYhxnQFCET0G4J4K 8XYBVhF4UD UiAa4G8Z0f8FwBaoFnEbAAEgBJAJ8AVA5xcADyAZ0HMuCqIKhAqAkRahQSAoGtZzKS AU+EIgPRaS IjAhIBr0IcXWQyJEI7AoIU1EIkQlQHQoMyFcRSJEJtAkTkYvIkQoYCLNIHlzFSB1bN MXYAkAb2sf gGkVsRnQjQQAOimKGiAgQkMs8upELUBFLXJGKYophAdA3wMgCsAVwAuAF8BnBJAf/P 8aRSsCGXEU IQWgAQAYIRRwBx9xK28sdEE9J0InqCYnQzRBRDRBRTRBxEYnLd8KYnUcIhPxvm4dwB XwCHAb1Rsx dyqzGTgQcmsgCymEQW55RTcxZy+wc3RpAiBzyj8pilQQ8G5rELAgKb5EA3ALgA3gKY QR4QA90AAL AAGACCAGAADARgADhQMAA4AIIAYAAM BGABCF AwAHgAggBgAAwEYAUoUAACdqAQAeAAmACCAGAA DA RgBUhQAAAQQ5LjAAHgAKgAggBgAAwEYANoUAAA EB AB4AC4AIIAYAAMBGADeFAAABAQAeAAyACC AGAADA RgA4hQAAAQEACwANgAggBgAAwEYAAA AAgoUAAAEA AAALADqACCAGAADARgAOhQMAPIAIIAYAAM BG ABGFAwA9gAggBgAAwEYAGIULAFKACCAGAA DA RgAGhQMAU4AIIAYAAMBGAAGFAg H4DwEQ KiU/tyhe1BGozgABAg6NuAIB+g8BEColP7coXtQRqM4AAQIOjbgCAf sPAQAAAI4A OKG7EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAATklUQfm/uA EAqgA32W4A AABEOlxXSU5OVFxQcm9maWxlc1xkamRsXExvY2FsIFNldHRpbmdzXEFwcGxpY2F0aW 9uIERhdGFc TWljcm9zb2Z0XE91dGxvb2tcb3V0bG9vay5wc3QDAP4PBQMADTT9NwAAAg F/AAE0 PE5FQkJLSU1PQ0tDRUROTEpLRk9HQ0VOQ0NDQUEuZG9taW5pY0BncmVubGFuZC 5jb20+AAMA BhCCz1m8AwAHEIgBAAADABAQAAMAERAAHgAIEAEAAABlSUFNQVRBTk lNUEFTU09O SE9XVE9UQUtFQVNFUklFU09GVkFSSUFCTEVTQU5EQ1JFQVRFQVNJTkdMRVZBUklBQk xFQ09NUE9T RURPRlRIRU1JSEFWRUExNURJR0lUVkFSSUFCTADnVA== --=_NextPart_000_000D_01C03760.71E05810-- -- 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: Extra records in CSV file generation
Why not wrap it in a tag (see tag gallery) like cf_stripwhitespace or cf_lesswhitespace (see below) They take out all whitespace from a cf document after it's been processed. It may sort it out, it may not. Paul PS cf_lesswhitepace from http://www.bjork.net/taggallery/index.htm is my personal favourite. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 16:43 To: CF-Talk Subject: RE: Extra records in CSV file generation Maybe wrap the entire thing in cfsetting enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" [sic] Hi Aaron, Unfortunately that didn't work either. h I even tried putting the whole code on one line. Difficult to read in studio, and didn't work either! --- 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: Aaron Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 4:06 PM To: CF-Talk Subject: RE: Extra records in CSV file generation hey rich, Maybe wrap the entire thing in cfsetting enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" so your code would look like this: cfsetting enablecfoutpuonly="1" CFHEADER NAME="Content-Disposition" VALUE="inline; filename=#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv" CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#i tem_data#"#chr (13)#/CFOUTPUT cfsettingenablecfoutputonly="0" Aaron -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 10:50 AM To: CF-Talk Subject: Extra records in CSV file generation Gents and Ladies... I am having a right old headache generating a CSV file from data in a database. The data is all returned fine, but at the end of every file there are seven blank fields, no matter what data is contained. I'm pulling my hair out trying to find out why these seven lines are added... I use almost identical code in another app, and it never returns any garbage! Anyone had this or know why this is happening? CFHEADER NAME="Content-Disposition" VALUE="inline; filename=#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv" CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#i tem_data#"#chr (13)#/CFOUTPUT --- 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=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Extra records in CSV file generation
Well, have you checked there are no empty records in the db at all? Paul PS I assume you have, but it's only polite to ask! -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 17:11 To: CF-Talk Subject: RE: Extra records in CSV file generation Why not wrap it in a tag (see tag gallery) like cf_stripwhitespace or cf_lesswhitespace (see below) Unfortunately that didn't help either.. :( I think the problem may lie elsewhere... thanks for the help though. --- 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: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 5:05 PM To: CF-Talk Subject: RE: Extra records in CSV file generation Why not wrap it in a tag (see tag gallery) like cf_stripwhitespace or cf_lesswhitespace (see below) They take out all whitespace from a cf document after it's been processed. It may sort it out, it may not. Paul PS cf_lesswhitepace from http://www.bjork.net/taggallery/index.htm is my personal favourite. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 16:43 To: CF-Talk Subject: RE: Extra records in CSV file generation Maybe wrap the entire thing in cfsetting enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" [sic] Hi Aaron, Unfortunately that didn't work either. h I even tried putting the whole code on one line. Difficult to read in studio, and didn't work either! --- 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: Aaron Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 4:06 PM To: CF-Talk Subject: RE: Extra records in CSV file generation hey rich, Maybe wrap the entire thing in cfsetting enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" so your code would look like this: cfsetting enablecfoutpuonly="1" CFHEADER NAME="Content-Disposition" VALUE="inline; filename=#dateformat(now(), "mmdd")#_#timeformat(now(), "HHmm")#.csv" CFCONTENT TYPE="application/unknown"cfoutput"CONTACT ID","SET NAME","SET LABEL","DATA"#chr(13)#/cfoutputCFOUTPUT QUERY="get_all""#contact_id#","#set_name#","#item_label#","#i tem_data#"#chr (13)#/CFOUTPUT cfsettingenablecfoutputonly="0" Aaron -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 10:50 AM To: CF-Talk Subject: Extra records in CSV file generation Gents and Ladies... I am having a right old headache generating a CSV fil
RE: [RE: Source Control for Linux]
First of all, you need a source control SERVER. This sits wherever your files are. Then you need a source control CLIENT. This chats to the server and says: "I want this file, let me have it!" or "Please create a new version of this for me". So, you install the server on the file server and the client on your machine. There are CVS clients for Windows. I have never tried a CVS client on Windows, so I don't know how it will integrate into Studio. However, it appears that you can do most Windows Explorer type stuff from within Studio so my guess would be that (since CVS integrates with Explorer), that it would work fine. Paul PS It's just a guess, as I've never used it with Windows. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: 13 October 2000 14:58 To: CF-Talk Subject: Re: [RE: Source Control for Linux] I don't understand that answer. We do have a development server and a production server. They are both running Linux. I could install CVS on either or both. How does that help me have source code control from CFStudio? At 07:12 PM 10/12/00 -0500, [EMAIL PROTECTED] wrote: No. You have to have a development server (or development directory) for any of this to work. Peter Theobald [EMAIL PROTECTED] wrote: Does it integrate well with CFStudio? How? At 08:12 AM 10/12/00 -0400, Ken Wilson wrote: Seems to me that http://www.cvshome.org/ would be the most obvious choice? Ken -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 7:53 AM To: CF-Talk Subject: Source Control for Linux Does anyone use a system of source control for linux? I am going to write one if nobody else has a method they use for version control Thanks! Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 -- 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/c f_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 --- --- 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 free email and a permanent address at http://www.netaddress.com/?N=1 --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- 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.
Wierd CFLOCATION error
An email is sent out with a url on it. THe url sets a cookie and then redirects the user with a cflocation tag. For some reason, the cflocation tag is run before the cfcookie tag is complete thus not allowing the cookie to be set. Any ideas? Paul PS Code: CFQUERY NAME="getnextpage" DATASOURCE="mydsn" SELECT refid, formrefid, nextpage, campaignenddate FROM qb_referral WHERE refid='#URL.refid#' /CFQUERY CFIF getnextpage.RecordCount GT 0 !--- set cookie (if it already exists it doesn't matter) --- !--- set it to "CIDID of campaign" and equal to 1 --- !--- we only need to check if it exists on the order pages --- cfif getnextpage.campaignenddate eq "" cfset enddate = Now() cfelse Cfset enddate = getnextpage.campaignenddate /cfif cfset days_to_end = DateDiff("d",Now(),enddate) cfif days_to_end eq 0Cfset days_to_end = 1/cfif !-- set cookie -- cfcookie name="CID#getnextpage.refid#" value="1" expires="#days_to_end#" !-- check if cookie exists -- cfif NOT IsDefined("cookie.CID#getnextpage.refid#") cflocation url="referralerror.cfm?refid=#URL.refid#" /cfif !--- cfoutput#Evaluate("cookie.CID" getnextpage.refid)#/cfoutput --- !-- set relevant things up -- CFSET refid=getnextpage.refid CFSET formrefid=getnextpage.formrefid CFELSE !-- ERROR: refid parameter not found -- !--- if the cookie doesn't exist, send the refid in the URL --- cflocation url="order.cfm" /CFIF CFIF getnextpage.RecordCount GT 0 htmlhead meta http-equiv="Refresh" content="0;url=http://www.blurgh.co.ukcfoutput#REReplace(CGI.SCRIPT_NAME," referral.cfm","","all")#/cfoutputorder.cfm" /headbody cfoutputIf this page doesn't redirect you a href="#getnextpage.nextpage#"click here/a/cfoutput /body/html !--- for some reason this needs to be here --- cfabort cflocation url="#getnextpage.nextpage#" /cfif -- 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: XML, XSL Books?
I found the XML Bible very good. Paul -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: 10 October 2000 03:35 To: CF-Talk Subject: RE: XML, XSL Books? Have a look at http://www.vbxml.com/. Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ICQ: 666275 ACT ColdFusion Users Group - http://203.37.24.198 Being Paid to Surf the Web is only the Beginning! http://au.nz.alladvantage.com/go.asp?refid=der010 -Original Message- From: Alexander Aguilar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 October 2000 12:20 To: CF-Talk Subject: Re: XML, XSL Books? Hmm, I didn't find "XML for Dummies" to be too useful. At least the first edition was chock full of errors and I'm not talking about just typos . I'd recommend "XML by Example" - Original Message - From: "Paige Chandler" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 09, 2000 3:17 PM Subject: Re: XML, XSL Books? Hi Shawn, There is an "XML for Dummies" book available. I have it but have not gotten very far reading it. What I've read is pretty good. Regards, Paige - Original Message - From: "Shawn Regan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 09, 2000 2:05 PM Subject: XML, XSL Books? 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_01C0321B.79E02388 Content-Type: text/plain; charset="iso-8859-1" Can anyone point me to some good XML and XSL books? Shawn Regan --_=_NextPart_001_01C0321B.79E02388 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLEXML, XSL Books?/TITLE /HEAD BODY PFONT SIZE=2Can anyone point me to some good XML and XSL books?/FONT /P PFONT SIZE=2Shawn Regan /FONT /P /BODY /HTML --_=_NextPart_001_01C0321B.79E02388-- -- 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. -- 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 Server Decimal
Erm, I set it up with a precision of 9 and a scale of 18 (or at least that's what I thought I'd set up in EM). Paul -Original Message- From: Peter Stolz [mailto:[EMAIL PROTECTED]] Sent: 07 October 2000 07:33 To: CF-Talk Subject: RE: SQL Server Decimal The digits to the right of the decimal point were truncated because SQL Server stores decimal numbers with precision(max total number of digits) and scale(max digits to the right of the decimal point). The default scale is 0, that is no digits to the right of the decimal point. You can change this in EM. Also, the use of float data types is not recommended when storing prices, money amounts etc. as the representation is approximate : not all numbers can be precisely represented. Decimal is the data type you need. P. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 9:08 AM To: CF-Talk Subject: RE: SQL Server Decimal Actually, I change the field to a float and it's fine! Sorry to bother everyone with that one, although I do think that a data type of "decimal" should be able to hold a "decimal" number! Whoever decided it shouldn't, was a stupid person. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:55 To: CF-Talk Subject: RE: SQL Server Decimal Paul Take a step back mate..what is getting put into the SQL table? If the wrong data is getting put in there run the same query through ISQL and see what happens -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:44 To: CF-Talk Subject: RE: SQL Server Decimal By means of an example, here is some test output: -- TESTING Source Data Case Price: 133.8 Bottle Price: 11.15 Web Data Case Price: 133 Bottle Price: 11 -- Erm, I can't figure out why it does this. Here is the query to get the data in: cfquery name="addWine" datasource="#request.dsn#" INSERT INTO hr_wine ( ... ... , CasePrice , BottlePrice ) VALUES ( ... ... , cfqueryparam value="#REReplace(DecimalFormat(caseprice),",","","all")#" cfsqltype="CF_SQL_DECIMAL" , cfqueryparam value="#REReplace(DecimalFormat(case_bottle_price),",","","all")#" cfsqltype="CF_SQL_DECIMAL" ) Can't figure this one out. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- 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 ht
RE: Which Platform is most scabable for CF 4.5?
Erm, I have never come across a situation where you would need to run X on linux whilst the web server is running. Maybe you need X to install some things, but after that it's strictly command line. Why waste resources on a GUI when you don't need it? Paul -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: 09 October 2000 16:47 To: CF-Talk Subject: Re: Which Platform is most scabable for CF 4.5? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 So far, I have found that linux is considerably faster than NT for functions such as news reading, web browsing, word processing, oracle and mysql databases and apache web serving. In fact I run Linux on a P2 350 and my NT machine is a P3 450 and Linux is faster! In character mode or in X? I find that (obviously) Linux is much faster when not running a GUI, but X performance has always been poor to atrocious... c -BEGIN PGP SIGNATURE- Version: PGP 6.5.8ckt - http://irfaiad.virtualave.net/ Comment: PGP Signed for message verification and/or encryption Comment: KeyID: 0xD68B61E851046CFD iQA/AwUBOeHojNaLYehRBGz9EQKDrACeI8YSOm68pRGJTXOBEJPH1QEbHzMAn20t 7tdkMZtoQY73SKg2ofZXKvcS =wP/X -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. -- 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.
SQL Server Decimal
I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- 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 Server Decimal
Either way it doesn't work (I've tried both and it's just wierd). There isn't an error as such. The field just discard everything after the dot. Should I be using a scientific format ie 361*10^-2 or something like that? Paul PS I even tried CFQUERYPARAM and that didn't work either. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- 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 Server Decimal
By means of an example, here is some test output: -- TESTING Source Data Case Price: 133.8 Bottle Price: 11.15 Web Data Case Price: 133 Bottle Price: 11 -- Erm, I can't figure out why it does this. Here is the query to get the data in: cfquery name="addWine" datasource="#request.dsn#" INSERT INTO hr_wine ( ... ... , CasePrice , BottlePrice ) VALUES ( ... ... , cfqueryparam value="#REReplace(DecimalFormat(caseprice),",","","all")#" cfsqltype="CF_SQL_DECIMAL" , cfqueryparam value="#REReplace(DecimalFormat(case_bottle_price),",","","all")#" cfsqltype="CF_SQL_DECIMAL" ) Can't figure this one out. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- 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 Server Decimal
Actually, I change the field to a float and it's fine! Sorry to bother everyone with that one, although I do think that a data type of "decimal" should be able to hold a "decimal" number! Whoever decided it shouldn't, was a stupid person. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:55 To: CF-Talk Subject: RE: SQL Server Decimal Paul Take a step back mate..what is getting put into the SQL table? If the wrong data is getting put in there run the same query through ISQL and see what happens -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:44 To: CF-Talk Subject: RE: SQL Server Decimal By means of an example, here is some test output: -- TESTING Source Data Case Price: 133.8 Bottle Price: 11.15 Web Data Case Price: 133 Bottle Price: 11 -- Erm, I can't figure out why it does this. Here is the query to get the data in: cfquery name="addWine" datasource="#request.dsn#" INSERT INTO hr_wine ( ... ... , CasePrice , BottlePrice ) VALUES ( ... ... , cfqueryparam value="#REReplace(DecimalFormat(caseprice),",","","all")#" cfsqltype="CF_SQL_DECIMAL" , cfqueryparam value="#REReplace(DecimalFormat(case_bottle_price),",","","all")#" cfsqltype="CF_SQL_DECIMAL" ) Can't figure this one out. Paul -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:25 To: CF-Talk Subject: RE: SQL Server Decimal Paul You don't need the quotes around it... INSERT INTO tablename (decimalfield1, decimalfield2) VALUES (#decimal1#, #decimal2#) I'm not sure this is the problem that you were getting the other day but if this doesn't work let us know the error message you get. -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 13:22 To: CF-Talk Subject: SQL Server Decimal I am having problems putting a decimal into a SQL Server field. The data type is decimal and I am passing the value in with DecimalFormat(#var#) with the commas taken out (so that it is just xx.xx and no more). Exactly what SQL do I need to add in? INSERT INTO... ... VALUES ( #decimal1# , #decimal2# ) or INSERT INTO... ... VALUES ( '#decimal1#' , '#decimal2#' ) or what? Paul -- -- -- 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. -- 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: CFOBJECT Sessions
You could put all of the properties you want into a structure and then copy the structure into the session variable. Have a look at CF_XMLPARSE on http://www.siteobjects.com/index.cfm?fuseAction=showProducts for a really good XML tag that puts a document into a structure. Paul -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 06 October 2000 16:32 To: CF-Talk Subject: CFOBJECT Sessions I'm using a COM object to parse an XML doc: cfobject action="CREATE" class="Microsoft.XMLDom" type="COM" name="xmlDoc" That works fine as long as I only have one page. But once I've loaded the document, I want to keep it in memory across pages. I put it in a session variable: Session.xmlDoc = xmlDoc; and in the next page, when I do cfif isDefined("Session.xmlDoc") EQ "true" I get the right answer. BUT, I can't access any of the object's properties. Error resolving parameter XMLDOC.SAVE The object SAVE is not present in the scope named XMLDOC Is there any way round this? Grateful for any help 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. -- 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: Browser Detect and CFIF
We've had this question before. see CF_BROWSER in the tag gallery. It's more robust (although not perfect) than just using the CFIF stuff although it is a custom tag and gives more info than you could need (although it seems to still only uses the CGI.HTTP_USER_AGENT part). Paul PS Why not use: Cflocation url="#IIF(CGI.HTTP_USER_AGENT contains "MSIE", "iedoc.cfm", "nsdoc.cfm")#" -Original Message- From: Shawnea Carter [mailto:[EMAIL PROTECTED]] Sent: 04 October 2000 20:59 To: CF-Talk Subject: RE: Browser Detect and CFIF I use: cfif HTTP_USER_AGENT contains "MSIE" Internet explorer stuff cfelse Netscape stuff /cfif Shawnea Carter Internet4Associations www.internet4associations.com -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 2:56 PM To: CF-Talk Subject: Browser Detect and CFIF Hello CF_FOLK, Is there a simple way to do a browser check and then depending on the outcome have a specific outcome included via something like cfif Browser ISNOT "Netscape" cfinclude template="IEdoc.htm" cfelse cfinclude template="NSdoc.htm" /cfif Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out all of our websites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. www.OFAH.org - the flagship site of the Ontario Federation of Anglers Hunters. P.S.S. Don't blame me for any of these sites except HuntingDog.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. -- 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.