RE: Calculate the date next Sunday
What a wonderful thing this list is.Here we are, less than 30 minutes
after I asked a questionI have an answer from the other side of the globe.
This is just magic.
Thanks Spike! Looks exactly what I want.
Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.
-Original Message-
From: Spike [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 5 November 2003 4:53 PM
To: CF-Talk
Subject: Re: Calculate the date next Sunday
Something like this should do:
cfset dateOffset = 8-dayOfWeek(Now())
!--- If you want to set the effective date of the transaction as today
if the day is sunday ---
cfif dateOffset GT 1
cfset targetDate = dateAdd('d',dateOffset,Now())
cfelse
cfset targetDate = Now()
/cfif
!--- If you want to make sure that transactions take at least 24 hours ---
cfset targetDate = dateAdd('d',dateOffset,Now())
Spike
Mike Kear wrote:
I have a task where I have to insert the effective date of a transaction,
which is the following Sunday, regardless of the day the form is
submitted.
Anyone know of a UDF or other functionality that'll work that out?
Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: ColdFusion workshop - any ideas?
Just my comments on your list - sorry for no indenting, but quoting on the HTML version of the list is a pain. Some example topics I intend to cover include (in no particular order): INTRODUCTION AND WELCOME I definitely think this should come first.;^) ABOUT/HISTORY OF COLDFUSION You didn't mention how long of a presentation this is (but it's obviously pretty long).Also I think that your audience is going to be hard - as you've described it you'll have both amateurs and pros - difficult to balance. In any case I would discuss, at least a bit, the history of the history of CF.For the early years the generational model works well, I think: 1st generation websites (billboard and business cards), second generation (more content but static, beginning to be seen as valuable), third generation (doing real work, dynamic seen as necessary for business) and so forth. Also, if it's appropriate for the audience I think that a basic understanding of HTTP is essential to understanding this.Just the cursory coverage: how the browser talks to the server, what a request is, what the limits are (statelessness for example) and, especially, a firm description of what happens where. One of the most common questions asked by newbies is how can ColdFusion change a _javascript_ variable? - I think this questions is a direct result of not understanding HTTP. APPLICATION ARCHITECTURE I'd place this late in your plan - get the foundational elements out first.Also make sure to define very clearly the differences between Application.cfm, the Application scope and the CFApplication tag - too many people end up thinking that they're tied completely together (that you can ONLY place a CFAPPLICATION tag in Application.cfm). DATABASE BASICS I might consider moving the DB stuff up front.I think that many people may find database stuff a bit easier to swallow at first.Also by doing this you can stay on CF as the topic for the rest of the time and not break away from it. COMPLEX DATATYPES Deep, deep topic - don't forget access methods tho'!Both dot notation and indexed notation - it's another thing that a lot of newbie's miss and they pay for it later. I've found that diagrams help a lot - especially if they're dynamic. Constructing visualizations of Array, structs, queries, etc out of post-it notes (which allow you to copy and move data visually) really helps describe the concepts behind pointers and such. TO # OR NOT TO # Good point to make. RECOMMENDED READING As you're doing this (and this is a personal bias) don't forget the supporting tools and philosophies - especially usability (which should also be useful to your non-CF programmers as well). USING PERSISTENT VARIABLES Not to toot my own horn, but I've got a large guide to a lot of CF variable stuff that you may find useful here (long URL): http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V ariables/Index.cfm I've tried to collect all of the things I think are important to know in that.It's not perfect, but I'm proud of it. THE FUTURE OF COLDFUSION Is bright! PROGRAMMING METHODOLOGIES Great topic - I'm assuming you're talking about things like Fusebox and such.Don't forget (if appropriate) the more basic concepts: procedural vrs OO and such. COLDFUSION VS ASP, ASP.NET, PHP, ETC I'd keep this low key and unbiased (if possible).I always start discussions on this topic with a general They're all mature, usable, versatile options and, in general, you can meet pretty much any need with pretty much any of the tools I definitely wouldn't use the word versus in the presentation.;^) Other things you might mention/cover: How dependent web applications are on browser support/cross (browser) platform issues. The concept of open source as it pertains to CF (perhaps during your discussion of the Exchange) which may include talking briefly about Blue Dragon. One of my favorite topics: CF Myths.Especially if you have other programmers there you'll have to face a lot of incorrect information. Things like CF isn't scalable, CF is too slow for production work, CF is just a CMS/Interface Tool/Prototyping Tool/Whatever and not a 'real' programming language. That's about it for now... sounds like you've got your work cut out for you!Good luck! Jim Davis [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calculate the date next Sunday
Not exactly the other side of the globe...
I'm in Brisbane at the minute ;)
Spike
Mike Kear wrote:
What a wonderful thing this list is.Here we are, less than 30 minutes
after I asked a questionI have an answer from the other side of the globe.
This is just magic.
Thanks Spike! Looks exactly what I want.
Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.
-Original Message-
From: Spike [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 5 November 2003 4:53 PM
To: CF-Talk
Subject: Re: Calculate the date next Sunday
Something like this should do:
cfset dateOffset = 8-dayOfWeek(Now())
!--- If you want to set the effective date of the transaction as today
if the day is sunday ---
cfif dateOffset GT 1
cfset targetDate = dateAdd('d',dateOffset,Now())
cfelse
cfset targetDate = Now()
/cfif
!--- If you want to make sure that transactions take at least 24 hours ---
cfset targetDate = dateAdd('d',dateOffset,Now())
Spike
Mike Kear wrote:
I have a task where I have to insert the effective date of a transaction,
which is the following Sunday, regardless of the day the form is
submitted.
Anyone know of a UDF or other functionality that'll work that out?
Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Calculate the date next Sunday
Brisbane!Oh,I saw the .co.uk address and assumed you're in the UK lamenting the lack of a rugby team. Instead you're in Brisbane, looking forward to the advent of the twentieth century some time soon. Thanks anyway Spike, your snippet of code is just the bees knees. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 5:45 PM To: CF-Talk Subject: Re: Calculate the date next Sunday Not exactly the other side of the globe... I'm in Brisbane at the minute ;) Spike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfexecute on unix
Thanks for the information. That was not very good news... How come there's no information at macromedia.com on this? I searched and found nothing... A tech-note would be appropriate. /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | On Tuesday, November 04, 2003 21:20 [GMT+1=CET], | Hiroshi Okugawa [EMAIL PROTECTED] wrote: | Unfortunately cfexecute doesn't work correctly with argument which | contains | spaces. (bugid 50604) | # It's Linux/Unix only. | | I think you may create custom java cfx for workaround. | # use Runtime.getRuntime().exec(String []) instead of | Runtime.getRuntime().exec(String) | | sorry for inconvenience. | | Thanks, | || -Original Message- || From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] || Sent: Monday, November 03, 2003 8:59 AM || To: CF-Talk || Subject: cfexecute on unix || || || Hi, || || I have encounted a problem in our migration between our old || Solaris box running 4.5 to the new Solaris machine -- running CFMX. || || I try to cfexecute rm to remove a directory tree, recursively. || It is not a permissions problem, since CF created the whole || tree (and I have played with chmod to make that is not the problem). || || I try to: || cfexecute name=/bin/rm || arguments=-rf #dirTree#/ || || It works fine without quotes around the path *as long as the || path does not contain spaces*. Quotes (as above) does not work || at all. I also tried to REReplace(dirTree, , \ ,ALL) to || escape any spaces -- but no. Another thing I looked at was to || make arguments an array beforehand, with -rf as the first || item in the array, and the tree-var as the second (tried both || and without double-quotes). || || Any tips? || || Thanks, || Hugo || || || || || - || Hugo AhleniusE-Mail: [EMAIL PROTECTED] || Project Officer Phone:+46 8 230460 || UNEP GRID-ArendalFax:+46 8 230441 || Stockholm OfficeMobile:+46 733 467111 || WWW: http://www.grida.no || - | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT- Dynamic Page Layouts
Two ways: * Frames, I think you should avoid it for this case. * CSS. I found a good way on the web somewhere (now link). You can look at the source and the css of this page, which uses a CSS method to do this: http://globalis.no/admin/ - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | On Wednesday, November 05, 2003 05:50 [GMT+1=CET], | Mickael [EMAIL PROTECTED] wrote: | Hello All, | | This is not exactly a coldfusion question but does pertain to dynamic | site.I have a site in CF that the client would like to include a | standard footer at the bottom of the page.This works fine when the | content that is returned is more than once screen in my explorer | window at my resolution. | | The problem that I am having is that some of the pages have content | that is returned and it is a little bit less one screen so I see my | footer then the remainder of the screen below the footer which is not | what the client wants. | | Is there a way to handle this? | | Thanks | | Mike | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [Stats] CF-Talk: October 2003
On Tuesday 04 Nov 2003 18:27 pm, Bill Doerrfeld wrote: Top 20 Contributors by Number of Posts [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Parsing a Unix Text File.
On Monday 03 Nov 2003 17:38 pm, Troy Simpson wrote: So if I had a file that delimited the records by triple pipes |||, there is nothing in ColdFusion that will let you do this, right? The list operators take an argument which is the delimiter. Then just skip every 3rd (2nd ?) record, which will be empty. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [Stats] CF-Talk: October 2003
Not only did the list of contributors vanish, so did my comment that they had... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Novell to acquire SUSE
On Tuesday 04 Nov 2003 15:49 pm, Dave Carabetta wrote: It is not a supported product of Red Hat, Inc. Although they are still backing it up with ftp, build hosts, cvs etc. This version is a proving ground for features that may or may not make it into their hardened server versions. Just like RH9 was. Are you willing to run mission-critical applications on this sort of version? I'm not. I am to the same degree as I was with RH7-9. If you need 24x7 cover, and quick tech support, it costs (AS). Otherwise go with the one-behind-current free one. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Novell to acquire SUSE
On Tuesday 04 Nov 2003 18:15 pm, Joshua Miller wrote: But if you go to the store RedHat costs what, like $30-$40? Granted the Enterprise Version is expensive, but you can still buy the boxed version of RedHat Linux which I'm sure will be as reliable as ever. Not after April. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion workshop - any ideas?
Thank you very much for the input I have received so far. Despite using CF myself for so long (8 years) and being close to 35 years of age - CF and it's history alone still keeps me more than occupied. Special thanks (at this early stage) to Mr Jim Davis for some great feedback - all duly noted. Will keep eveyone posted and - if I do it well enough - will make any resources I create (with credits) available to others. Regards, PT Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Stats] CF-Talk: October 2003
Must have been due to the move to HTML? I know that Sean Corfield left, vocally on his blog but respectfully not on this list. I have to use Lotus Notes R5 at work and it sucks - no plain text option and clunky as hell. Aarrggh! Money is good though. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 8:48 PM To: CF-Talk Subject: Re: [Stats] CF-Talk: October 2003 Not only did the list of contributors vanish, so did my comment that they had... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problems with MX - Can anyone help please !!!
I am having the following problem when trying to access a Univers database through an ODBC socket through the CFAdministrator in Coldfusion MX 6.1 It worked fine when we were using CF 4.5 against Univers but it will not work in MX ? I followed the same approach - installing the latest Univers ODBC driver on the IIS server and set it up via the control panel on IIS, and created a Local System Account, which I then set up in the administrator as ODBC socket data datasource.But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? Can anybody in Macromedia, Ben Forta, Rob ?help me resolve this please >From other posts I have read it seems as though there a lot of people with similar type problems, or can Coldfusion MX no longer connect to a Univers database. If this is the case then we will have to look at asp to resolve this. Yours Sincerely Ian Vaughan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Problems with MX - Can anyone help please !!!
TO be brutally honest I have never even heard of Univers. What is the nearest likeminded database server? Have you tried setting up the datasource manually (first - before CF Admin) through the ODBC wizard (Control Panel)? Alternatively using ODBC socket? Also you might try updating to the latest MDAC - 2.8 I think by now - at www.microsoft.com/data Just ideas but HTH. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 9:22 PM To: CF-Talk Subject: Problems with MX - Can anyone help please !!! I am having the following problem when trying to access a Univers database through an ODBC socket through the CFAdministrator in Coldfusion MX 6.1 It worked fine when we were using CF 4.5 against Univers but it will not work in MX ? I followed the same approach - installing the latest Univers ODBC driver on the IIS server and set it up via the control panel on IIS, and created a Local System Account, which I then set up in the administrator as ODBC socket data datasource.But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? Can anybody in Macromedia, Ben Forta, Rob ?help me resolve this please >From other posts I have read it seems as though there a lot of people with similar type problems, or can Coldfusion MX no longer connect to a Univers database. If this is the case then we will have to look at asp to resolve this. Yours Sincerely Ian Vaughan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT- Dynamic Page Layouts
Hugo Thanks that is just what I needed. - Original Message - From: Hugo Ahlenius To: CF-Talk Sent: Wednesday, November 05, 2003 2:52 AM Subject: Re: OT- Dynamic Page Layouts Two ways: * Frames, I think you should avoid it for this case. * CSS. I found a good way on the web somewhere (now link). You can look at the source and the css of this page, which uses a CSS method to do this: http://globalis.no/admin/ - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | On Wednesday, November 05, 2003 05:50 [GMT+1=CET], | Mickael [EMAIL PROTECTED] wrote: | Hello All, | | This is not exactly a coldfusion question but does pertain to dynamic | site.I have a site in CF that the client would like to include a | standard footer at the bottom of the page.This works fine when the | content that is returned is more than once screen in my explorer | window at my resolution. | | The problem that I am having is that some of the pages have content | that is returned and it is a little bit less one screen so I see my | footer then the remainder of the screen below the footer which is not | what the client wants. | | Is there a way to handle this? | | Thanks | | Mike | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX in SAP
Hi I wonder if anyone has used any CF (doesn't have to be CFMX) with SAP's Web Portal (using Sap web application server)? I am having some configuration issues. I want to install CFMX on Sap's Application Server not JRUN. I would highly appreciate if some one explain me how you have configured it? Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT- Dynamic Page Layouts
Mike, as Hugo stated definately avoid frames for this tip. Use the OnRequestEnd.cfm template. Unlike the Application.cfm template, OnRequestEnd.cfm is executed AFTER all other cfm templates. Very handy and I haven't worked out a better way to use it from what you require. In fact that is what I use for the footer at www.actcfug.com. There IS a way to use it with frames but it usually requires using CFABORT at the end of the template which probably isn't good practice - but it works at any rate. You could use the CFABORT method at the end of a template in say a small popup where your usual footer either does not fit or is not appropriate. HTH Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 9:36 PM To: CF-Talk Subject: Re: OT- Dynamic Page Layouts Hugo Thanks that is just what I needed. - Original Message - From: Hugo Ahlenius To: CF-Talk Sent: Wednesday, November 05, 2003 2:52 AM Subject: Re: OT- Dynamic Page Layouts Two ways: * Frames, I think you should avoid it for this case. * CSS. I found a good way on the web somewhere (now link). You can look at the source and the css of this page, which uses a CSS method to do this: http://globalis.no/admin/ - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | On Wednesday, November 05, 2003 05:50 [GMT+1=CET], | Mickael [EMAIL PROTECTED] wrote: | Hello All, | | This is not exactly a coldfusion question but does pertain to dynamic | site.I have a site in CF that the client would like to include a | standard footer at the bottom of the page.This works fine when the | content that is returned is more than once screen in my explorer | window at my resolution. | | The problem that I am having is that some of the pages have content | that is returned and it is a little bit less one screen so I see my | footer then the remainder of the screen below the footer which is not | what the client wants. | | Is there a way to handle this? | | Thanks | | Mike | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT- Dynamic Page Layouts
Note that it is not good practice to use OnRequestEnd.cfm for any display outputs. (The same goes for Application.cfm) I understood that the Mickael's problem was not how to get something appended to every called template, rather how to get a display piece to be presented at the bottom of the browser window (no matter what template is called). /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Peter Tilbrook [mailto:[EMAIL PROTECTED] | Sent: Wednesday, November 05, 2003 11:47 | To: CF-Talk | Subject: RE: OT- Dynamic Page Layouts | | | Mike, as Hugo stated definately avoid frames for this tip. | | Use the OnRequestEnd.cfm template. | | Unlike the Application.cfm template, OnRequestEnd.cfm is | executed AFTER | all other cfm templates. Very handy and I haven't worked out | a better way to | use it from what you require. | | In fact that is what I use for the footer at | www.actcfug.com. There IS a | way to use it with frames but it usually requires using | CFABORT at the end | of the template which probably isn't good practice - but it | works at any | rate. You could use the CFABORT method at the end of a | template in say a | small popup where your usual footer either does not fit or is not | appropriate. | | HTH | | Peter Tilbrook | ColdFusion Applications Developer | ColdGen Internet Solutions | Manager, ACT and Region ColdFusion Users Group - | http://www.actcfug.com | 4/73 Tharwa Road | Queanbeyan, NSW, 2620 | AUSTRALIA | | Telephone: +61-2-6284-2727 | Mobile: +61-0439-401-823 | E-mail: [EMAIL PROTECTED] | | World Wide Web: http:/www.coldgen.com/ | -Original Message- | From: Mickael [mailto:[EMAIL PROTECTED] | Sent: Wednesday, 5 November 2003 9:36 PM | To: CF-Talk | Subject: Re: OT- Dynamic Page Layouts | | | Hugo | | Thanks that is just what I needed. |- Original Message - |From: Hugo Ahlenius |To: CF-Talk |Sent: Wednesday, November 05, 2003 2:52 AM |Subject: Re: OT- Dynamic Page Layouts | |Two ways: | |* Frames, I think you should avoid it for this case. |* CSS. I found a good way on the web somewhere (now link). | You can look at |the source and the css of this page, which uses a CSS | method to do this: |http://globalis.no/admin/ | |- |Hugo AhleniusE-Mail: [EMAIL PROTECTED] |Project Officer Phone:+46 8 230460 |UNEP GRID-ArendalFax:+46 8 230441 |Stockholm OfficeMobile:+46 733 467111 | WWW: http://www.grida.no |- | | || On Wednesday, November 05, 2003 05:50 [GMT+1=CET], || Mickael [EMAIL PROTECTED] wrote: | || Hello All, || || This is not exactly a coldfusion question but does | pertain to dynamic || site.I have a site in CF that the client would like to include a || standard footer at the bottom of the page.This works | fine when the || content that is returned is more than once screen in my explorer || window at my resolution. || || The problem that I am having is that some of the pages | have content || that is returned and it is a little bit less one screen | so I see my || footer then the remainder of the screen below the footer | which is not || what the client wants. || || Is there a way to handle this? || || Thanks || || Mike || || || | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with this regex
Hello I have the following regex: s = rereplace(s, a[^]*href="" ])*[^]*[^]*/a,\1,all); Which should (in theory) replace a href="" here/a With page.htm But instead it just returns click here. Can anyone see where I'm going wrong? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT:Transparent Div question.
Hello All, I've got a slideshow app,using data from a DB I build a series of divs and switch between them using JS and timeouts. (in a nutshell) Everything works hunkey dorey except for one small problem with one of the Div's: The page consists of a top blue bar (title and subtitle),bottom blue bar (generic contact info) and a middle area (content area - consisting of a table and an image). The top and middle areas change with each cycle of the loop but because the page background is white I want to create a default top Div so that the different content top divs can be transparent and the change over of div's is smooth. Basically I have tried setting the content top divs with background:transparent; in the style and have played around with the z-index but, no matter what I try the default top div (the big blue bar) covers up all the content top Divs (blue bar with White and orange text) Surely can't I setup something like: div id=defaultTop style=background:darkblue; /div div id=div1_txt style=background:transparent; /div Therefore when I hide the div1_txt then make the next div visible the blue bar will still be there. Ignoring the height, width and position why wont this work,why does the default top cover all the other top divs? -Darren [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Stats] CF-Talk: October 2003
Can we do a stats search ourself? A drop of 10% from one month to the next may or may not be significant when taken in context of other months eh? ;-) July had a grand total of 977 posts according to a search on everything done between 01 July and 31 July 2003. In fact the list statistics from 2002 are as follows: Posts per month: 1-3392 2-3013 3-3927 4-4409 5-4422 6-1806 So it seems that the list has natural fluctuations in number of posts and who makes those posts from month to month since we did not have HTML mail back then. Ergo it is not possible to attribute a 10% fall off in posts to a switch to HTML mail simply by looking at the number of posts. I wonder how many people would disappear if we all had to pay a yearly/monthly subscription for these lists? -Gel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Assistance Needed
Can someone assist me with the following: SELECT O.opportunityId, O.title, N.ndaId, N.ndaDate, U.firstName, U.lastName, U.emailAddress FROM tbl_opportunity O INNER JOIN tbl_nda N ON (O.opportunityId = N.opportunityId) INNER JOIN tbl_user U ON (N.issuedById = U.userId) Here is the gist... Three table: opportunity, nda, user. User is a lookup table for users and opportunity and nda are linked together via opportunityId. Table nda can have more than one opportunity referenced in it. What I would like to do is to just get a listing of the opportunities for which there is at least 1 record in the nda table. Does that make sense? I am can't get my mind aorund how to do this. Any help is much appreciated.. Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT- Dynamic Page Layouts
Thanks Hugo, That is correct, my footer file is displaying properly.But I would like it to be displayed at the bottom of the brower window when there isn't enough content on the page to fill up the browser window. I am actually trying to get away from application.cfm the use of it has been causing me some headaches in a couple of app that I have running. - Original Message - From: Hugo Ahlenius To: CF-Talk Sent: Wednesday, November 05, 2003 6:30 AM Subject: RE: OT- Dynamic Page Layouts Note that it is not good practice to use OnRequestEnd.cfm for any display outputs. (The same goes for Application.cfm) I understood that the Mickael's problem was not how to get something appended to every called template, rather how to get a display piece to be presented at the bottom of the browser window (no matter what template is called). /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Peter Tilbrook [mailto:[EMAIL PROTECTED] | Sent: Wednesday, November 05, 2003 11:47 | To: CF-Talk | Subject: RE: OT- Dynamic Page Layouts | | | Mike, as Hugo stated definately avoid frames for this tip. | | Use the OnRequestEnd.cfm template. | | Unlike the Application.cfm template, OnRequestEnd.cfm is | executed AFTER | all other cfm templates. Very handy and I haven't worked out | a better way to | use it from what you require. | | In fact that is what I use for the footer at | www.actcfug.com. There IS a | way to use it with frames but it usually requires using | CFABORT at the end | of the template which probably isn't good practice - but it | works at any | rate. You could use the CFABORT method at the end of a | template in say a | small popup where your usual footer either does not fit or is not | appropriate. | | HTH | | Peter Tilbrook | ColdFusion Applications Developer | ColdGen Internet Solutions | Manager, ACT and Region ColdFusion Users Group - | http://www.actcfug.com | 4/73 Tharwa Road | Queanbeyan, NSW, 2620 | AUSTRALIA | | Telephone: +61-2-6284-2727 | Mobile: +61-0439-401-823 | E-mail: [EMAIL PROTECTED] | | World Wide Web: http:/www.coldgen.com/ | -Original Message- | From: Mickael [mailto:[EMAIL PROTECTED] | Sent: Wednesday, 5 November 2003 9:36 PM | To: CF-Talk | Subject: Re: OT- Dynamic Page Layouts | | | Hugo | | Thanks that is just what I needed. |- Original Message - |From: Hugo Ahlenius |To: CF-Talk |Sent: Wednesday, November 05, 2003 2:52 AM |Subject: Re: OT- Dynamic Page Layouts | |Two ways: | |* Frames, I think you should avoid it for this case. |* CSS. I found a good way on the web somewhere (now link). | You can look at |the source and the css of this page, which uses a CSS | method to do this: |http://globalis.no/admin/ | |- |Hugo AhleniusE-Mail: [EMAIL PROTECTED] |Project Officer Phone:+46 8 230460 |UNEP GRID-ArendalFax:+46 8 230441 |Stockholm OfficeMobile:+46 733 467111 | WWW: http://www.grida.no |- | | || On Wednesday, November 05, 2003 05:50 [GMT+1=CET], || Mickael [EMAIL PROTECTED] wrote: | || Hello All, || || This is not exactly a coldfusion question but does | pertain to dynamic || site.I have a site in CF that the client would like to include a || standard footer at the bottom of the page.This works | fine when the || content that is returned is more than once screen in my explorer || window at my resolution. || || The problem that I am having is that some of the pages | have content || that is returned and it is a little bit less one screen | so I see my || footer then the remainder of the screen below the footer | which is not || what the client wants. || || Is there a way to handle this? || || Thanks || || Mike || || || | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Uploading multple-files
Hello I'm trying to convert a PHP/java app I found into CF/java app. In this app your able to drag and drop multiple files to a java window and upload them all this is no problem as the java app takes care of the window its just when it goes to the PHP code is getting tricking. I just can't find what to use to keep track of the files to upload cause PHP has a tag like this $_FILES['userfile'] and count($file['name']). so I need to do the first part which I'm guessing is an array and the second is just counting the array to loop through. any one have any idea's for uploading multiple files at once? then I can probably take it from there? Thank you Troy E. Montour [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using cfhttp to access FTP via IE
This is driving me nuts. The problem is my expertise. --Original Message Text--- From: Lewis Sellers Date: Tue, 04 Nov 2003 15:35:45 -0500 Your browser is an HTTP client and an FTP client. If you want to perform FTP operations from CF, you'll have to use CFFTP instead of CFHTTP. Dave Watts, CTO, Fig Leaf Software Like Dave says, HTTP and FTP are fairly different protocols. Different command sets, different ports, etc. Microsoft has simply added a helpful feature to IE that lets you browse FTP servers through an artificial read-only HTML-like interface. (I haven't tried it in ages but it might do GOPHER:// as well.) --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT- Dynamic Page Layouts
Agreed - came in late after no email for 4 days. Depending on the web server this is possible (footer), IIS offers it but never tried it - but in a shared environment it could be awkward. Does it need to be dynamic or just static? Cheers! Note that it is not good practice to use OnRequestEnd.cfm for any display outputs. (The same goes for Application.cfm) I understood that the Mickael's problem was not how to get something appended to every called template, rather how to get a display piece to be presented at the bottom of the browser window (no matter what template is called). /Hugo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using cfhttp to access FTP via IE
Exactly but I want to be able to biuld this into a frameset. __ | || |ftp://server1|ftp://server2| | || | || | || |___ |__ | Doesn't seem to work in my app. If I open just a separate IE window and type in the ftp path it works just fine but not within my frameset? --Original Message Text--- From: J E VanOver Date: Tue, 4 Nov 2003 13:33:36 -0800 Read Only?On WinXP it acts just like another explorer window.Drag and drop to ftp.Kinda nice! Jevo -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 12:36 PM To: CF-Talk Subject: RE: Using cfhttp to access FTP via IE Your browser is an HTTP client and an FTP client. If you want to perform FTP operations from CF, you'll have to use CFFTP instead of CFHTTP. Dave Watts, CTO, Fig Leaf Software Like Dave says, HTTP and FTP are fairly different protocols. Different command sets, different ports, etc. Microsoft has simply added a helpful feature to IE that lets you browse FTP servers through an artificial read-only HTML-like interface. (I haven't tried it in ages but it might do GOPHER:// as well.) --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF5 and Flash5 Connector Kit
Good Day All, I have been tinkering of late with that old Flash Connector Kit. Dont ask, its just something I do, tinker with the older stuff. Well, in any case I have run up against a snag in the deployment. I've installed it. Use the Directory listing example, test movie in the flash standalone, works great. As soon as I try to call it from the browser, I get the infamous error: your flash player has decided to be as stubborn as a the 2 year old your trying to feed that spinich to, and refused to play it. It mentioned something about your performance being slow too. hehe you all get the point. I havehave seen it on the boards before but I cannot find a resolution. Now logically, if it runs in the standalone flashplayer and CF doesn't bark. It should work in the browser. Thanks in advance for the help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help with this regex
s = rereplace(s, a[^]+href="" ]*)[^]*[^]*/a,\1,all); -Oorspronkelijk bericht- Van: Ryan Mitchell [mailto:[EMAIL PROTECTED] Verzonden: wo 5/11/2003 12:44 Aan: CF-Talk CC: Onderwerp: Help with this regex Hello I have the following regex: s = rereplace(s, a[^]*href="" ])*[^]*[^]*/a,\1,all); Which should (in theory) replace a href="" here/a With page.htm But instead it just returns click here. Can anyone see where I'm going wrong? Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Date
Is there a way to output the day of the month with the appropriate string at the end: 1 = 1st 2 = 2nd 3 = 3rd 4 = 5th I did not come across any functions... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT- Dynamic Page Layouts
You can assign footer files in IIS, especially in a shared environment.You can even set up a different footer file for each virtual host on the shared server. The good part about doing it this way is that the displayed footer will automatically adjust to the page size., thus eliminating the whitespace inherent on a dynamically created page.The con would be that the footer would be displayed on every page that site renders., but perhaps that is what you want to do. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 6:58 AM Subject: RE: OT- Dynamic Page Layouts | Agreed - came in late after no email for 4 days. Depending on the web server | this is possible (footer), IIS offers it but never tried it - but in a | shared environment it could be awkward. Does it need to be dynamic or just | static? | | Cheers! | | | | Note that it is not good practice to use OnRequestEnd.cfm for any display | outputs. (The same goes for Application.cfm) | | I understood that the Mickael's problem was not how to get something | appended to every called template, rather how to get a display piece to be | presented at the bottom of the browser window (no matter what template is | called). | | /Hugo | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date
I'm pretty sure there is a UDF for this at cflib.org. Yep, http://www.cflib.org/udf.cfm?ID=349 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Using cfhttp to access FTP via IE
It works in a frameset for me. Here's my code: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Frameset//EN http://www.w3.org/TR/html4/frameset.dtd html head titleDueling FTP/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head frameset cols=*,* frameborder=NO border=0 framespacing=0 frame src="" name=leftFrame frame src="" name=mainFrame /frameset noframesbody /body/noframes /html -Kevin - Original Message - From: Bushy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 7:01 AM Subject: RE: Using cfhttp to access FTP via IE Exactly but I want to be able to biuld this into a frameset. __ | || |ftp://server1|ftp://server2| | || | || | || |___ |__ | Doesn't seem to work in my app. If I open just a separate IE window and type in the ftp path it works just fine but not within my frameset? --Original Message Text--- From: J E VanOver Date: Tue, 4 Nov 2003 13:33:36 -0800 Read Only?On WinXP it acts just like another explorer window.Drag and drop to ftp.Kinda nice! Jevo -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 12:36 PM To: CF-Talk Subject: RE: Using cfhttp to access FTP via IE Your browser is an HTTP client and an FTP client. If you want to perform FTP operations from CF, you'll have to use CFFTP instead of CFHTTP. Dave Watts, CTO, Fig Leaf Software Like Dave says, HTTP and FTP are fairly different protocols. Different command sets, different ports, etc. Microsoft has simply added a helpful feature to IE that lets you browse FTP servers through an artificial read-only HTML-like interface. (I haven't tried it in ages but it might do GOPHER:// as well.) --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT- Dynamic Page Layouts
IF its not good practice? What else do you suggest?Personally, I think css is quirky and causes more cross browser headaches than its really worth. Maybe my knowledge of css isn't wide enough to adequately implement them, but everything I have done/seen/read with cssbasically ends up sounding like this : You can do this, but not with that browser you need to do this instead but that won't work with version x.x and it just goes on and on... I actually cfinclude my headers and footers in Application.cfm and OnRequestEnd.cfmAnd I fail to see why this is such a bad idea? So I have decided to limit use of CSS in my sites to things that work on most browsers. -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: November 5, 2003 6:30 AM To: CF-Talk Subject: RE: OT- Dynamic Page Layouts Note that it is not good practice to use OnRequestEnd.cfm for any display outputs. (The same goes for Application.cfm) I understood that the Mickael's problem was not how to get something appended to every called template, rather how to get a display piece to be presented at the bottom of the browser window (no matter what template is called). /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no http://www.grida.no - | -Original Message- | From: Peter Tilbrook [mailto:[EMAIL PROTECTED] | Sent: Wednesday, November 05, 2003 11:47 | To: CF-Talk | Subject: RE: OT- Dynamic Page Layouts | | | Mike, as Hugo stated definately avoid frames for this tip. | | Use the OnRequestEnd.cfm template. | | Unlike the Application.cfm template, OnRequestEnd.cfm is | executed AFTER | all other cfm templates. Very handy and I haven't worked out | a better way to | use it from what you require. | | In fact that is what I use for the footer at | www.actcfug.com. There IS a | way to use it with frames but it usually requires using | CFABORT at the end | of the template which probably isn't good practice - but it | works at any | rate. You could use the CFABORT method at the end of a | template in say a | small popup where your usual footer either does not fit or is not | appropriate. | | HTH | | Peter Tilbrook | ColdFusion Applications Developer | ColdGen Internet Solutions | Manager, ACT and Region ColdFusion Users Group - | http://www.actcfug.com http://www.actcfug.com | 4/73 Tharwa Road | Queanbeyan, NSW, 2620 | AUSTRALIA | | Telephone: +61-2-6284-2727 | Mobile: +61-0439-401-823 | E-mail: [EMAIL PROTECTED] | | World Wide Web: http:/www.coldgen.com/ | -Original Message- | From: Mickael [mailto:[EMAIL PROTECTED] | Sent: Wednesday, 5 November 2003 9:36 PM | To: CF-Talk | Subject: Re: OT- Dynamic Page Layouts | | | Hugo | | Thanks that is just what I needed. |- Original Message - |From: Hugo Ahlenius |To: CF-Talk |Sent: Wednesday, November 05, 2003 2:52 AM |Subject: Re: OT- Dynamic Page Layouts | |Two ways: | |* Frames, I think you should avoid it for this case. |* CSS. I found a good way on the web somewhere (now link). | You can look at |the source and the css of this page, which uses a CSS | method to do this: | http://globalis.no/admin/ http://globalis.no/admin/ | |- |Hugo AhleniusE-Mail: [EMAIL PROTECTED] |Project Officer Phone:+46 8 230460 |UNEP GRID-ArendalFax:+46 8 230441 |Stockholm OfficeMobile:+46 733 467111 | WWW: http://www.grida.no http://www.grida.no |- | | || On Wednesday, November 05, 2003 05:50 [GMT+1=CET], || Mickael [EMAIL PROTECTED] wrote: | || Hello All, || || This is not exactly a coldfusion question but does | pertain to dynamic || site.I have a site in CF that the client would like to include a || standard footer at the bottom of the page.This works | fine when the || content that is returned is more than once screen in my explorer || window at my resolution. || || The problem that I am having is that some of the pages | have content || that is returned and it is a little bit less one screen | so I see my || footer then the remainder of the screen below the footer | which is not || what the client wants. || || Is there a way to handle this? || || Thanks || || Mike || || || | | | | _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date
Just out of curiosity, shouldn't the script at the top be
switch(two) {
case 11:
case 12:
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
instead of
switch(two) {
case 11: { num = two; break; }
case 12: { num = two; break; }
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 9:08 AM
To: CF-Talk
Subject: RE: Date
I'm pretty sure there is a UDF for this at cflib.org. Yep,
http://www.cflib.org/udf.cfm?ID=349
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: OT- Dynamic Page Layouts
To repeat: We are talking about two different things: * If you want to have a strip of text on a page that is displayed on the bottom of the browser window it does not matter where it is loaded (by an IIS automatic include, OnRequestEnd.cfm or whatever) -- the display in the client has to be done by a) Frames, or b) CSS. The method I described works in modern browsers, and is ignored by older. (Personally - I have stopped sending css to Netscape 4 clients, they just get the bare contents). * To have some code/display included with every request, yes then you can use some IIS settings, Application/OnRequestEnd.cfm etc. For the latter: there are a number of arguments against having display code in those two files, which is a different discussion (I think there should be loads of info if you search the archives of this list). Cheers, Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] | Sent: Wednesday, November 05, 2003 15:26 | To: CF-Talk | Subject: RE: OT- Dynamic Page Layouts | | | IF its not good practice? What else do you suggest? | Personally, I think css | is quirky and causes more cross browser headaches than its | really worth. | Maybe my knowledge of css isn't wide enough to adequately | implement them, | but everything I have done/seen/read with cssbasically ends | up sounding | like this : You can do this, but not with that browser you | need to do this | instead but that won't work with version x.x and it just | goes on and on... | I actually cfinclude my headers and footers in Application.cfm and | OnRequestEnd.cfmAnd I fail to see why this is such a bad | idea? So I have | decided to limit use of CSS in my sites to things that work on most | browsers. | | | | -Original Message- | From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] | Sent: November 5, 2003 6:30 AM | To: CF-Talk | Subject: RE: OT- Dynamic Page Layouts | | Note that it is not good practice to use OnRequestEnd.cfm for | any display | outputs. (The same goes for Application.cfm) | | I understood that the Mickael's problem was not how to get something | appended to every called template, rather how to get a | display piece to be | presented at the bottom of the browser window (no matter what | template is | called). | | /Hugo | | | - | Hugo AhleniusE-Mail: [EMAIL PROTECTED] | Project Officer Phone:+46 8 230460 | UNEP GRID-ArendalFax:+46 8 230441 | Stockholm OfficeMobile:+46 733 467111 |WWW: http://www.grida.no | http://www.grida.no | - | | | | | -Original Message- | | From: Peter Tilbrook [mailto:[EMAIL PROTECTED] | | Sent: Wednesday, November 05, 2003 11:47 | | To: CF-Talk | | Subject: RE: OT- Dynamic Page Layouts | | | | | | Mike, as Hugo stated definately avoid frames for this tip. | | | | Use the OnRequestEnd.cfm template. | | | | Unlike the Application.cfm template, OnRequestEnd.cfm is | | executed AFTER | | all other cfm templates. Very handy and I haven't worked out | | a better way to | | use it from what you require. | | | | In fact that is what I use for the footer at | | www.actcfug.com. There IS a | | way to use it with frames but it usually requires using | | CFABORT at the end | | of the template which probably isn't good practice - but it | | works at any | | rate. You could use the CFABORT method at the end of a | | template in say a | | small popup where your usual footer either does not fit or is not | | appropriate. | | | | HTH | | | | Peter Tilbrook | | ColdFusion Applications Developer | | ColdGen Internet Solutions | | Manager, ACT and Region ColdFusion Users Group - | | http://www.actcfug.com http://www.actcfug.com | | 4/73 Tharwa Road | | Queanbeyan, NSW, 2620 | | AUSTRALIA | | | | Telephone: +61-2-6284-2727 | | Mobile: +61-0439-401-823 | | E-mail: [EMAIL PROTECTED] | | | | World Wide Web: http:/www.coldgen.com/ | | -Original Message- | | From: Mickael [mailto:[EMAIL PROTECTED] | | Sent: Wednesday, 5 November 2003 9:36 PM | | To: CF-Talk | | Subject: Re: OT- Dynamic Page Layouts | | | | | | Hugo | | | | Thanks that is just what I needed. | |- Original Message - | |From: Hugo Ahlenius | |To: CF-Talk | |Sent: Wednesday, November 05, 2003 2:52 AM | |Subject: Re: OT- Dynamic Page Layouts | | | |Two ways: | | | |* Frames, I think you should avoid it for this case. | |* CSS. I found a good way on the web somewhere (now link). | | You can look at | |the source and the css of this page, which uses a CSS | | method to do this: | | http://globalis.no/admin/ http://globalis.no/admin/ | | |
Re: Using cfhttp to access FTP via IE
Well, after playing with my code in IE it only partly works. It opens two ftp windows nicely side by side, but then it goes downhill. Trying to open a directory on one side effectively does a target=_top. Hitting the back button then brings back the frameset, but it's listed in traditional ftp text listing instead of the graphical folder presentation. Ah well. -Kevin - Original Message - From: Kevin Graeme [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 8:26 AM Subject: Re: Using cfhttp to access FTP via IE It works in a frameset for me. Here's my code: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Frameset//EN http://www.w3.org/TR/html4/frameset.dtd html head titleDueling FTP/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head frameset cols=*,* frameborder=NO border=0 framespacing=0 frame src="" name=leftFrame frame src="" name=mainFrame /frameset noframesbody /body/noframes /html -Kevin - Original Message - From: Bushy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 7:01 AM Subject: RE: Using cfhttp to access FTP via IE Exactly but I want to be able to biuld this into a frameset. __ | || |ftp://server1|ftp://server2| | || | || | || |___ |__ | Doesn't seem to work in my app. If I open just a separate IE window and type in the ftp path it works just fine but not within my frameset? --Original Message Text--- From: J E VanOver Date: Tue, 4 Nov 2003 13:33:36 -0800 Read Only?On WinXP it acts just like another explorer window.Drag and drop to ftp.Kinda nice! Jevo -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 12:36 PM To: CF-Talk Subject: RE: Using cfhttp to access FTP via IE Your browser is an HTTP client and an FTP client. If you want to perform FTP operations from CF, you'll have to use CFFTP instead of CFHTTP. Dave Watts, CTO, Fig Leaf Software Like Dave says, HTTP and FTP are fairly different protocols. Different command sets, different ports, etc. Microsoft has simply added a helpful feature to IE that lets you browse FTP servers through an artificial read-only HTML-like interface. (I haven't tried it in ages but it might do GOPHER:// as well.) --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date
Yep, thats defintely cleaner. Updated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [Stats] CF-Talk: October 2003
On Wednesday 05 Nov 2003 11:54 am, Angel Stewart wrote: I wonder how many people would disappear if we all had to pay a yearly/monthly subscription for these lists? I'd go. Why pay for something I can get elsewhere for free ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date
Nope, they both work.It's analogous to:
cfcase value=11,12,13
cfset num = two
/cfcase
Reduces redundant code.Easier to read.
-Patti
Just out of curiosity, shouldn't the script at the top be
switch(two) {
case 11:
case 12:
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
instead of
switch(two) {
case 11: { num = two; break; }
case 12: { num = two; break; }
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 9:08 AM
To: CF-Talk
Subject: RE: Date
I'm pretty sure there is a UDF for this at cflib.org. Yep,
http://www.cflib.org/udf.cfm?ID=349
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: [Stats] CF-Talk: October 2003
We have had this discussion over on CF-Community before. Some felt that paying a very small fee would be worth it from the knowledge that you get here. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 9:43 AM To: CF-Talk Subject: Re: [Stats] CF-Talk: October 2003 On Wednesday 05 Nov 2003 11:54 am, Angel Stewart wrote: I wonder how many people would disappear if we all had to pay a yearly/monthly subscription for these lists? I'd go. Why pay for something I can get elsewhere for free ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date
Just to be clear, I read his email as should, not have to. Obviously both ways work, but I agree, using the fall through method, or whatever its called, makes it easier to read and does reduce code. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date
I know they both work, but repeated code that forms no function is a
waste
The original code was more like
cfcase value=11
cfset num = two
/cfcase
cfcase value=12
cfset num = two
/cfcase
cfcase value=13
cfset num = two
/cfcase
-Original Message-
From: Patricia G. L. Hall [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:47 AM
To: CF-Talk
Subject: RE: Date
Nope, they both work.It's analogous to:
cfcase value=11,12,13
cfset num = two
/cfcase
Reduces redundant code.Easier to read.
-Patti
Just out of curiosity, shouldn't the script at the top be
switch(two) {
case 11:
case 12:
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
instead of
switch(two) {
case 11: { num = two; break; }
case 12: { num = two; break; }
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 9:08 AM
To: CF-Talk
Subject: RE: Date
I'm pretty sure there is a UDF for this at cflib.org. Yep,
http://www.cflib.org/udf.cfm?ID=349
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Printable pages
Hi all, I have a page of query results which offers the user the option of printing the results listing. I have handled this by sending the user to a graphics-free page where the query is run against the database again, using the session variables from the previous page.This works, but it seems clunky. Is there a way to handle printing reports more gracefully? I can't use _javascript_ on these pages. Thanks, Laura === Laura Schlee DML Associates ofc202-685-1360 cell 703-622-0363 __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help with this regex
Looks like Pascal already posted a fix, but (since you asked) it looks like your problem is that you've got (^[ ]) instead of ([^ ]). Happy Regexing. --Ben Doom Ryan Mitchell wrote: Hello I have the following regex: s = rereplace(s, a[^]*href="" ])*[^]*[^]*/a,\1,all); Which should (in theory) replace a href="" here/a With page.htm But instead it just returns click here. Can anyone see where I'm going wrong? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: RE: [Stats] CF-Talk: October 2003
Probably has to do with the automagic comment removal system that strips out extraneous copies of the footer.Perhaps it's looking for a line of tilde characters and the stats report generates that as well. Hatton -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 4:48 AM To: CF-Talk Subject: Re: [Stats] CF-Talk: October 2003 Not only did the list of contributors vanish, so did my comment that they had... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Printable pages
Laura Schlee wrote: I have a page of query results which offers the user the option of printing the results listing. I have handled this by sending the user to a graphics-free page where the query is run against the database again, using the session variables from the previous page.This works, but it seems clunky. Is there a way to handle printing reports more gracefully? I can't use _javascript_ on these pages. CSS. Use one stylesheet for the screen and another one for the printed version. The UA should pick the right one if you specify the right media attribute. Jochem -- You have the right to remain silent but should you? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Regex help
hey mathew... that almost works! its not stopping at the end though reReplaceNoCase(string, /?cf[^]+, , all) its pretty much returning anything that starts with cf RETURNS cfoutpout table border=0 cellpadding=0 cellspacing=0 tr td /td /tr /table /cfoutput and enything inbetween what I am trying to do is colorcodeall the cf tags that are in a code block of a message board post thanks for your help Ewok - Original Message - From: Matthew Walker To: CF-Talk Sent: Tuesday, November 04, 2003 11:51 PM Subject: RE: Regex help It rather depends what you're trying to do but: reReplaceNoCase(string, /?cf[^]+, , all) -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 4:20 p.m. To: CF-Talk Subject: Regex help hola listo! I need some regex help : ) i need to find all cf tags in some text and replace it with something else so anything that starts with cfand ends with and anything that starts with /cf and ends with this should be an easy one and im sure it is... but I left my brain on vacation i THOUGHT it was cf[^] or /cf[^] but they arent working... the just return the cf or the /cf but not the rest of the tag TIA cheers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 10/17/2003 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date
Sorry, I think I misread your message.For some reason I thought that you
were saying that the second, less concise method was what the code should
be changed TO, instead of changed FROM.
Deduct 10 points from my reading comprehension score, please.
I do agree with both you and Ray that the fall through method is better.
For what (little) that's worth.
-Patti
I know they both work, but repeated code that forms no function is a
waste
The original code was more like
cfcase value=11
cfset num = two
/cfcase
cfcase value=12
cfset num = two
/cfcase
cfcase value=13
cfset num = two
/cfcase
-Original Message-
From: Patricia G. L. Hall [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:47 AM
To: CF-Talk
Subject: RE: Date
Nope, they both work.It's analogous to:
cfcase value=11,12,13
cfset num = two
/cfcase
Reduces redundant code.Easier to read.
-Patti
Just out of curiosity, shouldn't the script at the top be
switch(two) {
case 11:
case 12:
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
instead of
switch(two) {
case 11: { num = two; break; }
case 12: { num = two; break; }
case 13: { num = two; break; }
default: { num = Right(num,1); break; }
}
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 9:08 AM
To: CF-Talk
Subject: RE: Date
I'm pretty sure there is a UDF for this at cflib.org. Yep,
http://www.cflib.org/udf.cfm?ID=349
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: OT:Transparent Div question.
Try making everything BELOW the blue bar another div called ContentArea or something andplace your other divs inside that cheers - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, November 05, 2003 6:49 AM Subject: OT:Transparent Div question. Hello All, I've got a slideshow app,using data from a DB I build a series of divs and switch between them using JS and timeouts. (in a nutshell) Everything works hunkey dorey except for one small problem with one of the Div's: The page consists of a top blue bar (title and subtitle),bottom blue bar (generic contact info) and a middle area (content area - consisting of a table and an image). The top and middle areas change with each cycle of the loop but because the page background is white I want to create a default top Div so that the different content top divs can be transparent and the change over of div's is smooth. Basically I have tried setting the content top divs with background:transparent; in the style and have played around with the z-index but, no matter what I try the default top div (the big blue bar) covers up all the content top Divs (blue bar with White and orange text) Surely can't I setup something like: div id=defaultTop style=background:darkblue; /div div id=div1_txt style=background:transparent; /div Therefore when I hide the div1_txt then make the next div visible the blue bar will still be there. Ignoring the height, width and position why wont this work,why does the default top cover all the other top divs? -Darren [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UPS XML Rates w/ DRK5 Socket Component
Let's try it this way... Has anyone implemented the UPS rates XML service with CFMX 6.1's underlying J2EE functionality (namely the java.net.Socket object)? -cccfug.org -Original Message- From: Igor Ilyinsky Sent: Tuesday, November 04, 2003 3:31 PM To: CF-Talk Subject: UPS XML Rates w/ DRK5 Socket Component Hi Yall, For a long time I've been looking for a good way to implement the usage of UPS's XML based rates service program to calculate shipping costs. In the past, there were so many ways to do this, but they were all too messy or tedious... i.e, not worth the simple functionality I required. There were the custom tags that my host wouldn't let me use, the XML hacks, or writing my own java method to do it. Everyone kept expecting that CFMX would provide a cure but it hasn't. The bottom line was that CF did not provide a developer with usage of a Raw XML socket over HTTP as CFHTTP would f-up the buffer with all of its headers. Well, now there is a component on the latest DRK that promises to allow the raw XML Socket via the underlying java.net.Socket object. It is called the socket component, and may just be the saving grace here. So has anyone used it to implement the UPS Rates Services API? I'd be curious to know if it works, the performance, and how it is implemented. I think if this really does work, it will provide any developer using CFMX 6.1 with a means to easily get real-time shipping rates with very little programming, and for Macromedia, I think this component alone will make buying DRK5 a great value. Furthermore, it promotes using the underlying J2EE functionality to empower your CF app... -Igor -cccfug.org _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Printable pages
Does media PRINT remove the browser crap from the page? For instance: the address at the bottom of a printed page as well as the numbers at the top, or this only achievable through the browser settings? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:02 AM To: CF-Talk Subject: Re: Printable pages Laura Schlee wrote: I have a page of query results which offers the user the option of printing the results listing. I have handled this by sending the user to a graphics-free page where the query is run against the database again, using the session variables from the previous page.This works, but it seems clunky. Is there a way to handle printing reports more gracefully? I can't use _javascript_ on these pages. CSS. Use one stylesheet for the screen and another one for the printed version. The UA should pick the right one if you specify the right media attribute. Jochem -- You have the right to remain silent but should you? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT- Dynamic Page Layouts
Two ways to achieve what Mickael wants.Remember that Mickael's problem was NOT how to include the code on the page ,but how to make sure it always appears at the lowest point on the page.So he has a layout issue, not a CF Inclusions issue. Method [a]:CSS.Use a DIV=footer tag around the footer text and absolute positioning in the stylesheet so that it's positioned at the bottom of the window.If you don't want to use the modern way to position elements on a page, you'll have to divide up the page using tables... Method [b]Use a table for the overall page structure like this (simplified somewhat for clarity): .!--- header include starts here . --- .body .table .tr .td colspan=3 Header stuff- logo, images, etc. ./td ./tr .!--- header include ends here . --- .!--- Left nav include starts here . --- .tr .td Left nav bar contents/td .td .!--- Left nav include ends here . --- Main body of the page - the big box in the middle of the window .!--- Right column include starts here . --- ./td .tdRight Column contents/td ./tr .!--- Right column include Ends here . --- .!--- Footer include starts here . --- .tr .td colspan=3 Footer stuff- a footer include file ./td ./tr ./table ./body ./html Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Stats] CF-Talk: October 2003
What about everything else I said? I'd go. Why pay for something I can get elsewhere for free ? Good...for a moment I was wondering if you didn't comprehend the reason for using HTML in the emails. -Gel -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] On Wednesday 05 Nov 2003 11:54 am, Angel Stewart wrote: I wonder how many people would disappear if we all had to pay a yearly/monthly subscription for these lists? I'd go. Why pay for something I can get elsewhere for free ? -- Tom Chiverton Advanced ColdFusion Programmer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Printable pages
Tangorre, Michael wrote: Does media PRINT remove the browser crap from the page? For instance: the address at the bottom of a printed page as well as the numbers at the top, or this only achievable through the browser settings? They are user settings, and (naturally) CSS can't override the user. Jochem -- You have the right to remain silent but should you? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regex help
Some thoughtful soul (Dain Anderson) has already created a ColorCode script for you.I use it on my blog website and it works wonderfully.You can find it here: http://www.cfcomet.com/utilities/ http://www.cfcomet.com/utilities/ Look forhttp://www.cfcomet.com/utilities/CF_ColoredCode_v3-2.zip CF_ColoredCode v3.2 -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:02 AM To: CF-Talk Subject: Re: Regex help hey mathew... that almost works! its not stopping at the end though reReplaceNoCase(string, /?cf[^]+, , all) its pretty much returning anything that starts with cf RETURNS cfoutpout table border=0 cellpadding=0 cellspacing=0 tr td /td /tr /table /cfoutput and enything inbetween what I am trying to do is colorcodeall the cf tags that are in a code block of a message board post thanks for your help Ewok - Original Message - From: Matthew Walker To: CF-Talk Sent: Tuesday, November 04, 2003 11:51 PM Subject: RE: Regex help It rather depends what you're trying to do but: reReplaceNoCase(string, /?cf[^]+, , all) -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 4:20 p.m. To: CF-Talk Subject: Regex help hola listo! I need some regex help : ) i need to find all cf tags in some text and replace it with something else so anything that starts with cfand ends with and anything that starts with /cf and ends with this should be an easy one and im sure it is... but I left my brain on vacation i THOUGHT it was cf[^] or /cf[^] but they arent working... the just return the cf or the /cf but not the rest of the tag TIA cheers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 10/17/2003 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Printable pages
A good example/tutorial of different styles for different media can be found here: http://builder.com.com/5100-6371-1050180.html -d - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Wednesday, November 05, 2003 10:02 AM Subject: Re: Printable pages Laura Schlee wrote: I have a page of query results which offers the user the option of printing the results listing. I have handled this by sending the user to a graphics-free page where the query is run against the database again, using the session variables from the previous page.This works, but it seems clunky. Is there a way to handle printing reports more gracefully? I can't use _javascript_ on these pages. CSS. Use one stylesheet for the screen and another one for the printed version. The UA should pick the right one if you specify the right media attribute. Jochem -- You have the right to remain silent but should you? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Convert to unicode
I've just been browsing through pauls article on G18N at http://www.macromedia.com/devnet/mx/coldfusion/articles/globalize.html and have a question for the forum. How do I convert some text (inc jap, chinese etc) into Unicode for storage inside the resourceBundles? TIA Neil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [Stats] CF-Talk: October 2003
Thanks, Bill! I'm not sure why the top 20 contributors were cut off there, but I'm sure Michael will look into it when he has a minute. Don't forget, we also have searchable archives right on House of Fusion: http://www.houseoffusion.com/cf_lists/threads.cfm/4/11:05:2003 (CF-Talk) http://www.houseoffusion.com/cf_lists/ (All lists -- simply click on the list name at the left) Judith Dinowitz Mistress of the House House of Fusion - Original Message - From: Bill Doerrfeld [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 1:27 PM Subject: [Stats] CF-Talk: October 2003 Searchable archives for this list are available at http://www.listsearch.com/cf-talk.lasso --- CF-Talk Stats October, 2003 --- Note: Up/Down % as compared with September, 2003 Posts:3724 (Down 10%) Authors:431 (Down2%) Threads:805 (Up 8%) Top 20 Contributors by Number of Posts [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ID Retrieval
I have a BETA database table with one column with email addresses listed. There are about 20K rows in this table. What I need to is join the ALPHA table to retrieve CUSTOMER_ID that each email address identified with. I can write a script that loops over all the address and an insert to a new table with the found customer_id, but that just doesn't seem right. 20K database reads and 20K database writes, seems a little bit of overkill for matching up a email addresses with an ID. I also could also do something along this method which is probably the better solution: CREATE TABLE NEWTABLE AS (SELECT A.CUSTOMER_ID, B.EMAIL FROM TABLE A INNER JOIN TABLE B ON B.EMAIL = A.EMAIL) I am looking for a couple of other suggestions before I write this module. Thx! --- Ricky Fritzsching [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle Sequences
I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Setting up other OLDDB in CF5
Hi We're trying to set up an OLEDB connection using a third-party provider (SalesLogix).The following connection string works in VB but I don't have clue how to translate this into something that cf admin can take. This works as a connection string in VB... Provider=SLXNetwork.1;Password='passwordgoeshere';User ID=admin;Data Source=SALESLOGIX_HQ;Extended Properties='SLX Server=SERVERNAME;ADDRESS=localhost;Type=ODBC;PORT=1706';RSPass=passwordgoes here Any help appreciated! Thanks Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
Try doing two separate queries: cfquery name=insertData INSERT INTO ... /cfquery cfquery name=getSeq SELECT PKSeq.CurrVal /cfquery Stick them inside a transaction and you should be good to go. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
in Oracle you select stuff like this from the table dual, Oracles all powerful ally. Example select elem_seq.currval from dual Doug -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 New Query Bug
Hey all, I have the following in a test case and what happens is that the documentName column is returned to me computed_column_2. It is not a cfdump problem because when I try, queryName.documentName CF returns documentName not defined in query. Could someone verify that this is a bug and if so I will submit it as such. Steps to recreate: 1. Create a simple table with documentID, and documentName columns. The documentID column should be an integer, primary key. The documentName column should be a ntext field. 2. Run the following code in a test page. cfquery name=qry_GetDocuments datasource=yourDSN SELECT documentID, convert(nvarchar, documentName) FROM tbl_documentLibrary /cfquery cfdump var=#qry_GetDocuments# Thanks Bryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMail Problem
I have a form that works great until I add the CC option into it. Can anyone help me? Here is the code that works CFMAIL server=mail.LtcConnection.net FROM=#form.Email_Address# TO=#form.send_to# SUBJECT=#form.subject# When I change it to CFMAIL server=mail.LtcConnection.net FROM=#form.Email_Address# TO=#form.send_to# CC=#form.Email_Address# SUBJECT=#form.subject# It won't go anywhere. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using cfhttp to access FTP via IE
At 01:33 PM 11/4/2003 -0800, you wrote: Read Only?On WinXP it acts just like another explorer window.Drag and drop to ftp. Kinda nice! You're right of course. About 2 seconds after I hit send I thought a mild expletive concerning the phrase read only -- but too late. Was thinking something along the lines of simple and that came out. Happens. ;) --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help with this regex
After Ben's post I noticed a space I didn't see before. It should be s = rereplace(s, a[^]+href=""> with no spaces at all in the regexp. Pascal -Oorspronkelijk bericht- Van: Pascal Peters Verzonden: wo 5/11/2003 14:34 Aan: CF-Talk CC: Onderwerp: RE: Help with this regex s = rereplace(s, a[^]+href="" ]*)[^]*[^]*/a,\1,all); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 New Query Bug
This isn't a bug. I believe when you call a func on a column, the db _itself_ renames the column. I think you are supposed to d select foo, func(moo) as whatever then use queryname.whatever. I'm not sure if this is specific to one db, or maybe it's just CF, but I know whenever I do a func on a column, I use as. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 New Query Bug
No bug. Computed columns should have an alias SELECT documentID, convert(nvarchar, documentName) AS documentName -Oorspronkelijk bericht- Van: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Verzonden: wo 5/11/2003 16:57 Aan: CF-Talk CC: Onderwerp: CFMX 6.1 New Query Bug Hey all, I have the following in a test case and what happens is that the documentName column is returned to me computed_column_2. It is not a cfdump problem because when I try, queryName.documentName CF returns documentName not defined in query. Could someone verify that this is a bug and if so I will submit it as such. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 New Query Bug
Thanks Ray, that's what I forgot. Humbly going back into my hole. :) Bryan -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 11:09 AM To: CF-Talk Subject: RE: CFMX 6.1 New Query Bug This isn't a bug. I believe when you call a func on a column, the db _itself_ renames the column. I think you are supposed to d select foo, func(moo) as whatever then use queryname.whatever. I'm not sure if this is specific to one db, or maybe it's just CF, but I know whenever I do a func on a column, I use as. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
right i tried that too (sorry forgot to post it), still the same error of [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended Tyler Clendenin GSL Solutions _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:47 AM To: CF-Talk Subject: RE: Oracle Sequences in Oracle you select stuff like this from the table dual, Oracles all powerful ally. Example select elem_seq.currval from dual Doug -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UPS XML Rates w/ DRK5 Socket Component
At 09:01 AM 11/5/2003 -0600, you wrote: Let's try it this way... Has anyone implemented the UPS rates XML service with CFMX 6.1's underlying J2EE functionality (namely the java.net.Socket object)? Well, do you have a link to the specs of the format UPS's uses? Shouldn't be all that hard. I've been learning Java the last three weeks with a nod to taking the certifications in mind. If it doesn't look like it would take too long I might just do it for the practice. -cccfug.org --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Sequences
I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character JDBC has a limitation where you can't have multiple queries within the same cfquery, as least for Oracle (not sure about the other vendors). You have to have two separate calls inside of a cftransaction. Either that, or convert the process into a stored proc and just set a return value to the primary key value. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [Stats] CF-Talk: October 2003
Here's the post resent. In this post I've removed all instances of lengthy successive underscore characters (more than those characters used above and below the CF-Talk Stats report header) that were used in the prior post to help visually divide sections of this report. Hopefully this will come through as intended. Apologies for the repost. - Searchable archives for this list are available at http://www.listsearch.com/cf-talk.lasso --- CF-Talk Stats October, 2003 --- Note: Up/Down % as compared with September, 2003 Posts:3724 (Down 10%) Authors:431 (Down2%) Threads:805 (Up 8%) Top 20 Contributors by Number of Posts Tony Weeg 124 Jochem van Dieten103 Dave Watts 96 Barney Boisvert78 Bushy77 Raymond Camden75 Jim Davis73 Thomas Chiverton 70 Michael Dinowitz 57 Tangorre, Michael55 Calvin Ward51 Matt Liotta51 Craig Dudley43 Bryan Stevenson42 ColdFusion Programmer41 Claude Schneegans40 Matt Robertson40 Pascal Peters 38 cf-talk 38 Mark A. Kruger - CFG35 Top 20 Threads by Number of Posts SES urls on CFMX 6.141 application.cfm37 Antivirus software on web server37 How can it be done ?37 Macromedia sinks on sales news34 Sorting IP Addresses30 Scope Locking ( Blue Dragon and Fusebox) 29 Coldfusion VS Zope (Python) ... HELP!!28 Giving up on DW 2004 MX28 number of occurrences in a string. 28 SQL Statement help! 27 security flaw in web services25 lite source control for Homesite+ ? 24 OT (wasMacromedia sinks on sales news) 23 Looping through a list, setting each listItem to a column21 CFMX 6.1 on Windows 2003 = Service Unavailable !!!20 html emails with _javascript_ in outlook20 RSS feed20 sql question pt 219 Customg tag that will ring a phone 18 Top 20 Search Terms by Number of Requests password 5 rewriterule 5 function 5 mod_rewrite 5 mysql 4 coldfusion3 statistics2 contain2 a2 cfmail2 rewrite2 email 2 rule2 JRun2 did2 closed2 not2 connection2 X1 session1 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
right but that is not a very intuitive approach, shouldn't there be something.is it just because the oracle driver does not allow multiple queries in the same cfquery and the mssql driver does?is there any way i can get around this.i really don't want to have to break that statement out into another query.i'm sure there is a performance hit of some sort. i want to make this as scalable as possible and am trying to follow that idea in all the code.plus it would just be annoying to have to do another cfquery just to only execute one more command. Tyler Clendenin GSL Solutions _ From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:44 AM To: CF-Talk Subject: RE: Oracle Sequences Try doing two separate queries: cfquery name=insertData INSERT INTO ... /cfquery cfquery name=getSeq SELECT PKSeq.CurrVal /cfquery Stick them inside a transaction and you should be good to go. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
The below def works here in cf5/Oracle 8.1.6 cfquery name=qTAS_NewID datasource=#REQUEST.sIF_DSN# SELECT questionnaire_seq.nextval NEW_ID FROMdual /cfquery cfset iNewQuestID = qNewID.NEW_ID cfquery name=qCopyQuestInfo datasource=#REQUEST.sIF_DSN# INSERT INTO QUESTIONNAIRE ( ID, NAME, CREATED, AUTHOR ) VALUES ( cfqueryparam value=#iNewQuestID# cfsqltype=CF_SQL_DECIMAL, cfqueryparam value=#sNewQuestName# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#Now()# cfsqltype=CF_SQL_TIMESTAMP, cfqueryparam value=#SESSION.Username# cfsqltype=CF_SQL_VARCHAR ) /cfquery -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: 05 November 2003 16:24 To: CF-Talk Subject: RE: Oracle Sequences right i tried that too (sorry forgot to post it), still the same error of [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended Tyler Clendenin GSL Solutions _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:47 AM To: CF-Talk Subject: RE: Oracle Sequences in Oracle you select stuff like this from the table dual, Oracles all powerful ally. Example select elem_seq.currval from dual Doug -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes? I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 New Query Bug
Try aliasing your computed column...like this cfquery name=qry_GetDocuments datasource=yourDSN SELECT documentID, convert(nvarchar, documentName) as nuevonombre FROM tbl_documentLibrary /cfquery cfdump var=#qry_GetDocuments# Doug -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:57 AM To: CF-Talk Subject: CFMX 6.1 New Query Bug Hey all, I have the following in a test case and what happens is that the documentName column is returned to me computed_column_2. It is not a cfdump problem because when I try, queryName.documentName CF returns documentName not defined in query. Could someone verify that this is a bug and if so I will submit it as such. Steps to recreate: 1. Create a simple table with documentID, and documentName columns. The documentID column should be an integer, primary key. The documentName column should be a ntext field. 2. Run the following code in a test page. cfquery name=qry_GetDocuments datasource=yourDSN SELECT documentID, convert(nvarchar, documentName) FROM tbl_documentLibrary /cfquery cfdump var=#qry_GetDocuments# Thanks Bryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Stats] CF-Talk: October 2003
At 7:54 AM -0400 11/5/03, Angel Stewart wrote: A drop of 10% from one month to the next may or may not be significant when taken in context of other months eh? ;-) Agreed. Such fluctuation is completely normal and shouldn't be misconstrued to signify any change in the level of participation or significance of the list. There are many factors influencing discussion volume including: the season of the year, big industry news, product releases and other hot topics. -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Regex help
thats really cool but its way more than I need and conflicts with the bbml parsing code I already have. thanks though. I think I'll just wrap code blocks with pre tags and leave it at that cheers - Original Message - From: Hagan, Ryan Mr (Contractor ACI) To: CF-Talk Sent: Wednesday, November 05, 2003 10:14 AM Subject: RE: Regex help Some thoughtful soul (Dain Anderson) has already created a ColorCode script for you.I use it on my blog website and it works wonderfully.You can find it here: http://www.cfcomet.com/utilities/ http://www.cfcomet.com/utilities/ Look forhttp://www.cfcomet.com/utilities/CF_ColoredCode_v3-2.zip CF_ColoredCode v3.2 -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:02 AM To: CF-Talk Subject: Re: Regex help hey mathew... that almost works! its not stopping at the end though reReplaceNoCase(string, /?cf[^]+, , all) its pretty much returning anything that starts with cf RETURNS cfoutpout table border=0 cellpadding=0 cellspacing=0 tr td /td /tr /table /cfoutput and enything inbetween what I am trying to do is colorcodeall the cf tags that are in a code block of a message board post thanks for your help Ewok - Original Message - From: Matthew Walker To: CF-Talk Sent: Tuesday, November 04, 2003 11:51 PM Subject: RE: Regex help It rather depends what you're trying to do but: reReplaceNoCase(string, /?cf[^]+, , all) -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 4:20 p.m. To: CF-Talk Subject: Regex help hola listo! I need some regex help : ) i need to find all cf tags in some text and replace it with something else so anything that starts with cfand ends with and anything that starts with /cf and ends with this should be an easy one and im sure it is... but I left my brain on vacation i THOUGHT it was cf[^] or /cf[^] but they arent working... the just return the cf or the /cf but not the rest of the tag TIA cheers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 10/17/2003 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
Thanks Dave.What a pain.but i'm glad i recieved a more difinitive answer. Tyler Clendenin GSL Solutions _ From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 11:19 AM To: CF-Talk Subject: Re: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character JDBC has a limitation where you can't have multiple queries within the same cfquery, as least for Oracle (not sure about the other vendors). You have to have two separate calls inside of a cftransaction. Either that, or convert the process into a stored proc and just set a return value to the primary key value. Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
right but that is not a very intuitive approach, shouldn't there be something.is it just because the oracle driver does not allow multiple queries in the same cfquery and the mssql driver does?is there any way i can get around this.i really don't want to have to break that statement out into another query.i'm sure there is a performance hit of some sort. i want to make this as scalable as possible and am trying to follow that idea in all the code.plus it would just be annoying to have to do another cfquery just to only execute one more command. 1. If you're looking for performance and scalablity, then your SQL should be in stored procs to begin with, rather than inline SQL. 2. Since CF caches the connection to the database, the overhead of making the second call is so negligible you can safely say there is none. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Sequences
Dave Carabetta wrote: JDBC has a limitation where you can't have multiple queries within the same cfquery, as least for Oracle (not sure about the other vendors). The JDBC spec has the limitation, but not every JDBC driver obeys the spec. Jochem -- You have the right to remain silent but should you? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Sequences
We do it with separate queries. Also, because we use the native driver we can't use cftransaction First we do a nextval for the sequence. Because asking for the nextval creates the record, it effectively reserves the slot for the rest of what we need to do. Then in another query, we do an insert or update into the record reserved for us by the nextval. Because we already have the key for the record, we can also do any other queries or whatver need to be done without asking for that record position again. -Kevin - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:28 AM Subject: RE: Oracle Sequences right but that is not a very intuitive approach, shouldn't there be something.is it just because the oracle driver does not allow multiple queries in the same cfquery and the mssql driver does?is there any way i can get around this.i really don't want to have to break that statement out into another query.i'm sure there is a performance hit of some sort. i want to make this as scalable as possible and am trying to follow that idea in all the code.plus it would just be annoying to have to do another cfquery just to only execute one more command. Tyler Clendenin GSL Solutions _ From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:44 AM To: CF-Talk Subject: RE: Oracle Sequences Try doing two separate queries: cfquery name=insertData INSERT INTO ... /cfquery cfquery name=getSeq SELECT PKSeq.CurrVal /cfquery Stick them inside a transaction and you should be good to go. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Sequences
I've found that in Oracle as well1 query per CFQUERY Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tyler Clendenin To: CF-Talk Sent: Wednesday, November 05, 2003 8:28 AM Subject: RE: Oracle Sequences right but that is not a very intuitive approach, shouldn't there be something.is it just because the oracle driver does not allow multiple queries in the same cfquery and the mssql driver does?is there any way i can get around this.i really don't want to have to break that statement out into another query.i'm sure there is a performance hit of some sort. i want to make this as scalable as possible and am trying to follow that idea in all the code.plus it would just be annoying to have to do another cfquery just to only execute one more command. Tyler Clendenin GSL Solutions _ From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:44 AM To: CF-Talk Subject: RE: Oracle Sequences Try doing two separate queries: cfquery name=insertData INSERT INTO ... /cfquery cfquery name=getSeq SELECT PKSeq.CurrVal /cfquery Stick them inside a transaction and you should be good to go. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Novell to acquire SUSE
Yes, I didn't see the other articles that explained what was happening with the Workstation line. I just assumed that they would keep the workstation version active - apparently they are, but it now costs $179+. What's with all these expensive Linux distros now? Go look at prices for a workstation version of SUSE or Mandrake or RedHat ... didn't they used to say what MS charged was ridiculous? Now they're right alongside MS price-wise. Even though RedHat adds support it's pretty limited, it's a few months of installation support at best unless you want to break $1000. Guess it's time to check out some of the other distributions ... I've heard good things about Slackware and I guess Debian is still free. On Wed, 2003-11-05 at 04:51, Thomas Chiverton wrote: On Tuesday 04 Nov 2003 18:15 pm, Joshua Miller wrote: But if you go to the store RedHat costs what, like $30-$40? Granted the Enterprise Version is expensive, but you can still buy the boxed version of RedHat Linux which I'm sure will be as reliable as ever. Not after April. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
New Dreamweaver 2004 CFMX Article
Hi Everyone, We published this new article yesterday that may interest all of the DWMX 2004 users: Speeding Up CFML Development With Dreamweaver MX 2004: How To Create Custom Server Behaviors and Dreamweaver Extensions: http://www.macromedia.com/devnet/mx/dreamweaver/articles/server_behaviors.ht ml http://www.macromedia.com/devnet/mx/dreamweaver/articles/server_behaviors.h tml Best Regards, Christine Lawson Macromedia Technical Support 617-219-7757 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Announcing Macromedia DevNet Subscriptions Maximize your power with our new premium software subscription for Macromedia developers Find out more: http://www.macromedia.com/go/devnetsubs/ http://www.macromedia.com/go/devnetsubs/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
class file not getting updated?
Hello all, I have a cfstoredproc tag that I have added 2 additional parameters... but debug code still shows 2 less.I deleted the class file and restarted services... but still no luck... any ideas on why the file isn't getting updated? Thanks, Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Sequences
It's a driver issue. The oracle drivers don't allow multiple queries in one shot from CF. And, you can't use cftransaction either, as each call carries an implicit commit. What you need to do is the first query to get the seq. using SELECT myseq.NEXTVAL as newid from dual then use it in your next query insert into mytable(myid) values (#myquery.nextval#) Of course this is pseudo code and you should be usin queryparams, etc. -d - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:24 AM Subject: RE: Oracle Sequences right i tried that too (sorry forgot to post it), still the same error of [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended Tyler Clendenin GSL Solutions _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:47 AM To: CF-Talk Subject: RE: Oracle Sequences in Oracle you select stuff like this from the table dual, Oracles all powerful ally. Example select elem_seq.currval from dual Doug -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using cfhttp to access FTP via IE
Your browser is an HTTP client and an FTP client. If you want to perform FTP operations from CF, you'll have to use CFFTP instead of CFHTTP. This is driving me nuts. The problem is my expertise. I understand. Unfortunately, there's no easy solution to this. You will simply have to learn by doing. We've all been there before, if it makes you feel any better. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Novell to acquire SUSE
Use the Slack Luke!Ha!Slack rawksit ain't for the faint of heart though.I have not heard of anyone getting CF running on it yet, but cfmx being Java'd out now, this may not be an issue.I dunno. Doug -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 11:34 AM To: CF-Talk Subject: Re: Novell to acquire SUSE Yes, I didn't see the other articles that explained what was happening with the Workstation line. I just assumed that they would keep the workstation version active - apparently they are, but it now costs $179+. What's with all these expensive Linux distros now? Go look at prices for a workstation version of SUSE or Mandrake or RedHat ... didn't they used to say what MS charged was ridiculous? Now they're right alongside MS price-wise. Even though RedHat adds support it's pretty limited, it's a few months of installation support at best unless you want to break $1000. Guess it's time to check out some of the other distributions ... I've heard good things about Slackware and I guess Debian is still free. On Wed, 2003-11-05 at 04:51, Thomas Chiverton wrote: On Tuesday 04 Nov 2003 18:15 pm, Joshua Miller wrote: But if you go to the store RedHat costs what, like $30-$40? Granted the Enterprise Version is expensive, but you can still buy the boxed version of RedHat Linux which I'm sure will be as reliable as ever. Not after April. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Sequences
And, you can't use cftransaction either, as each call carries an implicit commit. Huh?Not so.We use cftransaction without issue against Oracle 8 and 9.Unless I'm having a big brain fart, cfquery doesn't perform the implicit commit within cftransaction tags.cftransaction withh perform the commit unless otherwise told not to do so. Doug -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 12:02 PM To: CF-Talk Subject: Re: Oracle Sequences It's a driver issue. The oracle drivers don't allow multiple queries in one shot from CF. And, you can't use cftransaction either, as each call carries an implicit commit. What you need to do is the first query to get the seq. using SELECT myseq.NEXTVAL as newid from dual then use it in your next query insert into mytable(myid) values (#myquery.nextval#) Of course this is pseudo code and you should be usin queryparams, etc. -d - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:24 AM Subject: RE: Oracle Sequences right i tried that too (sorry forgot to post it), still the same error of [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended Tyler Clendenin GSL Solutions _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:47 AM To: CF-Talk Subject: RE: Oracle Sequences in Oracle you select stuff like this from the table dual, Oracles all powerful ally. Example select elem_seq.currval from dual Doug -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Convert to unicode
How do I convert some text (inc jap, chinese etc) into Unicode for storage inside the resourceBundles? if you're doing it from scratch, notepad does just fine. just do a 'save as' you can select which encoding you need. i guess any modern editor ought to work ok, but its really up to the folks handling the translations (i've been working off on, mostly off these days, on a cf based rbManager similar to IBM's tool). if you have gobs of existing files, there are many file encoding conversion utils lying about. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PW encryption/decryption
Well... I've spent at least 40 hrs on this and even help from Peter Tilbrook and Tony did not solve the dilemma... would anybody be available to look at some code I've set up for a user registration password encryption scenario (used http://tutorial113.easycfm.com as a basis) I just don't get it... it works sometimes and not others... I'd be willing to send files/database etc... even pay someone at this point ... I've thrown my hands up... I really don't want to put plain text passwords in the DB, but I'm a hair away from doing just that You can see it NOT work at http://www.talbotcounty.org/employ/seekers/seeker_registration2.cfm Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Novell to acquire SUSE
I always thought the key reason to choose a Linux distro was because it was *better* than Windows, not because it was *cheaper*. I mean, Dr. DOS is cheap. :) Linux wins on the server in many cases because it's TCO is cheaper (security, reliability, hardware requirements, etc) and because it is also open source. Similar props to the BSDs. On the desktop, it's more of a toss up -- you have to decide what the total cost is to you, not just the sticker price. If you've got a good set of Linux skills, they probably transfer to the different distros, so the choice of distro should be less important. I'll echo Dave Watts and others comments though -- if you're running a production server, you should typically be running a supported commercial server OS, whether that's Windows Server, Solaris, RedHat Enterprise, SuSe Server, etc. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Joshua Miller To: CF-Talk Sent: Wednesday, November 05, 2003 11:33 AM Subject: Re: Novell to acquire SUSE Yes, I didn't see the other articles that explained what was happening with the Workstation line. I just assumed that they would keep the workstation version active - apparently they are, but it now costs $179+. What's with all these expensive Linux distros now? Go look at prices for a workstation version of SUSE or Mandrake or RedHat ... didn't they used to say what MS charged was ridiculous? Now they're right alongside MS price-wise. Even though RedHat adds support it's pretty limited, it's a few months of installation support at best unless you want to break $1000. Guess it's time to check out some of the other distributions ... I've heard good things about Slackware and I guess Debian is still free. On Wed, 2003-11-05 at 04:51, Thomas Chiverton wrote: On Tuesday 04 Nov 2003 18:15 pm, Joshua Miller wrote: But if you go to the store RedHat costs what, like $30-$40? Granted the Enterprise Version is expensive, but you can still buy the boxed version of RedHat Linux which I'm sure will be as reliable as ever. Not after April. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 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.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help with this regex
Wonderful thanks :) On 5/11/03 4:06 pm, Pascal Peters [EMAIL PROTECTED] wrote: After Ben's post I noticed a space I didn't see before. It should be s = rereplace(s, a[^]+href=""> with no spaces at all in the regexp. Pascal -Oorspronkelijk bericht- Van: Pascal Peters Verzonden: wo 5/11/2003 14:34 Aan: CF-Talk CC: Onderwerp: RE: Help with this regex s = rereplace(s, a[^]+href="" ]*)[^]*[^]*/a,\1,all); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Sequences
We're using the native drivers with CF5. Perhaps you're using the ODBC drivers? AFAIK, cftransaction only works with ODBC connections. -Kevin - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 11:14 AM Subject: RE: Oracle Sequences And, you can't use cftransaction either, as each call carries an implicit commit. Huh?Not so.We use cftransaction without issue against Oracle 8 and 9. Unless I'm having a big brain fart, cfquery doesn't perform the implicit commit within cftransaction tags.cftransaction withh perform the commit unless otherwise told not to do so. Doug -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 12:02 PM To: CF-Talk Subject: Re: Oracle Sequences It's a driver issue. The oracle drivers don't allow multiple queries in one shot from CF. And, you can't use cftransaction either, as each call carries an implicit commit. What you need to do is the first query to get the seq. using SELECT myseq.NEXTVAL as newid from dual then use it in your next query insert into mytable(myid) values (#myquery.nextval#) Of course this is pseudo code and you should be usin queryparams, etc. -d - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:24 AM Subject: RE: Oracle Sequences right i tried that too (sorry forgot to post it), still the same error of [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended Tyler Clendenin GSL Solutions _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:47 AM To: CF-Talk Subject: RE: Oracle Sequences in Oracle you select stuff like this from the table dual, Oracles all powerful ally. Example select elem_seq.currval from dual Doug -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: CF-Talk Subject: Oracle Sequences I am using CF6.1 on a redhat linux server connecting to Oracle 8i.I am trying to select the CurrVal of the sequence that i just used to insert a recod.in mssql server i can do this by selecting @@identity and i know in oracle i can do it using SeqName.CurrVal.The problem is i get this error when trying it in oracle: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended i am sure it is because there are multiple queries in the same cfquery but this is the way it must be done for data integrity reasons yes?I don't want to split it into two cfqueries because that would both create opportunities for mixed up data and would add an extra call to the db (which all in all is not that bad but should not be necessary). The query i am running loks like this. INSERT INTO TableName(PK, Name, FK) VALUES(PKSeq.NextVal, 'NameValue', #FK#) SELECT PKSeq.CurrVal AS PK I am sure that someone has run into this before I just hope there is a better answer then splitting into two queries. I also tried seperating the two queries with a semi-colon and that gave this error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character Tyler Clendenin GSL Solutions _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UPS XML Rates w/ DRK5 Socket Component
Socket communication is one way (ugly, but certainly works), but I believe a majority of the HTTP problems were fixed with 6.1, as we've implemented the UPS rate service and selection tool with CFHTTP with no problems. The following code works fine for us - !--- Build UPS XML Packet --- cfsavecontent variable=XMLPacketcfoutput ?xml version=1.0? AccessRequest AccessLicenseNumber#AccessLicenseNumber#/AccessLicenseNumber UserId#UserID#/UserId Password#Password#/Password /AccessRequest ?xml version=1.0? RatingServiceSelectionRequest xml:lang=en-US Request TransactionReference CustomerContextRating and Service/CustomerContext XpciVersion1.0001/XpciVersion /TransactionReference RequestActionRate/RequestAction RequestOptionshop/RequestOption /Request PickupType Code01/Code /PickupType Shipment Shipper Address PostalCode#attributes.originPostCode#/PostalCode CountryCodeUS/CountryCode /Address /Shipper ShipTo Address PostalCode#safePostalCode#/PostalCode City#cityName#/City cfif Len(Trim(stateProvince)) GT 0StateProvinceCode# stateProvince #/StateProvinceCode/cfif CountryCode#countryName#/CountryCode /Address /ShipTo Package PackagingType Code02/Code DescriptionPackage/Description /PackagingType DescriptionRate Shopping/Description PackageWeight Weight#weight#/Weight /PackageWeight /Package ShipmentServiceOptions/ /Shipment /RatingServiceSelectionRequest/cfoutput/cfsavecontent cfhttp url = ""> port = 443 method = POST throwonerror=yes cfhttpparam type=XML value=#XMLPacket# /cfhttp cfset XMLResponse = XmlParse(CFHTTP.FileContent) Erik Yowell [EMAIL PROTECTED] http://www.shortfusemedia.com -Original Message- From: Igor Ilyinsky [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 1:31 PM To: CF-Talk Subject: UPS XML Rates w/ DRK5 Socket Component Hi Yall, For a long time I've been looking for a good way to implement the usage of UPS's XML based rates service program to calculate shipping costs. In the past, there were so many ways to do this, but they were all too messy or tedious... i.e, not worth the simple functionality I required. There were the custom tags that my host wouldn't let me use, the XML hacks, or writing my own java method to do it. Everyone kept expecting that CFMX would provide a cure but it hasn't. The bottom line was that CF did not provide a developer with usage of a Raw XML socket over HTTP as CFHTTP would f-up the buffer with all of its headers. Well, now there is a component on the latest DRK that promises to allow the raw XML Socket via the underlying java.net.Socket object. It is called the socket component, and may just be the saving grace here. So has anyone used it to implement the UPS Rates Services API? I'd be curious to know if it works, the performance, and how it is implemented. I think if this really does work, it will provide any developer using CFMX 6.1 with a means to easily get real-time shipping rates with very little programming, and for Macromedia, I think this component alone will make buying DRK5 a great value. Furthermore, it promotes using the underlying J2EE functionality to empower your CF app... -Igor -cccfug.org _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Flash/PocketPC widget for MAX this year?
Last year there was a Flash widget for DevCon that had information about sessions and locations. Does anyone know if there's a similar PDA dookicky being put together for this year? I haven't seen anything at MM's site. -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
