Re: dishing up servlets on cfmx enterprise
On Fri, 7 Jan 2005 13:44:10 +0800, James Holmes [EMAIL PROTECTED] wrote: Servlets, yes; war files, no (in the standalone, anyway). Are you trying to run a servlet or deploy a war file? CFMX Enterprise is either CFMX + JRun in which case you can certainly run Servlets, deploy WAR files (they need manually expanding on JRun), etc etc; or CFMX as a WAR/EAR for deployment on a J2EE server - in which case you can certainly run Servlets, WAR files etc etc. KVS, can you provide a bit more detail about *exactly* what steps you went through and *exactly* what URL isn't working... -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189611 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: dishing up servlets on cfmx enterprise
Sean Where are you that you are up and working at this hour? Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189612 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dishing up servlets on cfmx enterprise
On Fri, 7 Jan 2005 00:08:51 -0800, Ken Ketsdever [EMAIL PROTECTED] wrote: Sean Where are you that you are up and working at this hour? Sitting in bed with my wife watching Nicole Kidman on Jay Leno - it's only just after midnight! -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189613 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: dishing up servlets on cfmx enterprise
Must be on the west coast. Sacramento myself -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 12:14 AM To: CF-Talk Subject: Re: dishing up servlets on cfmx enterprise On Fri, 7 Jan 2005 00:08:51 -0800, Ken Ketsdever [EMAIL PROTECTED] wrote: Sean Where are you that you are up and working at this hour? Sitting in bed with my wife watching Nicole Kidman on Jay Leno - it's only just after midnight! -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: dishing up servlets on cfmx enterprise
So familiar :D Glad I have wifi, I am even able to code on the toilet.. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189615 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: dishing up servlets on cfmx enterprise
Sean, can you elaborate on the manual expansion of a war file for the standalone install of CFMX 6.1 Enterprise (i.e. no separate Jrun install)? I've had people ask about this but I've never seen a doc for it. -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, 7 January 2005 4:07 To: CF-Talk Subject: Re: dishing up servlets on cfmx enterprise On Fri, 7 Jan 2005 13:44:10 +0800, James Holmes [EMAIL PROTECTED] wrote: Servlets, yes; war files, no (in the standalone, anyway). Are you trying to run a servlet or deploy a war file? CFMX Enterprise is either CFMX + JRun in which case you can certainly run Servlets, deploy WAR files (they need manually expanding on JRun), etc etc; or CFMX as a WAR/EAR for deployment on a J2EE server - in which case you can certainly run Servlets, WAR files etc etc. ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: dishing up servlets on cfmx enterprise
James You can use the java archive tool which comes with the JDK to expand .war, .jar, .ear files: jar -xvf somefile.war http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/instal16.htm http://java.sun.com/docs/books/tutorial/jar/basics/ HTH Kola -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 08:36 To: CF-Talk Subject: RE: dishing up servlets on cfmx enterprise Sean, can you elaborate on the manual expansion of a war file for the standalone install of CFMX 6.1 Enterprise (i.e. no separate Jrun install)? I've had people ask about this but I've never seen a doc for it. -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, 7 January 2005 4:07 To: CF-Talk Subject: Re: dishing up servlets on cfmx enterprise On Fri, 7 Jan 2005 13:44:10 +0800, James Holmes [EMAIL PROTECTED] wrote: Servlets, yes; war files, no (in the standalone, anyway). Are you trying to run a servlet or deploy a war file? CFMX Enterprise is either CFMX + JRun in which case you can certainly run Servlets, deploy WAR files (they need manually expanding on JRun), etc etc; or CFMX as a WAR/EAR for deployment on a J2EE server - in which case you can certainly run Servlets, WAR files etc etc. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189617 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dishing up servlets on cfmx enterprise
I am not going to mention the quality of the code made in a toilet?!?!?! On Fri, 7 Jan 2005 09:24:19 +0100, Micha Schopman [EMAIL PROTECTED] wrote: So familiar :D Glad I have wifi, I am even able to code on the toilet.. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189618 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: dishing up servlets on cfmx enterprise
It stinks? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dishing up servlets on cfmx enterprise
Or infact WinRar or WinZip will uncompress War files Regards MD On Fri, 7 Jan 2005 10:09:39 -, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: James You can use the java archive tool which comes with the JDK to expand .war, .jar, .ear files: jar -xvf somefile.war http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/instal16.htm http://java.sun.com/docs/books/tutorial/jar/basics/ HTH Kola -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 08:36 To: CF-Talk Subject: RE: dishing up servlets on cfmx enterprise Sean, can you elaborate on the manual expansion of a war file for the standalone install of CFMX 6.1 Enterprise (i.e. no separate Jrun install)? I've had people ask about this but I've never seen a doc for it. -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, 7 January 2005 4:07 To: CF-Talk Subject: Re: dishing up servlets on cfmx enterprise On Fri, 7 Jan 2005 13:44:10 +0800, James Holmes [EMAIL PROTECTED] wrote: Servlets, yes; war files, no (in the standalone, anyway). Are you trying to run a servlet or deploy a war file? CFMX Enterprise is either CFMX + JRun in which case you can certainly run Servlets, deploy WAR files (they need manually expanding on JRun), etc etc; or CFMX as a WAR/EAR for deployment on a J2EE server - in which case you can certainly run Servlets, WAR files etc etc. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Certification exam: Wait for Blackstone?
1. no idea 2. dunno, but i took the exam at CF4.5, and when CF5 came out a few months later i got a new certificate saying i was a CF5 certified (advanced) developer. 3. dunno 4. personally, i would wait. I had a vague plan to take the exam again sometime, but have put this on hold until the cf7 one comes out. Cheers Bert On Thu, 06 Jan 2005 10:20:16 -0400, Stephen Lapointe [EMAIL PROTECTED] wrote: For those with some insider knowledge, some questions about CF certification and Blackstone: 1) Will the Blackstone certification exam become available at about the same time as the Blackstone product release? 2) If someone were to take the CF certification exam now (and pass), would the certification be carried forward to Blackstone? 3) If the answer to 2 is no, would there be some coupon/discount for the Blackstone exam if you've taken the current CF exam just a short period before the Blackstone exam is available? 4) Bottom line: Would you recommend taking the CF certification exam now, or wait until the Blackstone exam becomes available? Thanks for any input. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189621 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Regex again
OK, a regular expressions is doing my head in again, can anyone help? What I'm trying to do is, match and replace all new line characters with br that are not inside html such as tables or lists, e.g. in the following string I would not want to add a br while I'm inside the ordered list. cfset testString = A test string with lots of line breaks ol li1/li li2/li li3/li /ol on several lines Sounds fairly simple? The \n bit for finding line breaks is at least ;D Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Clustering multiple CFMX server
That's just it. The steps that I followed are outlined on this page: http://www.talkingtree.com/blog/index.cfm?mode=entryentry=25A98D33-45A6-284 4-7E780B5AEBD8C085 Please do me that favor of looking over the instructions on that webpage and tell me if it is different from what you did. I really appreciate your help in getting to the bottom of this. -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 2:51 AM To: CF-Talk Subject: Re: Clustering multiple CFMX server On Thu, 6 Jan 2005 22:00:24 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: So I follow the directions from talkingtree.com and set everything up. The problem is that the cluster isn't working. When I hit the webpage, it will only hit the first server and if I shut the first one off and leave the second one on, it doesn't hit it. I basically get a Could not connect to JRun Server error. What am I doing wrong? Do you have separate ipaddresses assigned to each server in order to cluster them? Thanks in advance. Hmm, well, I've had a cluster running happily on my laptop which has only one IP address so I know it works. Can you provide a bit more information about exactly what steps you took? -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189623 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
List all Available Queries
Apart from Debugging is there any way to access all the available queries for a page stack/call? Maybe via the Factory? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189624 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dishing up servlets on cfmx enterprise
On Friday 07 Jan 2005 08:13 am, Sean Corfield wrote: Sean Where are you that you are up and working at this hour? Sitting in bed with my wife watching Nicole Kidman on Jay Leno - it's only just after midnight! Argh ! My minds eye ! There are children present :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44 (0)1749 834900 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834XXX web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189625 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: List all Available Queries
Yes, ... but only if you enable debugging in the administrator :) Only then, the service factory collects debugging information. If you use MSSQL, you might use Microsoft SQL Profiler, to view all executed queries and the corresponding information. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189626 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity)
Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Certification exam: Wait for Blackstone?
Hi, 1. It seems so from the insider information I saw. 2. Only for a limited period. I took the CF 5 Exam just before the CFMX release and got a 1 year validation. 3. Don't know of one 4. Wait - unless you have a really good reason for wanting it now. Kevin Roche On Thu, 06 Jan 2005 10:20:16 -0400, Stephen Lapointe [EMAIL PROTECTED] wrote: For those with some insider knowledge, some questions about CF certification and Blackstone: 1) Will the Blackstone certification exam become available at about the same time as the Blackstone product release? 2) If someone were to take the CF certification exam now (and pass), would the certification be carried forward to Blackstone? 3) If the answer to 2 is no, would there be some coupon/discount for the Blackstone exam if you've taken the current CF exam just a short period before the Blackstone exam is available? 4) Bottom line: Would you recommend taking the CF certification exam now, or wait until the Blackstone exam becomes available? Thanks for any input. ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity)
To do autonumbering you have to create a sequence and a trigger, to the best of my knowledge Toad does not provide a shortcut to creating these. I just edit a small snippet of code to reflect whatever table i need it for, such as: CREATE SEQUENCE SEQ_ACTIVITYLOG START WITH 1 MAXVALUE 1E27 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE OR REPLACE TRIGGER ITM.TRG_ACTIVITYLOG BEFORE INSERT ON ITM.ACTIVITYLOGREFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE x INTEGER; BEGIN IF :new.ID is null THEN SELECT SEQ_ACTIVITYLOG.NEXTVAL INTO x FROM DUAL; :new.ID := x; END IF; END; I just dumped those out of Toad, but at least put you down the right path, you probably can find countless examples of this via a google search. As far as the CFQUERies, your functions are going to be different between the two databases and the way you do joins might end up needing some changes. Will depend on what version of Oracle as to how different joins might need to be done. -- Aaron Rouse http://www.happyhacker.com/ On Fri, 7 Jan 2005 09:13:47 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity)
Your queries should be AOK...as long as you are not using any Oracle Specific SQL commands..though really apart from some quirky join syntax you should all be good. If you are simply sticking to Insert, delete etc. -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 14:14 To: CF-Talk Subject: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity) Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189630 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Where to place .vtm tag insight files
Hello, I use Dreamweaver 2004 for all my Cf'in and have some .vtm tag insight files I need to add. What folder do I need to place those in? It seems pretty straight forward in homesite, but I can't find the equivalent in DW. JB ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF 4.5 HTML Mail
I was wondering if anyone knew how to send html e-mail in CF 4.5. I know in 6.1 you can use the cfmailpart tag inside cfmail and thus specify different parts (eg. Text, html). How do you do the equivalent in pre 6.1 versions? Specifically 4.5. Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189632 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity)
One thing to keep in mind is Oracle is case sensitive where if I remember right MSSQL is not? So something like WHERE BLAH = 'foo' returns something different than WHERE BLAH = 'FoO' I know some people just do oracles upper function on the BLAH in order to get around this, then of course a CF's upper function on the other side. Only problem with that is if you are accessing a table with a lot of rows, Oracle ends up doing its upper function on the entire column which can slow things down a bit when running the query. -- Aaron Rouse http://www.happyhacker.com/ On Fri, 7 Jan 2005 14:19:40 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Your queries should be AOK...as long as you are not using any Oracle Specific SQL commands..though really apart from some quirky join syntax you should all be good. If you are simply sticking to Insert, delete etc. -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 14:14 To: CF-Talk Subject: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity) Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189633 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity)
Thanks for that Aaron, that should certainly put me on the right track. Out of curiosity i couldn't help but try and access your website... but... the firewall of this very large financial company in London blocked it. It let me look at happyhacker.org though, maybe because it's ORGanised happyhacking! ;) Saturday -- Original Message -- From: Aaron Rouse [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Fri, 7 Jan 2005 08:21:23 -0600 To do autonumbering you have to create a sequence and a trigger, to the best of my knowledge Toad does not provide a shortcut to creating these. I just edit a small snippet of code to reflect whatever table i need it for, such as: CREATE SEQUENCE SEQ_ACTIVITYLOG START WITH 1 MAXVALUE 1E27 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE OR REPLACE TRIGGER ITM.TRG_ACTIVITYLOG BEFORE INSERT ON ITM.ACTIVITYLOGREFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE x INTEGER; BEGIN IF :new.ID is null THEN SELECT SEQ_ACTIVITYLOG.NEXTVAL INTO x FROM DUAL; :new.ID := x; END IF; END; I just dumped those out of Toad, but at least put you down the right path, you probably can find countless examples of this via a google search. As far as the CFQUERies, your functions are going to be different between the two databases and the way you do joins might end up needing some changes. Will depend on what version of Oracle as to how different joins might need to be done. -- Aaron Rouse http://www.happyhacker.com/ On Fri, 7 Jan 2005 09:13:47 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189634 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF 4.5 HTML Mail
Theres a custom tag written by Jochem that used to do this... CF_ADVANCEDEMAIL i beleive it was called... Google that and it should help HTH On Fri, 7 Jan 2005 09:27:11 -0500, Russ [EMAIL PROTECTED] wrote: I was wondering if anyone knew how to send html e-mail in CF 4.5. I know in 6.1 you can use the cfmailpart tag inside cfmail and thus specify different parts (eg. Text, html). How do you do the equivalent in pre 6.1 versions? Specifically 4.5. Russ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189635 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity)
Actually the power source for the my rack has been down for a week. Hopefully it will be back up next week. Has not really been a big priority of mine to bug the guy who needs to fix it. Also kind of the joys of free hosting .net .com and .info should all be pointing to the same IP which is the web server on that rack. Good luck with the Oracle, I did this switch over a few years back and was not too bad at all. Toad really does help out a lot, I still do not know half of its functionality. On Fri, 7 Jan 2005 09:31:06 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Thanks for that Aaron, that should certainly put me on the right track. Out of curiosity i couldn't help but try and access your website... but... the firewall of this very large financial company in London blocked it. It let me look at happyhacker.org though, maybe because it's ORGanised happyhacking! ;) Saturday -- Original Message -- From: Aaron Rouse [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Fri, 7 Jan 2005 08:21:23 -0600 To do autonumbering you have to create a sequence and a trigger, to the best of my knowledge Toad does not provide a shortcut to creating these. I just edit a small snippet of code to reflect whatever table i need it for, such as: CREATE SEQUENCE SEQ_ACTIVITYLOG START WITH 1 MAXVALUE 1E27 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE OR REPLACE TRIGGER ITM.TRG_ACTIVITYLOG BEFORE INSERT ON ITM.ACTIVITYLOGREFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE x INTEGER; BEGIN IF :new.ID is null THEN SELECT SEQ_ACTIVITYLOG.NEXTVAL INTO x FROM DUAL; :new.ID := x; END IF; END; I just dumped those out of Toad, but at least put you down the right path, you probably can find countless examples of this via a google search. As far as the CFQUERies, your functions are going to be different between the two databases and the way you do joins might end up needing some changes. Will depend on what version of Oracle as to how different joins might need to be done. -- Aaron Rouse http://www.happyhacker.com/ On Fri, 7 Jan 2005 09:13:47 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189636 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: List all Available Queries
Apart from Debugging is there any way to access all the available queries for a page stack/call? Maybe via the Factory? Loop over scope(s), as a structure, and test each key with the isQuery() function. Pseudo-Code: cfset keys = struckKeyList(variables) cfloop list=#keys# index=thisOne cfif isQuery(thisOne) Query foundbr cfelse Query not foundbr /cfif /cfloop Obviously, you'd want to improve this code and make it work for multiple scopes. I think this beats hitting the factory. M!ke ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189637 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: List all Available Queries
From: Dawson, Michael [mailto:[EMAIL PROTECTED] cfset keys = struckKeyList(variables) cfloop list=#keys# index=thisOne cfif isQuery(thisOne) Query foundbr cfelse Query not foundbr /cfif /cfloop Obviously, you'd want to improve this code and make it work for multiple scopes. I think this beats hitting the factory. I think the above would take a long time, especially if you had a good sized application that used many scopes and a decent amount of variables in them. My guess is that the factory would be much better. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189638 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity)
One thing to keep in mind is Oracle is case sensitive where if I remember right MSSQL is not? Microsoft SQL Server uses a case-insensitive collation sequence by default. Collation sequences describe case sensitivity, sort order as well as the character set. This can be configured at the server, database, table, and column level. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity)
Small correction. The collation sequence stores the code page used, not the character set. That's determined by the column data type. My mistake. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Ben Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 9:50 AM To: CF-Talk Subject: RE: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity) One thing to keep in mind is Oracle is case sensitive where if I remember right MSSQL is not? Microsoft SQL Server uses a case-insensitive collation sequence by default. Collation sequences describe case sensitivity, sort order as well as the character set. This can be configured at the server, database, table, and column level. Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam and Unique Identifiers
CF_SQL_VARCHAR works in Access, mySQL, SQL Server, Oracle 8 and Oracle 9. A safe bet it works in Oracle 10. I'll have to check the docs on that IDSTAMP type. Never heard of it. rtfm. -- --mattRobertson-- President, Janitor MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
New CF Install: Do I need the Updater?
I'm migrating CF on a server from its Three's Company condo (dedicated box shared by mail and db servers) to its very own home. A fresh-install win2k box. I just finished installing the file I downloaded from MM on 1/5/05. Does anyone know if the current MM CF download includes the Updater, or do I need to install that as well? I have my original CF download from 2003 and the file size is smaller and the installer acts subtly different. -- --mattRobertson-- President, Janitor MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189642 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity)
Only problem with that is if you are accessing a table with a lot of rows, Oracle ends up doing its upper function on the entire column which can slow things down a bit when running the query. Look into function based indexes to solve this. Buy the book Expert one-on-one Oracle by Tom Kyte (Wrox/Apress) if you want to unlock the more powerful features of Oracle (but it should not be your first Oracle book obviously). If your customer is paying all that money for an Oracle license, you should be looking at maximizing their return. just my 0.02$, /t -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 3:30 PM To: CF-Talk Subject: Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity) One thing to keep in mind is Oracle is case sensitive where if I remember right MSSQL is not? So something like WHERE BLAH = 'foo' returns something different than WHERE BLAH = 'FoO' I know some people just do oracles upper function on the BLAH in order to get around this, then of course a CF's upper function on the other side. Only problem with that is if you are accessing a table with a lot of rows, Oracle ends up doing its upper function on the entire column which can slow things down a bit when running the query. -- Aaron Rouse http://www.happyhacker.com/ On Fri, 7 Jan 2005 14:19:40 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Your queries should be AOK...as long as you are not using any Oracle Specific SQL commands..though really apart from some quirky join syntax you should all be good. If you are simply sticking to Insert, delete etc. -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 14:14 To: CF-Talk Subject: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity) Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189643 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
WIKI App?
Has anyone used a free CF Wiki tag/app? I can also use a Web based solution, assuming it's free and private. Any recommendations? Thanks! Jake ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189644 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Regex again
Actually, this isn't simple. Offhand, I don't see a way to do this with regex that isn't more complicated than other methods. What you are really asking to do is parse an HTML page and selectivly replace tokens. The easiest way I see to do it -- and this isn't particularly robust -- is to remove the head and the foot from the page, find tables and lists, and split up what's left where the tables and lists where. Then, do your replace. I know that's not the answer you wanted, but it's the answer I got. Hopefully, someone smarter (and with more caffiene in their system) has a better suggestion. --Ben Craig Dudley wrote: OK, a regular expressions is doing my head in again, can anyone help? What I'm trying to do is, match and replace all new line characters with br that are not inside html such as tables or lists, e.g. in the following string I would not want to add a br while I'm inside the ordered list. cfset testString = A test string with lots of line breaks ol li1/li li2/li li3/li /ol on several lines Sounds fairly simple? The \n bit for finding line breaks is at least ;D Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189645 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regex again
Thanks Ben, I'm coming to the same conclusion, only after hours of head scratching. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 15:08 To: CF-Talk Subject: Re: Regex again Actually, this isn't simple. Offhand, I don't see a way to do this with regex that isn't more complicated than other methods. What you are really asking to do is parse an HTML page and selectivly replace tokens. The easiest way I see to do it -- and this isn't particularly robust -- is to remove the head and the foot from the page, find tables and lists, and split up what's left where the tables and lists where. Then, do your replace. I know that's not the answer you wanted, but it's the answer I got. Hopefully, someone smarter (and with more caffiene in their system) has a better suggestion. --Ben Craig Dudley wrote: OK, a regular expressions is doing my head in again, can anyone help? What I'm trying to do is, match and replace all new line characters with br that are not inside html such as tables or lists, e.g. in the following string I would not want to add a br while I'm inside the ordered list. cfset testString = A test string with lots of line breaks ol li1/li li2/li li3/li /ol on several lines Sounds fairly simple? The \n bit for finding line breaks is at least ;D Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189646 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WIKI App?
http://www.seedwiki.com/ was on sourceforge for download if i remember correct, a simpler one it's here http://cdsi-solutions.com/cfwiki/index.cfm?doc=CFWiki On Fri, 07 Jan 2005 09:08:01 -0600, Jake [EMAIL PROTECTED] wrote: Has anyone used a free CF Wiki tag/app? I can also use a Web based solution, assuming it's free and private. Any recommendations? Thanks! Jake ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189647 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity)
True, though the exact example I was thinking of was when someone was access a database they only had select access to. I typically never even run into this need, on one of my tables I have the exact value pulled from LDAP and then an upper cased copy of the value and just reference that. Anyway, that upper thing I have seen bite a couple of people at work more than once, seems to be something they commonly forget about. That and synonyms, no idea why that is. On Fri, 07 Jan 2005 16:02:09 +0100, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: Only problem with that is if you are accessing a table with a lot of rows, Oracle ends up doing its upper function on the entire column which can slow things down a bit when running the query. Look into function based indexes to solve this. Buy the book Expert one-on-one Oracle by Tom Kyte (Wrox/Apress) if you want to unlock the more powerful features of Oracle (but it should not be your first Oracle book obviously). If your customer is paying all that money for an Oracle license, you should be looking at maximizing their return. just my 0.02$, /t -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 3:30 PM To: CF-Talk Subject: Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trin ity) One thing to keep in mind is Oracle is case sensitive where if I remember right MSSQL is not? So something like WHERE BLAH = 'foo' returns something different than WHERE BLAH = 'FoO' I know some people just do oracles upper function on the BLAH in order to get around this, then of course a CF's upper function on the other side. Only problem with that is if you are accessing a table with a lot of rows, Oracle ends up doing its upper function on the entire column which can slow things down a bit when running the query. -- Aaron Rouse http://www.happyhacker.com/ On Fri, 7 Jan 2005 14:19:40 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Your queries should be AOK...as long as you are not using any Oracle Specific SQL commands..though really apart from some quirky join syntax you should all be good. If you are simply sticking to Insert, delete etc. -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 14:14 To: CF-Talk Subject: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity) Hi guys, I'm about to start on a new project at my current contract for which i've had them buy CF (and for once i didn't take too much convincing). In the past (and present) I connect to an MS-SQL database which i've grown to love. At work however, it's all Oracle. I've connected it using the CF Administrator and am using TOAD to add tables etc. Before i start coding i'm wondering if my CFQUERYies will be different to those I have created for MS-SQL in anyway? Thanks for your help, Stu ps: also, does anyone know how to create an incremental number for an INT in TOAD (it's for an PK id)? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189648 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WIKI App?
Jake wrote: Has anyone used a free CF Wiki tag/app? I can also use a Web based solution, assuming it's free and private. Any recommendations? I'm developing one called FusionWiki for my own use primarily, though its development is hosted by SourceForge and it's licenced under the Common Public License and anybody can contribute to or use it. But I think it's a little too primitive right now seeing as it's derived from a quick hack I had to write about a year ago, and I'm only right after starting the project. :-) Take a look at SeedWiki instead. It's the only other half-decent CF-based wiki I know of, though you need MX to run it, which probably isn't a problem. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.9 - Release Date: 06/01/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: dishing up servlets on cfmx enterprise
i added this to the war.xml file located in the WEB-INF directory. servlet servlet-namectzPackage.ListServ/servlet-name servlet-classctzPackage.ListServ/servlet-class /servlet servlet-mapping servlet-namectzPackage.ListServ/servlet-name url-pattern/listserv.do/url-pattern /servlet-mapping I tried to hit the servlet via http://localhost:8500/listserv.do?etc... On Fri, 7 Jan 2005 00:07:28 -0800, Sean Corfield [EMAIL PROTECTED] wrote: On Fri, 7 Jan 2005 13:44:10 +0800, James Holmes [EMAIL PROTECTED] wrote: Servlets, yes; war files, no (in the standalone, anyway). Are you trying to run a servlet or deploy a war file? CFMX Enterprise is either CFMX + JRun in which case you can certainly run Servlets, deploy WAR files (they need manually expanding on JRun), etc etc; or CFMX as a WAR/EAR for deployment on a J2EE server - in which case you can certainly run Servlets, WAR files etc etc. KVS, can you provide a bit more detail about *exactly* what steps you went through and *exactly* what URL isn't working... -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Consuming RSS in CF 4.5
Hi, Can't seem to find an example on consuming a RSS feed in CF 4.5. A lot of the examples are for CF MX which uses XMLParse function. Anyone with some code snippet...? Nyon ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Consuming RSS in CF 4.5
Just a couple of suggestions for you... http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =24060forumid=4 Which suggest getting an XML parsing custom tag from the devx Or http://www.box-one.org/new-2148376-4547.html Which (pretty cooly) suggest using cfwddx Someone might chime in with a snippet tho :) -- dc ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189652 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Query Question
We are using CF5.x and MSSQL server and I have a particular conundrum I am hoping one of you SQL experts can assist with. I have a record set like so: PN, V1, V2, V3...V15 Each V field contains a numeric value for each record. So a short record set might look something like: PN, V1, V2, V3 A 120 240 460 B 120 220 440 C 220 460 480 D 240 460 120 I need to query the database and come up with a result set of unique values for ALL the V fields across all records. So using the example above the optimum result would be a query with the result that would be: 120 220 240 440 460 480 I would like to let the database do the work instead of doing it in CF with loops but I am out of my depth on this particular query set. Any assistance would be appreciated. Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189653 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Raymond Camden Blog
Anyone have any experience with this blog app. I trying to use it and it looks like I have it installed properly but when I log in I don't get a menu to add an entry. So I tried logging in with the wrong password and there was no error message. Could it be that there is a problem but the system want tell that me that there is a problem? www.fluxflow.com/bloggingCole dwayne cole ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189654 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query Question
Others will probably come up with a better way, but my first thought was a series of unions. SELECT DISTINCT values FROM ( SELECT DISTINCT v1 AS values FROM table UNION SELECT DISTINCT v2 AS values FROM table UNION SELECT DISTINCT v3 AS values FROM table ) -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Dennis Powers [mailto:[EMAIL PROTECTED] ...Sent: Friday, January 07, 2005 8:01 AM ...To: CF-Talk ...Subject: SQL Query Question ... ...We are using CF5.x and MSSQL server and I have a particular conundrum I ...am ...hoping one of you SQL experts can assist with. ... ...I have a record set like so: PN, V1, V2, V3...V15 Each V field ...contains a ...numeric value for each record. So a short record set might look ...something ...like: ... ...PN, V1, V2, V3 ...A 120 240 460 ...B 120 220 440 ...C 220 460 480 ...D 240 460 120 ... ...I need to query the database and come up with a result set of unique ...values ...for ALL the V fields across all records. So using the example above ...the ...optimum result would be a query with the result that would be: ... ...120 ...220 ...240 ...440 ...460 ...480 ... ...I would like to let the database do the work instead of doing it in CF ...with ...loops but I am out of my depth on this particular query set. Any ...assistance ...would be appreciated. ... ... ...Best Regards, ... ...Dennis Powers ...UXB Internet- A Website Design and Hosting Company ...690 Wolcott Road - P.O. Box 6028 ...Wolcott, CT 06716tel: (203)879-2844 ...http://www.uxbinternet.com ...http://dennis.uxb.net ... ... ... ... ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Scheduled Tasks in CF5
I have some scheduled tasks on the Admin but theses tasks aren't executed in the expected time.. all tasks scheduled for day execution interval runs fine but the hours interval fails. Any ideas?... David. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189656 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Raymond Camden Blog
There's really no menu per se - after you log in, you should get Add New Entry - Logout displayed at the top of the main body area, probably just above the Sorry There are no blog entries available message. Is that showing up at all? -joe On Fri, 7 Jan 2005 11:03:33 -0500, Dwayne Cole [EMAIL PROTECTED] wrote: Anyone have any experience with this blog app. I trying to use it and it looks like I have it installed properly but when I log in I don't get a menu to add an entry. So I tried logging in with the wrong password and there was no error message. Could it be that there is a problem but the system want tell that me that there is a problem? www.fluxflow.com/bloggingCole dwayne cole ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189657 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Raymond Camden Blog
On Fri, 7 Jan 2005 11:03:33 -0500, Dwayne Cole [EMAIL PROTECTED] wrote: Anyone have any experience with this blog app. It powers my blog just fine. I trying to use it and it looks like I have it installed properly but when I log in I don't get a menu to add an entry. So I tried logging in with the wrong password and there was no error message. If you give bad login details, you just get the regular blog home page. So it sounds like you don't have the initial user name setup correctly. Did you change the login information in the .ini file and/or the .sql file? -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189658 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: New CF Install: Do I need the Updater?
I believe you need to install 6.1 and then apply the updater. On Fri, 7 Jan 2005 07:01:49 -0800, Matt Robertson [EMAIL PROTECTED] wrote: I'm migrating CF on a server from its Three's Company condo (dedicated box shared by mail and db servers) to its very own home. A fresh-install win2k box. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189659 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Simple Content Management
We need a tool to collect and organize information in order to build documentation for a project in a collaborative fashion. We've actually used blogs in the past to document the installation of software and such. A blog won't work in this case, however, as we need to be able organize information in a hierarchical fashion, not chronological. Wiki's are interesting and would probably work technically speaking. However, I think it will be too difficult to teach everyone how to use a Wiki. Also, a Wiki is a little too free form. We need to define the structure and let people provide the content. Does such a tool exist? We don't really care whether or not it's written in ColdFusion. It needs to run on Windows, however. I think we're looking for something Web based, but that's not a requirement (we have admin access to desktops and can install software). Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
(U) Referring to UDF Structure Values After Function is Run
Classification: UNCLASSIFIED Howdy, I'm running some tests using the GetContainer UDF ( http://www.cflib.org/udf.cfm?ID=566 ). That function creates a couple of structures (container and container.contents). Wondering how to refer to the structure values after the UDF is run in my template. For example, I'd like to use container.contents.end, container.contents.len, container.contents.str later in my page. How to do that? Running CF5 on Win2003. Thanks! Chris Montgomery, VAMP Programmer HQ AF Security Forces Center, Antiterrorism Branch 1517 Billy Mitchell Blvd, Bldg 954 Lackland AFB, TX 78236-0119 DSN 312.945.0432 Comm 210.925.0432 Classification: UNCLASSIFIED ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189661 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (U) Referring to UDF Structure Values After Function is Run
At first glance, it returns the container. Simply assign the output of the UDF to a variable, and then reference the variable: container = getcontainer(stuff); result = container.length; bob = getcontainer(stuff); jim = bob.end; Again, this is first glance, off the top of my head, but it should work. --Ben Montgomery Chris Contr AFSFC/SFPA wrote: Classification: UNCLASSIFIED Howdy, I'm running some tests using the GetContainer UDF ( http://www.cflib.org/udf.cfm?ID=566 ). That function creates a couple of structures (container and container.contents). Wondering how to refer to the structure values after the UDF is run in my template. For example, I'd like to use container.contents.end, container.contents.len, container.contents.str later in my page. How to do that? Running CF5 on Win2003. Thanks! Chris Montgomery, VAMP Programmer HQ AF Security Forces Center, Antiterrorism Branch 1517 Billy Mitchell Blvd, Bldg 954 Lackland AFB, TX 78236-0119 DSN 312.945.0432 Comm 210.925.0432 Classification: UNCLASSIFIED ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Dynamically creating multiple pages/rows of images from a query
Would like to create a preview page(s) of results froma search function from an image catalog. Displaying 1 image per row seems easy enough, but we would like to display 3 images per row and either 3 or 4 rows per page. Is a loop or multiple loops within a loop the only way to output 3 results per row as well as multiple rows? Or am I approaching this from a wrong-headed point of view. My mind tells me it should be much easier than what I'm thinking, but for the life of me I can't see how. Thanks, Charles Nahm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189663 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamically creating multiple pages/rows of images from a query
I've done something similar in the past. You just have to be strategic with your tr tags. cfquery name=images' datasource=#DSN# SELECT image_name FROM images /cfquery table tr cfoutput query=images tdimg src=#image_name#/td cfif CurrentRow MOD 3 EQ 0 !--- Current row is a multiple of 3, so close it and start another --- /trtr /cfif /cfoutput /tr /table Simple (and untested) but that should give you the idea. On Fri, 7 Jan 2005 12:11:46 -0500, Charles Nahm [EMAIL PROTECTED] wrote: Would like to create a preview page(s) of results froma search function from an image catalog. Displaying 1 image per row seems easy enough, but we would like to display 3 images per row and either 3 or 4 rows per page. Is a loop or multiple loops within a loop the only way to output 3 results per row as well as multiple rows? Or am I approaching this from a wrong-headed point of view. My mind tells me it should be much easier than what I'm thinking, but for the life of me I can't see how. Thanks, Charles Nahm ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189665 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (U) Referring to UDF Structure Values After Function is Run
Classification: UNCLASSIFIED Looks like that will work. I had: cfset temp = #GetContainer(teststring, 'ErrorResponse', '/ErrorResponse')# but was trying to output: cfoutput container.contents.start = #GetContainer.container.contents.start#br container.contents.end = #container.contents.end#br container.contents.len = #container.contents.len#br container.contents.str = #container.contents.str#br /cfoutput changing it to the following worked: cfoutput container.contents.start = #temp.contents.start#br container.contents.end = #temp.contents.end#br container.contents.len = #temp.contents.len#br container.contents.str = #temp.contents.str#br /cfoutput Brainfart with the variable name. Thanks, Ben! Chris Montgomery, VAMP Programmer HQ AF Security Forces Center, Antiterrorism Branch 1517 Billy Mitchell Blvd, Bldg 954 Lackland AFB, TX 78236-0119 DSN 312.945.0432 Comm 210.925.0432 -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 10:57 AM To: CF-Talk Subject: Re: (U) Referring to UDF Structure Values After Function is Run At first glance, it returns the container. Simply assign the output of the UDF to a variable, and then reference the variable: container = getcontainer(stuff); result = container.length; bob = getcontainer(stuff); jim = bob.end; Again, this is first glance, off the top of my head, but it should work. --Ben -- Classification: UNCLASSIFIED ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189664 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamically creating multiple pages/rows of images from a query
Hiya - The way I do it is to simply loop through the query once, but what you need to do is know first of all how many columns you want to display. This is pseudo code (i.e. it wont work :) and would need you to write it properly yourself of course... cfset cols = 4 cfset currentcol = 1 table border=1 cfloop query=myQuery cfif currentcol is 1 trtd /cfif img src=#myQuery.imageURL# cfif currentcol ge maxcols /td/tr cfset currentcol = 1 /cfif /cfloop /table Something like that OR (probably easier) If you're using CSS for formatting and quite hot on how to make stuff align you could use divs to display xx columns rather than table cells. You could then use the myQuery.currentrow to decide wether to open a new DIV or close an existing one. I'm in a rush to get out so I'm sorry if it doesn't make sense immediately. Please ask if your unsure. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: 07 January 2005 17:12 To: CF-Talk Subject: Dynamically creating multiple pages/rows of images from a query Would like to create a preview page(s) of results froma search function from an image catalog. Displaying 1 image per row seems easy enough, but we would like to display 3 images per row and either 3 or 4 rows per page. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189666 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamically creating multiple pages/rows of images from a query
Something along these lines might get you started. cfset cols = 4!---number of columns you would like--- cfoutput table tr cfloop query=myQuery td#query.column#/td !---If the remainder of currentRow/cols is zero start a new row.--- cfif NOT myQuery.currentRow MOD cols /tr tr /cfif /cfloop /tr /table /cfoutput Off the top of my head, AKA debugging no doutedly necessary. This could also be very easily modified to create other structures to display the output. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Charles Nahm [mailto:[EMAIL PROTECTED] ...Sent: Friday, January 07, 2005 9:12 AM ...To: CF-Talk ...Subject: Dynamically creating multiple pages/rows of images from a query ... ...Would like to create a preview page(s) of results froma search function ...from ...an image catalog. Displaying 1 image per row seems easy enough, but we ...would like to display 3 images per row and either 3 or 4 rows per page. ... ...Is a loop or multiple loops within a loop the only way to output 3 ...results ...per row as well as multiple rows? Or am I approaching this from a ...wrong-headed point of view. My mind tells me it should be much easier ...than ...what I'm thinking, but for the life of me I can't see how. ... ...Thanks, ...Charles Nahm ... ... ... ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Question about data access
Hi, I have determined I have some database schema issues necessitating rewriting the data access code. Currently I use cfquery with a couple stored procedures. Since the new database structure will require I change these queries, I am contemplating the idea of creating cfc's which contain stored procedures to handle the data access for the site. I am not the uber programmer to be sure, and to me the idea seems cool, but am unsure of the real benefits in terms of reuse, speed, etc. I was wondering if anyone had experience moving their data access into cfcs using stored procedures, and what their experience was like, what their motivations were, and how they feel about having done it now. Was it a good idea, and would they do it again? Any comments greatly appreciated. Thanks, John ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189668 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: New CF Install: Do I need the Updater?
OK Thx Sean. I compared build numbers on my current server and the one I am building up and they are indeed different, with the 6.1 build being lower. Cheers, -- --mattRobertson-- President, Janitor MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Simple Content Management
This one is free and has an installer. You can be up in a couple of minutes: http://mysecretbase.com/CMLite_Home.cfm version 4 of the for-pay version is hitting RC3 today; the last before release. Has Team Review (approval workflow) among many other items. -- --mattRobertson-- President, Janitor MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamically creating multiple pages/rows of images from a query
Thank you very much Ian, Martin and Al. Your way is much better than my way of thinking for sure. I appreciate the virtual smack upside the head. Charles -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 12:25 PM To: CF-Talk Subject: RE: Dynamically creating multiple pages/rows of images from a query Something along these lines might get you started. cfset cols = 4!---number of columns you would like--- cfoutput table tr cfloop query=myQuery td#query.column#/td !---If the remainder of currentRow/cols is zero start a new row.--- cfif NOT myQuery.currentRow MOD cols /tr tr /cfif /cfloop /tr /table /cfoutput Off the top of my head, AKA debugging no doutedly necessary. This could also be very easily modified to create other structures to display the output. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Charles Nahm [mailto:[EMAIL PROTECTED] ...Sent: Friday, January 07, 2005 9:12 AM ...To: CF-Talk ...Subject: Dynamically creating multiple pages/rows of images from a query ... ...Would like to create a preview page(s) of results froma search function ...from ...an image catalog. Displaying 1 image per row seems easy enough, but we ...would like to display 3 images per row and either 3 or 4 rows per page. ... ...Is a loop or multiple loops within a loop the only way to output 3 ...results ...per row as well as multiple rows? Or am I approaching this from a ...wrong-headed point of view. My mind tells me it should be much easier ...than ...what I'm thinking, but for the life of me I can't see how. ... ...Thanks, ...Charles Nahm ... ... ... ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189671 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question about data access
Look at Mach-II if you want to see a best-practice approach for what you are talking about. You don't have to take the full OO approach that Mach-II uses, but the overall idea that you separate your data access layer into objects (CFCs in this case) is part of the Mach-II framework and other OO programming models. I've just been playing with Mach-II lately, others on the list who are closer to the framework or are otherwise experienced OO programmers may have more detail to share with you. Hi, I have determined I have some database schema issues necessitating rewriting the data access code. Currently I use cfquery with a couple stored procedures. Since the new database structure will require I change these queries, I am contemplating the idea of creating cfc's which contain stored procedures to handle the data access for the site. I am not the uber programmer to be sure, and to me the idea seems cool, but am unsure of the real benefits in terms of reuse, speed, etc. I was wondering if anyone had experience moving their data access into cfcs using stored procedures, and what their experience was like, what their motivations were, and how they feel about having done it now. Was it a good idea, and would they do it again? Any comments greatly appreciated. Thanks, John ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Authorize.net
Alex Sherwood wrote: But the form data they type into your form that is then CFHTTP'd to Auth.net * should * be encrypted. For this, you'll need a cert. Not on the server making the request you don't. CFHTTP uses SSL when you call an https:// url. The form fields are sent encrypted. Obviously, you need a certificate to protect YOUR web page, but that has nothing to do with the CFHTTP call. - Rick ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189673 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Blog software?
I'm looking for a good blog software - hoping for CF based. So far, I like Movable Type but it's not CF based and was hoping some of you could point me to another one??? TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189674 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: John Dowdell Wants to Know What's Wrong with Macromedia
My only real pet peeve is Dreamweaver. Even the latest version is basically a slow dog compared to other editors, including Homesite+. Still, I understand MM's stance that once open-source candidates emerge in the category, it becomes a difficult if not impossible proposition to invest in proprietary software to compete in the space. Therefore, I have a proposition for MM. Why not support the Eclipse initiative? Most of the major Java vendors already support it. Other software companies support it. And the open source community supports it. Why not contribute a relatively modest effort toward making CFEclipse a top-flight product? For instance, someone could duplicate the data browser function in Homesite+ by attaching to the RDS servlet. Who better to write that than the people that know the code already? It might be MM's position that they will not contribute to open source because it eats into their revenue base, but the way I see it the job of software companies is to stay one step ahead of open source and always offer more value than the open source community alone can provide. By refusing to consider alternatives, MM is essentially deciding that the space isn't worth pursuing. Better tools are an enticement to developers and could be considered a loss leader to grow the server market share for products like ColdFusion. And that doesn't mean MM has to give away their product. They could produce some additions to CFEclipse for free and build a whole value-added product on top of it. And since MM seems to want to turn everyone into a CF/Java programmer, what better way to do that than to get them on the Eclipse platform where all the Java tools are right there? I'm available (for a modest fee) for further discussion of this topic with MM brass. ;-) This is worth reading and commenting on: http://www.markme.com/jd/archives/006722.cfm Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189675 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Blog software?
You could have a look at Ray Camdens Blog... written in CF http://www.camdenfamily.com/morpheus/blog/ HTH On Fri, 7 Jan 2005 12:47:15 -0600, Donna French [EMAIL PROTECTED] wrote: I'm looking for a good blog software - hoping for CF based. So far, I like Movable Type but it's not CF based and was hoping some of you could point me to another one??? TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189676 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamically creating multiple pages/rows of images from a query
Instead of using tables for your layout, you might want to consider using CSS instead, and avoid the issue of figuring out columns and rows. For a helpful example/tutorial, see http://www.alistapart.com/articles/practicalcss/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189677 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF - switching from MS-SQL to Oracle (neq Neo, Morpheus, Trinity)
You can also get away without using the trigger by simply using sequencename.nextval in your insert. Usually, however, I use a separate query to get the id value, so that the value is readily available for other parts of the application, like so: cfquery name=getID datasource=foo select sequencename.nextval as id from dual /cfquery Dual is sort of a dummy table in Oracle that you can use for this sort of thing. I just use the value returned for my subsequent insert queries - handy if you have more than one table you need to insert to using that id value. As for joins, this does depend largely on which version of Oracle you are using - version 8 and earlier, you are in for a big shift since Oracle didn't support the ANSI join statement like INNER JOIN, OUTER JOIN, etc. Oracle 9i and later do support that syntax, but I don't know for sure if it's exactly equivelant to SQLServer. Doug To do autonumbering you have to create a sequence and a trigger, to the best of my knowledge Toad does not provide a shortcut to creating these. I just edit a small snippet of code to reflect whatever table i need it for, such as: CREATE SEQUENCE SEQ_ACTIVITYLOG START WITH 1 MAXVALUE 1E27 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE OR REPLACE TRIGGER ITM.TRG_ACTIVITYLOG BEFORE INSERT ON ITM.ACTIVITYLOGREFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE x INTEGER; BEGIN IF :new.ID is null THEN SELECT SEQ_ACTIVITYLOG.NEXTVAL INTO x FROM DUAL; :new.ID := x; END IF; END; I just dumped those out of Toad, but at least put you down the right path, you probably can find countless examples of this via a google search. As far as the CFQUERies, your functions are going to be different between the two databases and the way you do joins might end up needing some changes. Will depend on what version of Oracle as to how different joins might need to be done. -- Aaron Rouse http://www.happyhacker.com/ On Fri, 7 Jan 2005 09:13:47 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189678 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Blog software?
Ditto from me. That's what I use. On Fri, 7 Jan 2005 18:52:26 +, JediHomer [EMAIL PROTECTED] wrote: You could have a look at Ray Camdens Blog... written in CF http://www.camdenfamily.com/morpheus/blog/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189679 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
General Security Discussion.
BACK STORY: Our department director came up and asked my about potential security ramifications of the back button in the browser. Someone had notified her that when they logged out of a moderately secure web application, they could hit the back button and see previously displayed data. While they could not do any actions in the application since they where no longer logged into it, they could still see potentially sensitive data. This quickly expanded into a general discussion of data security in browser based inter/intranet applications. And I realized that I do not have much depth of knowledge of all the possible gotchas and/or how to possibly mitigate them. QUESTION: So can this august group provide me some vetted, primer type resources in either web, book and/or news group discussion thread form that could illuminate my ignorance on this topic? Thank You PS. Wow, I have no idea where the language for that last sentence came from? I sounded a bit frumpy or pretentious for a code monkey programmer didn't I? -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189680 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Clustering multiple CFMX server
On Fri, 7 Jan 2005 07:28:58 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: The steps that I followed are outlined on this page: http://www.talkingtree.com/blog/index.cfm?mode=entryentry=25A98D33-45A6-284 4-7E780B5AEBD8C085 Please do me that favor of looking over the instructions on that webpage and tell me if it is different from what you did. I really appreciate your help in getting to the bottom of this. Other than being on a different platform, the steps I followed were essentially identical. It sounds to me like the IIS connector configuration is not correct on your system. Try re-running the wsconfig step - perhaps remove all existing connector setup and then adding just the cluster (make sure that wsconfig can actually see both server instances as well as the cluster). If that doesn't help, contact Steven Erat directly since he's more familiar with IIS. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189681 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Blog software?
Is there any that uses CF5 and not CFMX? -Original Message- From: Al Everett [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 2:30 PM To: CF-Talk Subject: Re: OT: Blog software? Ditto from me. That's what I use. On Fri, 7 Jan 2005 18:52:26 +, JediHomer [EMAIL PROTECTED] wrote: You could have a look at Ray Camdens Blog... written in CF http://www.camdenfamily.com/morpheus/blog/ ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189682 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
what is this?
Hi, can someone tell me why the # is showing up in the following lines? cfoutput query=GetInfo2 A HREF=process_path.cfm?LID=#couponhref# TARGET=_blank For some reason It's showing the value of couponhref but its also displaying the #. So the link looks like this on the page... a href=process_path.cfm?LID=#http://www.blah.com#; Target=_blank Any thoughts? I tried to put the couponhref in a separate variable name but that didnt work either. Thanks Phil ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: what is this?
Phillip, Are you sure you've put the file on a ColdFusion server, that the ColdFusion server is running, and that you're viewing the page via http:// and not file://? Would you mind posting both the URL in your location bar and the result of doing View Source? -joe On Fri, 7 Jan 2005 15:08:01 -0500, Phillip Perry [EMAIL PROTECTED] wrote: Hi, can someone tell me why the # is showing up in the following lines? cfoutput query=GetInfo2 A HREF=process_path.cfm?LID=#couponhref# TARGET=_blank For some reason It's showing the value of couponhref but its also displaying the #. So the link looks like this on the page... a href=process_path.cfm?LID=#http://www.blah.com#; Target=_blank Any thoughts? I tried to put the couponhref in a separate variable name but that didnt work either. Thanks Phil ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: what is this?
Thanks, actually it was a DB problem. I'm using access and it automatically assigned the value of the field to a hyperlink. For some reason the DB puts in #'s by itself when using a hyperlink data type. All I had to do was switch it to a text field and things fixed itself. Thanks again, Phil -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 3:22 PM To: CF-Talk Subject: Re: what is this? Phillip, Are you sure you've put the file on a ColdFusion server, that the ColdFusion server is running, and that you're viewing the page via http:// and not file://? Would you mind posting both the URL in your location bar and the result of doing View Source? -joe On Fri, 7 Jan 2005 15:08:01 -0500, Phillip Perry [EMAIL PROTECTED] wrote: Hi, can someone tell me why the # is showing up in the following lines? cfoutput query=GetInfo2 A HREF=process_path.cfm?LID=#couponhref# TARGET=_blank For some reason It's showing the value of couponhref but its also displaying the #. So the link looks like this on the page... a href=process_path.cfm?LID=#http://www.blah.com#; Target=_blank Any thoughts? I tried to put the couponhref in a separate variable name but that didnt work either. Thanks Phil ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query Question
Ian, Thanks!!! That put me on the right track. I had never used a Union before and didn't even think about it. The resultant query looks like: SELECT DISTINCT v1 AS V_values FROM table UNION SELECT DISTINCT v2 AS V_values FROM table UNION SELECT DISTINCT v3 AS V_values FROM table ORDER BY V_values By default the Union operation eliminates duplicate rows as part of it's processing (from My SQL book) so it natively accomplishes what I was looking for in the first place. Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: what is this?
congrats on the fix... Incidentally, you should also use urlencodedformat() around that value before using it in a link... i.e. A HREF=process_path.cfm?LID=#urlencodedformat(couponhref)# ... otherwise you'll run into problems if the couponhref variable has certain characters in it... technically the whole href attribute should also be in an htmleditformat() function, but that's a whole other can o' worms I won't get into right now. :) Thanks, actually it was a DB problem. I'm using access and it automatically assigned the value of the field to a hyperlink. For some reason the DB puts in #'s by itself when using a hyperlink data type. All I had to do was switch it to a text field and things fixed itself. Thanks again, Phil On Fri, 7 Jan 2005 15:08:01 -0500, Phillip Perry [EMAIL PROTECTED] wrote: Hi, can someone tell me why the # is showing up in the following lines? cfoutput query=GetInfo2 A HREF=process_path.cfm?LID=#couponhref# TARGET=_blank For some reason It's showing the value of couponhref but its also displaying the #. So the link looks like this on the page... a href=process_path.cfm?LID=#http://www.blah.com#; Target=_blank Any thoughts? I tried to put the couponhref in a separate variable name but that didnt work either. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189687 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Raymond Camden Blog
Thanks. I configured the ini file incorrectly. -- Original Message -- From: Sean Corfield [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Fri, 7 Jan 2005 08:17:49 -0800 On Fri, 7 Jan 2005 11:03:33 -0500, Dwayne Cole [EMAIL PROTECTED] wrote: Anyone have any experience with this blog app. It powers my blog just fine. I trying to use it and it looks like I have it installed properly but when I log in I don't get a menu to add an entry. So I tried logging in with the wrong password and there was no error message. If you give bad login details, you just get the regular blog home page. So it sounds like you don't have the initial user name setup correctly. Did you change the login information in the .ini file and/or the .sql file? -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Clustering multiple CFMX server
It sounds to me like the IIS connector configuration is not correct on your system. Try re-running the wsconfig step - perhaps remove all existing connector setup and then adding just the cluster (make sure that wsconfig can actually see both server instances as well as the cluster). Once you add a server instance to a cluster, wsconfig won't let you connect to that server instance directly, only to the cluster. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189689 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Blog software?
I'm looking for a good blog software - hoping for CF based. So far, I like Movable Type but it's not CF based and was hoping some of you could point me to another one??? Mine, BlogFusion is CF based. Jake Lead Developer BlogFusion - www.countersinkdg.com ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189690 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Blog software?
Is there any that uses CF5 and not CFMX? While BlogFusion isn't specifically designed for CF5, I've had a couple users tell me they had a pretty easy time modifying it to do so. Jake Lead Developer BlogFusion - www.countersinkdg.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189691 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WIKI App?
Keith, I'm happy to help bang around on it. I'll check out sourceforge. So are the SeedWiki on SF and www.seedwiki.com the same thing? If so, it's change it's product... it's now a free app for limited, public usage and Web based. Charges apply for private WIKIs Jake Lead Developer BlogFusion Jake wrote: Has anyone used a free CF Wiki tag/app? I can also use a Web based solution, assuming it's free and private. Any recommendations? I'm developing one called FusionWiki for my own use primarily, though its development is hosted by SourceForge and it's licenced under the Common Public License and anybody can contribute to or use it. But I think it's a little too primitive right now seeing as it's derived from a quick hack I had to write about a year ago, and I'm only right after starting the project. :-) Take a look at SeedWiki instead. It's the only other half-decent CF-based wiki I know of, though you need MX to run it, which probably isn't a problem. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.9 - Release Date: 06/01/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189692 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: John Dowdell Wants to Know What's Wrong with Macromedia
On Fri, 07 Jan 2005 13:53:10 -0400, Robert Munn [EMAIL PROTECTED] wrote: My only real pet peeve is Dreamweaver. Even the latest version is basically a slow dog compared to other editors, including Homesite+. Just a meta-comment: you will all get more mileage out of these peeves if you post them as comments on John's blog. He doesn't read this list and if you don't comment there, your voice will be lost (to him, at least). Therefore, I have a proposition for MM. Why not support the Eclipse initiative? Most of the major Java vendors already support it. Other software companies support it. And the open source community supports it. Why not contribute a relatively modest effort toward making CFEclipse a top-flight product? Er, you mean like allowing myself and my colleague Seth Hodgson to work with the CFE folks? Early days yet but we intend to work on stuff like framework support (FB / Mach II) and possibly UML support. Just remember that we do this in our (not so) copious free time... It isn't any sort of official support for CFE, just permission to contribute on our own time! For instance, someone could duplicate the data browser function in Homesite+ by attaching to the RDS servlet. Who better to write that than the people that know the code already? RDS is protected by a number of copyright / other measures so you won't see an open source hook for that. Besides, Eclipse already has a number of database plugins (I use DBEdit and like it a lot). It might be MM's position that they will not contribute to open source because it eats into their revenue base We already contribute extensively to Axis and several other Java Open Source projects so I'm not sure why you'd say that. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189693 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question about data access
On Fri, 7 Jan 2005 09:55:53 -0800, John Munyan [EMAIL PROTECTED] wrote: I am contemplating the idea of creating cfc's which contain stored procedures to handle the data access for the site. Separating out your data access is a good idea (although many would argue the pros and cons of stored procedures). I was wondering if anyone had experience moving their data access into cfcs using stored procedures, and what their experience was like, what their motivations were, and how they feel about having done it now. Was it a good idea, and would they do it again? Any comments greatly appreciated. As far as application structure is concerned, check out the concepts and models sections of the Mach II Development Guide: http://livedocs.macromedia.com/wtg/public/machiidevguide/ As for stored procs and CFCs, I've just built a web service wrapper around a bunch of Oracle stored procedures (which are also used internally by an Oracle-based application we use). The web service will be used by CF apps running elsewhere in the organization. By encapsulating the stored proc API in CFCs it helps decouple the front end and back end systems - we can do various error handling and data mapping operations in the CFC web service layer so that the 'client' app has a nice, clean interface to work with. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189694 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: John Dowdell Wants to Know What's Wrong with Macromedia
RDS is protected by a number of copyright / other measures so you won't see an open source hook for that. RDS would be a lot more useful if it were something that could be used by other tools. It might be MM's position that they will not contribute to open source because it eats into their revenue base We already contribute extensively to Axis and several other Java Open Source projects so I'm not sure why you'd say that. Those projects don't jeopardize your product sales - they're complementary to your products. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189695 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: New CF Install: Do I need the Updater?
I just finished installing the file I downloaded from MM on 1/5/05. Does anyone know if the current MM CF download includes the Updater, or do I need to install that as well? I have my original CF download from 2003 and the file size is smaller and the installer acts subtly different. You will need to install the Updater and any post-Updater hot fixes you want to use after installing CFMX itself. If you install CFMX on JRun, I'm pretty sure you will need to run the JRun Updater 4 for each JRun server first, then run the CFMX 6.1 Updater 1 for each CFMX instance. On a related note, you can always check to see if you have the latest version of CFMX by looking at the Version Information page within the CF Administrator, then comparing it against this page: http://www.macromedia.com/support/coldfusion/ts/documents/mx_version_info.ht m Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189696 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX 6.1 + Apache2... where is CGI.request_uri???
Help. I am having this problem where I don't have request.uri on my list of variables in the CGI scope. What should I do? This is a fresh installation on Windows 2003 AND on Windows XP with the newest version of apache.Apache/2.0.52 (Win32) JRun/4.0. Help? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189697 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfmx cfquery dbtype=odbc
The application I'm currently working on was originally written in CF 4.5 so I'm frequently seeing dbtype=odbc in CFQUERY tags. Does anyone know if that setting could adversely affect performance now that the DBTYPE attribute is to be used to designate a QofQ? Thanks much, Dina ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfmx cfquery dbtype=odbc
The application I'm currently working on was originally written in CF 4.5 so I'm frequently seeing dbtype=odbc in CFQUERY tags. Does anyone know if that setting could adversely affect performance now that the DBTYPE attribute is to be used to designate a QofQ? I'm pretty sure that the DBTYPE attribute has been deprecated from CFMX for all use other than query-of-query. I'd be somewhat surprised if it works at all when you specify something else. If you're using Dreamweaver, you can easily remove this using the tag attribute options within the find and replace dialog across all of your files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189699 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: session variables inside cftransaction
Do session variables still need to be locked inside of cftransaction? Or should cflock be avoided inside cftransaction? Session variables in CFMX need to be locked if you might have more than one request changing values in the same session variables at the same time. Since session variables are user-specific, this is often pretty unlikely. Locking session variables using CFLOCK has nothing specifically to do with CFTRANSACTION, which lets you lock database access. In general, you should avoid any unnecessary operations within any sort of lock, as locks create bottlenecks within your application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189701 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMX 6.1 + Apache2... where is CGI.request_uri???
I am having this problem where I don't have request.uri on my list of variables in the CGI scope. What should I do? This is a fresh installation on Windows 2003 AND on Windows XP with the newest version of apache.Apache/2.0.52 (Win32) JRun/4.0. Different web server software will provide different CGI variables. I'm not sure what you're trying to do, but there may be an alternative CGI variable that you can use. You might want to use CFDUMP to see what's in your CGI scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189702 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfmx cfquery dbtype=
Thanks, Dave. I was surprised to see that DBTYPE=odbc was working in this application as well, but it is. At this point, I'm just trying to determine if a DBTYPE=odbc designation in CFMX would adversely affect performance for a JDBC datasource. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189703 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: John Dowdell Wants to Know What's Wrong with Macromedia
Therefore, I have a proposition for MM. Why not support the Eclipse initiative? Most of the major Java vendors already support it. Other software companies support it. And the open source community supports it. Why not contribute a relatively modest effort toward making CFEclipse a top-flight product? Er, you mean like allowing myself and my colleague Seth Hodgson to work with the CFE folks? Early days yet but we intend to work on stuff like framework support (FB / Mach II) and possibly UML support. Just remember that we do this in our (not so) copious free time... It isn't any sort of official support for CFE, just permission to contribute on our own time! Just to solidify this, as Sean said, there are quite a few MM guys (and BlueDragon guys too) who talk with us off line quite regularly (mostly Spike who is now the project leader). A few have already sent in patches for CFE, and they have some very interesting ideas coming down the pike. MM as an entity doesn't support or endorse the project, but they don't hate us, and I think they want the project to do well (as it in the end should help sell more CF servers) -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Browser Stats (stirring the pot)
I dont want to restart this thread by any means but I wanted to reply to this one comment in the interest of those still using IE... On Mon, 06 Dec 2004 16:06:39 -0400, Jim Davis [EMAIL PROTECTED] wrote: On Mon, 06 Dec 2004 11:35:06 -0400, Jim Davis [EMAIL PROTECTED] wrote: The question is whether or not FireFox in mass use would reduce spyware - I'm not sure it would. It very well might - I just don't know. IE installs software without your consent - so yes it would reduce it (using logic and experience not stats). After I install firefox on systems and run spybot a month or two later there isn't any spyware. No it doesn't. I am afraid it does. Run spybot on your system every once in a while, bet you'll find some if you browse with IE - patch system or not Beleive me - I religiously run scanners and with a fully patched system have yet to encouter any getting through. Do you have a URL that could demonstrate this? http://news.com.com/IE+flaw+threat+hits+the+roof/2100-1002_3-5517457.html?tag=nl Exploit code for one of the vulnerabilities, a flaw in an HTML Help control, was published on the Internet on Dec. 21 in an advisory by GreyHats Security Group. In order for us to rate a vulnerability as extremely critical, there has to be a working exploit out there and one that doesn't require user interaction, Kristensen said. This is our highest rating and is the last warning for users to fix their systems. The exploit code can be used to attack computers running Windows XP even if Microsoft's Service Pack 2 patch has been installed, Secunia said. The company is advising people to disable IE's Active X support as a preventative measure, until Microsoft develops a patch for the problem. It also suggests using another browser product. -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189705 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: General Security Discussion.
For some general ideas of things to watch out for: ColdFusion Developer's Journal, Sept. 2004, pg. 48-50, had a good article: Top 10 Web Security Tips. Macromedia Developer Center has a helpful article: Ten tips for securing your ColdFusion application. http://www.macromedia.com/devnet/security/articles/topten_tips.html Plus: After you log a user out of an site, in the application.cfm file clear their CFID, CFTOKEN, JSESSIONID, and session, then do a cflocate to the index page of the site and that *should* prevent the back-button from letting anyone view secure pages (if you have everything else setup right). ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189706 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
get first day of month
I figure this has already been done by some out there: I need to get the first day of the month as a string when passing in a date. So far, I see that #FirstDayofMonth(date)# will get me the ordinal day of the year (0-366), but how does one extract the day as a string? THX, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189707 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: get first day of month
This should do it. cfset theDay=Now() cfset theFirstOfTheMonth=CreateDate(Year(theDay),Month(theDay),1) First day of #MonthAsString(Month(theDay))# is #DayOfWeekAsString(DayOfWeek(theFirstOfTheMonth))#. On Fri, 07 Jan 2005 20:20:13 -0500, Ray Champagne [EMAIL PROTECTED] wrote: I figure this has already been done by some out there: I need to get the first day of the month as a string when passing in a date. So far, I see that #FirstDayofMonth(date)# will get me the ordinal day of the year (0-366), but how does one extract the day as a string? THX, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189708 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: get first day of month
Forget it. Forta already answered this one a while ago on HoF. (Get the FirstDayofMonth, use DateAdd to add that many days to Jan 1st of that year, then use DayofWeekAsString to get the day name) Thanks anyways! Ray At 08:20 PM 1/7/2005, you wrote: I figure this has already been done by some out there: I need to get the first day of the month as a string when passing in a date. So far, I see that #FirstDayofMonth(date)# will get me the ordinal day of the year (0-366), but how does one extract the day as a string? THX, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189709 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Session is Invalid?
Here is a new one on me. Upon attempting to enter my site, I got: === Session is invalid The error occurred in Application.cfm: line 1 1 : cfapplication name=CODAVer1 sessionmanagement=Yes clientmanagement=Yes SESSIONTIMEOUT=#CREATETIMESPAN(0,8,0,0)# 2 : cfparam name=Session.UserName default= 3 : cfparam name=Session.Password default= I am not sure what is causing this? The sessiontimeout? My code at the beginning of the index page: CFIF isdefined(session.loginok)cfelseCFSET session.loginok = NO/cfif CFIF isdefined(session.level)cfelseCFSET session.level = 0/cfif Any ideas on how to diagnose and prevent the problem in the future would be Appreciated. TNX. Rick Colman ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189710 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Session is Invalid?
You are using J2EE session vars and your session timeout (8 hours) is longer than the J2EE session timeout (which is separate to the timeout in the admin): http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19109 -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Saturday, 8 January 2005 10:05 To: CF-Talk Subject: Session is Invalid? Here is a new one on me. Upon attempting to enter my site, I got: === Session is invalid The error occurred in Application.cfm: line 1 1 : cfapplication name=CODAVer1 sessionmanagement=Yes clientmanagement=Yes SESSIONTIMEOUT=#CREATETIMESPAN(0,8,0,0)# 2 : cfparam name=Session.UserName default= 3 : cfparam name=Session.Password default= I am not sure what is causing this? The sessiontimeout? My code at the beginning of the index page: CFIF isdefined(session.loginok)cfelseCFSET session.loginok = NO/cfif CFIF isdefined(session.level)cfelseCFSET session.level = 0/cfif ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54