Re: Visual Fusion - Thoughts?
Pablo Varando wrote: >Hello CF-Talk community: > >For the last year or so I've been working on an application called >"Visual Fusion©" (Patent pending). > I don't want to sound negative or anything, but I have to ask, why ? It sounds to me (after reading the thread) that what you are trying to do is to use the CF syntax to write "real" applications (rather than web applications), but, IMHO, the CF syntax is simply not suited to that, it was designed to intermix with HTML. In effect you would be using a soft toy to hammer in a nail, sure the soft toy is nice and comfortable to hold but it's positively crappy when it comes to hammering in a nail. Languages are designed in general for certain purposes, CF is designed to handle web transactions by manipulating basic data and generating textual output (HTML), Java is designed for cross platform applications programming. By all means, develop this application, but if you are doing it to make money, you should research it very thoroughly, I just don't see writing applications in CFML being an advantage over languages specifically designed for that purpose. --- James Sleeman ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Memory Leakage
Dave Watts wrote: > You might see if there are any documented problems with the specific > database drivers that you're using, or if there's a newer version of those > drivers. Mmm, should have mentioned it is using an MS SQL 2000 database (standard drivers as from Mr Gates), a quick googling finds no mention of leaks. Other sites using MS SQL 7 & 2000 that we have see no similar leakyness. --- James Sleeman ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
OT: Sites using CF Linux
Hi all, can anybody give me pointers to large sites using CF on Linux. The boss is trying to swing a client from PHP :-) --- James Sleeman ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
SOT: Statistics gatherers
Hi all, I'm currently investigating statistics gathering packages, such as "ActiveTracker", to be used to probide usage statistics for fusebox-like sites. The hosting providor's stats package (which probably parses log files) only sees index.cfm (yea, they should get a better package) when I say index.cfm/Foo/Bar. Anyway, "ActiveTracker" seems quite nice, however it stores the data in the form of 1 record per hit, which while I can appreciate is the fastes t way of logging, on a high traffic site that's going to be creating a LOT of records, I have visions of a huge wasteful table of hit records . Does anybody know of a similar package (doesn't necessarily need to be in CF, if it was open source I could possibly convert it), that stores the data in a slightly less gratuitous method ? It would need to provide the usual "stats" functions, session counts, referrers, exit pages, top pages, paths through site etc etc. --- James Sleeman __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Uniquely identifing a structure.
- Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> > May be missing what you're trying to do, but how about generating a uuid > and then having another structure linking uuids to structures. > > > > Yea, no :-) Perhaps I explained it badly. What I want to do is boil an _arbitrary_ structure down to a small value of some sort such that with two of these values I can compare the structures for functional equivalence (i.e same keys, same values for those keys but not necessarily same order in the underlying datastructure (admittedly my WDDX method doesn't work correctly for different ordering (or case) of keys it'll produce distinct keys for thoe functionally equivalent structures)). Example pseudocode lets say it's called blah.cfm... Code... Same Different Initial key stored. Output... 1. blah.cfm?hello=goodbye&goodbye=hello==> Initial key stored. 2. blah.cfm?hello=goodbye&goodbye=hello==> Same. 3. blah.cfm?goodbye=hello&hello=goodbye==> Same. 4. blah.cfm?foo=bar==> Different. Note that 2 & 3, while the order is different, functionally they are equivalent and so they both report same. I've only used the URL scope here because it's an easy structure for an example, but in my application there is the possibility of nested structures, arrays and queries in the structures to be compared. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.384 / Virus Database: 216 - Release Date: 24/08/2002 __ 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
Uniquely identifing a structure.
Hi all, I need to get a simple string value that will uniquely identify a given structure, currently what I am using is this... which produces exactly what I want, but my problem is that this happens several times per request and thus it is potentially a bottle neck (even if wddx is fast, the structure in question could possibly be large). Does anybody have any better ideas on how to accomplish this ? --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.384 / Virus Database: 216 - Release Date: 24/08/2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
exposing limited formatting functionality
For the current job, a requirement is that for the various editable content sections that I expose *limited* formatting functionality to the site editor(s). That is... editors should be able to write something like... [Header]Foo Bar Narf[/Header] [Bold]Hello[/Bold], how are you... This is an [IMG]images/myimage.jpg[/IMG], this is a link - http://www.foobar.com/. and have it converted to Foo Bar Narf Hello, how are you... This is an , this is a link - http://www.foobar.com/. before I bite the bullet and write something myself, does anybody know of a custom tag or user defined function anywhere that performs some function such as this. --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.373 / Virus Database: 208 - Release Date: 7/15/2002 __ 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: Component Calls: What would you do?
- Original Message - From: "Matt Liotta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 1:59 PM Subject: RE: Component Calls: What would you do? You said it yourself... > If the language supports > overloading than the constructors can be overloaded, if the language > doesn't then the constructors can't be overloaded. So - CF doesn't support overloading, that doesn't mean that what you call the component body isn't a default constructor. Infact, it just means that Macromedia was sensible - they decided that there was no need for a special constructor method for CFC's because each CFC may only have a default constructor (and by definition, a default constructor cannot have arguments). Lets say, for example, that MM took what you call the "component body" and turned that into a method that every CFC must have, that takes no arguments, would you be happy to call that a constructor. I think so. So what difference does it make if that method is given a name, as a specific method, or just remains nameless as the "component body", it still does the same thing, at the same time, is compulsory and takes no arguments. I think if you said to any Java or C++ programmer, "see this bit of code, that is what CFC's use as thier one and only constructor", they will instantly recognize that this happens when the object is "constructed", that it's a "default constructor" and that because CF doesn't support overloading, that it's the "only constructor". And likewise I think if you said to any CFC programmer, "see this Java function, this is what Java classes use as thier default constructor, but because you can overload in Java you may specify more non-default constructors that can take arguments", it would be quite plain that this function happens when the object is "constructed", that it's a "default constructor" and that because Java supports overloading, it's not the "only constructor". The concept is the same - a bit of code, that gets executed when the object is created, that can be used to initialize everything that object needs, be it written in Java, C++, Python, Smalltalk or ColdFusion. --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.373 / Virus Database: 208 - Release Date: 7/9/2002 __ 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: (Opinion) Pop-up or not to pop-up?
> Seriously, my first modem was a 5-pound walnut, wooden, box-jointed box, > about the size of a small tool--box, and had a speed of 100 baud -- and > *rented* for $79 per month -- we could run our APL terminals from > anywhere! EI: Right. I had to get up in the morning at ten o'clock at night, half an hour before I went to bed, eat a lump of cold poison, work twenty-nine hours a day down mill, and pay mill owner for permission to come to work, and when we got home, our Dad would kill us, and dance about on our graves singing "Hallelujah." MP: But you try and tell the young people today that... and they won't believe ya'. Sorry, couldn't resist. --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.373 / Virus Database: 208 - Release Date: 7/6/2002 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: CFMX bug ??
> Complex object types cannot be converted to simple values. > > The Error Occurred in J:\InnovativeMedia\StaffAdmin\qry_husk.cfm: line > 71 > Called from J:\InnovativeMedia\StaffAdmin\dsp_husk.cfm: line 6 > Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 126 > > 69 : > 70 : > 71 : href="#URL#" class="OLmenuLink" > onMouseOver="highlightMenuItem('#menuName##menuX#')" > onMouseOut="unhighlightMenuItem('#menuName##menuX#')">#Name# > 72 : > 73 : Replying to myself again :-) of course URL is a give away there, naming a variable the same as a scope is bad in any case, but used to work in CF5... the release notes have this to say. --- Currently in ColdFusion MX, you can create a variable with the same name as a scope (Application, CGI, Client, Cookie, Form, Request, Server, Session, URL, or Variables). The created variable is only visible if the Variables scope prefix is explicitly used; otherwise, an error results. However, scope names are reserved in ColdFusion MX and might be enforced in a later version. Therefore, Macromedia strongly recommends that you do not use scope names as variable names. --- This doesn't explain "file" though. --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: CFMX bug ??
- Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 7:04 PM Subject: RE: CFMX bug ?? > In the second case, #URL# might be the prime suspect for the same > reason. Yes, duh, realised that as soon as I posted :-) Don't blame me I didn't write that bit of code :-) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFMX bug ??
- Original Message - From: "James Sleeman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 6:34 PM Subject: CFMX bug ?? > > DESTINATION="#REQUEST.MirrorDir#\#file#" > > > > fails with... > > Complex object types cannot be converted to simple values. > Replying to myself... I have narrowed it down somewhat, it seems that there is something funky about calling a variable "file" (not case sensitive), no matter what I set "file" to (either there as the loop index, or manually as ) it always remains an empty struct (at least thats what CFDUMP tells me it is). So i renamed the variable file to xfile and this section of code works now. But after waiting around for aages while it compiled code, lo and behold a very similar error occurs here... Complex object types cannot be converted to simple values. The Error Occurred in J:\InnovativeMedia\StaffAdmin\qry_husk.cfm: line 71 Called from J:\InnovativeMedia\StaffAdmin\dsp_husk.cfm: line 6 Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 126 69 : 70 : 71 : #Name# 72 : 73 : here I'm guessing it's either #Insert#, #URL# or #Name# that is the problem. How many of these am I going to find around the place ?!?!?!?!?! --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFMX bug ??
Hi all, I'm just working on porting our intranet (which is currently running under CF5) to CFMX, and right off the bat I have a little strangeness I have a query, Q_Changers which contains the names of files that need to be copied, generating the query works fine, but the copy code... fails with... Complex object types cannot be converted to simple values. The Error Occurred in J:\InnovativeMedia\app_globals.cfm: line 122 Called from J:\InnovativeMedia\StaffAdmin\app_locals.cfm: line 12 Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 9 120 : 121 : 122 : 123 : 124 : but I'm not using any complex objects there, all variables on line 122 are simple strings, (REQUEST.RootPath & REQUEST.MirrorDir are directory paths, and file is of course just a filename). Not to mentiong the intranet is functioning correctly under CF5 as I type. Ideas anybody ? --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Netscape and MX
> We are in the process of changing these over to run on MX. The problem is > that anything with DHTML ends up causing the text in Netscape to change to > either a little box indicating a character not supported for display by > windows or a little cross like symbol. Everything still works fine in I.E. > and this is the same code running on CF 5.0 with no modifications yet. Both > servers are running NT 4.0 with Service Pack 6. > > Has anyone else ran in to this or did I miss something in the documentation? > You help is appreciated. Do you have debugging information turned on, and if you do do you have the new floating/dockable debugging pane turned on - it will only work in the latest model browsers and could be causing the errant effects you are seeing in NS4. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/28/2002 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Aggregating server side form validation messages
i usually do something like this in my server side action, then in the form display Please correct the following : #error# - Original Message - From: "Mark Leder" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 4:57 PM Subject: Aggregating server side form validation messages > I'm doing both client side (JS) and server-side form validation. > Typically in JS Client side, if there are a number of required fields > not filled in by the user, upon submit, a single popup alert occurs > listing all the fields that need to be filled in. > > I want to do this same process with server side (using CFM) as well. In > other words, using a first name field as an example, I'd like to replace > the CFLOCATION statements in each check group (I could wind up with 30 > checks on the various field) with something that will "remember" the > #val# number and then lump them all one CFLOCATION statement at the end > of the validation routine, such as: > > URL="#REQUEST.webroot##REQUEST.Ssubwebroot#/default.cfm?pID=#URL.pID#&va > l=19a, 19b, etc." ADDTOKEN="No"> > > The &val= appendage would be dynamic, only having those values which did > not pass the server-side validation. > > How would I accomplish something like this? > > == > > > > > > URL="#REQUEST.webroot##REQUEST.Ssubwebroot#/default.cfm?pID=#URL.pID#&va > l=19a" ADDTOKEN="No"> > > > > > > #IsAlphabet(SESSION.ecom.firstname)#> > > > URL="#REQUEST.webroot##REQUEST.Ssubwebroot#/default.cfm?pID=#URL.pID#&va > l=19b" ADDTOKEN="No"> > > > > === > > Thanks, > Mark > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Global database of cities/towns/villages.
Hi all, a client wants people to be able to select a country, region and city/town/village from select lists, problem is that it needs to be global. I found this one http://www.meridianworlddata.com/Product-Overview.asp?itemid=731 but apart from the hefty price tag a quick search revealed that it doesn't even have some large towns in New Zealand (for example, Rangiora which has a population of 8500 or so) so it doesn't instill confidence. Anybody know of any better sources ? --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/27/2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Apache 2.0.39 (win) + MX, any progress ?
Anybody know if any progress has been made on the problem with CFMX and Apache 2.0.39 (i.e it causes the Apache2 service not to start) ? I'd really like to be able to try some stuff with MX but need to use it with my Apache 2.0.39 install. --- James Sleeman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/23/2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Selecting specific value from a query result?
> I have a nagging feeling this is really obvious, but I can't get it - can't > I grab a specific value from a query using structure or array functions? > > I need to specify retrieval of value N from column X, if that makes sense. Q_MyQuery.X[N] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/21/2002 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Using CFInclude tag in content being extracted from DB....is it possible
> James Sleeman wrote: > | There is another thread running on this at the moment, see "templates held > | in database". > | > | To answer your question though, write the content from your database to a > | temporary file using CFFILE, then use to include that > file, then > | delete the temporary file... > > but this approach is flawed with cfmx as the first hit on a template s > slow as it is compiled in to java byte code. :-( That is correct, hence why you don't want to rewrite the file each time you need it. If you only pull it out of the database when it changes then CF will compile it only once per change... easy way to do this is to name the file as the hash of the content eg... ... write out the file ... Lock around the file writing of course to stop 2 threads trying to write it at the same time if it doesn't exist. You probably want to clean up the files every now and then (just delete any older than x days when the app fires up or something). --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/21/2002 __ 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: cflocation url length
> I've noticed that cflocation seems to fail when the url argument is very > long, for example > 850 chars. I think I remember seeing somewhere that > CFLOCATION actually implements an HTTP 302 Redirect. Is there something in > the html headers which is restricts the url length, or is this an artificial > restriction imposed by cflocation? > More pratically, has anyone determined the actual cutoff point where > cflocation will fail? The limit varies from browser to browser. The thing to remember is, if your sending data that is potentially large, you need to either store the data in a session variable/database/whatever and pick it out at the other end, or do it in a form post. Using Javascript you can easily make a hidden form on a "Loading..." page submit automatically Loading... --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/21/2002 __ 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: Using CFInclude tag in content being extracted from DB....is it possible
There is another thread running on this at the moment, see "templates held in database". To answer your question though, write the content from your database to a temporary file using CFFILE, then use to include that file, then delete the temporary file... Written off the top of my head, those attributes to CFFILE might be wrong. - Original Message - From: "Picker, Mark" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 6:26 PM Subject: Using CFInclude tag in content being extracted from DBis it possible > Hi, > > We are developing a site that has all the page contents stored in a > database. Each page has a variable set at the top and an include later > in the page that calls a page to load content from the database. > > This is a page from the site (all are the same as this) : > > > > > > > > > and this is the content.cfm page : > > > SELECT tblDocuments.fldDocumentID, > tblDocuments.fldDocumentTitle, tblDocuments.fldDocumentText > FROM tblDocuments > WHERE (tblDocuments.fldDocumentID=#PageID#) > > > > #Evaluate(DE(fldDocumentText))# > > > All seems to work ok except if the content coming from the database has > any coldfusion tags in it. Functions appear to be ok, just not tags. > The problem is, some pages has in them. > > This is an extract from a pages contents in the database : > > > > #now()# > > > The #now()# is done, and displays date/time etc, but the tag > does not do anything and actually appears as code in the source to the > final page in the browser. > > > {ts > '2002-06-24 16:16:26'} > > > > Does anybody know how to get around this problem? I need to use the > that is in the database content. > > Regards, > > Mark Picker > Internet Manager > Western Institute of TAFE - Dubbo > Direct Line : (02) 6885 7538 > Institute Office : (02) 6885 7522 > Fax Number : (02) 6884 3610 > > > 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 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Exclusive Lock timeout question
> I've been under the impression that serializes access to the > entire datasource ... in which case I think I would be more inclined to use > the named cflock approach since it wouldn't affect the performance of any > other pages which might be accessing other parts of the db in question... It would depend on the database. CFTRANSACTION just tells the database to start, end commit or rollback a transaction, wether the database engine thinks it should serialize all access to the entire datasource is up to it, but most would be sensible about it (i.e they will allow transactions to execute simultaneously until such point as a conflict is found, if one transaction would not interfere with another then the (good) database should have no problem allowing them to execute at the same time). :-) --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Exclusive Lock timeout question
- Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 11:07 PM Subject: Exclusive Lock timeout question > My question is, if I set a timeout value of "10" on an exclusive > lock, what exactly times out? > > Is it... > A) The person waiting for the lock will receive an error after > waiting for 10 seconds? If throwontimeout is set, yes. > B) The person using the lock will receive an error if the code inside > the lock runs for more than 10 seconds? No > C) Both? No Coldfusion will attempt to get the lock for 10 seconds, if it gets the lock inside 10 seconds it will enter the locked portion of code and continue on as normal. If it doesn't get the lock it will either (depending on what you set throwontimeout to do) throw an error or continue from the first statement after the locked portion of code. > Or is there a better way to do this in anyone's opinion. Perhaps you shoudl use CFTRANSACTION, it will "atomize" the individual queries ... that is... you have an available quantity, say 5, and 2 customers customer one comes in he wants 3 items, and customer 2 comes in he wants 3 items, your code is get number of available items reduce number of items Say "not enough items" all the queries between the tags will for all intents and purposes happen simultaneously, that is, for customer one (assuming they got into the CFTRANSACTION first) they will get the number of available items, and set the reduced number _at the same time_. Customer 2 will then get reign over the CFTRANSACTION and they will get the new number of available. Think of it as an exclusive lock that the database will handle for you, nice and easy. --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: CFEncrypt Utility
- Original Message - From: "Matt Liotta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 22, 2002 1:41 PM Subject: RE: CFEncrypt Utility > Without giving it all away... It allows you to package up some CF code > and lock it down with a key. Then you distribute it to some destination > server. The person on that end gives the tool the correct key to unlock > it, and the tool gets CF to compile all the code into classes and then > removes any trace of the source. There are lots more details to it > including how it protects against various types of attacks on stealing > the source, but those are implementation details you can't have. > I was under the impression that while Ben Forta showed in an early demo that the CF source code could be removed from the server that in the CFMX release it is not really possible to do this (I realise you are not sending around java classes, but still). Whatever the case you are still going to end up putting the source in clear text (or cfencrypted at least) on the server even if only for a short time, it would be trivial to have something watch the directory the files are installed (temporarily) to and whip off a copy somewhere before your tool scrubs them, no ? Unless CFMX can be coaxed into decrypting - in memory (the way it does with cfencrypted files) - source code files encrypted with some high quality algorithm, using a private key that is retrieved from some means not accessible to anything other than the CF server and never stored on disk (perhaps it could be retrieved over the web at run time, or wired into a server dongle (that's not a bad idea, if MM equiped CF server with unique dongles we could encrypt the files against the customers dongle ID)), then I don't see how it will be possible to protect source code with significant success (of course, you can never be 100% successfull, it's all just a bunch of bits in the end). --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.370 / Virus Database: 205 - Release Date: 6/16/2002 __ 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: Client side sorting SLOOWWWWW!! HELP!
Couple of things, JavaScript is slow, you just have to accept that. And you don't say what sorting algorithm your using, at least use a basic implementation of Hoare's Quicksort, if you have the time you should examine the data and invent a partitioning algorithm for the quicksort that will best suit the data for speed of sort. Also make sure that your comparison operation is as efficient as possible - that's the real gut work of a good sorter and it needs to be FAST. Remember that sorting algorithms are dependant on the data also, not even Quicksort will be the quickest sort for all data (Quicksort will get slow for unbalanced partitions). Now that's for the sort algorithm, but also remember if your rewriting HTML tables (sounds like you are) on the fly that will be a slow process, you are better to dump all the re-written HTML in one go rather than slowly appending to the innerHTML of an element. You might find it better to incorporate this into a Java applet, java (while still not blindingly quick) should be much quicker than javascript and you'll do away with re-writing HTML that way. - Original Message - From: "Andre Turrettini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 22, 2002 1:51 AM Subject: Client side sorting SLOOW!! HELP! > Hey, maybe someone can help me with this advanced topic. I'm doing client > side sorting of tables with dates, numbers, and text and it was working > dandy on my test tables but then I tried to do a big fat one. Like 600 rows > and 10 entries per row and it slos down like bad!! Anybody done this > and have any tips on speeding it up? DRE > __ 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: WYSIWYG HTML editors (a'la soEditor) for Macs ?
On Thu, 2002-06-13 at 00:19, Tim Painter wrote: > Don't know if this will work, but try http://editize.com/index.php -- they > have a java based editor that may fit the bill. Looks swish, but doesn't support images (or tables, but that's not so important), and Java support pre OSX sucks on Macs (no 1.3, can get Swing but it's a pain) so it probably wouldn't even work on them. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Backups
> I'm asking because our hosting provider just told us that they can't backup > our .mdb files, because they're locked when CF opens a connection to them. Most backup software should be able to back up locked files, they generally don't garuntee that the content is OK, but usually it shouldn't be a problem. Sounds like you should look for a new providor. __ 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
WYSIWYG HTML editors (a'la soEditor) for Macs ?
Hi all, we have a client, who despite our best efforts ( :-) ) is steadfastly Macintosh. They won't purchase a PC, they won't even purchase Virtual PC. Now, in many of our administration systems we use soEditor (lite, not that it matters), which works wonderfully under IE on windows, and doesn't on anything else (understandably, it uses IE components). This client really really really wants similar functionality for thier next site, but still refuses to get Virtual PC (soEditor works fine under Virtual PC, or so I hear from other clients). Does any body know of any comparable WYSIWYG editors that will function on a Mac platform (either IE or NS/Moz) ? --- James Sleeman __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Online CSS editors ?
- Original Message - From: "Nick de Voil" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 2:59 AM Subject: Re: Online CSS editors ? > Yes, I have one I built, drop me a line if you're still looking. Certainly still looking, you should put up a demo somewhere, looks like I'm not the only one interested in something like that :-) --- James Sleeman [EMAIL PROTECTED] Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
Online CSS editors ?
I am looking for a way that I can allow site admins to edit CSS styles to effect the look of a site, or page etc. It needs to be edited online. Basically I want soEditor but for editing CSS styles instead of html :-) Anybody seen anything like this around ? --- James Sleeman __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: UDFs in a Custom Tag problem
You have to do it as an include, the function declaration actually happens on parsing of the template you see, so when your custom tag gets hit on the end tag that parser "reads" the custom tag template again, and sees a declaration for isOperator - no matter that it won't be used this time around. A CFINCLUDE'd file won't be parsed ("read") until the CFINCLUDE is executed, so it is an effective work around. and thisOperator.cfm contains function IsOperator( value ) { blah blah blah; return something; } - Original Message - From: "heirophant mm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, May 18, 2002 2:27 AM Subject: UDFs in a Custom Tag problem > Hello developers, > > I'm writing a custom tag, and I've written some UDFs to clean up some of the code within the custom tag. Only the custom tag uses these UDFs - they're pretty specialized - so I thought it would be easiest to just put them right inside the template for the custom tag. Here's my general structure: > > > > function IsOperator( value ) { > blah blah blah; > return something; > } > > more code > > > some output, etc. > > > I get this error: > "Routines cannot be declared more than once. The routine IsOperator has been declared twice in different templates." > > I have found that this error occurs at the very beginning of the "end ExecutionMode" of the tag. > > I can't figure out how to stop this error. Any ideas? Thanks > > Mike Mertsock > Alfred University Webteam > > > > > Outgrown your current e-mail service? > Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. > http://login.mail.lycos.com/brandPage.shtml?pageId=plus > 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 > __ 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: Looping through file-fields
> > > > > > Received file number #f# > > Nothing for #f# > > > > Use Form["File#f#"] instead of ('Form.File#f#') __ Get the mailserver that powers this list at http://www.coolfusion.com 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: SHA-1
> We have a requirement to use SHA-1 encryption to store certain values > within a MS SQL7 database. Does anyone know of a custom tag or any other > encryption tool that utilizes SHA-1? Just a note, I'm sure you know, but others might not. SHA-1 is not an encryption method, it's a one-way hash, what goes in can never come back out. --- James Sleeman __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Cancel button with CFINPUT Requires=Yes
http://where.ever.you.so.please/'"> - Original Message - From: "Bruce Holm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 11:16 AM Subject: Cancel button with CFINPUT Requires=Yes > I am noticing that if you use CFFORM and then CFINPUT or CFSELECT and specify a field to be "Required" that having a Cancel submit button is not possible. It will ask for all required fields before you can click on Cancel. > Kind of defeats the point of Cancel. Any work arounds? Suggestions on how to deal with this (other than not to use CFINPUT, etc.) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
Online stylesheet editor
In the same vein as soEditor etc. I want to be able to offer users the ability to modify a stylesheet online, in a graphical environment (rather than just dumping them a textarea with the stylesheet in it :-)). Anybody know of an existing solution? --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ 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: Spiders and SES urls
> yes, but that is not really a 'search engine safe' url. > the .cfm in there will give the search spider all the clues it needs to > determine that this page is data-driven. > they won't ban you or anything, but you won't get as many points as if your > URLs looked like: > http://www.somesite.com/index/19/ > that is a true 'search engine safe' url, otherwise known as a > 'directory-style-querystring' But that would require passing any file - at least any file without extention to the CF engine. Bit of a problem no ? __ Get the mailserver that powers this list at http://www.coolfusion.com 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
getting NAME attribute of a CFFORM ancestor
Hi all, any body know if it's possible to get, programmatically, the value of the Name attribute of an ancestor CFFORM tag... that is something like this pseudocode (simplified use), I tried using getBaseTagData("CFFORM") but apparently (in CF's words...) "The parameter combination of function GetBaseTagData does not specify a base tag that exposes any data. " If you're wondering, it's for use in a custom tag that writes some augmented form fields for use in a CFFORM, sure I could pass the custom tag a FormName attribute, but I figure that seeing as you don't have to do that you shouldn't have to do either. --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Finer grain performance indicators
>From the good folks at Apache... http://jakarta.apache.org/jmeter/index.html - Original Message - From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 4:47 PM Subject: Re: Finer grain performance indicators > At this point it time, several thousand is out of the question, few-several > hundred would be fine ... nothing would be great ... > > I said in the previous message, I want to run some load testing on our apps > and see how they stand up and where we can improve. __ Get the mailserver that powers this list at http://www.coolfusion.com 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: All CFM Templates Require Login?
> He was trying to determine if two different web servers were configured > the same. If the configuration is based on text files, than a simply > text file comparison tool will do the job. Two (apache) config files can do the same thing and look entirely different, diff wouldn't have helped much in this case. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Finer grain performance indicators
- Original Message - From: "Matt Liotta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 06, 2002 3:49 PM Subject: RE: Finer grain performance indicators > The only way to really measure the performance of your application is > with load testing tools. Simply looking at the time it takes to process > a single request is generally not that useful. I disagree, load testing comes after you have performance tuned the application for single requests, the execution times will point you to areas of code that need improvement, or optimization, load testing can help point you to bottle necks exosed when the throughput is much higher than the single request. Execution times will help you optimize the code, load testing will help you optimize the logic. > However, an execution > time above 250ms is just plain slow. That is entirely relative - if you are doing a query manipulating 40,000 rows and your server is running on an old 486 with 64mb of ram then 250ms would be pretty bloody quick (magic box quick!), and if you are displaying a simple "Hello World" template on an Athlon 1700XP with 2 gig of usable Ram and a 3 gig Ram Disk containing your entire operating system, then 250ms is pretty slow. --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Get the mailserver that powers this list at http://www.coolfusion.com 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
Finer grain performance indicators
for those very quick templates. It would also be better if multiple calls to the same template were not lumped togethor, for example in the above all the templates in \PBCORE\ get run multiple times (4 times if I count correctly) but they each only get one time. Ideas ?? --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ 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: RDS in DW MX not working (fixed)
- Original Message - From: "James Sleeman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 4:08 PM Subject: RDS in DW MX not working > Has anybody managed to get RDS working in DW MX ? I'm trying to use the Ahh, did some digging around in the server logs and found that when I hit that "RDS login" link it posted a request to the "testing server" for /CFIDE/main/ide.cfm, and while I did have a /cfide alias set up for all the Apache sites, aliases are case sensitive so I actually had to alias /CFIDE to the Coldfusion CFIDE directory. Sweet .. on with the previewing. --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ 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
RDS in DW MX not working
Has anybody managed to get RDS working in DW MX ? I'm trying to use the Databases tab in the Application section... I have set up the site correctly, numbers 1, 2 and 3 are checked but when I click "RDS login" in step 4 I just get an error - The server name or address could not be resolved. The URL prefix (specified when you set up this Dreamweaver site) might be ill formed. but the URL Prefix (in the testing site configuration) is correct, and the fact that step 3 is checked off tells me that DW knows this is the case (because if I make that URL prefix invalid it doesn't check step 3 off). Without being able to see databases I'm having to jump back and forth between studio and DW, when if I had it I could almost use DW exclusively. --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Am I the only one who uses CONNECTSTRING ? (MX rant)
- Original Message - From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 6:47 AM Subject: RE: Am I the only one who uses CONNECTSTRING ? (MX rant) > The following message is being posted for Libby Freligh, ColdFusion > Product Manager, who for some reason was unable to do so herself (kept > bouncing). > Thanks Ben & Libby, it's good to know it hasn't been forgotten about. --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
Am I the only one who uses CONNECTSTRING ? (MX rant)
Ok, now the NDA is moot I can ask the wider community. One of the best features IMHO in CF5 was the introduction of CONNECTSTRING to enable us to have dynamic datasources, that is, DSN-less connections. Since CF5 came out I have used these almost exclusively, infact I have been able to write applications that simply would not have been possible without it. But with the introduction of CF MX the CONNECTSTRING is now no more, at least in the initial release. This means we say goodbye to dynamic datasources and it's back to having to have every database set up individually by the CF administrator. This, in my opinion is a major step back, surely the purpose of a new release is to add features not take them away. The reason for losing the functionality appears to be to do with JDBC, and while it is possible to work around, Macromedia has basically said they don't have time to do it now so it's easier to sweep under the carpet and perhaps catch it next time - whenever that may be. This single issue is certainly going to stop me from using MX with any of my existing applications - the changes necessary would be widespread, and in some cases impossible. Indeed, for new applications I will have to evaluate thier needs carefully to determine if I can use MX or not. This is going to cause shared hosting providors to not be able to upgrade thier existing servers, at least not without imposing on thier clients to a great degree, it's also going to increase thier work load because now they must set up each and every database (can you imagine if 500 clients ask to have thier previously dynamic datasources set up all at once !). But, only a couple of people in the beta group aside form myself seem to be at all concerned about this. Am I the only one who uses CONNECTSTRING ? Surely it is such a useful feature that we can't release MX without it ? Surely it's worth working on for a little longer to get this functional ? Well, just had to get that off my chest, I'll go back to work now :-) --- James Sleeman __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: CFStudio > DWMX hiccups
> > At least it wont > > crash as much as Studio...that's a plus. > > Damn straight! Haven't used it much, but stopping those bloody Access > violations that wiped hours of work away at times has to be #1 hope for > DWMX. Fingers crossed. Yeah, but it could do with a bit of a crash diet. Sitting idle here on my workstation with no files open it uses more than 40 meg of ram and 15 - 20% CPU time, that's a lot of resources to be doing nothing with. Switching to it from another application also seems to be quite intensive for it, takes a couple seconds. Hopefully it loses a few inches from the waist before it hits the streets. Personally I woulda liked to see it written in Java like CF MX using Mozilla as it's layout engine, then we could have DW MX 4 Linux and I could be rid of this Windows machine. Course, that probably would have made it _really_ slow (java, not mozilla ;-)). --- James Sleeman __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: CFABORT after CFLOCATION?
> My question is: Why is the custom tag executing? Shouldn't the page stop > processing after the cflocation call? If I put a CFABORT directly after the > CFLOCATION call *within* the CFIF block, the custom tag still executes. > However, if I place the CFABORT above the custom tag call, but *outside* of > the CFIF block, the page properly CFLOCATEs and the custom tag is not > called. Hmm, sounds to me like something fishy in that CFIF conditional... try this (i know you'll think - well duh of course it's executing, but just humor me :-))... if the page doesn't abort then you know that conditional is not running (which is what sounds like is happening), are there any nested conditonals in there that could cause the location not to happen ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Locking by name - is is application independant ?
- Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 8:04 AM Subject: RE: Locking by name - is is application independant ? > > The problem with this is that you can't just lock "part" > > of the APPLICATION scope for example, if you want to do > > something to only some stuff stored in the app scope you > > need to use named locks - but if you do that you're gonna > > have to be careful that you don't use a name that some > > other application on the same server has used (perhaps > > without your knowledge if on a shared server). > > I don't know how well that would work, though, since the Application scope > is a structure - a variable - itself. I don't know enough about the > internals of CF to say whether it would be safe to only lock access to a > structure member, rather than to the structure itself, but personally, I'd > avoid it. It's a concurrency thing more than anything - if one request is setting up the stuff in APPLICATION.CONFIGURATION I don't want anything reading the configuration until I'm done. But they should be perfectly entitled to read and write to APPLICATION.LOGGEDINUSERS for example. I see where you're gettng at though, I think it's just a little inconvienient :-) __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Locking by name - is is application independant ?
On Sat, 2002-04-27 at 04:54, Dave Watts wrote: > > When should you use each? Right now, I do not use > > named locks. > > If you're using CF 4.5.x or higher, you should use the SCOPE attribute when > locking memory variables, and the NAME attribute for locking other things, > like CFX tags, if they need to be locked. > > If you're using CF 4.0.x, you don't have a SCOPE attribute, and have to use > the NAME attribute for all locks. The problem with this is that you can't just lock "part" of the APPLICATION scope for example, if you want to do something to only some stuff stored in the app scope you need to use named locks - but if you do that you're gonna have to be careful that you don't use a name that some other application on the same server has used (perhaps without your knowledge if on a shared server). What CF really needs is a combination of scope="" and name="" so that we can specify we want to lock a structure within our application, but identify the lock by this name (local to our application), oh well, dreams are free. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: 2 Zip or Not 2 Zip
Y'know, it sounds to me like this special text file should be embedded into the music files themselves ? That, or the music files should be tarred or zipped or otherwise grouped into a file with thier text file. Whichever way, the C++ application should unquestionably be doing the extraction/untarring/zipping... to get out the music and encryption key for sending to the device. The last thing you want users to do is jump through hoops to get what they want, wether the hoop is having to download a mysterious text file as well as what they want, or unzip files and pass them into another application. I would suggest that having 2 files the user must download is going to be, as you believe, confusing for Jo Bloggs. Whatever you do you have to get those files combined into one. Sounds an interesting project BTW. - Original Message - From: "Owens, Howard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 26, 2002 5:09 AM Subject: RE: 2 Zip or Not 2 Zip > Good suggestions this morning ... > > It's a C++ application on the client side ... manages all of the files, uses > a special encryption method to prevent swapping files between devices, > writes them to an external device that uses the files (only properly > encrypted files can be used on the ID-identified device for which they are > written). > > H. > > > > > -Original Message- > > From: Lewis Sellers [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, April 25, 2002 9:24 AM > > To: CF-Talk > > Subject: RE: 2 Zip or Not 2 Zip > > > > At 09:16 AM 4/25/2002 -0400, you wrote: > > >After thinking about it overnight, my advice is to do it the Zip way, AS > > >WELL AS whatever way the programmer comes up with. > > > > > >Then do some benchmarking analysis and see which method works best. You > > >can support this plan by saying that it really is in the best interest > > >of the client to evaluate all of your options before making a decision. > > > > > >Then make the decision as to what method works best. I have a feeling > > >that once the programmer sees the results he may very well be more open > > >to the Zip idea. > > > > > >However, since we do not have all the details of the project, who knows? > > >Maybe this guy's method really will work better. That is why the idea I > > >outlined above benefits everyone. > > > > > > > > I think one "detail" that might help the group at large here :) decide is > > what was meant by this being a "client-side application". I was under the > > impression that mean an activex COM (as Howard mentioned the word COM). If > > > > that's so, you simply throw in a generic ZIP class to the project (if it > > were in c++) and run with it. (In fact, if it's an activex control the end > > > > user might not necessarily even ever see the file). > > > > A java applet might work just as well at this point (though as .NET > > gung-ho > > as the programmer is they might not want to touch java). > > > > Anyway, if it's not activex... well... maybe something besides ZIP might > > be > > easier after all on the client end. > > > > --min > > > > > > > __ 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
Locking by name - is is application independant ?
If i have two applications on the same CF server, indentified by to different CFAPPLICATION tags, say one with an application name Foo and the other Bar, and I execute a bit of code in each that does a *named* cflock using the same name, will that lock extend across applications ? That is... In Foo.cfm Do something here In bar.cfm Do something else here can Bar get into it's CFLOCK while Foo is in it's CFLOCK. I'm hoping yes, beause that's what I expected, but I'm seeing some behaviour on our server with different sites using locks with the same name that might indicate that the answer is no. --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Get the mailserver that powers this list at http://www.coolfusion.com 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: QoQ
> > > Select numberfield > From tbl > > > > > Select numberfield > from qmain > WHERE qmain.numberfield > 45 > you are missing DBTYPE="query" i.e. Select numberfield From tbl - Original Message - From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 9:45 AM Subject: QoQ > Hello all > > need a little help with QoQs. > > How can I compare numbers in the QoQ? > > Example: > > > Select numberfield > From tbl > > > > > Select numberfield > from qmain > WHERE qmain.numberfield > 45 > > > > IF I use the ">" I get a PCODERUNTIME. error > If I use GT I get the error that numberfield is not a number. > I even tried #qmain.numberfield#, but then it only compares the first > record. > I have ran numberfield through the ISNUMBER function and get true so it is a > number. > > > Thanks for any help > Rodney > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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: CFLOOP problem with commas
> As you can see, the first URL outputs normally, but the second URL > breaks at every comma. Is there a way around this? I don't want to > insert Chr() codes if I can help it! Remember that when picking a delimiter, any character is fair game, you can be pretty much assured that something like the BEL character (CHR(7)) or something equally as unprintable isn't going to apear in your list, and if you're paranoid just do a check before using the list and pick another delimiter if it is in use. A handy ascii chart... http://www.asciitable.com --- James Sleeman __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Using ... Why?
What it means to you as a developer is essentially that however many queries you do inside a block they will ALL be executed at the same time (well, they won't strictly, but it will look that way to you). Generally you use them to maintain database & query integrit, think of this (most common) example... You have two processes, both are trying to insert into a database table, before they do they must figure out what the next "key" value to use is but querying the database, adding to the key it got from the query and using that in the insert... each process looks like tihs. Query 1 - get key Add to key Query 2 - insert record using key Now let's say process one comes in, it runs query 1 and adds to the key, then the task scheduler kicks in, switches out process one and switches in process two, process two runs query 1 and adds to the key - but because process one hasn't yet run query 2, process two has calculated the same key as process one ! One of those processes has to fail now because you can't have the same key twice. If this was wrapped in a transaction then Query 1 and Query 2 would be grouped togethor, we are assured that they execute "at the same time" and thus there is no way process two can get the same key as process one. The other main reason to use a transaction is if you want to "rollback" to the point before you started the transaction if something goes wrong inside... CF will automatically roll back if it generates an (uncaught) exception - some bad SQL for instance. The level of "locking" that a transaction induces is totally dependant on the database, and some databases do not support transactions at all (MySQL I believe is in this group) leaving all locking up to the developer. - Original Message - From: "Charles Nahm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 7:22 AM Subject: Using ... Why? > Are cftransaction tags necessary for certain types of queries (e.g. queries > involving Merant driver access to a DBaseIII database?). > > I am working with some code from the past and I notice the > tags in some areas but not in others. Recently I have added more > stress/queries to the DBaseIII databases and am noticing big slowdowns in > the processes that require access to those files... > > In: > > http://www.cfcertification.com/cfdocs/CFML_Language_Reference/2_ColdFusion_T > ags/lr2_098.htm > > They say it can be used to group multiple transactions into one single > business event. What does that mean? Does this mean the database will be > locked out until all the functions within the tags are > finished? Is this a requirement for certain types of db's? > > Any help/ideas appreciated, you people have been amazing. Thanks. > > Charles > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
bulk insert to SQL server but not from file
Hi all, I have an old, ugly and large Paradox database that I inherited and am converting into a new, beautiful and large SQL Server (7) driven schema. Problem is the importing of this old database - it takes a VERY long time and i have to watch it like a hawk because invariably the Paradox data is broken beyond belief in places and I have to fix the data or scrap that row or work around it... The reason it takes so long (it's not to do with Paradox itself, those queries get cached), is that the inserting of this data generates, about 500 insert queries per row of data in the old paradox database (it was a big flat file thing more or less, my schema is fully relational), there are just under 1000 rows, that's, 50 inserts ! Not to mention the fact that the SQL server is all the way across the net :-) So, is there any way to do a BULK insert into single tables aside from using "BULK INSERT" itself, which inserts from a file on the SQL server (I don't have access to put files on the SQL server anyway), so that instead of 500 individual inserts per old database row I can just do one insert for each of my new tables (that is insert all the "Education" data for a row in one shot, insert all the "Staff" data in one shot etc) there by reducing the load to maybe 40 "bulk" inserts per row, and the total down to 4 "bulk" inserts (which is still a lot, but not staggeringly). Ideas anybody ? --- James Sleeman Innovative Media Ltd Ph: (03) 377 6262 http://www.websolutions.co.nz CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: InTransaction Function?
Sure, I am in a transaction I am not in a transaction I use it like this on my "action" templates (eg inserting something into a database DO THE DATABASE STUFF On Sat, 2002-04-13 at 10:00, Shawn Grover wrote: > I'm sure I've seen this topic before, but can't seem to find anything in the > archives, or through a google search... > > Is it possible to dynamically determine if the code being processed is in > the middle of a CFTransaction? > > For instance: > > > >Show Message > > > > I make a call to a custom Error Handler tag in a transaction, and need to > know if a RollBack needs to be done or not. I'd rather not have to create a > new attribute/flag for the custom tag, if it's not needed. > > Thanks. > > Shawn Grover > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Trigger and Sequences
> > create table #answtable# ( > FLDUNIQUE_ID number(10), > FLDID number(11), > FLDFIRSTNAME varchar(50), > FLDLASTNAME varchar(50), > > Your create table there looks a little, err, incomplete :-) __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Crosswired queries
> Is their anyway a query refernecing datasource A can affect datasource B? No. Well, not unless you have "linked" A & B somehow, say using linked tables or replication or something like that. > I have a query that sets a group of classes offered by a client to inactive in > datasource A if the date is < today. The client is trying to tell me that this > query is causing the products in datasource B to deactivate. Has antone ever > heard of anything like this on an access database? Have you checked inside B to see if the value you think is changing is actually changed ? Have you tried the same thing as your client to see if it really does happen or if your client was doing something wierd ? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: What IDE are you using for Java CFX?
> What IDE are you folks out there using for developing Java CFX? I am > currently using CF Studio and the command line compiler (pain in the @$$). > I was considering buyin' a copy of JRun Studio, but wanted to see what the > masses think. Thanks! I use RealJ http://www.realj.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: parsing CFML
> And how about those dreaded and HTML tags often scattered throughout cf code. Yea I didn't intend to parse it AS XML, because it's obviously not valid XML (many instances of unclosed tags in CF, and HTML), but I thought somebody might have written a parser that produces a similar interface to the structure of the code as an XML parser would to XML. > I might suggest parsing it with regular expressions instead unless you really need to treat it as XML, or want to handle every single tag that CF can support. I did write something to parse (nested) cfcases, but I thought before i went too far I should check to be sure I wasn't just reinventing the wheel. > Also, what are you going to do with custom tags? Probably not a lot :-) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
parsing CFML
Hi all, this is a bit of a strange request I guess. I want to parse CFML files like they were XML files, so that I can access the structure of the (well formed, no overlapping with html etc) cfml. For example, so that I can do something like I just saw a cfcase, it's value was #parsecf[i].value# and the content of this cfcase is #parsecf[i].contents#... . etc . has anybody done anything like this ?? --- James Sleeman __ 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: Since when was fusebox ever supported or promoted by Allaire / Macromedia?
I've highlighted where they say it. >From the Back Cover Fusebox: Developing ColdFusion Applications is the most complete resource for learning to develop ColdFusion applications with the Fusebox standard. Fusebox is a free web application standard that was created as a standard for writing web applications. * (This methodology is supported and promoted by Allaire/Macromedia.) * The aim of this methodology is to reduce the high failure rate of these applications. If a team of developers uses Fusebox to write ColdFusion applications, the applications will be written more quickly and effectively because they will all code according to the same standard. Fusebox's popularity is growing daily and will grow even more with the next release of ColdFusion. The authors explain concepts such as the Fusebox lifecycle process, testing, and deployment. The appendixes are full of extra Fusebox references and resources. The web site includes databases, files, and code from this book; current enhancements and revisions to the material in this book; links to other Fusebox resources; the latest updates to the core of Fusebox, for any version. - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 3:58 AM Subject: RE: Since when was fusebox ever supported or promoted by Allaire / Macromedia? > > Since when was fusebox ever supported or promoted by Allaire > > / Macromedia? > > To the best of my knowledge, never. > > > http://www.amazon.com/exec/obidos/ASIN/0735712697/qid=10179238 > > 36/sr=1-5/ref=sr_1_5/002-7985215-1486459 > > > > ( According to this listing that just appeared on amazon.com ) > > The way I remember it, Allaire went out of there not to endorse > > or support any methodology. I didn't realize that Macromedia > > had taken an official stance. > > I don't see anything there to indicate otherwise. > > 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 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: DSNless query
I always use - Original Message - From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 10:26 AM Subject: DSNless query > Hello all > > Hoping someone can tell me what I am missing here. > We are running: CF5 NT ACCESS2K > > > > > SELECT DrawingDetails.* > FROM DrawingDetails > WHERE DrawingDetails.ESID=5; > > > > > I get the error: > Error Diagnostic Information > ODBC Error Code = IM002 (Data source not found and no default driver > specified) > > > [Microsoft][ODBC Driver Manager] Data source '' not found and no default > driver specified > > Hint: In order to use ODBC data sources with Cold Fusion you must create the > data source using the Data Sources page of the Cold Fusion Administrator. In > addition, if you are running under Windows NT you must make sure that the > Data Source is created as a System DSN in order for it to be available to > ColdFusion. > > > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (4:1) to (4:68). > > > Date/Time: 04/03/02 15:31:44 > Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) > Remote Address: 137.80.60.254 > > > Thanks for any help > __ 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: Testing Software
> Does anyone know of any software like vmware that will allow for Mac > emulation. From what I understand vmware does not, but does anyone know of > another that does? Best way is to... buy a mac. We have a lone iMac sitting in middle of the office for website testing. And when it's not testing it makes a good (if ugly) MP3 jukebox :-) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: cfmail query acting strange
Sounds like you don't want to use a query with the cfmail (which specifies "who" to send the email body to rather than what to send to a single person) but rather nest a CFLOOP QUERY="" inside your body... ItemPublication #Item_id##Headline#"td> Think about it, if you substitued CFMAIL for CFOUTPUT (as that's the way you thought it worked) would you get the output you want ? No you'd get something like Item Publication 1 Foo Item Publication 2 Blah Item Publication 3 Narf etc... you need to loop -inside- the table -after- the header row to get the correct output. - Original Message - From: "Tristram Charnley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 23, 2002 3:58 AM Subject: cfmail query acting strange > I always thought cfmail with the query attribute acted like query...> What am I doing wrong all of a sudden? CFMAIL is sending multiple > separate emails, one for each record in the query, rather than multiple > records in the one email. > > Whats happened? > > > SELECT item_Id,Headline > FROM Publications > WHERE Item_ID IN (#form.item_id#) > Order By Item_ID > > > from="y" >subject="Publication request" >query="GetPubs" > type="HTML"> > > > ItemPublication > > #Item_id##Headline#"td> > > etc etc > > > > Tristram Charnley > --- > [EMAIL PROTECTED] > Allaire Certified ColdFusion Developer > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: CFSCRIPT & Preservesinglequotes()
Yea this is a really wierd bug that I have encountered also, basically what I see happening is.. when you supply your variable to the UDF - inside a cfquery block CF escapes quotes in the variable before handing to the UDF, and then it takes the value your UDF returns and escapes the quotes again. So your one quote becomes '' when going into the UDF and then coming out of the UDF :-o Two ways to fix it, what I did was unescape the single quotes in the value my UDF gets, so I have something like function myUDF(someValue) { someValue = Replace(someValue, "''", "'", "ALL"); ... do stuff ... return someValue; } or I think you could also use preserve single quotes when passing the value to the UDF, something like... SOME SQL STUFF #myUDF(preserveSingleQuotes(yourVariable))# which should stop the escapement of single quotes when passing yourVariable into myUDF, the single quotes will still be escaped coming out, but that's what you'd expect, if you didn't want that either you could do #preserveSingleQuotes(myUDF(preserveSingleQuotes(yourVariable)))# Whatever way you look at it it's a very wierd thing, it's one thing to escape values being spit out to the database, it's another to escape values when feeding them to a UDF. - Original Message - From: "Sean Daniels" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 5:06 AM Subject: CFSCRIPT & Preservesinglequotes() > I have written a seemingly simple UDF for cleaning up data before an insert > or update statement (it trims the string, inserts null when necessary, wraps > string in single quotes if it's a char field): > > > > function checknull(ii,isint) { > if (isint) { > return iif(len(trim(ii)),de(trim(ii)),de("null")); } > else { > return > iif(len(trim(ii)),de(chr(39)&trim(ii)&chr(39)),de("null")); } > } > > > Basically, my insert statement looks like: > > Insert into tablename (intfield,charfield) > Values (#checknull(intfield,1)#,#checknull(charfield,0)#) > > It works great except for when the charfield contains apostrophes. It > escapes them all and the result is that twice as many apostrophes get > inserted. I know that somewhere in here I should probably be using > preservesinglequotes() but everywhere I attempt to use it in the UDF I get a > JIT compilation error. I also get a JIT if I put the preservesinglequotes > function in the calling template > [preservesinglequotes(checknull(charfield,0))] > > Any suggestions? Please? Unfortunately I used this function all through an > app before finding the bug, so I would be psyched to make repairs to the > function itself not all the code that uses it. > > - Sean > > ~~ > Sean Daniels > Director, Engineering > Marketplace Technologies, Inc > (T): 207.363.7374 > (C): 207.332.6340 > (F): 240.269.6319 > ~~ > http://www.dealforce.com > http://www.mergernetwork.com > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: CF admin password
CF servers on unix machines keep thier own "registry" files, on windows machines they use the windows registry. - Original Message - From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 10:30 AM Subject: Re: CF admin password > I know nothing of UNIX, but I do not believe it has a registry setting. > > > > > "Success is a journey, not a destination!!" > > > > Doug Brown > - Original Message - > From: "Dave Watts" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, March 21, 2002 2:18 PM > Subject: RE: CF admin password > > > > > I am on a Unix System running Apache and I need to > > > reset the CF Admin password for CF 4.5 because it > > > was forgotten can someone tell me how to do this. > > > Please email me off list. > > > > 1. Stop the CF server. > > 2. Edit the registry file (typically /opt/coldfusion/registry/cf.registry). > > 3. Find the entry > > HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword and > > set it to "0". > > 4. Save the registry file. > > 5. Start the CF server. > > 6. Open the CF Administrator - it won't require a password - and enable the > > password, and set the password to the desired value. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > voice: (202) 797-5496 > > fax: (202) 797-5444 > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Getting database structure from Access
Sure, stick the following into a cfm file and give it a whirl, enter a ful path to database (eg d:\foo\bar.mdb) where required. Needs access installed on the CF server machine. Examine A Database Enter the location of a Microsoft Access database on the system. Database : #tableDef.Name# #field.Name# (#field.Type#(#field.Size#), #field.Required# - Original Message - From: "Thane Sherrington" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 4:27 AM Subject: Getting database structure from Access > Is there a way to get database structure (tablenames, column names, and > data types) from an Access database using ColdFusion? > > T > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: HELP NEEDED
I had to do a similar thing once, take some information via CF on an NT machine, and pass it off to a perl script on a Linux machine. The way I did it was to write a daemon in perl (using Net::Daemon module) which just sits listening on a port on the linux box, then I used the TCPCLIENT custom tag on the NT box via CF to connect to the daemon, sned the information and tell the daemon to "do it", the daemon feeds the information to the perl script, and goes back to listening for more connections. - Original Message - From: "Allan Pichler" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 8:32 PM Subject: RE: HELP NEEDED > Well ... the thing is ... I'm not executing any perl scripts from my cf > machine (Win2k with IIS) > > That's exactly what I need . a way for the cf machine to execute a perl > script on another server (FreeBSD) > > Anyone ? > > @llan > > -Original Message- > From: Matthew R. Small [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 5:18 PM > To: CF-Talk > Subject: RE: HELP NEEDED > > Golly... I'm not UNIX expert, but as long as you can find a way to > execute your PERL script from your CF machine (is it Windows or what?) > then you can make CF perform the execution as well. Is there a > webserver running on the other machine? If so, then (and its really not > necessary but keeps you using CF) then you could use CFHTTP to run the > script via the webserver. If you don't want to run a webserver on the > PERL machine and you don't presently have any way of executing the > script from your CF machine then some custom programming is in order. > You might be interested in writing a small application server in java, > C++ or perl that waits for a TCP-IP request and only runs that one > script. It's not terribly hard to write it. I have a good book and can > email you off line with some pointers. > > - Matt Small > > > -Original Message- > From: Allan Pichler [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 11:03 AM > To: CF-Talk > Subject: RE: HELP NEEDED > > Well ... the problem is that the other box is a FreeBSD box! Can I use > cfexecute to solve my problem > > @llan > > -Original Message- > From: Matthew R. Small [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 5:04 PM > To: CF-Talk > Subject: RE: HELP NEEDED > > That is, using CFEXECUTE. > > - Matt Small > > > -Original Message- > From: Matthew R. Small [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 10:59 AM > To: CF-Talk > Subject: RE: HELP NEEDED > > Just thinking here... > Why don't you write a batch file on your CF server that executes your > perl script on the other server? > > - Matt Small > > -Original Message- > From: Allan Pichler [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 10:24 AM > To: CF-Talk > Subject: HELP NEEDED > > I have a little problem guys and i need your help! > > I've made a little perl script that runs every 5 minutes, it checks a > MySQL > DB to see if there's any mailjobs scheduled that needs to be executed. > > If there's jobs in queue it runs another perl script with the id of the > mailjob as an argument. > > Now my problem is this ... I'm making a web interface to setup the > mailjobs, > and in this interface I would like to have a "Test Mailjob" button that > shows a form where the user can specify a test email account to send X > test > mails to. > > How do I get CF to execute a perl script on another server with some > commandline arguments > > Please help out if you can! > > @llan > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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: SUCCESS!!!
A note on that - expandpath, getcurrenttemplatepath and getbasetemplatepath (did I forget any ?) will get you the full path to your files - which can be quite handy stuff to know for advanced applications. #ExpandPath('./')##GetDirectoryFromPath(GetCurrentTemplatePath())##GetDirectoryFromPath(GetBaseTemplatePath())# On Wed, 2002-03-13 at 09:26, [EMAIL PROTECTED] wrote: > Thank you. It worked! > > D- > > Did you try #ExpandPath("filename.gif")#? --- James Sleeman __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Setting a dynamic variable...
> "session.#attributes.CartName#" = StructNew(); > "session.#attributes.CartName#.items = ArrayNew(); > > Which seems to work fine, however if I try the following line: > > "session.#attributes.CartName#.items[1] = "blahblahblah"; > or > > > I get the following error: > > --- > Cannot set dynamic variable with name 'session.myCart.items[1]'. The variable name is illegal. Variable names > must start with a letter and can include only letters, numbers, and underscores. It would be better to treat the session structure as an associative array... session[attributes.cartName] = StructNew(); session[attributes.cartName].items = ArrayNew(1); // Note you missed the 1 in this... session[attributes.cartName].items[1] = "blahblahblah"; that way you get away from that whole hacky way of setting dynamic variables. You could also use setVariable - but I think this way is cleaner personally. --- James Sleeman __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Trim in SQL
- Original Message - From: "Ben Forta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 3:07 PM Subject: RE: Trim in SQL > There is no TRIM(), but there is a RTIM() and a LTRIM(): > > SELECT foo from bar > WHERE RTRIM(LTRIM(narf)) is like 'blah' Thanks, unfortunatly it's not quite the same - it only trims spaces (maybe tabs too, didn't test), not other whitespace like (specifically) CR and LF. I have done the following instead, but it's a bit hacky... Replace(Replace(narf, Char(10), ''), Char(13), '') --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
OT: Trim in SQL
Anybody know if there is a way of doing something like the following with SQL server SELECT foo from bar WHERE TRIM(narf) is like 'blah' --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
get modification date of file via http
Hi all, anybody know if there is a way of getting the modification date of a file without retrieving the entire file using CFHTTP. Essentially what I want to do, in pseudo code is Download file i.e the same thing that a web browser cache might do when requesting file - if the header indicates the URL is newer than the file in the cache, download it, otherwise use the cached version. --- James Sleeman __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Displaying Please wait message during a process
On Sat, 2002-03-02 at 04:11, Mark Leder wrote: > I have a template that I want to display "Please wait" text, then > go > through a CFIndex Process, with a "complete" message when done. > This > is displayed in a pop-up window. I find that when the CF process > > starts, the window goes blank until the process is done, then > displays all the text. I've tried a CFFlush on the "please wait" > > prior to the process, but then the process hangs. I've also > tried > wrapped CFSilent around the process, to no avail. > > What's the right way to do this? CFFLUSH should do the job, but remember some browsers won't display anything until thier buffer is full. The way to do this before CFFLUSH existed was to put an intermediate page in, lets say your long process happens on a form submission - you make the process look like SUBMIT FORM => "PLEASE WAIT" Page => Process Form where you submit the form to the please wait page, which includes a hidden form to pass the data on to the real processing. In the onload of the please wait page you submit the form. Thus the please wait page will hang about on screen until the processing returns it's data. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Regular Expression Help
On Sat, 2002-03-02 at 10:10, Jared Stark wrote: > Hello all. I am trying to write a simple search engine, and would like > to replace certain commonly used prepositions from the search string > such as 'a','the','for', etc... > > I have an array of the prepositions that I would like to remove, however > the problem I have is that it is removing them when they are subsets of > other words, for example 'them' would become 'm' when removing 'the', > 'bag' would become 'bg' when removing 'a', etc... > > I'm not an expert at regular expression, but I'm assuming it is possible > to remove only those instances where the prepositions are stand-alone > and not subsets of other words. Could someone render me some > assistance? If you want to use regular expressions to do it, easiest way would be to use the character class for whitespace before and after your preposition. However don't underestimate the power of the CF list processing functions, think of your search term as a list seperated by whitespace and you can use any of the CF list functions. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Attaching CSS style sheet
the tag should always appear in the section of the generated HTML document, unless your application.cfm also includes this section, putting the in there would cause it to appear outside the section. i.e it's makes for bad HTML. On Sat, 2002-03-02 at 10:06, WebMaster wrote: > What's the problem with referencing the stylesheet in the application.cfm > file? I have done this on several websites and never seen a problem before. > > Here's the code I use: > > > > Is there an issue with doing it this way? > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT : Submit file field form via javascript
At 08:31 PM 2/28/2002, you wrote: >I think it has something to do with the security in the browsers. Yea I think it's to stop you from silently uploading files from the user's machine.. eg onLoad = document.forms[0].fileField.value = 'C:\SomeSecretStuff.txt'; document.forms[0].submit() a real PITA though. >I did a search on it, and found several discussion boards with people >asking about that. >They wanted to use an image though instead of a button to do what you >are wanting to do. >But noone can get it to work, they get access denied. >http://www.siteexperts.com/forums/viewConverse.asp?d_id=7741&Sort=0 Yeah that's more or less what I want to do. Looks like I'm outa luck. >The only way I was able to get it to semi-work was to set the width of >the file field to 80, so it sort of hides the text part, and click on >the browse button. > > > >style="width:80px"> > > I hadn't thought of that. James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
OT : Submit file field form via javascript
Anybody know if there is a way to submit a form containing a file field via javascript whilst retaining the contents of the file field ? IE seems to (I'm presuming for security reasons) not allow this. Specifically what I want to do is... but as soon as the javascript goes to submit the form the contents of Foo get scrubbed. Ideas anybody ? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Bug Tracking Systems
Hi all, I'm thinking about offering a bug tracking system for our clients (during testing stages of course, I'd never have a bug in a production system :-)) for the various jobs they have running with us (i.e we'd have a number of projects with each client that they can open bugs with, but each client may not see another clients projects or bugs). Before I invest energy into reinventing the wheel, does anybody know of any bug tracking systems written in CF that I might be able to massage to fit my needs ? --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: This is cool.. Doable??
At 11:22 AM 2/27/2002, you wrote: >Adam, > > > hmm - wouldn't that also block search spiders as well? I can imagine they > > spider fairly quickly throughout your site. This may be your desired > > functionality however. > >You are right, I guess I could add a simple filter using CGI USER AGENT >and sort out fast/altavista/google and other search engines I know about >(and care about). Spiderhunter.com has data available on the IP's useragents and DNS of spiders around the place, I've used it to do spider detection work in the past (and may do so in the future too when I get around to it :-)). http://www.spiderhunter.com/spiderlist/index.cfm?FuseAction=Results&Key=1470.26536188&SearchEngineIDLink=-1&ReportFormat=1&information=2 James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Recursion of UDFs
At 11:33 AM 2/26/2002, you wrote: >to populate this struct, but my UDF does not continue looping after the >first recursion call. Oh man, I spent most of yesterday debugging a seemingly simple recursive UDF, I was so sure it was all correct, just couldn't work out what was going on. Until I finally realised, that I hadn't created my "local" variables as var localVariable = ""; but instead had just done localVariable = ""; causing, of course, localVariable to in fact be a global variable, so of course, my recursive calls were thoroughly munging what I thought were untouchable local variables, causing all manner of mayhem. Oh for compiler warnings :-) James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
joining arrays
Hi all, anybody know if there is a nicer way of joining arrays in CF than i = 1; while (i lte arrayLen(secondArray)) { arrayAppend(firstArray, secondArray[i]); }; James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: SQL trickyness
At 08:50 PM 2/22/2002, you wrote: >What about this hack? > >SELECT TOP 1 > (SELECT TOP 1 TipID > FROM TIPS > WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLink# > ORDER BY TipTitle ASC) As FirstTip, > (SELECT TOP 1 TipID > FROM TIPS > WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLink# > ORDER BY TipTitle DESC) As LastTip >FROM TIPS > >I tried the Last() and First() functions and they didn't work in Query >Analyzer (on 7 and 2K). Weird. Ahhh, I didn't think of that, brilliant :-) __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: SQL trickyness
At 04:12 PM 2/22/2002, you wrote: >James, > >Rather than using Last() and First(), try Max() and Min(). Also, try adding >in a GROUP BY clause. Adding it in always seems to fix the error messages >about aggregate functions. Min and Max will give me the minimum and maximum values without regard to where they occur in the recordset, I want the first and last values as they appear in the recordset eg if the select gives a recordset like [ID][TITLE] 1Bar 3Foo 2Goop I want to get [MinimumID][MaximumID] 1 2 using a group by would give me [MinimumID][MaximumID] 1 1 3 3 2 2 (because titles are unique). James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: SQL trickyness
It goes away but it won't give me what I want - I effectively want one group, that would give me as many groups as there are unique tiptitle values ? At 04:22 PM 2/22/2002, you wrote: >Whenever you use aggregate functions in SQL, you need to add a group >by >clause that contains the fields that you're not aggregating on. That > would >be stuff in your select and in the order by. So, add a "group by Tip >Title" >before the order by and your error should go away. > >-Original Message- >From: James Sleeman [mailto:[EMAIL PROTECTED]] >Sent: Thursday, February 21, 2002 8:01 PM >To: CF-Talk >Subject: SQL trickyness > > >Hi all, > trying to do a little funky SQL to get the minimum and maxim >um >ID's with respect to a sort order on a table but I'm getting an acces >s >error, cam anybody see what is wrong with my sql here... > >DBTYPE="#CFG.DBTYPE#" NAME="Q_Tips"> > SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP > FROM TIPS > WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLi >nk# > ORDER BY TipTitle ASC > > > > >Error Diagnostic Information >ODBC Error Code = S1000 (General error) >[Microsoft][ODBC Microsoft Access Driver] You tried to execute a quer >y that >does not include the specified expression 'TipTitle' as part of an >aggregate function. >SQL = "SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP > FROM >TIPS WHERE TipTipCategoryLink = 1 ORDER BY TipTitle ASC" >Data Source = "" >The error occurred while processing an element with a general identif >ier of >(CFQUERY), occupying document position (20:2) to (20:104) in the temp >late >file >D:\JOBS\WEB-FUSION\WEBSHOPCODEBASE\_MIRROREDFILES\BFD5C5FB051709B72C9 >FF321B6 >2A465C\PLUGIN_SHOWSTUFF\QRY_SHOWTIP.CFM. >Date/Time: 02/22/02 16:02:18 >Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) >Remote Address: 10.10.10.105 >Query String: >FuseAction=showTip&TipID=7&CFID=6778&CFTOKEN=31983074&ForceUp >date=1 > > > > >James Sleeman >Innovative Media Ltd >Phone: (03) 377 6262 >http://www.websolutions.co.nz/ > >CAUTION: The information contained in this email message is confident >ial >and may be legally privileged. If the reader of this message is not t >he >intended recipient you are notified that any use, dissemination, >distribution or reproduction of this message is prohibited. If you ha >ve >received this message in error please notify the sender immediately a >nd >destroy the original message and any attachments. > >Views expressed in this communication may not be those of Innovative >Media >Ltd. >_ >_ >Get Your Own Dedicated Windows 2000 Server > PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > Instant Activation · $99/Month · Free Setup > http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb >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 > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
SQL trickyness
Hi all, trying to do a little funky SQL to get the minimum and maximum ID's with respect to a sort order on a table but I'm getting an access error, cam anybody see what is wrong with my sql here... SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP FROM TIPS WHERE TipTipCategoryLink = #Q_Tip.TipTipCategoryLink# ORDER BY TipTitle ASC Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'TipTitle' as part of an aggregate function. SQL = "SELECT Last(TIPID) AS MaximumTIP, First(TIPID) AS MinimumTIP FROM TIPS WHERE TipTipCategoryLink = 1 ORDER BY TipTitle ASC" Data Source = "" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:2) to (20:104) in the template file D:\JOBS\WEB-FUSION\WEBSHOPCODEBASE\_MIRROREDFILES\BFD5C5FB051709B72C9FF321B62A465C\PLUGIN_SHOWSTUFF\QRY_SHOWTIP.CFM. Date/Time: 02/22/02 16:02:18 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 10.10.10.105 Query String: FuseAction=showTip&TipID=7&CFID=6778&CFTOKEN=31983074&ForceUpdate=1 James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Dynamic Include
At 10:24 AM 2/20/2002, you wrote: > > What is the best way to allow someone on another Web server > > which will not > > necessarily have CF on it to imbed a call to a CF page on my > > server. Where > > my page would do some database lookups and return some HTML > > that would be > > imbedded in the original page (not a redirect). > >Lee, > >You could do this: > > http://www.yourdomain.com/filename.cfm"</A>;> > >where filename.cfm would use cfcontent to set headers that would trick the >browser into thinking it was a JavaScript file, and then use valid >JavaScript in that file to write the content to the screen. It can be a >chore converting your CF output to valid JavaScript, however. Wouldn't you just catch all the output of your template (CFSAVECONTENT in CF5, make a custom tag previously) and use JSStringFormat() to convert to javascript ? eg... This Is A Page Foo Bar Bar Foo Any stuff you want in here, cf stuff, html stuff, whatever... <CFOUTPUT>document.write("#JsStringFormat(TheRealOutput)#"); James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Query of Query problem
Anybody know if this is a known bug in CF ? This query SELECT * FROM Q_Table WHERE FrWMin <= #Weight# AND ((FrWMax > #Weight#) OR (FrWMax = '')) produces a single row with value of 15.0 in the FrZWPrice field but this query SELECT Max(FrZWPrice) AS Price FROM Q_Table WHERE FrWMin <= #Weight# AND ((FrWMax > #Weight#) OR (FrWMax = '')) ignores the where clause and simply returns the maximum FrZWPrice, which in this instance is 55.0 James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Getting locale's date format
Hi all, is there any way to get a string representation of the currently set locale's date format, ie something like "dd/mm/" or "mm/dd/". Seems that I can parse dates in the locale's date format but you can't find out programattically what that date format is. I want to do soemthing like... Please enter dates in #GetLSDateFormatString()# format. --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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:Pausing execution
"Kay Smoljak" <[EMAIL PROTECTED]> wrote on 2/12/2002 4:46:30 PM: >Has anyone used this tag? I don't mind forking out the $5 (actually $10 >in Australian pesos) but does it really work? Does anyone have a better >way of delaying the user for a certain amount of time? I would use a deadlock situation to my advantage... the first lock will obtain fine, the internal lock won't be able to because DummyLock is already locked, after 2 seconds it will timeout without an error and continue on it's merry way. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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:[2] Jeremy Allaire interview on DevX
Jon Hall <[EMAIL PROTECTED]> wrote on 2/8/2002 6:24:23 PM: > >stas wrote: >> So you want to design your GUI in Flash > >I want to design a GUI with the tool that gives me the most power, with > the least amount of code. It would take considerably longer I believe to implement a competent gui in flash than to hand code in your toolkit of choice in compiled/interpreted language (eg Swing on Java, GTK in C, TK In Tcl, wxWindows in Python). >> re-invent every little widget? >It's called originality. Take an html select box widget for example. It >takes almost no code to create and stlye to create any kind of look >compared to what it takes to create in say CSharp, which I have been >working with lately. I long for style sheets when doing a form >component, just because it's what I'm used too. It's called consistency, and that is the driving force behind toolkits in the first place, it is much easier for the user if one programs "checkbox" looks and works the same as other program's checkboxes. Not to mention that it vastly increases code reuse and helps to enforce a modular approach for the engineer. Flash isn't designed to be an interface toolkit, it is designed to deliver animation and whizzy interactive things, let it do what it's best at, leave the interface display to the various libraries designed to be interface toolkits (and in the case of web sites, to the HTML). --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
OT: OBJECT tag for java plugin and IE
Hi all, I have a system where I have a large amoutn (or will have a large amount :-)) of "distributed front ends" to ecommerce sites, they basically consist of images, and a couple of dummy fusebox files that call a set of shared code sitting away on another server. Anyway, I want to add a java applet I have written into an area of the system, but my problem is that I don't want to have to put the JAR files in with the front-end code. So I thought I'd do something like... http://java.sun.com/products/plugin/1.1.2/jinstall-112-win32.cab##Version=1,1,2,0";> that's obviosuly the OBJECT tag for getting the java plugin in IE to run my applet, notice the codebase, I'm telling it to get the jar files from this "directory" (which is really a search-engine-friendly url to a fuseaction that will do a cfcontent to return the requested jar file). Now, while this works fine in mozilla (with an equivalent applet tag instead of the object tag), IE just doesn't like it. Does anybody have any idea why this wouldn't work ? NB: I've tested the applet in IE and it works fine, it's just when I try and reference the jars in this manner that it fails. --- James Sleeman __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
ReReplace(NoCase) maximum length
Hi All, anybody know if there is a maximum length on the string passed to ReReplace(NoCase) ? Reason I ask is that I am running the following ReReplaceNoCase(trim(text), "^(.*)$", "\1"); and when the string in text is above a certain length (don't know how long exactly) the code fails with an Invalid regular expression message. I cut the offending text in half (it's comign from a database field (the data in the field is fine, all there, all returned in query)) and each half goes through just fine, but put em togethor and I get the error. Hopefully the "designers" won't mind me splitting thier page into two (stupidly long anyway) :-) --- James Sleeman __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
little OT, getting DataTypeEnum from DAO
Hi all, I'm doing a little experimentation with getting table & field information from Access using some code Brendan Avery posted (RE: SQL for grabbing list of tables in DB / fields in table?). My intention is to use this information to further automate the creation of administration systems. Anyway, I've got it sussed to the point of being able to get the table names, field names, types, sizes, wether they are required etc, however the types are defined as an integer which is identified by a DAO constant. Now, I know nothing really about this whole COM business, I used "Object Browser" in access and found DAO.DataTypeEnum holds all these constants, but how do I get that information into CF ? Here is the code as it stands... #tableDef.Name# #field.Name# (#field.Type#, #field.Size#, #field.Required#) Anybody here a COM guru :-) __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Quick cfdirectory ?...
At 03:01 PM 12/12/2001, you wrote: >Is it possible to keep the "Dir" Types out of my query for cfdirectory? >With a filter maybe? This is what I got's: > >directory="#request.Path.FileDir#filez\"> > >and it returns: > >".", "..", "file01", "file02", "file03", etc. Can I throw a filter >attribute on the cfdirectory? I can figure out how to make it return all >the *.wma files, but I can't figure out how to just give me back Type=File, >(Type is a returned column when using cfdirectory) and not the Type=Dir. >And I've got it doing basically what I want, which is excluding the Dir >Types, with some cfifs, but I'd rather leave them out of the over all >picture. Any assistance would be greatly appreciated... Mmm, I don't think there is a way to do it directly with the cfdirectory tag. If you are runing CF5, you can just do a query of the query that cfdirectory returns to get all the type='file' or type='dir' records. If you are not yet on CF5 you could build another query manually (using combinations of queryNew(), queryAddRow(), querySetCell()) from the query that cfdirectory returns, opnly inserting those rows you want (i.e where type eq "file"). James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: Templates executing twice CF bug
Ok, here is what I see is hapenning in this situation (and it is NOTHING to do with CF or IIS or anything server side here), quite simple... let's take for exampl the _URL_) you are using in the src of your img tag it has a bit before the first # which in this case is an empty string, and a bit after the first # which isn't important for now. What does this remind you of perhaps something like foo (by now you probably see your error but I'll continue for those who it is not obvious to). What that anchor does is tells your browser to get blah.htm and display it from the point in the document that the anchor named someAnchor appears. You canm just as easily write foo which tells the browser to go to the point in the document where the anchor someAnchor appears. Both of these are valid URLS. The src in an image tag takes a valid URL. So in your example img tag below, when the browser gets that (the hashes come through because there is no cfoutput around it) it reads that as "load the image from the current document at the point where the anchor "variables.someVariable#/test.gif" is written" (which of course makes no sense, but the browser doesn't care, all it wanted was a URL and you gave it a URL), it does it's duty, the img tag causes the template to be hit again, and when it gets the results it tries to the anchor you specified (which of course doesn't do anything because not only does the anchor not exist, but that file isn't an image either). Now of course this may not happen on all browsers, mainly because if they are clever enough they will not have to actually hit the server to get the same file they are looking at, and if they are really clever enough they will know that an anchor specification inside an img src is nonsense and will ignore it. Nothing mystical, just not an expected behaviour on behalf of web browsers. At 05:29 PM 12/11/2001, you wrote: > James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: MS Access: True/False Questions
First IANAL (nor have I actually read the GPL in a long time), but the way I understand it. They are completely within their rights to sell a closed-source version of their software if they wish to do so. Them releasing a GPL'd (is it GPL'd?) version does not in any way prohibit them from also releasing a closed-source version - it's their software. Likewise they could just as easy stop releasing the GPL'd version and start releasing a closed version instead. The only caveats are... if there is source from contributing developers then that source remains the contributing developer's source licensed by the license the contributing developer released it under (ie GPL, wether directly or indirectly through becoming part of the GPL'd mySQL) and as such the company would have to either not include the contributed code or obtain a different license for said code from the contributing developer, and if they were to withdraw the GPL'd version from release existing copies in the world remain GPL'd (and thus a source fork would likely begin). Of course this is all totally OT. So to bring it back some, when I was playing with CF on linux I looked at using mySQL but the limitations (especially on no sub-selects which is something I use often and am not willing to give up without a fight !) were too great, postgres on the otherhand worked very well, nice and fast, I've heard that the Vacuum() procedure which must be run periodically can be a bit of a pain - tying up the database for inordinate amounts of time, but I guess replication or something could get around that for large scale sites. And of course it's free :-) At 01:35 PM 12/6/2001, you wrote: >If MySQL was allowed to sell a closed version of it's software, instead of >having to sell overpriced support contracts it would be much more >successful. -- James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: MAC File Upload Issues
As I remember IE on the Mac messes up when uploading files, I had the same problem a couple of years ago and found no solution. Use Netscape to upload files and your problems will disappear :-) >I'm uploading a file via CFFILE and the code works flawlessly - until you >get onto a MAC (IE5) -- James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
BUG In CF5, is it known ?
I had an old client come to me with a bug today. The server was upgraded to CF5 a while ago and this bug seems to be related to that... basically I was using a variable called "Arguments", and it was producing an "unknown exception" from CF, simply changing the variable to be called "Argies" fixed the problem - after an hour of bug hunting of course ! So, this doesn't work... while this one does... it's all in a standard single file template, not fusebox, nothing fancy happening, just a simple file. The error message that CF produced wasn't helpful at all basically claiming that an unknown exception occurred but didn't say where. Arguments is the array used within a UDF, seems wierd that it shoudl cause problems OUTSIDE of CFSCRIPT let alone UDF's. -- James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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