RE: Evaluate an Array
cfloop list=#PNResponse# index=pair delimiters= cfset #ListFirst(pair,'=')# = ListRest(pair,'=') /cfloop Make sure that the var names are suitable for CF. Maybe it's better to create a structure cfset stResponse = StructNew() cfloop list=#PNResponse# index=pair delimiters= cfset stResponse[ListFirst(pair,'=')] = ListRest(pair,'=') /cfloop Pascal -Oorspronkelijk bericht- Van: Robert Redpath [mailto:[EMAIL PROTECTED] Verzonden: do 13/11/2003 21:25 Aan: CF-Talk CC: Onderwerp: Evaluate an Array In a credit card processing app I am working on I get a response back from the credit card processor in the following form: PNResponse = RESULT=23PNREF=V50035748010RESPMSG=Invalid account number [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINCLUDE within CFLOOP not working
This works perfectly on a few of my apps (in CF 5, but I don't know why it would break in CFMX). Make sure the file ReportName'.CFM' exists. Use FileExists or try/catch around your include. Also, don't use # when it's not neccesary: cfif ReportName NEQ cfset theReport = ReportName'.CFM' -Oorspronkelijk bericht- Van: Sam Komolafe [mailto:[EMAIL PROTECTED] Verzonden: do 13/11/2003 20:44 Aan: CF-Talk CC: Onderwerp: CFINCLUDE within CFLOOP not working Hi, How do I dynamically include files using CFINCLUDE within a CFLOOP statement: This does NOT WORK: cfloop index=ReportName list =#variables.ALLReports# delimiters = , cfif #ReportName# NEQ cfset theReport = #ReportName#'.CFM' cfinclude template=#theReport#br /cfif /cfloop Help will be appreciated. Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINCLUDE within CFLOOP not working
What is wrong with that line? He has unneaded # in there, but that isn't wrong. is the concatenation operator in CF, but not always in sql (can be , +, || and maybe others depending on the db). Pascal -Oorspronkelijk bericht- Van: Janine Jakim [mailto:[EMAIL PROTECTED] Verzonden: do 13/11/2003 21:07 Aan: CF-Talk CC: Onderwerp: RE: CFINCLUDE within CFLOOP not working My guess there's something wrong with this line cfset theReport = #ReportName#'.CFM' This isn't a database command so you don't need a to concatonate the 2 together. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sleepy CF
It might to do with the CF templates being compiled. After a template has been amended (or after CF has been restarted on the server) CF needs to recompile the template, hence why it can be much slower on the first 'hit' than the subsequent hits. This was a bit of a problem for doing development with the first version of CFMX, but I thought that 6.1 had speeded up the compiling process. HTH Alex -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 21:27 To: CF-Talk Subject: Sleepy CF I've got a 6.1 box on the LAN and it takes long time to get the first page after I haven't hit the site in a while, the following pages spool much faster. I haven't nailed down the threshold for this behavior, but is there anything I should look at? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Project / Task Manager Collaboration
Sorry for the insane delay - if you'd caught my frantic emails this past week you hopefully understand much of the delay- had to basically rebuild my main web server (with 50 domains, 30 databases)... At least now I'm running CF MX 6.1 finally! Anyhow, over the next couple days I'll work to get my task management tool onto a site where everyone can mess with it and I'll also start up a mailing list for us.So far there's five of us wanting to give it a go! Just to let you know, I have used this component on projects valued at up to $500,000 (www.lawroom.com) and it's done really well by me so far.I'd love to see it out in the open source community as a truly robust solution! Alan At 03:29 AM 10/31/03, you wrote: Hi, I'd be interested in looking at that! /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.nohttp://www.grida.no - | -Original Message- | From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED] | Sent: Friday, October 31, 2003 05:25 | To: CF-Talk | Subject: Project / Task Manager Collaboration | | | Don't recall who on the list was interested.I've got a | Project / Task | manager | that I'm ready to make available in a collaborative | open-source initiative. | | If you're interested let me know.We'll coordinate. | | -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINCLUDE within CFLOOP not working
Not true, dynamic includes worked in CF4.5/5 (and probably in CF4, but we can't verify) and they still work in CFMX. We just tested. Pascal -Oorspronkelijk bericht- Van: Schuster, Steven [mailto:[EMAIL PROTECTED] Verzonden: do 13/11/2003 21:08 Aan: CF-Talk CC: Onderwerp: RE: CFINCLUDE within CFLOOP not working Page processing will not do dynamic includes because the code has to compile. It's complicated to explain but it has to do with the order in which the page is rendered from both the web server and the cold fusion server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
Haven't checked around for a while, but if I remember correctly -- there are no XHTML compliant ones out there. If I had a project that required something like this I would go with a simple textarea and allow the user to use UBB syntax (or similar) I think. /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] | Sent: Friday, November 14, 2003 00:39 | To: CF-Talk | Subject: RE: Users want to format text | | | why dont u do it in flash? | or use a flash editor and i hope he could copy and paste it | into the right | place | this one is fantastic | http://www.joshdura.com/archives/000163.php ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
Did massimo not do a pretty near XHTML version of a formatted text area? Can't google it but sure he did -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 14 November 2003 11:07 To: CF-Talk Subject: RE: Users want to format text Haven't checked around for a while, but if I remember correctly -- there are no XHTML compliant ones out there. If I had a project that required something like this I would go with a simple textarea and allow the user to use UBB syntax (or similar) I think. /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] | Sent: Friday, November 14, 2003 00:39 | To: CF-Talk | Subject: RE: Users want to format text | | | why dont u do it in flash? | or use a flash editor and i hope he could copy and paste it | into the right | place | this one is fantastic | http://www.joshdura.com/archives/000163.php ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
What do you mean store it in a scope and then cache it? How? --Original Message Text--- From: Raymond Camden Date: Thu, 13 Nov 2003 11:42:56 -0600 The result of cfdirectory is a query. You can store it in scope you want and cache it. If you want to store it into a db, you need to convert it to a string first, which you can do with WDDX, or just save one column. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Users want to format text
[EMAIL PROTECTED] wrote in message Did massimo not do a pretty near XHTML version of a formatted text area? Yes, I did, I focused on outputting clean code removing instead of adding features (no tables for example). Usually it's available from the italian CFUG website, right now the server is moving and the whole stuff is offline, feel free to send me an email if you need a copy quickly Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
There shouldn't be any need to store anything. Schedule a template to run every day at 1 minute past midnight. Have that template do a cfdirectory to list the content of the directory. Then do a QofQ of the dirlist to get all the files with a datelastmodified that was in the previous day. Email that QofQ to the person that needs to be informed. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Generators
Why don't you create the query in the GUI tools in Access, and then cutnpaste them to your CF code (with minor modifications). I often do that, to test that they work find. - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Brad Roberts [mailto:[EMAIL PROTECTED] | Sent: Thursday, November 13, 2003 18:34 | To: CF-Talk | Subject: SQL Generators | | | Anyone know of software (desktop or CF based), that will generate SQL | (select, insert, update, etc.), by simply pointing to an | Access database? | Generating cfqueryparam's would be a bonus. | | -Brad | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Com/asp/ldap maybe?
Hello I have the following line in an asp script: GetObject(IIS:// Application(Server) /W3SVC) To connect to iis to get some details from it. Is there any way of doing the same in coldfusion? Would prefer to do it natively as opposed to cfhttping an asp script. Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
I think ray means something like cfdirectory ... name=qDir cfset application.qDir = qDir It is then stored in the application scope and available as long as the application doesn't time-out or you alter the var. Don't forget to lock if you are not on CFMX. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 12:55 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY What do you mean store it in a scope and then cache it? How? --Original Message Text--- From: Raymond Camden Date: Thu, 13 Nov 2003 11:42:56 -0600 The result of cfdirectory is a query. You can store it in scope you want and cache it. If you want to store it into a db, you need to convert it to a string first, which you can do with WDDX, or just save one column. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Better method for counting records?
Hi all, I've got a main cfloop looping through a set of records - say 15 at a time - and within that loop I've got 3 SQL queries performing a count on how many associated records there are for that particular record in the main loop. Kind of like a forum index page to give how many threads, posts etc there are for each forum. i.e. (rough code to give you an idea of what I mean): cfquery name=mainquery select * from tablemain /cfquery cfloop query=mainquery startrow=1 endrow=15 td#SectionName#/td cfquery name=countquery1 select count(case_id) As ThisCount1 from table1 where x = '#mainquery.SectionName#' /cfquery td#countquery1.ThisCount1#/td cfquery name=countquery2 select count(case_id) As ThisCount2 from table2 where x = '#mainquery.SectionName#' /cfquery td#countquery2.ThisCount2#/td cfquery name=countquery3 select count(case_id) As ThisCount3 from table3 where x = '#mainquery.SectionName#' /cfquery td#countquery3.ThisCount3#/td /cfloop My question is, is there a more efficient method for doing this kind of thing? As the tables I am accessing have 1,000s of rows - possibly millions - the page takes a significant amount of time finish processing. I could remove the record counts altogether, but it's preferable for it to remain. Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.0 on Red Hat ES 3.0 install errors
We've seen the first error, and a TechNote for the issue is currently going through the review process. It shouldn't affect the installation process though. The second error isn't expected however. Is it possible you don't have enough disk space in /tmp for the install? If it wasn't able to extract all the files, you could see an error like this. 450MB is the amount of free space needed for the installation. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro5.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro5.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro6.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro6.htm -Original Message- From: Eric Parker [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 8:43 PM To: CF-Talk Subject: CFMX 6.0 on Red Hat ES 3.0 install errors Hello, I am trying to install CFMX on Red Hat ES 3.0 I get the following error message: [EMAIL PROTECTED] data]# ./coldfusion-60-linux-en.bin Preparing to install... tail: `-1' option is obsolete; use `-n 1' Try `tail --help' for more information. ./coldfusion-60-linux-en.bin: line 328: [: `)' expected, found -z WARNING! The amount of /tmp disk space required and/or available could not be determined.The installation will be attempted anyway. Extracting the JRE from the installer archive... Unpacking the JRE... Extracting the installation resources from the installer archive... Configuring the installer for this system's environment... Launching installer... head: `-1' option is obsolete; use `-n 1' Try `head --help' for more information. /tmp/install.dir.3579/Linux/resource/jre/bin/i386/native_threads/java: error while loading shared libraries: libjvm.so: cannot open shared object file: No such file or directory [EMAIL PROTECTED] data]# any help would be greatly appreciated. Eric _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Com/asp/ldap maybe?
Ryan Mitchell said: I have the following line in an asp script: GetObject(IIS:// Application(Server) /W3SVC) To connect to iis to get some details from it. Is there any way of doing the same in coldfusion? Would prefer to do it natively as opposed to cfhttping an asp script. I don't think you can do it without going through COM or some executable. I use mdutil.exe (Option pack or Support Tools) called with cfexecute myself. Using a command line tool from CF can be a bit hackish, but it allows for a uniform codebase when I am logged in through OpenSSH and I only have a command line. Syntax will be something like: mdutil enum W3CSVC/1/ and you can drill down from there. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons? --Original Message Text--- From: Pascal Peters Date: Fri, 14 Nov 2003 13:36:40 +0100 I think ray means something like cfdirectory ... name=qDir cfset application.qDir = qDir It is then stored in the application scope and available as long as the application doesn't time-out or you alter the var. Don't forget to lock if you are not on CFMX. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 12:55 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY What do you mean store it in a scope and then cache it? How? --Original Message Text--- From: Raymond Camden Date: Thu, 13 Nov 2003 11:42:56 -0600 The result of cfdirectory is a query. You can store it in scope you want and cache it. If you want to store it into a db, you need to convert it to a string first, which you can do with WDDX, or just save one column. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
When sending a message through CFMail
Is the cfmailpart tag required if I know I'm only going to send the message as plain text? Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF4.5, CFHTTP, SSL.... anybody been able to get it to work?
Yeah sorry, diff timezone... matt I'm sure you've thought of this, but you remembered to specify the port matt value, right? It's been tried with proxyPort and proxyServer in the cfhttp tag and doesn't seem to make any diff We can browse to the script matt As I recall, cfhttp was pretty screwed up in early 4.5 releases, and got matt a lot of attention in the service packs.You're up to .1sp2 on that 4.5 matt box, right? It's not really a machine under my control, more helping out another dept... Thing is we can get it to work on the CF4.5 Dev box without issue, it's just the CF4.5 Prod box that is keeling over systems say there are no rules in the DMZ (both servers in same DMZ) that would stop it, the other dept say they have no other config settings that I can't think about that would stop this from working on the Prod box grrr and it's friday Cheers for the reply -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Better method for counting records?
cfquery name=mainquery select * from tablemain /cfquery cfloop query=mainquery startrow=1 endrow=15 cfquery name=countquery1 select count(case_id) As ThisCount1 from table1 where x = '#mainquery.SectionName#' /cfquery cfquery name=countquery2 select count(case_id) As ThisCount2 from table2 where x = '#mainquery.SectionName#' /cfquery cfquery name=countquery3 select count(case_id) As ThisCount3 from table3 where x = '#mainquery.SectionName#' /cfquery /cfloop SELECT tm.SectionName, count(t1.case_id) AS count1, count(t2.case_id) AS count2, count(t3.case_id) AS count3 FROM tablemain tm INNER JOIN table1 t1 ON tm.SectionName = t1.x INNER JOIN table2 t2 ON tm.SectionName = t2.x INNER JOIN table3 t3 ON tm.SectionName = t3.x GROUP BY tm.SectionName Whether this is actually faster depends on indexes and how smart your DBMS is. It might be more efficient to split it in 3 queries, one for each of the table you are joining against. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Better method for counting records?
try this: cfquery name=countquery1 select count(case_id) As ThisCount1 from table1 left outer join tablemain on tablemain.sectionname = table1.x group by sectionname order by sectionname /cfquery cfquery name=countquery2 select count(case_id) As ThisCount2 from table2 left outer join tablemain on tablemain.sectionname = table1.x group by sectionname order by sectionname /cfquery cfquery name=countquery3 select count(case_id) As ThisCount3 from table2 left outer join tablemain on tablemain.sectionname = table1.x group by sectionname order by sectionname /cfquery cfoutput query=countquery1 #countquery1.thiscount1[currentrow]# #countquery2.thiscount2[currentrow]# #countquery3.thiscount3[currentrow]# /cfoutput --- [EMAIL PROTECTED] wrote: Hi all, I've got a main cfloop looping through a set of records - say 15 at a time - and within that loop I've got 3 SQL queries performing a count on how many associated records there are for that particular record in the main loop. Kind of like a forum index page to give how many threads, posts etc there are for each forum. i.e. (rough code to give you an idea of what I mean): cfquery name=mainquery select * from tablemain /cfquery cfloop query=mainquery startrow=1 endrow=15 td#SectionName#/td cfquery name=countquery1 select count(case_id) As ThisCount1 from table1 where x = '#mainquery.SectionName#' /cfquery td#countquery1.ThisCount1#/td cfquery name=countquery2 select count(case_id) As ThisCount2 from table2 where x = '#mainquery.SectionName#' /cfquery td#countquery2.ThisCount2#/td cfquery name=countquery3 select count(case_id) As ThisCount3 from table3 where x = '#mainquery.SectionName#' /cfquery td#countquery3.ThisCount3#/td /cfloop My question is, is there a more efficient method for doing this kind of thing? As the tables I am accessing have 1,000s of rows - possibly millions - the page takes a significant amount of time finish processing. I could remove the record counts altogether, but it's preferable for it to remain. Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Better method for counting records?
Try avoiding queries in loops. You can do the query before the loop using group by and in cfquery name=countquery1 select count(case_id) As ThisCount1, x from table1 where x IN (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#SectionNameList# list=yes) GROUP BY x /cfquery You have to build your SectionNameList first from your main query. You can store the results in a structure to easily display later cfset stCounter1 = StructNew() cfloop query=countquery1 cfset stCounter1[countquery1.x] = countquery1.ThisCount1 /cfloop If the counts don't change according to the user, you may consider storing them in the main table to savea query. When you add or delete an item, update the count in the main table. This could save a lot of time on display. -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 13:41 Aan: CF-Talk CC: Onderwerp: Better method for counting records? Hi all, I've got a main cfloop looping through a set of records - say 15 at a time - and within that loop I've got 3 SQL queries performing a count on how many associated records there are for that particular record in the main loop. Kind of like a forum index page to give how many threads, posts etc there are for each forum. i.e. (rough code to give you an idea of what I mean): cfquery name=mainquery select * from tablemain /cfquery cfloop query=mainquery startrow=1 endrow=15 td#SectionName#/td cfquery name=countquery1 select count(case_id) As ThisCount1 from table1 where x = '#mainquery.SectionName#' /cfquery td#countquery1.ThisCount1#/td cfquery name=countquery2 select count(case_id) As ThisCount2 from table2 where x = '#mainquery.SectionName#' /cfquery td#countquery2.ThisCount2#/td cfquery name=countquery3 select count(case_id) As ThisCount3 from table3 where x = '#mainquery.SectionName#' /cfquery td#countquery3.ThisCount3#/td /cfloop My question is, is there a more efficient method for doing this kind of thing? As the tables I am accessing have 1,000s of rows - possibly millions - the page takes a significant amount of time finish processing. I could remove the record counts altogether, but it's preferable for it to remain. Cheers, Rob _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
Depends on what you need: SESSION: 1 user, 1 application, short timeout APPLICATION: All users, 1 application, longer timeout SERVER: All users, all applications, no timeout (not recommended to write in this scope) All these shared scopes are destroyed if the CFServer is restarted. All need locking before CFMX. In CFMX, only lock to avoid race conditions. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 13:52 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
I see. So I have a web interface that will be accessed by 50+ users. A treeview listing of directories allowing editing/deleteing files etc. So I should be using an APPLICATION scope then? Currently I have all SESSION scopes. --Original Message Text--- From: Pascal Peters Date: Fri, 14 Nov 2003 14:06:24 +0100 Depends on what you need: SESSION: 1 user, 1 application, short timeout APPLICATION: All users, 1 application, longer timeout SERVER: All users, all applications, no timeout (not recommended to write in this scope) All these shared scopes are destroyed if the CFServer is restarted. All need locking before CFMX. In CFMX, only lock to avoid race conditions. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 13:52 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
Forgot to ask...why not use a SERVER scope. Why is it not recommended to write to this scope? Why have it then? --Original Message Text--- From: Pascal Peters Date: Fri, 14 Nov 2003 14:06:24 +0100 Depends on what you need: SESSION: 1 user, 1 application, short timeout APPLICATION: All users, 1 application, longer timeout SERVER: All users, all applications, no timeout (not recommended to write in this scope) All these shared scopes are destroyed if the CFServer is restarted. All need locking before CFMX. In CFMX, only lock to avoid race conditions. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 13:52 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Com/asp/ldap maybe?
I have the following line in an asp script: GetObject(IIS:// Application(Server) /W3SVC) To connect to iis to get some details from it. Is there any way of doing the same in coldfusion? Would prefer to do it natively as opposed to cfhttping an asp script. You can't easily use ADSI (which is what this is) directly from CF - even with CF 5. What I've done before is to write COM wrappers for ADSI functionality in Windows Script Components, and called those. If you're using CFMX, you might find better solutions by searching for ADSI and Java. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
There is some default info in the server scope. I'm not sure about CFMX, but in CF5 you couldn't delete server variables. So they would exist untill you restarted the server. How often do you need a var in ALL your apps, for ALL your users, ALL the time? -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 14:13 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY Forgot to ask...why not use a SERVER scope. Why is it not recommended to write to this scope? Why have it then? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT - Win 2000 boot
In NT 4.0 I was able to edit the boot.ini file and change the bootup menu. How does one do this in Windows 2000? I don't see a boot.ini file and can't find any reference to changing it in the Control Panel. Thx. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
If the directory listing is the same for all users, you can store it in the application scope. Don't forget to refresh the variable if you add/delete/rename a file. You can only store it in the session scope if users can only see their own files. Otherwise you would get in trouble if two users are logged in and one of them deletes a file. How would the other user be aware of that? The file would still exist in his session var. If you are pre-CFMX, you have to be carefull not to single-thread your application using the application scope in the Application.cfm -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 14:11 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY I see. So I have a web interface that will be accessed by 50+ users. A treeview listing of directories allowing editing/deleteing files etc. So I should be using an APPLICATION scope then? Currently I have all SESSION scopes. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cookies...
Hi Dave: ASP application write in cookies variables without any trouble. And yes in ASP and CF u can write/read cookies as ASP: Response.Cookies.(User).nick=hassan CF MX CFCookie name=user.nick value=hassan Regards -- M.Sc. Hassan Arteaga Rodrguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
--Original Message Text--- From: Pascal Peters Date: Fri, 14 Nov 2003 14:51:45 +0100 If the directory listing is the same for all users, you can store it in the application scope. Directory listings would change. Not all users would be accessing the same data in the same directories. Can I still use an APPLICATION scope? Don't forget to refresh the variable if you add/delete/rename a file. You can only store it in the session scope if users can only see their own files. Otherwise you would get in trouble if two users are logged in and one of them deletes a file. How would the other user be aware of that? The file would still exist in his session var. If you are pre-CFMX, Yes...CF5 you have to be carefull not to single-thread your application using the application scope in the Application.cfm I'm not sure what you mean by that. Could you give an example? -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 14:11 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY I see. So I have a web interface that will be accessed by 50+ users. A treeview listing of directories allowing editing/deleteing files etc. So I should be using an APPLICATION scope then? Currently I have all SESSION scopes. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Manually clearing CF cache
Can I manually delete the files i the cache folder without screwing anything up? CF won't recompile a template I've changed, so the website keeps seeing the previous, now incorrect file. -- Austin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Com/asp/ldap maybe?
Aaah java, should have thought of that! Thanks for pointing me in the right direction :) On 14/11/03 1:45 pm, Dave Watts [EMAIL PROTECTED] wrote: I have the following line in an asp script: GetObject(IIS:// Application(Server) /W3SVC) To connect to iis to get some details from it. Is there any way of doing the same in coldfusion? Would prefer to do it natively as opposed to cfhttping an asp script. You can't easily use ADSI (which is what this is) directly from CF - even with CF 5. What I've done before is to write COM wrappers for ADSI functionality in Windows Script Components, and called those. If you're using CFMX, you might find better solutions by searching for ADSI and Java. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:SOT: Internal/Intranet Search Engines - What to ask the sales critters
Larry, Some of the critical questions to help you in your search. 1) Do you need to search locally from a CD/DVD or from a server? 2) In what file format is the manual (PDF, word docs, etc) 3) What will you use as your user interface for searching the manual (flash, HTML, etc)? 4) What is your budget? 5) Are there any components of the manual located on the server (diagrams, videos, and so on)? 6) If using a CD, what platforms will the target audiance use? If you're searching directly from a CD/DVD then you'll need to bundle DT search (the others require a server) and create an interface that interacts with the search program either using Flash or Java Swing (assuming not everyone has Windows). Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE Thanks Jeremy. I don't think that this is really for a CMS system rather for an on-line manual (IETM's Interactive Electronic Technical Manuals). But I agree with your point regarding the database searches. As for the location of the data, from what I understand its going to be on the corporate servers and local hard drives. regards, larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Win 2000 boot
START RUN msconfig.exe and run it, Jb. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: 14 November 2003 13:45 To: CF-Talk Subject: OT - Win 2000 boot In NT 4.0 I was able to edit the boot.ini file and change the bootup menu. How does one do this in Windows 2000? I don't see a boot.ini file and can't find any reference to changing it in the Control Panel. Thx. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Win 2000 boot
Also, just FYI: boot.ini exists on 2k/xp, it's just a hidden file.Also, you can typically get to these settings through the System control panel. Usually under Advanced / Startup-Recovery. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 9:30 AM To: CF-Talk Subject: RE: OT - Win 2000 boot START RUN msconfig.exe and run it, Jb. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: 14 November 2003 13:45 To: CF-Talk Subject: OT - Win 2000 boot In NT 4.0 I was able to edit the boot.ini file and change the bootup menu. How does one do this in Windows 2000? I don't see a boot.ini file and can't find any reference to changing it in the Control Panel. Thx. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Manually clearing CF cache
Can I manually delete the files i the cache folder without screwing anything up? Yes. I think Matt Liotta posted a script on his blog (http://devilm.com/ ?) you can use to determine exactly which file you want to delete, if you'd rather not delete them all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Win 2000 boot
In NT 4.0 I was able to edit the boot.ini file and change the bootup menu. How does one do this in Windows 2000? I don't see a boot.ini file and can't find any reference to changing it in the Control Panel. It's on the root of your boot partition, although it's often hidden and read-only by default. You can just remove those attributes with attrib, edit, then reset the attributes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
UNC names and Mapped Drives for CFDIRECTORY
Hello All, Does CFDIRECTORY work with Mapped drive letters?I am trying to view Network Share and having now luck.I went into the coldfusion service and checked off log on as and gave it a name with rights on the machine.Also I tried setting up a mapped drive and tried doing a list on my mapped letter no luck either? Any ideas? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UNC names and Mapped Drives for CFDIRECTORY
Does CFDIRECTORY work with Mapped drive letters?I am trying to view Network Share and having now luck.I went into the coldfusion service and checked off log on as and gave it a name with rights on the machine.Also I tried setting up a mapped drive and tried doing a list on my mapped letter no luck either? The mapped drive would have to be created using that user account, and it would also have to be persistent. I'd recommend just using the UNC path, if that works for you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Changes in a Directory CFDIRECTORY
I have no idea what your app does, but you could cache the dir structure in the application scope and filter it according to the user that is logged. If two users can't manipulate the same file, I would use session scope. Single treaded app in cf5: Application.cfm: = = = = = = = cflock scope=application timeout=20 cfset application.var = /cflock By locking the application scope, every tread has to wait for the previous tread to release the lock. As all users share the application scope and all requests execute application.cfm, the result is a single-treaded app. This may work fine in dev (only one or two users), but have a huge performance impact in production. -Oorspronkelijk bericht- Van: Bushy [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 15:03 Aan: CF-Talk CC: Onderwerp: RE: Changes in a Directory CFDIRECTORY --Original Message Text--- From: Pascal Peters Date: Fri, 14 Nov 2003 14:51:45 +0100 If the directory listing is the same for all users, you can store it in the application scope. Directory listings would change. Not all users would be accessing the same data in the same directories. Can I still use an APPLICATION scope? you have to be carefull not to single-thread your application using the application scope in the Application.cfm I'm not sure what you mean by that. Could you give an example? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UNC names and Mapped Drives for CFDIRECTORY
I think it's possible, but you have to run the CF service as a user with rights to access the network and create the mapped drive using that account. -Oorspronkelijk bericht- Van: Mickael [mailto:[EMAIL PROTECTED] Verzonden: vr 14/11/2003 15:37 Aan: CF-Talk CC: Onderwerp: UNC names and Mapped Drives for CFDIRECTORY Hello All, Does CFDIRECTORY work with Mapped drive letters?I am trying to view Network Share and having now luck [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: When sending a message through CFMail
Mark, On 11/14/2003 at 07:53, you wrote: ML Is the cfmailpart tag required if I know I'm only going to send ML the message as plain text? Not normally. You should only need that for multi-part messages or if you need to use specific character encoding (utf-8, iso-8859-1, etc). ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: When sending a message through CFMail
As long as your message isn't multipart, you can leave it out. -- Jillian -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: November 14, 2003 6:54 AM To: CF-Talk Subject: When sending a message through CFMail Is the cfmailpart tag required if I know I'm only going to send the message as plain text? Thanks, Mark _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: UNC names and Mapped Drives for CFDIRECTORY
I have no problem using the UNC path, I am not able to view any of the files that are there.I just get an empty directory, and there is something in the directory.Is there a way to output debugging info for cfdirectory, like if there was a permission issue? - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, November 14, 2003 9:46 AM Subject: RE: UNC names and Mapped Drives for CFDIRECTORY Does CFDIRECTORY work with Mapped drive letters?I am trying to view Network Share and having now luck.I went into the coldfusion service and checked off log on as and gave it a name with rights on the machine.Also I tried setting up a mapped drive and tried doing a list on my mapped letter no luck either? The mapped drive would have to be created using that user account, and it would also have to be persistent. I'd recommend just using the UNC path, if that works for you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Is cflog thread-safe? [cf5]
Is cflog in ColdFusion 5 thread-safe, or does it need to be locked like cffile? Thank you, Mike Chabot [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Manually clearing CF cache
Actually, I made a udf for this... http://www.cflib.org/udf.cfm?ID=895 although I haven't had a need for it since the 6.1 upgrade came out. -nathan strutz -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 7:43 AM To: CF-Talk Subject: RE: Manually clearing CF cache Can I manually delete the files i the cache folder without screwing anything up? Yes. I think Matt Liotta posted a script on his blog (http://devilm.com/ ?) you can use to determine exactly which file you want to delete, if you'd rather not delete them all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Win 2000 boot
Thanks all for the help. Robert O. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 9:44 AM To: CF-Talk Subject: RE: OT - Win 2000 boot In NT 4.0 I was able to edit the boot.ini file and change the bootup menu. How does one do this in Windows 2000? I don't see a boot.ini file and can't find any reference to changing it in the Control Panel. It's on the root of your boot partition, although it's often hidden and read-only by default. You can just remove those attributes with attrib, edit, then reset the attributes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Evaluate an Array
Thanks Pascal - worked like a charm! -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 3:23 AM To: CF-Talk Subject: RE: Evaluate an Array cfloop list=#PNResponse# index=pair delimiters= cfset #ListFirst(pair,'=')# = ListRest(pair,'=') /cfloop Make sure that the var names are suitable for CF. Maybe it's better to create a structure cfset stResponse = StructNew() cfloop list=#PNResponse# index=pair delimiters= cfset stResponse[ListFirst(pair,'=')] = ListRest(pair,'=') /cfloop Pascal -Oorspronkelijk bericht- Van: Robert Redpath [mailto:[EMAIL PROTECTED] Verzonden: do 13/11/2003 21:25 Aan: CF-Talk CC: Onderwerp: Evaluate an Array In a credit card processing app I am working on I get a response back from the credit card processor in the following form: PNResponse = RESULT=23PNREF=V50035748010RESPMSG=Invalid account number _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT Hosting Options? Repost
I posted this on a slow Sunday got no response -- so I'll try again: have been away from CFMX for a couple of months, so I'd like to get the latest input from the experts. I want to set up several web sites to memorialize family members who have passed on  -- wife, sister, mother, father. Also to provide web sites for my grandchildren. I want this to run on CFMX/JRun Linux, Unix or Mac OS X Almost any db is acceptable (dynamic text, photo, music storage). I could host this myself or go to a reasonably-priced, reliable shared service. I will need to have 20-30 domain names -- so registration cost is a consideration too, One shared host (WebCom) offers CFMX, UNIX... and $6.95 domain registration. WebCom brings bittersweet memories -- hosted my first Perl (subset) shopping cart there. My ideal would be a Mac OS X hosted site CFMX For J2EE / JRun / Sybase, Oracle. or SQL-Server. I know there is no Official CFMX product for Mac OS X. but I could purchase the Developer License and run it myself. Does MM still offer a Multiuser CFMX/JRun developer license?  I went to the MM site but could not find this. Any input will be greatly appreciated. TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Question from a beginner
I have a website describing hikes I have taken.I have recently added a charting page to chart much of the data I collect such as Region, Recommendation, Difficulty which works fine (since these values are essentially categorical ones with few values 5-6).However I also am trying to chart Time, Elevation gain, and Distance hiked.Elevation Gain in particular charts poorly as hardly any of the 60 hikes had the same gain. What I would like to do is when I am charting Time, Elevation gain, and Distance I would like to categorized the output into just a few.For Elevation it would probably be best to use 500ft increments.0-500, 500-1000, 1000-1500 and so on. The current query I am using for the cfchart call is: SELECT #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMe# order by #ChartMe#; Does anyone have an idea of how this query might be amended or otherwise rewritten to allow the above categorization to happen rather than just counting discreet instances?I have tried searching the web for quite a while to no avail, and was thinking this group might have some clues. Even good sql sites, groups, or book recommendations would be very welcomed. Thanks sincerely, John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle CLOBS SQL
Hi All, Got a table where the text is held in clob's I need to extract all CLOBS where there is a URL contained within them. Can I do this in SQL (Oracle specific SQL ok by me) or would I have to do it in Co,d Fusion, looping and doing a REFind on each individual clob? Cheers, -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question from a beginner
John, Are your elevation value stored in feet units? If so, you can set a new variable: cfset chart_me_calc=integer(elevation/500) (the actual syntax may be different for your db.) Then: cfset chart_me=elevation cfparam name=chart_me_code default=#chart_me# select #chart_me_calc# as #chart_me#, count(*) as Chart_count Post the url when you are done so we can check it out. Jerry Johnson [EMAIL PROTECTED] 11/14/03 11:04AM I have a website describing hikes I have taken.I have recently added a charting page to chart much of the data I collect such as Region, Recommendation, Difficulty which works fine (since these values are essentially categorical ones with few values 5-6).However I also am trying to chart Time, Elevation gain, and Distance hiked.Elevation Gain in particular charts poorly as hardly any of the 60 hikes had the same gain. What I would like to do is when I am charting Time, Elevation gain, and Distance I would like to categorized the output into just a few.For Elevation it would probably be best to use 500ft increments.0-500, 500-1000, 1000-1500 and so on. The current query I am using for the cfchart call is: SELECT #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMe# order by #ChartMe#; Does anyone have an idea of how this query might be amended or otherwise rewritten to allow the above categorization to happen rather than just counting discreet instances?I have tried searching the web for quite a while to no avail, and was thinking this group might have some clues. Even good sql sites, groups, or book recommendations would be very welcomed. Thanks sincerely, John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
What is wrong w/ this cfscript block of code?
Any help would be appreciated here... In the end, I would like 4 dynamically named variables with random values. What am I missing? cfscript // Convert the product ids to a comma delimited list. PIDList = ValueList(getAllInCat.Product_ID); // Loop through 4 times and create 4 dynamically name vars with random values. for(i=1; i LTE 4; i = i + 1) { // Grab a random number based on the number of products available. RandValue#i# = RandRange(1, ListLen(PIDList)); // Get the Product_ID based on the random number. RandRecord#i# = ListGetAt(PIDList, RandValue#i#); // Remove the first Random value from the list, so it is not selected twice. PIDList = ListDeleteAt(PIDList, RandValue#i#); } /cfscript Thanks, Ch [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle CLOBS SQL
A cfquery/cfloop would be pretty simple to write.Sounds like a tall order for a single regex, though.Seems like you'd need another loop over the output text in case of multiple urls.I'm not much with regexes though, so I could be wrong. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What is wrong w/ this cfscript block of code?
Che, I think you probably need a SetVariable for this... RandValue#i# = RandRange(1, ListLen(PIDList)); SetVariable(RandValuei,RandRange(1, ListLen(PIDList)); RandRecord#i# = ListGetAt(PIDList, RandValue#i#); SetVariable(RandRecordi,RandRange(1, ListLen(PIDList)); And perhaps use a struct reference for this PIDList = ListDeleteAt(PIDList, RandValue#i#); PIDList = ListDeleteAt(PIDList,variables[RandValuei]); Hope this helps Regards Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle CLOBS SQL
Hmmm thought it would be difficult to do in SQL I don't need to actually find the URL's in the text, just need to identify that there is one or more so a simple regexp would do for me it's just a flag to say... hey this block of text needs to be checked Don't want the users putting in undesirable links and want a quick way to check them;-) -dc -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 14 November 2003 16:43 To: CF-Talk Subject: RE: Oracle CLOBS SQL A cfquery/cfloop would be pretty simple to write.Sounds like a tall order for a single regex, though.Seems like you'd need another loop over the output text in case of multiple urls.I'm not much with regexes though, so I could be wrong. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle CLOBS SQL
[EMAIL PROTECTED] wrote: I need to extract all CLOBS where there is a URL contained within them. Can I do this in SQL (Oracle specific SQL ok by me) or would I have to do it in Co,d Fusion, looping and doing a REFind on each individual clob? SELECT * FROM table WHERE whatever LIKE '%http://%' Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What is wrong w/ this cfscript block of code?
Che, On 11/14/2003 at 11:33, you wrote: CV In the end, I would like 4 dynamically named variables with random CV values. What am I missing? CV RandValue#i# = RandRange(1, ListLen(PIDList)); Quote the dynamically named variable: RandValue#i# = RandRange(1, ListLen(PIDList)); ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question from a beginner
The link is http://www.attrition.ws/hike.cfm (click piechart). Basically the hikechart.cfm page takes in a url variable from 1-6 to set some values and based on the input populates the #chartme# variable to build the query. I am using mssql for this.I am trying to take into consideration the discreet values for Elevation, Time, and distance so the count value from the sql query would be categorized.Currently each discreet value is charted. See how many values there are for elevation? http://www.attrition.ws/hikechart.cfm?Chart=6Totpics=12Columns=3Condi tion=UrlValue= When drilling into the chart I pass back a couple url variables to refine the query to the hike.cfm page, which is why I am trying to handle this logic in sql rather than the application per se so that I can pass this back to the refining page.I was hoping that based in the incoming url.chart value I could build some conditional logic within the sql query to group Elevation etc into categories of 500. Any ideas?Below is the relevant hikechart.cfm code: cfif IsDefined(URL.Chart) AND url.Chart EQ 1 cfset ChartMe=Region cfset Title=Regional Distribution of Hikes /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 2 cfset ChartMe=HikeDifficulty cfset Title=Difficulty PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 3 cfset ChartMe=Reccomend cfset Title=Reccomendation Piechart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 4 cfset ChartMe=HikeTime cfset Title=Round Trip Time In Hours PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 5 cfset ChartMe=RoundTripDistance cfset Title=Round Trip Distance In Miles PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 6 cfset ChartMe=ElevationGain cfset Title=Elevation Gained In Feet PieChart /cfif !--- End Catch block for URL variables --- cfquery name=Recordset1 datasource=hike SELECT #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMe# order by #ChartMe#; /cfquery cfchart showborder=yes show3d=yes chartwidth=600 chartheight=400pieslicestyle=sliced url=""> umns#urlvalue=$ITEMLABEL$ cfchartseries type=pie query=Recordset1 itemcolumn=#ChartMe# valuecolumn=Chart_count /cfchartseries /cfchart Thanks, John -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 8:27 AM To: CF-Talk Subject: Re: Question from a beginner John, Are your elevation value stored in feet units? If so, you can set a new variable: cfset chart_me_calc=integer(elevation/500) (the actual syntax may be different for your db.) Then: cfset chart_me=elevation cfparam name=chart_me_code default=#chart_me# select #chart_me_calc# as #chart_me#, count(*) as Chart_count Post the url when you are done so we can check it out. Jerry Johnson [EMAIL PROTECTED] 11/14/03 11:04AM I have a website describing hikes I have taken.I have recently added a charting page to chart much of the data I collect such as Region, Recommendation, Difficulty which works fine (since these values are essentially categorical ones with few values 5-6).However I also am trying to chart Time, Elevation gain, and Distance hiked.Elevation Gain in particular charts poorly as hardly any of the 60 hikes had the same gain. What I would like to do is when I am charting Time, Elevation gain, and Distance I would like to categorized the output into just a few.For Elevation it would probably be best to use 500ft increments.0-500, 500-1000, 1000-1500 and so on. The current query I am using for the cfchart call is: SELECT #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMe# order by #ChartMe#; Does anyone have an idea of how this query might be amended or otherwise rewritten to allow the above categorization to happen rather than just counting discreet instances?I have tried searching the web for quite a while to no avail, and was thinking this group might have some clues. Even good sql sites, groups, or book recommendations would be very welcomed. Thanks sincerely, John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What is wrong w/ this cfscript block of code?
Stephen, the last line bombs out. Variables is undefined. Any ideas? -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 11:42 AM To: CF-Talk Subject: Re: What is wrong w/ this cfscript block of code? Che, I think you probably need a SetVariable for this... RandValue#i# = RandRange(1, ListLen(PIDList)); SetVariable(RandValuei,RandRange(1, ListLen(PIDList)); RandRecord#i# = ListGetAt(PIDList, RandValue#i#); SetVariable(RandRecordi,RandRange(1, ListLen(PIDList)); And perhaps use a struct reference for this PIDList = ListDeleteAt(PIDList, RandValue#i#); PIDList = ListDeleteAt(PIDList,variables[RandValuei]); Hope this helps Regards Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle CLOBS SQL
Cheers Jochem, but I thought of that and should have made it a bit clearer in the question... The clobs contain be free text with no HTML allowed.The links that may be in the clob will just be plain text and may not actually contain http://. It might just be www.domain.com or even domain.com, that's why I was thinking that I would need regexp, but was wondering aloud whether SQL could do something like that -dc -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 14 November 2003 16:48 To: CF-Talk Subject: Re: Oracle CLOBS SQL [EMAIL PROTECTED] wrote: I need to extract all CLOBS where there is a URL contained within them. Can I do this in SQL (Oracle specific SQL ok by me) or would I have to do it in Co,d Fusion, looping and doing a REFind on each individual clob? SELECT * FROM table WHERE whatever LIKE '%http://%' Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
persistent CFC and data update problem.
I'm going to try to describe this problem in abstract first.I'm sure we'll get into code examples before the end, but I did not want to dump nine related CFCs on the list all at once.Please bear with me, this is a bit convoluted. I have a fairly complex CFC/data structure.My first attempt at OO/CFC application design.Lets start with the main CFC's (Donor/Chairperson/Volunteer) each of which extend a CFC of basic functionality (Profile).Profile is a composite of 6 CFC's that group different sets of functionality (Basic Data/General Comments/Education/Family Friend Relationships/Lifestyle/Special Dates/Complaints).All of these extend a small CFC containing common init and display functions. The main CFC is initiated and stored in the session scope: cfparam name=session.cps.profile default=#createObject('component','Profile_Donor').init(session.cps.id)# for example.The main CFC then initiate each composite CFC which query the database and stores the returned query in their this scope through a getter function in each composite CFC. The problem occurs when I try to update any of this data. In my update code, I can not seem to refresh the data.I have forms that collects the new data, the form is submitted to a controller CFC, that calls the update functions of the Main CFC (in the session scope) inherited from the Profile CFC.These functions in the Profile CFC, call the associated functions from the appropriate composite CFC.Then the update function in the composite CFC updates the database and calls the getter function that queries the database and stores the data in the this scope. For some reason this works, if I do it from a CFM file.But, if I do it from a controller type CFC, I seem to get some kind of separate scope/instance somewhere?That's the only theory I have anyway.All the update code works, but when I return, the data in the CFC/object in the session scope has not been updated. I doubt I explained that very clearly yet.As I said this is rather convoluted, and I'm not really sure where my problem is.Any help in understanding / explaining / resolving this issue would be most appreciated. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: cfftp
Hi, I'm using cfftp to connect to a server to list /directory/files. I want to be able to check if whats being displayed is a directory or file. Like cfif ... dir display this image and cfif ... file display this image? This is what I have... cfftp action="" connection=ftpconnect ... cfftp action=""> stoponerror=yes name=listfiles directory=/ connection=ftpconnect cfoutput query=listfiles #name# /cfoutput cfftp action=""> connection=ftpconnect ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What is wrong w/ this cfscript block of code?
Che, On 11/14/2003 at 12:03, you wrote: CV Stephen, the last line bombs out. Variables is undefined. Any CV ideas? CVPIDList = ListDeleteAt(PIDList,variables[RandValuei]); How about this: cfscript PIDList=ValueList(getAllInCat.Product_ID); for(i=1; i lte 4; i=i+1){ thisRandValue=RandRange(1,ListLen(PIDList)); RandValue#i#=thisRandValue; RandRecord#i#=ListGetAt(PIDList,thisRandValue); PIDList=ListDeleteAt(PIDList,thisRandValue); } /cfscript ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfftp
Instead of cfoutput query=listfiles./cfoutput Do a cfdump var=#listfiles# and that will show you everything that is returned in that object.You'll see all of the variables and information that you have access to and then you can set up your cfif .dir etc. John Burns -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:21 PM To: CF-Talk Subject: re: cfftp Hi, I'm using cfftp to connect to a server to list /directory/files. I want to be able to check if whats being displayed is a directory or file. Like cfif ... dir display this image and cfif ... file display this image? This is what I have... cfftp action="" connection=ftpconnect ... cfftp action=""> stoponerror=yes name=listfiles directory=/ connection=ftpconnect cfoutput query=listfiles #name# /cfoutput cfftp action=""> connection=ftpconnect ... _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What is wrong w/ this cfscript block of code?
that did the trick. thank you very much. clever, using a set variable name made it work. -Original Message- From: Ubqtous [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:22 PM To: CF-Talk Subject: Re: What is wrong w/ this cfscript block of code? Che, On 11/14/2003 at 12:03, you wrote: CV Stephen, the last line bombs out. Variables is undefined. Any CV ideas? CVPIDList = ListDeleteAt(PIDList,variables[RandValuei]); How about this: cfscript PIDList=ValueList(getAllInCat.Product_ID); for(i=1; i lte 4; i=i+1){ thisRandValue=RandRange(1,ListLen(PIDList)); RandValue#i#=thisRandValue; RandRecord#i#=ListGetAt(PIDList,thisRandValue); PIDList=ListDeleteAt(PIDList,thisRandValue); } /cfscript ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cool Fusion - infusion Mail server - any opinions?
Saw a banner on this list for the Cool-Fusion built mail server and wanted to find out if anyone here has any experience with either their inFusion Mail server or their FusionMail server? I tried joining their mailing list and sending email to their tech support - their automated just reply to confirm email came back user unknown as did the email I sent to their support staff! They around? Legit? A good solid Cold Fusion based product? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle CLOBS SQL
Jochem wrote: WHERE whatever LIKE '%http://%' DOH! :-) Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cool Fusion - infusion Mail server - any opinions?
Very legit. Howie Hamlin is a long time list member and I've been using it to power the lists for a while. I've emailed him that he may have some problems with their mail support. If I get a bounce, I'll give him a call. As a side thing, he's a list supporter which is the reason for the ads. iMS makes the lists as powerful as they are and potentially more powerful once I get a free second to make some mods to the software. I've got some built in anti-spam templates for the product which will remove most spam before its even on the server. Saw a banner on this list for the Cool-Fusion built mail server and wanted to find out if anyone here has any experience with either their inFusion Mail server or their FusionMail server? I tried joining their mailing list and sending email to their tech support - their automated just reply to confirm email came back user unknown as did the email I sent to their support staff! They around? Legit? A good solid Cold Fusion based product? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What is wrong w/ this cfscript block of code?
Che, On 11/14/2003 at 12:28, you wrote: CV clever, using a set variable name made it work. I thought the variables[RandValuei] trick would have worked, but maybe your version of CF doesn't support it. I've successfully used that approach with the request scope on CF5: request.name_#f#=trim(form['name_'f]); ... #request['name_'f]# ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle CLOBS SQL
[EMAIL PROTECTED] wrote: The clobs contain be free text with no HTML allowed.The links that may be in the clob will just be plain text and may not actually contain http://. It might just be www.domain.com or even domain.com, that's why I was thinking that I would need regexp, but was wondering aloud whether SQL could do something like that SQL doesn't do normal regex. But there is a functionality in SQL that combines parts from LIKE and regex, named SIMILAR TO. You might want to check the Oracle docs to see if it is supported. The pattern would look something like: SELECT * FROM table WHERE whatever SIMILAR TO '%[abcdefghijklmnopqrstuvwxyz]+.(com|org|net)%' Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: cfftp
How can I sort the directories/files of my output with the directories being listed first and then files using cfftp? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
Is this a replacement for a textarea?Will it post along with a form submission?I don't see any docs of that nature... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 6:39 PM To: CF-Talk Subject: RE: Users want to format text why dont u do it in flash? or use a flash editor and i hope he could copy and paste it into the right place this one is fantastic http://www.joshdura.com/archives/000163.php I'm having the same problem.One mac user (the site owner). I think everyone else uses Windows. My biggest problem is that the editors are using a number of different versions of MS Word to write up their content. Some versions convert just fine (using FCKEditor - windows only) while others leave bad markup and unprintable characters. Of course, we can't expect the end users to be careful :-) I'm looking at soEditor Pro 2.5 - has anyone used this with multiple versions of MS Word?I know it won't work for the Mac user - he's ok with that, but the MS Word support has to be top notch. Why can't they just learn a little HTML! Hehe -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:58 PM To: CF-Talk Subject: RE: Users want to format text Would be perfect if 90% of my users were not Mac users! Any good cross platform ones? -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:42 PM To: CF-Talk Subject: Re: Users want to format text Use HTMLEdit from http://www.interactivetools.com http://www.interactivetools.com Easy use - Original Message - From: Janine Jakim To: CF-Talk Sent: Thursday, November 13, 2003 12:30 PM Subject: Users want to format text Have an application with a bunch of input boxes.The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cool Fusion - infusion Mail server - any opinions?
No..but if you're buying it buy it by clicking the link in the ad on these pages so HOF gets the referral cash ^_^ These lists run on iMS I believe. -Gel -Original Message- From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED] Saw a banner on this list for the Cool-Fusion built mail server and wanted to find out if anyone here has any experience with either their inFusion Mail server or their FusionMail server? I tried joining their mailing list and sending email to their tech support - their automated just reply to confirm email came back user unknown as did the email I sent to their support staff! They around? Legit? A good solid Cold Fusion based product? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question from a beginner
You use a cfloop and use statements to set a variable that you can increment if a hike falls within that group.. cfparam name=group1 default=0 cfparam name=group2 default=0 cfparam name=group3 default=0 cfparam name=hikeGrouping default=500 cfoutput query=queryOfHikes cfif hikeHeight LT hikeGrouping cfset group1 = group1 + 1 cfelseif hikeHeight LT evaluate(hikeGrouping * 2) cfset group2 = group2 + 1 /cfif /cfoutput This should give you values for your groups at the end for how many hikes fell into that group.Since CFIF evaluates in order, just see if the hike is less than that amount and if so, it falls into that group.Use hikeGrouping to set the size of the groups.Then, later, when you climb Everest, you can change it to 1000 so you don't have too many pie pieces. John Burns -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 11:51 AM To: CF-Talk Subject: RE: Question from a beginner The link is http://www.attrition.ws/hike.cfm (click piechart). Basically the hikechart.cfm page takes in a url variable from 1-6 to set some values and based on the input populates the #chartme# variable to build the query. I am using mssql for this.I am trying to take into consideration the discreet values for Elevation, Time, and distance so the count value from the sql query would be categorized.Currently each discreet value is charted. See how many values there are for elevation? http://www.attrition.ws/hikechart.cfm?Chart=6 http://www.attrition.ws/hikechart.cfm?Chart=6Totpics=12Columns=3Condi Totpics=12Columns=3Condi tion=UrlValue= When drilling into the chart I pass back a couple url variables to refine the query to the hike.cfm page, which is why I am trying to handle this logic in sql rather than the application per se so that I can pass this back to the refining page.I was hoping that based in the incoming url.chart value I could build some conditional logic within the sql query to group Elevation etc into categories of 500. Any ideas?Below is the relevant hikechart.cfm code: cfif IsDefined(URL.Chart) AND url.Chart EQ 1 cfset ChartMe=Region cfset Title=Regional Distribution of Hikes /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 2 cfset ChartMe=HikeDifficulty cfset Title=Difficulty PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 3 cfset ChartMe=Reccomend cfset Title=Reccomendation Piechart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 4 cfset ChartMe=HikeTime cfset Title=Round Trip Time In Hours PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 5 cfset ChartMe=RoundTripDistance cfset Title=Round Trip Distance In Miles PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 6 cfset ChartMe=ElevationGain cfset Title=Elevation Gained In Feet PieChart /cfif !--- End Catch block for URL variables --- cfquery name=Recordset1 datasource=hike SELECT #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMe# order by #ChartMe#; /cfquery cfchart showborder=yes show3d=yes chartwidth=600 chartheight=400pieslicestyle=sliced url=""> umns#urlvalue=$ITEMLABEL$ cfchartseries type=pie query=Recordset1 itemcolumn=#ChartMe# valuecolumn=Chart_count /cfchartseries /cfchart Thanks, John -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 8:27 AM To: CF-Talk Subject: Re: Question from a beginner John, Are your elevation value stored in feet units? If so, you can set a new variable: cfset chart_me_calc=integer(elevation/500) (the actual syntax may be different for your db.) Then: cfset chart_me=elevation cfparam name=chart_me_code default=#chart_me# select #chart_me_calc# as #chart_me#, count(*) as Chart_count Post the url when you are done so we can check it out. Jerry Johnson [EMAIL PROTECTED] 11/14/03 11:04AM I have a website describing hikes I have taken.I have recently added a charting page to chart much of the data I collect such as Region, Recommendation, Difficulty which works fine (since these values are essentially categorical ones with few values 5-6).However I also am trying to chart Time, Elevation gain, and Distance hiked.Elevation Gain in particular charts poorly as hardly any of the 60 hikes had the same gain. What I would like to do is when I am charting Time, Elevation gain, and Distance I would like to categorized the output into just a few.For Elevation it would probably be best to use 500ft increments.0-500, 500-1000, 1000-1500 and so on. The current query I am using for the cfchart call is: SELECT #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMe# order by #ChartMe#; Does anyone have an idea of how this query might be amended or otherwise rewritten to allow the above categorization to happen rather than just counting discreet instances?I have tried searching the web for quite a while to no avail, and was thinking this group might have
Re: Cool Fusion - infusion Mail server - any opinions?
Actually, because the list ads for iMS are in response to Howie's support, we don't get any referrals for it. The only paid ads we have at the moment are the Macromedia ads, but the same idea applies there. If you buy a MM product from one of the HoF links, we get a referral fee. I've gotten 1 already (after over 500,000 ad impressions). As for the lists, yes we're using iMS. It allows much finer control over the mail out in addition to all the other features. No..but if you're buying it buy it by clicking the link in the ad on these pages so HOF gets the referral cash ^_^ These lists run on iMS I believe. -Gel -Original Message- From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED] Saw a banner on this list for the Cool-Fusion built mail server and wanted to find out if anyone here has any experience with either their inFusion Mail server or their FusionMail server? I tried joining their mailing list and sending email to their tech support - their automated just reply to confirm email came back user unknown as did the email I sent to their support staff! They around? Legit? A good solid Cold Fusion based product? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfftp
I would imagine you could do a query of a query on the object that is returned by cfftp and order it by whatever you wanted. John Burns -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:47 PM To: CF-Talk Subject: re: cfftp How can I sort the directories/files of my output with the directories being listed first and then files using cfftp? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
im sure u could if not what u could do is have it as a pop up, fill it in hit the show html button and copy paste it in or if you know enough flash just use it as the text field pretty easy too do. just make the form in flash and call the cfm insert page to do the insert Is this a replacement for a textarea?Will it post along with a form submission?I don't see any docs of that nature... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 6:39 PM To: CF-Talk Subject: RE: Users want to format text why dont u do it in flash? or use a flash editor and i hope he could copy and paste it into the right place this one is fantastic http://www.joshdura.com/archives/000163.php I'm having the same problem.One mac user (the site owner). I think everyone else uses Windows. My biggest problem is that the editors are using a number of different versions of MS Word to write up their content. Some versions convert just fine (using FCKEditor - windows only) while others leave bad markup and unprintable characters. Of course, we can't expect the end users to be careful :-) I'm looking at soEditor Pro 2.5 - has anyone used this with multiple versions of MS Word?I know it won't work for the Mac user - he's ok with that, but the MS Word support has to be top notch. Why can't they just learn a little HTML! Hehe -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:58 PM To: CF-Talk Subject: RE: Users want to format text Would be perfect if 90% of my users were not Mac users! Any good cross platform ones? -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:42 PM To: CF-Talk Subject: Re: Users want to format text Use HTMLEdit from http://www.interactivetools.com http://www.interactivetools.com Easy use - Original Message - From: Janine Jakim To: CF-Talk Sent: Thursday, November 13, 2003 12:30 PM Subject: Users want to format text Have an application with a bunch of input boxes.The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
Way too involved.. There are about 40 total textareas I need to replace - and I'm not at all sure it will handle MS Word conversions. Thanks for the info, though - I'll probably use it for other projects. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:54 PM To: CF-Talk Subject: RE: Users want to format text im sure u could if not what u could do is have it as a pop up, fill it in hit the show html button and copy paste it in or if you know enough flash just use it as the text field pretty easy too do. just make the form in flash and call the cfm insert page to do the insert Is this a replacement for a textarea?Will it post along with a form submission?I don't see any docs of that nature... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 6:39 PM To: CF-Talk Subject: RE: Users want to format text why dont u do it in flash? or use a flash editor and i hope he could copy and paste it into the right place this one is fantastic http://www.joshdura.com/archives/000163.php I'm having the same problem.One mac user (the site owner). I think everyone else uses Windows. My biggest problem is that the editors are using a number of different versions of MS Word to write up their content. Some versions convert just fine (using FCKEditor - windows only) while others leave bad markup and unprintable characters. Of course, we can't expect the end users to be careful :-) I'm looking at soEditor Pro 2.5 - has anyone used this with multiple versions of MS Word?I know it won't work for the Mac user - he's ok with that, but the MS Word support has to be top notch. Why can't they just learn a little HTML! Hehe -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:58 PM To: CF-Talk Subject: RE: Users want to format text Would be perfect if 90% of my users were not Mac users! Any good cross platform ones? -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:42 PM To: CF-Talk Subject: Re: Users want to format text Use HTMLEdit from http://www.interactivetools.com http://www.interactivetools.com Easy use - Original Message - From: Janine Jakim To: CF-Talk Sent: Thursday, November 13, 2003 12:30 PM Subject: Users want to format text Have an application with a bunch of input boxes.The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFCOOKIE and Netscape 7.1
Hey All, I'm setting non-persistent cookies like so: cfcookie name=MyCookie value=MyValue So with no expires attribute the cookie should be destroyed when the browser closes.Well in Netscape 7.1 the cookie is persisting (i.e. close ALL browsers...re-open...cookie is still there)!! Any ideas? Thanks Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
While on this question. has anyone seen anything that allows you to format text with style sheets?For instance, a user highlights some text and instead of changing the font and size, you give them a list of the styles that they can use so that the text matches the styles on the rest of your pages? John Burns -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:54 PM To: CF-Talk Subject: RE: Users want to format text im sure u could if not what u could do is have it as a pop up, fill it in hit the show html button and copy paste it in or if you know enough flash just use it as the text field pretty easy too do. just make the form in flash and call the cfm insert page to do the insert Is this a replacement for a textarea?Will it post along with a form submission?I don't see any docs of that nature... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 6:39 PM To: CF-Talk Subject: RE: Users want to format text why dont u do it in flash? or use a flash editor and i hope he could copy and paste it into the right place this one is fantastic http://www.joshdura.com/archives/000163.php I'm having the same problem.One mac user (the site owner). I think everyone else uses Windows. My biggest problem is that the editors are using a number of different versions of MS Word to write up their content. Some versions convert just fine (using FCKEditor - windows only) while others leave bad markup and unprintable characters. Of course, we can't expect the end users to be careful :-) I'm looking at soEditor Pro 2.5 - has anyone used this with multiple versions of MS Word?I know it won't work for the Mac user - he's ok with that, but the MS Word support has to be top notch. Why can't they just learn a little HTML! Hehe -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:58 PM To: CF-Talk Subject: RE: Users want to format text Would be perfect if 90% of my users were not Mac users! Any good cross platform ones? -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:42 PM To: CF-Talk Subject: Re: Users want to format text Use HTMLEdit from http://www.interactivetools.com http://www.interactivetools.com Easy use - Original Message - From: Janine Jakim To: CF-Talk Sent: Thursday, November 13, 2003 12:30 PM Subject: Users want to format text Have an application with a bunch of input boxes.The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOLVED: CFCOOKIE and Netscape 7.1
Nevermind...solved I had just installed NS 7.1 and the registration window was open the whole time but hiddenso it was keeping the cookie aliveTGIF ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SESConverter
I've been reading about the sesConverter at Fusium.com and wondered what other's experience was using it, preferrably with fusebox. I have a FB2 site a client wants better reporting/search engine ability on. After looking into the sesConverter I didn't understand the reason/value of having the dummy filename on the url. What is this dummy file? Do you actually create a file with searchable content or is it just so the stats app will have something to display? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cool Fusion - infusion Mail server - any opinions?
I apologize for that.Your server is listed as an open relay in njabl.org and our mail server is currently configured to reply unknown user when a server is banned (we'll be changing that in the future - once we relocated to our new facility). FYI: http://njabl.org/cgi-bin/lookup.cgi?query=209.73.244.54 We received a voice mail from someone at your company named Allen - someone here will return his call shortly. I manually unbanned your server from our mail server so you should be able to send mail to us now.Sorry for the inconvenience. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Rafael Bleiweiss To: CF-Talk Sent: Friday, November 14, 2003 1:35 PM Subject: Cool Fusion - infusion Mail server - any opinions? Saw a banner on this list for the Cool-Fusion built mail server and wanted to find out if anyone here has any experience with either their inFusion Mail server or their FusionMail server? I tried joining their mailing list and sending email to their tech support - their automated just reply to confirm email came back user unknown as did the email I sent to their support staff! They around? Legit? A good solid Cold Fusion based product? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
http://www.fredck.com/FCKeditor/ This is an awesome editor - free of charge - seems pretty flawless in use, as long as your clients are on Windoze with IE5+ -Original Message- From: John Burns [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 1:07 PM To: CF-Talk Subject: RE: Users want to format text While on this question. has anyone seen anything that allows you to format text with style sheets?For instance, a user highlights some text and instead of changing the font and size, you give them a list of the styles that they can use so that the text matches the styles on the rest of your pages? John Burns -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:54 PM To: CF-Talk Subject: RE: Users want to format text im sure u could if not what u could do is have it as a pop up, fill it in hit the show html button and copy paste it in or if you know enough flash just use it as the text field pretty easy too do. just make the form in flash and call the cfm insert page to do the insert Is this a replacement for a textarea?Will it post along with a form submission?I don't see any docs of that nature... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 6:39 PM To: CF-Talk Subject: RE: Users want to format text why dont u do it in flash? or use a flash editor and i hope he could copy and paste it into the right place this one is fantastic http://www.joshdura.com/archives/000163.php I'm having the same problem.One mac user (the site owner). I think everyone else uses Windows. My biggest problem is that the editors are using a number of different versions of MS Word to write up their content. Some versions convert just fine (using FCKEditor - windows only) while others leave bad markup and unprintable characters. Of course, we can't expect the end users to be careful :-) I'm looking at soEditor Pro 2.5 - has anyone used this with multiple versions of MS Word?I know it won't work for the Mac user - he's ok with that, but the MS Word support has to be top notch. Why can't they just learn a little HTML! Hehe -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:58 PM To: CF-Talk Subject: RE: Users want to format text Would be perfect if 90% of my users were not Mac users! Any good cross platform ones? -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:42 PM To: CF-Talk Subject: Re: Users want to format text Use HTMLEdit from http://www.interactivetools.com http://www.interactivetools.com Easy use - Original Message - From: Janine Jakim To: CF-Talk Sent: Thursday, November 13, 2003 12:30 PM Subject: Users want to format text Have an application with a bunch of input boxes.The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cool Fusion - infusion Mail server - any opinions?
You could always be set up as a reseller and make $ that way. Regards, Howie - Original Message - From: Michael Dinowitz To: CF-Talk Sent: Friday, November 14, 2003 1:00 PM Subject: Re: Cool Fusion - infusion Mail server - any opinions? Actually, because the list ads for iMS are in response to Howie's support, we don't get any referrals for it. The only paid ads we have at the moment are the Macromedia ads, but the same idea applies there. If you buy a MM product from one of the HoF links, we get a referral fee. I've gotten 1 already (after over 500,000 ad impressions). As for the lists, yes we're using iMS. It allows much finer control over the mail out in addition to all the other features. No..but if you're buying it buy it by clicking the link in the ad on these pages so HOF gets the referral cash ^_^ These lists run on iMS I believe. -Gel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users want to format text
Yeah, that is an awesome one. I use it Steve -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 1:25 PM To: CF-Talk Subject: RE: Users want to format text http://www.fredck.com/FCKeditor/ This is an awesome editor - free of charge - seems pretty flawless in use, as long as your clients are on Windoze with IE5+ -Original Message- From: John Burns [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 1:07 PM To: CF-Talk Subject: RE: Users want to format text While on this question. has anyone seen anything that allows you to format text with style sheets?For instance, a user highlights some text and instead of changing the font and size, you give them a list of the styles that they can use so that the text matches the styles on the rest of your pages? John Burns -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 12:54 PM To: CF-Talk Subject: RE: Users want to format text im sure u could if not what u could do is have it as a pop up, fill it in hit the show html button and copy paste it in or if you know enough flash just use it as the text field pretty easy too do. just make the form in flash and call the cfm insert page to do the insert Is this a replacement for a textarea?Will it post along with a form submission?I don't see any docs of that nature... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 6:39 PM To: CF-Talk Subject: RE: Users want to format text why dont u do it in flash? or use a flash editor and i hope he could copy and paste it into the right place this one is fantastic http://www.joshdura.com/archives/000163.php http://www.joshdura.com/archives/000163.php I'm having the same problem.One mac user (the site owner). I think everyone else uses Windows. My biggest problem is that the editors are using a number of different versions of MS Word to write up their content. Some versions convert just fine (using FCKEditor - windows only) while others leave bad markup and unprintable characters. Of course, we can't expect the end users to be careful :-) I'm looking at soEditor Pro 2.5 - has anyone used this with multiple versions of MS Word?I know it won't work for the Mac user - he's ok with that, but the MS Word support has to be top notch. Why can't they just learn a little HTML! Hehe -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:58 PM To: CF-Talk Subject: RE: Users want to format text Would be perfect if 90% of my users were not Mac users! Any good cross platform ones? -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:42 PM To: CF-Talk Subject: Re: Users want to format text Use HTMLEdit from http://www.interactivetools.com http://www.interactivetools.com http://www.interactivetools.com Easy use - Original Message - From: Janine Jakim To: CF-Talk Sent: Thursday, November 13, 2003 12:30 PM Subject: Users want to format text Have an application with a bunch of input boxes.The users want to be able to do snazzy things as if it's a word document- underline, bold, change font size and/or type for certain parts. Is this possible? They then want to output it to a word doc. (I do know that's doable) Thanks, J _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
separating alpha groups in query results
Want to insert a blank line separator at the start of each new alpha letter group in a looped display query result. Any suggestions? DougF - Example: Ajo Amado Apache Junction Arizona City Ash Fork blank line here Benson Bisbee Black Canyon City blank line here Camp Creek Cottonwood -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle CLOBS SQL
Here's a quick tutorial on regular expressions in Oracle, but I'm not sure when they became supported (I don't think they're available in 8i): http://otn.oracle.com/books/pdfs/gennick_ch01.pdf - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 14, 2003 11:44 AM Subject: Re: Oracle CLOBS SQL [EMAIL PROTECTED] wrote: The clobs contain be free text with no HTML allowed.The links that may be in the clob will just be plain text and may not actually contain http://. It might just be www.domain.com or even domain.com, that's why I was thinking that I would need regexp, but was wondering aloud whether SQL could do something like that SQL doesn't do normal regex. But there is a functionality in SQL that combines parts from LIKE and regex, named SIMILAR TO. You might want to check the Oracle docs to see if it is supported. The pattern would look something like: SELECT * FROM table WHERE whatever SIMILAR TO '%[abcdefghijklmnopqrstuvwxyz]+.(com|org|net)%' Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: separating alpha groups in query results
One simple way is to add a column to your query with the initial letter (something like LEFT(column, 1) AS initial) and then CFOUTPUT GROUP using that column. --- Ben -Original Message- From: DougF [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 1:34 PM To: CF-Talk Subject: separating alpha groups in query results Want to insert a blank line separator at the start of each new alpha letter group in a looped display query result. Any suggestions? DougF - Example: Ajo Amado Apache Junction Arizona City Ash Fork blank line here Benson Bisbee Black Canyon City blank line here Camp Creek Cottonwood -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: separating alpha groups in query results
Check the first letter of the variable you're outputting and store it into a temporary variable.On the next time through, check the first letter against that temporary variable and if they don't match, put a blank line before outputting the info from the query. John Burns -Original Message- From: DougF [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 1:34 PM To: CF-Talk Subject: separating alpha groups in query results Want to insert a blank line separator at the start of each new alpha letter group in a looped display query result. Any suggestions? DougF - Example: Ajo Amado Apache Junction Arizona City Ash Fork blank line here Benson Bisbee Black Canyon City blank line here Camp Creek Cottonwood -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: separating alpha groups in query results
cfset firstLetter = A cflloop AlphaList index=String cfif Left(string,1) NEQ firstLetter Output Blank Line cfset firstLetter = left(string,1) /cfif cfoutput#String#/cfoutput /cfloop HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: DougF [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 10:34 AM To: CF-Talk Subject: separating alpha groups in query results Want to insert a blank line separator at the start of each new alpha letter group in a looped display query result. Any suggestions? DougF - Example: Ajo Amado Apache Junction Arizona City Ash Fork blank line here Benson Bisbee Black Canyon City blank line here Camp Creek Cottonwood -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question from a beginner
Well, after looking at the site, I completely miss living in Portland, OR. Boo Hoo! Make the following changes and I think you can get there: (The label will say 500, rather than the more proper 500-1000, but I leave that as a detail for you to finish) =) Jerry Johnson cfif IsDefined(URL.Chart) AND url.Chart EQ 6 cfset ChartMe=ElevationGain cfset ChartMeCalc=integer(ElevationGain/500)*500 cfset Title=Elevation Gained In Feet PieChart /cfif !--- End Catch block for URL variables --- cfparam name=ChartMeCalc default=#ChartMe# cfquery name=Recordset1 datasource=hike SELECT #ChartMeCalc# as #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMeCalc# order by #ChartMe#; /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SESConverter
Hi I have used it on FB3 and found it very useful for some search engines. The only issue is that it is one more this to support with IIS if thre is a change, and it is sometime difficult to get working properly at shared hosting environment. The dummy file is not an actual file in your system it is just there to make your url look complete. Here is a link from one of my websites http://www.mydomain.com/index.cfm/fuseaction/hotels.main/hotels.cfm This is the same as http://www.mydomain.com/index.cfm?fuseaction=hotels.main The file hotels.cfm does not actually exist. Mike - Original Message - From: CF Lists To: CF-Talk Sent: Friday, November 14, 2003 1:12 PM Subject: SESConverter I've been reading about the sesConverter at Fusium.com and wondered what other's experience was using it, preferrably with fusebox. I have a FB2 site a client wants better reporting/search engine ability on. After looking into the sesConverter I didn't understand the reason/value of having the dummy filename on the url. What is this dummy file? Do you actually create a file with searchable content or is it just so the stats app will have something to display? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question from a beginner
I pasted the wrong text. cfset ChartMeCalc=integer(ElevationGain/500)*500 should read cfset ChartMeCalc=convert(int,ElevationGain/500)*500 Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle CLOBS SQL
Thanks for alerting me to this. According to documentation, it's a new feature in 10g. Two words of warning on searching CLOBs: - CLOBs aren't made to be searched or manipulated or concatenated, but Oracle usually converts a CLOB to a string to allow this. - the CLOB-string conversion usually only takes the first 4000 bytes. --- Deanna Schneider [EMAIL PROTECTED] wrote: Here's a quick tutorial on regular expressions in Oracle, but I'm not sure when they became supported (I don't think they're available in 8i): http://otn.oracle.com/books/pdfs/gennick_ch01.pdf - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 14, 2003 11:44 AM Subject: Re: Oracle CLOBS SQL [EMAIL PROTECTED] wrote: The clobs contain be free text with no HTML allowed.The links that may be in the clob will just be plain text and may not actually contain http://. It might just be www.domain.com or even domain.com, that's why I was thinking that I would need regexp, but was wondering aloud whether SQL could do something like that SQL doesn't do normal regex. But there is a functionality in SQL that combines parts from LIKE and regex, named SIMILAR TO. You might want to check the Oracle docs to see if it is supported. The pattern would look something like: SELECT * FROM table WHERE whatever SIMILAR TO '%[abcdefghijklmnopqrstuvwxyz]+.(com|org|net)%' Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: limit processor load of cfserver.exe ?
Hello Jochem, Thursday, November 13, 2003, 11:29:40 PM, you wrote: JvD [EMAIL PROTECTED] wrote: Hi list, is it (theoretically) possible, to limit the processor load coldfusion (cfserver.exe) is causing to the server itself ?(OS: Win2000 Server; CF: Version 5) JvD Just give it a lower priority. JvD Jochem The bad part is, that I cannot change the priority even though I am the administrator. Strange windows. The message is: Access denied Weird. Uwe -- Best regards, cf-talk mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Setting Server Variables
How do I set server variables in CFMX 6.1? I want them to load everytime the instance starts.. - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]