Re: CF 4.0 custom 404 page...
Ian, You need to set the option in IIS to check if pages exist before sending them to the CF ISAPI. It's under Virtual Directory - Configuration button - select .cfm - click Edit - check box for check that file exists. Then if a cfm page doesn't exist it gets redirected to your IIS 404 page. HTH, Kay. Ian Tait [EMAIL PROTECTED] wrote in message news:F7797736377BD311A0B0009027B0A966422013@THOUGHTBUBBLE01... Hi, Anybody know of a way to 'customise' the ColdFusion 404 page in CF4.0?, or to enable redirection to a custom error page etc? Doesn't seem to work the same as in 4.5. Cheers, Ian Internet Email Confidentiality Footer The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to and must not disclose, copy, distribute, or retain this message or any part of it, and should notify us immediately on +44 (0)207 387 8890. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: concatenate blank fields SQL and the pesky
SELECT LTrim(Rtrim(IsNull(Author, ' ') + IsNull('; ' + secondAuthor, ' '))) AS Authors FROM table -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: dinsdag 15 januari 2002 22:25 To: CF-Talk Subject: concatenate blank fields SQL and the pesky Ok, I have to concatenate two fields together Author and SecondAuthor. SecondAuthor some times has blank values in it. What I have so far is (thanks Hatton) SELECT LTrim(Rtrim(IsNull(Author, ' ') + '; ' + IsNull(secondAuthor, ' '))) AS Authors FROM table Now the only question is if a book only has one author how do I not have the ; after the Author. Yes, I know I should break the Authors off into a related table but, that is not in the scope of the project. Thanks Mark W. Breneman -Macromedia Certified ColdFusion 5 Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 4.0 custom 404 page...
Works perfectly! You're a star! Ian -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 08:37 To: CF-Talk Subject: Re: CF 4.0 custom 404 page... Ian, You need to set the option in IIS to check if pages exist before sending them to the CF ISAPI. It's under Virtual Directory - Configuration button - select .cfm - click Edit - check box for check that file exists. Then if a cfm page doesn't exist it gets redirected to your IIS 404 page. HTH, Kay. Ian Tait [EMAIL PROTECTED] wrote in message news:F7797736377BD311A0B0009027B0A966422013@THOUGHTBUBBLE01... Hi, Anybody know of a way to 'customise' the ColdFusion 404 page in CF4.0?, or to enable redirection to a custom error page etc? Doesn't seem to work the same as in 4.5. Cheers, Ian Internet Email Confidentiality Footer The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to and must not disclose, copy, distribute, or retain this message or any part of it, and should notify us immediately on +44 (0)207 387 8890. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange CF Location problem/
Hello, Just a quick one. Does anyone know what is wrong with this scenario: We have a content management system, when a user edits a page they can preview the page by clicking a form button. The page preview opens a new window and should display the page. Now the problem : The preview button runs a script which changes the form action page to the preview page and submits the form. I send the value from the form to the preview page which uses a CFLocation to redirect to the correct display page. I can dump the values out on the screen no problem but as soon as I stick in some CFLocations the screen is blank. Code: cfswitch expression=#content# cfcase value=Introduction cfif tabletype EQ live cfoutput cflocation url=New_intro_pageLive.cfm?id=#id#menu_item=#menu_item#headline=#headli ne#subtitle=#subtitle#body=#body#template=#template# /cfoutput cfelse cfoutput cflocation url=New_intro_page.cfm?id=#id#menu_item=#menu_item#headline=#headline# subtitle=#subtitle#body=#body#template=#template# /cfoutput /cfif /cfcase cfdefaultcase just some text for the mean time /cfdefaultcase /cfswitch Any advice ? Thanks, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] Data + Structure = INFORMATION __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange CF Location problem/
Have you tried trying to recurse to get the file? eg. ../ ../../ etc..? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange CF Location problem/
If not, create a mapping and you should be ok. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange CF Location problem/
Well it should work fine as the code was previously used to preview a page calling the data from the database but, users want the preview to run with the data from the previous page (if you see what I mean). -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 11:23 To: CF-Talk Subject: RE: Strange CF Location problem/ If not, create a mapping and you should be ok. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange CF Location problem/
I think I have found the problem. I've cut out some of the parameters passed to the url in CFLocation and it calls the page fine now. I didnt realise there was a limit ! thanks for you help Neil. -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 11:23 To: CF-Talk Subject: RE: Strange CF Location problem/ If not, create a mapping and you should be ok. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Milliseconds
cf 4x + works fine with sql server milliseconds values, depending upon the field datatype in the sql server db tables. I seem to have missed the context of your use of milliseconds ... my apologies. How are y using them? Steve - Original Message - From: Rudy Rustam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 10:51 PM Subject: RE: Milliseconds Very effective indeed for getting miliseconds from now(). In MSSQL, there is a datepart(ms,date). But coldfusion only support until seconds. Any idea? Rudy -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:52 PM To: CF-Talk Subject: RE: Milliseconds GetTickCount() + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 11:13 PM To: CF-Talk Subject: Milliseconds Is there a way to get a miliseconds? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDirectory
Shawn Regan wrote: Hello cf friends, Is there a way to force cfdirectory to delete a directory even if it is not empty? cfexecute name=c:\winnt\system32\cmd.exe argumenths=/c rd #fullpath# /s timeout=20/cfexecute Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Parser
Ian Lurie wrote: What's the best way to pull content from an HTML page and insert it into a database? Any elegant solutions out there? What do you know about the HTML page? Do you know its general structure? Is it written in correct HTML or are closing tags missing all over the place? Usually you can use a combination of looping and regular expressions. But imagine what happens with the following code if the title of the page is missing or is not properly closed. cfset title = REReplaceNoCase(cfhttp.filecontent, ^.*title[^]*(.*)/title[^]*.*$,\1) Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL?
If there's a volume discount you might need to factor that into the database design as well. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 5:00 PM To: CF-Talk Subject: RE: SQL? The problem with keeping the price with the album. What if the album goes on sale? You'd change the price in the album table then suddenly anyone who bought the album previously shows that they paid the sale price. You would at least need to add a history table or make sure that the sales table shows the actual price and isn't just hooked to the album table. It's been a long day- hope this is coherent enough. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 5:01 PM To: CF-Talk Subject: SQL? I am trying to figure out how I should set up a database for an ecommerce site. I will be selling music CD's. Each artist can have several albums, and each album can have several tracks. I am pretty sure I will need 3 tables for that info. What I am wondering , is where should I keep pricing info and such? Should it be in the album table or should there be a seperate table for pricing etc. Any insight would be helpful There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML Parser
Serialise it as a WDDX packet and store the packet.. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Strange CF Location problem/
BTW, You should be able to do the same thing in a javascript routine. Basically, it would never even have to post to the server until you went through the second time :) - Original Message - From: David Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 5:42 AM Subject: Re: Strange CF Location problem/ Darren, You might find it easier to post the form to itself, changing the name of the submit buttons and using those to test. For example: cfif isDefined(Form.Cancel) ~do some cancel action~ cfif isDefined(Form.Submit) ~save record~ ~cflocation to wherever~ cfelseif isDefined(Form.Preview) cfset buttonname=Submit cfset button2type=Submit cfset button2name=Cancel cfelse cfset buttonname=Preview cfset button2type=Reset cfset button2name=Reset /cfif form action= input type=submit name=#buttonname# input type=#button2type name=#button2name# /form Some of these tags need to be edited, but you should get the idea... David Schmidt __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Hosting Service Review
Hi folks, I know the question of hosting has come up in the past, but my question comes at a bit of a different twist. Is anyone on the list familiar with Ascent Networking (http://www.ascent.net) as a hosting service provider? I'm just wondering if I can get some feedback on them. Thanks! Hatton __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DCOM ?
Hi I am trying the following : Connecting to a DCOM object on another machine that returns me a 32bit int. (or H Result in C++ terms) Below - bLogon fails to return my value. Trying to work out why its not working from this result. Any ideas ? Or DCOM / CF guru's on here ;-) Thanks Mike //Logon and send a message bLogon = tester.Logon(Attributes.Username, Attributes.Password); if bLogon == 0 { tester.SendCommand('!FSC_CADTG:Body=' Attributes.MessageBody ',Destination=' ',FSC_CMDTYPE=SubmitReq,FSC_SERVICENAME=abc,' chr(10)); } else sErrorMessage = brError: Failed to Authenticate user.; //Free up the COM object (Never trust CF to do this...) tester = ; __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Coldfusion Intelligent Queries ???
Just tried the following query and no results are now returning even thou gh there are records from todays date and future dates, since I added the li ne ORDER BY eventdate asc It just brings back a blank page? it is an oracle database and want to modify the query below, so that when an event date has passed it is no longer shown, so for example if an event was on January 12 2002, it would not show up in the results returned, it would only show the events happen ing from todays date i.e. January 16th. cfset MonthsToDisplay = 2 cfset BeginDate = #Month(now())#/1/#Year(now())# cfset EndDate = #Month(DateAdd(m, MonthsToDisplay,now()))#/#DaysInMonth(DateAdd(m, MonthsToDisplay,now()))#/#Year(DateAdd(m, MonthsToDisplay, now()))# cfquery name=getupcomingevents datasource=events SELECT eventid, eventdate, to_char(eventdate,'') AS eventYear, to_char(eventdate,'MM') AS eventMonth, longtitle, location FROM whatson WHERE trunc(eventdate) BETWEEN TO_DATE('#DateFormat(variables.Begindate,dd/mm/)#','DD/MM/') AND TO_DATE('#DateFormat(variables.Enddate,dd/mm/)#','DD/MM/') AND eventdate = SysDate /cfquery TIA Ian - Original Message - From: Nick de Voil [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 14, 2002 12:04 PM Subject: Re: Coldfusion Intelligent Queries ??? Oracle, right? AND eventdate = SysDate should do it Nick - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 14, 2002 11:48 AM Subject: Coldfusion Intelligent Queries ??? Hi How do I modify my query below, so that when an event date has passed it is no longer shown, so for example if an event was on January 12 2002 , it would not show up in the results returned, it would only show the events happening from todays date i.e. January 14th. How could this feature be implemented into the code below, any ideas would be most appreciated. cfset MonthsToDisplay = 2 cfset BeginDate = #Month(now())#/1/#Year(now())# cfset EndDate = #Month(DateAdd(m, MonthsToDisplay,now()))#/#DaysInMonth(DateAdd(m, MonthsToDisplay,now()))#/#Year(DateAdd(m, MonthsToDisplay, now())) # cfquery name=getupcomingevents datasource=events SELECT eventid, eventdate, to_char(eventdate,'') AS eventYear, to_char(eventdate,'MM') AS eventMonth, longtitle, location FROM whatson WHERE trunc(eventdate) BETWEEN TO_DATE('#DateFormat(variables.Begindate,dd/mm/)#','DD/MM/' ) AND TO_DATE('#DateFormat(variables.Enddate,dd/mm/)#','DD/MM/YYY Y') ORDER BY eventdate asc /cfquery Thanks Ian __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: approach to nested file locations.. menus.. and includes...
You could create mappings on the web server, that way no matter where you are in the directory structure you could reference the specific folder and file that you wanted to go to. e.g. If you create a mapping called folder you could place the following link in your code no matter where you are in the app. a href=/folder/file.cfm Instead of: a href=http://url.com/top_folder/folder/file.cfm or a href../folder/file.cfm -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:38 AM To: CF-Talk Subject: approach to nested file locations.. menus.. and includes... so this has been brought up in part before and I was wondering if anyone had successfully came up with an easy to use solution... like most fusebox-like sites, we utilize a well defined site architecture/naming schema... one of the glaring parts of our universal solution and most others is the header and footer type pieces... in both we have navigation (links) to certain things all is swell if we define this in long full defined server linkage including the img locations ... has anyone come up with any approach that works well no matter where a person is making the call from within your site...?? want to move away from the sub_header design I have been implementing (somewhat lazily) for a while now... interested in hearing approaches others have successfully employed to work around this. -paris __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle 8i and cfstoredproc confusion
You can only call stored PL/SQL procedures from Oracle using CFSTOREDPROC , not stored PL/SQL functions. Also, RETURNCODE has to be no for Oracle. Regards, Joel Parramore -Original Message- From: Eric Gilbert [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 11:42 PM To: CF-Talk Subject: Oracle 8i and cfstoredproc confusion Hi all, I've gotten my self twisted around on the correct way get a res ult set back from an oracle 8i procedure . This is my first real attemp t at this and based the code on what I gathered from other CF-Talk posts of a similar topic. I think the problem is with the procedure, but the resu lt set seems to come back just fine in Oracle SQL*Plus. Any help on this is greatly appreciated. It gets the following message when I run the code in CF5: the error is : ORA-06550: line1, colum 13: PLS-00306: wrong number or types of argumen ts in call to 's_departement_get_all' ORA-06550: line 1, column 7: PL/SQL Statement ignored the CF code is: cfstoredproc procedure = s_departement_get_all dataSource= #request.db.dsn# returnCode = Yes cfprocparam type = Out CFSQLType = CF_SQL_REFCURSOR variable = testingoutvar cfprocresult name = rs1 maxrows=-1 /cfstoredproc and finally the script for creating the sproc: create or replace package types as type cursorType is ref cursor; end; create or replace FUNCTION s_departement_get_all return types.cursorTyp e as l_cursortypes.cursorType begin open l_cursor for select name, date_created from department where date_created sysdate order by name; return l_cursor; end; Thanks in advance, Eric __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: approach to nested file locations.. menus.. and includes...
thanks Chuck.. was considering that approach.. had used that one before as well... Assume extending it to IMG tag references should be seamless as well... Longer code on large pages... but aside from that it should work well I suspect... Even with CFCONTENT :) ? -paris -Original Message- From: Chuck Hergenroeder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 09:27 To: CF-Talk Subject: RE: approach to nested file locations.. menus.. and includes... You could create mappings on the web server, that way no matter where you are in the directory structure you could reference the specific folder and file that you wanted to go to. e.g. If you create a mapping called folder you could place the following link in your code no matter where you are in the app. a href=/folder/file.cfm Instead of: a href=http://url.com/top_folder/folder/file.cfm or a href../folder/file.cfm -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:38 AM To: CF-Talk Subject: approach to nested file locations.. menus.. and includes... so this has been brought up in part before and I was wondering if anyone had successfully came up with an easy to use solution... like most fusebox-like sites, we utilize a well defined site architecture/naming schema... one of the glaring parts of our universal solution and most others is the header and footer type pieces... in both we have navigation (links) to certain things all is swell if we define this in long full defined server linkage including the img locations ... has anyone come up with any approach that works well no matter where a person is making the call from within your site...?? want to move away from the sub_header design I have been implementing (somewhat lazily) for a while now... interested in hearing approaches others have successfully employed to work around this. -paris __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: approach to nested file locations.. menus.. and includes...
It will work on an IMG tag also, as long as you create a web server mapping not a cf mapping in the CFAS. If all your docs are CFML then create a cf mapping in the CFAS for them and a web server mapping for the image directory(s). I have not tried it with CFCONTENT, but would assume it would work with a CF mapping. Regards Chuck -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 9:32 AM To: CF-Talk Subject: RE: approach to nested file locations.. menus.. and includes... thanks Chuck.. was considering that approach.. had used that one before as well... Assume extending it to IMG tag references should be seamless as well... Longer code on large pages... but aside from that it should work well I suspect... Even with CFCONTENT :) ? -paris -Original Message- From: Chuck Hergenroeder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 09:27 To: CF-Talk Subject: RE: approach to nested file locations.. menus.. and includes... You could create mappings on the web server, that way no matter where you are in the directory structure you could reference the specific folder and file that you wanted to go to. e.g. If you create a mapping called folder you could place the following link in your code no matter where you are in the app. a href=/folder/file.cfm Instead of: a href=http://url.com/top_folder/folder/file.cfm or a href../folder/file.cfm -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:38 AM To: CF-Talk Subject: approach to nested file locations.. menus.. and includes... so this has been brought up in part before and I was wondering if anyone had successfully came up with an easy to use solution... like most fusebox-like sites, we utilize a well defined site architecture/naming schema... one of the glaring parts of our universal solution and most others is the header and footer type pieces... in both we have navigation (links) to certain things all is swell if we define this in long full defined server linkage including the img locations ... has anyone come up with any approach that works well no matter where a person is making the call from within your site...?? want to move away from the sub_header design I have been implementing (somewhat lazily) for a while now... interested in hearing approaches others have successfully employed to work around this. -paris __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT? Access union query
i'm having a bit of trouble w/ good sized union query. I'ts a union of 4 queries and i was trying to use Access' Count method to count a subset of the union query, unsuccessfully. i think the problem is with the way i'm using access' Count() method. I'm trying to go Count(IIf([Col1]5,[Col1],0) can i do that? if that's way out of whack what's a good way to create a subset of a union query and count the records? Thanks-Savan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting Service Review
I may be biased but let me say this: Go with a provider who only does hosting. You get better service and the connection doesn't suffer from dial abusers. Also I didn't notice CF hosting. Thanks, Neil [EMAIL PROTECTED] www.hostmysite.com Get your FREE .COM, .NET, .ORG, or .INFO domain name at WWW.HOSTMYSITE.COM! - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 8:50 AM Subject: OT: Hosting Service Review Hi folks, I know the question of hosting has come up in the past, but my question comes at a bit of a different twist. Is anyone on the list familiar with Ascent Networking (http://www.ascent.net) as a hosting service provider? I'm just wondering if I can get some feedback on them. Thanks! Hatton __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: concatenate blank fields SQL and the pesky
Thanks that works!!! I thought about tiring that yesterday but, never did thinking that putting the ';' in the isnull would make it always not null and end up with a '; always. I see that I was wrong. Thanks much! Mark W. Breneman -Macromedia Certified ColdFusion 5 Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:52 AM To: CF-Talk Subject: RE: concatenate blank fields SQL and the pesky SELECT LTrim(Rtrim(IsNull(Author, ' ') + IsNull('; ' + secondAuthor, ' '))) AS Authors FROM table -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: dinsdag 15 januari 2002 22:25 To: CF-Talk Subject: concatenate blank fields SQL and the pesky Ok, I have to concatenate two fields together Author and SecondAuthor. SecondAuthor some times has blank values in it. What I have so far is (thanks Hatton) SELECT LTrim(Rtrim(IsNull(Author, ' ') + '; ' + IsNull(secondAuthor, ' '))) AS Authors FROM table Now the only question is if a book only has one author how do I not have the ; after the Author. Yes, I know I should break the Authors off into a related table but, that is not in the scope of the project. Thanks Mark W. Breneman -Macromedia Certified ColdFusion 5 Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OnRequestEnd.cfm not running
OK. This is weird. I thought OnRequestEnd runs every time a page is called, as long as there is a matching Application.cfm in the app Am I ok so far? I have a form page ... on submission goes to another .cfm page which does some error checking ... if errors are found, it sends the user back to the form cfinclude, and highlights the errors. When I first load the form page ... All the templates that are supposed to run, indeed do so. Including OnRequestEnd.cfm. If there is an error on the page though, and the user gets sent back to the form, the OnRequestEnd does not run, but Application.cfm does. Has anyone ever had this happen? Am I going nuts? Did I do something wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
Yup, I have a very similar thing on one of my sites, except it runs the OnRequestEnd.cfm from the folder above. Annoys the hell out of me. Craig. -Original Message- From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 15:21 To: CF-Talk Subject: OnRequestEnd.cfm not running OK. This is weird. I thought OnRequestEnd runs every time a page is called, as long as there is a matching Application.cfm in the app Am I ok so far? I have a form page ... on submission goes to another .cfm page which does some error checking ... if errors are found, it sends the user back to the form cfinclude, and highlights the errors. When I first load the form page ... All the templates that are supposed to run, indeed do so. Including OnRequestEnd.cfm. If there is an error on the page though, and the user gets sent back to the form, the OnRequestEnd does not run, but Application.cfm does. Has anyone ever had this happen? Am I going nuts? Did I do something wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
Don't you have to actually have a named application using the cfapplication tag? -Original Message- From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 7:21 AM To: CF-Talk Subject: OnRequestEnd.cfm not running OK. This is weird. I thought OnRequestEnd runs every time a page is called, as long as there is a matching Application.cfm in the app Am I ok so far? I have a form page ... on submission goes to another .cfm page which does some error checking ... if errors are found, it sends the user back to the form cfinclude, and highlights the errors. When I first load the form page ... All the templates that are supposed to run, indeed do so. Including OnRequestEnd.cfm. If there is an error on the page though, and the user gets sent back to the form, the OnRequestEnd does not run, but Application.cfm does. Has anyone ever had this happen? Am I going nuts? Did I do something wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
Not sure if this is your problem but the onrequestend.cfm executed will be the one in the same folder as the application.cfm, if its in a different folder then I think it may not be executed. HTH Kola Oyedeji |Web Developer |ekeda elthorne gate |64 high street |pinner |middx |ha55qa t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 15:18 To: CF-Talk Subject: RE: OnRequestEnd.cfm not running Yup, I have a very similar thing on one of my sites, except it runs the OnRequestEnd.cfm from the folder above. Annoys the hell out of me. Craig. -Original Message- From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 15:21 To: CF-Talk Subject: OnRequestEnd.cfm not running OK. This is weird. I thought OnRequestEnd runs every time a page is called, as long as there is a matching Application.cfm in the app Am I ok so far? I have a form page ... on submission goes to another .cfm page which does some error checking ... if errors are found, it sends the user back to the form cfinclude, and highlights the errors. When I first load the form page ... All the templates that are supposed to run, indeed do so. Including OnRequestEnd.cfm. If there is an error on the page though, and the user gets sent back to the form, the OnRequestEnd does not run, but Application.cfm does. Has anyone ever had this happen? Am I going nuts? Did I do something wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OnRequestEnd.cfm not running
I'm not sure if this is the case, but if you're on anything but Windows (the server), filenames are case-sensitive. In other words, the file name should be OnRequestEnd.cfm, not onrequestend.cfm. What version of CF are you running? OnRequestEnd.cfm is only available in 4.5+ If you still can't get it to work, look at cf_sandwich - Original Message - From: Erika L Walker-Arnold [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 9:20 AM Subject: OnRequestEnd.cfm not running OK. This is weird. I thought OnRequestEnd runs every time a page is called, as long as there is a matching Application.cfm in the app Am I ok so far? I have a form page ... on submission goes to another .cfm page which does some error checking ... if errors are found, it sends the user back to the form cfinclude, and highlights the errors. When I first load the form page ... All the templates that are supposed to run, indeed do so. Including OnRequestEnd.cfm. If there is an error on the page though, and the user gets sent back to the form, the OnRequestEnd does not run, but Application.cfm does. Has anyone ever had this happen? Am I going nuts? Did I do something wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and ASP
The mailing lists at 15Seconds are pretty good. - Original Message - From: Tangorre, Michael T. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 9:04 PM Subject: CF and ASP Hello All, I have a question a bit off topic. Does anyone know of a list like this one but for ASP? I need to ask a few questions there to help get this site converted to CF. Thanks, Mike Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
-Original Message- From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:21 AM To: CF-Talk Subject: OnRequestEnd.cfm not running OK. This is weird. I thought OnRequestEnd runs every time a page is called, as long as there is a matching Application.cfm in the app Am I ok so far? I have a form page ... on submission goes to another .cfm page which does some error checking ... if errors are found, it sends the user back to the form cfinclude, and highlights the errors. When I first load the form page ... All the templates that are supposed to run, indeed do so. Including OnRequestEnd.cfm. If there is an error on the page though, and the user gets sent back to the form, the OnRequestEnd does not run, but Application.cfm does. Has anyone ever had this happen? Am I going nuts? Did I do something wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC There are a few things that could be wrong here: Are you using a cflocation if there is an error? If so, OnRequestEnd.cfm won't run before the cflocation takes place. When you say error, do you mean a runtime error? I don't think OnRequestEnd.cfm is processed unless the actual page loads and runs completely. The OnRequestEnd.cfm file is processed in the same directory that the application.cfm file resides, not in the directory the template runs in, unless that directory contains an application.cfm. The remedy in these situations would be to cfinclude the OnRequestEnd.cfm file to make sure it gets processed, one way or the other; before a cflocation, after an error is caught, or at the end of the template if an OnRequestEnd.cfm does not reside in the same directory as the application.cfm that gets processed. Andy __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
Yer, that appears to be the case. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 15:31 To: CF-Talk Subject: RE: OnRequestEnd.cfm not running Not sure if this is your problem but the onrequestend.cfm executed will be the one in the same folder as the application.cfm, if its in a different folder then I think it may not be executed. HTH Kola Oyedeji |Web Developer |ekeda elthorne gate |64 high street |pinner |middx |ha55qa t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 15:18 To: CF-Talk Subject: RE: OnRequestEnd.cfm not running Yup, I have a very similar thing on one of my sites, except it runs the OnRequestEnd.cfm from the folder above. Annoys the hell out of me. Craig. -Original Message- From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 15:21 To: CF-Talk Subject: OnRequestEnd.cfm not running OK. This is weird. I thought OnRequestEnd runs every time a page is called, as long as there is a matching Application.cfm in the app Am I ok so far? I have a form page ... on submission goes to another .cfm page which does some error checking ... if errors are found, it sends the user back to the form cfinclude, and highlights the errors. When I first load the form page ... All the templates that are supposed to run, indeed do so. Including OnRequestEnd.cfm. If there is an error on the page though, and the user gets sent back to the form, the OnRequestEnd does not run, but Application.cfm does. Has anyone ever had this happen? Am I going nuts? Did I do something wrong? - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf and cgi session variables compatibility
thank's Joel, i did that method to insert the asp script that launch the api, (in fact it seems to be a cgi script written in vbscript). but it works. but i have another pb, the api is for an e-business site that make a transaction by card in SSL format. the transaction result is returned in session that i must read with a cgi script (in vbscript). do you know how to read the session values in cfm ? it is the oposite question of the first one (i'm trying resolving this for 4 hours) thank's in advance. lje - Original Message - From: Joel Parramore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 09, 2002 4:18 PM Subject: RE: cf and cgi session variables compatibility Session variables in CF are not automatically passed along to either CGI or ASP scripts. ASP scripts in particular have a Session scope, but that does not connect to CF's Session scope at all. If the script needs any C F session variables, then you need to manually pass them along when your co de calls that script. If you're calling the ASP script using CFHTTP, you c a n pass the session variables along as URL or FORM parameters (COOKIE parameters also, but let's keep it simple). In either case, they'll be available in the ASP script's Request scope. An example using FORM parameters: CF code: CFLOCK ... !--- since we're accessing a shared scope, even for a rea d, we'll need a lock. --- CFSET var1 = session.var1 CFSET var2 = session.var2 /CFLOCK CFHTTP URL=http://www.myservername.com/myscriptname.asp?var1=#var1var 2=# var2# CFHTTPPARAM TYPE=FORMFIELD NAME=var1 VALUE=#URLEncodedFormat(var1)# CFHTTPPARAM TYPE=FORMFIELD NAME=var2 VALUE=#URLEncodedFormat(var2)# /CFHTTP ASP code: % numb1=Request(var1) numb2=Request(var2) .. % Regards, Joel Parramore -Original Message- From: loic jegouzo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 9:35 AM To: CF-Talk Subject: cf and cgi session variables compatibility hello, i have pb with cf session variables. i have created two numeric session variables in cf (the site is in cf) that i need in a cgi script wich launch an api. but these variables seem no t to be recognized by the cgi script. with an asp example that i have there is no pb. in cf i have created session.var1, session.var2 in the cgi script the syntax is % numb1=session(var1) numb2=session(var2) .. % do you know if it's normal (compatibility problem) or if there is 'something' to do ? lje __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Phone App Server
www.voxeo.com www.voicegenie.com www.tellme.com www.heyanita.com From: Duane Boudreau [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Phone App Server Date: Tue, 15 Jan 2002 12:30:43 -0500 Hi All, Does anyone know the url and name of the company that makes the phone app software that interacts with ColdFusion? The company was Voxio or Vexio, or something like that. If anyone was at the 2000 DevCon Jeremy Allaire built/showed a music selection demo of it on stage on the second day. Thanks, Duane _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and ASP
Michael, Try this one http://www.aspmessageboard.com/forum/asp.asp Brian Ferrigno -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 10:04 PM To: CF-Talk Subject: CF and ASP Hello All, I have a question a bit off topic. Does anyone know of a list like this one but for ASP? I need to ask a few questions there to help get this site converted to CF. Thanks, Mike Michael T. Tangorre == Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4== __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Global UUID and Client vars
A couple quick questions: 1. Where and what is the registry key that needs to be modified on a Solaris box to make the CFID generate a Global UUID instead of a sequential number? 2. If CF is upgraded, say from CF 4.01 to 4.5, do the counters that CF keeps track of to generated the sequential CFID get reset? Where is the last number assigned stored? Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Phone App Server
I have a hockey league app running on tellme.com To access your Extension: 1. Call Tellme at 1-800-555-Tell 2. At the Tellme Menu prompt, dial 1-25483 basically an ASP generates VXML (or other hybrid definition) that is requested by a voice server. the voice server acts as the browser agent on behalf of the caller. Text to Speech and Voice recognition are key/cool elements of the voice interface. In my sample app - I publish recent results, tonights games, upcoming games, (you could get into interactive driving instructions), and I have a voice game reports option (which you could password protect) I post a WAV file to my server and save in a directory, because CF is managing the interactions I can do anything I want with the sound file. I intented to also collect game information like scores etc, but I haven't had time. I may work on a sport registration site - web, wap, voice, developer XML based API (or do they call that SOAP?) for third party developers. And voice would be key. Expensive though. 25K for a server with 4 ports. tellme.com has some free services - long distance from Canada. :( Eric From: Shawn Grover [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Phone App Server Date: Tue, 15 Jan 2002 12:50:35 -0700 Took a look at their web site. didn't see any details relating to CF. How does it work with CF??? tied into a web page? back end processing of the voice messages? web presentation of the recorded messages and managment items??? Just curious - we have an in-house developed phone system, it might be interesting to see how this relates... Shawn Grover -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 11:36 AM To: CF-Talk Subject: RE: Phone App Server So close. Thx Howie. Duane -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:18 PM To: CF-Talk Subject: Re: Phone App Server www.voxeo.com Howie - Original Message - From: Duane Boudreau [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 12:30 PM Subject: Phone App Server Hi All, Does anyone know the url and name of the company that makes the phone app software that interacts with ColdFusion? The company was Voxio or Vexio, or something like that. If anyone was at the 2000 DevCon Jeremy Allaire built/showed a music selection demo of it on stage on the second day. Thanks, Duane __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and ASP
Do they offer an email list? Imagine if CF-Talk was web-based only - Original Message - From: Brian Ferrigno [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 10:01 AM Subject: RE: CF and ASP Michael, Try this one http://www.aspmessageboard.com/forum/asp.asp Brian Ferrigno -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 10:04 PM To: CF-Talk Subject: CF and ASP Hello All, I have a question a bit off topic. Does anyone know of a list like this one but for ASP? I need to ask a few questions there to help get this site converted to CF. Thanks, Mike Michael T. Tangorre == Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4== __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Global UUID and Client vars
1. Where and what is the registry key that needs to be modified on a Solaris box to make the CFID generate a Global UUID instead of a sequential number? I've never set that up on Solaris, but I'd guess it's in the same place as in the Windows registry. The Solaris registry itself is, of course, in a different place. With CF 4.5.x, it's typically the file /opt/coldfusion/registry/cf.registry (it's just a text file). Note that, to change it, you have to stop CF, change the file, then restart CF. The registry key itself is: HKLM\Software\Allaire\ColdFusion\CurrentVersion\Clients and the value you want to create there is: UuidToken, 1. 2. If CF is upgraded, say from CF 4.01 to 4.5, do the counters that CF keeps track of to generated the sequential CFID get reset? Where is the last number assigned stored? I have absolutely no idea on either of these. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Global UUID and Client vars
This doesn't really answer your question, but it seems like you're counting on unique CFID's - seems like I read somewhere that this is not something that you can count on. (though UUID's are supposedly globally unique) - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 10:01 AM Subject: Global UUID and Client vars A couple quick questions: 1. Where and what is the registry key that needs to be modified on a Solaris box to make the CFID generate a Global UUID instead of a sequential number? 2. If CF is upgraded, say from CF 4.01 to 4.5, do the counters that CF keeps track of to generated the sequential CFID get reset? Where is the last number assigned stored? Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: ASP.NET
Noticed that ASP.NET is finally gold. Pretty interesting technology (or powerful, depending on your attitude toward MS) I'm a big fan of the more solutions I can offer, the better, but even if you're 100% committed to CF, I'd recommend checking it out (You can't make professional arguments against competing technologies if you don't understand it - and anti-MS FUD and soundbytes don't qualify as real knowledge) __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
udf in a complex custom tag
Hi! I am trying to declare an UDF in a custom tag: CFIF ThisTag.ExecutionMode Is start cfscript function myfunc() { return true; } /cfscript .. etc. /CFIF This throws The routine test has been declared twice in different templates. If the tag has no end tag, no error is thrown; I need an end tag, though, because there are child tags. Any ideas? Thanks in advance Alexander __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Traffic (OT)
Off-Topic warning. Have any of you server admin's out there noticed how messed up the Internet has been over the last 48 hours? I am having an impossible time over here in Utah. Our T-1 connection is routed through San Jose (MAE-West), and the latency is sky high for the second day now. I can't reach anything, either through dial a separate dial-up, or our LAN (T-1). I am getting time-outs all over the place, even in Chicago. It seems to be worst at the big level-3 providers. Can anyone shed some light on what's going on here? My co-workers are demanding exact answers, and I just don't have anything to tell them at this point. Help. Nick __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Global UUID and Client vars
Billy, Actually, unless I'm reading what you wrote the wrong way, everybody who uses SESSION or CLIENT variables is counting on unique CFIDs (and CFTOKENS for that matter). That's how the user gets identified. Am I wrong? Dave. Original Message Follows From: Billy Cravens [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Global UUID and Client vars Date: Wed, 16 Jan 2002 11:04:27 -0600 This doesn't really answer your question, but it seems like you're counting on unique CFID's - seems like I read somewhere that this is not something that you can count on. (though UUID's are supposedly globally unique) - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 10:01 AM Subject: Global UUID and Client vars A couple quick questions: 1. Where and what is the registry key that needs to be modified on a Solaris box to make the CFID generate a Global UUID instead of a sequential number? 2. If CF is upgraded, say from CF 4.01 to 4.5, do the counters that CF keeps track of to generated the sequential CFID get reset? Where is the last number assigned stored? Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Traffic (OT)
Everything looks fine from here...of course we just turned up our 2nd full T3 too :) This site may be of some help though. http://www.internetpulse.com/ - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:34 PM Subject: Traffic (OT) Off-Topic warning. Have any of you server admin's out there noticed how messed up the Internet has been over the last 48 hours? I am having an impossible time over here in Utah. Our T-1 connection is routed through San Jose (MAE-West), and the latency is sky high for the second day now. I can't reach anything, either through dial a separate dial-up, or our LAN (T-1). I am getting time-outs all over the place, even in Chicago. It seems to be worst at the big level-3 providers. Can anyone shed some light on what's going on here? My co-workers are demanding exact answers, and I just don't have anything to tell them at this point. Help. Nick __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Traffic (OT)
I have noticed a lot of Nimda scans on our network recently. Perhaps a new strain is going around. Last time nimda attacked there was a huge slow down. Neil - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:34 PM Subject: Traffic (OT) Off-Topic warning. Have any of you server admin's out there noticed how messed up the Internet has been over the last 48 hours? I am having an impossible time over here in Utah. Our T-1 connection is routed through San Jose (MAE-West), and the latency is sky high for the second day now. I can't reach anything, either through dial a separate dial-up, or our LAN (T-1). I am getting time-outs all over the place, even in Chicago. It seems to be worst at the big level-3 providers. Can anyone shed some light on what's going on here? My co-workers are demanding exact answers, and I just don't have anything to tell them at this point. Help. Nick __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Traffic (OT)
Thanks, Neil! Any little bit of info helps. Nick - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 10:55 AM Subject: Re: Traffic (OT) I have noticed a lot of Nimda scans on our network recently. Perhaps a new strain is going around. Last time nimda attacked there was a huge slow down. Neil - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:34 PM Subject: Traffic (OT) Off-Topic warning. Have any of you server admin's out there noticed how messed up the Internet has been over the last 48 hours? I am having an impossible time over here in Utah. Our T-1 connection is routed through San Jose (MAE-West), and the latency is sky high for the second day now. I can't reach anything, either through dial a separate dial-up, or our LAN (T-1). I am getting time-outs all over the place, even in Chicago. It seems to be worst at the big level-3 providers. Can anyone shed some light on what's going on here? My co-workers are demanding exact answers, and I just don't have anything to tell them at this point. Help. Nick __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Traffic (OT)
John...Thanks for the URL! Nick - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 10:54 AM Subject: Re: Traffic (OT) Everything looks fine from here...of course we just turned up our 2nd full T3 too :) This site may be of some help though. http://www.internetpulse.com/ - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:34 PM Subject: Traffic (OT) Off-Topic warning. Have any of you server admin's out there noticed how messed up the Internet has been over the last 48 hours? I am having an impossible time over here in Utah. Our T-1 connection is routed through San Jose (MAE-West), and the latency is sky high for the second day now. I can't reach anything, either through dial a separate dial-up, or our LAN (T-1). I am getting time-outs all over the place, even in Chicago. It seems to be worst at the big level-3 providers. Can anyone shed some light on what's going on here? My co-workers are demanding exact answers, and I just don't have anything to tell them at this point. Help. Nick __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Traffic (OT)
I've seen a rash of bad DNS issues over the last few weeks. Sites I expect to get to are being thrown as not existing or the like. At 12:55 PM 1/16/02, you wrote: I have noticed a lot of Nimda scans on our network recently. Perhaps a new strain is going around. Last time nimda attacked there was a huge slow down. Neil - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:34 PM Subject: Traffic (OT) Off-Topic warning. Have any of you server admin's out there noticed how messed up the Internet has been over the last 48 hours? I am having an impossible time over here in Utah. Our T-1 connection is routed through San Jose (MAE-West), and the latency is sky high for the second day now. I can't reach anything, either through dial a separate dial-up, or our LAN (T-1). I am getting time-outs all over the place, even in Chicago. It seems to be worst at the big level-3 providers. Can anyone shed some light on what's going on here? My co-workers are demanding exact answers, and I just don't have anything to tell them at this point. Help. Nick __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
Thanks for the posts, and to answer some of the q's ... My OnRequestEnd.cfm resides in the same folder as my Application.cfm, spelled exactly that way even though the site runs on IIS 5 on a Win 2K box .. I like to watch file case in the off-chance the app ever gets moved to a Unix box. The Application and OnRequestEnd reside in the outermost folder of the app, and I only go about two folders deep at any time. This works perfectly at moment ... I also have a cfapplication designated in Application.cfm. I have a form.cfm page and a formSubmit.cfm page. These sit one folder down. When you go to form.cfm, OnRequestEnd runs fine. When you submit the form.cfm, and formSubmit.cfm checks for data validity ... phone number digits, blank fields, email validity, that kind of error. If there is something wrong, I send them back to the form.cfm via a cfinclude NOT a cflocation ... so that's not the problem. It only happens in this situation. I gues a quick fix would be to cfinclude the OnRequestEnd after the original include if there's an error, but it just seems to me that this is wrong, as Application runs again, why doesn't OnRequestEnd? Any further ideas? Thanks muchly! - Erika L. Walker-Arnold, VP, RUWebby, LLC - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - |-Original Message- |From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] | |Not sure if this is your problem but the onrequestend.cfm |executed will be |the one in the same folder as the application.cfm, if its in a different |folder then I think it may not be executed. | __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Global UUID and Client vars
Assuming non-UUID's: Theoretically, yes. The CFID is only 4 digits long, and the CFTOKEN is 8 digits long. As a combination, this works out to about 100 billion unique values. If you have more sessions than that, I'm sure you have bigger problems! However, I'm one of those mathematical geeks that will only use a value for uniqueness if you can guarantee *pure* uniqueness. Of course, by themselves, CFID and CFTOKEN would have a higher probability of duplicate values, since you can only have 10,000 different CFID values and 100,000,000 different CFTOKEN's. - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:45 AM Subject: Re: Global UUID and Client vars Billy, Actually, unless I'm reading what you wrote the wrong way, everybody who uses SESSION or CLIENT variables is counting on unique CFIDs (and CFTOKENS for that matter). That's how the user gets identified. Am I wrong? Dave. Original Message Follows From: Billy Cravens [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Global UUID and Client vars Date: Wed, 16 Jan 2002 11:04:27 -0600 This doesn't really answer your question, but it seems like you're counting on unique CFID's - seems like I read somewhere that this is not something that you can count on. (though UUID's are supposedly globally unique) - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 10:01 AM Subject: Global UUID and Client vars A couple quick questions: 1. Where and what is the registry key that needs to be modified on a Solaris box to make the CFID generate a Global UUID instead of a sequential number? 2. If CF is upgraded, say from CF 4.01 to 4.5, do the counters that CF keeps track of to generated the sequential CFID get reset? Where is the last number assigned stored? Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and ASP
You can try the 15Seconds list, but beware... Make sure you've read through the VBScript documentation and searched on MSDN/Technet to answer your problems. Most of the time they will reference a KB article and that's it. They're not as friendly as we are here. You can also ping me off-list. I've done a significant amount of ASP development and porting ASP to CF. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 8:04 PM To: CF-Talk Subject: CF and ASP Hello All, I have a question a bit off topic. Does anyone know of a list like this one but for ASP? I need to ask a few questions there to help get this site converted to CF. Thanks, Mike Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Multiple sites...
When you're trying to cfinclude templates, it won't include from the proper directory, without creating mappings in the ColdFusion administrator, and then using a variable to store that mapping. Never had this problem, I always use relative paths, e.g. cfinclude template=../../myFile.cfm - would this work for you? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
Best thing to do in that situation is use relative urls (../includes/blah.cfm) in your CFINCLUDEs. That way, as long as your directory structure stays the same, your site should work perfectly when you just copy it over. Another thing you can do is set a variable in your application.cfm, like: CFSET imageDir = D:\wwwroot\mysite\images\ Then, in the pages where you access this directory, do it using #imageDir#. When you move the site, just change the once instance of each path defined like this, and voila. This method has problems, though, because if you're on a shared server, you have to figure out what those absolute paths are, by using some getBaseTemplatePath() functions. Kevin Langevin Web Guy In Charge UsWebGuys 954-327-5780 [EMAIL PROTECTED] -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:17 PM To: CF-Talk Subject: Multiple sites... Hi, I'm new on the list and to ColdFusion in general, so take it easy on me. I would like to have two (or more) sites on my NT box, one for staging, and one for production. For example, I'd like to have a website (stage.livingscriptures.com) that I do all my pre-production work in, and then when I'm finished, simply copy everything over to a different directory, that would be my production site (www.livingscriptures.com). This is very simple to do with say, ASP, but I have found difficulty in getting this to work with ColdFusion. When you're trying to cfinclude templates, it won't include from the proper directory, without creating mappings in the ColdFusion administrator, and then using a variable to store that mapping. My co-worker introduced my to ColdFusion, and I think it's a GREAT product, but the inability to do this has frustrated me. Maybe I'm approaching this the wrong way. I'd really appreciate it if someone could help me with this. Thanks! ---Les Buchanan Newbie ColdFusion Developer __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and ASP
Thanks Jeff.. I appreciate the willingneed to help. -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:11 PM To: CF-Talk Subject: RE: CF and ASP You can try the 15Seconds list, but beware... Make sure you've read through the VBScript documentation and searched on MSDN/Technet to answer your problems. Most of the time they will reference a KB article and that's it. They're not as friendly as we are here. You can also ping me off-list. I've done a significant amount of ASP development and porting ASP to CF. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 8:04 PM To: CF-Talk Subject: CF and ASP Hello All, I have a question a bit off topic. Does anyone know of a list like this one but for ASP? I need to ask a few questions there to help get this site converted to CF. Thanks, Mike Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Regular expression help
I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASP.NET
do you have any info on resources where one can learn more about NET and how to implement it? in the dark about .NET ~~ Stephenie -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:12 PM To: CF-Talk Subject: OT: ASP.NET Noticed that ASP.NET is finally gold. Pretty interesting technology (or powerful, depending on your attitude toward MS) I'm a big fan of the more solutions I can offer, the better, but even if you're 100% committed to CF, I'd recommend checking it out (You can't make professional arguments against competing technologies if you don't understand it - and anti-MS FUD and soundbytes don't qualify as real knowledge) _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
Hi Les, I do all my mapping stuff in the application.cfm file. That way, when you move things over, you just change a few lines in the application.cfm file. I set imagepath, DSN, homepath, and a few others... Makes things go real smnooth when moving over. Mike -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:17 PM To: CF-Talk Subject: Multiple sites... Hi, I'm new on the list and to ColdFusion in general, so take it easy on me. I would like to have two (or more) sites on my NT box, one for staging, and one for production. For example, I'd like to have a website (stage.livingscriptures.com) that I do all my pre-production work in, and then when I'm finished, simply copy everything over to a different directory, that would be my production site (www.livingscriptures.com). This is very simple to do with say, ASP, but I have found difficulty in getting this to work with ColdFusion. When you're trying to cfinclude templates, it won't include from the proper directory, without creating mappings in the ColdFusion administrator, and then using a variable to store that mapping. My co-worker introduced my to ColdFusion, and I think it's a GREAT product, but the inability to do this has frustrated me. Maybe I'm approaching this the wrong way. I'd really appreciate it if someone could help me with this. Thanks! ---Les Buchanan Newbie ColdFusion Developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FYI: AbleCommerce checkout rounding bug
The other day I found an obscure bug in the way AbleCommerce sums pricing for totals and subtotals. In my case, it exhibited itself when I discounted an ite m using a 10% discount. This caused products to have three decimal places in the discounted price ($14.95 discounted 10% is $13.455). The ExtPrice field in OrderOptions thinks the price is $13.455 (which technically it is) but it is rounded to $13.46 when it is displayed in the shopping cart. Now consider wh en you add another discounted book to the shopping cart. They both get rounded up to $13.46. The subtotal line should read $26.92. However, the subtotal line displays $26.91. Technically, this is correct since it is adding 13.455 + 13.455. While this penny might not seem like much, I for one am not going to try telling that to the accounting department. :) If you purchased the source version as we did, you can change the following in showcott.cfm in the basket. This may not be the best coding solution, but it works. Original SubTotal query: cfquery name = subtotal datasource = #ACBMainDS# SELECT Sum (OrderDetails.ExtPrice) AS SubtotalPrice FROMOrderDetails WHERE Order_ID = #Showcont.Order_ID# AND Product_ID 10/cfquery New SubTotal query: cfquery name = tempSubtotal datasource = #ACBMainDS# SELECT OrderDetails.ExtPrice FROMOrderDetails WHERE Order_ID = #Showcont.Order_ID# AND Product_ID 10/cfquery cfset SubtotalPrice = 0 cfloop query=tempSubtotal cfif SubtotalPrice eq 0cfset SubtotalPrice= (#evaluate((round(#tempSubtotal.ExtPrice#*100))/100)#) cfelse cfset SubtotalPrice = (#evaluate(SubtotalPrice + ((round(#tempSubtotal.ExtPrice#*100))/100))#) /cfif /cfloop Use the same basic idea for the Total query (leave the original Total query in there just to total the weight). Finally, change Subtotal.SubtotalPrice to SubtotalPrice and Total.TotalPrice to TotalPrice on the lines which actually output the subtotal and total. Good Luck! Jeff Langevin Appalachian Mountain Club MIS Department 5 Joy Street, Boston, Massachusetts 02108 617-523-0655 x302http://www.outdoors.org If one advances confidently in the direction of his dreams, and endeavors to live the life which he has imagined, he will meet with success unexpected in common hours. -- Henry David Thoreau __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASP.NET
http://www.411asp.net/ -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:43 PM To: CF-Talk Subject: RE: ASP.NET do you have any info on resources where one can learn more about NET and how to implement it? in the dark about .NET ~~ Stephenie -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:12 PM To: CF-Talk Subject: OT: ASP.NET Noticed that ASP.NET is finally gold. Pretty interesting technology (or powerful, depending on your attitude toward MS) I'm a big fan of the more solutions I can offer, the better, but even if you're 100% committed to CF, I'd recommend checking it out (You can't make professional arguments against competing technologies if you don't understand it - and anti-MS FUD and soundbytes don't qualify as real knowledge) _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: udf in a complex custom tag
This is a known issue - and there may even be a KB for it. In you want to define a UDF in a custom tag that is used in begin/end notation, you must place the UDF in another file and cfinclude it. That should work for you. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Alexander just me Apartsev [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:33 PM To: CF-Talk Subject: udf in a complex custom tag Hi! I am trying to declare an UDF in a custom tag: CFIF ThisTag.ExecutionMode Is start cfscript function myfunc() { return true; } /cfscript .. etc. /CFIF This throws The routine test has been declared twice in different templates. If the tag has no end tag, no error is thrown; I need an end tag, though, because there are child tags. Any ideas? Thanks in advance Alexander __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Traffic (OT)
thank goodness. i thought it was just us. we had to move our DNS servers a few weeks ago (we moved offices) and things have been FUBAR ever since. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:00 PM To: CF-Talk Subject: Re: Traffic (OT) I've seen a rash of bad DNS issues over the last few weeks. Sites I expect to get to are being thrown as not existing or the like. At 12:55 PM 1/16/02, you wrote: I have noticed a lot of Nimda scans on our network recently. Perhaps a new strain is going around. Last time nimda attacked there was a huge slow down. Neil - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:34 PM Subject: Traffic (OT) Off-Topic warning. Have any of you server admin's out there noticed how messed up the Internet has been over the last 48 hours? I am having an impossible time over here in Utah. Our T-1 connection is routed through San Jose (MAE-West), and the latency is sky high for the second day now. I can't reach anything, either through dial a separate dial-up, or our LAN (T-1). I am getting time-outs all over the place, even in Chicago. It seems to be worst at the big level-3 providers. Can anyone shed some light on what's going on here? My co-workers are demanding exact answers, and I just don't have anything to tell them at this point. Help. Nick __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
Hmmm... Thanks for all the help everyone... I guess I'll just have to decide the lesser of the two evils. =) I'm surprised that ColdFusion server doesn't have a way to handle multiple sites. Does anyone know if there is going to be any support for this in future editions? Thanks again everyone! ---Les Buchanan -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 11:32 AM To: CF-Talk Subject: RE: Multiple sites... Hi Les, I do all my mapping stuff in the application.cfm file. That way, when you move things over, you just change a few lines in the application.cfm file. I set imagepath, DSN, homepath, and a few others... Makes things go real smnooth when moving over. Mike -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:17 PM To: CF-Talk Subject: Multiple sites... Hi, I'm new on the list and to ColdFusion in general, so take it easy on me. I would like to have two (or more) sites on my NT box, one for staging, and one for production. For example, I'd like to have a website (stage.livingscriptures.com) that I do all my pre-production work in, and then when I'm finished, simply copy everything over to a different directory, that would be my production site (www.livingscriptures.com). This is very simple to do with say, ASP, but I have found difficulty in getting this to work with ColdFusion. When you're trying to cfinclude templates, it won't include from the proper directory, without creating mappings in the ColdFusion administrator, and then using a variable to store that mapping. My co-worker introduced my to ColdFusion, and I think it's a GREAT product, but the inability to do this has frustrated me. Maybe I'm approaching this the wrong way. I'd really appreciate it if someone could help me with this. Thanks! ---Les Buchanan Newbie ColdFusion Developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASP.NET
Try http://asp.net/... it's the mother of all asp.net sites. -Ron -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:43 PM To: CF-Talk Subject: RE: ASP.NET do you have any info on resources where one can learn more about NET and how to implement it? in the dark about .NET ~~ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ASP.NET
Most of the ASP sites are chock full of ASP.net info. Off the top of my head: asp101.com learnasp.com 15seconds.com Also, Wrox has written a crapload of books covering ASP.NET and the .NET framework (I was fortunate to be a technical reviewer on a few of them) Most of the MS developer mags are pretty deep into .NET (MSDN mag, Visual Studio mag). Plus there's a new .NET mag by the same ppl who do the Visual Studio mag. Note that Microsoft has futher blurred the line between web and traditional development - since you're developing against the entire CLR in a real language (VB or C#, not VBScript), you really can't learn ASP.NET without learning the framework (though ASP.NET does have features specific to it - sessions, databinding, etc) - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:42 PM Subject: RE: ASP.NET do you have any info on resources where one can learn more about NET and how to implement it? in the dark about .NET ~~ Stephenie -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:12 PM To: CF-Talk Subject: OT: ASP.NET Noticed that ASP.NET is finally gold. Pretty interesting technology (or powerful, depending on your attitude toward MS) I'm a big fan of the more solutions I can offer, the better, but even if you're 100% committed to CF, I'd recommend checking it out (You can't make professional arguments against competing technologies if you don't understand it - and anti-MS FUD and soundbytes don't qualify as real knowledge) _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
Les, I can say that CF does a great job of running multiple sites. The key, that has already been mentioned is to use relative paths for your CFINCLUDEs. We have a dozen IIS sites and essentially 50 others sites in subdirectories under one of those and they all work absolutely fine without using CF mappings, though it is there if you wanted it. I don't think using relative paths is the lesser of an evil. It's simply how CF does it's thing when you need to run more than one site. As far as future support, I haven't seen anything added or planned for adding in future releases, I guess because most people seem to get it working with the methods already available. Just my $0.02 t Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:52 AM To: CF-Talk Subject: RE: Multiple sites... Hmmm... Thanks for all the help everyone... I guess I'll just have to decide the lesser of the two evils. =) I'm surprised that ColdFusion server doesn't have a way to handle multiple sites. Does anyone know if there is going to be any support for this in future editions? Thanks again everyone! ---Les Buchanan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular expression help
I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? I'm having problems finding ways of detecting/converting case using CF regexes too (doing tags to lowercase for XHTML markup). From what I've gathered, Perl regexes can do this but CF can't. Bah. There is a Perl-compatible regex parsing extension tag for CF Server at http://www.rixsoft.com/ColdFusion/CFX/PCRegEx/, but I've not bothered with this. I'm plodding along with loops and substring extraction fiddliness. Of course all I'm doing is LCase() to certain substrings. Shame there's no Capitalise() CF function. There is something similar at http://www.cflib.org/udf.cfm?ID=9, might be of use to you. You could LCase() the whole string, then run it through this UDF. Imagine you could stick a workaround in for hyphenated names too! Let me know if you find any regex solution for dealing with case like this... - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression help
try CFIF REFind(^[A-Z][a-z]+, VARIABLENAME) it's capitalized! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:46 PM To: CF-Talk Subject: Regular expression help I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
I can't agree that it does a great job. It's adequate, but it would it would be better if there could be multiple instances of the CF engine so, for instance, one application's badly-locked code didn't hurt another application. It would also permit tuning the server settings for the needs of each application. For instance, Les might like his development site to do full checking for shared-scope locks while his production site does none. -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:11 PM To: CF-Talk Subject: RE: Multiple sites... Les, I can say that CF does a great job of running multiple sites. The key, that has already been mentioned is to use relative paths for your CFINCLUDEs. We have a dozen IIS sites and essentially 50 others sites in subdirectories under one of those and they all work absolutely fine without using CF mappings, though it is there if you wanted it. I don't think using relative paths is the lesser of an evil. It's simply how CF does it's thing when you need to run more than one site. As far as future support, I haven't seen anything added or planned for adding in future releases, I guess because most people seem to get it working with the methods already available. Just my $0.02 t Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:52 AM To: CF-Talk Subject: RE: Multiple sites... Hmmm... Thanks for all the help everyone... I guess I'll just have to decide the lesser of the two evils. =) I'm surprised that ColdFusion server doesn't have a way to handle multiple sites. Does anyone know if there is going to be any support for this in future editions? Thanks again everyone! ---Les Buchanan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular expression help
That definately will not do it. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:20 AM Subject: RE: Regular expression help try CFIF REFind(^[A-Z][a-z]+, VARIABLENAME) it's capitalized! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:46 PM To: CF-Talk Subject: Regular expression help I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
Coming in neo -Original Message- From: Herbener, Martin - School Information Technology [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 11:24 AM To: CF-Talk Subject: RE: Multiple sites... I can't agree that it does a great job. It's adequate, but it would it would be better if there could be multiple instances of the CF engine so, for instance, one application's badly-locked code didn't hurt another application. It would also permit tuning the server settings for the needs of each application. For instance, Les might like his development site to do full checking for shared-scope locks while his production site does none. -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:11 PM To: CF-Talk Subject: RE: Multiple sites... Les, I can say that CF does a great job of running multiple sites. The key, that has already been mentioned is to use relative paths for your CFINCLUDEs. We have a dozen IIS sites and essentially 50 others sites in subdirectories under one of those and they all work absolutely fine without using CF mappings, though it is there if you wanted it. I don't think using relative paths is the lesser of an evil. It's simply how CF does it's thing when you need to run more than one site. As far as future support, I haven't seen anything added or planned for adding in future releases, I guess because most people seem to get it working with the methods already available. Just my $0.02 t Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:52 AM To: CF-Talk Subject: RE: Multiple sites... Hmmm... Thanks for all the help everyone... I guess I'll just have to decide the lesser of the two evils. =) I'm surprised that ColdFusion server doesn't have a way to handle multiple sites. Does anyone know if there is going to be any support for this in future editions? Thanks again everyone! ---Les Buchanan _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression help
um, did you try it? it works for me. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:43 PM To: CF-Talk Subject: Re: Regular expression help That definately will not do it. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:20 AM Subject: RE: Regular expression help try CFIF REFind(^[A-Z][a-z]+, VARIABLENAME) it's capitalized! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:46 PM To: CF-Talk Subject: Regular expression help I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Multiple sites...
Ditto...I use relative paths always. I've built a handy tag to build the relative path back to the root of the site from anby directory. I just call the tag in the application.cfm file in whatever directory I'm working in. That gives me a RelativePath var to use in my includes...works like a charm. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 10:21 AM Subject: Re: Multiple sites... When you're trying to cfinclude templates, it won't include from the proper directory, without creating mappings in the ColdFusion administrator, and then using a variable to store that mapping. Never had this problem, I always use relative paths, e.g. cfinclude template=../../myFile.cfm - would this work for you? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OnRequestEnd.cfm not running
OnRequestEnd should only run in the folder where the calling template is. So, though your form page should traverse up a level to find the Application.cfm, it should not ever be finding the OnRequestEnd.cfm. I think that's the way it's supposed to work anyway. So, the error is in the form.cfm FINDING the OnRequestEnd file to begin with - not in it not finding it when there's an error. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular expression help
All refind does is find the starting position of a string. IE: CFSET test = REFind(^[A-Z][a-z]+, hello world) CFOUTPUT #test# /CFOUTPUT returns 0 I need it to change hello world to Hello World There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:43 AM Subject: Re: Regular expression help That definately will not do it. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:20 AM Subject: RE: Regular expression help try CFIF REFind(^[A-Z][a-z]+, VARIABLENAME) it's capitalized! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:46 PM To: CF-Talk Subject: Regular expression help I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
Actually, that is not correct. OnRequestEnd.cfm will be executed if it exists in the same directory as the Application.cfm that was executed. --- Ben -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:52 PM To: CF-Talk Subject: Re: OnRequestEnd.cfm not running OnRequestEnd should only run in the folder where the calling template is. So, though your form page should traverse up a level to find the Application.cfm, it should not ever be finding the OnRequestEnd.cfm. I think that's the way it's supposed to work anyway. So, the error is in the form.cfm FINDING the OnRequestEnd file to begin with - not in it not finding it when there's an error. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression help
ah. you said Make sure that it's capitalized correctly in your email. i wrote a detection script. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:00 PM To: CF-Talk Subject: Re: Regular expression help All refind does is find the starting position of a string. IE: CFSET test = REFind(^[A-Z][a-z]+, hello world) CFOUTPUT #test# /CFOUTPUT returns 0 I need it to change hello world to Hello World There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:43 AM Subject: Re: Regular expression help That definately will not do it. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:20 AM Subject: RE: Regular expression help try CFIF REFind(^[A-Z][a-z]+, VARIABLENAME) it's capitalized! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:46 PM To: CF-Talk Subject: Regular expression help I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular expression help
check cflib.org for a UDF that will cap the first letter of every word in a stringI think Raymond Camden wrote it..but don't quote me on that ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:00 PM Subject: Re: Regular expression help All refind does is find the starting position of a string. IE: CFSET test = REFind(^[A-Z][a-z]+, hello world) CFOUTPUT #test# /CFOUTPUT returns 0 I need it to change hello world to Hello World There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:43 AM Subject: Re: Regular expression help That definately will not do it. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:20 AM Subject: RE: Regular expression help try CFIF REFind(^[A-Z][a-z]+, VARIABLENAME) it's capitalized! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:46 PM To: CF-Talk Subject: Regular expression help I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression help
Use the UDF: capFirstTitle() http://www.cflib.org/udf.cfm?ID=116 For your purpose, CF RegExp won't do it as well as what Ed Hodder implemented with his UDF. But, FYI, REFind() and REFindNoCase() can return subexpressions. Example: Variables.sttREFind = REFind([[:graph:]]+, Variables.strName, 1, true); If (Variables.sttREFind.pos[1] GT 0) { Variables.strFirstWord = Mid(Variables.strName, Variables.sttREFind.pos[1], Variables.sttREFind.len[1]); } else { // nothing found Variables.strFirstWord = ; } See how messy this can get? The UDF has a much more elegant solution, in my opinion. :) Of course, RegExp has its uses. In your case, it isn't the most optimal solution. James. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:00 PM To: CF-Talk Subject: Re: Regular expression help All refind does is find the starting position of a string. IE: CFSET test = REFind(^[A-Z][a-z]+, hello world) CFOUTPUT #test# /CFOUTPUT returns 0 I need it to change hello world to Hello World There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:43 AM Subject: Re: Regular expression help That definately will not do it. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:20 AM Subject: RE: Regular expression help try CFIF REFind(^[A-Z][a-z]+, VARIABLENAME) it's capitalized! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:46 PM To: CF-Talk Subject: Regular expression help I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help with resolving a variable...
Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
It just seems odd to me that I'd have to do it that way... I guess relative paths isn't going to be a problem, thinking about it now... that's the method I'll use. Thanks guys! ---Les -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 12:11 PM To: CF-Talk Subject: RE: Multiple sites... Les, I can say that CF does a great job of running multiple sites. The key, that has already been mentioned is to use relative paths for your CFINCLUDEs. We have a dozen IIS sites and essentially 50 others sites in subdirectories under one of those and they all work absolutely fine without using CF mappings, though it is there if you wanted it. I don't think using relative paths is the lesser of an evil. It's simply how CF does it's thing when you need to run more than one site. As far as future support, I haven't seen anything added or planned for adding in future releases, I guess because most people seem to get it working with the methods already available. Just my $0.02 t Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:52 AM To: CF-Talk Subject: RE: Multiple sites... Hmmm... Thanks for all the help everyone... I guess I'll just have to decide the lesser of the two evils. =) I'm surprised that ColdFusion server doesn't have a way to handle multiple sites. Does anyone know if there is going to be any support for this in future editions? Thanks again everyone! ---Les Buchanan __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
Sweet... thanks for the info Mark! ---Les -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:29 PM To: CF-Talk Subject: RE: Multiple sites... Coming in neo -Original Message- From: Herbener, Martin - School Information Technology [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 11:24 AM To: CF-Talk Subject: RE: Multiple sites... I can't agree that it does a great job. It's adequate, but it would it would be better if there could be multiple instances of the CF engine so, for instance, one application's badly-locked code didn't hurt another application. It would also permit tuning the server settings for the needs of each application. For instance, Les might like his development site to do full checking for shared-scope locks while his production site does none. -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:11 PM To: CF-Talk Subject: RE: Multiple sites... Les, I can say that CF does a great job of running multiple sites. The key, that has already been mentioned is to use relative paths for your CFINCLUDEs. We have a dozen IIS sites and essentially 50 others sites in subdirectories under one of those and they all work absolutely fine without using CF mappings, though it is there if you wanted it. I don't think using relative paths is the lesser of an evil. It's simply how CF does it's thing when you need to run more than one site. As far as future support, I haven't seen anything added or planned for adding in future releases, I guess because most people seem to get it working with the methods already available. Just my $0.02 t Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 10:52 AM To: CF-Talk Subject: RE: Multiple sites... Hmmm... Thanks for all the help everyone... I guess I'll just have to decide the lesser of the two evils. =) I'm surprised that ColdFusion server doesn't have a way to handle multiple sites. Does anyone know if there is going to be any support for this in future editions? Thanks again everyone! ---Les Buchanan _ _ Why Share? Dedicated Win 2000 Server 7 PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation 7 $99/Month 7 Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression help
Here's a UDF I may not be the most eloquent but it does work. I used it to do tile casing. why my string is title ;o) CFscript //Changes a String to Title case Function TitleCase(title){ title = trim(title); //Caps first letter of string and Lower cases rest //for standardization Leadchar = UCase(RemoveChars(title,2,len(title))); title = RemoveChars(title, 1, 1); title = LCase(title); title = Leadchar title; start = 1; //loops through string word by word to Cap first letter //uses space to tell when new word starts While (start LT len(title)){ place = REFindNoCase( , title ,start ); //place has to be less than length of string and //greater than 0 (no more words) if (place LT len(title) and place GT 0){ Frontpart = Removechars(title,place,len(title)); backpart = RemoveChars(title, 1,place); //if last part is one letter like a Middle initial if (len(backpart) gt 1){ nextchar = RemoveChars(backpart,2,len(backpart)); backpart = RemoveChars(backpart,1,1); nextchar = Ucase(nextchar); title = frontpartnextchar backpart; start = place +1; } else{ backpart = Ucase(backpart); title = frontpartbackpart; start = place +1; } } else{ start = len(title); } } return title; } __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
oh dammit that's right I knew there was a solution cuz I had this problem well over a year ago just couldn't remember. Thanks Bryan! :) -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular expression help
There was a /CFSCRIPT at the bottom, must have gotten cut off. -Original Message- From: Bruce, Rodney (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:05 PM To: CF-Talk Subject: RE: Regular expression help Here's a UDF I may not be the most eloquent but it does work. I used it to do tile casing. why my string is title ;o) CFscript //Changes a String to Title case Function TitleCase(title){ title = trim(title); //Caps first letter of string and Lower cases rest //for standardization Leadchar = UCase(RemoveChars(title,2,len(title))); title = RemoveChars(title, 1, 1); title = LCase(title); title = Leadchar title; start = 1; //loops through string word by word to Cap first letter //uses space to tell when new word starts While (start LT len(title)){ place = REFindNoCase( , title ,start ); //place has to be less than length of string and //greater than 0 (no more words) if (place LT len(title) and place GT 0){ Frontpart= Removechars(title,place,len(title)); backpart = RemoveChars(title, 1,place); //if last part is one letter like a Middle initial if (len(backpart) gt 1){ nextchar= RemoveChars(backpart,2,len(backpart));backpart= RemoveChars(backpart,1,1); nextchar = Ucase(nextchar); title = frontpart nextchar backpart; start = place +1; } else{ backpart = Ucase(backpart); title = frontpart backpart; start = place +1; } } else{ start = len(title); } } return title; } __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular expression help
Douglas Brown wrote: I have a field that will be populated with a first name and a last name, what I want to do is make sure that the first letter of the first last name is uppercase and that all others are lower case. Could someone help in a reg expression that will do this? It is pretty easy with normal functions (see http://www.cflib.org/) in CF. I don't think it is possible purely with regular expressions. But even if I could tell you I wouldn't because I prefer te be able spell my own name correctly ;) Jochem van Dieten __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
Ok wait still confused... Evaluate(WHAT?) For instance Evaluate(surname_Comm) doesn't work nor does Evaluate(#surname#_Comm) Sorry just not sure how to display it properly... Was using a CFSET tag like CFSET surnamecomm = Evaluate(#surname#_Comm) That gives an error CFSET surnamecomm = Evaluate(#surname#_Comm) Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm I am probably missing something minor... -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
I believe it would be one of these CFSET surnamecomm = #Evaluate(surname_#Comm#)# or CFSET surnamecomm = #Evaluate(#surname#_Comm)# -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:09 PM To: CF-Talk Subject: RE: Help with resolving a variable... Ok wait still confused... Evaluate(WHAT?) For instance Evaluate(surname_Comm) doesn't work nor does Evaluate(#surname#_Comm) Sorry just not sure how to display it properly... Was using a CFSET tag like CFSET surnamecomm = Evaluate(#surname#_Comm) That gives an error CFSET surnamecomm = Evaluate(#surname#_Comm) Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm I am probably missing something minor... -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
cfset surname=jerry cfset jerry_comm=2 cfset result=evaluate(#surname#_comm) cfoutput#result#/cfoutput (Should write 2) Jerry [EMAIL PROTECTED] 01/16/02 03:09PM Ok wait still confused... Evaluate(WHAT?) For instance Evaluate(surname_Comm) doesn't work nor does Evaluate(#surname#_Comm) Sorry just not sure how to display it properly... Was using a CFSET tag like CFSET surnamecomm = Evaluate(#surname#_Comm) That gives an error CFSET surnamecomm = Evaluate(#surname#_Comm) Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm I am probably missing something minor... -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories . Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=Y ou forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=Y ou forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=Y ou forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Multiple sites...
For the most part, this isn't something you'd do in your application server - you do it in your web server (for example, custom headers in IIS). However, if you don't have access to the web server, you can do it in code. It's no more difficult to do in CF than it is in any other language. For example, if you use something where you funnel all requests through one file (perhaps Fusebox, but not necessarily) and you have each site's file in it's own directory, something like this in the application.cfm should do the trick: cfset subDomain = listGetAt(cgi.server_name,1,.) cfswitch expression=#subDomain# cfcase value=www cfset dir = production /cfcase cfcase value=beta cfset dir = staging /cfcase /cfswitch cfinclude template=#dir#/app.cfm cfinclude template=#dir#/index.cfm How would you normally do this in ASP? ColdFusion makes this really easy to do because it executes the application.cfm on every request - allowing you to put the server name checking in the application.cfm, and not in your application (plus you don't have to remember includes on multiple files) - Original Message - From: Les Buchanan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:51 PM Subject: RE: Multiple sites... Hmmm... Thanks for all the help everyone... I guess I'll just have to decide the lesser of the two evils. =) I'm surprised that ColdFusion server doesn't have a way to handle multiple sites. Does anyone know if there is going to be any support for this in future editions? Thanks again everyone! ---Les Buchanan -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 11:32 AM To: CF-Talk Subject: RE: Multiple sites... Hi Les, I do all my mapping stuff in the application.cfm file. That way, when you move things over, you just change a few lines in the application.cfm file. I set imagepath, DSN, homepath, and a few others... Makes things go real smnooth when moving over. Mike -Original Message- From: Les Buchanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:17 PM To: CF-Talk Subject: Multiple sites... Hi, I'm new on the list and to ColdFusion in general, so take it easy on me. I would like to have two (or more) sites on my NT box, one for staging, and one for production. For example, I'd like to have a website (stage.livingscriptures.com) that I do all my pre-production work in, and then when I'm finished, simply copy everything over to a different directory, that would be my production site (www.livingscriptures.com). This is very simple to do with say, ASP, but I have found difficulty in getting this to work with ColdFusion. When you're trying to cfinclude templates, it won't include from the proper directory, without creating mappings in the ColdFusion administrator, and then using a variable to store that mapping. My co-worker introduced my to ColdFusion, and I think it's a GREAT product, but the inability to do this has frustrated me. Maybe I'm approaching this the wrong way. I'd really appreciate it if someone could help me with this. Thanks! ---Les Buchanan Newbie ColdFusion Developer __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
Ok I figured it out, ignore my last message. Thanks again! -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help with resolving a variable...
cfset TempVar= #surname# _Comm Then in your INSERT: #Evaluate(TempVar)# Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 12:09 PM Subject: RE: Help with resolving a variable... Ok wait still confused... Evaluate(WHAT?) For instance Evaluate(surname_Comm) doesn't work nor does Evaluate(#surname#_Comm) Sorry just not sure how to display it properly... Was using a CFSET tag like CFSET surnamecomm = Evaluate(#surname#_Comm) That gives an error CFSET surnamecomm = Evaluate(#surname#_Comm) Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm I am probably missing something minor... -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
actually what I did was CFSET surnamecomm = #Surname#_Comm Then in the insert statement for the values I did '#Evaluate(surnamecomm)#' -Original Message- From: Bruce, Rodney (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:18 PM To: CF-Talk Subject: RE: Help with resolving a variable... I believe it would be one of these CFSET surnamecomm = #Evaluate(surname_#Comm#)# or CFSET surnamecomm = #Evaluate(#surname#_Comm)# -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:09 PM To: CF-Talk Subject: RE: Help with resolving a variable... Ok wait still confused... Evaluate(WHAT?) For instance Evaluate(surname_Comm) doesn't work nor does Evaluate(#surname#_Comm) Sorry just not sure how to display it properly... Was using a CFSET tag like CFSET surnamecomm = Evaluate(#surname#_Comm) That gives an error CFSET surnamecomm = Evaluate(#surname#_Comm) Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm I am probably missing something minor... -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:03 PM To: CF-Talk Subject: Re: Help with resolving a variable... Evaluate() Use that to find the value of the vars you are dynamically building the names for Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:46 AM Subject: Help with resolving a variable... Ok we have a survey where we have to rate each person in 3 categories. We have 50 people to rate. I set a comma delimited list of names and then create a loop to create 3 questions for each person, so we can rate each of the 50 people in the 3 categories. Looks like this: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 cfinput type=radio name=#trim(Surname)#_Comm value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Comm value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Comm value=3 style=background: 9DCBFF input name=#trim(Surname)#_Comm_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b cfinput type=radio name=#trim(Surname)#_Cust value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Cust value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Cust value=3 style=background: 9DCBFF input name=#trim(Surname)#_Cust_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bCustomer Service/b. cfinput type=radio name=#trim(Surname)#_Extr value=1 style=background: white cfinput type=radio name=#trim(Surname)#_Extr value=2 style=background: BBE9FF cfinput type=radio name=#trim(Surname)#_Extr value=3 style=background: 9DCBFFcfinput type=radio name=#trim(Surname)#_Extr value=4 style=background: 5785FF input name=#trim(Surname)#_Extr_required type=hidden value=You forgot to rate b#trim(Surname)#/b for bExtra Effort/b. /CFLOOP It creates this part fine and as you can see for each category there are 3 radio buttons all w/ the same name. So if the surname for the first person were smith the first set of radio buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr It does this for all 50 people, works great. Here is the problem when I hit submit I want to loop through to resolve all the values rather than have to type up 200 separate values in the insert statement. However if I want to loop through on the insert page similarly to how I am looping through on the form I can't resolve the variable. Because if I pass a value named smith_comm I can't loop through to get the value of smith_comm... Meaning an insert statement like: cfloop index=Surname list=#ChunkLast# cfset ChunkFirstIndex = ChunkFirstIndex +1 CFQUERY datasource=SC2002 INSERT INTO SCORES (#trim(Surname)#_Comm) VALUES ('#trim(surname)#_comm') (obviously that won't work because it will insert a value of smith_comm instead of say 3 How do I find the value of smith_comm by looping through? Any ideas?? /CFQUERY __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple sites...
On 1/16/02, Tyler M. Fitch penned: I can say that CF does a great job of running multiple sites. The key, that has already been mentioned is to use relative paths for your CFINCLUDEs. We have a dozen IIS sites and essentially 50 others sites in subdirectories under one of those and they all work absolutely fine without using CF mappings, though it is there if you wanted it. I hear that. My shopping cart application has dozens of cfincluded files and it works fine whether you drop it into an NT or Linux server. cfinclude template=includes/filename.cfm or cfinclude template=../includes/filename.cfm Works every time. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Looking for suggestions for a Virtual Museum
One of the sites I volunteer my time for is considering putting their museum online (a virtual museum). I'm looking for ideas on how to accomplish this. When they say virtual museum they simply mean providing access to some/most/all of the museum resources online. We do not necessarily need a VRML environment (and I'd rather avoid the extra complexity). So basically a search engine to their resources. I have considered taking the content management route (meaning they upload Word/PDF/Image/etc. files, and it gets mapped into the site automatically), but am not yet convinced this is the best solution. Most of the museum artifacts are old magazines, pilot and maintenance manuals and such - well suited for content management I think. But I'm not sure if a CM system would be able to handle our particular needs for searching/sorting/storage. (I'd roll my own if we go this route, so that's not really a strong argument). Unfortunately, they only have maybe 1% (if that) of their resources in digital format thus far. Anyone want to offer ideas on how to approach this project?? It would be great to hear from someone who has but museum resources online before. If it helps, here is their current website: www.arrow2000.ab.ca This site is undergoing massive revisions (using the powers of Cold Fusion of course... grins) and will likely integrate with the virtual museum concept at a later date. Thanks for any feedback. I think this project is a bit bigger than I thought when I first agreed to take it on, but hey, I gotta learn how to handle a project of this size sooner or later... __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Parser
Ian, I just had to do this the other day pulling an html based article and stripping the html off to send as text only as well as keeping the format. If WDDX is not what you want to use, follow up on the REReplaceNoCase function that Jochem was talking about. Here is a look at the code that d id it. !--- START OF HTML STRIPPING --- cfset resultspacket = REReplaceNoCase(resultspacket,#chr(9)#,,ALL ) cfset resultspacket = REReplaceNoCase(resultspacket,#chr(13)#,,AL L) cfset resultspacket = REReplaceNoCase(resultspacket,#chr(10)#,,AL L)cfset resultspacket= REReplaceNoCase(resultspacket,br,#chr(13)##chr(10)#,ALL) cfset resultspacket = REReplaceNoCase(resultspacket,[^.]+,,ALL ) !--- END OF HTML STRIPPING --- Basicly I remove any breaks, tabs, and or new lines then I replace the br with a carrage retirn and a new line, then I striped the HTML out. This c ode worked out great I hope you can use it. Ernie Pena Sr Coldfusion Developer University of Texas M.D. Anderson - Original Message - From: Neil Clark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 6:24 AM Subject: RE: HTML Parser Serialise it as a WDDX packet and store the packet.. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Multiple sites...
Martin said: It's adequate, but it would it would be better if there could be multiple instances of the CF engine so, for instance, one application's badly-locked code didn't hurt another application Deanna says: Neo is supposed to have this capability, as was demonstrated at Dev Con. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OnRequestEnd.cfm not running
Oops. My bad. But, while we're pointint out mistakes, Ben, has anyone mentioned your incorrect syntax on list functions in the CF 5.0 Language Reference? *grin* Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OnRequestEnd.cfm not running
Ouch... biting the hand that feeds you g -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:03 PM To: CF-Talk Subject: Re: OnRequestEnd.cfm not running Oops. My bad. But, while we're pointint out mistakes, Ben, has anyone mentioned your incorrect syntax on list functions in the CF 5.0 Language Reference? *grin* Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists