re: CF Forum 2000
Is the forum using Access or SQL Server? If it is using Access then up the database to SQL Server and that should help alot. Clint Tredway www.digital12studios.com Original Message: Return-Path: [EMAIL PROTECTED] Thu Oct 16 21:25:44 2003 Received: from houseoffusion.com [64.118.64.245] by mail16.crystaltech.com with SMTP; Thu, 16 Oct 2003 21:25:44 -0700 Received: from LOCALHOST by LOCALHOST with ESMTP id 17CC6E829D9BA3479E8EF2803401F19A Fri, 17 Oct 2003 00:27:32 -0400 Date: Fri, 17 Oct 2003 14:21:35 +1000 From: Ryan Sabir [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] Precedence: bulk References: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Subject: CF Forum 2000 To: CF-Talk [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=_NextPart_000_1066350452_CFX_iMSMail_141555966 Content-Transfer-Encoding: 7bit Hi all, Has anyone here implemented a high volume site using CF FORUM 2000? We have just inherited one, and am wondering how solid the code is. Its a very busy forum, doing about 3 gigs of traffic per day, and its started to show signs of breaking down, e.g. deadlock errors, timeouts, No more data available to read errors. Should I be looking for different forum software? Or re-write the code myself? Has anyone done an optimisation job on the CFFORUM code and can give a few pointers on where the bottlenecks are? thanks, bye! --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Giving up on DW 2004 MX
doc.write and innerHTML is the same thing...it's all writing out html with _javascript_, and it's old, lame, and slow. I'd though that was implied. It's all DOM 1. I wouldn't even mind DOM 1 if it was fully implemented, but it's not It's clear to me you just like to complain for the sake of it. I was having the impression you would like to discuss, my mistake. I apologize with the list for wastiung the bandwith Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Forum 2000
Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS Hi all, RS Has anyone here implemented a high volume site using CF FORUM 2000? RS We have just inherited one, and am wondering how solid the code is. RS Its a very busy forum, doing about 3 gigs of traffic per day, and its RS started to show signs of breaking down, e.g. deadlock errors, RS timeouts, No more data available to read errors. RS Should I be looking for different forum software? Or re-write the code RS myself? RS Has anyone done an optimisation job on the CFFORUM code and can give a RS few pointers on where the bottlenecks are? RS thanks, bye! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: query to outout an xml file
ty Matthew It's actually pretty easy. XML is just text. Create a variable with your XML, then use cffile to write it. Something like: cfdirectory action="" directory=qwerty name=myPix cfsavecontent variable=myXml?xml version=1.0 encoding=iso-8859-1? Slides cfoutput query=myPix slideNode jpegURL=asdfgzxcvb/slideNode /cfoutput /Slides /cfsavecontent cffile action="" file=uiop output=#myXml# addnewline=Yes -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 17 October 2003 9:53 a.m. To: CF-Talk Subject: query to outout an xml file i know nothing about xml so any help would be appriciated im making a slideshow in flash that draws the images out of a folder and is read by an xml file to import them into flash flash needs to read the xml file which i just have as slides.xml the xml looks like this Slides slideNode jpegURL=images/image1.jpgPicture Description./slideNode slideNode jpegURL=images/image2.jpgPicture Description./slideNode slideNode jpegURL=images/image3.jpgPicture Description./slideNode slideNode jpegURL=images/image4.jpgPicture Description./slideNode slideNode jpegURL=images/image5.jpgPicture Description/slideNode /Slides but what i would like to do is have this xml file made dynamic so I can upload images via coldfusion and then do a db query to get the xml file so i dont have to manually update it everytime a pic is added. But the file needs to be an xml file not a cfm file, so how in the heck do i do that? ty:) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
sweet guestbook!! but......
I have this amazing guestbook in flash asp which i would like to convert to flash and coldfusion. im ok with converting most of the asp stuff but the xml is throwing me off. there are only 7 asp pages to convert with a total of 281 lines of code this is a fabulous gb. anyone interested in helping me convert it, of course you get a great app as well. has everything there just need to change some code only 1 page is trippin me up any takers? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Actually - if I remember correctly - CF Forums was never encrypted.So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a oh, do we HAVE to! budget and timeline.It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS Hi all, RS Has anyone here implemented a high volume site using CF FORUM 2000? RS We have just inherited one, and am wondering how solid the code is. RS Its a very busy forum, doing about 3 gigs of traffic per day, and its RS started to show signs of breaking down, e.g. deadlock errors, RS timeouts, No more data available to read errors. RS Should I be looking for different forum software? Or re-write the code RS myself? RS Has anyone done an optimisation job on the CFFORUM code and can give a RS few pointers on where the bottlenecks are? RS thanks, bye! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing empty form field entry
First of all: if the field is a radio, checkbox or multiple select, you use cfparam to set a default value on the action page. cfparam name=form.myfield default= Then in your query you have 2 possibilities: 1. The field is a text field in the db (char, varchar, ...). You can just insert the empty string. If you want to insert a NULL or a default value: see 2 2. The field is not a text field. Then you have problems inserting the empty string because it doesn't match your datatype and it will throw an sql error. The solution is usually to insert NULL instead and the way to do that is cfqueryparam (and of course you are already using it ;-) ): INSERT INTO TBL(field) VALUES (cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#form.myfield# null=#YesNoFormat(Len(form.myfield))#) If you want a default value inserted, you can change the value when you do your server side validation: cfif NOT Len(form.myfield) !--- or any other validation --- cfset form.myfield = default_value /cfif Pascal -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 1:21 Aan: CF-Talk CC: Onderwerp: passing empty form field entry If a web site visitor completes a form without entering data in a field (which in this case may be OK), how do you set up the coding for inserting that blank entry into a database (or ignoring that field). If I include the field in the SQL insert statement, I get an error resolving parameter I'm trying to avoid a bunch of CFIF statements (ie. CFIF field EQ '', then such and such CFELSE such and such) TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Including servlets in a CF template
Thanks Dave I'll take a look at this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 00:18 To: CF-Talk Subject: RE: Including servlets in a CF template is there anyway to include java servlets in a CF page on an MX CF server that is running on IIS, I'm getting errors when trying to do this, although the same template runs fine on a dev box that is running the jrun stand alone from install. Can you run the servlets directly through IIS? If that's not configured correctly, you won't be able to use them from CF either. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sorting IP Addresses
That sounds like it could perform poorly, would it?
- Calvin
- Original Message -
From: Benjamin S. Rogers
To: CF-Talk
Sent: Thursday, October 16, 2003 4:38 PM
Subject: RE: Sorting IP Addresses
that doesn't work perfectly.
166.141.22.4
166.141.22.40
166.141.22.41
166.141.22.47
166.141.22.48
166.141.22.5
Sorry about that. I forgot to convert the substrings to integers. Try
this:
SELECT *
FROM SourceIPSpamCount
ORDER BY
CONVERT(INT, SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, SUBSTRING(SourceIP, CHARINDEX('.', SourceIP) +
1,CHARINDEX('.', SourceIP, CHARINDEX('.', SourceIP) + 1) -
CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1, CHARINDEX('.', REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1) - CHARINDEX('.', REVERSE(SourceIP)) - 1))),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), 1, CHARINDEX('.',
REVERSE(SourceIP)) - 1)))
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Giving up on DW 2004 MX
Nicely done on ignoring every point I made, including the request to back up your false claims about focus. I still feel DW's scripting API is far less powerful than Homesite's, and I'd welcome any attempt to prove my any of the facts I laid out in defense of my opinion wrong. This whole thing started out with what I felt was a positive post about the DW API, including an example of an extension I wrote showing it off rather nicely I thought. You disagreed with my opinion that I tacked on at the end, and still haven't backed it up with any facts. To me, it seems to me that you are the one wanting to complain about my opinions for no reason that I can see. You didn't even look at the extension or you wouldn't have asked what kind of extension needs recurring dir listings. Why you would go fishing for a debate, then whine about it when you get one is beyond me. ...and since I have no issues against responding to Ad Hominem attacks in kind...if you don't realize doc.write and innerHTML, part of DOM1, and over 6 years old, are one and the same conceptually, you really aren't worth discussing the issue with anyway. Kinda makes me want to whip together some extensions and see if they sell. I thought I went out of my way to be respectful in my post (which I just reread to make sure, and I'm still not sure what got you so defensive. I do apologize for any unintended slight. The ones above are quite intended though.), and I expect the same in return. Otherwise, you get what you give. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 1:29:39 AM, you wrote: doc.write and innerHTML is the same thing...it's all writing out html with _javascript_, and it's old, lame, and slow. I'd though that was implied. It's all DOM 1. I wouldn't even mind DOM 1 if it was fully implemented, but it's not MTeF It's clear to me you just like to complain for the sake of it. I was having MTeF the impression you would like to discuss, my mistake. MTeF I apologize with the list for wastiung the bandwith [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Query
Paul Giesenhagen said: I have a number of reports all dated, but dated by day (no time). Some of the reports are on the same day If I have an ID value, I need to grab the report before and the report after that ID and it needs to be by date. Here is what the data looks like: ReportID|ReportDate|Report | 19/10/2003 29/11/2003 39/11/2003 49/11/2003 59/12/2003 89/12/2003 99/14/2003 1110/01/2003 etc.. If I am looking at ReportID (5), then I want to know that reportID 4 is previous and reportID 8 is next So my output should be Previous = 4 This > Next = 8 Oh, and I need to know if previous is Nothing or Next is nothing (ie there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access db Query error
Mark Leder said: cfquery name=indexCitations datasource= timeout=900 SELECT * FROM citationsTable /cfquery I now want to move this over to CFMX 6.1, but running just a simple query to return all records throws the following error (after about 15 seconds): Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. Have you tried the Access with Unicode driver? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Programmatically set debug options
Does anyone know of a way to set specific debug options? Yup, you can do it using the (undocumented, therefore unsupported) factory methods: cfscript // grab the debugging service factory = createobject(java, coldfusion.server.ServiceFactory); cfdebugger = factory.getDebuggingService(); // set the appropriate vars cfdebugger.settings.cgivar = 0; cfdebugger.settings.sessionvar = 0; /cfscript If you want a list of the options available for you to set (and their current values), run the following after grabbing the debugging service instance: cfdump var=#cfdebugger.getSettings()# HTH, Tim. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Server Indexing of tables help
Exactly 6 years this month as an independent consultant. TODAY I am embarking on my first ever SQL Server driven web site. (So please, be gentle with me) OMG yes, first ever - til now just never needed more than MS Access. I'm running SQL Server 2000, and have successfully converted a message forum Access database to SQL Server - total 3,609 records. 3 Basic Questions 1 - Question regarding indexing.In Access, I was able to just designate whether a column in a table was indexed or not. In reading the SQL Server documentation I THINK I need to do this through Manage Indexes / Create Index.However I'm not sure if I'm doing this properly. I have three columns in the table that I want to index on - CategoryChoice (nvarchar), PostDate (datetime desc) and ThreadDate (datetime desc). All three are non-unique. I createed an index based on these three columns, and set it as nonclustered, name it BoardSort The FIleGroup is checked and set as Primary. Subquestions: Is that all I need to do, or am I missing something?Do I need to refer to this index on my web site to make use of it? 2. - Auto-Incremented Number field - in Access, I just set a field to AutoNum. In SQL Server, after import, for my CategoryChoices Table, I have a unique ID field that was autonum.The import wizard converted the column to an INT and I set the Identity to YES, Identity Seed to 1, and Identity Increment to 1. Is that all I need to do to achieve the same results as an Access AutoNum? 3.On the front end of the site, for my queries, what is the syntax for a query regarding ownership? I recall needing to either refer to the table owner or provide the UserID and Password to access a table however I can't recall where in the query to do this or when.Couldn't find any info in the documentation. Thanks very much for any help provided [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Thursday 16 Oct 2003 17:17 pm, Jochem van Dieten wrote: No account, not even LocalSystem, should have permission to patch core OS files. How would you distribute security updates then ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: html emails with javascript in outlook
On Thursday 16 Oct 2003 17:45 pm, Dave Watts wrote: Not until you mentioned it, so I took a look (http://www.horde.org/), and no, it's no substitute for Exchange + Outlook. Not by a long shot. I jsut thought it had all the right bits - sharable calenders/contacts etc. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1. Oracle 8i. BLOB. Insert/update trouble
Is anyone has success with inserting data in Oracle BLOB field? I tried latest JDBC driver from otn.oracle.com. As I found, this driver excellently work with CLOBs (insert, select, update) and can select BLOBs too. But when I try to insert BLOB, I receive an error Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed. I use CFQUERYPARAM in CFQUERY to insert or update data with cfsqltype == CF_SQL_BLOB (if I change data type to CF_SQL_BINARY, ColdFusion throws other error: Invalid data [EMAIL PROTECTED] for CFSQLTYPE CF_SQL_BINARY). Also I found (it may be helpful for CF/ORACLE developers) that CFMX DataDirect Oracle driver *really* does not support CLOBs/BLOBs at all as well as bundle CFMX JDBC/ODBC bridge with Microsoft ODBC driver for Oracle. Alex. -- Environment details -- * ColdFusion MX 6.1 ENT. * Windows 2000 SP4 + postfixes * Oracle 8.1.7 * Oracle client 9.2.0.1, JDBC driver 9.2.0.3 (ojdbc14.jar, ocrs12.zip, nls_charset12.zip) * CLOB and BLOB checkboxes in datasource configuration in CF Admin are checked. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton said: On Thursday 16 Oct 2003 17:17 pm, Jochem van Dieten wrote: No account, not even LocalSystem, should have permission to patch core OS files. How would you distribute security updates then ? Log in, assign yourself the apropriate rights, update, revoke rights. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing empty form field entry
Yes Pascal... thanks, the 2nd possibility is where I was at... I was trying to insert an empty string (no value) into a number field and experienced the error ... I would have never known to use the code you show (cfsqltype=CF_SQL_NUMERIC)... Is this code referenced/explained anywhere on the web? I did a simple cfparam name=exp_years default=0 in the receing template and that seemed to work But I think your method is more upfront and technically correct Thanks Tim the novice -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:27 AM To: CF-Talk Subject: RE: passing empty form field entry First of all: if the field is a radio, checkbox or multiple select, you use cfparam to set a default value on the action page. cfparam name=form.myfield default= Then in your query you have 2 possibilities: 1. The field is a text field in the db (char, varchar, ...). You can just insert the empty string. If you want to insert a NULL or a default value: see 2 2. The field is not a text field. Then you have problems inserting the empty string because it doesn't match your datatype and it will throw an sql error. The solution is usually to insert NULL instead and the way to do that is cfqueryparam (and of course you are already using it ;-) ): INSERT INTO TBL(field) VALUES (cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#form.myfield# null=#YesNoFormat(Len(form.myfield))#) If you want a default value inserted, you can change the value when you do your server side validation: cfif NOT Len(form.myfield) !--- or any other validation --- cfset form.myfield = default_value /cfif Pascal -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 1:21 Aan: CF-Talk CC: Onderwerp: passing empty form field entry If a web site visitor completes a form without entering data in a field (which in this case may be OK), how do you set up the coding for inserting that blank entry into a database (or ignoring that field). If I include the field in the SQL insert statement, I get an error resolving parameter I'm trying to avoid a bunch of CFIF statements (ie. CFIF field EQ '', then such and such CFELSE such and such) TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Does anybody have answer for this .When I use cflib function wordinstance() sometimes CPU usage will max out ,it reaches its max to 100%.It takes a good amount of time to open the page. This is the only function which give me correct results. My concern is when the site will generate good traffic it will choke the server. I am not sure why. Any help or suggestions are appreciated. Ketan Patel G3 Technology Group, LLC Graphics III Advertising, Inc. (410)789-7007 or (800)783-1799 It's Not Creative if it doesn't Sell. http://www.g3group.com http://www.g3group.com -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 2:21 PM To: CF-Talk Subject: number of occurrences in a string. Hi All, I am looking for which returns the number of occurrences of a word in a string. It should return the word occurrence count when I pass a word to search in a string. Ketan Patel G3 Technology Group, LLC Graphics III Advertising, Inc. (410)789-7007 or (800)783-1799 It's Not Creative if it doesn't Sell. http://www.g3group.com http://www.g3group.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
I am looking for which returns the number of occurrences of a word in a string. It should return the word occurrence count when I pass a word to search in a string. Try this (watch the wrap): cffunction name=wordcount returntype=numeric output=yes hint=Counts the number of occurences of a given word in a given string cfargument name=word type=string required=yes hint=The word to look for cfargument name=line type=string required=yes hint=The string to search through cfset var wordarray = refind([^[:alpha:]](#arguments.word#)[^[:alpha:]], arguments.line, 1, TRUE) cfif NOT wordarray.len[1] cfreturn 0 /cfif cfreturn arraylen(wordarray.len) /cffunction HTH, Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Try this (watch the wrap): Oops, replace the output=yes with output=no in the cffunction header.Also note that this is a case sensitive search - if you want case insensitive change the refind(...) to refindnocase(...). Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing empty form field entry
Just type cfqueryparam in Google -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 13:27 Aan: CF-Talk CC: Onderwerp: RE: passing empty form field entry Yes Pascal... thanks, the 2nd possibility is where I was at... I was trying to insert an empty string (no value) into a number field and experienced the error ... I would have never known to use the code you show (cfsqltype=CF_SQL_NUMERIC)... Is this code referenced/explained anywhere on the web? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Any suggestion for CF5.0 instead of CFMX. Ketan Patel G3 Technology Group, LLC Graphics III Advertising, Inc. (410)789-7007 or (800)783-1799 It's Not Creative if it doesn't Sell. http://www.g3group.com http://www.g3group.com -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 8:00 AM To: CF-Talk Subject: RE: number of occurrences in a string. I am looking for which returns the number of occurrences of a word in a string. It should return the word occurrence count when I pass a word to search in a string. Try this (watch the wrap): cffunction name=wordcount returntype=numeric output=yes hint=Counts the number of occurences of a given word in a given string cfargument name=word type=string required=yes hint=The word to look for cfargument name=line type=string required=yes hint=The string to search through cfset var wordarray = refind([^[:alpha:]](#arguments.word#)[^[:alpha:]], arguments.line, 1, TRUE) cfif NOT wordarray.len[1] cfreturn 0 /cfif cfreturn arraylen(wordarray.len) /cffunction HTH, Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Will this work in CF5.0 ?
*Now* he says...No, it's MX only.But I _think_ this should do it
(and work on MX too):
cfscript
function wordcount(word, line) {
var wordarray = refind([^[:alpha:]](#word#)[^[:alpha:]], line, 1,
TRUE)
if (NOT wordarray.len[1]) { return 0; }
return arraylen(wordarray.len);
}
/cfscript
No promises on it working though - only MX here so can't test it.
Tim.
---
OUR NEW SITE IS NOW LIVE
Visit our new website at http://www.rawnet.com/ and
race around the beautiful Bracknell streets at
http://xmas.rawnet.com/
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re:Dynamic page processing
Hi all, Sorry it took me sooo long to get back to you all.I've been swamped.Thank you all for your comments and suggestions.I think we've decided to create actual static pages for every page as they are created during the data entry phase.This makes me slightly nervous as it seems somewhat messy, but my coworker is really in favor of this solution.It does seem to have some advantages. Anyway, thanks very much to all! --Cheers, Janice [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
What you are returning here is the number if subexpressions of the first matching word (will always be 2), NOT the wordcount. To count the number of words, you NEED to loop. Also, you will need to escape the word for regular expressions (escape chars like \$^([ and so on). Finally, you probably want to do a REFindNoCase. Look at CountIt (http://www.cflib.org/udf.cfm?ID=304) on cflib.org, but use REFindNoCase instead of FindNoCase with the regexp in the code. There is an escape function for RegExp on cflib too. Pascal -Oorspronkelijk bericht- Van: Tim Blair [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 13:59 Aan: CF-Talk CC: Onderwerp: RE: number of occurrences in a string. Try this (watch the wrap): cffunction name=wordcount returntype=numeric output=yes hint=Counts the number of occurences of a given word in a given string cfargument name=word type=string required=yes hint=The word to look for cfargument name=line type=string required=yes hint=The string to search through cfset var wordarray = refind([^[:alpha:]](#arguments.word#)[^[:alpha:]], arguments.line, 1, TRUE) cfif NOT wordarray.len[1] cfreturn 0 /cfif cfreturn arraylen(wordarray.len) /cffunction [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
What you are returning here is the number if subexpressions of the first matching word (will always be 2), NOT the wordcount. Damn, yes, you're right.I was thinking perl regex.Sorry! #!/usr/bin/perl $word = the; $string = q giw fieo the nigeow the woeifnw io fmewo the miwo; @wordarray = $string =~ /[^[:alpha:]]($word)[^[:alpha:]]/g; print scalar(@wordarray) . \n; :o\ Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Goofy Rows Questions
what version finally worked? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 12:38 AM To: CF-Talk Subject: RE: Goofy Rows Questions I did a hack and made it work, good enough for now, thanks all. Eric _ From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:29 PM To: CF-Talk Tony, thanks for the pointer... Wow...am I out of it... It is breaking at row 1, 3, and 5 instead of 2 4 and 6.Ideas? Eric _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:05 PM To: CF-Talk hello eric. do this. in your looping, check to see if the queryname.currentRow mod 2 and if so, add a tr and start a new row. table tr cfloop query = yourQuery td/td cfif yourQuery.currentRow mod 2 /tr cfelse td/td /cfif /cfloop /table this should work like a charm, closing the row if its the second one, making another cell if its not the second one. and if you wanted to make three of them, just make it mod 3, and so on. hth tony -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:53 PM To: CF-Talk Subject: Goofy Rows Questions This is elementary I am sure, but brain is fried out... I have some records that need to be displayed left to right, 2 columns per row... So, Column 1 Column 2 (record 1) (record 2) (record 3)(record 4) How do I do something this simple?All the monkey business I am figuring out does one long column.*sigh*Why don't they make Jolt cola anymore???! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
(Admin) Respect
Please refrain from personal attacks. They do not reflect the attackers professionalism or even maturity. Remember that everything on this list is archived and an attack today can come back to haunt you at work or other places tomorrow. (remember the Secret Service event as an extreme of that) Thank you -- Michael Dinowitz Finding technical solutions to the problems you didn't know you had yet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
The function doesn't look correct. This should work (I modified it, but didn't test)
function WordInstance(word,string){
var i = 0;
var start = 1;
var exit = false;
var tmp = ;
var special_char_list= \,+,*,?,.,[,],^,$,(,),{,},|,-;
var esc_special_char_list= \\,\+,\*,\?,\.,\[,\],\^,\$,\(,\),\{,\},\|,\-;
word = ReplaceList(word, special_char_list, esc_special_char_list);
string =string ;
while(NOT exit){
tmp=REFindNoCase([^a-z]+#word#[^a-z]+,string,start,true);
if(tmp.pos[0] gt 0){
i=i+1;
start=tmp.pos[0]+tmp.len[0];
}else{
exit = true;
}
}
return i;
}
Pascal
-Oorspronkelijk bericht-
Van: Ketan Patel [mailto:[EMAIL PROTECTED]
Verzonden: vr 17/10/2003 13:42
Aan: CF-Talk
CC:
Onderwerp: RE: number of occurrences in a string.
Does anybody have answer for this .When I use cflib function wordinstance()
sometimes CPU usage will max out ,it reaches its max to 100%.It takes a
good amount of time to open the page. This is the only function which give
me correct results. My concern is when the site will generate good traffic
it will choke the server. I am not sure why. Any help or suggestions are
appreciated.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: passing empty form field entry
http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 13:27 Aan: CF-Talk CC: Onderwerp: RE: passing empty form field entry Yes Pascal... thanks, the 2nd possibility is where I was at... I was trying to insert an empty string (no value) into a number field and experienced the error ... I would have never known to use the code you show (cfsqltype=CF_SQL_NUMERIC)... Is this code referenced/explained anywhere on the web? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Goofy Rows Questions
Eric: http://tutorial140.easycfm.com/ http://tutorial141.easycfm.com/ hth, charlie -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 9:38 PM To: CF-Talk Subject: RE: Goofy Rows Questions I did a hack and made it work, good enough for now, thanks all. Eric _ From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:29 PM To: CF-Talk Tony, thanks for the pointer... Wow...am I out of it... It is breaking at row 1, 3, and 5 instead of 2 4 and 6.Ideas? Eric _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:05 PM To: CF-Talk hello eric. do this. in your looping, check to see if the queryname.currentRow mod 2 and if so, add a tr and start a new row. table tr cfloop query = yourQuery td/td cfif yourQuery.currentRow mod 2 /tr cfelse td/td /cfif /cfloop /table this should work like a charm, closing the row if its the second one, making another cell if its not the second one. and if you wanted to make three of them, just make it mod 3, and so on. hth tony -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:53 PM To: CF-Talk Subject: Goofy Rows Questions This is elementary I am sure, but brain is fried out... I have some records that need to be displayed left to right, 2 columns per row... So, Column 1 Column 2 (record 1) (record 2) (record 3)(record 4) How do I do something this simple?All the monkey business I am figuring out does one long column.*sigh*Why don't they make Jolt cola anymore???! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Constrain on a blob
Thanks for the input all.It appears you can add a 1,1 attribute on the end
to define the start? and span?seems to work more like a wildcard.Still
cant get it case insensitive
-Original Message-
From: Plunkett, Matt [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 4:14 PM
To: CF-Talk
Subject: RE: Constrain on a blob
Hrm, I see the problem.My bad.I looked around on google a bit, but
didn't see any answers beyond using an Oracle Text index on the field.
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 2:07 PM
To: CF-Talk
Subject: Re: Constrain on a blob
No, it doesn't work, dbms_lob is a package and INSTR is a function within
the package. It does not support UPPER.
-Deanna
- Original Message -
From: Plunkett, Matt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 8:52 AM
Subject: RE: Constrain on a blob
To do case insensitive like searches, I use UPPER() on both sides of the
where clause.I haven't tried it here, but WHERE
dbms_lob.INSTR(UPPER(section.text), UPPER('abc'))0 may work fine.
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 9:39 AM
To: CF-Talk
Subject: Re: Constrain on a blob
You should be able to do this (at least it works on clobs)
SELECT header FROM section WHERE dbms_lob.INSTR(section.text, 'abc')0
This performs a case-sensitve LIKE search. I've yet to find any way to do
a
case-insensitive LIKE search.
-Deanna
- Original Message -
From: Sean McCarthy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 6:07 PM
Subject: Constrain on a blob
I get and 'inconsistent datatype' error when I try to:
SELECT
title
FROM
myTable
WHERE
myBlob = 'abc'
Is it possible to constrain on the information in a blob.Optimally I
would
like the ability to do a 'like %foo%'
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Access db Query error
Jochem, That simple change to Unicode support worked. Query runs in about 1.5 seconds now. Thanks! Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 5:07 AM To: CF-Talk Subject: Re: Access db Query error Mark Leder said: cfquery name=indexCitations datasource= timeout=900 SELECT * FROM citationsTable /cfquery I now want to move this over to CFMX 6.1, but running just a simple query to return all records throws the following error (after about 15 seconds): Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. Have you tried the Access with Unicode driver? Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 12:09 pm, Jochem van Dieten wrote: Thomas Chiverton said: On Thursday 16 Oct 2003 17:17 pm, Jochem van Dieten wrote: No account, not even LocalSystem, should have permission to patch core OS files. How would you distribute security updates then ? Log in, assign yourself the apropriate rights, update, revoke rights. And then the attacker has a window to run in... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton said: On Friday 17 Oct 2003 12:09 pm, Jochem van Dieten wrote: Thomas Chiverton said: On Thursday 16 Oct 2003 17:17 pm, Jochem van Dieten wrote: No account, not even LocalSystem, should have permission to patch core OS files. How would you distribute security updates then ? Log in, assign yourself the apropriate rights, update, revoke rights. And then the attacker has a window to run in... Administrators are only allowed to do an interactive login. How many of those can there be at the same time? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Netscape 7.x and CFSTOREDPROC
Ok... This is kind of odd... I have a CFSTOREDPROC that works fine with IE but when we try to call it with Netscape 7.X it crashed...Has anyone else had this sort of problem?? Anyone have any ideas as to how to fix this? Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Goofy Rows Questions
substitute x by whatever number of columns you want cfset x = 2 cfset emptyCells = (x - qTest.recordCount MOD x) MOD x table cfloop query=qTest cfif qTest.currentRow MOD x IS 1 tr /cfif td#qTest.field#/td cfif qTest.currentRow MOD x IS 0 /tr /cfif /cfloop cfif emptyCells cfloop index=i from=1 to=#emptyCells# tdnbsp;/td /cfloop /tr /cfif /table Pascal -Oorspronkelijk bericht- Van: Eric Hoffman [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 6:37 Aan: CF-Talk CC: Onderwerp: RE: Goofy Rows Questions I did a hack and made it work, good enough for now, thanks all. Eric _ From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:29 PM To: CF-Talk Tony, thanks for the pointer... Wow...am I out of it... It is breaking at row 1, 3, and 5 instead of 2 4 and 6.Ideas? Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7.x and CFSTOREDPROC
have you/can you verify the data that is getting passed to the cfstoredproc. browser shouldn't matter apart from the data getting to the cfstored proc.form driven data? url driven data? id look there. cf is server side, so it shouldn't matter ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:38 AM To: CF-Talk Subject: Netscape 7.x and CFSTOREDPROC Ok... This is kind of odd... I have a CFSTOREDPROC that works fine with IE but when we try to call it with Netscape 7.X it crashed...Has anyone else had this sort of problem?? Anyone have any ideas as to how to fix this? Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
I was doing _javascript_ when I posted this. Obviously the first element in the array has index 1 in CF. So replace [0] by [1] in my code.
-Oorspronkelijk bericht-
Van: Pascal Peters
Verzonden: vr 17/10/2003 15:08
Aan: CF-Talk
CC:
Onderwerp: RE: number of occurrences in a string.
The function doesn't look correct. This should work (I modified it, but didn't test)
function WordInstance(word,string){
var i = 0;
var start = 1;
var exit = false;
var tmp = ;
var special_char_list= \,+,*,?,.,[,],^,$,(,),{,},|,-;
var esc_special_char_list= \\,\+,\*,\?,\.,\[,\],\^,\$,\(,\),\{,\},\|,\-;
word = ReplaceList(word, special_char_list, esc_special_char_list);
string =string ;
while(NOT exit){
tmp=REFindNoCase([^a-z]+#word#[^a-z]+,string,start,true);
if(tmp.pos[0] gt 0){
i=i+1;
start=tmp.pos[0]+tmp.len[0];
}else{
exit = true;
}
}
return i;
}
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: One more dumb question
I do not understand this -Original Message- From: Austin Govella [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 5:21 PM To: CF-Talk Subject: Re: One more dumb question Can you change your character encoding to UTF-8? That might enter the apostrophes correctly (sans box) and output them correctly. Or maybe that is the problem and you should switch it to ISO 88... whatever Windows uses (since Access is Windows). -- Austin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7.x and CFSTOREDPROC
I have outputted the variables on the page so I can see them it is the weirdest thing works fine in IE but not NS -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:39 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC have you/can you verify the data that is getting passed to the cfstoredproc. browser shouldn't matter apart from the data getting to the cfstored proc.form driven data? url driven data? id look there. cf is server side, so it shouldn't matter ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:38 AM To: CF-Talk Subject: Netscape 7.x and CFSTOREDPROC Ok... This is kind of odd... I have a CFSTOREDPROC that works fine with IE but when we try to call it with Netscape 7.X it crashed...Has anyone else had this sort of problem?? Anyone have any ideas as to how to fix this? Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: lite source control for Homesite+ ?
You're right, RDS and CVS are not comparable products.All I was saying was that problems with RDS (failure to save files after indicating saved, slow file transfer, missed files in directory searches) were the primary catalyst for us moving to CVS, which in turn embodied a move to a different protocol. I'd wanted to move to CVS for a while but my boss always has the belief that if it's not broke then don't fix it.I was only allowed to move us to CVS after demonstrating that RDS was in fact broke.Perhaps it was our connection, but we are in the same LAN as our servers (albeit a different sub-net and building) but we don't have network issues with any other programs and we had them repeatedly with RDS. My $0.02. Sam -- Blog:http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 3:01 PM To: CF-Talk Subject: RE: lite source control for Homesite+ ? Well, one minute though - it's not really fair since RDS is a means to remotely create, edit, and delete files. CVS is for source control and code manangement. It's apples and oranges. That being said, RDS is NOT perfect, however I think it works quite well most of the time. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7.x and CFSTOREDPROC
that's odd...i cant imagine how a browser could dictate how cf stuff runs on the server...apart from the data it sends to it ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:42 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC I have outputted the variables on the page so I can see them it is the weirdest thing works fine in IE but not NS -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:39 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC have you/can you verify the data that is getting passed to the cfstoredproc. browser shouldn't matter apart from the data getting to the cfstored proc.form driven data? url driven data? id look there. cf is server side, so it shouldn't matter ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:38 AM To: CF-Talk Subject: Netscape 7.x and CFSTOREDPROC Ok... This is kind of odd... I have a CFSTOREDPROC that works fine with IE but when we try to call it with Netscape 7.X it crashed...Has anyone else had this sort of problem?? Anyone have any ideas as to how to fix this? Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 6.0 6.1 on same machine?
One other option I forgot to mention is that you can install CFMX 6.0 and CFMX 6.1 on the same machine at the same time as long as you don't run both of them at the same time. You will have issues with ODBC services as there is a registry reference to the DLL that needs to be changed every time you switch from 6.0 to 6.1 (which can be done with reg/bat files).I had CFMX 6.1 installed on my laptop like this before moving fully to 6.1. Best regards, Sam -- Blog:http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7.x and CFSTOREDPROC
I ficed it... had NO-CACHE on the action page... seems to have corrected thr problems by removing it -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:47 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC that's odd...i cant imagine how a browser could dictate how cf stuff runs on the server...apart from the data it sends to it ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:42 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC I have outputted the variables on the page so I can see them it is the weirdest thing works fine in IE but not NS -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:39 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC have you/can you verify the data that is getting passed to the cfstoredproc. browser shouldn't matter apart from the data getting to the cfstored proc.form driven data? url driven data? id look there. cf is server side, so it shouldn't matter ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:38 AM To: CF-Talk Subject: Netscape 7.x and CFSTOREDPROC Ok... This is kind of odd... I have a CFSTOREDPROC that works fine with IE but when we try to call it with Netscape 7.X it crashed...Has anyone else had this sort of problem?? Anyone have any ideas as to how to fix this? Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7.x and CFSTOREDPROC
Kris Pilles said: I have outputted the variables on the page so I can see them it is the weirdest thing works fine in IE but not NS Does it work from telnet? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
What didn't look right about the function? It's working here. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Developing CF Code on a Linux Machine
What are the available CF code editors for Linux.I love HomeSite but I am sure there is no market demand to port it over to Linux.Any comments? Using VI is not the answer I am looking for.;) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Programmatically set debug options
FuseBox 4 supports a Developer switch.Then when you complete you turn the switch to Production. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 14:32 pm, Jochem van Dieten wrote: Administrators are only allowed to do an interactive login. How many of those can there be at the same time? But any programs they run are now running as admin... you only solve some problems by enforcing this. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Query
The dataset is fairly small .. I doubt it would be over a few hundred records for awhile .. and in a few years maybe up to 2000, so I don't think it will be a huge ordeal. Thanks in advance, I will give it a try! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Friday, October 17, 2003 3:56 AM Subject: Re: OT: SQL Query Paul Giesenhagen said: I have a number of reports all dated, but dated by day (no time). Some of the reports are on the same day If I have an ID value, I need to grab the report before and the report after that ID and it needs to be by date. Here is what the data looks like: ReportID|ReportDate|Report | 19/10/2003 29/11/2003 39/11/2003 49/11/2003 59/12/2003 89/12/2003 99/14/2003 1110/01/2003 etc.. If I am looking at ReportID (5), then I want to know that reportID 4 is previous and reportID 8 is next So my output should be Previous = 4 This > Next = 8 Oh, and I need to know if previous is Nothing or Next is nothing (ie there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Linux Newbie
On Thursday 16 Oct 2003 21:37 pm, Nathan Strutz wrote: a boot manager like grep grub -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton said: On Friday 17 Oct 2003 14:32 pm, Jochem van Dieten wrote: Administrators are only allowed to do an interactive login. How many of those can there be at the same time? But any programs they run are now running as admin... you only solve someproblems by enforcing this. Who is running what as admin? If I log in as Admin and I do something stupid that gives problems. But how is somebody else going to run anything as admin that can replace kernel files? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Traffic Analyzer
Hello folks... I am looking for a traffic analyzer that I can implement into our current site. Basically what we have is a template driven web site for our agent's which gives each of them their own personalized site. What I need to do is give them the ability to track visitors to their site and report on things like refers and keywords so that they can monitor who is linking to them and what search engines are bringing them visitors. If anyone has any idea where I could find some type of ColdFusion application that doses something like this please let me know. Not sure how involved this would be to build from scratch and I kind of have a time constraint. Any help would be appreciated. Thanks - Neal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Developing CF Code on a Linux Machine
What are the available CF code editors for Linux. I use JEdit: http://www.jedit.org/ You could also try Eclipse: http://www.eclipse.org/ Tim. PS.Vi rocks!:) --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Well, performance is relative. However, it is a solution which overcomes
a lack of native support for an IP data type and addresses Dave's
requirement that everything must happen in the query itself.
As I said, this bit of code was excerpted and adapted from a DNSBL we
run. We found that this chunk of code, when executing it against 150,000
records, was too slow to be used in real time DNS requests. The DNS
requests would take about 5 seconds, which meant that our SMTP banner
would take just as long to appear. There is actually a good deal more
going on, but that's the gist of it.
Our solution was to convert the query to a view. A scheduled task runs
every 15 minutes and populates a table from the view. Now, DNS requests
take milliseconds and the SMTP banner appears almost immediately.
So, for us, performance was an issue, but we did not have similar
requirements to Dave.
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 4:35 AM
To: CF-Talk
Subject: Re: Sorting IP Addresses
That sounds like it could perform poorly, would it?
- Calvin
- Original Message -
From: Benjamin S. Rogers
To: CF-Talk
Sent: Thursday, October 16, 2003 4:38 PM
Subject: RE: Sorting IP Addresses
that doesn't work perfectly.
166.141.22.4
166.141.22.40
166.141.22.41
166.141.22.47
166.141.22.48
166.141.22.5
Sorry about that. I forgot to convert the substrings to integers. Try
this:
SELECT *
FROM SourceIPSpamCount
ORDER BY
CONVERT(INT, SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, SUBSTRING(SourceIP, CHARINDEX('.', SourceIP) +
1,CHARINDEX('.', SourceIP, CHARINDEX('.', SourceIP) + 1) -
CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1, CHARINDEX('.', REVERSE(SourceIP),
CHARINDEX('.',
REVERSE(SourceIP)) + 1) - CHARINDEX('.', REVERSE(SourceIP)) - 1))),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), 1, CHARINDEX('.',
REVERSE(SourceIP)) - 1)))
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Developing CF Code on a Linux Machine
On Friday 17 Oct 2003 15:07 pm, David Adams wrote: What are the available CF code editors for Linux.I love HomeSite but I am sure there is no market demand to port it over to Linux.Any comments? jEdit -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Sorry about that. I was busy yesterday, but I saw a question that I thought I could provide one possible answer too so I rattle it off a couple of e-mails without looking back at the thread. And I didn't take offense to Jochem's quip: my apologies to Jochem if it seemed that way. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 4:45 PM To: CF-Talk Subject: RE: Sorting IP Addresses not for me :) im not the one lookin, it was , david delbridge. and don't mind jochem, I think that's just his brand of humor. although not very funny sometimes, its just jochem, and we deal. he is a db wizard. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 4:33 PM To: CF-Talk Subject: RE: Sorting IP Addresses Sure. I would use: SELECT* FROM SourceIPSpamCount ORDER BYSourceIP But I don't use MS SQL Server ;-) I'm afraid that comment was lost on me? If you could give me a bit more information, perhaps I could come up with an equivalent in SQL Server for Tony. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Merchant Account Suggestions
I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
the for loop isn't right: 1. if it doesn't find a match, it continues looping 2. if there is a match, start will become greater than the string length 3. the word is not escaped for special chars in regexp 4. when the new start position is set, it isn't set to the right place (should be +Len(word)+2, but this isn't a problem, it is just not efficient). Look at the code I posted, I think it will be more efficient. Maybe the 4th attribute of REFindNoCase can be dropped and the length to add can be calculated from the original word before escaping. -Oorspronkelijk bericht- Van: Raymond Camden [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 15:52 Aan: CF-Talk CC: Onderwerp: RE: number of occurrences in a string. What didn't look right about the function? It's working here. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted.So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a oh, do we HAVE to! budget and timeline.It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS Hi all, RS Has anyone here implemented a high volume site using CF FORUM 2000? RS We have just inherited one, and am wondering how solid the code is. RS Its a very busy forum, doing about 3 gigs of traffic per day, and its RS started to show signs of breaking down, e.g. deadlock errors, RS timeouts, No more data available to read errors. RS Should I be looking for different forum software? Or re-write the code RS myself? RS Has anyone done an optimisation job on the CFFORUM code and can give a RS few pointers on where the bottlenecks are? RS thanks, bye! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Yes but. it looks nice. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:35 AM To: CF-Talk Subject: RE: CF Forum 2000 Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted.So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a oh, do we HAVE to! budget and timeline.It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS Hi all, RS Has anyone here implemented a high volume site using CF FORUM 2000? RS We have just inherited one, and am wondering how solid the code is. RS Its a very busy forum, doing about 3 gigs of traffic per day, and its RS started to show signs of breaking down, e.g. deadlock errors, RS timeouts, No more data available to read errors. RS Should I be looking for different forum software? Or re-write the code RS myself? RS Has anyone done an optimisation job on the CFFORUM code and can give a RS few pointers on where the bottlenecks are? RS thanks, bye! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Authorize.net is very easy to setup and use. -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 15:15 pm, Jochem van Dieten wrote: Who is running what as admin? If I log in as Admin and I do something stupid that gives problems. But how is somebody else going to run anything as admin that can replace kernel files? You don't have to be doing something stupid to trigger a trojon. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Help me out...are we talking about the following forum here??? http://www.cfcode.com/index.cfm/fuse/forumdetails.htm Let me know...Ch -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:43 AM To: CF-Talk Subject: RE: CF Forum 2000 Yes but. it looks nice. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:35 AM To: CF-Talk Subject: RE: CF Forum 2000 Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted.So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a oh, do we HAVE to! budget and timeline.It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS Hi all, RS Has anyone here implemented a high volume site using CF FORUM 2000? RS We have just inherited one, and am wondering how solid the code is. RS Its a very busy forum, doing about 3 gigs of traffic per day, and its RS started to show signs of breaking down, e.g. deadlock errors, RS timeouts, No more data available to read errors. RS Should I be looking for different forum software? Or re-write the code RS myself? RS Has anyone done an optimisation job on the CFFORUM code and can give a RS few pointers on where the bottlenecks are? RS thanks, bye! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Somebody wrote IP, network and MAC data types for PostgreSQL, And how far along are they in porting that to Windows? :) including support for the big seven operators. So I could just use the IP datatype for SourceIP and everything would work automagically: That's pretty handy. Out of curiosity, does it also include functions for selecting individual octets? If not, how about user defined functions? That would make it useful for what we're doing. Since it is my understanding that you can't write your own operators in MS SQL Server, I doubt this is going to fly. I don't know of a SQL Server equivalent functionality wise. Perhaps Yukon with C# will address this, though a multi-thousand dollar upgrade for an IP datatype would just be silly. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Antivirus software on web server
You don't have to be doing something stupid to trigger a trojon. I would classify unnecessary use of Administrator privileges as something stupid. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton said: On Friday 17 Oct 2003 15:15 pm, Jochem van Dieten wrote: Who is running what as admin? If I log in as Admin and I do something stupid that gives problems. But how is somebody else going to run anything as admin that can replace kernel files? You don't have to be doing something stupid to trigger a trojon. What would be a non-stupid way for an admin to trigger a trojan on his server? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Server Administration
Sorry for the OT post, but I know plenty of people on here work with SQL Server. We're running SQL Server 7 that hosts a few large databases for internal use.One of them is Saleslogix, if any of you work with that.I was reassigning accounts (like 3500) from Saleslogix's administrator (which executes a big batch update), and that action makes that database unusuable for everyone else. My belief is there should be some way to balance this out, either by user or machine.Basically, I don't want the Administrator to ever push that database so hard that it's making it COMPLETELY unusuable for everyone else. I can accept slow down, and I can accept the Adminstrative things (like reassigning accounts) going slower. I can see where I can change the amount of memory SQL can consume, the number of processor threads, the windows priority settings, but nothing to limit a particular machine/user from gobbling up all the resources. I'm certainly no DBA, but was hoping someone might shed some light.Thanks for any help! --- Josh Remus Network Manager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Traffic Analyzer
Hi Neil, Did you look at Statistex on CFTagStore.com by Shawn Wellman? http://www.cftagstore.com/index.cfm/page/viewtag/tagId/31 Regards, Dan. -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 15:19 To: CF-Talk Subject: CF Traffic Analyzer Hello folks... I am looking for a traffic analyzer that I can implement into our current site. Basically what we have is a template driven web site for our agent's which gives each of them their own personalized site. What I need to do is give them the ability to track visitors to their site and report on things like refers and keywords so that they can monitor who is linking to them and what search engines are bringing them visitors. If anyone has any idea where I could find some type of ColdFusion application that doses something like this please let me know. Not sure how involved this would be to build from scratch and I kind of have a time constraint. Any help would be appreciated. Thanks - Neal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFHTTP Question!
Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
I'm not a regex guru, but what about using the \b boundry: cfset s = This is the beginning of the Beg. I don't beg for crap when I begin. cfset foo = reFindNoCase(\b(beg)\b,s,1,true) cfdump var=#foo# This seems to work well. In a UDF you would just return the arrayLen of foo.pos. Does this seem right to others? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Verity K2 Spider Missing Some Titles
On Thu, 16 Oct 2003 16:36:34 -0400, in cf-talk you wrote: I'm using VK2 spider (bundled with the old CF5) to crawl a Web site. Some indexed CFM pages are returning titles, while others are not. I've painstakingly compared view-source code from pages that do have titles in the index, and those that don't: I can't find *any* common element(s) in the code that might prevent a title from being parsed/collected. Does anyone have any ideas as to what the problem/solution might be? Problem solved. Reluctant admission, but for posterity: Original problem was with HTML comments before the html tag. This prevented title gathering. When these were removed, titles still weren't being collected, but this time, it was because IIS was pointing to an old codebase, and our comment removal hadn't been done there. Duh, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Nope, I stand corrected, you still need to loop. But \b may be better than [^a-z]+. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Of course I'm biased but I'd have to disagree on that.;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com http://www.terrapayments.com/ (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Benjamin S. Rogers said: Somebody wrote IP, network and MAC data types for PostgreSQL, And how far along are they in porting that to Windows? :) SRA and some others sell commercial versions, 7.2.1 is available as a free source distribution. including support for the big seven operators. So I could just use the IP datatype for SourceIP and everything would work automagically: That's pretty handy. Out of curiosity, does it also include functions for selecting individual octets? If not, how about user defined functions? That would make it useful for what we're doing. There isn't really code to select individual octets, but you could write something for it in any of the available procedural languages. But do you really want to select individual octets or is that just the workaround you use now? Because there are operators to check for subnet inclusion and functions to calculate broadcast address, network address etc from subnet definitions. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Wouldn't it be faster to use a Lower() on the string rather than REFindNoCase? I thought that doing a NoCase does the search twice, so on long strings, it could be slower... Just a thought -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:02 AM To: CF-Talk Subject: RE: number of occurrences in a string. I'm not a regex guru, but what about using the \b boundry: cfset s = This is the beginning of the Beg. I don't beg for crap when I begin. cfset foo = reFindNoCase(\b(beg)\b,s,1,true) cfdump var=#foo# This seems to work well. In a UDF you would just return the arrayLen of foo.pos. Does this seem right to others? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Uh oh, my bad. I was talking about the old Allaire forums which went open-source. http://www.houseoffusion.com/forumspot Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:46 AM To: CF-Talk Subject: RE: CF Forum 2000 Help me out...are we talking about the following forum here??? http://www.cfcode.com/index.cfm/fuse/forumdetails.htm Let me know...Ch -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:43 AM To: CF-Talk Subject: RE: CF Forum 2000 Yes but. it looks nice. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:35 AM To: CF-Talk Subject: RE: CF Forum 2000 Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted. So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a oh, do we HAVE to! budget and timeline.It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS Hi all, RS Has anyone here implemented a high volume site using CF FORUM 2000? RS We have just inherited one, and am wondering how solid the code is. RS Its a very busy forum, doing about 3 gigs of traffic per day, and its RS started to show signs of breaking down, e.g. deadlock errors, RS timeouts, No more data available to read errors. RS Should I be looking for different forum software? Or re-write the code RS myself? RS Has anyone done an optimisation job on the CFFORUM code and can give a RS few pointers on where the bottlenecks are? RS thanks, bye! _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that.;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com http://www.terrapayments.com/ (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 15:58 pm, Dave Watts wrote: You don't have to be doing something stupid to trigger a trojon. I would classify unnecessary use of Administrator privileges as something stupid. But you don't have be doing something stupid (like unnecessary use of Administrator privileges) to be caught out. At some point you have to trust (say) your external DNS to really give you the real patch file you asked for, as oppsoed to Something Nasty. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
I always assumed it said, match A or a, not search twice. I guess it depends on what is happening at the lowest level. I've never seen any recommendations in the past to not use findNoCase or reFindNocase (or etc). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
\b only on cfmx. As I said before, the array created will give you the number of subexpressions (2: the entire regexp and the subexpr (beg)) of the first match. In cf you need a loop. Try putting 3 beg's in your string. Pascal -Oorspronkelijk bericht- Van: Raymond Camden [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 17:01 Aan: CF-Talk CC: Onderwerp: RE: number of occurrences in a string. I'm not a regex guru, but what about using the \b boundry: cfset s = This is the beginning of the Beg. I don't beg for crap when I begin. cfset foo = reFindNoCase(\b(beg)\b,s,1,true) cfdump var=#foo# This seems to work well. In a UDF you would just return the arrayLen of foo.pos. Does this seem right to others? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 15:53 pm, Jochem van Dieten wrote: You don't have to be doing something stupid to trigger a trojon. What would be a non-stupid way for an admin to trigger a trojan on his server? DNS poisioning when you downloaded the patch file, for instance. On UNIX boxes, a local attacker could have altered an alias for a common command to fetch, compile and insert a Nasty kernel module and then waited for you to run that command. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
It would have to do the search more than twice, it woudl have to do every possible case combination of either the string or the RE.I suspect that internally it just does a LOWER or UPPER on both the RE and the string. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 8:15 AM To: CF-Talk Subject: RE: number of occurrences in a string. Wouldn't it be faster to use a Lower() on the string rather than REFindNoCase? I thought that doing a NoCase does the search twice, so on long strings, it could be slower... Just a thought [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
We're in the midst of a revamp on the corporate site so some info is not very apparent, please checkout the faq for pricing info https://payment.firepay.com/surefire/ccs/reg/faq.jsp As for the setup fees...waived for cf-talk folks! (just be sure to give me a holler) Cheers, Stace _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:22 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that.;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com http://www.terrapayments.com/ (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
sweet.I didn't know! thanks. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:31 AM To: CF-Talk Subject: RE: Merchant Account Suggestions We're in the midst of a revamp on the corporate site so some info is not very apparent, please checkout the faq for pricing info https://payment.firepay.com/surefire/ccs/reg/faq.jsp As for the setup fees...waived for cf-talk folks! (just be sure to give me a holler) Cheers, Stace _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:22 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that.;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com http://www.terrapayments.com/ (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
Allan, What is the URL you need to type into a browser in order to run menu.asp? That is the URL you need to specify for using CFHTTP. (Remember when using CFHTTP it is the ColdFusion server running the request so the URL needs to be from the perspective of what the ColdFusion server can see the menu.asp page as which could mean using a 127.0.0.1 or localhost address since it is on the same server. Also, in general better to use IP addresses to avoid domain name resolution issues though you loose the obvious benefits.) Andr -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:01 To: CF-Talk Subject: CFHTTP Question! Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Ok last post from me in regards to this advertising frenzy;-) I realize we may not be a household name but rest assured we've been around for years. Here are some quick notes on us: - We currently process in excess of 1 Billion dollars a year - We do CCs and checks - We're International, supporting a wide array of currencies - One of the fastest payment gateways on the planet - We specialize in high risk transactions (i.e. extensive fraud prevention) - We are not a reseller, but we do offer reseller programs - Easy CF, PHP, Java, Com integration - Macromedia Partner - No setup fees if you go thru me - I do not earn any commission; I just believe we offer great service. :) I'm done! Back to regular scheduled CF programming... Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:34 AM To: CF-Talk Subject: RE: Merchant Account Suggestions sweet.I didn't know! thanks. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:31 AM To: CF-Talk Subject: RE: Merchant Account Suggestions We're in the midst of a revamp on the corporate site so some info is not very apparent, please checkout the faq for pricing info https://payment.firepay.com/surefire/ccs/reg/faq.jsp As for the setup fees...waived for cf-talk folks! (just be sure to give me a holler) Cheers, Stace _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:22 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that.;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com http://www.terrapayments.com/ (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFHTTP Question!
This is the code I have got on my Coldfusion file CFHTTP url="" METHOD=GET RESOLVEURL=true throwonerror=yes/ cfoutput#CFHTTP.FileContent# /cfoutput I get an error: You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. Can somebody tell me what am I doing wrong Thanks Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SES urls on CFMX6.1 installed on top of JRun
I'm running CFMX6.1 installed on top of JRun, Win XP pro, and i can't get search engine safe (SES) urls to work. --- -- START TESTS --- no dummy extension --- URL http://127.0.0.1/index.cfm/this/that RESULT headtitleJRun Servlet Error/title/headh1404 /index.cfm/this/that/h1body /index.cfm/this/that/body --- .htm dummy extension --- URL http://127.0.0.1/index.cfm/this/that.htm RESULT: headtitleJRun Servlet Error/title/headh1404 /index.cfm/this/that.htm/h1body /index.cfm/this/that.htm/body --- .cfm dummy extension --- URL http://127.0.0.1/index.cfm/this/that.cfm RESULT - standard CFMX error: Error Occurred While Processing Request File not found: /index.cfm/this/that.cfm Please try the following:etc etc -- END TESTS - I had no problems when running CFMX6.0 with the built in JRun - this has only been a problem with 6.1 on the full JRun. Any help/advise/anything gratefully received. TIA Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton wrote: On Friday 17 Oct 2003 15:53 pm, Jochem van Dieten wrote: You don't have to be doing something stupid to trigger a trojon. What would be a non-stupid way for an admin to trigger a trojan on his server? DNS poisioning when you downloaded the patch file, for instance. On UNIX boxes, a local attacker could have altered an alias for a common command to fetch, compile and insert a Nasty kernel module and then waited for you to run that command. That is what checksums are for. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFHTTP Question!
When I browse the asp file in the browse, it displays the menu on the browser. This is the url I'm using: http://myProject/site/includes/topmenu/folder2/menu.asp But when I include this url in cfhttp I get You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. error. Here is my code: CFHTTP url="" METHOD=GET RESOLVEURL=true throwonerror=yes/ cfoutput#CFHTTP.FileContent# /cfoutput Am I missing some attributes in my cfhttp tag? Allan, What is the URL you need to type into a browser in order to run menu.asp? That is the URL you need to specify for using CFHTTP. (Remember when using CFHTTP it is the ColdFusion server running the request so the URL needs to be from the perspective of what the ColdFusion server can see the menu.asp page as which could mean using a 127.0.0.1 or localhost address since it is on the same server. Also, in general better to use IP addresses to avoid domain name resolution issues though you loose the obvious benefits.) Andr -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:01 To: CF-Talk Subject: CFHTTP Question! Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
Most likely there are directory permissions setup on this folder and that you are logged into your network with an account that has permission to view this directory. Which is why you are able to browse the file. However CFHTTP can not because it is making a request like I would be if I where to click the link. I can not verify that this is the problem because you left your domain out of the URL that you provided. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:55 AM To: CF-Talk Subject: Re:CFHTTP Question! When I browse the asp file in the browse, it displays the menu on the browser. This is the url I'm using: http://myProject/site/includes/topmenu/folder2/menu.asp [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFHTTP Question!
As a side thought If that menu.asp is actually just a bunch of html with no asp code in there, the you could just use cfinclude to drag it into your cf code. Or you could bin that asp junk altogether and.~joking~ ;o) Andre Mohamed wrote: Allan, What is the URL you need to type into a browser in order to run menu.asp? That is the URL you need to specify for using CFHTTP. (Remember when using CFHTTP it is the ColdFusion server running the request so the URL needs to be from the perspective of what the ColdFusion server can see the menu.asp page as which could mean using a 127.0.0.1 or localhost address since it is on the same server. Also, in general better to use IP addresses to avoid domain name resolution issues though you loose the obvious benefits.) Andr -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:01 To: CF-Talk Subject: CFHTTP Question! Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
If you are actually on the ColdFusion server can you browse to that same URL? Andr -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:55 To: CF-Talk Subject: Re:CFHTTP Question! When I browse the asp file in the browse, it displays the menu on the browser. This is the url I'm using: http://myProject/site/includes/topmenu/folder2/menu.asp But when I include this url in cfhttp I get You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. error. Here is my code: CFHTTP url=""> METHOD=GET RESOLVEURL=true throwonerror=yes/ cfoutput#CFHTTP.FileContent# /cfoutput Am I missing some attributes in my cfhttp tag? Allan, What is the URL you need to type into a browser in order to run menu.asp? That is the URL you need to specify for using CFHTTP. (Remember when using CFHTTP it is the ColdFusion server running the request so the URL needs to be from the perspective of what the ColdFusion server can see the menu.asp page as which could mean using a 127.0.0.1 or localhost address since it is on the same server. Also, in general better to use IP addresses to avoid domain name resolution issues though you loose the obvious benefits.) Andr -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:01 To: CF-Talk Subject: CFHTTP Question! Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Forum 2000
Jim Davis wrote: Actually - if I remember correctly - CF Forums was never encrypted.So no matter what version you have you should be able to dig in. I have looked it over a few times over the last years, but since it was never released under an OSI approved Open Source license I never released any code. And with all the new features that MX offers, it is probably better to start from scratch. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic page processing
Publishing static pages translate to a more complex admin process, but much less load on the public side.I love what they do for me, personally, and use them wherever possible.Embrace the horror :D Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
