access to the cf server settings

2004-02-27 Thread Eric Chataigné
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

2004-02-27 Thread Jochem van Dieten
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 =

DateFormat misery

2004-02-27 Thread cf coder
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

RE: DateFormat misery

2004-02-27 Thread Pascal Peters
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

Re: DateFormat misery

2004-02-27 Thread Thomas Chiverton
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

Re: DateFormat misery

2004-02-27 Thread cf coder
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;

RE: How to know when you have the last record?

2004-02-27 Thread Tim Blair
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

Re: DateFormat misery

2004-02-27 Thread cf coder
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

RE: DateFormat misery

2004-02-27 Thread Pascal Peters
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Nick de Voil
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

error 32

2004-02-27 Thread Rick Lansford
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

RE: access to the cf server settings

2004-02-27 Thread John Beynon
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

RE: Question regarding CFMX 6.2 - UPDATE

2004-02-27 Thread Ian Vaughan
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

Decrypt an encrypted CFM template

2004-02-27 Thread Burns, John
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Donnie Bachan
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

RE: Decrypt an encrypted CFM template

2004-02-27 Thread John Beynon
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

RE: Decrypt an encrypted CFM template

2004-02-27 Thread Tom Kitta
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

CFMX admin on server

2004-02-27 Thread Terri Hodgson
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
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

RE: CFMX admin on server

2004-02-27 Thread John Beynon
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Nick de Voil
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

2004-02-27 Thread Jerry Johnson
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

Improving stored procedure

2004-02-27 Thread 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

RE: Decrypt an encrypted CFM template

2004-02-27 Thread Burns, John
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
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

CFLDAP Bombs Out Intermittently

2004-02-27 Thread d.a.collie
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

Re: Improving stored procedure

2004-02-27 Thread Nick de Voil
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]

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Nick de Voil
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

2004-02-27 Thread Plunkett, Matt
-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

Re: Improving stored procedure

2004-02-27 Thread Jacob
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

Re: Improving stored procedure

2004-02-27 Thread Nick de Voil
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

More Unicode Fun

2004-02-27 Thread Deanna Schneider
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

RE: Improving stored procedure

2004-02-27 Thread Philip Arnold
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

Scope for non-scoped variables

2004-02-27 Thread Burns, John
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Donnie Bachan
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]

RE: Improving stored procedure

2004-02-27 Thread Jacob
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

RE: Scope for non-scoped variables

2004-02-27 Thread John Beynon
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'),

RE: Scope for non-scoped variables

2004-02-27 Thread Raymond Camden
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

2004-02-27 Thread Jamie Jackson
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

RE: Question regarding CFMX 6.2 - UPDATE

2004-02-27 Thread Steven Erat
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Donnie Bachan
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

Re: More Unicode Fun

2004-02-27 Thread Giampaolo Bellavite
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.

RE: Improving stored procedure

2004-02-27 Thread Philip Arnold
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

2004-02-27 Thread Pascal Peters
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

Re: More Unicode Fun

2004-02-27 Thread Thomas Chiverton
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

Re: More Unicode Fun

2004-02-27 Thread Deanna Schneider
- 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*

RE: Improving stored procedure

2004-02-27 Thread Jacob
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

RE: Scope for non-scoped variables

2004-02-27 Thread Raymond Camden
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

RE: More Unicode Fun

2004-02-27 Thread Matt Robertson
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

Re: More Unicode Fun

2004-02-27 Thread Giampaolo Bellavite
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

SOT: Setting up a professional, best practice environment?

2004-02-27 Thread Ian Skinner
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

RE: access to the cf server settings

2004-02-27 Thread Jim Davis
As a useless aside I’ve a very reliable rumor that all of this stuff will finally be surfaced in the next release of CF.It’ll probably take the form of some sort of CFADMIN tag or set of tags.I didn’t get any specifics (exactly which functions would be provided and so forth) but I did hear it

RE: Improving stored procedure

2004-02-27 Thread Jacob
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

RE: Improving stored procedure

2004-02-27 Thread Plunkett, Matt
-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

RE: Improving stored procedure

2004-02-27 Thread Jacob
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Josen Ruiseco
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
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

RE: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Dave Watts
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:

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Jochem van Dieten
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Phillip Beazley
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

Re: Question regarding CFMX 6.2 - UPDATE

2004-02-27 Thread Josen Ruiseco
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

Re: Access Coldfusion MX6.1 problems...sites keep dying

2004-02-27 Thread Josen Ruiseco
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

CFHTTP return data....

2004-02-27 Thread Butch Zaccheo
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....

2004-02-27 Thread Dave Watts
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

Re: CFHTTP return data....

2004-02-27 Thread Butch Zaccheo
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

OT - Getting age from MySQL

2004-02-27 Thread Spectrum WebDesign
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) -

cfmx cf5

2004-02-27 Thread kelly
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

RE: OT - Getting age from MySQL

2004-02-27 Thread Barney Boisvert
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

Re: cfmx cf5

2004-02-27 Thread Bryan Stevenson
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.

RE: OT - Getting age from MySQL

2004-02-27 Thread Greg Luce
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:

RE: cfmx cf5

2004-02-27 Thread Barney Boisvert
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

Re: cfmx cf5

2004-02-27 Thread Charlie Griefer
#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

CFAPPLICATION question

2004-02-27 Thread Burns, John
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,

RE: CFAPPLICATION question

2004-02-27 Thread Raymond Camden
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

RE: CFAPPLICATION question

2004-02-27 Thread Barney Boisvert
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

RE: CFAPPLICATION question

2004-02-27 Thread Dave Watts
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

RE: cfmx cf5

2004-02-27 Thread Dave Watts
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]

RE: OT - Getting age from MySQL

2004-02-27 Thread Spectrum WebDesign
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

RE: OT - Getting age from MySQL

2004-02-27 Thread Philip Arnold
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) -

Now() and GetDate()

2004-02-27 Thread 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? John [Todays Threads] [This Message] [Subscription] [Fast

Detecting Images with Digital Rights

2004-02-27 Thread John Blayter
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

RE: CFAPPLICATION question

2004-02-27 Thread Gaulin, Mark
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

Re: Now() and GetDate()

2004-02-27 Thread Jeremy Brodie
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

RE: CFAPPLICATION question

2004-02-27 Thread Burns, John
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:

RE: CFHTTP return data....

2004-02-27 Thread Paul Kenney
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

RE: cfmx cf5

2004-02-27 Thread kelly
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)

Re: Detecting Images with Digital Rights

2004-02-27 Thread Jeremy Brodie
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

RE: Now() and GetDate()

2004-02-27 Thread Philip Arnold
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

Protect action pages

2004-02-27 Thread Stan Winchester
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

CFMAIL too slow on Coldfusion MX Standard 6.1 version

2004-02-27 Thread Ketan Patel
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

RE: CFMAIL too slow on Coldfusion MX Standard 6.1 version

2004-02-27 Thread Stacy Young
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

Re: Protect action pages

2004-02-27 Thread Nick Han
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

RE: Protect action pages

2004-02-27 Thread Mosh Teitelbaum
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

RE: CFMAIL too slow on Coldfusion MX Standard 6.1 version

2004-02-27 Thread Ketan Patel
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

RE: Protect action pages

2004-02-27 Thread Dave Watts
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

Re: Protect action pages

2004-02-27 Thread brobborb
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

RE: Protect action pages

2004-02-27 Thread Kwang Suh
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

Re: Detecting Images with Digital Rights

2004-02-27 Thread John Blayter
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

RE: Protect action pages

2004-02-27 Thread Dave Watts
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

RE: Protect action pages

2004-02-27 Thread Douglas.Knudsen
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-

  1   2   >