access to the cf server settings
Is it possible to access to the CFMX server settings in a CF script. I am interested in getting the list of mapped directories. Many thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: access to the cf server settings
Eric Chataign said: Is it possible to access to the CFMX server settings in a CF script. I am interested in getting the list of mapped directories. cflock name=serviceFactory type=exclusive timeout=10 cfscript factory = CreateObject(java, coldfusion.server.ServiceFactory); rt_service = factory.runtimeservice; mappings = rt_service.mappings; /cfscript cfdump var=#mappings# /cflock IIRC you need to be logged in as Admin since Updater 3. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DateFormat misery
Hello everybody, I can't understand what's happenning here. I have form with a text field and a date selector that pops up when a user clicks on a img next to the text field. If I select a date from the calendar, say for example I selected this: 5/1/2004 11:04 (05 Jan. 2004), the text field is set to 5/1/2004 11:04. I'm passing this value in a url variable. On the action page when I output this url variable the value displayed is the same (5/1/2004 11:04), however if I do this: cfoutput#dateFormat(url.timestamp,'/mm/dd')#/cfoutput, the output value is 2004/05/01 when I expect it to be 2004/01/05. Can anybody tell me what's happenning here because I can't figure it out why this is happenning. I am using CFMX Best Regards, CFCODER __ Do you Yahoo!? Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DateFormat misery
Probably, your locale is US, so it formats a US date (mm/dd/). I always use ISO-format and if I have a text field with a date, I write a function to transform it to ISO (-mm-dd). -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: vrijdag 27 februari 2004 12:11 To: CF-Talk Subject: DateFormat misery Hello everybody, I can't understand what's happenning here. I have form with a text field and a date selector that pops up when a user clicks on a img next to the text field. If I select a date from the calendar, say for example I selected this: 5/1/2004 11:04 (05 Jan. 2004), the text field is set to 5/1/2004 11:04. I'm passing this value in a url variable. On the action page when I output this url variable the value displayed is the same (5/1/2004 11:04), however if I do this: cfoutput#dateFormat(url.timestamp,'/mm/dd')#/cfoutput, the output value is 2004/05/01 when I expect it to be 2004/01/05. Can anybody tell me what's happenning here because I can't figure it out why this is happenning. I am using CFMX Best Regards, CFCODER __ Do you Yahoo!? Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DateFormat misery
On Friday 27 Feb 2004 11:11 am, cf coder wrote: if I do this: cfoutput#dateFormat(url.timestamp,'/mm/dd')#/cfoutput, What about lsDateFormat ? -- 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: DateFormat misery
I've just noticed that if the date selected is 20/2/2004 11:35, dateformat correctly outputs it - 2004/02/20 (/mm/dd), but if the date selected is 5/2/2004 11:35, the output is - 2004/05/02. I have the meta tag on top of my page meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 Any thoughts? Probably, your locale is US, so it formats a US date (mm/dd/). I always use ISO-format and if I have a text field with a date, I write a function to transform it to ISO (-mm-dd). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to know when you have the last record?
CFIF myquery.CurrentRow NEQ myquery.RecordCount Worked perfectly. Just out of interest, you could use one of the methods of the underlying coldfusion.sql.QueryTable java object of the query: isLast() For example, to output a list of names from a query with a comma between each, you don't want a comma added afte rthe last one, so: cfoutput query=variables.myQuery #variables.myQuery.name# cfif NOT variables.myQuery.isLast(),/cfif /cfoutput And before anyone says, yes I know you can use valuelist() - it's just a simple example...:) Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- 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: DateFormat misery
LSDateFormat does the trick. Thank you all for your help I've just noticed that if the date selected is 20/2/2004 11:35, dateformat correctly outputs it - 2004/02/20 (/mm/dd), but if the date selected is 5/2/2004 11:35, the output is - 2004/05/02. I have the meta tag on top of my page meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 Any thoughts? Probably, your locale is US, so it formats a US date (mm/dd/). I always use ISO-format and if I have a text field with a date, I write a function to transform it to ISO (-mm-dd). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DateFormat misery
That's becausethe 20th month doesn't exist. It is a CF feature that it will switch day and month in a date if the month is higher than 12 (and the switched date exists) -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: vrijdag 27 februari 2004 11:48 To: CF-Talk Subject: Re: DateFormat misery I've just noticed that if the date selected is 20/2/2004 11:35, dateformat correctly outputs it - 2004/02/20 (/mm/dd), but if the date selected is 5/2/2004 11:35, the output is - 2004/05/02. I have the meta tag on top of my page meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 Any thoughts? Probably, your locale is US, so it formats a US date (mm/dd/). I always use ISO-format and if I have a text field with a date, I write a function to transform it to ISO (-mm-dd). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
My companies live hosting server was recently upgraded to Coldfusion MX6.1 .. and the latest MDAC / Jet Drivers have been updated also. The problem is that all coldfusion sites on the server using access db's stop working every 2 days or so (more often if traffic is high).. the only way to get it running again is to restart the whole server. We certainly have this problem too, I just don't know the solution. Does anyone else? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
error 32
I'm getting an error message when I try to replace an Excel Spreadsheet (CFFILE on a CF 5.0 Server) that says the file is being used by another process. The file has an ODBC connection. I unchecked the Maintain Connection box, but that didn't help. Anyone run into this problem? Rick Lansford WebMaster Gwinnett Health System 678-442-4422 Happiness is an empty mailbox. This email communication, including any attached files, may contain material that is protected, proprietary, privileged, confidential, or otherwise legally exempt from disclosure. This communication is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient or the person responsible for delivering this communication to the intended recipient, you are prohibited from retaining, using, disseminating, forwarding, printing or copying this communication or taking any action based on the contents of this communication. If you have received this communication in error, please immediately notify the sender by replying to this email, and then delete the original message and attachments. -Gwinnett Hospital System [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: access to the cf server settings
I wrote a CF wrapper to manage all this, list, add, delete, edit CF mappings, download from http://www.beynon.org.uk/downloads/mappings.zip John. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 09:53 To: CF-Talk Subject: Re: access to the cf server settings Eric Chataign said: Is it possible to access to the CFMX server settings in a CF script. I am interested in getting the list of mapped directories. cflock name=serviceFactory type=exclusive timeout=10 cfscript factory = CreateObject(java, coldfusion.server.ServiceFactory); rt_service = factory.runtimeservice; mappings = rt_service.mappings; /cfscript cfdump var=#mappings# /cflock IIRC you need to be logged in as Admin since Updater 3. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question regarding CFMX 6.2 - UPDATE
Hi Ben Any more news on this problem ?? any workarounds available ? Ian -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 12:54 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 No, but I'll check. --- Ben _ From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 3:55 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Any update on connecting to IBM Univers database from Macromedia, has this been confirmed as a bug ?or have they come up with any solution why it does not work with MX but does with 4.5 ? If it is a bug it would be good if it could be resolved! -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 18:56 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Nothing is final. But you hit the nail on the head, every piece of software in existence (including the CF apps that us CF developers write) could be updated and patched and improved. Some updates are vital, some are insignificant, and the vast majority sit somewhere between those two extremes. And so judgment calls have to be made, recognizing that while updates are important, they have a tremendous cost and impact on core product delivery. And too many incremental updates are disruptive (look at Microsoft, and how often that annoying automatic update utility kicks in). It's about balance. As I already said, critical issues (for example, security holes, or anything that could crash a server) take top priority, beyond that it's a judgment call. We have releases a few hot fixes, they may be more, we'll work it out as is needed. For now, keep us informed of any and all issues, we'll try to maintain the right balance. --- Ben _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 1:45 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 No planned maintenance release anytime soon? Sigh, that is too bad, I was hoping some of the minor issues would be addressed in CFMX 6.1 soon.But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Has black stone entered Beta testing yet?I should maybe get in that program and see if I can get some of these issues addressed, if they have not been yet. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:57 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Right now we are aggressively working on Blackstone. That is not to say that there'll not be a release between now and then, but I am unaware of any planned maintenance release at this point. If one becomes critical and necessary, then I am sure that one will be released (if hot fixes are not an option). --- Ben _ From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 12:50 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Correct me if I'm wrong but aren't there still bugs and known issues with 6.1. Are you suggesting that there are no immediate plans to address these? Thanks Kola -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 16:29 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 CFMX 6.2? I don't believe that version numbers and editions have been discussed at all, actually. Generally, maintenance releases have been free upgrades (as 6.1 was) whereas full product releases have been paid upgrades (and included in subscriptions, of course). The next planned version of ColdFusion is codenamed Blackstone, and version numbers, pricing, etc., have yet to be discussed at all. But, and this is my own opinion here, I doubt that there will be another maintenance release for CFMX any time soon. CFMX needed updates, which is why we released service packs and then v6.1, But 6.1 has proven to be reliable and solid and arguably one of the best ColdFusion's ever, and so a maintenance release is unlikely. Bottom line, use 6.1 now, and stay tuned for announcements from MM. --- Ben _ From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:16 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 I am wondering, will CF 6.2 be a free upgrade from 6.1 or will MM want us to pay for it? And if $$$ is involved, how much? TK -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 10:21 AM To:
Decrypt an encrypted CFM template
I wrote a CFM template about a year ago (in CF5) and I encrypted it for redistribution to some clients.Since that time, I lost the original. Does anyone know of a location where I can get a precompiled decrypter so I don't have to write it all over again?I've done a bit of googling and found some source codes, but I need something precompiled to run on a windows machine.Command line programs would work as well.Thanks in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
We are experiencing this problem also. I have tried the hotfixes on Macromedia's site, which do not really apply to MS Access but it couldn't hurt. We have an application that requires a large recordset to be returned (~1 records), CFQUERY caching helps somewhat but the problem exists whenever the cache is cleared. I think that Access just cannot handle the load, the ODBC Server hangs first, then CFMX Server. When I notice the spiking, I restart CFMX Server first, then the ODBC Server and finally the ODBC Client in that order, that prevents me from rebooting the entire server. Nothing I have tried has really helped other than employing my own caching strategy using Application variables, but the dataset is so large that Access chokes. I will be moving the app over to MySQL pretty soon but I was holding out for MySQL 4.1 to be released in full before I do so because we have some queries with subqueries that cannot be rewritten. Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Decrypt an encrypted CFM template
Google it, 'cfdecrypt' and you find http://shroom.dv8.org/cfd/ Jb. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 14:30 To: CF-Talk Subject: Decrypt an encrypted CFM template I wrote a CFM template about a year ago (in CF5) and I encrypted it for redistribution to some clients.Since that time, I lost the original. Does anyone know of a location where I can get a precompiled decrypter so I don't have to write it all over again?I've done a bit of googling and found some source codes, but I need something precompiled to run on a windows machine.Command line programs would work as well.Thanks in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Decrypt an encrypted CFM template
Last time I checked there were some commercial decrypters floating around for about $20 per copy. Sorry, I don't have a link handy, but they were not hard to find last time I checked. TK -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 9:30 AM To: CF-Talk Subject: Decrypt an encrypted CFM template I wrote a CFM template about a year ago (in CF5) and I encrypted it for redistribution to some clients.Since that time, I lost the original. Does anyone know of a location where I can get a precompiled decrypter so I don't have to write it all over again?I've done a bit of googling and found some source codes, but I need something precompiled to run on a windows machine.Command line programs would work as well.Thanks in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX admin on server
Hi: I'm new to the list and fairly new to CF.Have uploaded my first site to a CFMX host (not in house) and am slowly converting the site to CF pages.Here is the difficulty: I don't know how to administrate the website on the server side.I know how to set up the Application.cfm file to determine which DSN to select based upon a query, but how do I let the CF Administrator on the server know what the mapping to my remote database is? Or, is this even necessary? Thanks, Terri [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Donnie Bachan said: We are experiencing this problem also. I have tried the hotfixes on Macromedia's site, which do not really apply to MS Access but it couldn'thurt. We have an application that requires a large recordset to be returned(~1 records), CFQUERY caching helps somewhat but the problem existswhenever the cache is cleared. I think that Access just cannot handle the load, the ODBC Server hangsfirst Have you tried the unicode driver? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX admin on server
You'd have to ask your host to do that for you, unless they have some sort of control panel where they let you do it yourself, Jb. -Original Message- From: Terri Hodgson [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 14:39 To: CF-Talk Subject: CFMX admin on server Hi: I'm new to the list and fairly new to CF.Have uploaded my first site to a CFMX host (not in house) and am slowly converting the site to CF pages.Here is the difficulty: I don't know how to administrate the website on the server side.I know how to set up the Application.cfm file to determine which DSN to select based upon a query, but how do I let the CF Administrator on the server know what the mapping to my remote database is? Or, is this even necessary? Thanks, Terri [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Jochem Have you tried the unicode driver? Any particular reason why this might help? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Decrypt an encrypted CFM template
I'm not sure the community feeling about decrypters here in CF land (I know where the Flash community stands), but I 'm sure I wil lfind out. Use this only for good, not evil. =) http://www.cse.unsw.edu.au/~matthewc/files/cfdecrypt.zip (This is from the guy who wrote all the C source you see around the net.) Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Improving stored procedure
Is there a way to improve this stored procedure? It is basically a search for titles.We have a title and subtitle column in the database.This stored procedure takes over 60 seconds to run, while other queries to the database take less than a second.I noticed in the database design, that title and subtitle are designed at nvarchar (255). Database - SQL Server 2000 on Windows 2000 with 4 Xeons and 2GB Ram (The database itself it about 350MB, about 50,000 rows) Servers - Windows 2000 with Website Professional 3.0 and CF5.2 Xeon 2.8 GHz and 2 GB Ram. Thanks is advance. FYI - I am using * in the select because we output all the colunms. CREATE PROC GeneralDVDMovies_Title @searchTitle varchar(50), @searchTitle2 varchar(50), @searchTitle3 varchar(50) AS IF( @searchTitle = @searchTitle2 AND @searchTitle2 = @searchTitle3) SELECT TOP 550 * FROM GeneralDVD WHERE (title like @searchTitle or subtitle like @searchTitle) AND url IS NOT NULL AND (BackOrder NOT LIKE '%HR%' ORBackOrder IS NULL) Order by title ELSE SELECT TOP 550 * FROM GeneralDVD WHERE (title like @searchTitle or title like @searchTitle2 or title like @searchTitle3 or subtitle like @searchTitle or subtitle like @searchTitle2 or subtitle like @searchTitle3) AND url IS NOT NULL AND (BackOrder NOT LIKE '%HR%' ORBackOrder IS NULL) Order by title GO [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Decrypt an encrypted CFM template
Great thanks.Yes, I know, I was afraid of having everyone rip me a new one for asking, but within this community, I was hoping that everyone would be upright and not use this stuff for wrong doing.I appreciate the help. John -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 9:52 AM To: CF-Talk Subject: RE: Decrypt an encrypted CFM template I'm not sure the community feeling about decrypters here in CF land (I know where the Flash community stands), but I 'm sure I wil lfind out. Use this only for good, not evil. =) http://www.cse.unsw.edu.au/~matthewc/files/cfdecrypt.zip (This is from the guy who wrote all the C source you see around the net.) Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Nick de Voil said: Have you tried the unicode driver? Any particular reason why this might help? It doesn't use the ODBC workaround. People have also reported dramatic speed improvements with large datasets using this driver. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLDAP Bombs Out Intermittently
Hello We have a web service that uses CFLDAP to authenticate users... on average it gets about 3000 hits a day. Problem is that (as far as we can see) that the CFLDAP tag seems to bomb out intermittently rendering the authentication system pretty useless. The script can still be called and ran over http leaving only the cfldap tag as the suspected culprit. We are writing code to trap the error next time and email us the details of it... but til then does anybody have any idea's/similar experiences with CFLDAP? Cheers -- David [ cf5, iis5, ora8i ] -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 14:25 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 - UPDATE Hi Ben Any more news on this problem ?? any workarounds available ? Ian -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 12:54 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 No, but I'll check. --- Ben _ From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 3:55 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Any update on connecting to IBM Univers database from Macromedia, has this been confirmed as a bug ?or have they come up with any solution why it does not work with MX but does with 4.5 ? If it is a bug it would be good if it could be resolved! -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 18:56 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Nothing is final. But you hit the nail on the head, every piece of software in existence (including the CF apps that us CF developers write) could be updated and patched and improved. Some updates are vital, some are insignificant, and the vast majority sit somewhere between those two extremes. And so judgment calls have to be made, recognizing that while updates are important, they have a tremendous cost and impact on core product delivery. And too many incremental updates are disruptive (look at Microsoft, and how often that annoying automatic update utility kicks in). It's about balance. As I already said, critical issues (for example, security holes, or anything that could crash a server) take top priority, beyond that it's a judgment call. We have releases a few hot fixes, they may be more, we'll work it out as is needed. For now, keep us informed of any and all issues, we'll try to maintain the right balance. --- Ben _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 1:45 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 No planned maintenance release anytime soon? Sigh, that is too bad, I was hoping some of the minor issues would be addressed in CFMX 6.1 soon.But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Has black stone entered Beta testing yet?I should maybe get in that program and see if I can get some of these issues addressed, if they have not been yet. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:57 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Right now we are aggressively working on Blackstone. That is not to say that there'll not be a release between now and then, but I am unaware of any planned maintenance release at this point. If one becomes critical and necessary, then I am sure that one will be released (if hot fixes are not an option). --- Ben _ From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 12:50 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Correct me if I'm wrong but aren't there still bugs and known issues with 6.1. Are you suggesting that there are no immediate plans to address these? Thanks Kola -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 16:29 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 CFMX 6.2? I don't believe that version numbers and editions have been discussed at all, actually. Generally, maintenance releases have been free upgrades (as 6.1 was) whereas full product releases have been paid upgrades (and included in subscriptions, of course). The next planned version of ColdFusion is codenamed Blackstone, and version numbers, pricing, etc., have yet to be discussed at all. But, and this is my own opinion here, I doubt that there will be another maintenance release for CFMX
Re: Improving stored procedure
BackOrder NOT LIKE '%HR%'could be causing you problems even if that field is indexed, because you're not looking at the beginning of the field. Is there anothere way of doing it? For the title fields also, have you considered full text indexing? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Jochem It doesn't use the ODBC workaround. People have also reported dramatic speed improvements with large datasets using this driver. OK, very interesting, thanks. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
-Original Message- From: Nick de Voil Sent: Friday, February 27, 2004 9:56 AM To: CF-Talk Subject: Re: Improving stored procedure BackOrder NOT LIKE '%HR%'could be causing you problems even if that field is indexed, because you're not looking at the beginning of the field. Is there anothere way of doing it? Just curious, cause I don't know Sql Server... In oracle, those null checks on URL and BackOrder would also cause problems because they would negate any indexes on those fields.Is that the case in Sql Server? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Improving stored procedure
At 06:55 AM 2/27/2004, you wrote: BackOrder NOT LIKE '%HR%'could be causing you problems even if that field is indexed, because you're not looking at the beginning of the field. Is there anothere way of doing it? I can remove it for the time being.Later create a bit column for HR. For the title fields also, have you considered full text indexing? Considering it now... Nick -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Improving stored procedure
Just curious, cause I don't know Sql Server... In oracle, those null checks on URL and BackOrder would also cause problems because they would negate any indexes on those fields.Is that the case in Sql Server? I don't think they would make the index unusable, but obviously IS NULL and IS NOT NULL aren't going to narrow things down much. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
More Unicode Fun
Okay, theoretically, if I have a page that has this: cfset setEncoding(url,UTF-8) cfset setEncoding(form,UTF-8) cfcontent type=text/html; charset=UTF-8 cfprocessingdirective pageEncoding=UTF-8 cfoutputBullet: #chr(2022)#/cfoutput Should I see a bullet? Or a square? The live docs say that the chr() function should work with unicode in MX, but I see a square. (This is still part of yesterday's problem, in which I figured out that if I do all the above, forcing it to ISO, that I can successfully replace the problem characters with html entities. But, not if I force it to UTF-8.) -- Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
From: Jacob Is there a way to improve this stored procedure? It is basically a search for titles.We have a title and subtitle column in the database.This stored procedure takes over 60 seconds to run, while other queries to the database take less than a second.I noticed in the database design, that title and subtitle are designed at nvarchar (255). Use Free Text rather than Like - it's TONS faster [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Scope for non-scoped variables
If you don't assign a scope for a variable (cfset foo = 'bar'), is that put into some kind of default scope in a standard cfm page?Is there any way to dump all unscoped variables?Or, if you're in a cfoutput query=blah and you want to reference an unscoped variable that has the same name as one of the columns being output from that query, is there some way to differentiate it?Thanks in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Jochem van Dieten wrote: Have you tried the unicode driver? No I haven't actually, going to try this now. I am willing to try anything at this point! Thanks! Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
Free Text?Not quite sure what you mean. :D At 07:20 AM 2/27/2004, you wrote: From: Jacob Is there a way to improve this stored procedure? It is basically a search for titles.We have a title and subtitle column in the database.This stored procedure takes over 60 seconds to run, while other queries to the database take less than a second.I noticed in the database design, that title and subtitle are designed at nvarchar (255). Use Free Text rather than Like - it's TONS faster -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Scope for non-scoped variables
Yep, It would be in the 'variables' scope, to view cfdump var=#variables# jb -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 15:21 To: CF-Talk Subject: Scope for non-scoped variables If you don't assign a scope for a variable (cfset foo = 'bar'), is that put into some kind of default scope in a standard cfm page?Is there any way to dump all unscoped variables?Or, if you're in a cfoutput query=blah and you want to reference an unscoped variable that has the same name as one of the columns being output from that query, is there some way to differentiate it?Thanks in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Scope for non-scoped variables
It is placed in the Variables scope. In CFMX, you can cfdump variables. If you are in a query and want to refer to the variables scope, you would just use variables.foo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Scope for non-scoped variables
That's the variables scope, which is dumpable in cfmx. cfdump var=#variables# Jamie On Fri, 27 Feb 2004 10:21:18 -0500, in cf-talk you wrote: If you don't assign a scope for a variable (cfset foo = 'bar'), is that put into some kind of default scope in a standard cfm page?Is there any way to dump all unscoped variables?Or, if you're in a cfoutput query=blah and you want to reference an unscoped variable that has the same name as one of the columns being output from that query, is there some way to differentiate it?Thanks in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question regarding CFMX 6.2 - UPDATE
Ian, Have you tried the instructions in this technote?: ColdFusion MX: Creating a JDBC data source for DB2 http://www.macromedia.com/support/coldfusion/ts/documents/tn18337.htm Specifically, the requirement for the connect string parameters is unusual, whereas other JDBC datasource types don't need one. Also, - If you submit the datasource in the CFAdmin after completing the parameters, what is the error message that is displayed (in red font, I think)? - Are you using a packageName that exists already? - Are you creating a new package? - Does that user in the DSN have privileges to create or modify packages on the db? - Are you continuing to use createdefaultpackage=true after the initial configuration? Thanks Steven Erat _ From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 9:25 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 - UPDATE Hi Ben Any more news on this problem ?? any workarounds available ? Ian -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 12:54 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 No, but I'll check. --- Ben _ From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 3:55 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Any update on connecting to IBM Univers database from Macromedia, has this been confirmed as a bug ?or have they come up with any solution why it does not work with MX but does with 4.5 ? If it is a bug it would be good if it could be resolved! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
This seems to have done the trick for the time being. It is too early to really tell if it has cured all my woes but my preliminary tests have been successful and the system isn't hanging as before with the exact same tests. The speed has improved significantly as well! Thanks Johcem! Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: More Unicode Fun
Hello Deanna, Friday, February 27, 2004, 4:16:51 PM, you wrote: cfoutputBullet: #chr(2022)#/cfoutput Should I see a bullet? Or a square? The live docs say that the chr() function should work with unicode in MX, but I see a square. I can get the bullet if I use#chr(2197)#. Don't ask me why. -- Giampaolo Bellavite, Milano (Italy) [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
From: Jacob Free Text?Not quite sure what you mean. :D Sorry, meant Full Text, just typing too fast for my own good Full Text Indexing makes a HUGE difference on large tables [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Scope for non-scoped variables
variables.foo In cfmx: cfdump var=#variables# In cf5 or earlier it is not possible to dump them. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: vrijdag 27 februari 2004 16:21 To: CF-Talk Subject: Scope for non-scoped variables If you don't assign a scope for a variable (cfset foo = 'bar'), is that put into some kind of default scope in a standard cfm page?Is there any way to dump all unscoped variables?Or, if you're in a cfoutput query=blah and you want to reference an unscoped variable that has the same name as one of the columns being output from that query, is there some way to differentiate it?Thanks in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: More Unicode Fun
On Friday 27 Feb 2004 15:52 pm, Giampaolo Bellavite wrote: Should I see a bullet? Or a square? The live docs say that the chr() function should work with unicode in MX, but I see a square. I can get the bullet if I use#chr(2197)#. Don't ask me why. Because only one of you has a font with that glyh defined. -- 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: More Unicode Fun
- Original Message - From: Giampaolo Bellavite Friday, February 27, 2004, 4:16:51 PM, you wrote: I can get the bullet if I use#chr(2197)#. Don't ask me why. Nope, still a square. *sigh* -Deanna, resigning herself to forcing ISO and converting to html entities. *double sigh* [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
Okay.Even searched google for free text I am already playing with full text search.Going to give it a shot. Thanks Philip and Nick for you help. Jacob At 08:00 AM 2/27/2004, you wrote: From: Jacob Free Text?Not quite sure what you mean. :D Sorry, meant Full Text, just typing too fast for my own good Full Text Indexing makes a HUGE difference on large tables -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Scope for non-scoped variables
In cfmx: cfdump var=#variables# In cf5 or earlier it is not possible to dump them. Don't forget that if you need to grab a set of variables, you can simply make sure you use a structure to hold them. This is probably a good idea for CFMX as well since variables may contain things you don't want (as it contains _everything_). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: More Unicode Fun
Are you sure you have the fonts installed in Windows (or whatever :-)) to display the character? Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: More Unicode Fun
Hello Deanna,
Friday, February 27, 2004, 5:10:43 PM, you wrote:
- Original Message -
From: Giampaolo Bellavite
Friday, February 27, 2004, 4:16:51 PM, you wrote:
I can get the bullet if I use#chr(2197)#. Don't ask me why.
Nope, still a square. *sigh*
Ok, i solved my oddities about the bullet:
this code works ok for me in WindowsXP and Firefox:
!--- start ---
cfcontent type=text/html; charset=utf-8
cfprocessingdirective pageencoding=utf-8
h1Bullets/h1
pre
XML Character Reference (DEC) amp;#8226 = #8226;
XML Character Reference (Hex) amp;#x2022; = #x2022;
ColdFusion Chr(8226) = cfoutput#chr(8226)#/cfoutput
ColdFusion Chr(inputBaseN('2022', 16)) = cfoutput#Chr(inputBaseN('2022', 16))#/cfoutput
/pre
!--- end ---
My tips for you are:
- use Dreamweaver MX and in page properties change the encoding to utf-8
- use the cfcontent tag in the Application.cfm
- try to use cfprocessingdirective in every page if your page don't
works.
- ensure you are using a font that supports extended characters. But if it
works with XML character references, it surely has those chars.
--
Giampaolo Bellavite, Milano (Italy)
[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
SOT: Setting up a professional, best practice environment?
Can anybody recommend a good resource or two on the best practice for setting up a professional, multiple developer, development, staging and production environments? Some questions I'm hoping to answer: How to handle common code files such as CFC's, UDF's, Custom Tags.Where to put them? How to access them? How to manage migration of them? Basically, I've been a one man team most of my Cold Fusion Career.Recently I've been working with one other developer, also a long time solo artist, more or less the same as we always have.But our work is growing here and we are quickly moving from a two person to a five person team. We have the opportunity to start nearly from scratch in setting up two boxes for development, staging and production.We would like to be forward thinking as much as possible and avoid any pitfalls that we can. All advice and recommended resources greatly appreciated. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: access to the cf server settings
As a useless aside Ive a very reliable rumor that all of this stuff will finally be surfaced in the next release of CF.Itll probably take the form of some sort of CFADMIN tag or set of tags.I didnt get any specifics (exactly which functions would be provided and so forth) but I did hear it should let you build your own CF Administrator. Not helpful now, I know but it gives hope for the (near) future I think. ;^) Jim Davis _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 4:53 AM To: CF-Talk Subject: Re: access to the cf server settings Eric Chataign said: Is it possible to access to the CFMX server settings in a CF script. I am interested in getting the list of mapped directories. cflock name=serviceFactory type=exclusive timeout=10 cfscript factory = CreateObject(java, coldfusion.server.ServiceFactory); rt_service = factory.runtimeservice; mappings = rt_service.mappings; /cfscript cfdump var=#mappings# /cflock IIRC you need to be logged in as Admin since Updater 3. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
Okay.. one last question.. hopefully... How would i do something like this? SELECT* FROM DVD WHERE title like '%music%' or subtitle like '%music%' I tried... SELECT* FROM DVD WHERE contains (title, 'music') or contains (subtitle, 'music') So I want to search title and subtitle for music.If I search only title or only subtitle by itself, it pulls the information quickly.If I use the two together, it take a lng time. Thanks Jacob At 08:00 AM 2/27/2004, you wrote: From: Jacob Free Text?Not quite sure what you mean. :D Sorry, meant Full Text, just typing too fast for my own good Full Text Indexing makes a HUGE difference on large tables -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
-Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:44 AM To: CF-Talk Subject: RE: Improving stored procedure So I want to search title and subtitle for music.If I search only title or only subtitle by itself, it pulls the information quickly.If I use the two together, it take a lng time. Try a union then?Instead of combining the two text searches in an or, try something like: SELECT * FROM DVD WHERE contains(title, 'music') UNION SELECT * FROM DVD WHERE contains(subtitle, 'music'); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Improving stored procedure
I think I have found the problem.When I select a certain column, it takes a long time.Think that is where I have to start looking. ;-) Thanks.I will try union also. At 08:56 AM 2/27/2004, you wrote: -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:44 AM To: CF-Talk Subject: RE: Improving stored procedure So I want to search title and subtitle for music.If I search only title or only subtitle by itself, it pulls the information quickly.If I use the two together, it take a lng time. Try a union then?Instead of combining the two text searches in an or, try something like: SELECT * FROM DVD WHERE contains(title, 'music') UNION SELECT * FROM DVD WHERE contains(subtitle, 'music'); -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Is the unicode driver just useful for Access or will it stabilize Sql Server 2000 also? Where can it be found? Josen www.gomotorbids.com Donnie Bachan said: We are experiencing this problem also. I have tried the hotfixes on Macromedia's site, which do not really apply to MS Access but it couldn'thurt. We have an application that requires a large recordset to be returned(~1 records), CFQUERY caching helps somewhat but the problem existswhenever the cache is cleared. I think that Access just cannot handle the load, the ODBC Server hangsfirst Have you tried the unicode driver? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Josen Ruiseco wrote: Is the unicode driver just useful for Access or will it stabilize Sql Server 2000 also? Where can it be found? Access only, and it is just in the dropdown menu. For MS SQL Server, use the JDBC driver from Microsoft. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access Coldfusion MX6.1 problems...sites keep dying
For MS SQL Server, use the JDBC driver from Microsoft. Jochem, have you run into any issues with that? I've only started testing it. Have you compared it with the latest DataDirect Connect for JDBC version? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Dave Watts wrote: For MS SQL Server, use the JDBC driver from Microsoft. Jochem, have you run into any issues with that? I've only started testing it. Have you compared it with the latest DataDirect Connect for JDBC version? I don't use MS SQL Server so I haven't compared it, but IIRC Paul Hastings recommends it. But the most important thing from this thread appears to be that people need to stop using the JDBC-ODBC bridge (Type 1) and switch to a JDBC Type 3 or Type 4 driver. Even if it is just to shut down 2 more daemons :-) Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
At 12:28 PM 2/27/2004, you wrote: I don't use MS SQL Server so I haven't compared it, but IIRC Paul Hastings recommends it. But the most important thing from this thread appears to be that people need to stop using the JDBC-ODBC bridge (Type 1) and switch to a JDBC Type 3 or Type 4 driver. Even if it is just to shut down 2 more daemons :-) I use another application language that can only access ODBC, unfortunately, and I'm having issues with it reading Unicode data correctly (CFMX reads it just fine, but it's obviously not using ODBC).Are there any options for bridging there? -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question regarding CFMX 6.2 - UPDATE
Ben, Any word on whether or not work is being done on the Could not connect to JRUN server error. This issue seems to affect a lot of folks and there is yet no word from Macromedia on the issue. Regards, Josen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Regarding the Microsoft JDBC driver, have you heard if that lessens or elimiantes the Could not connect to JRUN Server error? Josen Josen Ruiseco wrote: Is the unicode driver just useful for Access or will it stabilize Sql Server 2000 also? Where can it be found? Access only, and it is just in the dropdown menu. For MS SQL Server, use the JDBC driver from Microsoft. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFHTTP return data....
What¹s the best way to access variables returned from an inprocess cfhttp request. When using cfhttp.filecontent I get an html formatted string back instead of usable variables. Thanx in advance. BZaccheo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP return data....
What¹s the best way to access variables returned from an inprocess cfhttp request. When using cfhttp.filecontent I get an html formatted string back instead of usable variables. If you use CFHTTP to fetch an HTML page, you'll have to parse CFHTTP.FileContent to get what you're after. String parsing functions (Replace, ReplaceNoCase, REReplace, REReplaceNoCase) and regular expressions are your best bet for this kind of thing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFHTTP return data....
Thanx Dave.. I¹ll give that a try. I was hoping I didn¹t have to... Oh well... :) BZaccheo On 2/27/04 10:10 AM, Dave Watts [EMAIL PROTECTED] wrote: What¹s the best way to access variables returned from an inprocess cfhttp request. When using cfhttp.filecontent I get an html formatted string back instead of usable variables. If you use CFHTTP to fetch an HTML page, you'll have to parse CFHTTP.FileContent to get what you're after. String parsing functions (Replace, ReplaceNoCase, REReplace, REReplaceNoCase) and regular expressions are your best bet for this kind of thing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT - Getting age from MySQL
Hi all our DB have a field with dob from our clients. I'm looking for a script to calculate the age including WHERE clauses. But MySQL give an error: Unknown column Age in where clause. Please look: SELECT Name, dob, year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0)) AS Age FROM cand WHERE 1=1 AND Age 1 How to do that? Thanx in advance -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfmx cf5
I have a query that works fine on MX but shows this error on 5: Invalid parser construct found on line 117 at position 55. ColdFusion was looking at the following text: - Here is my query: cfquery name=checkserialnumber datasource=test select count(*) as MyCount from claimdetails where serialnum = '#prefix##suffix - 5#' AND serialnum = '#prefix##suffix + 5#' /cfquery How do I format for 5 and MX? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Getting age from MySQL
Just put the _expression_ in the WHERE clause as well: SELECT Name, dob, year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0)) AS Age FROM cand WHERE 1=1 AND year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0)) 1 -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 10:35 AM To: CF-Talk Subject: OT - Getting age from MySQL Hi all our DB have a field with dob from our clients. I'm looking for a script to calculate the age including WHERE clauses. But MySQL give an error: Unknown column Age in where clause. Please look: SELECT Name, dob, year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0)) AS Age FROM cand WHERE 1=1 AND Age 1 How to do that? Thanx in advance -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfmx cf5
I'm not sure CF 5 allows this kind of math: #suffix + 5# You may need to set a var before the query like so: cfset MyCalculatedVar = suffix + 5 and in your query use #MyCalculatedVar# HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Friday, February 27, 2004 10:45 AM Subject: cfmx cf5 I have a query that works fine on MX but shows this error on 5: Invalid parser construct found on line 117 at position 55. ColdFusion was looking at the following text: - Here is my query: cfquery name=checkserialnumber datasource=test select count(*) as MyCount from claimdetails where serialnum = '#prefix##suffix - 5#' AND serialnum = '#prefix##suffix + 5#' /cfquery How do I format for 5 and MX? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Getting age from MySQL
Providing the date functions you used in the age calculation work try: SELECT Name, dob FROM cand WHERE (year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0))) 1 Let me know, Greg -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:35 PM To: CF-Talk Subject: OT - Getting age from MySQL Hi all our DB have a field with dob from our clients. I'm looking for a script to calculate the age including WHERE clauses. But MySQL give an error: Unknown column Age in where clause. Please look: SELECT Name, dob, year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0)) AS AgeFROM cand WHERE 1=1 AND Age 1 How to do that? Thanx in advance -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfmx cf5
You can't use expressions inside hashes on CF5 and less.That's a CFMX-only thing.You can wrap your expressions in a function (int() or evaluate()), or assign them to temp variables and use them in your query.For example: cfquery name=checkserialnumber datasource=test select count(*) as MyCount from claimdetails where serialnum = '#prefix##int(suffix - 5)#' AND serialnum = '#prefix##int(suffix + 5)#' /cfquery -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 10:46 AM To: CF-Talk Subject: cfmx cf5 I have a query that works fine on MX but shows this error on 5: Invalid parser construct found on line 117 at position 55. ColdFusion was looking at the following text: - Here is my query: cfquery name=checkserialnumber datasource=test select count(*) as MyCount from claimdetails where serialnum = '#prefix##suffix - 5#' AND serialnum = '#prefix##suffix + 5#' /cfquery How do I format for 5 and MX? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfmx cf5
#suffix-5# and #suffix+5# didn't work on CF5 you'd need to do a cfset thisSuffix = suffix - 5or #evaluate(suffix -5)# - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:45 AM Subject: cfmx cf5 I have a query that works fine on MX but shows this error on 5: Invalid parser construct found on line 117 at position 55. ColdFusion was looking at the following text: - Here is my query: cfquery name=checkserialnumber datasource=test select count(*) as MyCount from claimdetails where serialnum = '#prefix##suffix - 5#' AND serialnum = '#prefix##suffix + 5#' /cfquery How do I format for 5 and MX? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFAPPLICATION question
I have a site in the webroot.In that site, I have an Application.cfm with a CFAPPLICATION name=appname tag.On the same server, can I have a separate webroot with a separate Application.cfm with another CFAPPLICATION name=appname tag with the same appname?Will it see these as the same application, thus allowing me to set some application variables, switch a user to the other domain and still have those application variables available?I'm not 100% sure how that works. Thanks for your input. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFAPPLICATION question
While they will both be the same Application to CF, you won't (I believe) be able to share session variables, since there will be a different cookie for each domain, unless you have domains like a.foo.com and b.foo.com (and use setDomainCookies). But you asked specifically about Application variables, and yes, they will be shared. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFAPPLICATION question
Yes, they'll share application variables.Switching users between domains is a bit dicier, because client management is bound to domains (because cookies are).But if you're not using client or session management, or you're doing it with URL variables, then you should be fine. Cheers, barneyb -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 10:56 AM To: CF-Talk Subject: CFAPPLICATION question I have a site in the webroot.In that site, I have an Application.cfm with a CFAPPLICATION name=appname tag.On the same server, can I have a separate webroot with a separate Application.cfm with another CFAPPLICATION name=appname tag with the same appname?Will it see these as the same application, thus allowing me to set some application variables, switch a user to the other domain and still have those application variables available?I'm not 100% sure how that works. Thanks for your input. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFAPPLICATION question
I have a site in the webroot.In that site, I have an Application.cfm with a CFAPPLICATION name=appname tag. On the same server, can I have a separate webroot with a separate Application.cfm with another CFAPPLICATION name=appname tag with the same appname? Yes. Will it see these as the same application, thus allowing me to set some application variables, switch a user to the other domain and still have those application variables available? Yes, although you may have problems with session variables, if you're using separate domains for each application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfmx cf5
I'm not sure CF 5 allows this kind of math: #suffix + 5# It doesn't. I believe that very early versions of CF (1, 2) did allow this, and CFMX does. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Getting age from MySQL
Thanks Greg works fine now - Original Message - From: Greg Luce [EMAIL PROTECTED] Date: Fri, 27 Feb 2004 13:50:39 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: RE: OT - Getting age from MySQL Providing the date functions you used in the age calculation work try: SELECT Name, dob FROM cand WHERE (year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0))) 1 Let me know, Greg -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:35 PM To: CF-Talk Subject: OT - Getting age from MySQL Hi all our DB have a field with dob from our clients. I'm looking for a script to calculate the age including WHERE clauses. But MySQL give an error: Unknown column Age in where clause. Please look: SELECT Name, dob, year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0)) AS AgeFROM cand WHERE 1=1 AND Age 1 How to do that? Thanx in advance -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Getting age from MySQL
From: Spectrum WebDesign our DB have a field with dob from our clients. I'm looking for a script to calculate the age including WHERE clauses. But MySQL give an error: Unknown column Age in where clause. Please look: SELECT Name, dob, year(current_date) - year(dob) - (if(dayofyear(dob)dayofyear(current_date),1,0)) AS AgeFROM cand WHERE 1=1 AND Age 1 Aliased columns aren't usable until the query is returned So you have to use the same calculation in the WHERE [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Now() and GetDate()
Is there a common function for getting the current date/time for MS SQL and MySQL?Anything I can use across both databases would be great, but MS doesn't like now() and MySQL doesn't like getDate().Am I missing something? John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Detecting Images with Digital Rights
Does anyone know of a product or service that checks an image to see if it is protected by Digital Rights? We have developed a very robust CMS product but want to limit our liability if one of our users uploads an image to the system that is an Rights Managed image. Regards, John Blayter Director of Engineering Interactive Sites, Inc. 480-707-1600 x237 (office) 480-707-1601 (fax) http://www.interactivesites.com http://www.planitonline.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFAPPLICATION question
If the two domains are just different hosts on the same domain (abc.company.com and xyz.company.com) then you can arrange for the cf cookies to be shared, and so session would also be shared. It's the setdomaincookies option on cfapplication.(If you use it then you have to be careful to make sure the hosts more than one dot in the name... the host company.com will get no cf cookies at all if you have setdomaincookies=true) Mark -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:56 PM To: CF-Talk Subject: CFAPPLICATION question I have a site in the webroot.In that site, I have an Application.cfm with a CFAPPLICATION name=appname tag.On the same server, can I have a separate webroot with a separate Application.cfm with another CFAPPLICATION name=appname tag with the same appname?Will it see these as the same application, thus allowing me to set some application variables, switch a user to the other domain and still have those application variables available?I'm not 100% sure how that works. Thanks for your input. John Burns _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Now() and GetDate()
Sorry. There is not a common date function between databases. Turns out date functions are propritary in nature -- and varry greatly between databases. Take a look Ben Forta's article, The Case Against Coding for Portability - DATABASES ARE DIFFERENT, on using database functions for applications at http://www.sys-con.com/coldfusion/article.cfm?id=705 P.S. You can add sysdate() for those using Oracle. now() however works in MS Access. Jeremy Brodie Edgewater Technology web: http://www.edgewater.com phone:(703) 815-2500 email: [EMAIL PROTECTED] Is there a common function for getting the current date/time for MS SQL and MySQL?Anything I can use across both databases would be great, but MS doesn't like now() and MySQL doesn't like getDate().Am I missing something? John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFAPPLICATION question
Does anyone have a good breakdown of when is the best time to use different variable scopes.I know a lot of it is preference, but I'm curious if there's a best practices type idea floating around anywhere. John -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 2:25 PM To: CF-Talk Subject: RE: CFAPPLICATION question If the two domains are just different hosts on the same domain (abc.company.com and xyz.company.com) then you can arrange for the cf cookies to be shared, and so session would also be shared. It's the setdomaincookies option on cfapplication.(If you use it then you have to be careful to make sure the hosts more than one dot in the name... the host company.com will get no cf cookies at all if you have setdomaincookies=true) Mark -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:56 PM To: CF-Talk Subject: CFAPPLICATION question I have a site in the webroot.In that site, I have an Application.cfm with a CFAPPLICATION name=appname tag.On the same server, can I have a separate webroot with a separate Application.cfm with another CFAPPLICATION name=appname tag with the same appname?Will it see these as the same application, thus allowing me to set some application variables, switch a user to the other domain and still have those application variables available?I'm not 100% sure how that works. Thanks for your input. John Burns _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP return data....
Butch, What is the purpose of the HTTP request?Do you want html content from the remote server or are you looking to transfer structured data between servers?If you are transfering data, then have you considered WDDX for a data format?I don't even know if the other server can construct WDDX, so I could be way off.Any how, just a thought. Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 10:01 AM To: CF-Talk Subject: CFHTTP return data What¹s the best way to access variables returned from an inprocess cfhttp request. When using cfhttp.filecontent I get an html formatted string back instead of usable variables. Thanx in advance. BZaccheo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfmx cf5
Tell me if there is an easier way to do this. I have a list of serial numbers (ex. 23T2, 23T3, 23T452365789). I need to check and see if an of the numbers are within 5 digits of each other. So, I was taking the prefix and suffix: cfset Prefix = Left(ListGetAt(form.serialnumber), 3) cfset Suffix = RightListGetAt(form.serialnumber), 9) and comparing them to records in the db. Is there a way to do this without a query? Can I compare using an if statement? If there are serial numbers within 5 digits, I need to flag the record. You can't use expressions inside hashes on CF5 and less.That's a CFMX-only thing.You can wrap your expressions in a function (int() or evaluate()), or assign them to temp variables and use them in your query.For example: cfquery name=checkserialnumber datasource=test select count(*) as MyCount from claimdetails where serialnum = '#prefix##int(suffix - 5)#' AND serialnum = '#prefix##int(suffix + 5)#' /cfquery -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 10:46 AM To: CF-Talk Subject: cfmx cf5 I have a query that works fine on MX but shows this error on 5: Invalid parser construct found on line 117 at position 55. ColdFusion was looking at the following text: - Here is my query: cfquery name=checkserialnumber datasource=test select count(*) as MyCount from claimdetails where serialnum = '#prefix##suffix - 5#' AND serialnum = '#prefix##suffix + 5#' /cfquery How do I format for 5 and MX? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Detecting Images with Digital Rights
John, While there is nothing that is 100% foolproof, our colleuges(used very lightly) in the Adult Website industry and news industry can provide us with the following strategies. 1) Place the copyright information and the website within the graphic/Flash/Video. Make the information visable within the picture itself (see cnn.com for a good example of what they do to AP photos). Use Alt tags/ metadate (for video) to emphisize that point. 2) Have a strong terms and conditions section on your site There are quite a few (heated) discussions out there and even a few products out there cliaming to have the silver bullet of allowing 100% image protection. However, with enough skill (key caveat) any file format, including Flash and Video can be pulled. Jeremy Brodie Edgewater Technology web: http://www.edgewater.com phone:(703) 815-2500 email: [EMAIL PROTECTED] Does anyone know of a product or service that checks an image to see if it is protected by Digital Rights? We have developed a very robust CMS product but want to limit our liability if one of our users uploads an image to the system that is an Rights Managed image. Regards, John Blayter Director of Engineering Interactive Sites, Inc. 480-707-1600 x237 (office) 480-707-1601 (fax) http://www.interactivesites.com http://www.planitonline.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Now() and GetDate()
From: Burns, John Is there a common function for getting the current date/time for MS SQL and MySQL?Anything I can use across both databases would be great, but MS doesn't like now() and MySQL doesn't like getDate().Am I missing something? You could always pass the database #Now()# from CF [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Protect action pages
I want to protect action pages from unauthorized forms that are not on the
same server, namely spammers. I wrote this simple script that will work in
conjunction with my other form validation scripts to ensure a referrer comes
from the same CGI.HTTP_HOST.
cftry
cfscript
message = ;
errors = 0;
if ( NOT FindNoCase(CGI.HTTP_HOST,CGI.HTTP_REFERER) ) {
message = You cannot access this page;
errors = 1;
}
/cfscript
cfif errors EQ 1
cfthrow message=#message# type=goBack
/cfif
cfcatch type=Any
cfoutput
h3#message#/h3
/cfoutput
/cfcatch
/cftry
Does anyone see any holes that I should address, or is there a better
solution?
Thank you,
Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CFMAIL too slow on Coldfusion MX Standard 6.1 version
Hi All, I want to improve the CFMAIL performance for our CF SERVER. Here is the server info: CF: Coldfusion MXStandard 6.1 version OS: Windows 2000IIS5.0 2.8 GHZ Pentium 4 with 1GB RAM and about 8 sites hosted on that server which are low traffic sites. It took me about 5 hours to email 1000 emails. which is too low number for emails to go out. Can anybody help me with suggestions what should I do in setting to increase the performance of CFMAIL. Ketan Patel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMAIL too slow on Coldfusion MX Standard 6.1 version
Wow...you're sure it's CFMX? On Enterprise that would take about 30 seconds. Possible it's your SMTP that's sluggish? Stace _ From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 3:18 PM To: CF-Talk Subject: CFMAIL too slow on Coldfusion MX Standard 6.1 version Hi All, I want to improve the CFMAIL performance for our CF SERVER. Here is the server info: CF: Coldfusion MXStandard 6.1 version OS: Windows 2000IIS5.0 2.8 GHZ Pentium 4 with 1GB RAM and about 8 sites hosted on that server which are low traffic sites. It took me about 5 hours to email 1000 emails. which is too low number for emails to go out. Can anybody help me with suggestions what should I do in setting to increase the performance of CFMAIL. Ketan Patel _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Protect action pages
Be aware that in IE when using a _javascript_ to forward or request a page, like window.location, you lose the cgi.http_referer on the targeted page.
Nick Han
[EMAIL PROTECTED] 02/27/04 12:09PM
I want to protect action pages from unauthorized forms that are not on the
same server, namely spammers. I wrote this simple script that will work in
conjunction with my other form validation scripts to ensure a referrer comes
from the same CGI.HTTP_HOST.
cftry
cfscript
message = ;
errors = 0;
if ( NOT FindNoCase(CGI.HTTP_HOST,CGI.HTTP_REFERER) ) {
message = You cannot access this page;
errors = 1;
}
/cfscript
cfif errors EQ 1
cfthrow message=#message# type=goBack
/cfif
cfcatch type=Any
cfoutput
h3#message#/h3
/cfoutput
/cfcatch
/cftry
Does anyone see any holes that I should address, or is there a better
solution?
Thank you,
Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Protect action pages
Stan:
The HTTP Referer header can be spoofed quite easily.And if it's spammers
you're worried about, they would definitely have the capabilities to spoof
the header.
Try to find a mechanism that doesn't rely on user provided data or, that
requires multiple steps.For example, if you're concerned about people
auto-submitting to your action page without coming through your form page,
build in a check that verifies they visited the form page such as those
systems that ask you to type in the string shown in the associated image.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Stan Winchester [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 3:09 PM
To: CF-Talk
Subject: Protect action pages
I want to protect action pages from unauthorized forms that are not on the
same server, namely spammers. I wrote this simple script that will work in
conjunction with my other form validation scripts to ensure a referrer comes
from the same CGI.HTTP_HOST.
cftry
cfscript
message = ;
errors = 0;
if ( NOT FindNoCase(CGI.HTTP_HOST,CGI.HTTP_REFERER) ) {
message = You cannot access this page;
errors = 1;
}
/cfscript
cfif errors EQ 1
cfthrow message=#message# type=goBack
/cfif
cfcatch type=Any
cfoutput
h3#message#/h3
/cfoutput
/cfcatch
/cftry
Does anyone see any holes that I should address, or is there a better
solution?
Thank you,
Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFMAIL too slow on Coldfusion MX Standard 6.1 version
I know its slow. My SMTP ma is connecting to a external mail server may be that may be the issue. Do I need to do any settings change to Connection Timeout I have 60 sec and verify mail server connection is Unchecked. Thanks, Ketan -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 3:16 PM To: CF-Talk Subject: RE: CFMAIL too slow on Coldfusion MX Standard 6.1 version Wow...you're sure it's CFMX? On Enterprise that would take about 30 seconds. Possible it's your SMTP that's sluggish? Stace _ From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 3:18 PM To: CF-Talk Subject: CFMAIL too slow on Coldfusion MX Standard 6.1 version Hi All, I want to improve the CFMAIL performance for our CF SERVER. Here is the server info: CF: Coldfusion MXStandard 6.1 version OS: Windows 2000IIS5.0 2.8 GHZ Pentium 4 with 1GB RAM and about 8 sites hosted on that server which are low traffic sites. It took me about 5 hours to email 1000 emails. which is too low number for emails to go out. Can anybody help me with suggestions what should I do in setting to increase the performance of CFMAIL. Ketan Patel _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Protect action pages
I want to protect action pages from unauthorized forms that are not on the same server, namely spammers. I wrote this simple script that will work in conjunction with my other form validation scripts to ensure a referrer comes from the same CGI.HTTP_HOST. This can't stop anything. Both HTTP_HOST and HTTP_REFERER are set by the browser, and can be changed by anyone writing an HTTP client: cfhttp ... cfhttpparam type=header name=Host value=... cfhttpparam type=header name=Referer value=... /cfhttp You can take steps to make it more difficult to submit data to your action pages, but it's hard to make it impossible. For example, you could generate a random number when someone requests the form, and require that number when data is submitted to the action page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Protect action pages
I wrap my action pages in a CFSWITCH.
fAll of the values in my cases are names of certain actions, such as update or delete or Send order.
On every form sent is a hidden field named action.So, if there is no form.action variable present, then it gives them a custom error or forwards them soemwhere else.u think this will help?
- Original Message -
From: Stan Winchester
To: CF-Talk
Sent: Friday, February 27, 2004 2:09 PM
Subject: Protect action pages
I want to protect action pages from unauthorized forms that are not on the
same server, namely spammers. I wrote this simple script that will work in
conjunction with my other form validation scripts to ensure a referrer comes
from the same CGI.HTTP_HOST.
cftry
cfscript
message = ;
errors = 0;
if ( NOT FindNoCase(CGI.HTTP_HOST,CGI.HTTP_REFERER) ) {
message = You cannot access this page;
errors = 1;
}
/cfscript
cfif errors EQ 1
cfthrow message=#message# type=goBack
/cfif
cfcatch type=Any
cfoutput
h3#message#/h3
/cfoutput
/cfcatch
/cftry
Does anyone see any holes that I should address, or is there a better
solution?
Thank you,
Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Protect action pages
nope.
-Original Message-
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: February 27, 2004 1:47 PM
To: CF-Talk
Subject: Re: Protect action pages
I wrap my action pages in a CFSWITCH.
fAll of the values in my cases are names of certain actions, such as
update or delete or Send order.
On every form sent is a hidden field named action.So, if there is no
form.action variable present, then it gives them a custom error or forwards
them soemwhere else.u think this will help?
- Original Message -
From: Stan Winchester
To: CF-Talk
Sent: Friday, February 27, 2004 2:09 PM
Subject: Protect action pages
I want to protect action pages from unauthorized forms that are not on the
same server, namely spammers. I wrote this simple script that will work in
conjunction with my other form validation scripts to ensure a referrer
comes
from the same CGI.HTTP_HOST.
cftry
cfscript
message = ;
errors = 0;
if ( NOT FindNoCase(CGI.HTTP_HOST,CGI.HTTP_REFERER) ) {
message = You cannot access this page;
errors = 1;
}
/cfscript
cfif errors EQ 1
cfthrow message=#message# type=goBack
/cfif
cfcatch type=Any
cfoutput
h3#message#/h3
/cfoutput
/cfcatch
/cftry
Does anyone see any holes that I should address, or is there a better
solution?
Thank you,
Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Detecting Images with Digital Rights
I not worried about people coping images that belong to our clients. I am more concenred about our clients uploading protected images to our system and we are then dragged into a lawsuit because of our clients actions. I am looking for some sort of service that reads for known digital watermarks that are not visable when you view the image. Thanks John John, While there is nothing that is 100% foolproof, our colleuges(used very lightly) in the Adult Website industry and news industry can provide us with the following strategies. 1) Place the copyright information and the website within the graphic/Flash/Video. Make the information visable within the picture itself (see cnn.com for a good example of what they do to AP photos). Use Alt tags/ metadate (for video) to emphisize that point. 2) Have a strong terms and conditions section on your site There are quite a few (heated) discussions out there and even a few products out there cliaming to have the silver bullet of allowing 100% image protection. However, with enough skill (key caveat) any file format, including Flash and Video can be pulled. Jeremy Brodie Edgewater Technology web: http://www.edgewater.com phone:(703) 815-2500 email: [EMAIL PROTECTED] Does anyone know of a product or service that checks an image to see if it is protected by Digital Rights? We have developed a very robust CMS product but want to limit our liability if one of our users uploads an image to the system that is an Rights Managed image. Regards, John Blayter Director of Engineering Interactive Sites, Inc. 480-707-1600 x237 (office) 480-707-1601 (fax) http://www.interactivesites.com http://www.planitonline. com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Protect action pages
I wrap my action pages in a CFSWITCH. fAll of the values in my cases are names of certain actions, such as update or delete or Send order. On every form sent is a hidden field named action.So, if there is no form.action variable present, then it gives them a custom error or forwards them soemwhere else.u think this will help? No, since anyone interested enough in posting directly to your site will take the trouble to select view source when browsing your form. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Protect action pages
if I save your page to my hardrive and edit the 'hidden' action field, could I possibly guess how to delete a record or table?
Douglas Knudsen (Telecommuting)
ACI RRT Group
Let your hook be always cast. In the pool where you least expect it, will be fish.
-Ovid
-Original Message-
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: Fri 2/27/2004 3:47 PM
To: CF-Talk
Cc:
Subject: Re: Protect action pages
I wrap my action pages in a CFSWITCH.
fAll of the values in my cases are names of certain actions, such as update or delete or Send order.
On every form sent is a hidden field named action.So, if there is no form.action variable present, then it gives them a custom error or forwards them soemwhere else.u think this will help?
- Original Message -
From: Stan Winchester
To: CF-Talk
Sent: Friday, February 27, 2004 2:09 PM
Subject: Protect action pages
I want to protect action pages from unauthorized forms that are not on the
same server, namely spammers. I wrote this simple script that will work in
conjunction with my other form validation scripts to ensure a referrer comes
from the same CGI.HTTP_HOST.
cftry
cfscript
message = ;
errors = 0;
if ( NOT FindNoCase(CGI.HTTP_HOST,CGI.HTTP_REFERER) ) {
message = You cannot access this page;
errors = 1;
}
/cfscript
cfif errors EQ 1
cfthrow message=#message# type=goBack
/cfif
cfcatch type=Any
cfoutput
h3#message#/h3
/cfoutput
/cfcatch
/cftry
Does anyone see any holes that I should address, or is there a better
solution?
Thank you,
Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
