Re: List Length
On Tuesday, August 27, 2002, at 06:12 , Bruce Holm wrote: The lists in my application are either ID numbers or usernames. I don't believe there will ever be more than several hundred and never more than 1200. Arrays won't work well because I'm using lists to determine duplicates...searching for a duplicate username or ID in the list using ListFind(). Arrays are not great for searching since you have to loop through the entire array. But then maybe that's faster? Arrays are *much* faster in CFMX!! listFind() can be *very* slow. Lists are just strings - string manipulation is slow. I'd recommend you used arrays instead! Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Installation of latest MDAC on CF4.5 SP2 - required or not ??
Recently, my ColdFusion application.log has started showing a few messages like this: Error,TID=1060,08/28/02,09:42:04,CFSCHEDULE,unknown exception conditionP PCodeRuntimeContextImp::executeSQLTagCFQuery::endTagpThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (167:4) to (167:79) in the template file EYOSCHEDULER.CFM./pPPDate/Time: 08/28/02 05:00:31BRBrowser: CFSCHEDULEBRQuery String: RequestTimeout=5000P Some further analysis shows that at the same time that the error was logged in my coldfusion server application.log file, there was also an entry in my Win 2K server's event viewer application.log file : Event Type: Information Event Source: DrWatson Event Category: None Event ID: 4097 Date: 8/28/2002 Time: 9:42:09 AM User: N/A Description: The application, , generated an application error The error occurred on 08/28/2002 09:42:09.323 The exception generated was c005 at address (nosymbols) I am running CF 4.5.1 SP2 Professional on Win 2K Server, with IIS 5 and SQL 2000 DB. However, it doesn't have the latest version of MDAC installed on it. Could that be causing these errors to happen ? Should I install the latest MDAC on my production web server ? A search on the ColdFusion Support Forums also shows me the above pcode errors may happen due to not using the cflock tag. Whenever you access (read or write) Application, Server, or Session variables in an application, you should use the CFLOCK tag. CFLOCK provides borders around the variable access, which in turn ensures the integrity of shared data. Using CFLOCK guarantees that multiple concurrently executing requests do not manipulate shared data structures, files, or CFXs in an inconsistent manner. The template in the above case reads a few application variables and repeatedly calls a CFX tag (upto 5000 times), as follows : cfquery name=generalquery datasource=#dns# username=#ua# password=#pwd# -- query goes here --- /cfquery where #dns#, #ua# and #pwd# are application variables defined in my application.cfm file. cfloop query=generalquery --- cfx tag call goes here --- /cfloop Should there be a CFLOCK around : a) the cfquery declaration ? b) the cfx call ? Note that the same CFX tag is used by other applications on my website as well. c) Each of them ? Hope someone can help me on this one. Vishal. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Outlook
Hi I am using CFMail to send email on certain action (when new task is created). It is for company's intranet and all emails are read using Microsoft Outlook. I was wondering is there anyway in that email i mention IF YOU WANT TO OWN TASK CLICK HERE. Now this Click Here should be a link which opens browser with href to page which deals with Owner ships of tasks. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web mail
I don't think so, but if you have a copy of CFWACK (as all CF developers should, thanks Ben ;-) it is in there, on page 591-599 if you have the third edition for CF4.0. -- Jay [EMAIL PROTECTED] Computer games don't affect kids, I mean if Pac Man affected us as kids, we'd all be running around in darkened rooms, munching pills and listening to repetitive music... - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 7:27 PM Subject: Re: web mail Didn't CF come shipped with an example web mail demo? I don't honestly recall as I didn't really look at it. -Novak - Original Message - From: JLH All Turbo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 8:30 AM Subject: web mail You guys know of a free or inexpensive, basic (or with a few features) CF web mail package? j __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with CFCONTENT
Don't use CFContent and if you want to delete the file use CFFile to delete. If you use cfcontent type=image you can never display text on that specific page as it is treated as an image file then. On thing you can try calling that page with CFContent(say blah.cfm) in another page using Img src=blah.cfm and display your text there like Image1: img src=blah.cfm.. I havent tried this thing but I think it might work. I am using Coldfusion Custom Tag to do the job. CFX_GetImage CFX_PutImage. It works perfect. Shahzad -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 01:15 To: CF-Talk Subject: Help with CFCONTENT Hi all, I was wondering if someone might be able to assist me. My problem is that I am trying to display an image that retrieved from a MS SQL Server database and display it back in a html page. The image displays correctly but I do not get any of my HTML appearing. Below is a sample of what I am trying to do - it is kind of sloppy (since its late here and I want to go home). I am sure that I am doing something stupid with cfcontent. Any help would be appreciated. Thanks Mario Ciliotta CODE Sample: cfheader name=pragma value=no-cache cfheader name=expires value=-1 !--- This code works correctly - I can save it to a db and retrieve it and create a file on the server --- cffile action=readbinary file=g:\inetpub\wwwroot\mario\oldpict.jpg variable=imagebinary cfquery name=test datasource=db_spri11503 INSERT INTO tbl_myImageTable ( filename, fileblob ) values ( 'old.jpg', '#tobase64(imagebinary)#') /cfquery cfquery name=test2 datasource=db_spri11503 Select * from tbl_myImageTable /cfquery cfset tobin = tobinary(test2.fileblob) cffile action=WRITE file=g:\inetpub\wwwroot\mario\old.jpg output=#tobin# addnewline=No !--- END WORKS Correctly --- !--- This code does not work correctly. I only see on my page the image called old.jpg. I get no text (Image 1 or image 2) and there is no new.jpg display. When I go to view the source - there is no source --- html head titleUntitled/title /head body Image 1: img src=new.jpgBR Image 2: cfcontent type=image/jpeg file=g:\inetpub\wwwroot\mario\old.jpg deletefile=No !--- End Does Not Work --- /body /html This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: List Length
Bruce Holm wrote: The lists in my application are either ID numbers or usernames. I don't believe there will ever be more than several hundred and never more than 1200. Arrays won't work well because I'm using lists to determine duplicates...searching for a duplicate username or ID in the list using ListFind(). Arrays are not great for searching since you have to loop through the entire array. But then maybe that's faster? Finding is OK for lists. What hurts is list manipulation, i.e. every time your list changes. For instance, building a list of 1000 itemns using a for loop is easily a 100 times slower as building a 1000 item array using a for loop. If you really need to build out of a loop, the best is to build an array in the loop and then convert it to a list using ArrayToList(). You should really look at the bigger picture and not just take into account the finding, but count the time for building the list as well. BTW, I am talking CF MX here. In previous versions the difference was much smaller. Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [OT] - MXDU.com
And, the only other 'public' topless event would be Mardi Gras. :) ~Todd On Wed, 28 Aug 2002, Paris Lundis wrote: yeah the US is mega uptight... too uptight... Heck even a cold Canadian providence approved pubic bare chested choice for women recently... The few sensible jurisdictions are in California and Florida most notably But the beaches tend to be private and hidden... Almost on the verge being some weird thing... -paris -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Managing Software Versions
If I needed to handle this, I'd do each version as a separate directory - i.e. http://mydomain/myapp/ver1/index.cfm and http://mydomain/myapp/ver2/index.cfm you could also put in a application layer, moving your code directly out the web path and using sessions to select which code base to use cfinclude template=/code/#request.session.app_version#/login.cfm z __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with CFCONTENT
Thanks Shahzad, I'll give it a try. Mario -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 5:10 AM To: CF-Talk Subject: RE: Help with CFCONTENT Don't use CFContent and if you want to delete the file use CFFile to delete. If you use cfcontent type=image you can never display text on that specific page as it is treated as an image file then. On thing you can try calling that page with CFContent(say blah.cfm) in another page using Img src=blah.cfm and display your text there like Image1: img src=blah.cfm.. I havent tried this thing but I think it might work. I am using Coldfusion Custom Tag to do the job. CFX_GetImage CFX_PutImage. It works perfect. Shahzad -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 01:15 To: CF-Talk Subject: Help with CFCONTENT Hi all, I was wondering if someone might be able to assist me. My problem is that I am trying to display an image that retrieved from a MS SQL Server database and display it back in a html page. The image displays correctly but I do not get any of my HTML appearing. Below is a sample of what I am trying to do - it is kind of sloppy (since its late here and I want to go home). I am sure that I am doing something stupid with cfcontent. Any help would be appreciated. Thanks Mario Ciliotta CODE Sample: cfheader name=pragma value=no-cache cfheader name=expires value=-1 !--- This code works correctly - I can save it to a db and retrieve it and create a file on the server --- cffile action=readbinary file=g:\inetpub\wwwroot\mario\oldpict.jpg variable=imagebinary cfquery name=test datasource=db_spri11503 INSERT INTO tbl_myImageTable ( filename, fileblob ) values ( 'old.jpg', '#tobase64(imagebinary)#') /cfquery cfquery name=test2 datasource=db_spri11503 Select * from tbl_myImageTable /cfquery cfset tobin = tobinary(test2.fileblob) cffile action=WRITE file=g:\inetpub\wwwroot\mario\old.jpg output=#tobin# addnewline=No !--- END WORKS Correctly --- !--- This code does not work correctly. I only see on my page the image called old.jpg. I get no text (Image 1 or image 2) and there is no new.jpg display. When I go to view the source - there is no source --- html head titleUntitled/title /head body Image 1: img src=new.jpgBR Image 2: cfcontent type=image/jpeg file=g:\inetpub\wwwroot\mario\old.jpg deletefile=No !--- End Does Not Work --- /body /html This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Date matchup help in Access 2000
Hello, I'm having some trouble getting dates to match up in Access 2000. This date thing is new to me and I think I'm close, just can't get everything lined up. I'm trying to pull records when the dates match. Here's my link, this works fine -- cfoutput query=getDates a href=articles.cfm?GetDate=#AddDate##DateFormat(AddDate, DD, )#/a /cfoutput Here's the query --- cfquery name=getteam datasource=#application.datasource# dbtype=ODBC Select AddDate, Title, Team from TBLteam WHERE AddDate = GetDate Order BY Team /cfquery This either gives me no records returned, gives me EVERY record in the list, or says it doesn't know what AddDate is as I've tried different configs. I've tried this with quotes, without quotes, using the DateFormat to try to format them correctly, using both GetDate and URL.GetDate and anything else I can think of and can't quite get it to match up. The version of CF is 4.5.2 and of course Access 2000. Please help so I can learn to love dates and not hate them as I do right now. Thanks, Bob Wilson FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 5 Installation error. Windows is looking for %1
Hi, I've tried installing / unstalling / reinstalling CF 5 Enterprise on a Win2K Pro server running Apache 2.0.40 (and that third party Apache module for CF 5) to no avail. When I click on Start Programs Macromedia ColdFusion Server 5 ColdFusion Administrator, it gives me the message: Windows is looking for %1. To locate the file yourself, click browse. Apache runs fine, and CFIDE is installed on Apache's webroot (C:\Program Files\Apache Group\Apache2\CFIDE\) I had MX installed on the same pc before, but uninstalled it. Any help greatly appreciated! Thanks in advance, Andrew __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Trouble with sessions and AOL ??
Hello, I have a login that tracks users with sessions and some people are having trouble with the login. ALL are AOL users. They complete the login screen and are immediately looped back to a blank login screen. It's working fine for all non-AOL users. Here is the application.cfm setting -- CFAPPLICATION NAME=foo CLIENTMANAGEMENT=YES SESSIONMANAGEMENT=YES SESSIONTIMEOUT=#CreateTimespan(0,0,90,0)# Here is the session checker at the top of the page post-login -- CFIF isDefined('Session.Auth') is NOT TRUE CFLOCATION url=subs_login.cfm cfelseif Session.Auth is NOT TRUE CFLOCATION url=subs_login.cfm CFELSE show the stuff they want /cfif Is there something better than IsDefined('Session.Auth') I can use to test to see if a session is in effect?? Is this what is tripping the AOL software?? Or do I need to remove this form of authentication to deal with AOL? The CF Server in use here is 4.5.2 Thanks for all your help, Bob Wilson FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
LDAP CF
When using CFLDAP to authenicate a login, does anyone know if it is possible to CLOSE that LDAP session or does it close automatically after the tag is completed the authenication? TIA! __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ccaching resultsets
Can you guys advise as to the best way to cache resultsets that are user specific. I have a situ whereby users are performing searches and doing a next/previous and I don't want to go to the DB everytime to get the results again but want to look at all of the ways of allowing the resultset to persist across requests __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
New CFMX Certification website - Any legal issues????
I am in the process of developing a website for CFMX Certification and going to release the site by the end of Sept Any issues to be addressed before releasing the website? Help!!! Any input or suggestions is appreciated.. Thank you.. Good Day. --Siva Girumala __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Regex problem
Sweet. Thanks for the new info. Jerry Johnson [EMAIL PROTECTED] 08/27/02 03:54PM That's not 100% true. 1. If the first character of a set is a close bracket and there's no open bracket in the set, then it will match: []0-9] will match ]0123456789 2. If the open bracket is anywhere in the set without a close bracket, it'll match: [0-9[] will match [0123456789 [[0-9] will match [0123456789 3. If you set a range in your set that starts with an open bracket and goes until a tilde, then it'll match: [[-^] will match [/]^ 4. If you use a grouping with a pipe, you can fake the brackets: (\[|/]|[0-9]) will match []0123456789 And you can always use the [[:punct:]]. :) From the Advanced Cold Fusion 5 Application Development, by Ben Forta, page 230: [ and ] Brackets delimit a character class and are not allowed within the class itself. Cold Fusion RegEx does not allow them as escaped characters. Of course, the [:punct:] class handles them as well as all the other brackets, so you COULD use that. But I have often replaced them with another (unused) pair of characters to allow regex to work. Jerry Johnson [EMAIL PROTECTED] 08/27/02 02:19PM Hi there, I'm having a problem in CF5 - if I try to use a regular expression to match a pattern that contains either the [ or ] characters, the find fails. I've already tried escaping each and using ascii character codes instead of the actual character, but I can't seem to make it work. If I change the text to use ( and ) or { and } and escape them properly, the regex find works as expected. Is this a known problem? Is there a workaround? Thanks, Matt __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: CFQuery, Oracle and Limiting rows
I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
Rob I have asked a similar question on this forum - I think the best bet is to cache the query results and then use the query a query functionality (assuming you are using CF5 or above). How best to cache the query will depend on whether the results are specific to users or not. If not then you can cache in the Application scope. If it is specific to users then I think you can cache in the session scope although my questio (which I am still awaiting responses to) asks how best to do this... Andy -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 14:43 To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Date matchup help in Access 2000
Try this as your query instead SELECT AddDate, Title, Team FROM TBLteam WHERE AddDate = #CreateODBCDate(Url.GetDate)# ORDER BY Team ~Val - Original Message - From: Bob Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 9:24 AM Subject: Date matchup help in Access 2000 Hello, I'm having some trouble getting dates to match up in Access 2000. This date thing is new to me and I think I'm close, just can't get everything lined up. I'm trying to pull records when the dates match. Here's my link, this works fine -- cfoutput query=getDates a href=articles.cfm?GetDate=#AddDate##DateFormat(AddDate, DD, )#/a /cfoutput Here's the query --- cfquery name=getteam datasource=#application.datasource# dbtype=ODBC Select AddDate, Title, Team from TBLteam WHERE AddDate = GetDate Order BY Team /cfquery This either gives me no records returned, gives me EVERY record in the list, or says it doesn't know what AddDate is as I've tried different configs. I've tried this with quotes, without quotes, using the DateFormat to try to format them correctly, using both GetDate and URL.GetDate and anything else I can think of and can't quite get it to match up. The version of CF is 4.5.2 and of course Access 2000. Please help so I can learn to love dates and not hate them as I do right now. Thanks, Bob Wilson FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Coldfusion Hiermenus Newstickers
Hi I have a news ticker that sits just below a menu system that uses hiermenus. When the menus drop down the newsticker overlays the menu, in the same way a form select box does. But this only happens in Internet Explorer 5 and below, in Internet Explorer 6 it works fine. Any ideas on what could cause this strange event? and can it be solved, anybody had any experiences with this? Ian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
I had the same problem. I used a next/previous button system that showed 10 records at a time. If this is what you're looking for I'll post the code. Phil -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
I've got code that does that already. (thanks for the offer anyway). my problem is that when I click the button to go to the next one hundred, the cfquery still returns 5000+ records but the cfloop goes to start row 101 and end row 200. I'm looking at possibilities with oracle's ROWNUM psudofield. If I figure out anything on my own, I'll post it here. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:01 AM To: CF-Talk Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows I had the same problem. I used a next/previous button system that showed 10 records at a time. If this is what you're looking for I'll post the code. Phil -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CVS
I hope this was an attempt at humor. CVS is a source control system (Concurrent Versioning System) that allows simultaneous editing of a given file. On the client side, I strongly recommend using WinCVS Tortoise in combination. http://www.wincvs.org/ http://www.tortoisecvs.org/ CVS support is not integral to CF Studio like MS SourceSafe is. Pete - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 5:14 PM Subject: Re: CVS CVS is a drug store. CSV stands for comma-separated values which is a text file that uses commas (or other characters, most notably tabs) to separate data values. Usually used as a text dump of data. What is a CVS and where can I learn more about it? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
Sorry, just re-read the post. My code relys on ordered number list. Since your id's are all unique it won't work for you. good luck Phil -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:01 AM To: CF-Talk Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows I had the same problem. I used a next/previous button system that showed 10 records at a time. If this is what you're looking for I'll post the code. Phil -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Web Hosting services for ColdFusion
Hi I am going to release a website for CFMX certification in a shortwhile. I would like to know about the hosting services for Coldfusion... Please mention few names either free/charge basis... Thank you --Siva Girumala __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slightly OT: CFQuery, Oracle and Limiting rows
Edwards Robert (air0rae) wrote: I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). That is long. What are you doing, table scan on a million rows? Full text searching? Get somebody who knows Oracle to look at the query and the database schema. If ODBC, set a blockfactor of 100, it might save half a second :) I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) I think it is unlikely that there is a solution for this in the area of getting just a part of the resultset. You could use WHERE rowcount BETWEEN 100 AND 200 to get the second batch of 100 records back, but I don't think that would matter much for your query execution time (you need an ORDER BY with that which in turn means that internally the db still has to get all rows). If you need better performance, look at the database setup, or losen the realtime restriction (technically your current setup is not realtime anyway because Oracle uses MVCC). Sometimes it might be an option to just give the user the first 300 results and ask them to modify their query to be more specific (need to see the explain output to see if that can be used to reduce runtime). Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What does the error mean?
I have gotten this error once while working remotely on a file and then viewing it in the browser very quickly between changes. I am not positive about what caused the duplicate class file, but it may have been that I tried to view the page before it had updated (compiled the class?)completely on the remote server... At any rate, I deleted the duplicate class file/s located in CFusionMX/wwwroot/WEB-INF/cfclasses/ and the error has never reappeared. Good luck, Mike -Original Message- From: Ali Daniali [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 7:36 PM To: CF-Talk Subject: What does the error mean? Error Occurred While Processing Request Errors reported by Java compiler: Found 1 semantic error compiling C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfLogin2ecfm1727608710.java __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
Actually, upon further review my code doesn't rely on ordered numbers. I'll post the code anyway, it may benefit someone on the list. !--- Previous Next buttons --- CFSET MaxRows = 10 CFPARAM name=start default=1 CFQUERY datasource=cnyidea name=customers SELECT CompanyName, CustomerID FROM Customers WHERE CategoryID = 1001 ORDER BY CompanyName /cfquery CFSET PrevStart = Start - MaxRows CFSET NextStart = Start + MaxRows CFSET current = StartCFIF PrevStart GTE 1 CFOUTPUT FORM action=sometemplate.cfm method=post INPUT type=hidden name=start value=#PrevStart# INPUT type=Image(you could also use submit button src=../images/oldideas2.gif border=0 /form /cfoutput /cfif /td td valign=bottom CFIF NextStart LTE customers.RecordCount CFOUTPUT FORM action=sometemplate.cfm method=post INPUT type=hidden name=start value=#NextStart# INPUT type=Image(you could also use submit button src=yourimagehere border=0 /form /cfoutput /cfif !--- END Previous Next buttons --- -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:08 AM To: CF-Talk Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows I've got code that does that already. (thanks for the offer anyway). my problem is that when I click the button to go to the next one hundred, the cfquery still returns 5000+ records but the cfloop goes to start row 101 and end row 200. I'm looking at possibilities with oracle's ROWNUM psudofield. If I figure out anything on my own, I'll post it here. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:01 AM To: CF-Talk Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows I had the same problem. I used a next/previous button system that showed 10 records at a time. If this is what you're looking for I'll post the code. Phil -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CVS
CVS stands for Concurrent Versioning System. Information about it can be found at http://www.cvshome.org/. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 2:14 PM To: CF-Talk Subject: Re: CVS CVS is a drug store. CSV stands for comma-separated values which is a text file that uses commas (or other characters, most notably tabs) to separate data values. Usually used as a text dump of data. What is a CVS and where can I learn more about it? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
reading files into an array
How would I read a file into an array, where each array element is a single line from the file? I want to take a string, pick a delimiter, and chop up that string via the delimiter and return an array Thanks -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: reading files into an array
Loop through the list(your string with a chosen delimiter) and ArrayAppend the elements to your Array Ade -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 15:31 To: CF-Talk Subject: reading files into an array How would I read a file into an array, where each array element is a single line from the file? I want to take a string, pick a delimiter, and chop up that string via the delimiter and return an array Thanks -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
Assuming you can do *TOP* within Oracle (i don't use it, so i don't know) and there is *any* field you can order by, the following works great for me (for SQL Server): select top X item_ID fromattorney where attorney_ID in ( select top Y attorney_ID fromattorney order byattorney_ID DESC ) order byattorney_ID where x = total number of rows you want and y = total_records - start_row if i have 1000 rows and want records 1 - 10 x = 10 y = 1000 - 1 + 1 = 1000 if i want 401 - 420 x = 20 y = 1000 - 401 + 1 = 600 Hope that helps. - j jim curran technical director nylon technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: reading files into an array
whats the delimiter for a newline and carriage return? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: reading files into an array
CHR(13)CHR(10) -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:43 AM To: CF-Talk Subject: Re: reading files into an array whats the delimiter for a newline and carriage return? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: reading files into an array
oi Adrian!! why loop. just to an listToArray(list,CHR(13)CHR(10)) -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Wednesday, August 28, 2002, 10:35:13 AM, you wrote: AL Loop through the list(your string with a chosen delimiter) and ArrayAppend AL the elements to your Array AL Ade AL -Original Message- AL From: Chris Edwards [mailto:[EMAIL PROTECTED]] AL Sent: 28 August 2002 15:31 AL To: CF-Talk AL Subject: reading files into an array AL How would I read a file into an array, where each array element is a single AL line from the file? AL I want to take a string, pick a delimiter, and chop up that string via the AL delimiter and return an array AL Thanks AL -- AL Chris Edwards AL Web Application Developer AL Outer Banks Internet, Inc. AL 252-441-6698 AL [EMAIL PROTECTED] AL http://www.OuterBanksInternet.com AL __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: reading files into an array
Just remember that you can't tell CF to use multiple characters as a delim. I should say - multiple characters as ONE delim. If you pass AB as delimiters to a list func, it will teat both A and B as delims, not the string AB. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:46 AM To: CF-Talk Subject: RE: reading files into an array CHR(13)CHR(10) -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:43 AM To: CF-Talk Subject: Re: reading files into an array whats the delimiter for a newline and carriage return? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5 Installation error. Windows is looking for %1
I'm no expert, but sounds like it is trying to run a batch file with no arguments? -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:13 AM To: CF-Talk Subject: CF 5 Installation error. Windows is looking for %1 Hi, I've tried installing / unstalling / reinstalling CF 5 Enterprise on a Win2K Pro server running Apache 2.0.40 (and that third party Apache module for CF 5) to no avail. When I click on Start Programs Macromedia ColdFusion Server 5 ColdFusion Administrator, it gives me the message: Windows is looking for %1. To locate the file yourself, click browse. Apache runs fine, and CFIDE is installed on Apache's webroot (C:\Program Files\Apache Group\Apache2\CFIDE\) I had MX installed on the same pc before, but uninstalled it. Any help greatly appreciated! Thanks in advance, Andrew __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: reading files into an array
Oi Crits, true :O) -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 15:38 To: CF-Talk Subject: Re[2]: reading files into an array oi Adrian!! why loop. just to an listToArray(list,CHR(13)CHR(10)) -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Wednesday, August 28, 2002, 10:35:13 AM, you wrote: AL Loop through the list(your string with a chosen delimiter) and ArrayAppend AL the elements to your Array AL Ade AL -Original Message- AL From: Chris Edwards [mailto:[EMAIL PROTECTED]] AL Sent: 28 August 2002 15:31 AL To: CF-Talk AL Subject: reading files into an array AL How would I read a file into an array, where each array element is a single AL line from the file? AL I want to take a string, pick a delimiter, and chop up that string via the AL delimiter and return an array AL Thanks AL -- AL Chris Edwards AL Web Application Developer AL Outer Banks Internet, Inc. AL 252-441-6698 AL [EMAIL PROTECTED] AL http://www.OuterBanksInternet.com AL __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: reading files into an array
See my earlier post. This code will use two characters as delims, not the string #chr(13)##chr(10)#. In this case, it probably won't hurt anything, but I just want to make sure people remember the point. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:38 AM To: CF-Talk Subject: Re[2]: reading files into an array oi Adrian!! why loop. just to an listToArray(list,CHR(13)CHR(10)) -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: reading files into an array
I mean untrue :OD -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 15:53 To: CF-Talk Subject: RE: Re[2]: reading files into an array Oi Crits, true :O) -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 15:38 To: CF-Talk Subject: Re[2]: reading files into an array oi Adrian!! why loop. just to an listToArray(list,CHR(13)CHR(10)) -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Wednesday, August 28, 2002, 10:35:13 AM, you wrote: AL Loop through the list(your string with a chosen delimiter) and ArrayAppend AL the elements to your Array AL Ade AL -Original Message- AL From: Chris Edwards [mailto:[EMAIL PROTECTED]] AL Sent: 28 August 2002 15:31 AL To: CF-Talk AL Subject: reading files into an array AL How would I read a file into an array, where each array element is a single AL line from the file? AL I want to take a string, pick a delimiter, and chop up that string via the AL delimiter and return an array AL Thanks AL -- AL Chris Edwards AL Web Application Developer AL Outer Banks Internet, Inc. AL 252-441-6698 AL [EMAIL PROTECTED] AL http://www.OuterBanksInternet.com AL __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: reading files into an array
oi Raymond!! but you could use #CHR(13)CHR(10#, yeah? -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Wednesday, August 28, 2002, 10:48:08 AM, you wrote: RC Just remember that you can't tell CF to use multiple characters as a RC delim. I should say - multiple characters as ONE delim. If you pass AB RC as delimiters to a list func, it will teat both A and B as delims, not RC the string AB. RC === RC Raymond Camden, ColdFusion Jedi Master for Hire RC Email: [EMAIL PROTECTED] RC Yahoo IM : cfjedimaster RC My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:46 AM To: CF-Talk Subject: RE: reading files into an array CHR(13)CHR(10) -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:43 AM To: CF-Talk Subject: Re: reading files into an array whats the delimiter for a newline and carriage return? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com RC __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[3]: reading files into an array
oi Critter!! well #CHR(13)CHR(10)# not nuff coffee -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Wednesday, August 28, 2002, 10:51:50 AM, you wrote: C oi Raymond!! C but you could use #CHR(13)CHR(10#, yeah? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Forcing Output to a Specific Length
I need to have some outputted data forced to have a certain length For example, take the two following bits of data ( #myStreet# and #myCity#) on one line: 234 Pine StreetSmallville Each of these needs to be exactly 35 characters in length. If the data doesn't fill the entire 35 characters, then it's padded with spaces to make it 35. I know how to do this with numbers using NumberFormat, but I've never had to do it with text before. This is going into a file that to be imported into a specific processing application on a mainframe that needs to see it this way... Somebody please point me in the right direction? TIA, Les __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Learning Tree
Has anyone had any experience with Learning Tree International training group? Looking for a good training group. You can reply to [EMAIL PROTECTED] off list if you wish Thank You Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[3]: reading files into an array
No. I mean, yes, you CAN use it - but CF does NOT treat it as one delimiter. It treats it as two delimiters. I'm being anal here I guess - I just want to make sure people understand the difference. Saying that Chr(13)Chr(10) is a delimiter is different from saying Chr(13) and Chr(10) are delimiters. CF list functions do not support the idea of multi-character delimiters. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:58 AM To: CF-Talk Subject: Re[3]: reading files into an array oi Critter!! well #CHR(13)CHR(10)# not nuff coffee -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Wednesday, August 28, 2002, 10:51:50 AM, you wrote: C oi Raymond!! C but you could use #CHR(13)CHR(10#, yeah? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forcing Output to a Specific Length
There might be an easier way, but I can see this getting messy. Count the number of chars in the string, get the difference if there is one, then loop over the string wacking in as many $nbsp; as you need. Ade -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 16:05 To: CF-Talk Subject: Forcing Output to a Specific Length I need to have some outputted data forced to have a certain length For example, take the two following bits of data ( #myStreet# and #myCity#) on one line: 234 Pine StreetSmallville Each of these needs to be exactly 35 characters in length. If the data doesn't fill the entire 35 characters, then it's padded with spaces to make it 35. I know how to do this with numbers using NumberFormat, but I've never had to do it with text before. This is going into a file that to be imported into a specific processing application on a mainframe that needs to see it this way... Somebody please point me in the right direction? TIA, Les __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forcing Output to a Specific Length
PadString http://www.cflib.org/udf.cfm?ID=152 === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:05 AM To: CF-Talk Subject: Forcing Output to a Specific Length I need to have some outputted data forced to have a certain length For example, take the two following bits of data ( #myStreet# and #myCity#) on one line: 234 Pine StreetSmallville Each of these needs to be exactly 35 characters in length. If the data doesn't fill the entire 35 characters, then it's padded with spaces to make it 35. I know how to do this with numbers using NumberFormat, but I've never had to do it with text before. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5 Installation error. Windows is looking for %1
Can you browse to the admin via http://localhost/cfide/administrator/index.cfm (localhost or whatever IP you installed it on?) - that's all the shortcut is pointing at...you might just need to recreate the shortcut pointing at the correct location. Jb. -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 14:13 To: CF-Talk Subject: CF 5 Installation error. Windows is looking for %1 Hi, I've tried installing / unstalling / reinstalling CF 5 Enterprise on a Win2K Pro server running Apache 2.0.40 (and that third party Apache module for CF 5) to no avail. When I click on Start Programs Macromedia ColdFusion Server 5 ColdFusion Administrator, it gives me the message: Windows is looking for %1. To locate the file yourself, click browse. Apache runs fine, and CFIDE is installed on Apache's webroot (C:\Program Files\Apache Group\Apache2\CFIDE\) I had MX installed on the same pc before, but uninstalled it. Any help greatly appreciated! Thanks in advance, Andrew __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forcing Output to a Specific Length
#LJustify(myStreet,35)##LJustify(myCity,35)# -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] I need to have some outputted data forced to have a certain length For example, take the two following bits of data ( #myStreet# and #myCity#) on one line: 234 Pine StreetSmallville Each of these needs to be exactly 35 characters in length. If the data doesn't fill the entire 35 characters, then it's padded with spaces to make it 35. I know how to do this with numbers using NumberFormat, but I've never had to do it with text before. This is going into a file that to be imported into a specific processing application on a mainframe that needs to see it this way... Somebody please point me in the right direction? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
unresponsive threads crashing cf
I am having a problem with unresponsive threads crashing the server. It seems that they are not being released even after they exceed the timeout specified in cf administrator(90 seconds). It took over 37 minutes for the same template to generate unresponsive threads. Why doesn't CF drop them when they exceed the time limit? Information,238,08/28/02,05:52:49,,The ColdFusion Application Server started. Warning,88,08/28/02,06:53:12,,Template: D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 101 seconds. Warning,304,08/28/02,06:53:13,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 102 seconds. Warning,426,08/28/02,07:06:19,,A request exceeded the timeout. The unresponsive thread count is up to 1. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:06:19,, !! CFTrace::logThread(304) has no entry for thread 304 Warning,426,08/28/02,07:12:19,,A request exceeded the timeout. The unresponsive thread count is up to 2. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:12:19,, !! CFTrace::logThread(324) has no entry for thread 324 Warning,426,08/28/02,07:16:49,,A request exceeded the timeout. The unresponsive thread count is up to 3. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:16:49,, !! CFTrace::logThread(88) has no entry for thread 88 Warning,426,08/28/02,07:18:19,,A request exceeded the timeout. The unresponsive thread count is up to 4. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:18:19,, !! CFTrace::logThread(464) has no entry for thread 464 Warning,426,08/28/02,07:21:19,,A request exceeded the timeout. The unresponsive thread count is up to 5. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:21:19,, !! CFTrace::logThread(327) has no entry for thread 327 Warning,426,08/28/02,07:43:49,,A request exceeded the timeout. The unresponsive thread count is up to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:43:49,, !! CFTrace::logThread(568) has no entry for thread 568 Warning,426,08/28/02,07:55:49,,A request exceeded the timeout. The unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:55:49,, !! CFTrace::logThread(129) has no entry for thread 129 Warning,554,08/28/02,07:56:44,,Template: D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 210 seconds. Information,129,08/28/02,07:56:45,,A long-running request returned. The unresponsive thread count is down to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm]. Warning,129,08/28/02,07:56:45,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 211 seconds. Warning,426,08/28/02,08:00:19,,A request exceeded the timeout. The unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:00:19,, !! CFTrace::logThread(308) has no entry for thread 308 Warning,426,08/28/02,08:04:49,,A request exceeded the timeout. The unresponsive thread count is up to 8. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:04:49,, !! CFTrace::logThread(554) has no entry for thread 554 Warning,426,08/28/02,08:07:49,,A request exceeded the timeout. The unresponsive thread count is up to 9. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:07:49,, !! CFTrace::logThread(129) has no entry for thread 129 Fatal,426,08/28/02,08:09:19,,Unresponsive thread threshold reached. Restarting service. Information,177,08/28/02,08:09:23,,The ColdFusion Application Server started. (ETC) The template uses a custom tag call that does a cfhttp call to another template on the same server, trying my hand at a pseudo web service. Basically: 1. Template calls custom tag for validation. 2. Custom tag calls (local/same cf server) web service url 3. Web service url/template checks if local cache(ms sql db) if user validation expired. If not expired and validates properly, returns 1. 4. If expired: Calls a third party web service, which we validate against. Validation fails, return 0 Validation succeeds, insert to local db cache, return 1 I hope that makes sense. Could that cause problems? I would guess that it would take two threads as one template calls another... But that shouldn't be to bad. We've tried tweaking cf administrator a bit, but we're not really sure which setting to play with. Thanks for any help. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: reading files into an array
I remember a while back getting stuck when I was trying to write a search feature that would use and/or keywords, I kept trying to use and and or as list delimiters until I eventually figured out that wouldn't work, since I was going to wind up with list elements like baseball = b,seb,ll meandering = me,,,eri,g element = eleme,t crystal = cryst,l bandaid = bi, So I ended up replacing and and or with non-printing characters and using those as delimiters instead Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 See my earlier post. This code will use two characters as delims, not the string #chr(13)##chr(10)#. In this case, it probably won't hurt anything, but I just want to make sure people remember the point. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:38 AM To: CF-Talk Subject: Re[2]: reading files into an array oi Adrian!! why loop. just to an listToArray(list,CHR(13)CHR(10)) -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
Here's what i came up with (this is oracle 8.i+ specific) Select * from ( Obscenely long and complex query RANK() OVER (ORDER BY some_col ASC NULLS LAST) as Row_Rank ) Where Row_Rank between #startrow# and #endrow# This gives me 100 rows back at a time. I'm still getting an obscene time in the query so i'm trying to come up with ways to speed things up a little more. One idea is to rank on the primary table first as a subquery and then do the complex joins using the where in (subquery) clause so i only join on 100 rows at a time instead of 5000+. Another is to slightly denormalize (currently i have a complex left between join using ipranges) to speed up processing. Some background on this project (what little i am allowed to reveal): This is a tool that runs on every machine and checks in with a webserver/database on a given interval. The web server sets the interval by returning a time code. Lots of data sent in a small package including Mac address and ip address. Our IP addresses are broken down by building, so if i want to see machines in a given building i do something like (Where ipoc1 between ipocb1 and ipoce1 and ipco2 between ipcob2 and ipoce2 and ipoc3 between ipocb3 and ipoce3 and ipoc4 between ipocb4 and ipcoe4) with left joins done on the between to get null for any areas not in the iprange (the above code is basicly finding between each octet in the ip address). Yes, this does need to be real time so i can see at any given moment what machines are where and other information. One possibility is to determine the building when checking in and inserting the building name or id in the main table so i don't have to do 4 between joins for every ip address. Hence, the slight denormalization. Thanks for all the help though. Currently the processing time for all the rows is about 57000 milliseconds (57 seconds). If i get it working through the denormalization i'll post the time improvement here if anyone is interested. Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:35 AM To: CF-Talk Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows Assuming you can do *TOP* within Oracle (i don't use it, so i don't know) and there is *any* field you can order by, the following works great for me (for SQL Server): select top X item_ID fromattorney where attorney_ID in ( select top Y attorney_ID fromattorney order byattorney_ID DESC ) order byattorney_ID where x = total number of rows you want and y = total_records - start_row if i have 1000 rows and want records 1 - 10 x = 10 y = 1000 - 1 + 1 = 1000 if i want 401 - 420 x = 20 y = 1000 - 401 + 1 = 600 Hope that helps. - j jim curran technical director nylon technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:43 AM To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:
Re: List Length
I built the list using the ValueList() function of a query column. Seems to be fast. I'm also using CF 5 still. Thanks all for your help. I was thinking there was a small upper limit to list vars, something in the 255 range but that is the limit to using a list in a query WHERE clause i.e. WHERE id IN (1,2,3,4,255) THis is where I believe the 255 limit applies to a list. I would guess this is an Oracle Db SQL limitation? Bruce - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 3:24 AM Subject: Re: List Length Bruce Holm wrote: The lists in my application are either ID numbers or usernames. I don't believe there will ever be more than several hundred and never more than 1200. Arrays won't work well because I'm using lists to determine duplicates...searching for a duplicate username or ID in the list using ListFind(). Arrays are not great for searching since you have to loop through the entire array. But then maybe that's faster? Finding is OK for lists. What hurts is list manipulation, i.e. every time your list changes. For instance, building a list of 1000 itemns using a for loop is easily a 100 times slower as building a 1000 item array using a for loop. If you really need to build out of a loop, the best is to build an array in the loop and then convert it to a list using ArrayToList(). You should really look at the bigger picture and not just take into account the finding, but count the time for building the list as well. BTW, I am talking CF MX here. In previous versions the difference was much smaller. Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List Length
I ran into a problem with a list in a query to an Oracle DB of over 1000 items. We hacked a work-around to break up large lists into several pieces linked with ORs. Strangely, sub-queries that returned more than 1000 records posed no problem whatsoever. -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:35 AM To: CF-Talk Subject: Re: List Length I built the list using the ValueList() function of a query column. Seems to be fast. I'm also using CF 5 still. Thanks all for your help. I was thinking there was a small upper limit to list vars, something in the 255 range but that is the limit to using a list in a query WHERE clause i.e. WHERE id IN (1,2,3,4,255) THis is where I believe the 255 limit applies to a list. I would guess this is an Oracle Db SQL limitation? Bruce - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 3:24 AM Subject: Re: List Length Bruce Holm wrote: The lists in my application are either ID numbers or usernames. I don't believe there will ever be more than several hundred and never more than 1200. Arrays won't work well because I'm using lists to determine duplicates...searching for a duplicate username or ID in the list using ListFind(). Arrays are not great for searching since you have to loop through the entire array. But then maybe that's faster? Finding is OK for lists. What hurts is list manipulation, i.e. every time your list changes. For instance, building a list of 1000 itemns using a for loop is easily a 100 times slower as building a 1000 item array using a for loop. If you really need to build out of a loop, the best is to build an array in the loop and then convert it to a list using ArrayToList(). You should really look at the bigger picture and not just take into account the finding, but count the time for building the list as well. BTW, I am talking CF MX here. In previous versions the difference was much smaller. Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Solved/CF 5 Installation error. Windows is looking for %1
Can you browse to the admin via http://localhost/cfide/administrator/index.cfm No I couldn't, but it was because I placed the CFIDE folder in the wrong directory (duh). Now I can get into CFIDE just fine, despite the error in the shortcut which I suspect can be easily recreated. Thanks for your help! Andrew __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFDUMP issue
Has anyone had an issues with CFdump? It doesn't happen to me all the time, but now and then ... my page just starts throwing itself into a recursive loop and ... I swear this code isn't complicated at all. It only happens when debugging is on and I'm trying to cfdump something. I'm pretty sure I brought this up before, but I don't think I got any response. I thought I'd bring this up again. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slightly OT: CFQuery, Oracle and Limiting rows
Edwards Robert (air0rae) wrote: One idea is to rank on the primary table first as a subquery and then do the complex joins using the where in (subquery) clause so i only join on 100 rows at a time instead of 5000+. Another is to slightly denormalize (currently i have a complex left between join using ipranges) to speed up processing. That should help. Some background on this project (what little i am allowed to reveal): This is a tool that runs on every machine and checks in with a webserver/database on a given interval. The web server sets the interval by returning a time code. Lots of data sent in a small package including Mac address and ip address. Our IP addresses are broken down by building, so if i want to see machines in a given building i do something like (Where ipoc1 between ipocb1 and ipoce1 and ipco2 between ipcob2 and ipoce2 and ipoc3 between ipocb3 and ipoce3 and ipoc4 between ipocb4 and ipcoe4) with left joins done on the between to get null for any areas not in the iprange (the above code is basicly finding between each octet in the ip address). I thought Oracle had IP and MAC datatypes? If you just need to see what is where NOW, this screams for a second table with just the latest data. Just put a trigger on the table you have now and insert whatever is inserted there into a second table. Upon insert in that second table, fire a trigger that deletes the old entry for that machine. That way you should have a quite small table with just the latest data, and use the big table only if you need historic data. (You could achieve the same using partial indexes and a boolean, but I don't know if Oracle supports partial indexes.) Yes, this does need to be real time so i can see at any given moment what machines are where and other information. Well, currently it isn't realtime. You are about 57 seconds behind. And if 10 people hit the application at the same time and the available resources are distributed equally you are 10 times 57 seconds behind (baring caching etc.). One possibility is to determine the building when checking in and inserting the building name or id in the main table so i don't have to do 4 between joins for every ip address. Hence, the slight denormalization. Seeing the query helps. Seeing the explain output helps even more. Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Big problem- session vars not saved in IE6 on CF5
I am having a big problem with an old standard login system. This is the most simple login system I know and have used it for years. It consists of: Login form page Login action page Main page Session variables tracking who is logged in The user enters in their login acct, the action page compares it against the db, then sets some session variables and uses cflocation to forward them to a new page or back to the login page if they fail. The application page checks for the session variable to see if they're logged in and uses cflocation to send them back to the login page if the var doesn't exist. Up until August 19 it worked fine on all browsers. After then, it works fine on about 75% of the instances of IE6 in our enterprise. It fails on about 1 out of 4 IE installations including my own! What happens is the user logs in, the database accepts the login and uses cflocation to send them to the main page. Then Application.cfm checks to see if they have the correct session variable and uses cflocation to forward them to the login page. I can display the session vars at the bottom of the login action page during testing, but as soon as I turn cflocation back on, the session variables do not exist on the main page after the action page. They disappear. Yes they exist on most instances of IE and they exist in every single instance of NS that I tested. I have a working version of IE 6 that can login with no problem- I have modified my internet options (ESPECIALLY the cookies/privacy options) to match that machine exactly, but still the problems persist on my machine. The only thing that I did that could have affected this on August 19 was that I remember that morning getting a request to log into MS Passport to access my hotmail account. Other than that, I changed none of this code. Since 25% of our users seem to be affected by this problem, it's a big deal for us. I have asked EVERYONE about this and no one has seen this one before. Have any of you heard about this before or does anyone have any suggestions of how to go about debugging this? Thanks, Don Smith __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDUMP issue
Show us your code -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 16:58 To: CF-Talk Subject: CFDUMP issue Has anyone had an issues with CFdump? It doesn't happen to me all the time, but now and then ... my page just starts throwing itself into a recursive loop and ... I swear this code isn't complicated at all. It only happens when debugging is on and I'm trying to cfdump something. I'm pretty sure I brought this up before, but I don't think I got any response. I thought I'd bring this up again. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Issue with text database on Unix
Yup. Still treated is as numeric. I wound up having to put a dummy row in the file with text in those columns to force the driver to treat them as text. Ugly, but it works. Steve -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 7:10 PM To: CF-Talk Subject: Re: Issue with text database on Unix have you tried saving the CSV file with double quotes () around the text column? Dick On Tuesday, August 27, 2002, at 12:55 PM, Steven Monaghan wrote: I configured a data source, and can now query any csv file I drop into a directory. The only issue I am having, is that sometimes, a text column only has numeric data. The driver assumes that since the column only contains numeric data, that the column is numeric. So, any reference to this column as a string (ie DESCRIPTION NE '') fails on a datatype error. Does anyone know how to tell CF/Merant ODBC Text driver that this column is a text column? TIA, Steve Monaghan - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: List Length
Bruce Holm wrote: I built the list using the ValueList() function of a query column. Seems to be fast. I think it is (it is quite easy to test). But if you use ArrayToList(queryname[columnname]) I know for sure :) Thanks all for your help. I was thinking there was a small upper limit to list vars, something in the 255 range but that is the limit to using a list in a query WHERE clause i.e. WHERE id IN (1,2,3,4,255) THis is where I believe the 255 limit applies to a list. I would guess this is an Oracle Db SQL limitation? Don't know. Have you tried using cfqueryparam? Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDUMP issue
Has anyone had an issues with CFdump? Todd, I had the same problem before, but it's probably not the same problem... at least not exactly. I had a huge tree structure that I was dumping, but on the root node, there was an array of references to the different tree nodes. For example: - Root Node |- Node 1 |- Node 2 ||- Sub Node 1 ||- Sub Node 2 | |- array of Node References |- [1] : reference to root node |- [2] : reference to node 1 |- [3] : reference to node 2 |- [4] : reference to sub node 1 |- [5] : reference to sub node 2 The problem with dumping this variable is that it would start dumping the root node, then the child nodes, then it would hit array and dump the root node, then the child nodes, then it would hit the array again... etc. If your data structure is complex, you might look into that. Otherwise, I'm not sure. Ben Johnson Information Architect www.architekture.com [p] 720.934.2179 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDUMP issue
Too long and scattered to list. I read Ben's email and I think that's my issue. I do have a 2D Array, but it's not that complicated. It's flipping out on a 2D array and spinning into a crazy loop. It's just weird. ~Todd On Wed, 28 Aug 2002, Adrian Lynch wrote: Show us your code -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 16:58 To: CF-Talk Subject: CFDUMP issue Has anyone had an issues with CFdump? It doesn't happen to me all the time, but now and then ... my page just starts throwing itself into a recursive loop and ... I swear this code isn't complicated at all. It only happens when debugging is on and I'm trying to cfdump something. I'm pretty sure I brought this up before, but I don't think I got any response. I thought I'd bring this up again. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Semi OT question: Skills for jobs
Hey guys and gals and code monkeys, it's come to my attention that Employers are looking for someone with a wide range of skills For example, one required that you know C++, Coldfusion, ASP, Dreamweaver, VBScript, Java, Adobe Photoshop, Macromedia Flash... Oh, and it would be a PLUS if you know nuclear physics and how to cook french cuisine. Jokes aside, is this fair? I mean I know few people who know all of these at once. Few...like 1!!! Are these employers just dropping skills without considering their relationship? And also, there are sites like freelance.com or elance.com that allows coders to bid on projects, and the $$ offered on these projects are crazy. FOr example, someone wanted an auction site like ebay. Max bid allowed was $200. I contacted the project poster, and his answer was..well, since there is so many free code you can get online, I assume the programmer only has to put them together to make the auction site. How does this make you feel? What is the percieved view on programmers? Maybe I'm just whining. Maybe I'm just not over the dot com hey-days when code monkeys were gods with shorts and sandals at work. Mr. Forta, and dude from Figleaf, I would really appreciate your take on this one. Phoeun __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Big problem- session vars not saved in IE6 on CF5
I too have seen this on one of our client's server, that I do not manage. Where I first found it was a job app that used different includes for different jobs. When the data was inserted into the database about 15%-20% of the records would not have a value from the session. Thus you could not tell what job they were applying for. I never did track down the exact problem I fix it by passing the job ID in the url line. Are cookies enabled? Check to see if IE is set to default security settings. Under some of the higher settings cookies are disabled and since sessions are tracked via the CFID and CFTOKEN cookies session vars will not work. You can turn on Debugging Options - Show Variables on the server and check to see if the CFID and CFTOKEN cookies are being written. That will show up in the browser under the CGI Variables: HTTP_COOKIE If you find the problem please let me know. So far this has not been a problem for my servers. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Smith, Don , , WHS/PSD [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:51 AM To: CF-Talk Subject: Big problem- session vars not saved in IE6 on CF5 I am having a big problem with an old standard login system. This is the most simple login system I know and have used it for years. It consists of: Login form page Login action page Main page Session variables tracking who is logged in The user enters in their login acct, the action page compares it against the db, then sets some session variables and uses cflocation to forward them to a new page or back to the login page if they fail. The application page checks for the session variable to see if they're logged in and uses cflocation to send them back to the login page if the var doesn't exist. Up until August 19 it worked fine on all browsers. After then, it works fine on about 75% of the instances of IE6 in our enterprise. It fails on about 1 out of 4 IE installations including my own! What happens is the user logs in, the database accepts the login and uses cflocation to send them to the main page. Then Application.cfm checks to see if they have the correct session variable and uses cflocation to forward them to the login page. I can display the session vars at the bottom of the login action page during testing, but as soon as I turn cflocation back on, the session variables do not exist on the main page after the action page. They disappear. Yes they exist on most instances of IE and they exist in every single instance of NS that I tested. I have a working version of IE 6 that can login with no problem- I have modified my internet options (ESPECIALLY the cookies/privacy options) to match that machine exactly, but still the problems persist on my machine. The only thing that I did that could have affected this on August 19 was that I remember that morning getting a request to log into MS Passport to access my hotmail account. Other than that, I changed none of this code. Since 25% of our users seem to be affected by this problem, it's a big deal for us. I have asked EVERYONE about this and no one has seen this one before. Have any of you heard about this before or does anyone have any suggestions of how to go about debugging this? Thanks, Don Smith __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Semi OT question: Skills for jobs
I agree with you, most wanted ads read like a list of whatever happened to be on the shelf at the time. Fact of the matter is I'd never hire a Java developer who claimed to be good at Photoshop - I don't believe he'd be good at either. Problem is, companies need 2 or 3 people who can do a dozen things and know they'll end up needing a mix of skills, but the exact member makeup can vary. And so they list them all - that makes sense (somewhat). But then whoever screens the calls and sorts the resumes axes those that don't list everything flagging them as a lesser match. Furthermore, the current economy dictates that employers try find one person who can do the job of three. It won't work, but they'll try. I think they'll learn the hard way though. --- Ben -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:15 PM To: CF-Talk Subject: Semi OT question: Skills for jobs Hey guys and gals and code monkeys, it's come to my attention that Employers are looking for someone with a wide range of skills For example, one required that you know C++, Coldfusion, ASP, Dreamweaver, VBScript, Java, Adobe Photoshop, Macromedia Flash... Oh, and it would be a PLUS if you know nuclear physics and how to cook french cuisine. Jokes aside, is this fair? I mean I know few people who know all of these at once. Few...like 1!!! Are these employers just dropping skills without considering their relationship? And also, there are sites like freelance.com or elance.com that allows coders to bid on projects, and the $$ offered on these projects are crazy. FOr example, someone wanted an auction site like ebay. Max bid allowed was $200. I contacted the project poster, and his answer was..well, since there is so many free code you can get online, I assume the programmer only has to put them together to make the auction site. How does this make you feel? What is the percieved view on programmers? Maybe I'm just whining. Maybe I'm just not over the dot com hey-days when code monkeys were gods with shorts and sandals at work. Mr. Forta, and dude from Figleaf, I would really appreciate your take on this one. Phoeun __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Semi OT question: Skills for jobs
First ofCF-JOBS-TALK for this one ;-) Secondcheck the archives at http://www.mail-archive.com/cf-talk@houseoffusion.com/ as these topics have been beaten to a fine paste over the past few weeks (and every few weeks for eternity I'm sure). Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Phoeun Pha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 9:14 AM Subject: Semi OT question: Skills for jobs Hey guys and gals and code monkeys, it's come to my attention that Employers are looking for someone with a wide range of skills For example, one required that you know C++, Coldfusion, ASP, Dreamweaver, VBScript, Java, Adobe Photoshop, Macromedia Flash... Oh, and it would be a PLUS if you know nuclear physics and how to cook french cuisine. Jokes aside, is this fair? I mean I know few people who know all of these at once. Few...like 1!!! Are these employers just dropping skills without considering their relationship? And also, there are sites like freelance.com or elance.com that allows coders to bid on projects, and the $$ offered on these projects are crazy. FOr example, someone wanted an auction site like ebay. Max bid allowed was $200. I contacted the project poster, and his answer was..well, since there is so many free code you can get online, I assume the programmer only has to put them together to make the auction site. How does this make you feel? What is the percieved view on programmers? Maybe I'm just whining. Maybe I'm just not over the dot com hey-days when code monkeys were gods with shorts and sandals at work. Mr. Forta, and dude from Figleaf, I would really appreciate your take on this one. Phoeun __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Question about IE6 and FTP
Ok, this is a bit off topic, but I have been banging my head against the wall all morning! I just upgraded my browser to IE6 and I have this website that I am working on uses a FTP window within a frame to move large amounts of files from the clients machine to the server. The whole FTP worked great until I upgraded my browser from IE 5.5 to IE6. I wanted to be sure that everything was still going to work with the site. Now, we I try to get the site to open, I am now getting the The page cannot be displayed kiss of death. If I try to type the FTP address into the address bar I get the login popup screen ( BTW: I am using an anonymous login) and have to press the cancel button. But, when I press the cancel button I am able to see the directory on the server. If I go to another machine that has IE 5.5 running then the website (with the framed FTP window) is still there and all is well. Does anyone have any idea why this is happening and what I need to do to get things running again? Thanks in advance. Michael __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Function?
I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Function?
Why not just let it happen when the user clicks a submit button? Onexit AKA OnBlur is creepy and confusing. but it's possible to do it your way. First write a javascript function to submit the form. THen in the form field for the SSN, add in this attribute.. onblur=nameoffunction(); that way, when the user moves out of the field, it calls the javascript, which submits the form magically. walla! -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:52 AM To: CF-Talk Subject: Function? I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
setting client vars via list
I am trying to loop through a list and tack on a prefix of client. to set client variables in that list variables.thisvar is the index cfset clientvars = address1,address2,city,country,email,firstname,lastname,phonenumber,phonenumber2,state cfloop list=#clientvars# index=variables.thisvar CFSET evaluate('client.'variables.Thisvar)= ucase(evaluate(variables.thisvar)) /cfloop __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Function?
You can do this in Javascript and CF... You would use the onBlur event to call your function. Your function would likely call a CF page into a IFrame, frame, processing window, etc. and that page would take whatever action is necessary... i.e. function ConfirmSSN(sSSN) { document.all.WorkFrame.src = confirmSSN.cfm?SSN= + sSSN; } . . input type=Text . . . onblur=ConfirmSSN(this.value); iframe id=WorkFrame name=WorkFrame hieght=0 width=0/iframe CONFIRMSSN.CFM: === cfparam name=URL.SSN default= .. (other code here to process the SSN) ... cfif ValidSSN eq No script language=javascript alert(Invalid SSN); window.parent.document.forms[0].SSN.focus(); /script /cfif Hope this helps (well, it's a start at least...) Shawn Grover -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:52 AM To: CF-Talk Subject: Function? I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: setting client vars via list
I was able to get this to work with cfparam name=client.#variables.thisvar# default=#ucase(evaluate(variables.thisvar))# - Original Message - From: Brian Thornton To: CF-Talk Sent: Wednesday, August 28, 2002 10:07 AM Subject: setting client vars via list I am trying to loop through a list and tack on a prefix of client. to set client variables in that list variables.thisvar is the index cfset clientvars = address1,address2,city,country,email,firstname,lastname,phonenumber,phonenumber2,state cfloop list=#clientvars# index=variables.thisvar CFSET evaluate('client.'variables.Thisvar)= ucase(evaluate(variables.thisvar)) /cfloop __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Training IN SoCal
Doug, After an hour searching the web, I found one. here's the link if you 're interested. http://www.roundpeg.com/home.cfm?main=trainingaction=classinfoclassid=109; locid=29 Thanh. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 12:11 PM To: CF-Talk Subject: Re: Coldfusion Training IN SoCal I have looked also, and do not know of any. There are several that offer the certs and such, but no luck on the actual training aspect. I live in Orange and have checked Irvine, Anaheim, Santa Ana and a few other areas. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 11:02 AM Subject: OT: Coldfusion Training IN SoCal Are there any ColdFusion training schools in Southern California? Thanh __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: unresponsive threads crashing cf
Search the Macromedia knowledge base, I think there's information there about CF admin settings. Also, search on information about how CF handles threads. You need to find why your .cfm templates are running so slowly - that's what's killing you. It sounds like the restart at X number of unresponsive threads is set too low. Generally that should be 80% of the number of threads. The number of threads should be about 3 to 5 per processor. The CFadmin default setting makes the restart number greater than the total number of threads, so CF never restarts even if all threads are unresponsive. Chris Norloff -- Original Message -- from: Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 28 Aug 2002 10:30:22 -0500 I am having a problem with unresponsive threads crashing the server. It seems that they are not being released even after they exceed the timeout specified in cf administrator(90 seconds). It took over 37 minutes for the same template to generate unresponsive threads. Why doesn't CF drop them when they exceed the time limit? Information,238,08/28/02,05:52:49,,The ColdFusion Application Server started. Warning,88,08/28/02,06:53:12,,Template: D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 101 seconds. Warning,304,08/28/02,06:53:13,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 102 seconds. Warning,426,08/28/02,07:06:19,,A request exceeded the timeout. The unresponsive thread count is up to 1. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:06:19,, !! CFTrace::logThread(304) has no entry for thread 304 Warning,426,08/28/02,07:12:19,,A request exceeded the timeout. The unresponsive thread count is up to 2. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:12:19,, !! CFTrace::logThread(324) has no entry for thread 324 Warning,426,08/28/02,07:16:49,,A request exceeded the timeout. The unresponsive thread count is up to 3. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:16:49,, !! CFTrace::logThread(88) has no entry for thread 88 Warning,426,08/28/02,07:18:19,,A request exceeded the timeout. The unresponsive thread count is up to 4. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:18:19,, !! CFTrace::logThread(464) has no entry for thread 464 Warning,426,08/28/02,07:21:19,,A request exceeded the timeout. The unresponsive thread count is up to 5. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:21:19,, !! CFTrace::logThread(327) has no entry for thread 327 Warning,426,08/28/02,07:43:49,,A request exceeded the timeout. The unresponsive thread count is up to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:43:49,, !! CFTrace::logThread(568) has no entry for thread 568 Warning,426,08/28/02,07:55:49,,A request exceeded the timeout. The unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:55:49,, !! CFTrace::logThread(129) has no entry for thread 129 Warning,554,08/28/02,07:56:44,,Template: D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 210 seconds. Information,129,08/28/02,07:56:45,,A long-running request returned. The unresponsive thread count is down to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm]. Warning,129,08/28/02,07:56:45,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 211 seconds. Warning,426,08/28/02,08:00:19,,A request exceeded the timeout. The unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:00:19,, !! CFTrace::logThread(308) has no entry for thread 308 Warning,426,08/28/02,08:04:49,,A request exceeded the timeout. The unresponsive thread count is up to 8. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:04:49,, !! CFTrace::logThread(554) has no entry for thread 554 Warning,426,08/28/02,08:07:49,,A request exceeded the timeout. The unresponsive thread count is up to 9. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:07:49,, !! CFTrace::logThread(129) has no entry for thread 129 Fatal,426,08/28/02,08:09:19,,Unresponsive thread threshold reached. Restarting service. Information,177,08/28/02,08:09:23,,The ColdFusion Application Server started. (ETC) The template uses a custom tag call that does a cfhttp call to another template on the same server, trying my hand at a pseudo web service. Basically: 1. Template calls custom tag for validation. 2. Custom tag calls (local/same cf server) web service url 3. Web service url/template checks if local cache(ms sql db) if user validation expired. If not expired and validates properly, returns 1. 4. If expired: Calls a third party web service, which we validate against. Validation fails, return 0 Validation succeeds, insert to local db cache, return 1 I hope that makes sense. Could that cause problems? I would guess that it would take two threads as one template calls another... But that shouldn't be to bad. We've tried
RE: Function?
Well I want to validate certain fields throughout the application and use the submit for a master save of all of the data associated with the form. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:01 PM To: CF-Talk Subject: RE: Function? Why not just let it happen when the user clicks a submit button? Onexit AKA OnBlur is creepy and confusing. but it's possible to do it your way. First write a javascript function to submit the form. THen in the form field for the SSN, add in this attribute.. onblur=nameoffunction(); that way, when the user moves out of the field, it calls the javascript, which submits the form magically. walla! -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:52 AM To: CF-Talk Subject: Function? I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cflocation and a popup
Can I do this? cfif NOT IsDefined('session.client_id') cflocation url=javascript:popUpb('home_login.cfm') cfabort /cfif It doesn't work though! Don't worry - I have a function in my head tags within my top element page. Kodjo ackah Principal Consultant concrete-media.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Big problem- session vars not saved in IE6 on CF5
I'd suspect the cflocation and/or cookies - if it doesn't have addtoken set, and there's problems with the cookies, session vars won't know which session they're part of. Not sure why that would change all of a sudden, though. I had a problem with an organization once where they stripped all javascript out of web pages without telling anyone. Did a number on my client-side activity! Chris Norloff -- Original Message -- from: Smith, Don , , WHS/PSD [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 28 Aug 2002 11:50:30 -0400 I am having a big problem with an old standard login system. This is the most simple login system I know and have used it for years. It consists of: Login form page Login action page Main page Session variables tracking who is logged in The user enters in their login acct, the action page compares it against the db, then sets some session variables and uses cflocation to forward them to a new page or back to the login page if they fail. The application page checks for the session variable to see if they're logged in and uses cflocation to send them back to the login page if the var doesn't exist. Up until August 19 it worked fine on all browsers. After then, it works fine on about 75% of the instances of IE6 in our enterprise. It fails on about 1 out of 4 IE installations including my own! What happens is the user logs in, the database accepts the login and uses cflocation to send them to the main page. Then Application.cfm checks to see if they have the correct session variable and uses cflocation to forward them to the login page. I can display the session vars at the bottom of the login action page during testing, but as soon as I turn cflocation back on, the session variables do not exist on the main page after the action page. They disappear. Yes they exist on most instances of IE and they exist in every single instance of NS that I tested. I have a working version of IE 6 that can login with no problem- I have modified my internet options (ESPECIALLY the cookies/privacy options) to match that machine exactly, but still the problems persist on my machine. The only thing that I did that could have affected this on August 19 was that I remember that morning getting a request to log into MS Passport to access my hotmail account. Other than that, I changed none of this code. Since 25% of our users seem to be affected by this problem, it's a big deal for us. I have asked EVERYONE about this and no one has seen this one before. Have any of you heard about this before or does anyone have any suggestions of how to go about debugging this? Thanks, Don Smith __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Function?
That is unconventional. Do it this way... Put an ONCLICK attribute in the submit button. That way, if u click it, it will run your javascript functions which u will write to validate the fields. If something is wrong, put out a pop up message. if nothing is wrong, have it submit the message. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:20 PM To: CF-Talk Subject: RE: Function? Well I want to validate certain fields throughout the application and use the submit for a master save of all of the data associated with the form. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:01 PM To: CF-Talk Subject: RE: Function? Why not just let it happen when the user clicks a submit button? Onexit AKA OnBlur is creepy and confusing. but it's possible to do it your way. First write a javascript function to submit the form. THen in the form field for the SSN, add in this attribute.. onblur=nameoffunction(); that way, when the user moves out of the field, it calls the javascript, which submits the form magically. walla! -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:52 AM To: CF-Talk Subject: Function? I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cflocation and a popup
actually, this would work cfif NOT IsDefined('session.client_id') script language=javascript function pupUpb() blah blah blah; /script /cfif it runs the script right in there :) -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:18 PM To: CF-Talk Subject: Cflocation and a popup Can I do this? cfif NOT IsDefined('session.client_id') cflocation url=javascript:popUpb('home_login.cfm') cfabort /cfif It doesn't work though! Don't worry - I have a function in my head tags within my top element page. Kodjo ackah Principal Consultant concrete-media.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cflocation and a popup
The abort is probably giving you fits ... remove it and try it out! Paul Giesenhagen QuillDesign - Original Message - From: Kodjo Ackah [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 12:18 PM Subject: Cflocation and a popup Can I do this? It doesn't work though! Don't worry - I have a function in my head tags within my top element page. Kodjo ackah Principal Consultant concrete-media.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Function?
Phoeun Pha writes: That is unconventional. Do it this way... Put an ONCLICK attribute in the submit button. That way, if u click it, it will run your javascript functions which u will write to validate the fields. If something is wrong, put out a pop up message. if nothing is wrong, have it submit the message. actually i believe it's preferrable to have an onSubmit event in the form tag to call the validation functions(s) rather than an onClick event in the submit button. charlie -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:20 PM To: CF-Talk Subject: RE: Function? Well I want to validate certain fields throughout the application and use the submit for a master save of all of the data associated with the form. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:01 PM To: CF-Talk Subject: RE: Function? Why not just let it happen when the user clicks a submit button? Onexit AKA OnBlur is creepy and confusing. but it's possible to do it your way. First write a javascript function to submit the form. THen in the form field for the SSN, add in this attribute.. onblur=nameoffunction(); that way, when the user moves out of the field, it calls the javascript, which submits the form magically. walla! -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:52 AM To: CF-Talk Subject: Function? I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web Hosting services for ColdFusion
www.cfdynamics.com Good people, good prices. We use them and are very happy with them. -Novak - Original Message - From: siva girumala [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 7:12 AM Subject: Web Hosting services for ColdFusion Hi I am going to release a website for CFMX certification in a shortwhile. I would like to know about the hosting services for Coldfusion... Please mention few names either free/charge basis... Thank you --Siva Girumala __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Function?
Yes, you are right. I thought that she had wanted to do javascript, then serverside validation, and if something is wrong, bring them back to the input page with prefilled fields and alert them. If nothing is wrong, still bring them back to the input page, except this time instead of an alert message, display a submit button for them to click. heh i'm sleepy i guess -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:34 PM To: CF-Talk Subject: Re: Function? Phoeun Pha writes: That is unconventional. Do it this way... Put an ONCLICK attribute in the submit button. That way, if u click it, it will run your javascript functions which u will write to validate the fields. If something is wrong, put out a pop up message. if nothing is wrong, have it submit the message. actually i believe it's preferrable to have an onSubmit event in the form tag to call the validation functions(s) rather than an onClick event in the submit button. charlie -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:20 PM To: CF-Talk Subject: RE: Function? Well I want to validate certain fields throughout the application and use the submit for a master save of all of the data associated with the form. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:01 PM To: CF-Talk Subject: RE: Function? Why not just let it happen when the user clicks a submit button? Onexit AKA OnBlur is creepy and confusing. but it's possible to do it your way. First write a javascript function to submit the form. THen in the form field for the SSN, add in this attribute.. onblur=nameoffunction(); that way, when the user moves out of the field, it calls the javascript, which submits the form magically. walla! -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:52 AM To: CF-Talk Subject: Function? I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Function?
Unconventional? I've seen a LARGE number of applications that do this sort of validation - granted most are desktop applications. In a web environment this is more of a pain to do, but still very possible. Perhaps a better word would be Uncommon? at least in web pages. The unwritten standard that I've seen in web pages is to validate your data when the form is being submitted. This certainly makes writing the code easier, and removes any weird delays checking data while enter it. However, each application has it's own requirements, and some will require validation when the data is entered (i.e. a text box field that only allows numbers). I worked on a web app recently where the type of validation to be done changed on the fly depending on the value of some other form elements. This validation had to happen as data was entered, when the field lost focus, and when the form was submitted. It took a fair bit of code to make it happen, but it wasn't impossible, and actually performs pretty good considering network lags and all My thoughts... Shawn Grover -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:24 AM To: CF-Talk Subject: RE: Function? That is unconventional. Do it this way... Put an ONCLICK attribute in the submit button. That way, if u click it, it will run your javascript functions which u will write to validate the fields. If something is wrong, put out a pop up message. if nothing is wrong, have it submit the message. -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:20 PM To: CF-Talk Subject: RE: Function? Well I want to validate certain fields throughout the application and use the submit for a master save of all of the data associated with the form. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:01 PM To: CF-Talk Subject: RE: Function? Why not just let it happen when the user clicks a submit button? Onexit AKA OnBlur is creepy and confusing. but it's possible to do it your way. First write a javascript function to submit the form. THen in the form field for the SSN, add in this attribute.. onblur=nameoffunction(); that way, when the user moves out of the field, it calls the javascript, which submits the form magically. walla! -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:52 AM To: CF-Talk Subject: Function? I was curious if it is possible for me to write a function that will onExit from a form field cerify that data against our database? For examples if I enter in my SSN then onexit the ssn would be passed back to the server and a query would execute Either returing the results of my query (firstname, lastname etc...) or it would send back no then I would display a error message. Please advise... Seems possible im just not sure how to do it...exactly... Thanks for your help Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cflocation and a popup
Can I do this? cfif NOT IsDefined('session.client_id') cflocation url=javascript:popUpb('home_login.cfm') cfabort /cfif It doesn't work though! Don't worry - I have a function in my head tags within my top element page. M... nope, I wouldn't expect that to work and here's why: cflocation actually is a shortcut for a particular cfheader tag, so it redirects to the next page by manipulating the http header information for the current request. There is however no communication ( that I'm aware of ) between the http headers for a given request and javascript on the page... So, the way to get this to work the way you would like it to is to eliminate the cflocation and use a slightly different syntax. cfif NOT IsDefined('session.client_id') script language=javascript popUpb('home_login.cfm'); /script cfabort /cfif I won't get into specifics about how this technically ought to be inside the head tags or how it's probably better to associate it with the window.onload event either in the body tag or by setting the event to your function... this syntax should work for all intents and purposes on most browsers. hth Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
programmer vs. developer
whats the difference? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Function?
Yes, you are right. I thought that she had wanted to do javascript, then serverside validation, and if something is wrong, bring them back to the input page with prefilled fields and alert them. If nothing is wrong, still bring them back to the input page, except this time instead of an alert message, display a submit button for them to click. heh i'm sleepy i guess Actually, dependant upon the application, I could see a situation where it might be beneficial to take the contents of a single input field and pass or submit them to an action page in the onblur() event of the field, thus making allmost all visible content always current, and eliminating the need for a submit or save button. The only drawbacks are that it makes undo a little unwieldy and has the potential to drastically increase bandwidth and server resource usage as a result of sending dozens if not hundreds or thousands of page requests for such a tiny amount of data. But the idea is interresting and possibly viable, given circumstance. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web Hosting services for ColdFusion
[EMAIL PROTECTED] writes: www.cfdynamics.com Good people, good prices. We use them and are very happy with them. -Novak I love that on their 'side-by-side comparison' page they list that all of their plans offer 'Java Script' :) - Original Message - From: siva girumala [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 7:12 AM Subject: Web Hosting services for ColdFusion Hi I am going to release a website for CFMX certification in a shortwhile. I would like to know about the hosting services for Coldfusion... Please mention few names either free/charge basis... Thank you --Siva Girumala __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Big problem- session vars not saved in IE6 on CF5
You know... I passed by this thread originally but then this morning I remembered that I have experienced something similar to this in the past. It was even reported to Macromedia and (reluctantly) confirmed to be a bug. I wish I could remember the exact details but to the best of my recollection it had something to do with using session variables and CFCONTENT or... session variables and cflocation Something like that. Since MM couldn't give us a fix... the workaround was to use CLIENT vars instead of session vars. I also recall an issue with the CFCOOKIE tag and CFCONTENT tag (in CF5). Once again, the workaround here was to use CLIENT vars instead of regular cookies. On the surface it didn't make much sense since a Client var IS a cookie... but I guess it was treated differently in the CF code... -Novak - Original Message - From: Mark W. Breneman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 9:18 AM Subject: RE: Big problem- session vars not saved in IE6 on CF5 I too have seen this on one of our client's server, that I do not manage. Where I first found it was a job app that used different includes for different jobs. When the data was inserted into the database about 15%-20% of the records would not have a value from the session. Thus you could not tell what job they were applying for. I never did track down the exact problem I fix it by passing the job ID in the url line. Are cookies enabled? Check to see if IE is set to default security settings. Under some of the higher settings cookies are disabled and since sessions are tracked via the CFID and CFTOKEN cookies session vars will not work. You can turn on Debugging Options - Show Variables on the server and check to see if the CFID and CFTOKEN cookies are being written. That will show up in the browser under the CGI Variables: HTTP_COOKIE If you find the problem please let me know. So far this has not been a problem for my servers. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Smith, Don , , WHS/PSD [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:51 AM To: CF-Talk Subject: Big problem- session vars not saved in IE6 on CF5 I am having a big problem with an old standard login system. This is the most simple login system I know and have used it for years. It consists of: Login form page Login action page Main page Session variables tracking who is logged in The user enters in their login acct, the action page compares it against the db, then sets some session variables and uses cflocation to forward them to a new page or back to the login page if they fail. The application page checks for the session variable to see if they're logged in and uses cflocation to send them back to the login page if the var doesn't exist. Up until August 19 it worked fine on all browsers. After then, it works fine on about 75% of the instances of IE6 in our enterprise. It fails on about 1 out of 4 IE installations including my own! What happens is the user logs in, the database accepts the login and uses cflocation to send them to the main page. Then Application.cfm checks to see if they have the correct session variable and uses cflocation to forward them to the login page. I can display the session vars at the bottom of the login action page during testing, but as soon as I turn cflocation back on, the session variables do not exist on the main page after the action page. They disappear. Yes they exist on most instances of IE and they exist in every single instance of NS that I tested. I have a working version of IE 6 that can login with no problem- I have modified my internet options (ESPECIALLY the cookies/privacy options) to match that machine exactly, but still the problems persist on my machine. The only thing that I did that could have affected this on August 19 was that I remember that morning getting a request to log into MS Passport to access my hotmail account. Other than that, I changed none of this code. Since 25% of our users seem to be affected by this problem, it's a big deal for us. I have asked EVERYONE about this and no one has seen this one before. Have any of you heard about this before or does anyone have any suggestions of how to go about debugging this? Thanks, Don Smith __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: programmer vs. developer
In MMs mind, a programmer is one who uses a compiled language like Java or C++. A developer is someone who uses a scripting language like CF. This is a totally artificial distinction and one I reject on every level. I program. So do you. We're programmers. whats the difference? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cflocation and a popup
No joy to dropping the cfabort Kodjo ackah Principal Consultant concrete-media.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cflocation and a popup
No joy to this either! cfif NOT IsDefined('session.client_id') script language=javascript function popUpb(URL) { day = new Date(); id = day.getTime(); eval(page + id + = window.open(home_login.cfm, ' + id + ', 'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,wid th=580,height=580,bgcolor=#11');); } /script /cfif Kodjo ackah Principal Consultant concrete-media.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: programmer vs. developer
A developer developes, a programmer programs. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 18:42 To: CF-Talk Subject: programmer vs. developer whats the difference? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: programmer vs. developer
imho: developer has these as his/her strong suit: 50/50 on graphical interface/programming work photoshop/fireworks flash cf sql javascript dhtml a programmer is a language guru: all ecma based scripts cf maybe some vbscript/asp (if that be their flavor of choice) sql (cant get too far without this guy) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:42 PM To: CF-Talk Subject: programmer vs. developer whats the difference? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFTicket Beta Testers Needed.
oi List!! We are currently looking for 10 beta testers for our new ColdFusion based ticketing system. Below is a quick list of features it offers: Multiple Queues for different accounts Multiple Users allowed, all with different permissions Statistics for quick viewing of which queues are the busiest History of all communication between customer and your company Autoresponders to new and closed tickets Notification of new tickets Notification at certain intervals, or after each new ticket. Allows multiple recipients Powerful search engine Enhanced security allows only certain people into certain areas Color coding scheme allows quick viewing of which tickets have been responded to Quick navigation allows for more efficient work Built in Web-Mail allows for quick replying to Tickets Compatible with Windows and Unix/Linux and MSSQL, Microsoft Access, and MySQL You can read up on it at http://www.cornfeed.com and if you are interested in helping us beta test the app, please send an email to [EMAIL PROTECTED] Cheers Critz __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: programmer vs. developer
If you consider yourself a programmer because you write cfml then you're saying cfml is a programming language? Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 18:52 To: CF-Talk Subject: Re: programmer vs. developer In MMs mind, a programmer is one who uses a compiled language like Java or C++. A developer is someone who uses a scripting language like CF. This is a totally artificial distinction and one I reject on every level. I program. So do you. We're programmers. whats the difference? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Exchange, Outlook Tasks with CF
Hello all. i need to figure out how to create Tasks within Outlook using ColdFusion with our Exchange server. any pointers, leads example code would be SO MUCH appreciated... thank you. -paul __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cflocation and a popup
Isaac, this did not work - cfabort makes it all go blank! Kodjo ackah Principal Consultant concrete-media.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: programmer vs. developer
Define a programming language and see if CF fits into it. Does it store variables? Do conditional logic? iterate loops? convert data? What makes C++ a programming language and CF not one? If you say that CF is just built on top of C++, then every C++ and java programmer aren't really programmers as they're not writing machine code. The argument is an artificial one. I'm a programmer because I use a computer language to write applications (even a single template) that runs on a computer to process some data. If you consider yourself a programmer because you write cfml then you're saying cfml is a programming language? Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 18:52 To: CF-Talk Subject: Re: programmer vs. developer In MMs mind, a programmer is one who uses a compiled language like Java or C++. A developer is someone who uses a scripting language like CF. This is a totally artificial distinction and one I reject on every level. I program. So do you. We're programmers. whats the difference? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists