RE: Regex help
Oops, you're right, this is what I should have said: [^c]at That matches any AT except CAT Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:25 PM To: CF-Talk Subject: Re: Regex help >>but not in CAT or CATalog or CATastrophe, etc. Neither tattoo, in [^cat] any of c, a or t may not precede at. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: XML Question
> Cool! I'd love to be able to take advantage of these methods, but I don't > know squat about Java. > > So, how do you call these methods from within CF? Any examples you can > point me to? Well, in order to turn an XML string into a DOM object you could use this: http://www.cfmentor.com/code/index.cfm?action=script&id=127 Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: XML Question
Cool! I'd love to be able to take advantage of these methods, but I don't know squat about Java. So, how do you call these methods from within CF? Any examples you can point me to? -Brad -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 12:02 AM To: CF-Talk Subject: RE: XML Question > Get the children of an element, easy... get the parent of an > element, I have > no clue... CFMX allows basic xml parsing in the simplest form(i.e array and structs) If you are trying to accomlish XML Parsing in the Popular or Best ways.. I suggest you use XML DOM Parsing with Java. You have alot functions like getParentNode(), getChildNode etc to accomplish tasks easier.. Here is some documentation on XML Node http://java.sun.com/j2se/1.4.1/docs/api/org/w3c/dom/Node.html Joe Eugene > -Original Message- > From: Brad Roberts [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:29 AM > To: CF-Talk > Subject: RE: XML Question > > > Let me re-ask my question... > > What's the best way to insert a child element under id="2">, when you > don't know where it's at in the XML doc? All you know is that it has an > attribute "id" and the value is "2". > > Another thought (along the same lines), if you wanted to show the > ancestors > of a specific element, how would this be accomplished? An > example would be > displaying "breadcrumbs". Again, all you would know is the page > id. Would > this require a recursive udf/tag? And if so, how do you get the parent > element of a given element. I can't find this anywhere in the docs (or > web). > > Get the children of an element, easy... get the parent of an > element, I have > no clue... > > Thanks, > > Brad > > -Original Message- > From: Joe Eugene [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 12:28 AM > To: CF-Talk > Subject: RE: XML Question > > > Do an xml search for the attribute with XPath.. > xmlSearch(xmlDocObject, "Pages/[EMAIL PROTECTED]'2']"); > > Or Iterate through the node to find "id=2" > > Joe Eugene > > > > -Original Message- > > From: Brad Roberts [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 10, 2003 8:15 PM > > To: CF-Talk > > Subject: XML Question > > > > > > Give the following XML, how can I get the full path to a given element? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Let's say I want to add a child element under page "2", but I don't know > > where 2 falls in the xml object. All I know is I want to insert a child > > under the page with ID "2". > > > > Any ideas? > > > > Thanks, > > > > Brad > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
oi Stacy!! that would probably have been homesite (not homesite+) -- Friday, September 12, 2003, 12:02:09 AM, you wrote: SY> I could have sworn someone posted a link to buy it separately for SY> $99...or was I dreaming? ;) SY> Stace SY> -Original Message- SY> From: Critz [mailto:[EMAIL PROTECTED] SY> Sent: September 11, 2003 11:59 PM SY> To: CF-Talk SY> Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? SY> oi jonhall!! SY> dun believe so. SY> it comes on the dwmx disc... --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
I think that is the non + (-+? :)) version... Is there actually anything new in 5.5+? There didn't seem to be anything in 5.5 according to the page for it. $200 is a lot to ask for Homesite+ upgrade imo. Of course, if there is nothing new, I wont bother. -- mailto:[EMAIL PROTECTED] Friday, September 12, 2003, 12:02:09 AM, you wrote: SY> I could have sworn someone posted a link to buy it separately for SY> $99...or was I dreaming? ;) SY> Stace SY> -Original Message- SY> From: Critz [mailto:[EMAIL PROTECTED] SY> Sent: September 11, 2003 11:59 PM SY> To: CF-Talk SY> Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? SY> oi jonhall!! SY> dun believe so. SY> it comes on the dwmx disc... ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
That was Homesite standard. -Kevin - Original Message - From: "Stacy Young" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 11:02 PM Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver? > I could have sworn someone posted a link to buy it separately for > $99...or was I dreaming? ;) > > Stace > > -Original Message- > From: Critz [mailto:[EMAIL PROTECTED] > Sent: September 11, 2003 11:59 PM > To: CF-Talk > Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? > > oi jonhall!! > > dun believe so. > > it comes on the dwmx disc... > > > -- > > > > Thursday, September 11, 2003, 11:46:54 PM, you wrote: > > jon> I own Studio MX, but I don't want to pay the $200 for the DW > upgrade > jon> just for Homesite+. Is there any other option? > > > > --- > [This E-mail scanned for viruses by Declude Virus] > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: count and strip words from string.
Try (and adapt) this: SELECT myColumn FROM myTable WHERE #oper# myColumn LIKE '%#word#%' ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Any way to get Homesite+ 5.5 without Dreamweaver?
I could have sworn someone posted a link to buy it separately for $99...or was I dreaming? ;) Stace -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: September 11, 2003 11:59 PM To: CF-Talk Subject: Re: Any way to get Homesite+ 5.5 without Dreamweaver? oi jonhall!! dun believe so. it comes on the dwmx disc... -- Thursday, September 11, 2003, 11:46:54 PM, you wrote: jon> I own Studio MX, but I don't want to pay the $200 for the DW upgrade jon> just for Homesite+. Is there any other option? --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: XML Question
> Get the children of an element, easy... get the parent of an > element, I have > no clue... CFMX allows basic xml parsing in the simplest form(i.e array and structs) If you are trying to accomlish XML Parsing in the Popular or Best ways.. I suggest you use XML DOM Parsing with Java. You have alot functions like getParentNode(), getChildNode etc to accomplish tasks easier.. Here is some documentation on XML Node http://java.sun.com/j2se/1.4.1/docs/api/org/w3c/dom/Node.html Joe Eugene > -Original Message- > From: Brad Roberts [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:29 AM > To: CF-Talk > Subject: RE: XML Question > > > Let me re-ask my question... > > What's the best way to insert a child element under id="2">, when you > don't know where it's at in the XML doc? All you know is that it has an > attribute "id" and the value is "2". > > Another thought (along the same lines), if you wanted to show the > ancestors > of a specific element, how would this be accomplished? An > example would be > displaying "breadcrumbs". Again, all you would know is the page > id. Would > this require a recursive udf/tag? And if so, how do you get the parent > element of a given element. I can't find this anywhere in the docs (or > web). > > Get the children of an element, easy... get the parent of an > element, I have > no clue... > > Thanks, > > Brad > > -Original Message- > From: Joe Eugene [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 12:28 AM > To: CF-Talk > Subject: RE: XML Question > > > Do an xml search for the attribute with XPath.. > xmlSearch(xmlDocObject, "Pages/[EMAIL PROTECTED]'2']"); > > Or Iterate through the node to find "id=2" > > Joe Eugene > > > > -Original Message- > > From: Brad Roberts [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 10, 2003 8:15 PM > > To: CF-Talk > > Subject: XML Question > > > > > > Give the following XML, how can I get the full path to a given element? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Let's say I want to add a child element under page "2", but I don't know > > where 2 falls in the xml object. All I know is I want to insert a child > > under the page with ID "2". > > > > Any ideas? > > > > Thanks, > > > > Brad > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Any way to get Homesite+ 5.5 without Dreamweaver?
oi jonhall!! dun believe so. it comes on the dwmx disc... -- Thursday, September 11, 2003, 11:46:54 PM, you wrote: jon> I own Studio MX, but I don't want to pay the $200 for the DW upgrade jon> just for Homesite+. Is there any other option? --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Any way to get Homesite+ 5.5 without Dreamweaver?
I own Studio MX, but I don't want to pay the $200 for the DW upgrade just for Homesite+. Is there any other option? -- mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: count and strip words from string.
> > > > ',search,firstWordBreak)> > > > > ',search,secondWordBreak)> > > > > ',search,thirdWordBreak)> > > >got it. > > >thats what ill do, then mid the strings out, and build the dynamic query >based on the presence of a 1st, 2nd, 3rd, or 4th word that may be there, >should i make them separate by commas, since st. anne would return, st. >joseph as well as many other possibilities, but if i make them separate >by commas, then ill be good, cause they will be separating it >themselves, and then i can just find commasmore reliable i think. >huh? > A few things: 1) You might be better off finding a different delimiter if you use your solution and are expecting search terms like "St. Anne's". 2) You'd probably be better off treating the search terms as a list with a space as a delimiter instead of the find() function, i.e.: SELECT myColumn FROM myTable WHERE 0 = 0 AND myColumn LIKE %#term#"% This way you don't have to worry about how many search terms are entered, which your proposed solution seems to be (i.e., "firstWordBreak", etc.) 3) Though not related to breaking up the search terms, why not use Verity? I think you'll find that the performance and accuracy of your results are enhanced by creating a collection that's populated by the results of a database query. Regards, Dave. _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Repost: SQL Help
> Maybe you should try to explain in words what you are trying to > achieve, because I am getting the impression that the code is > much more complicated then what is actually needed. > I'll try. I warn you, I'll likely end up muddying the issue. A patient's records are stored throughout many tables in the db. For the most part it is one row per patient record. Sometimes, in some tables, there can be multiple records per patient record. I have to flatten the patient record into a text file. The format the text file takes is spec'ed out by a third party and it is what I have to conform to. It turns out that this text file does not expect there to be multiple records per patient record... ever. So I have to query the database and deal with the cases where I have multiple records, but I have to flatten them into one. I can think of two ways to do it in theory... but I don't know how to make it work in SQL in practice. 1) Somehow cause the query to only return the Top 1 record per primary key. That wold be acceptable, but I have no idea if its a legal idea. 2) Somehow, through subqueries, aggregate the multiple values when they appear. That is what I was attempting to do in the question I originally posted. The Case statement works fine unless I hit a record with multiple rows. It returns both rows and that violates my parameters. I'm trying to get this done in as few [cfquery] calls as I can, to limit complexity and hopefully limit the amount of time the entire application will take to parse through everything > >> Cannot perform an aggregate function on an expression containing an >> aggregate or a subquery > > What database are you using? > > Jochem > SQL Server 2000 -Patti ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: count and strip words from string.
got it. thats what ill do, then mid the strings out, and build the dynamic query based on the presence of a 1st, 2nd, 3rd, or 4th word that may be there, should i make them separate by commas, since st. anne would return, st. joseph as well as many other possibilities, but if i make them separate by commas, then ill be good, cause they will be separating it themselves, and then i can just find commasmore reliable i think. huh? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:17 PM To: CF-Talk Subject: count and strip words from string. lets say, a user enters "skateboarding atlanta half-pipe" and you wanted to break that up into separate words, and know that there should be 3 "...or searchTerm like '%wordHere%'" sections in a query (one for each word) so that the user can search for "skateboarding or atlanta or half-pipe" through a sql statement. is this feasible, i know it has to be, just cant think past my keyboard right now. thanks for any ideas tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
count and strip words from string.
lets say, a user enters "skateboarding atlanta half-pipe" and you wanted to break that up into separate words, and know that there should be 3 "...or searchTerm like '%wordHere%'" sections in a query (one for each word) so that the user can search for "skateboarding or atlanta or half-pipe" through a sql statement. is this feasible, i know it has to be, just cant think past my keyboard right now. thanks for any ideas tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Weird CFMX install quirk (another)
After the install on win2003 CFMX is in English while JRun is in French...?!?! lol I speak it so its no big deal but I'd rather not have it lol, anyone know how to change it? Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
SSL question
Any easy way of carrying session info from SSL page to non SSL? I recently set up SSL for some high level pages. I want to include 'regular' port 80 pages in the mix but I am losing session vars when moving from SSL to regular. Anything I can append to the link to trick it? Thanks, Dave ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: How Many CFMX Instances?
On Thursday, Sep 11, 2003, at 17:56 US/Pacific, Ben Forta wrote: > Not sure that I agree with the "not to have more instances that you > have > CPUs" statement. I think that an "it depends" is the right answer. Hence my caveat: "You'd need to experiment, performance-wise..." :) > I have one dual CPU box that runs 6 low to medium volume sites, and I > have each in a separate instance, and it runs perfectly. Yep, I'd hope so. Do you know if you get better performance with that setup vs a single instance for those six sites? (Not that it's relevant if you're getting acceptable performance with your current config). > There is overhead per instance, memory an CPU cycles too. The correct > number of instances is going to be based more on what you consider to > be > appropriate performance for your applications than anything else. Yep. Lots of performance experimentation needed to fine tune things. Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: How Many CFMX Instances?
Oh and each instance is clustered to it's twin on the other machine. (sticky session round robin) I also did an initial load test (somewhat of a hack job but). I was impressed...while I eventually overwhelmed the server (100% CPU)...it recovered nicely afterwards. CF4.5 and CF5 never did...once they flat lined that was it...restart. Stace -Original Message- From: Stacy Young Sent: September 11, 2003 9:18 PM To: '[EMAIL PROTECTED]' Subject: RE: How Many CFMX Instances? It appears an idle instance hovers at about 65mb RAM from what I've seen on various installs. Our config is 2 single CPU boxes with 2 instances on each. Each machine: 1 x 256mb RAM (medium volume site) 1 x 128mb RAM (low volume site) Admin server is off in prod On winblows boxes (say that 10x fast lol) it takes a little extra work to get the CFMX/JRun install all nice...but man it runs great once ur done! Heads up for those of you attempting to install JRun4 (separate jrun, not the one from CMFX bits) then CFMX 6.1 EAR files...the Underlying Jrun that comes *with* CFMX is actually a later build than the latest available JRun4 solo version. I ran into connector issues doing this and was advised from their engineers to reinstall. Setting up separate JVMs is a little cumbersome especially if u want them to startup as services (do not modify jvm settings via jrun admin afterwards)...but it's still doable. Just a few command lines and u rollin'. Stace -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: September 11, 2003 8:56 PM To: CF-Talk Subject: RE: How Many CFMX Instances? Sean, Not sure that I agree with the "not to have more instances that you have CPUs" statement. I think that an "it depends" is the right answer. I have one dual CPU box that runs 6 low to medium volume sites, and I have each in a separate instance, and it runs perfectly. There is overhead per instance, memory an CPU cycles too. The correct number of instances is going to be based more on what you consider to be appropriate performance for your applications than anything else. --- Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:40 PM To: CF-Talk Subject: Re: How Many CFMX Instances? On Thursday, Sep 11, 2003, at 10:13 US/Pacific, Demarco, Alex wrote: > What is a good rule of thumb as to how many jrun/CFMX instances you > need? > > We have one instance that handles all our web sites, should I break it > down > and split the sites amongst several instances? It depends on a number of factors. If you want robustness (so one website doesn't trample on another) then yes, multiple instances will help - and give you a separate CF Admin for each instance. But you also need to consider the number of CPUs and the amount of RAM on your server (assuming you're talking about everything on one server). You'd need to experiment, performance-wise, but I'd say not to have more instances that you have CPUs for example. We have two instances (each with a 2-3Gb JVM heap) on each of our 8 CPU, 8Gb RAM servers but then we're running a very high traffic site (up to 20,000 concurrent sessions during peak traffic). Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: How Many CFMX Instances?
It appears an idle instance hovers at about 65mb RAM from what I've seen on various installs. Our config is 2 single CPU boxes with 2 instances on each. Each machine: 1 x 256mb RAM (medium volume site) 1 x 128mb RAM (low volume site) Admin server is off in prod On winblows boxes (say that 10x fast lol) it takes a little extra work to get the CFMX/JRun install all nice...but man it runs great once ur done! Heads up for those of you attempting to install JRun4 (separate jrun, not the one from CMFX bits) then CFMX 6.1 EAR files...the Underlying Jrun that comes *with* CFMX is actually a later build than the latest available JRun4 solo version. I ran into connector issues doing this and was advised from their engineers to reinstall. Setting up separate JVMs is a little cumbersome especially if u want them to startup as services (do not modify jvm settings via jrun admin afterwards)...but it's still doable. Just a few command lines and u rollin'. Stace -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: September 11, 2003 8:56 PM To: CF-Talk Subject: RE: How Many CFMX Instances? Sean, Not sure that I agree with the "not to have more instances that you have CPUs" statement. I think that an "it depends" is the right answer. I have one dual CPU box that runs 6 low to medium volume sites, and I have each in a separate instance, and it runs perfectly. There is overhead per instance, memory an CPU cycles too. The correct number of instances is going to be based more on what you consider to be appropriate performance for your applications than anything else. --- Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:40 PM To: CF-Talk Subject: Re: How Many CFMX Instances? On Thursday, Sep 11, 2003, at 10:13 US/Pacific, Demarco, Alex wrote: > What is a good rule of thumb as to how many jrun/CFMX instances you > need? > > We have one instance that handles all our web sites, should I break it > down > and split the sites amongst several instances? It depends on a number of factors. If you want robustness (so one website doesn't trample on another) then yes, multiple instances will help - and give you a separate CF Admin for each instance. But you also need to consider the number of CPUs and the amount of RAM on your server (assuming you're talking about everything on one server). You'd need to experiment, performance-wise, but I'd say not to have more instances that you have CPUs for example. We have two instances (each with a 2-3Gb JVM heap) on each of our 8 CPU, 8Gb RAM servers but then we're running a very high traffic site (up to 20,000 concurrent sessions during peak traffic). Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CMFX 6.1 much better
Yep. Fast and reliable here. Stace -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: September 11, 2003 8:48 PM To: CF-Talk Subject: CMFX 6.1 much better Since I usually only post when I have a problem, I wanted to take a second and say that since upgrading to CFMX 6.1 many of the server stability issues I was having have gone away and are running much better. Have others also found better stability and speed with 6.1? Brook ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CFMX6.1 Install Issue on Win2003
I downloaded twice from MM. Both bad bits. Just copied from local PC over VPN to the server (older 6.1 final). Works just fine. Anyway thanks! Stace -Original Message- From: Stacy Young Sent: September 11, 2003 7:39 PM To: CF-Talk Subject: RE: CFMX6.1 Install Issue on Win2003 Tried that, no go. :( There's plenty of disk space to...very weird. -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: September 11, 2003 5:58 PM To: CF-Talk Subject: Re: CFMX6.1 Install Issue on Win2003 C;\TEMP is what I put in == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Stacy Young" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 4:50 PM Subject: CFMX6.1 Install Issue on Win2003 | The installer keeps prompting me to find another place where it can | extract itself. | | "Please select a location where to extract the installer to" | | Any ideas appreciated! | | Stace | | | AVIS IMPORTANT: | --- | Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.. | | WARNING: | --- | The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. | | ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: How Many CFMX Instances?
Sean, Not sure that I agree with the "not to have more instances that you have CPUs" statement. I think that an "it depends" is the right answer. I have one dual CPU box that runs 6 low to medium volume sites, and I have each in a separate instance, and it runs perfectly. There is overhead per instance, memory an CPU cycles too. The correct number of instances is going to be based more on what you consider to be appropriate performance for your applications than anything else. --- Ben -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 8:40 PM To: CF-Talk Subject: Re: How Many CFMX Instances? On Thursday, Sep 11, 2003, at 10:13 US/Pacific, Demarco, Alex wrote: > What is a good rule of thumb as to how many jrun/CFMX instances you > need? > > We have one instance that handles all our web sites, should I break it > down > and split the sites amongst several instances? It depends on a number of factors. If you want robustness (so one website doesn't trample on another) then yes, multiple instances will help - and give you a separate CF Admin for each instance. But you also need to consider the number of CPUs and the amount of RAM on your server (assuming you're talking about everything on one server). You'd need to experiment, performance-wise, but I'd say not to have more instances that you have CPUs for example. We have two instances (each with a 2-3Gb JVM heap) on each of our 8 CPU, 8Gb RAM servers but then we're running a very high traffic site (up to 20,000 concurrent sessions during peak traffic). Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Basic CFC method design question.
On Thursday, Sep 11, 2003, at 14:36 US/Pacific, Ian Skinner wrote:
> Generally which is better, a single method with branching logic based
> on a
> parameter, or separate methods? Or is there no really difference and
> depends
> on the personal choice and the situation.
It depends. In the example you give where your logic is of the form:
{dosomeinitialprocessing}
{donormalprocessing}
There's nothing inherently bad in that being in a single method
although I might be inclined to have both {do...processing} pieces in
separate (private) methods that are called from the main method.
Of course, you haven't shown us how you are using the CFC and that
might change my recommendation...
Sean A Corfield -- http://www.corfield.org/blog/
"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
Re: Cracking the RDS protocol?
On Wednesday, Sep 10, 2003, at 05:42 US/Pacific, Deanna Schneider wrote: > "live" (in our case development) server, where we rely on the > cgi.remote_user variable to determine who someone is. Do you use LDAP > to Unless you are writing code for a very specific environment where you can guarantee cgi.remote_user will work, I'd be very wary of relying on any CGI variables... Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Image manipulation
ATROEM: (At The Risk Of Embarrassing Myself) I've been asking myself about IIRC for a couple of months and just couldn't come up with anything... Rick > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 8:14 PM > To: CF-Talk > Subject: Re: Image manipulation > > > >>IIRC = If I Recall Correctly > > TWIWAM (that's what I was asking myself ;-) > > ~ > | > Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 > Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 > Unsubscribe: > http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 > > This list and all House of Fusion resources hosted by > CFHosting.com. The place for dependable ColdFusion Hosting. > http://www.cfhosting.com > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
CMFX 6.1 much better
Since I usually only post when I have a problem, I wanted to take a second and say that since upgrading to CFMX 6.1 many of the server stability issues I was having have gone away and are running much better. Have others also found better stability and speed with 6.1? Brook ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Strange problem
Sounds like your client (desktop) machine can hit port 80 on that system but your CF server (which is a different machine?) cannot? On Thursday, Sep 11, 2003, at 12:53 US/Pacific, Kris Pilles wrote: > Its weird because I can resolve the URL in the vrowser but it seems > like > Coldfusion can not... Any ideas how to fix on the firewall side? > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:46 PM > To: CF-Talk > Subject: RE: Strange problem > > > What happens if you switch to CFHTTP and just dump out the results? > > === > = > === > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > (www.mindseye.com) > Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) > > Email: [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > >> -Original Message- >> From: Kris Pilles [mailto:[EMAIL PROTECTED] >> Sent: Thursday, September 11, 2003 1:44 PM >> To: CF-Talk >> Subject: RE: Strange problem >> >> >> Still erroriing out, has been doing so since yesturday... >> >> -Original Message- >> From: Raymond Camden [mailto:[EMAIL PROTECTED] >> Sent: Thursday, September 11, 2003 3:42 PM >> To: CF-Talk >> Subject: RE: Strange problem >> >> >> Could it have been a temporary network problem? Can you try again? >> >> == >> == >> === >> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc >> (www.mindseye.com) >> Member of Team Macromedia >> (http://www.macromedia.com/go/teammacromedia) >> >> Email: >> [EMAIL PROTECTED] >> Blog : www.camdenfamily.com/morpheus/blog >> Yahoo IM : morpheus >> >> "My ally is the Force, and a powerful ally it is." - Yoda >> >>> -Original Message- >>> From: Kris Pilles [mailto:[EMAIL PROTECTED] >>> Sent: Thursday, September 11, 2003 1:10 PM >>> To: CF-Talk >>> Subject: RE: Strange problem >>> >>> >>> I did also notice that it was not putting an entry in the >> webservices >>> in the admin.. >>> >>> -Original Message- >>> From: Raymond Camden [mailto:[EMAIL PROTECTED] >>> Sent: Thursday, September 11, 2003 3:01 PM >>> To: CF-Talk >>> Subject: RE: Strange problem >>> >>> >>> If you go to that machine, open a browser and enter the >> URL, does it >>> work? >>> ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Image manipulation
Thanks for the tip, Claude! Rick > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 8:11 PM > To: CF-Talk > Subject: Re: Image manipulation > > > >>I'm going to be doing some of this work for a professional > photographer > > If ever you feel like you should protect the images by some > watermark embedded in it while the file is being uploaded, > you might have a look at custom tag CFX_StampImage. > CF_pictureFrame could be a plus for your presentation also. > See http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf > > ~ > | > Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 > Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 > Unsubscribe: > http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 > > 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 > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: How Many CFMX Instances?
On Thursday, Sep 11, 2003, at 10:13 US/Pacific, Demarco, Alex wrote: > What is a good rule of thumb as to how many jrun/CFMX instances you > need? > > We have one instance that handles all our web sites, should I break it > down > and split the sites amongst several instances? It depends on a number of factors. If you want robustness (so one website doesn't trample on another) then yes, multiple instances will help - and give you a separate CF Admin for each instance. But you also need to consider the number of CPUs and the amount of RAM on your server (assuming you're talking about everything on one server). You'd need to experiment, performance-wise, but I'd say not to have more instances that you have CPUs for example. We have two instances (each with a 2-3Gb JVM heap) on each of our 8 CPU, 8Gb RAM servers but then we're running a very high traffic site (up to 20,000 concurrent sessions during peak traffic). Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Regex help
>>but not in CAT or CATalog or CATastrophe, etc. Neither tattoo, in [^cat] any of c, a or t may not precede at. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: CFLINCLUDE in CFSCRIPT
I think that it will use the internal mappings for the machine to try and run
the included page. I've got some docs from Apache on what this should allow and
will add them in soon as I get a second. I also want to test to see a few
things.
1. Does an included page inherit all vars from the calling page?
2. Does an included page act in the context of the calling page or is it called
separately? i.e. does an application.cfm get called for the included page
separately.
> This function peaks my interest once again.
>
> GetPageContext().Include("somefile.cfm") will parse a cfm page, but not htm
> page ("somefile.htm"). So it has some internal parse switch to determine
> whether or not to parse a relative link.
>
> Sooo...is there some sub-function within GetPageContext() that might parse a
> variable (that could be read from a file or created on the fly?
>
>
> // example (quick one)
> Bob="I love ##BobsGirlfriend##, but this is a pound: ##.";
> BobsGirlfriend="Jane";
> GetPageContext().Parse(SomeString);
>
>
> Would output: "I love Jane, but this is a pound: #."
>
> This isn't exactly what I'm talking about, but close. And I've been
> searching high and low for something like this for a very long time...
>
> Tyler
>
> (I know this is a stretch, using GetPageContext() and all, but I can't seem
> to find anything close to doing what I want)
>
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 7:04 PM
> To: CF-Talk
> Subject: Re: CFLINCLUDE in CFSCRIPT
>
> Perfect, thanks. I'll give you credit and a link in the docs to this (as
> well as Charlie credit for his CFLOCATION portion).
> Are there any solid docs on the GetPageContext() stuff?
>
>
> > > I'm redoing my CFSCRIPT docs and one of the things I'm adding in are
> > > all the 'extra' things you can do with it in CFMX. One such thing is
> > > a CFLOCATION using
> > > GetPageContext().forward("somefile.cfm")
> > > I believe that there was a CFINCLUDE type code as well, but I can't
> > > seem to find it. If anyone remembers it, please let me know.
> > > Thanks
> > >
> > You can do an include with getPageContext().include("somefile.cfm").
> > However, it is not the same as doing a cfinclude. See a blog entry I
> > made on the subject.
> > http://devilm.com/archives/37.html
> >
> > Matt Liotta
> > President & CEO
> > Montara Software, Inc.
> > http://www.MontaraSoftware.com
> > (888) 408-0900 x901
> >
> >
> >
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
Sentra Commerce??
Does anyone know what happened to Sentra Commerce? I am tried to do an install of for my license (I corrupted the DB big time) and I saw their site is no longer up? Rizal if you are on this list, perhaps you remember our correspondence from some time ago? My company had purchased a few licenses of Sentra Commerce. I am in a dilemma. Since their server is gone, I cannot complete the setup routine for Sentra installation (I have a corrupt db I need to do a clean install). I was hoping since you were the chief architect, you perhaps share some advice on how I can get up and running without the Sentra Server. Regards, Michael [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Image manipulation
>>IIRC = If I Recall Correctly TWIWAM (that's what I was asking myself ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Image manipulation
>>I'm going to be doing some of this work for a professional photographer If ever you feel like you should protect the images by some watermark embedded in it while the file is being uploaded, you might have a look at custom tag CFX_StampImage. CF_pictureFrame could be a plus for your presentation also. See http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: [OT] ShittyCode.Com (Launched new site last night, feedback please!)
>>I wanted to see if I could get some feedback on the site Nice concept. However I wanted to sign in, and I got the message "Please Enter Valid Text." after entering my name, probably because there is an accent in it. Now, THAT's really shitty code! ;-)) You better correct this, or I'll publish YOUR OWN shitty code in your own site! ;-)) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: CFLINCLUDE in CFSCRIPT
Got that already, thanks. Do you know of any other GetPageContext() pieces that
are floating around? I only remember those 2.
>
> For that matter, I think it's worth pointing out that cflocation and
> GetPageContext().forward("somefile.cfm") are not exactly the same either.
> One's a client-side redirect and the other's a server-side redirect. While
> the end result is the same, there are some important ramifications to
> consider when using each (i.e., the potential for duplicate form data
> submissions if the GetPageContext().forward("somefile.cfm") method is used
> and the user hits the "Refresh" button). For this reason (and some others),
> I have tended to stay away from the .forward() technique unless i have one
> back-end script that needs to pass info to another back-end page, or some
> other scenario where the user can't interfere.
>
> Regards,
> Dave.
>
> _
> Use custom emotions -- try MSN Messenger 6.0!
> http://www.msnmessenger-download.com/tracking/reach_emoticon
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
RE: CFLINCLUDE in CFSCRIPT
This function peaks my interest once again.
GetPageContext().Include("somefile.cfm") will parse a cfm page, but not htm
page ("somefile.htm"). So it has some internal parse switch to determine
whether or not to parse a relative link.
Sooo...is there some sub-function within GetPageContext() that might parse a
variable (that could be read from a file or created on the fly?
// example (quick one)
Bob="I love ##BobsGirlfriend##, but this is a pound: ##.";
BobsGirlfriend="Jane";
GetPageContext().Parse(SomeString);
Would output: "I love Jane, but this is a pound: #."
This isn't exactly what I'm talking about, but close. And I've been
searching high and low for something like this for a very long time...
Tyler
(I know this is a stretch, using GetPageContext() and all, but I can't seem
to find anything close to doing what I want)
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 7:04 PM
To: CF-Talk
Subject: Re: CFLINCLUDE in CFSCRIPT
Perfect, thanks. I'll give you credit and a link in the docs to this (as
well as Charlie credit for his CFLOCATION portion).
Are there any solid docs on the GetPageContext() stuff?
> > I'm redoing my CFSCRIPT docs and one of the things I'm adding in are
> > all the 'extra' things you can do with it in CFMX. One such thing is
> > a CFLOCATION using
> > GetPageContext().forward("somefile.cfm")
> > I believe that there was a CFINCLUDE type code as well, but I can't
> > seem to find it. If anyone remembers it, please let me know.
> > Thanks
> >
> You can do an include with getPageContext().include("somefile.cfm").
> However, it is not the same as doing a cfinclude. See a blog entry I
> made on the subject.
> http://devilm.com/archives/37.html
>
> Matt Liotta
> President & CEO
> Montara Software, Inc.
> http://www.MontaraSoftware.com
> (888) 408-0900 x901
>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
RE: CFMX6.1 Install Issue on Win2003
Tried that, no go. :( There's plenty of disk space to...very weird. -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: September 11, 2003 5:58 PM To: CF-Talk Subject: Re: CFMX6.1 Install Issue on Win2003 C;\TEMP is what I put in == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Stacy Young" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 4:50 PM Subject: CFMX6.1 Install Issue on Win2003 | The installer keeps prompting me to find another place where it can | extract itself. | | "Please select a location where to extract the installer to" | | Any ideas appreciated! | | Stace | | | AVIS IMPORTANT: | --- | Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.. | | WARNING: | --- | The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. | | ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Repost: SQL Help
Patricia G.L.Hall wrote: > > I tried to implement this 3 ways. 2 gave me errors (cause they're > wrong) and 1 didn't give me the results I needed. Referring back to > the shorter query I started out with: Maybe you should try to explain in words what you are trying to achieve, because I am getting the impression that the code is much more complicated then what is actually needed. > Cannot perform an aggregate function on an expression containing an > aggregate or a subquery What database are you using? Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFLINCLUDE in CFSCRIPT
> > I'm redoing my CFSCRIPT docs and one of the things I'm adding in are
> > all the
> > 'extra' things you can do with it in CFMX. One such thing is a
> > CFLOCATION using
> > GetPageContext().forward("somefile.cfm")
> > I believe that there was a CFINCLUDE type code as well, but I can't
> > seem to find
> > it. If anyone remembers it, please let me know.
> > Thanks
> >
>You can do an include with getPageContext().include("somefile.cfm").
>However, it is not the same as doing a cfinclude. See a blog entry I
>made on the subject.
>http://devilm.com/archives/37.html
>
For that matter, I think it's worth pointing out that cflocation and
GetPageContext().forward("somefile.cfm") are not exactly the same either.
One's a client-side redirect and the other's a server-side redirect. While
the end result is the same, there are some important ramifications to
consider when using each (i.e., the potential for duplicate form data
submissions if the GetPageContext().forward("somefile.cfm") method is used
and the user hits the "Refresh" button). For this reason (and some others),
I have tended to stay away from the .forward() technique unless i have one
back-end script that needs to pass info to another back-end page, or some
other scenario where the user can't interfere.
Regards,
Dave.
_
Use custom emotions -- try MSN Messenger 6.0!
http://www.msnmessenger-download.com/tracking/reach_emoticon
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
Re: RE: RE: Image manipulation
IIRC = If I Recall Correctly -Kevin - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 6:16 PM Subject: RE: RE: RE: Image manipulation > Right...that's what occurs when resampling is specified for the image... > Pixels dimensions can be reduced, document size can be reduced, > resolution can be reduced, and file size decreases... > > Without resampling, file size doesn't change... > > Rick > > BTW...I never have been able to figure out what "IIRC" is...what does > that stand for? > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 6:21 PM > > To: CF-Talk > > Subject: Re: RE: RE: Image manipulation > > > > > > IIRC, If you're using Photoshop, then when you are > > resizing/reshaping/whatever, make sure that you change the > > DPI and the pixel sizes at the same time for the web ready images. > > > > - Original Message - > > From: Rick Faircloth <[EMAIL PROTECTED]> > > Date: Thursday, September 11, 2003 3:39 pm > > Subject: RE: RE: Image manipulation > > > > > That part I got...what I wasn't factoring in was the > > "resampling" that > > > was taking place when I was resizing the images... > > > > > > When resampling occurs, the image is changed. When resizing > > > occurs without resampling, a new image is not created. > > > > > > I think, if I'm not mistaken, that when you say "you'd have to > > > *resample*your image to 1500*2100 pixels..." you reallly mean > > > *resize*, because > > > *resampling* causes the confusion we had earlier. > > > > > > I need to *resample* when creating thumbnails or onscreen display > > > versions.That reduces file size...resizing without resampling does > > > not reduce file > > > size > > > and is therefore a bad practice for onscreen display images. > > > For printing, images should be *resized*, but not *resampled*. > > > > > > If you work with Photoshop, and work with resizing as well as > > > resamplingimages, which can both be done at the same time, you'll > > > know what I'm > > > referring to... > > > > > > Rick > > > > > > > > >> -Original Message- > > >> From: [EMAIL PROTECTED] [EMAIL PROTECTED] > > >> Sent: Thursday, September 11, 2003 1:41 PM > > >> To: CF-Talk > > >> Subject: Re: RE: Image manipulation > > >> > > >> > > >> I don't understand why you're having such problems with > > >> this. An 8X10 image @ 300 dpi is a 2400 X 3000 pixel image. > > >> Resize this image to whatever pixel dimensions you want for > > >> display purposes. You're confusing yourself with the 72dpi. > > >> That's irrelevant. Don't worry about it. > > >> > > >> For a 5X7 @ 300 dpi, you'd have to resample your image to > > >> 1500 * 2100 pixels. > > >> > > >> For a 4X6 @ 300 dpi, you have 1200 * 1800 pixels. > > >> > > >> > > >> - Original Message - > > >> From: Rick Faircloth <[EMAIL PROTECTED]> > > >> Date: Thursday, September 11, 2003 11:12 am > > >> Subject: RE: Image manipulation > > >> > > >> > It was the resampling that was complicating the > > >> discussion...my bad... > > >> > > > >> > But that brings me back to my original question about the > > > CF image > > >> > manipulation tags. I want to be able to automatically > > > resample> > the images > > >> > for display so the file size is smaller while keeping the > > >> > originals (if they > > >> > are > > >> > scanned or taken at higher resolutions) at the same ppi. > > >> > > > >> > I don't know yet whether or not any of the tags will > > > perform that > > >> > function. > > >> > I want to be able to upload a hi-res 8x10 image, have it > > > downsized> > (dimensions only) > > >> > to a 5x7 and 4x6 (still at same ppi, if the camera's ppi > > > setting is > > >> > variable) > > >> > then resample the image to 72 ppi for display on the > > > website. The > > >> > 8x10,5x7, and 4x6 > > >> > are for downloading, saving, and printing...that's what > > >> I'm trying to > > >> > accomplish. > > >> > > > >> > Anyone know what tag can do this? CFX_Image? > > >> > CF_MagickTag/ImageMagick?CFX_ImageCR from Efflare? > > >> > > > >> > If CFX_ImageCR can accomplish all of that... ppi > > > manipulation and > >
RE: RE: RE: Image manipulation
Right...that's what occurs when resampling is specified for the image... Pixels dimensions can be reduced, document size can be reduced, resolution can be reduced, and file size decreases... Without resampling, file size doesn't change... Rick BTW...I never have been able to figure out what "IIRC" is...what does that stand for? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 6:21 PM > To: CF-Talk > Subject: Re: RE: RE: Image manipulation > > > IIRC, If you're using Photoshop, then when you are > resizing/reshaping/whatever, make sure that you change the > DPI and the pixel sizes at the same time for the web ready images. > > - Original Message - > From: Rick Faircloth <[EMAIL PROTECTED]> > Date: Thursday, September 11, 2003 3:39 pm > Subject: RE: RE: Image manipulation > > > That part I got...what I wasn't factoring in was the > "resampling" that > > was taking place when I was resizing the images... > > > > When resampling occurs, the image is changed. When resizing > > occurs without resampling, a new image is not created. > > > > I think, if I'm not mistaken, that when you say "you'd have to > > *resample*your image to 1500*2100 pixels..." you reallly mean > > *resize*, because > > *resampling* causes the confusion we had earlier. > > > > I need to *resample* when creating thumbnails or onscreen display > > versions.That reduces file size...resizing without resampling does > > not reduce file > > size > > and is therefore a bad practice for onscreen display images. > > For printing, images should be *resized*, but not *resampled*. > > > > If you work with Photoshop, and work with resizing as well as > > resamplingimages, which can both be done at the same time, you'll > > know what I'm > > referring to... > > > > Rick > > > > > >> -Original Message- > >> From: [EMAIL PROTECTED] [EMAIL PROTECTED] > >> Sent: Thursday, September 11, 2003 1:41 PM > >> To: CF-Talk > >> Subject: Re: RE: Image manipulation > >> > >> > >> I don't understand why you're having such problems with > >> this. An 8X10 image @ 300 dpi is a 2400 X 3000 pixel image. > >> Resize this image to whatever pixel dimensions you want for > >> display purposes. You're confusing yourself with the 72dpi. > >> That's irrelevant. Don't worry about it. > >> > >> For a 5X7 @ 300 dpi, you'd have to resample your image to > >> 1500 * 2100 pixels. > >> > >> For a 4X6 @ 300 dpi, you have 1200 * 1800 pixels. > >> > >> > >> - Original Message - > >> From: Rick Faircloth <[EMAIL PROTECTED]> > >> Date: Thursday, September 11, 2003 11:12 am > >> Subject: RE: Image manipulation > >> > >> > It was the resampling that was complicating the > >> discussion...my bad... > >> > > >> > But that brings me back to my original question about the > > CF image > >> > manipulation tags. I want to be able to automatically > > resample> > the images > >> > for display so the file size is smaller while keeping the > >> > originals (if they > >> > are > >> > scanned or taken at higher resolutions) at the same ppi. > >> > > >> > I don't know yet whether or not any of the tags will > > perform that > >> > function. > >> > I want to be able to upload a hi-res 8x10 image, have it > > downsized> > (dimensions only) > >> > to a 5x7 and 4x6 (still at same ppi, if the camera's ppi > > setting is > >> > variable) > >> > then resample the image to 72 ppi for display on the > > website. The > >> > 8x10,5x7, and 4x6 > >> > are for downloading, saving, and printing...that's what > >> I'm trying to > >> > accomplish. > >> > > >> > Anyone know what tag can do this? CFX_Image? > >> > CF_MagickTag/ImageMagick?CFX_ImageCR from Efflare? > >> > > >> > If CFX_ImageCR can accomplish all of that... ppi > > manipulation and > >> > resampling, too, > >> > then it'll be worth $149, easily... > >> > > >> > Thanks for your help... > >> > > >> > Rick > >> > > >> > > >> >> -Original Message- > >> >> From: Claude Schneegans [EMAIL PROTECTED] > >> >> Sent: Thursday, September 11, 2003 12:32 PM > >> >> To: CF-Talk > >> >
Re: Repost: SQL Help
On Thursday, September 11, 2003, at 06:24 PM, Ian Skinner wrote: > your group by is on the wrong query. you need it on the sub-query > where the > max is at. > > Case > ( >Select MAX count(etp.etprocedureid) >from eTransferProtocolLink etp >Where etp.etProcedureid = et.etProcedureid and >etp.protocolid = 12 > GROUP BY etp.etprocedureid > ) > I ran this. I received this error: Incorrect syntax near the keyword 'count'. Then I put parens around count() so it read Select Max(count(etp.etprocedureid)) Running that I received this error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery. -Patti ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFLINCLUDE in CFSCRIPT
Perfect, thanks. I'll give you credit and a link in the docs to this (as well as
Charlie credit for his CFLOCATION portion).
Are there any solid docs on the GetPageContext() stuff?
> > I'm redoing my CFSCRIPT docs and one of the things I'm adding in are
> > all the
> > 'extra' things you can do with it in CFMX. One such thing is a
> > CFLOCATION using
> > GetPageContext().forward("somefile.cfm")
> > I believe that there was a CFINCLUDE type code as well, but I can't
> > seem to find
> > it. If anyone remembers it, please let me know.
> > Thanks
> >
> You can do an include with getPageContext().include("somefile.cfm").
> However, it is not the same as doing a cfinclude. See a blog entry I
> made on the subject.
> http://devilm.com/archives/37.html
>
> Matt Liotta
> President & CEO
> Montara Software, Inc.
> http://www.MontaraSoftware.com
> (888) 408-0900 x901
>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
RE: CFLINCLUDE in CFSCRIPT
getPageContext.include("template"); will do a JSP-style include. Matt
Liotta blogged it a while back. If the extension is .html or .htm, the
content will be included without CF processing. if the extension is .cfm,
it will be processed by CF just like CFINCLUDE.
barneyb
---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 3:52 PM
> To: CF-Talk
> Subject: CFLINCLUDE in CFSCRIPT
>
>
> I'm redoing my CFSCRIPT docs and one of the things I'm adding in
> are all the
> 'extra' things you can do with it in CFMX. One such thing is a
> CFLOCATION using
> GetPageContext().forward("somefile.cfm")
> I believe that there was a CFINCLUDE type code as well, but I
> can't seem to find
> it. If anyone remembers it, please let me know.
> Thanks
>
> p.s. the docs will be re-released both as a web doc and as a .chm
> stand alone
> file. If people like it, I may do the same with other topics like RegEx.
>
> Michael Dinowitz
> Finding technical solutions to the problems you didn't know you had yet
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
Re: CFLINCLUDE in CFSCRIPT
> I'm redoing my CFSCRIPT docs and one of the things I'm adding in are
> all the
> 'extra' things you can do with it in CFMX. One such thing is a
> CFLOCATION using
> GetPageContext().forward("somefile.cfm")
> I believe that there was a CFINCLUDE type code as well, but I can't
> seem to find
> it. If anyone remembers it, please let me know.
> Thanks
>
You can do an include with getPageContext().include("somefile.cfm").
However, it is not the same as doing a cfinclude. See a blog entry I
made on the subject.
http://devilm.com/archives/37.html
Matt Liotta
President & CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
Re: calling all users of PostgreSQL on Windows
Bryan Stevenson wrote: > OK...why? Because the native port that is available for Windows is version 7.2.1 (the current Unix version is at 7.3.4 or 7.4 beta2), which is a source only distribution that requires about 40 steps to compile. If it is just for testing and demo's and not for real production, just use one of the beta's from PeerDirects port. If it is for production, use Unix. > and any idea how long the native port is supposed to be? I expect it to be in CVS tip early next year, but there won't be any release until it is ready. Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: calling all users of PostgreSQL on Windows
Well saying open source is not supported is a bit off in my books..hehe...but I hear ya ;-) I'm asking why because I want to know what the issues are (if any). If it works beautifully but "isn't supported", then that's good enough for mejust trying to get a handle on it ;-) Ultimately if it's not ready or blows smelly chunks on Windows then I'll head the MSDE route for straters on this co-lo box and then moev up to full-blown MS SQL Server if.when it's requiredjust tryin to make things cheaper for the client ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Massimo, Tiziana e Federica" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 3:33 PM Subject: Re: calling all users of PostgreSQL on Windows > > OK...why? > > Because Postgres is not supported under Windows, just like CF isn't under > BSD > > > > and any idea how long the native port is supposed to be? > > I have no idea, you should check the website. I don't work often with > Postgres (even if I like it a lot) > > > Massimo Foti > Certified Dreamweaver MX Developer > Certified Advanced ColdFusion MX Developer > http://www.massimocorner.com/ > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
CFLINCLUDE in CFSCRIPT
I'm redoing my CFSCRIPT docs and one of the things I'm adding in are all the
'extra' things you can do with it in CFMX. One such thing is a CFLOCATION using
GetPageContext().forward("somefile.cfm")
I believe that there was a CFINCLUDE type code as well, but I can't seem to find
it. If anyone remembers it, please let me know.
Thanks
p.s. the docs will be re-released both as a web doc and as a .chm stand alone
file. If people like it, I may do the same with other topics like RegEx.
Michael Dinowitz
Finding technical solutions to the problems you didn't know you had yet
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
Re: Basic CFC method design question.
The first choice is the pinnacle of bad OO design, and is totally unnecessary in OO languages (it's what method overloading is for). The second choice is much better. - Original Message - From: Ian Skinner <[EMAIL PROTECTED]> Date: Thursday, September 11, 2003 3:36 pm Subject: Basic CFC method design question. > Generally which is better, a single method with branching logic > based on a > parameter, or separate methods? Or is there no really difference > and depends > on the personal choice and the situation. > > I am in the process of converting some procedural code onto cfc's. > I have > several queries that where written to serve multiple purposes > based on the > parameter passed to them. Basically something along these lines... > > > > INSERT INTO tableA > (Field1, Field, Field 3) > Values (A,B,C) > > > > > > INSERT INTO tableB > (field1, field2, field3) > VALUES(D,E,F) > > > Basicaly if the insert is a new category add category date to the > category,if it is just a new data about an existing category added > it to the details > table. How might some of you more expienced OO types design this? > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: calling all users of PostgreSQL on Windows
> OK...why? Because Postgres is not supported under Windows, just like CF isn't under BSD > and any idea how long the native port is supposed to be? I have no idea, you should check the website. I don't work often with Postgres (even if I like it a lot) Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: RE: RE: Image manipulation
IIRC, If you're using Photoshop, then when you are resizing/reshaping/whatever, make sure that you change the DPI and the pixel sizes at the same time for the web ready images. - Original Message - From: Rick Faircloth <[EMAIL PROTECTED]> Date: Thursday, September 11, 2003 3:39 pm Subject: RE: RE: Image manipulation > That part I got...what I wasn't factoring in was the "resampling" that > was taking place when I was resizing the images... > > When resampling occurs, the image is changed. When resizing > occurs without resampling, a new image is not created. > > I think, if I'm not mistaken, that when you say "you'd have to > *resample*your image to 1500*2100 pixels..." you reallly mean > *resize*, because > *resampling* causes the confusion we had earlier. > > I need to *resample* when creating thumbnails or onscreen display > versions.That reduces file size...resizing without resampling does > not reduce file > size > and is therefore a bad practice for onscreen display images. > For printing, images should be *resized*, but not *resampled*. > > If you work with Photoshop, and work with resizing as well as > resamplingimages, which can both be done at the same time, you'll > know what I'm > referring to... > > Rick > > >> -Original Message- >> From: [EMAIL PROTECTED] [EMAIL PROTECTED] >> Sent: Thursday, September 11, 2003 1:41 PM >> To: CF-Talk >> Subject: Re: RE: Image manipulation >> >> >> I don't understand why you're having such problems with >> this. An 8X10 image @ 300 dpi is a 2400 X 3000 pixel image. >> Resize this image to whatever pixel dimensions you want for >> display purposes. You're confusing yourself with the 72dpi. >> That's irrelevant. Don't worry about it. >> >> For a 5X7 @ 300 dpi, you'd have to resample your image to >> 1500 * 2100 pixels. >> >> For a 4X6 @ 300 dpi, you have 1200 * 1800 pixels. >> >> >> - Original Message - >> From: Rick Faircloth <[EMAIL PROTECTED]> >> Date: Thursday, September 11, 2003 11:12 am >> Subject: RE: Image manipulation >> >> > It was the resampling that was complicating the >> discussion...my bad... >> > >> > But that brings me back to my original question about the > CF image >> > manipulation tags. I want to be able to automatically > resample> > the images >> > for display so the file size is smaller while keeping the >> > originals (if they >> > are >> > scanned or taken at higher resolutions) at the same ppi. >> > >> > I don't know yet whether or not any of the tags will > perform that >> > function. >> > I want to be able to upload a hi-res 8x10 image, have it > downsized> > (dimensions only) >> > to a 5x7 and 4x6 (still at same ppi, if the camera's ppi > setting is >> > variable) >> > then resample the image to 72 ppi for display on the > website. The >> > 8x10,5x7, and 4x6 >> > are for downloading, saving, and printing...that's what >> I'm trying to >> > accomplish. >> > >> > Anyone know what tag can do this? CFX_Image? >> > CF_MagickTag/ImageMagick?CFX_ImageCR from Efflare? >> > >> > If CFX_ImageCR can accomplish all of that... ppi > manipulation and >> > resampling, too, >> > then it'll be worth $149, easily... >> > >> > Thanks for your help... >> > >> > Rick >> > >> > >> >> -Original Message- >> >> From: Claude Schneegans [EMAIL PROTECTED] >> >> Sent: Thursday, September 11, 2003 12:32 PM >> >> To: CF-Talk >> >> Subject: Re: Image manipulation >> >> >> >> >> >> >>Can't agree there...perhaps we're comparing > apples to >> > oranges...> >> >> Excatly: you are comparing two different images! >> >> >> >> >>Took the same photo and resampled it to 72 pixels per >> > inch (ppi), >> >> 360 pixels wide, and 503 pixels high. (Maximum > quality JPEG >> > setting)> >> >> When you "resample" an image this way you get a > different> > image.> You say yourself one is "1501 > pixels wide", the other >> > one is >> >> 360 pixels. >> >> Of course, if you print them at the same size, thay > won't> >> look the same. >> >> Here are your apples and oranges. >> >> >> >> >>I'm not sure if we're missing something in this > discussion,> >> >> >> I'm pretty sure I'm not ;-) >> >> >> >> >>Does using "ppi" as opposed to "dpi" to refer to >> >> resolution make any difference in our discussion? >> >> >> >> If you see a difference between a pixel and a dot, > yes it >> >> could make a difference, but for me it doesn't. >>
RE: Repost: SQL Help
your group by is on the wrong query. you need it on the sub-query where the max is at. Case ( Select MAX count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 GROUP BY etp.etprocedureid ) -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Patricia G. L. Hall [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:21 PM To: CF-Talk Subject: Re: Repost: SQL Help > You should be able to just do a MAX() around the Gift field (if I > understand your intentions correctly, you need them around some > other CASE statements as well) and add group by statements as needed. > > I tried to implement this 3 ways. 2 gave me errors (cause they're wrong) and 1 didn't give me the results I needed. Referring back to the shorter query I started out with: This: Select Max ( Case ( Select count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End ) as GIFT, et.caseid from etprocedure et Group by et.caseid Gives me this error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery and so does: Select Case ( Select count( max( etp.etprocedureid) ) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid This gave me no error, but the results were still wrong: Select Case ( Select max(etp.etprocedureid) from eTransferProtocolLink etp Where etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid, et.etProcedureid ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Repost: SQL Help
> You should be able to just do a MAX() around the Gift field (if I > understand your intentions correctly, you need them around some > other CASE statements as well) and add group by statements as needed. > > I tried to implement this 3 ways. 2 gave me errors (cause they're wrong) and 1 didn't give me the results I needed. Referring back to the shorter query I started out with: This: Select Max ( Case ( Select count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End ) as GIFT, et.caseid from etprocedure et Group by et.caseid Gives me this error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery and so does: Select Case ( Select count( max( etp.etprocedureid) ) from eTransferProtocolLink etp Where etp.etProcedureid = et.etProcedureid and etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid This gave me no error, but the results were still wrong: Select Case ( Select max(etp.etprocedureid) from eTransferProtocolLink etp Where etp.protocolid = 12 ) When 0 then 0 When null then 0 Else 1 End as GIFT, et.caseid from etprocedure et Group by et.caseid, et.etProcedureid ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Image manipulation
> One word of caution: don't try to resize to a larger pixel measurement. > If the person gives you a hi-res 4"x6" image (1200x1800), don't try to make > that into a hi-res 8"x10" (2400x3000). If you do, you'll be > inventing pixels from thin air and it won't look good. Yes...you can go down but not up... Everything makes complete sense, now that resampling is taken into consideration. The only time an image needs to be resampled, is when it's being prepared for onscreen display to reduce file size... Looks like CFX_ImageCR will do everything I need, including resizing only with width specified and heighth automatically calculated, resizing and creating the various files according to needed print dimensions, and the ability to resample an image to reduce the file size...and all with great quality... I'm going to be doing some of this work for a professional photographer who will be very concerned about image quality, and it looks like Efflare pays special attention to that. Rick > -Original Message- > From: Kevin Graeme [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 2:14 PM > To: CF-Talk > Subject: Re: Image manipulation > > > Okay, to get the tags to work for you, you're going to have > to give up > thinking in terms of 8x10 and 5x7. At least for a part of > the process. > > When you say "hi-res 8x10", you have to clarify what that > means in pixel > values. If "hi-res" = 300dpi to you, then a bit of simple > math will give you > the pixel values. > > 8"*300dpi = 2400pixels > 10"*300dpi = 3000pixels > > Therefore, > > Hi-res 8x10 = 2400x3000 pixels > > From that, you want to get a hi-res (300dpi) 4x6. > > 4*300 = 1200px > 6*300 = 1800px > > So all you need to do is tell the image manipulation tag > that you want to > resize that image to 1200*1800. And as you've seen, some > tags allow you to > just specify one dimension and the other resizes proportionately. > > To size for the screen, you probably already know the desired pixel > measurements (or at least width) for your web thumbnail and > preview, so you > just plug that in. > > One word of caution: don't try to resize to a larger pixel > measurement. If > the person gives you a hi-res 4"x6" image (1200x1800), don't > try to make > that into a hi-res 8"x10" (2400x3000). If you do, you'll be > inventing pixels > from thin air and it won't look good. > > Hope that helps and good luck, > > -Kevin > > > - Original Message - > From: "Rick Faircloth" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, September 11, 2003 12:12 PM > Subject: RE: Image manipulation > > > > It was the resampling that was complicating the > discussion...my bad... > > > > But that brings me back to my original question about the CF image > > manipulation tags. I want to be able to automatically > resample the images > > for display so the file size is smaller while keeping the > originals (if > they > > are > > scanned or taken at higher resolutions) at the same ppi. > > > > I don't know yet whether or not any of the tags will perform that > function. > > > > I want to be able to upload a hi-res 8x10 image, have it downsized > > (dimensions only) > > to a 5x7 and 4x6 (still at same ppi, if the camera's ppi setting is > > variable) > > then resample the image to 72 ppi for display on the > website. The 8x10, > > 5x7, and 4x6 > > are for downloading, saving, and printing...that's what > I'm trying to > > accomplish. > > > > Anyone know what tag can do this? CFX_Image? > CF_MagickTag/ImageMagick? > > CFX_ImageCR from Efflare? > > > > If CFX_ImageCR can accomplish all of that... ppi manipulation and > > resampling, too, > > then it'll be worth $149, easily... > > > > Thanks for your help... > > > > Rick > > > > > > > -Original Message- > > > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, September 11, 2003 12:32 PM > > > To: CF-Talk > > > Subject: Re: Image manipulation > > > > > > > > > >>Can't agree there...perhaps we're comparing > apples to oranges... > > > > > > Excatly: you are comparing two different images! > > > > > > >>Took the same photo and resampled it to 72 pixels > per inch (ppi), > > > 360 pixels wide, and 503 pixels high. (Maximum quality JPEG > setting) > > > > > > When you "resample" an image this way you get a >
Re: CFMX6.1 Install Issue on Win2003
C;\TEMP is what I put in == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Stacy Young" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 4:50 PM Subject: CFMX6.1 Install Issue on Win2003 | The installer keeps prompting me to find another place where it can | extract itself. | | "Please select a location where to extract the installer to" | | Any ideas appreciated! | | Stace | | | AVIS IMPORTANT: | --- | Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.. | | WARNING: | --- | The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. | | ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Misbehaving query
Make sure to use Preservesinglequote() IN the query -- not in defining the
string ...
ie.
WhereString = Preservesinglequotes("userID = 'foo' ")
SELECT blah
FROMyuk
WHERE #whereString#
is WRONG
WhereString = "userID = 'foo' "
SELECT blah
FROMyuk
WHERE #Preservesinglequotes(whereString)#
is RIGHT
-
Personally, since I discovered cfqueryparam, I've rewriting all code where I
used these techniques, because I prefer all the extra benefits of
CFQUERYPARAM (protection from SQL Injection, improved execution plans on the
SQL Server). I had to move a lot of decision code back into my CFQUERY, but
I think it's worth it.
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 2:36 PM
To: CF-Talk
Subject: RE: Misbehaving query
Hello,
You can use Preservesinglequote() function
-Original Message-
From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 5:26 PM
To: CF-Talk
Subject: Misbehaving query
I am trying dynamically build a query.
I have the following string variable:
WhereString = "userID = 'foo' "
When I do a normal cfoutput #whereString# I get userID = 'foo'
So far, so good == but when I put it in a cfquery such as,
SELECT blah
FROMyuk
WHERE #whereString#
CF ends up passing user="foo" in the SQL string and it obviously throws
an error.
Anybody know how to get around this??
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
CFMX6.1 Install Issue on Win2003
The installer keeps prompting me to find another place where it can extract itself. "Please select a location where to extract the installer to" Any ideas appreciated! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: calling all users of PostgreSQL on Windows
OK...why? and any idea how long the native port is supposed to be? Thanks Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Massimo, Tiziana e Federica" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 2:38 PM Subject: Re: calling all users of PostgreSQL on Windows > > The GUI and the DB on Windows (so CF Server and database all running on a > > Windows server). I don't know what package is best (i.e. cygwin or > > others)that's why I asked ;-) > > I wouldn't run Postgres on Windows on a production box, at least not until > the native version will be available. > > For a GUI you may try: > > http://www.aquadatastudio.com/ > > > Massimo Foti > Certified Dreamweaver MX Developer > Certified Advanced ColdFusion MX Developer > http://www.massimocorner.com/ > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Repost: SQL Help
Patricia G. L. Hall wrote: > > Select > 'False' as FSHUnknown, > 'False' as E2Unknown, > '' as ptGnRHaFlare, > '' as PtGnRHaSupp, > ci.caseid as clinicCycleID, > Case count(stim.stimulationid) > When Then 1 > Else 0 > End as PtUnstimulated, > stim.labNormalFSHLevel as labFshUpLimitNormal, > stim.maxFSHLevel as ptMaxFshLevel, > stim.labNormalE2Level as labE2UpLimitNormal, > stim.maxE2Level as ptMaxE2Level, > Case stim.clomiphenedose > When Then > When NULL Then 0 > Else 1 > End AS ptClomiphene, > stim.clomiphenedose as ptClomipheneDosage, > Case stim.fshTotalIU > When Then 0 > When NULL Then 0 > Else 1 > End As PtFSH, > stim.fshTotalIU as ptFSHDosage, > stim.gnrhagonistid, > gnrh.gnrhagonisttypename, > Case stim.GNRHAntagonistDays > When Then 0 > When NULL Then 0 > Else 1 > End as PtGnRHA_Antagonist, > Case > (Select count(etp.etprocedureid) from eTransferProtocolLink etp Where > etp.protocolid = 12 and etp.etProcedureid = et.etProcedureid) > When then 0 > When NULL then 0 > Else 1 > End as transGIFT, > Case > (Select count(etp.etprocedureid) from eTransferProtocolLink etp Where > etp.protocolid IN (19,13) and etp.etProcedureid = et.etProcedureid) > When then 0 > When NULL then 0 > Else 1 > End as transZIFT, > Case > (Select count(etp.etprocedureid) from eTransferProtocolLink etp Where > etp.protocolid NOT IN (19,13,12,6) and etp.etProcedureid = > et.etProcedureid) > When then 0 > When NULL then 0 > Else 1 > End as transIVF, > Case et.AHPERFORMED > When 'None' Then 1 > When 'Some' Then 2 > When 'All' Then 3 > Else 0 > End as AZHid, > et.treatmentAsIntended as asIntended, > Case count(et.etprocedureid) > When Then 0 > When null Then 0 > Else 1 > End as transferAttempted, > et.proceduredate > from caseInfo ci > Left Outer Join stimulation stim on ci.caseid = stim.caseid > Left Outer join gnrhagonisttype gnrh on stim.gnrhagonisttypeid = > gnrh.gnrhagonisttypeid > Left Outer Join etProcedure et on ci.caseID = et.caseid > Left Outer Join eTransferProtocolLink etp on et.etProcedureID = > etp.etProcedureID > Where > ci.caseid IN (#session.sartdata.cycles.cyclespk#) > Group By > ci.caseid, > stim.labNormalFSHLevel, > stim.maxFSHLevel, > stim.labNormalE2Level, > stim.maxE2Level, > stim.clomiphenedose, > stim.fshTotalIU, > stim.gnrhagonistid, > gnrh.gnrhagonisttypename, > stim.GNRHAntagonistDays, > et.etProcedureID, > et.AHPERFORMED, > et.treatmentAsIntended, > et.proceduredate You should be able to just do a MAX() around the Gift field (if I understand your intentions correctly, you need them around some other CASE statements as well) and add group by statements as needed. Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: calling all users of PostgreSQL on Windows
> The GUI and the DB on Windows (so CF Server and database all running on a > Windows server). I don't know what package is best (i.e. cygwin or > others)that's why I asked ;-) I wouldn't run Postgres on Windows on a production box, at least not until the native version will be available. For a GUI you may try: http://www.aquadatastudio.com/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Basic CFC method design question.
Generally which is better, a single method with branching logic based on a parameter, or separate methods? Or is there no really difference and depends on the personal choice and the situation. I am in the process of converting some procedural code onto cfc's. I have several queries that where written to serve multiple purposes based on the parameter passed to them. Basically something along these lines... INSERT INTO tableA (Field1, Field, Field 3) Values (A,B,C) INSERT INTO tableB (field1, field2, field3) VALUES(D,E,F) Basicaly if the insert is a new category add category date to the category, if it is just a new data about an existing category added it to the details table. How might some of you more expienced OO types design this? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Misbehaving query
Hello, You can use Preservesinglequote() function -Original Message- From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 5:26 PM To: CF-Talk Subject: Misbehaving query I am trying dynamically build a query. I have the following string variable: WhereString = "userID = 'foo' " When I do a normal cfoutput #whereString# I get userID = 'foo' So far, so good == but when I put it in a cfquery such as, SELECT blah FROMyuk WHERE #whereString# CF ends up passing user="foo" in the SQL string and it obviously throws an error. Anybody know how to get around this?? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: RE: Image manipulation
That part I got...what I wasn't factoring in was the "resampling" that was taking place when I was resizing the images... When resampling occurs, the image is changed. When resizing occurs without resampling, a new image is not created. I think, if I'm not mistaken, that when you say "you'd have to *resample* your image to 1500*2100 pixels..." you reallly mean *resize*, because *resampling* causes the confusion we had earlier. I need to *resample* when creating thumbnails or onscreen display versions. That reduces file size...resizing without resampling does not reduce file size and is therefore a bad practice for onscreen display images. For printing, images should be *resized*, but not *resampled*. If you work with Photoshop, and work with resizing as well as resampling images, which can both be done at the same time, you'll know what I'm referring to... Rick > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:41 PM > To: CF-Talk > Subject: Re: RE: Image manipulation > > > I don't understand why you're having such problems with > this. An 8X10 image @ 300 dpi is a 2400 X 3000 pixel image. > Resize this image to whatever pixel dimensions you want for > display purposes. You're confusing yourself with the 72dpi. > That's irrelevant. Don't worry about it. > > For a 5X7 @ 300 dpi, you'd have to resample your image to > 1500 * 2100 pixels. > > For a 4X6 @ 300 dpi, you have 1200 * 1800 pixels. > > > - Original Message - > From: Rick Faircloth <[EMAIL PROTECTED]> > Date: Thursday, September 11, 2003 11:12 am > Subject: RE: Image manipulation > > > It was the resampling that was complicating the > discussion...my bad... > > > > But that brings me back to my original question about the CF image > > manipulation tags. I want to be able to automatically resample > > the images > > for display so the file size is smaller while keeping the > > originals (if they > > are > > scanned or taken at higher resolutions) at the same ppi. > > > > I don't know yet whether or not any of the tags will perform that > > function. > > I want to be able to upload a hi-res 8x10 image, have it downsized > > (dimensions only) > > to a 5x7 and 4x6 (still at same ppi, if the camera's ppi setting is > > variable) > > then resample the image to 72 ppi for display on the website. The > > 8x10,5x7, and 4x6 > > are for downloading, saving, and printing...that's what > I'm trying to > > accomplish. > > > > Anyone know what tag can do this? CFX_Image? > > CF_MagickTag/ImageMagick?CFX_ImageCR from Efflare? > > > > If CFX_ImageCR can accomplish all of that... ppi manipulation and > > resampling, too, > > then it'll be worth $149, easily... > > > > Thanks for your help... > > > > Rick > > > > > >> -Original Message- > >> From: Claude Schneegans [EMAIL PROTECTED] > >> Sent: Thursday, September 11, 2003 12:32 PM > >> To: CF-Talk > >> Subject: Re: Image manipulation > >> > >> > >> >>Can't agree there...perhaps we're comparing apples to > > oranges...> > >> Excatly: you are comparing two different images! > >> > >> >>Took the same photo and resampled it to 72 pixels per > > inch (ppi), > >> 360 pixels wide, and 503 pixels high. (Maximum quality JPEG > > setting)> > >> When you "resample" an image this way you get a different > > image.> You say yourself one is "1501 pixels wide", the other > > one is > >> 360 pixels. > >> Of course, if you print them at the same size, thay won't > >> look the same. > >> Here are your apples and oranges. > >> > >> >>I'm not sure if we're missing something in this discussion, > >> > >> I'm pretty sure I'm not ;-) > >> > >> >>Does using "ppi" as opposed to "dpi" to refer to > >> resolution make any difference in our discussion? > >> > >> If you see a difference between a pixel and a dot, yes it > >> could make a difference, but for me it doesn't. > >> > >> ~ > >> | > >> Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 > >> Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 > >> Unsubscribe: > > > http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 > > > > Signup for the Fusion Authority news alert and keep up with the > > latest news > > in ColdFusion and
Re: kill all domain cookies
Loop over the cookie struct, and set them all to expire now. -- jon mailto:[EMAIL PROTECTED] Thursday, September 11, 2003, 2:47:05 PM, you wrote: TW> hi there. TW> made a change last night, and for some reason clients cant get to stuff TW> on our reporting site TW> due to old cookies vs. new cookies, I want to delete all cookies, is TW> there a way to just delete TW> the entire cookie scope? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Misbehaving query
CF by default escapes single quotes in variables in queries (to prevent errors when inserting or updating strings with apostrophes :-) #preservesinglequotes(wherestring)# will prevent CF from escaping your single quotes. -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 5:26 PM : To: CF-Talk : Subject: Misbehaving query : : : I am trying dynamically build a query. : : I have the following string variable: : WhereString = "userID = 'foo' " : : When I do a normal cfoutput #whereString# I get userID = 'foo' : : So far, so good == but when I put it in a cfquery such as, : : SELECT blah : FROMyuk : WHERE #whereString# : : CF ends up passing user="foo" in the SQL string and it obviously : throws an : error. : : Anybody know how to get around this?? : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Server Error 500?
I am working with two different CFMX 6.1 boxes. On one, if I insert the following code as a stand alone file ... #test# I get the expected 'variable test is undefined' error message with the CF grey box etc. On the other server, I get a generic '500 server error' message. I have had this appear in several other cases as well. Anybody know what is going on? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Misbehaving query
I am trying dynamically build a query. I have the following string variable: WhereString = "userID = 'foo' " When I do a normal cfoutput #whereString# I get userID = 'foo' So far, so good == but when I put it in a cfquery such as, SELECT blah FROMyuk WHERE #whereString# CF ends up passing user="foo" in the SQL string and it obviously throws an error. Anybody know how to get around this?? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: calling all users of PostgreSQL on Windows
Hey Lee, The GUI and the DB on Windows (so CF Server and database all running on a Windows server). I don't know what package is best (i.e. cygwin or others)that's why I asked ;-) As you can tell I'm totally new to this open-source nonsense..hehe...so any pointers will be greatly appreciated (especially the..."do not do or the machine will sprout legs and eat the tech department" kind of stuff) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 12:35 PM Subject: OT: calling all users of PostgreSQL on Windows > Can you be a little more specific? > > Are you looking to host the database on Windows or just a GUI tool that will be a window to the database on a *NIX system? > > If the former, are you running on the Cygwin framework (Windows Unix) or via a native application database (from one of a few commercial companies). > > Personally, I'm running Postgres on Linux - but I'm eagerly waiting for the native port to Windows to make the use of the database more appealing to my "superiors" - as a mySQL, cross-platform database. > > >Hey all, > > > >Do any of you with experience with PostgreSQL on Windows have any > >tips/tricks/gotchas that you would care to share? Which package do you > >think is best? > > > >TIA > > > >Cheers > > > >Bryan Stevenson B.Comm. > >VP & Director of E-Commerce Development > >Electric Edge Systems Group Inc. > >t. 250.920.8830 > >e. [EMAIL PROTECTED] > > > >- > >Macromedia Associate Partner > >www.macromedia.com > >- > >Vancouver Island ColdFusion Users Group > >Founder & Director > >www.cfug-vancouverisland.com > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFC Problem
Raymond, Thanks for your help. I ended up calling the component a different way and it works. Im not sure if I stumbled on a bug or if I was doing something incorrectly. What I ended up doing was creating the object like normal: Then using cfinvoke to call the method. I think maybe what was happening is that calling the method as obj.method(args) didn't like receiving empty values as "" or something along those lines. Thanks again for your help, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com phone: 281.807.4344 x1716 fax: 281.807.4384 > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:09 PM > To: CF-Talk > Subject: RE: CFC Problem > > > Nope, there shouldn't be a limit. Line 31 was the partner line in the > cfx call, right? If you ONLY output the args and comment out the cfx > call, does the method call work? > > == > == > === > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > (www.mindseye.com) > Member of Team Macromedia > (http://www.macromedia.com/go/teammacromedia) > > Email: > [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Chris Alvarado [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 1:54 PM > > To: CF-Talk > > Subject: RE: CFC Problem > > > > > > Did that, everything is coming through as expected. > > > > Is there a limit to the number of arguments you can have for > > a given method? > > > > Maybe the exceptions portion of the debugging would help: > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: [OT] ShittyCode.Com (Launched new site last night, feedback please!)
I agree, however being that I built the entire site in one night, I cant complain for the results :) I usually do get things such as multi-level environments, etc in my code... but my main idea (being that originally someone else was supposed to built it with me and they couldn't at the last moment... I just wrote everything you see in one night, tested it and launched it...) Pablo - Original Message - From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 2:18 PM Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback please!) > Pablo, > We avoid the issue of "uncommenting" our error tags for production by > wrapping them in an if statement that looks at the cgi.server_name var. I'm > sure there's multiple ways to handle this, but we've found it's way easier > to do if you're not relying on remembering to change that one little thing > before going live. > -d > > - Original Message - > From: "Pablo Varando" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 10, 2003 2:18 PM > Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback > please!) > > > > It's not mean, it's good feedback.. > > > > I had a CFERROR in the application, but it was commented out (while > > development and somehow it didn't get uncommented ;) it's "on" now... > thanks > > for catching that one! :) > > > > Pablo > > - Original Message - > > From: "Matt Liotta" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, September 10, 2003 1:59 PM > > Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback > > please!) > > > > > > > > I wanted to see if I could get some feedback on the site, the concept, > > > > and maybe even the name! :) > > > > > > > I know this is mean, but shouldn't the shitty code site not be running > > > on shitty code? For example, not validating URL variables used in a > > > query. > > > > > > http://www.shittycode.com/directory/details.cfm?code_id=a > > > > > > I'd hate someone to drop all your tables because of the following > > > information presented by your site. > > > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'a'. > > > > > > > > > > > > > > > The error occurred in > > > D:\inetpub\shittycode.com\web\directory\details.cfm: line 64 > > > > > > > > > > > > > > > > > > 62 :SELECT * > > > 63 :FROMCodeArchive > > > 64 :WHERE code_id > > > = #code_id# > > > 65 : > > > 66 : > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SQL > > > SELECT* > > > FROMCodeArchive > > > WHEREcode_id= > > > a > > > > > > DATASOURCE > > > shittycode > > > > > > VENDORERRORCODE > > > 207 > > > > > > SQLSTATE > > > 42S22 > > > > > > Matt Liotta > > > President & CEO > > > Montara Software, Inc. > > > http://www.MontaraSoftware.com > > > (888) 408-0900 x901 > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: [OT] xxxxxxCode.Com (Launched new site last night, feedback please!)
We do something sorta like that, I have a chunk of code that looks for a "debug cookie". If you have the cookie and the value is set to debug =on via a URL var, you can see all of the diagnostic code, all of the server debug code and allows us to see any errors rather then the "An error has occurred, the webadmin has been notified" message. Kinda handy, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Darron J. Schall [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:10 PM To: CF-Talk Subject: Re: [OT] .Com (Launched new site last night, feedback please!) Same deal here: We have xxx1.my.com for development, xxx2.my.com for staging, and www.my.com for production. We wrote a UDF that returns the sub domain based on the ip address. debugging output here! It's also useful in changing from http to https and ensure that the domain is right.. https://#getSubDomain()#.my.com Nothing is worse than having the live site link to stuff on your development server.. -d - Original Message - From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 3:18 PM Subject: Re: [OT] .Com (Launched new site last night, feedback please!) > Pablo, > We avoid the issue of "uncommenting" our error tags for production by > wrapping them in an if statement that looks at the cgi.server_name > var. I'm > sure there's multiple ways to handle this, but we've found it's way > easier to do if you're not relying on remembering to change that one > little thing before going live. -d > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Screen Cam software
It's not a "screen cam" but RoboDemo is a nifty little tool that makes a flash movie of your screen actions complete with popup descriptions of what you're doing. We use it here for teaching tutorials. http://www.ehelp.com/products/robodemo/ - Original Message - From: "Bushy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 10:43 PM Subject: OT: Screen Cam software > Hi, > > I have an application in CF that I want to show someone. I was thinking of using a screen cam software package but I'm not sure of the best one out there. > I recall using Lotus Screen Cam but it's ancient. > > Are there any new apps available? > > Thanks > > > > > > [EMAIL PROTECTED] > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Repost: SQL Help
Sure. > It would be easier if you showed the real query. Select 'False' as FSHUnknown, 'False' as E2Unknown, '' as ptGnRHaFlare, '' as PtGnRHaSupp, ci.caseid as clinicCycleID, Case count(stim.stimulationid) When Then 1 Else 0 End as PtUnstimulated, stim.labNormalFSHLevel as labFshUpLimitNormal, stim.maxFSHLevel as ptMaxFshLevel, stim.labNormalE2Level as labE2UpLimitNormal, stim.maxE2Level as ptMaxE2Level, Case stim.clomiphenedose When Then When NULL Then 0 Else 1 End AS ptClomiphene, stim.clomiphenedose as ptClomipheneDosage, Case stim.fshTotalIU When Then 0 When NULL Then 0 Else 1 End As PtFSH, stim.fshTotalIU as ptFSHDosage, stim.gnrhagonistid, gnrh.gnrhagonisttypename, Case stim.GNRHAntagonistDays When Then 0 When NULL Then 0 Else 1 End as PtGnRHA_Antagonist, Case (Select count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.protocolid = 12 and etp.etProcedureid = et.etProcedureid) When then 0 When NULL then 0 Else 1 End as transGIFT, Case (Select count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.protocolid IN (19,13) and etp.etProcedureid = et.etProcedureid) When then 0 When NULL then 0 Else 1 End as transZIFT, Case (Select count(etp.etprocedureid) from eTransferProtocolLink etp Where etp.protocolid NOT IN (19,13,12,6) and etp.etProcedureid = et.etProcedureid) When then 0 When NULL then 0 Else 1 End as transIVF, Case et.AHPERFORMED When 'None' Then 1 When 'Some' Then 2 When 'All' Then 3 Else 0 End as AZHid, et.treatmentAsIntended as asIntended, Case count(et.etprocedureid) When Then 0 When null Then 0 Else 1 End as transferAttempted, et.proceduredate from caseInfo ci Left Outer Join stimulation stim on ci.caseid = stim.caseid Left Outer join gnrhagonisttype gnrh on stim.gnrhagonisttypeid = gnrh.gnrhagonisttypeid Left Outer Join etProcedure et on ci.caseID = et.caseid Left Outer Join eTransferProtocolLink etp on et.etProcedureID = etp.etProcedureID Where ci.caseid IN (#session.sartdata.cycles.cyclespk#) Group By ci.caseid, stim.labNormalFSHLevel, stim.maxFSHLevel, stim.labNormalE2Level, stim.maxE2Level, stim.clomiphenedose, stim.fshTotalIU, stim.gnrhagonistid, gnrh.gnrhagonisttypename, stim.GNRHAntagonistDays, et.etProcedureID, et.AHPERFORMED, et.treatmentAsIntended, et.proceduredate > Which produces these results: > > CaseID | GIFT > --- > 76 0 > 77 1 > 78 0 > 78 1 > > I need to modify the query so that instead of seeing two rows with caseid > = 78, I see one row and a GIFT column = 1. Or: > > CaseID | GIFT > --- > 76 0 > 77 1 > 78 1 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
MVDB
>At 04:41 PM 9/9/2003 -0400, Don wrote: >>Have you ever tried to import your RainingData PICK database into a >>RDBMS like MS SQL Server >Sure, that would be preferable. But the problem is MV data does not >"map" directly to relational data. MV allows a "field" in a "table" to >actually contain multiple values or sub-data. I would think so too. >Check if your PICK >product has some export options that would "flatten" the data. For >example, turning all multivalues into a separate relational table. Great tip. I'll try it when I meet with the client next time. >If >it doesn't have this ability perhaps you could export to XML (which is >hierarchical and is more like MV data than SQL data). >Then there are >more tools available to translate XML into relational data. Here essentially you're saying, try Matt's XML tool or the similar. I have two concerns for this approach, say, a XML tool works well (Matt's a very smart guy, that's for sure) (a) this process has to be sort of automated because the target database needs to be refreshed regularly; (b) the cost and implementation efforts required for using such a tool. I'm constantly reminded that this client is very tight on cash spending. Thanks, Peter. Don > > >>>Yes, I am working on a project right now that uses a RainingData >PICK >>>database from a ColdFusion website. >>>We had all sorts of problems and finally decided to run the website > >>>from a local database (MySQL, but it could be anything) and have the > >>>administrator upload data from PICK periodically. >>> >>>We had trouble with GaExpress and finally wrote our own PICK program > >>>that listens on a TCP port and parses simple requests for data. In >CF >>>we use cfhttp to contact the PICK program and the results are put >into >>>a query object by manually parsing the results and using QueryNew, >>>QuerySetCell, etc... >>> >>>Remember: PICK is single threaded. The entire operating environment. > >>>Don't let your web site depend on it. >>> >>>At 08:57 AM 9/5/2003 -0700, LI, Chunshen \(Don\) wrote: Hello, I'm wondering if anyone has ever worked on a Multi-valued Database system like UniData from ROI. Thanks. >>> > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: MX 6.1: Permission to MS Access DSN denied!
Hah! It was sandbox security alright. Never messed with it after setting up the server, and the Access db was in the 'disabled' column'. Thanks Dave. This one has had me scratching my head for awhile. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: CFC Problem
Nope, there shouldn't be a limit. Line 31 was the partner line in the cfx call, right? If you ONLY output the args and comment out the cfx call, does the method call work? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Chris Alvarado [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:54 PM > To: CF-Talk > Subject: RE: CFC Problem > > > Did that, everything is coming through as expected. > > Is there a limit to the number of arguments you can have for > a given method? > > Maybe the exceptions portion of the debugging would help: > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Is there delay after updating collection
I've not noticed that there's a time lag between when a collection /finishes/ updating and when the data is available to search -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Andy Ousterhout [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 4:01 PM : To: CF-Talk : Subject: Is there delay after updating collection : : : Is there any delay between when a collection is updated and when : the results : are reflected in a search? : : Andy : : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Regex help
: This wouldn't, though. find AT at the beginning of the string, would it? Good point. (^| |[^c])at :-) BTW -- just a reminder to Doug and everyone else, http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21 is great for this kind of stuff. About half a dozen ninjas are ready to become your sensei. :-) CF-RegEx, for all your regex needs! -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Jerry Johnson [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 3:58 PM : To: CF-Talk : Subject: RE: Regex help : : : That's why you the ninja. : : This also helps solve his need for an index to just the AT part : of the word, rather than the beginning of the word (which is what : I was shooting towards). : : The find would return all the indexes one character less than the : start of the "at" string. : : This wouldn't, though. find AT at the beginning of the string, would it? : : Thanks for the fixes, : Jerry Johnson : : >>> [EMAIL PROTECTED] 09/11/03 03:47PM >>> : Technically, it doesn't since it doesn't match "at" by itself. : : (^|) This is either the beginning of the string or a space, so the : beginning of a word. Probably unnecessary in this case : : ([^ ]*) This is zero or more non-spaces. In this example, dots and : letters. : : ([^c ]) This is one not-c or not-space. : : at This is "at" :-) : : What you should really be using is : rereplacenocase(str, "([^c]| )at", "\1AT", "all") : which capitalizes all the "at"s except in "cat". : : -- Ben Doom : Programmer & General Lackey : Moonbow Software, Inc : : : -Original Message- : : From: Jerry Johnson [mailto:[EMAIL PROTECTED] : : Sent: Thursday, September 11, 2003 2:29 PM : : To: CF-Talk : : Subject: Re: Regex help : : : : : : Hopefully Ben can tell me why this appears to work. : : : : : : : : : : #f# : : : : : : Jerry Johnson : : : : : : >>> [EMAIL PROTECTED] 09/11/03 01:32PM >>> : : Regex help please. I've been busting my brain on this one. : : : : Here's what I'm trying to do, I could have string like: : : "...a cat hat prate at bird..." : : And I want to match all the "at" strings except the "at" string in the : : "cat". : : : : I tried a bunch of stuff like: "(^C)?at" but that didn't work. Is this : : possible? : : : : Thanks in advance, Doug : : : : : : : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Strange problem
Thats what it looks like to me. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:53 PM To: CF-Talk Subject: RE: Strange problem Error Occurred While Processing Request Connection Failure: Status code unavailable Now im pretty sure it is firewall related wouldn't you think? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:46 PM To: CF-Talk Subject: RE: Strange problem What happens if you switch to CFHTTP and just dump out the results? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:44 PM > To: CF-Talk > Subject: RE: Strange problem > > > Still erroriing out, has been doing so since yesturday... > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:42 PM > To: CF-Talk > Subject: RE: Strange problem > > > Could it have been a temporary network problem? Can you try again? > > == > == > === > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > (www.mindseye.com) > Member of Team Macromedia > (http://www.macromedia.com/go/teammacromedia) > > Email: > [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Kris Pilles [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 1:10 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > I did also notice that it was not putting an entry in the > webservices > > in the admin.. > > > > -Original Message- > > From: Raymond Camden [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 3:01 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > If you go to that machine, open a browser and enter the > URL, does it > > work? > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: [OT] ShittyCode.Com (Launched new site last night, feedback please!)
Same deal here: We have xxx1.my.com for development, xxx2.my.com for staging, and www.my.com for production. We wrote a UDF that returns the sub domain based on the ip address. debugging output here! It's also useful in changing from http to https and ensure that the domain is right.. https://#getSubDomain()#.my.com Nothing is worse than having the live site link to stuff on your development server.. -d - Original Message - From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 3:18 PM Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback please!) > Pablo, > We avoid the issue of "uncommenting" our error tags for production by > wrapping them in an if statement that looks at the cgi.server_name var. I'm > sure there's multiple ways to handle this, but we've found it's way easier > to do if you're not relying on remembering to change that one little thing > before going live. > -d > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Repost: SQL Help
Patricia G. L. Hall wrote: > > Select > Case > ( > Select count(etp.etprocedureid) > from eTransferProtocolLink etp > Where etp.etProcedureid = et.etProcedureid and > etp.protocolid = 12 > ) > When 0 then 0 > When null then 0 > Else 1 > End as GIFT, > et.caseid > from etprocedure et > > Which produces these results: > > CaseID | GIFT > --- > 76 0 > 77 1 > 78 0 > 78 1 > > I need to modify the query so that instead of seeing two rows with caseid > = 78, I see one row and a GIFT column = 1. Or: > > CaseID | GIFT > --- > 76 0 > 77 1 > 78 1 > > I would rather not do a [cfoutput group = 'caseid'] to solve the problem. > For one thing, I've simplified the query here... It would be easier if you showed the real query. Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Is there delay after updating collection
Is there any delay between when a collection is updated and when the results are reflected in a search? Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Regex help
That's why you the ninja. This also helps solve his need for an index to just the AT part of the word, rather than the beginning of the word (which is what I was shooting towards). The find would return all the indexes one character less than the start of the "at" string. This wouldn't, though. find AT at the beginning of the string, would it? Thanks for the fixes, Jerry Johnson >>> [EMAIL PROTECTED] 09/11/03 03:47PM >>> Technically, it doesn't since it doesn't match "at" by itself. (^|) This is either the beginning of the string or a space, so the beginning of a word. Probably unnecessary in this case ([^ ]*) This is zero or more non-spaces. In this example, dots and letters. ([^c ]) This is one not-c or not-space. at This is "at" :-) What you should really be using is rereplacenocase(str, "([^c]| )at", "\1AT", "all") which capitalizes all the "at"s except in "cat". -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Jerry Johnson [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 2:29 PM : To: CF-Talk : Subject: Re: Regex help : : : Hopefully Ben can tell me why this appears to work. : : : : : #f# : : : Jerry Johnson : : : >>> [EMAIL PROTECTED] 09/11/03 01:32PM >>> : Regex help please. I've been busting my brain on this one. : : Here's what I'm trying to do, I could have string like: : "...a cat hat prate at bird..." : And I want to match all the "at" strings except the "at" string in the : "cat". : : I tried a bunch of stuff like: "(^C)?at" but that didn't work. Is this : possible? : : Thanks in advance, Doug : : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Looking for a ColdFusion log parser
I've been thinking of trying something custom but I just have not had time yet. NO stealing my idea!!! j/k :-) I thought about making a schedules task that would dump the logs into a CSV file where I could import it into access or SQL and then use a template the search the logs that way. Should be quicker too since I'm looking at records and not some huge text file. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:56 PM To: CF-Talk Subject: RE: Looking for a ColdFusion log parser > You know what I think would be a good idea, is if MM could > create the logs in XML format. That would make for some big, verbose log files! They're easy enough to parse already, aren't they? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Looking for a ColdFusion log parser
Yes, they are easy enough to parse. I do like the XML idea. About being verbose, I guess it could be, but I think using an XML format would make it easier to create additional tools to use these files for reports and things. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:56 PM To: CF-Talk Subject: RE: Looking for a ColdFusion log parser > You know what I think would be a good idea, is if MM could > create the logs in XML format. That would make for some big, verbose log files! They're easy enough to parse already, aren't they? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: MX 6.1: Permission to MS Access DSN denied!
> What could cause MX 6.1 to put up this error: > > Security: The requested template has been denied access to > gmsample. The following is the internal exception message: > access denied (coldfusion.sql.DataSourcePermission gmsample) > > I created this datasource if CF Admin accepting all defaults. > No password is on the .mdb file. It happens when I create a > new db from scratch, or if I copy one over from somewhere > else. Also changing the format from the default Access 2000 > to Access 2002 is no help. I am using CF's native Access > driver, which also seems to be creating odbc connections > (visible if I go in and look at them in the odbc applet), > interestingly. > > The dsn verifies perfectly in Administrator. This looks like an error thrown by the sandbox security. You might want to look in the CF Administrator and see if your current sandbox security settings deny access to datasources for the directory in which your application is located. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Regex help
Note that to use this, you need to enable subexpressions and check the position on the proper one. It's easier just to match all of "rat" and add one, as someone suggested. -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: J E VanOver [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 3:53 PM : To: CF-Talk : Subject: RE: Regex help : : : [^cC](at) (in CF -- other RE engines would be [^cC]\(at\) : : -Original Message- : From: Teel, C. Doug [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 11:42 AM : To: CF-Talk : Subject: RE: Regex help : : : Thanks JE for the response. : : One note: This will also match something like "rat", but I only want the : "at" matched in rat. : : -Original Message- : From: J E VanOver [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 12:58 PM : To: CF-Talk : Subject: RE: Regex help : : : You're close ... : : [^cC]at should match any single character that is not c (or C) : followed by : "at" : : -Original Message- : From: Teel, C. Doug [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 10:33 AM : To: CF-Talk : Subject: Regex help : : : Regex help please. I've been busting my brain on this one. : : Here's what I'm trying to do, I could have string like: : "...a cat hat prate at bird..." : And I want to match all the "at" strings except the "at" string in the : "cat". : : I tried a bunch of stuff like: "(^C)?at" but that didn't work. Is this : possible? : : Thanks in advance, Doug : : : : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Regex help
That also won't match AAT or TAT -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Joshua Miller [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 3:48 PM : To: CF-Talk : Subject: RE: Regex help : : : [^cat]at : : That will match AT but not in CAT or CATalog or CATastrophe, etc. : : : Joshua Miller : Head Programmer / IT Manager : Garrison Enterprises Inc. : www.garrisonenterprises.net : [EMAIL PROTECTED] : (704) 569-0801 ext. 254 : : : * : Any views expressed in this message are those of the individual sender, : except where the sender states them to be the views of : Garrison Enterprises Inc. : : This e-mail is intended only for the individual or entity to which it is : addressed and contains information that is private and confidential. If : you are not the intended recipient you are hereby notified that any : dissemination, distribution or copying is strictly prohibited. If you : have received this e-mail in error please delete it immediately and : advise us by return e-mail to [EMAIL PROTECTED] : : * : : : -Original Message- : From: Claude Schneegans [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 3:01 PM : To: CF-Talk : Subject: Re: Regex help : : : >>but I only want the "at" matched in rat. : : As I said: just add one to the position. : : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Strange problem
Its weird because I can resolve the URL in the vrowser but it seems like Coldfusion can not... Any ideas how to fix on the firewall side? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:46 PM To: CF-Talk Subject: RE: Strange problem What happens if you switch to CFHTTP and just dump out the results? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:44 PM > To: CF-Talk > Subject: RE: Strange problem > > > Still erroriing out, has been doing so since yesturday... > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:42 PM > To: CF-Talk > Subject: RE: Strange problem > > > Could it have been a temporary network problem? Can you try again? > > == > == > === > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > (www.mindseye.com) > Member of Team Macromedia > (http://www.macromedia.com/go/teammacromedia) > > Email: > [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Kris Pilles [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 1:10 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > I did also notice that it was not putting an entry in the > webservices > > in the admin.. > > > > -Original Message- > > From: Raymond Camden [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 3:01 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > If you go to that machine, open a browser and enter the > URL, does it > > work? > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Strange problem
Error Occurred While Processing Request Connection Failure: Status code unavailable Now im pretty sure it is firewall related wouldn't you think? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:46 PM To: CF-Talk Subject: RE: Strange problem What happens if you switch to CFHTTP and just dump out the results? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:44 PM > To: CF-Talk > Subject: RE: Strange problem > > > Still erroriing out, has been doing so since yesturday... > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:42 PM > To: CF-Talk > Subject: RE: Strange problem > > > Could it have been a temporary network problem? Can you try again? > > == > == > === > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > (www.mindseye.com) > Member of Team Macromedia > (http://www.macromedia.com/go/teammacromedia) > > Email: > [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Kris Pilles [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 1:10 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > I did also notice that it was not putting an entry in the > webservices > > in the admin.. > > > > -Original Message- > > From: Raymond Camden [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 3:01 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > If you go to that machine, open a browser and enter the > URL, does it > > work? > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CFC Problem
Did that, everything is coming through as expected. Is there a limit to the number of arguments you can have for a given method? Maybe the exceptions portion of the debugging would help: Exceptions 14:46:37.037 - java.lang.NumberFormatException - in E:\Data\Published\wwwroot\developmentmx\verisignCFC\processPayment.cfc : line 31 For input string: "" Im stumped myself. Thanks for any and all help, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com phone: 281.807.4344 x1716 fax: 281.807.4384 > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 2:13 PM > To: CF-Talk > Subject: RE: CFC Problem > > > You have a lot of arguments there - you may want to try debugging. > Before calling the cfx, output each value, and make sure it > is what you > think it is. Ie > > > parter was passed as #arguments.partner# > > > I'd also add arguments. before the use of arguments - to be anal and > 100% safe. > > == > == > === > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > (www.mindseye.com) > Member of Team Macromedia > (http://www.macromedia.com/go/teammacromedia) > > Email: > [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Chris Alvarado [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 1:03 PM > > To: CF-Talk > > Subject: RE: CFC Problem > > > > > > Absolutely, > > > > Here is the code for the method causing the problem > > > > > > > > > output="true" returntype="query" hint="Process Credit Card > > (charge) using verisign."> > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Regex help
[^cC](at) (in CF -- other RE engines would be [^cC]\(at\) -Original Message- From: Teel, C. Doug [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 11:42 AM To: CF-Talk Subject: RE: Regex help Thanks JE for the response. One note: This will also match something like "rat", but I only want the "at" matched in rat. -Original Message- From: J E VanOver [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:58 PM To: CF-Talk Subject: RE: Regex help You're close ... [^cC]at should match any single character that is not c (or C) followed by "at" -Original Message- From: Teel, C. Doug [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 10:33 AM To: CF-Talk Subject: Regex help Regex help please. I've been busting my brain on this one. Here's what I'm trying to do, I could have string like: "...a cat hat prate at bird..." And I want to match all the "at" strings except the "at" string in the "cat". I tried a bunch of stuff like: "(^C)?at" but that didn't work. Is this possible? Thanks in advance, Doug ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Looking for a ColdFusion log parser
> You know what I think would be a good idea, is if MM could > create the logs in XML format. That would make for some big, verbose log files! They're easy enough to parse already, aren't they? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Regex help
Technically, it doesn't since it doesn't match "at" by itself. (^|) This is either the beginning of the string or a space, so the beginning of a word. Probably unnecessary in this case ([^ ]*) This is zero or more non-spaces. In this example, dots and letters. ([^c ]) This is one not-c or not-space. at This is "at" :-) What you should really be using is rereplacenocase(str, "([^c]| )at", "\1AT", "all") which capitalizes all the "at"s except in "cat". -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Jerry Johnson [mailto:[EMAIL PROTECTED] : Sent: Thursday, September 11, 2003 2:29 PM : To: CF-Talk : Subject: Re: Regex help : : : Hopefully Ben can tell me why this appears to work. : : : : : #f# : : : Jerry Johnson : : : >>> [EMAIL PROTECTED] 09/11/03 01:32PM >>> : Regex help please. I've been busting my brain on this one. : : Here's what I'm trying to do, I could have string like: : "...a cat hat prate at bird..." : And I want to match all the "at" strings except the "at" string in the : "cat". : : I tried a bunch of stuff like: "(^C)?at" but that didn't work. Is this : possible? : : Thanks in advance, Doug : : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Regex help
[^cat]at That will match AT but not in CAT or CATalog or CATastrophe, etc. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:01 PM To: CF-Talk Subject: Re: Regex help >>but I only want the "at" matched in rat. As I said: just add one to the position. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Strange problem
What happens if you switch to CFHTTP and just dump out the results? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:44 PM > To: CF-Talk > Subject: RE: Strange problem > > > Still erroriing out, has been doing so since yesturday... > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:42 PM > To: CF-Talk > Subject: RE: Strange problem > > > Could it have been a temporary network problem? Can you try again? > > == > == > === > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > (www.mindseye.com) > Member of Team Macromedia > (http://www.macromedia.com/go/teammacromedia) > > Email: > [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Kris Pilles [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 1:10 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > I did also notice that it was not putting an entry in the > webservices > > in the admin.. > > > > -Original Message- > > From: Raymond Camden [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 11, 2003 3:01 PM > > To: CF-Talk > > Subject: RE: Strange problem > > > > > > If you go to that machine, open a browser and enter the > URL, does it > > work? > > > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Strange problem
Still erroriing out, has been doing so since yesturday... -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:42 PM To: CF-Talk Subject: RE: Strange problem Could it have been a temporary network problem? Can you try again? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Kris Pilles [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 1:10 PM > To: CF-Talk > Subject: RE: Strange problem > > > I did also notice that it was not putting an entry in the > webservices in the admin.. > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:01 PM > To: CF-Talk > Subject: RE: Strange problem > > > If you go to that machine, open a browser and enter the URL, > does it work? > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: MVDB
At 04:41 PM 9/9/2003 -0400, Don wrote: >Have you ever tried to import your RainingData PICK database into a RDBMS like MS SQL >Server or MySQL then run querie against the RDBMS via ODBC driver or the like instead >of going after the "beast" directly, from what you wrote the latter is no fun? Sure, that would be preferable. But the problem is MV data does not "map" directly to relational data. MV allows a "field" in a "table" to actually contain multiple values or sub-data. Check if your PICK product has some export options that would "flatten" the data. For example, turning all multivalues into a separate relational table. If it doesn't have this ability perhaps you could export to XML (which is hierarchical and is more like MV data than SQL data). Then there are more tools available to translate XML into relational data. >>Yes, I am working on a project right now that uses a RainingData PICK >>database from a ColdFusion website. >>We had all sorts of problems and finally decided to run the website >>from a local database (MySQL, but it could be anything) and have the >>administrator upload data from PICK periodically. >> >>We had trouble with GaExpress and finally wrote our own PICK program >>that listens on a TCP port and parses simple requests for data. In CF >>we use cfhttp to contact the PICK program and the results are put into >>a query object by manually parsing the results and using QueryNew, >>QuerySetCell, etc... >> >>Remember: PICK is single threaded. The entire operating environment. >>Don't let your web site depend on it. >> >>At 08:57 AM 9/5/2003 -0700, LI, Chunshen \(Don\) wrote: >>>Hello, >>> >>>I'm wondering if anyone has ever worked on a >>>Multi-valued Database system like UniData from ROI. >>> >>>Thanks. >> > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
