Re: !! cfmail wierdness on developer vs enterprise versions
On Thursday 01 June 2006 00:12, Duncan wrote: So this then goes back to my question - if the SMTP server throws an error, how do I get that error fed back to cf? I thought spool enable would be the answer. I believe the normal answer is to have a scheduled task to look at the Undelvr folder and copy them back to the main spool folder, or ping you an email or something. If you are setting spoolEnable to 'no', then CF should throw an error if the mail server given in the cfmail tag (or administrator if none in tag) rejects the message. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241897 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: how (the heck) to call functions on a jsp page?
On Wednesday 31 May 2006 18:28, stylo stylo wrote: Why not just use CreateObject() to create the Java class you need, and then use it like a CFC. So how would I do all that, including the jsp page includes and calling the functions on the jsp page? Ignore including a JSP page. In a CFML page: obj=createIObject('java','java.util.foo'); foo.init(myConstructorArgs); baz=foo.doSomethingWith(myArguments); writeOutput(baz); 'course, you can do the same thing with a tag syntax too. Maybe if you posted the code you were trying to convert we could take a stab, as James suggested. I have no idea, sorry. What's a class exactly? A java class, or the abstract OO notion of 'class' ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241898 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
free sql tool
http://www.red-gate.com/products/SQL_Prompt/index.htm get it while its free ~Dave the disruptor~ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241899 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Find in an array...
What the hell? I've run into this before but I just can't believe that MM didn't provide some sort of ArrayFind function!!! I've got this code: cfset villages = ArrayNew(1) cfset villages[1] = -25|25 cfset villages[2] = 4|14 cfset villages[3] = 12|20 Which works just fine. But I'm looping over a set of coordinates for a map and I want to find out if the current coordinates match coords in the array. But I have no way of doing that. Does anyone have any idea? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241900 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simpler Cleaner Way
Does this currently work for you? Are you calling several different component paths? Or just making different paths to the same directory? ... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills. - Napoleon Dynamite -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 6:32 PM To: CF-Talk Subject: Simpler Cleaner Way Here is my code: cfif cgi.https Is on cfset translatedPath = ReplaceNoCase(cgi.path_info, '/cart/cart.cfm','','one') cfset transalatedPath = ReplaceNoCase(translatedPath,'/','.','ALL') cfset translatedPath = Right(translatedPath, len(translatedPath)-1) cfif translatedPath Neq cfset request.componentDirectory = #ReplaceNoCase(translatedPath, '/','.','all')#.components /cfif /cfif Is there a simpler/cleaner way of doing this?? Basically I am getting a dynamic component directory path. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241902 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
What about something like this: cffunction name=FindSimpleValue access=public returntype=numeric output=no hint=This returns the index of the first occurence of the given string or number within a one dimensional array. !--- Define arguments. --- cfargument name=Array type=array required=yes / cfargument name=Value type=string required=yes / cfscript // Define local scope. var LOCAL = StructNew(); // Loop over array to find the given value. for (LOCAL.Index = 1 ; LOCAL.Index LTE ArrayLen(ARGUMENTS.Array) ; LOCAL.Index = (LOCAL.Index + 1)){ // Check for matching value. if (NOT Compare(ARGUMENTS.Array[LOCAL.Index], ARGUMENTS.Value)){ // We found a match. Return the index. return(LOCAL.Index); } } // At this point, we have not found the value. Return zero. return(0); /cfscript /cffunction .. Ben Nadel www.bennadel.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 2:24 PM To: CF-Talk Subject: Find in an array... What the hell? I've run into this before but I just can't believe that MM didn't provide some sort of ArrayFind function!!! I've got this code: cfset villages = ArrayNew(1) cfset villages[1] = -25|25 cfset villages[2] = 4|14 cfset villages[3] = 12|20 Which works just fine. But I'm looping over a set of coordinates for a map and I want to find out if the current coordinates match coords in the array. But I have no way of doing that. Does anyone have any idea? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241901 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
How about to use ArrayToList() and ListFind() Function? cfset cords = ArrayToList(villages) cfset result = ListFind(cords, 4|14) Artur -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 8:24 PM To: CF-Talk Subject: Find in an array... What the hell? I've run into this before but I just can't believe that MM didn't provide some sort of ArrayFind function!!! I've got this code: cfset villages = ArrayNew(1) cfset villages[1] = -25|25 cfset villages[2] = 4|14 cfset villages[3] = 12|20 Which works just fine. But I'm looping over a set of coordinates for a map and I want to find out if the current coordinates match coords in the array. But I have no way of doing that. Does anyone have any idea? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241903 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
reseting the CF admin password
Is there anyway to reset the CF administrator password? I have the development version on my laptop and I forgot the password because I donât use it that often. Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241904 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: reseting the CF admin password
Assuming you are using CF MX: 1. Stop the CFMX service. 2. Open cfmxroot/lib/password.properties (CFMX Standard) or jrun.home/servers/instance/cfusion-ear/cfusion-war/WEB-INF/lib/password.properties (CFMX/J2EE) 3. Change the password to something temporary. 4. Change the encrypt line to false. 5. Save the file and close. 6. Start CFMX Service. 7. Load up the administrator and use the password you chose in 3). 8. Change your administrator password once logged in. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 7:30 AM To: CF-Talk Subject: reseting the CF admin password Is there anyway to reset the CF administrator password? I have the development version on my laptop and I forgot the password because I donââ¬â¢t use it that often. Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241905 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: reseting the CF admin password
here it is on the coldfusion cookbook website: http://coldfusioncookbook.com/entry/68/How-do-I-reset-the-ColdFusion-Administrator-password? On 01/06/06, Chad Gray [EMAIL PROTECTED] wrote: Is there anyway to reset the CF administrator password? I have the development version on my laptop and I forgot the password because I don't use it that often. Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241906 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
Artur... I'm looping over what could potentially be 2500 records. I'd rather avoid converting back and forth. I ended up finding a function on cflib that did the trick. I'm just irritated that there's no ArrayFind function built into CF to begin with. That seems like a complete no-brainer. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Artur Kordowski [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 6:14 AM To: CF-Talk Subject: RE: Find in an array... How about to use ArrayToList() and ListFind() Function? cfset cords = ArrayToList(villages) cfset result = ListFind(cords, 4|14) Artur -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 8:24 PM To: CF-Talk Subject: Find in an array... What the hell? I've run into this before but I just can't believe that MM didn't provide some sort of ArrayFind function!!! I've got this code: cfset villages = ArrayNew(1) cfset villages[1] = -25|25 cfset villages[2] = 4|14 cfset villages[3] = 12|20 Which works just fine. But I'm looping over a set of coordinates for a map and I want to find out if the current coordinates match coords in the array. But I have no way of doing that. Does anyone have any idea? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241907 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find in an array...
I'd say the reasons they didn't include it are: 1) writing code to loop through an array to look for a simple value is only about 4 lines of code and 2) more importantly, a great deal of the time an array doesn't just contain simple values, but rather contains other arrays, CFC instances, queries, etc. In a large number of cases a simple arrayFind() wouldn't work anyway, and a custom function would have to be written anyway. Just by two cents. Regards, Brian On 6/1/06, Andy Matthews [EMAIL PROTECTED] wrote: Artur... I'm looping over what could potentially be 2500 records. I'd rather avoid converting back and forth. I ended up finding a function on cflib that did the trick. I'm just irritated that there's no ArrayFind function built into CF to begin with. That seems like a complete no-brainer. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Artur Kordowski [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 6:14 AM To: CF-Talk Subject: RE: Find in an array... How about to use ArrayToList() and ListFind() Function? cfset cords = ArrayToList(villages) cfset result = ListFind(cords, 4|14) Artur -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 8:24 PM To: CF-Talk Subject: Find in an array... What the hell? I've run into this before but I just can't believe that MM didn't provide some sort of ArrayFind function!!! I've got this code: cfset villages = ArrayNew(1) cfset villages[1] = -25|25 cfset villages[2] = 4|14 cfset villages[3] = 12|20 Which works just fine. But I'm looping over a set of coordinates for a map and I want to find out if the current coordinates match coords in the array. But I have no way of doing that. Does anyone have any idea? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241908 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
You are correct that they should have an ArrayFind function, but knowing this limitation you should code to the strength of the language. In CF, that means using a lot of lists and queries vs. something like C++ in which I would use arrays. Mike -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 8:10 AM To: CF-Talk Subject: RE: Find in an array... Artur... I'm looping over what could potentially be 2500 records. I'd rather avoid converting back and forth. I ended up finding a function on cflib that did the trick. I'm just irritated that there's no ArrayFind function built into CF to begin with. That seems like a complete no-brainer. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Artur Kordowski [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 6:14 AM To: CF-Talk Subject: RE: Find in an array... How about to use ArrayToList() and ListFind() Function? cfset cords = ArrayToList(villages) cfset result = ListFind(cords, 4|14) Artur -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 8:24 PM To: CF-Talk Subject: Find in an array... What the hell? I've run into this before but I just can't believe that MM didn't provide some sort of ArrayFind function!!! I've got this code: cfset villages = ArrayNew(1) cfset villages[1] = -25|25 cfset villages[2] = 4|14 cfset villages[3] = 12|20 Which works just fine. But I'm looping over a set of coordinates for a map and I want to find out if the current coordinates match coords in the array. But I have no way of doing that. Does anyone have any idea? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241909 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
and 2) more importantly, a great deal of the time an array doesn't just contain simple values, but rather contains other arrays, CFC instances, queries, etc. In a large number of cases a simple arrayFind() wouldn't work anyway, and a custom function would have to be written anyway. The same could be said for a structure, yet there is a StructFind() function. Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Problems with manipulating a query
I'm trying to manipulate the values in a query, by selecting a money value and replacing it with a formated value. QuerySetCell(qryTest,MONEYVALUE,LSCurrencyFormat(MONEYVALUE,'none'),currentrow); Original value: 123.45 Replace value: 123,45 But when I insert the new formated value, sometimes the value converts to a totally different value. After some research I found that if a value had descimal number 12 or less the value changed from 427,08 to -537787, but for decimal value lager than 12 there was no problem. Dump of query before manipulation FLOATVALUE MONEYVALUE 1 427.05 427.0500 2 427.06 427.0600 3 427.07 427.0700 4 427.08 427.0800 5 427.09 427.0900 6 427.1 427.1000 7 427.11 427.1100 8 427.12 427.1200 9 427.13 427.1300 10 427.14 427.1400 11 427.15 427.1500 12 427.16 427.1600 13 427.17 427.1700 14 427.18 427.1800 Dump of query after manipulation FLOATVALUE MONEYVALUE 1 -537879 -537879 2 -537848 -537848 3 -537818 -537818 4 -537787 -537787 5 -537756 -537756 6 -537726 -537726 7 -537695 -537695 8 -537665 -537665 9 427,13 427,13 10 427,14 427,14 11 427,15 427,15 12 427,16 427,16 13 427,17 427,17 14 427,18 427,18 What is the reason for this problem? Please help me :) Best regards Frode ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find in an array...
StructFind() searches for a key in a structure, not a value. The arrayFind() they are talking about is looking for a value. Its not the same. there is a StructFindValue() but it will only search for simple variables, not complex ones. On 6/1/06, Mike Klostermeyer [EMAIL PROTECTED] wrote: and 2) more importantly, a great deal of the time an array doesn't just contain simple values, but rather contains other arrays, CFC instances, queries, etc. In a large number of cases a simple arrayFind() wouldn't work anyway, and a custom function would have to be written anyway. The same could be said for a structure, yet there is a StructFind() function. Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
You're right, thanks for the correction. StructFindValue() was what I was thinking of. ArrayFindValue() would work for me! Mike -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 8:59 AM To: CF-Talk Subject: Re: Find in an array... StructFind() searches for a key in a structure, not a value. The arrayFind() they are talking about is looking for a value. Its not the same. there is a StructFindValue() but it will only search for simple variables, not complex ones. On 6/1/06, Mike Klostermeyer [EMAIL PROTECTED] wrote: and 2) more importantly, a great deal of the time an array doesn't just contain simple values, but rather contains other arrays, CFC instances, queries, etc. In a large number of cases a simple arrayFind() wouldn't work anyway, and a custom function would have to be written anyway. The same could be said for a structure, yet there is a StructFind() function. Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find in an array...
structFind() returns the value for a specified key, it doesn't search for a specified value. There is a structFindValue() function which I believe works recursively but I'm not sure. In 11 years of CF development I've never used this function. On 6/1/06, Mike Klostermeyer [EMAIL PROTECTED] wrote: and 2) more importantly, a great deal of the time an array doesn't just contain simple values, but rather contains other arrays, CFC instances, queries, etc. In a large number of cases a simple arrayFind() wouldn't work anyway, and a custom function would have to be written anyway. The same could be said for a structure, yet there is a StructFind() function. Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241914 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problems with manipulating a query
I don't know if this will work for sure I have not tested it. Recently when I had some float problems using the val() function sorted the calcuations out. Maybe this LSCurrencyFormat(val(MONEYVALUE),'none') OR val(LSCurrencyFormat(MONEYVALUE,'none')) will do the trick. Apparently it is all to do with the figure not being read correctly as a floating point. I beleive evaluate() has a similar effect in correcting floating point calculations. Hope it helps. cheers Martin I'm trying to manipulate the values in a query, by selecting a money value and replacing it with a formated value. QuerySetCell(qryTest,MONEYVALUE,LSCurrencyFormat(MONEYVALUE,'none'), currentrow); Original value: 123.45 Replace value: 123,45 But when I insert the new formated value, sometimes the value converts to a totally different value. After some research I found that if a value had descimal number 12 or less the value changed from 427,08 to -537787, but for decimal value lager than 12 there was no problem. Dump of query before manipulation FLOATVALUE MONEYVALUE 1 427.05 427.0500 2 427.06 427.0600 3 427.07 427.0700 4 427.08 427.0800 5 427.09 427.0900 6 427.1 427.1000 7 427.11 427.1100 8 427.12 427.1200 9 427.13 427.1300 10427.14 427.1400 11427.15 427.1500 12427.16 427.1600 13427.17 427.1700 14427.18 427.1800 Dump of query after manipulation FLOATVALUE MONEYVALUE 1 -537879 -537879 2 -537848 -537848 3 -537818 -537818 4 -537787 -537787 5 -537756 -537756 6 -537726 -537726 7 -537695 -537695 8 -537665 -537665 9 427,13 427,13 10427,14 427,14 11427,15 427,15 12427,16 427,16 13427,17 427,17 14427,18 427,18 What is the reason for this problem? Please help me :) Best regards Frode ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241915 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
I'm looping over what could potentially be 2500 records. I'd rather avoid converting back and forth. I ended up finding a function on cflib that did the trick. I'm glad you found a solution, and I agree that there should be an ArrayFind function (I was just wishing for that yesterday). But I have to say that 2500 array items is peanuts when you're dealing with RAM/CPU. I could be wrong, but I'd think it would be fairly inexpensive to convert back and forth. I'd take a look in that library you found to see what it's doing...could be just as expensive as a list conversion. --- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
Me too. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 9:03 AM To: CF-Talk Subject: RE: Find in an array... You're right, thanks for the correction. StructFindValue() was what I was thinking of. ArrayFindValue() would work for me! Mike -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 8:59 AM To: CF-Talk Subject: Re: Find in an array... StructFind() searches for a key in a structure, not a value. The arrayFind() they are talking about is looking for a value. Its not the same. there is a StructFindValue() but it will only search for simple variables, not complex ones. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241917 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: free sql tool
Holy cow, that tool is awesome! Thanks for the heads up. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:32 AM To: CF-Talk Subject: free sql tool http://www.red-gate.com/products/SQL_Prompt/index.htm get it while its free This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: free sql tool
I'll second that, were big fans of red gate too. Thanks Dave -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 10:54 AM To: CF-Talk Subject: RE: free sql tool Holy cow, that tool is awesome! Thanks for the heads up. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:32 AM To: CF-Talk Subject: free sql tool http://www.red-gate.com/products/SQL_Prompt/index.htm get it while its free This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
It was written by Ray... Here's the code: function QueryToStructOfStructures(theQuery, primaryKey){ var theStructure = StructNew(); // remove primary key from cols listing var cols = ListToArray(ListDeleteAt(theQuery.columnlist, ListFindNoCase(theQuery.columnlist, primaryKey))); var row = 1; var thisRow = ; var col = 1; for(row = 1; row LTE theQuery.recordcount; row = row + 1){ thisRow = structnew(); for(col = 1; col LTE arraylen(cols); col = col + 1){ thisRow[cols[col]] = theQuery[cols[col]][row]; } theStructure[theQuery[primaryKey][row]] = duplicate(thisRow); } return(theStructure); } !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 9:34 AM To: CF-Talk Subject: RE: Find in an array... I'm looping over what could potentially be 2500 records. I'd rather avoid converting back and forth. I ended up finding a function on cflib that did the trick. I'm glad you found a solution, and I agree that there should be an ArrayFind function (I was just wishing for that yesterday). But I have to say that 2500 array items is peanuts when you're dealing with RAM/CPU. I could be wrong, but I'd think it would be fairly inexpensive to convert back and forth. I'd take a look in that library you found to see what it's doing...could be just as expensive as a list conversion. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241920 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: free sql tool
Third. Their tools are sweet. -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 9:56 AM To: CF-Talk Subject: RE: free sql tool I'll second that, were big fans of red gate too. Thanks Dave -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 10:54 AM To: CF-Talk Subject: RE: free sql tool Holy cow, that tool is awesome! Thanks for the heads up. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:32 AM To: CF-Talk Subject: free sql tool http://www.red-gate.com/products/SQL_Prompt/index.htm get it while its free This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: how (the heck) to call functions on a jsp page?
You can't directly call functions in a JSP page. However, JSP and CF can share scopes. You'd have to rewrite your JSP page to put variables in the REQUEST scope. Here's an example: JSP PAGE % ThreadGroup threadGroup = Thread.currentThread().getThreadGroup().getParent(); Thread threadList[]=new Thread[Thread.activeCount()]; threadGroup.enumerate(threadList); request.setAttribute(threads, threadList); % CFML PAGE - cfscript // Call the JSP page GetPageContext().include(jspPage.jsp); // REQUEST.THREADS populated from JSP call QueryAddRow(ThreadQuery, arrayLen(request.threads)); for ( thread = 1; thread lte arrayLen(request.threads); thread = thread + 1 ) { code... code... code... } /cfscript -Original Message- From: stylo stylo [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 8:50 AM To: CF-Talk Subject: how (the heck) to call functions on a jsp page? I need to either rewrite some functions into cf (see my asp conversion thread) or include a jsp file and call 2 functions in there. To the latter: 1) the jsp file has at the top %@ page import = java.sql.*, java.util.*, java.util.zip.* % followed by 2 functions. Is that a problem? Are those special classes or regular ones the shared cf7 server will have already? 2) how do I call the 2 functions in the jsp page? I know I can use a GetPageContext().include(hello.jsp?name=Bobby); style but I don't need to include url variables, I need to call the functions there. How exactly do I call them??? Or I also found this example: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241922 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find in an array...
There is a list conversion in there, so it could be just as expensive as listFind(arraytolist()). But it's all academic at this point anyway, whatever works for you works and that's all that matters. :) -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 9:01 AM It was written by Ray... Here's the code: function QueryToStructOfStructures(theQuery, primaryKey){ var theStructure = StructNew(); // remove primary key from cols listing var cols = ListToArray(ListDeleteAt(theQuery.columnlist, ListFindNoCase(theQuery.columnlist, primaryKey))); var row = 1; var thisRow = ; var col = 1; for(row = 1; row LTE theQuery.recordcount; row = row + 1){ thisRow = structnew(); for(col = 1; col LTE arraylen(cols); col = col + 1){ thisRow[cols[col]] = theQuery[cols[col]][row]; } theStructure[theQuery[primaryKey][row]] = duplicate(thisRow); } return(theStructure); } This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241923 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Alternating Rows issue with M$ IE 6.X
Hello all, I am using the following code: cfoutput query=qClients maxrows=5 table cfset Class = IIF(qClients.CurrentRow MOD 2 EQ 0, 'td1', 'td4') tr class=#Class# td#tempClientID#/td td#DateFormat(tempDateModified,mm/dd/yy)#/td td#tempClientName#/td tdnbsp; a href=Client.cfm?Client_ID=#tempClientID#CustomerSearchIDshowFormDetails /a /td /tr /table /cfoutput This is working great in Firefox, but not Nutscrape of M$ IE. Do these browsers not understand the class attribute in the tablerow? Thanks, Bruce ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241924 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Alternating Rows issue with M$ IE 6.X
On Thursday 01 June 2006 16:48, Bruce Sorge wrote: This is working great in Firefox, but not Nutscrape of M$ IE. Do these browsers not understand the class attribute in the tablerow? Set it on the td as well. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Alternating Rows issue with M$ IE 6.X
what does the style look like? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241926 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Alternating Rows issue with M$ IE 6.X
That did it. Thanks. Tom. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241927 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Alternating Rows issue with M$ IE 6.X
I will go on a limb and say it should be td1 or td4 and not 'td1' or 'td4' Remove the single quote. May be wrong but the output would be: TR CLASS='td1' if you use your example. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 11:55 AM To: CF-Talk Subject: Re: Alternating Rows issue with M$ IE 6.X On Thursday 01 June 2006 16:48, Bruce Sorge wrote: This is working great in Firefox, but not Nutscrape of M$ IE. Do these browsers not understand the class attribute in the tablerow? Set it on the td as well. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241928 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Alternating Rows issue with M$ IE 6.X
You can style a TR just fine. Check your source. Randy's suggestion that there's extra single quotes in there sounds like it might solve your issue. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 10:49 AM To: CF-Talk Subject: Alternating Rows issue with M$ IE 6.X Hello all, I am using the following code: cfoutput query=qClients maxrows=5 table cfset Class = IIF(qClients.CurrentRow MOD 2 EQ 0, 'td1', 'td4') tr class=#Class# td#tempClientID#/td td#DateFormat(tempDateModified,mm/dd/yy)#/td td#tempClientName#/td tdnbsp; a href=Client.cfm?Client_ID=#tempClientID#CustomerSearchIDshowFormDetails /a /td /tr /table /cfoutput This is working great in Firefox, but not Nutscrape of M$ IE. Do these browsers not understand the class attribute in the tablerow? Thanks, Bruce ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241929 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Document Upload/Retrieval Security
Hi, I've got a fed govt project where I need to allow for sensitive documents (pdf, doc, wpd, gif, tiff, xls, txt - anything really) to be uploaded via a secure (uname/pwd) CF app (6.1 currently) using SSL. I have a number of questions: 1) Is SSL (128-bit) secure enough for the upload/download/viewing of these documents? 2) Depending on #1, would you store the docs in the SQL Server 2000 database as image data type or on the file system with metadata and pointers to the files in a database table? Please explain your opinion. 3) The client would like to be able to view several documents in a browser at the same time, possibly all docs related to a case, so that he/she can scroll through everything w/o having to open one doc at a time. Is this possible? Are there COTS products out there that you recommend? 4) The client would also like to search the documents. I've assumed that any scanned documents would have to be converted to PDF using OCR in order to be searchable using Verity (using the file system approach). Is that correct? Is Adobe's OCR product worthwhile? Are there other COTS products that are better? TIA, Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241930 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Document Upload/Retrieval Security
Hi, I've got a fed govt project where I need to allow for sensitive documents (pdf, doc, wpd, gif, tiff, xls, txt - anything really) to be uploaded via a secure (uname/pwd) CF app (6.1 currently) using SSL. I have a number of questions: 1) Is SSL (128-bit) secure enough for the upload/download/viewing of these documents? 2) Depending on #1, would you store the docs in the SQL Server 2000 database as image data type or on the file system with metadata and pointers to the files in a database table? Please explain your opinion. 3) The client would like to be able to view several documents in a browser at the same time, possibly all docs related to a case, so that he/she can scroll through everything w/o having to open one doc at a time. Is this possible? Are there COTS products out there that you recommend? 4) The client would also like to search the documents. I've assumed that any scanned documents would have to be converted to PDF using OCR in order to be searchable using Verity (using the file system approach). Is that correct? Is Adobe's OCR product worthwhile? Are there other COTS products that are better? TIA, Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241931 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOAP 302 Error
While trying to access a webservice from a partner, I receive the following SOAP Exception: AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (302)Found faultActor: faultNode: faultDetail: {}string: return code: 302 I can confirm that the webservice is available when viewing the WSDL file through a URL. However, when invoking it using either CFINVOKE or through CreateObject method, this error is received. After researching I understand it to be a redirection error in which Axis doesn't understand how to handle the 302 message. Has anyone developed a simple workaround for this error and is it something the consumer of web service should be developing a workaround or the publisher of the service? Thanks in advance for any help, Phil ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241932 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can I use CF 6.1 and CF 7 on the same machine?
Nathan, Nice blog post mate! If virtualisation is not an option (still to determine this) then you may have found the solution for me. How has your experience been running this kind of set up? Well, it's a development environment only, but I have yet to experience any problems. All I need to do is change my IP address to test code under both versions of CF. The virtualization options has some benefits, but I thought there'd be less overhead this way. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241933 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Document Upload/Retrieval Security
Regarding items 1 and 2. Since it's Federal, there may be security requirements already established for storage and transmittal of classified data. I'd research that some if you can. Terry This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Peter Legg [EMAIL PROTECTED] 06/01/2006 12:16 PM Please respond to cf-talk@houseoffusion.com To CF-Talk cf-talk@houseoffusion.com cc Subject Document Upload/Retrieval Security Hi, I've got a fed govt project where I need to allow for sensitive documents (pdf, doc, wpd, gif, tiff, xls, txt - anything really) to be uploaded via a secure (uname/pwd) CF app (6.1 currently) using SSL. I have a number of questions: 1) Is SSL (128-bit) secure enough for the upload/download/viewing of these documents? 2) Depending on #1, would you store the docs in the SQL Server 2000 database as image data type or on the file system with metadata and pointers to the files in a database table? Please explain your opinion. 3) The client would like to be able to view several documents in a browser at the same time, possibly all docs related to a case, so that he/she can scroll through everything w/o having to open one doc at a time. Is this possible? Are there COTS products out there that you recommend? 4) The client would also like to search the documents. I've assumed that any scanned documents would have to be converted to PDF using OCR in order to be searchable using Verity (using the file system approach). Is that correct? Is Adobe's OCR product worthwhile? Are there other COTS products that are better? TIA, Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241934 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: free sql tool
wow, was actually thanked!! It's a landmark day haha Actually thank communitymx.com for that one ~Dave the disruptor~ From: Mike Klostermeyer [EMAIL PROTECTED] Sent: Thursday, June 01, 2006 11:07 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: free sql tool Third. Their tools are sweet. -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 9:56 AM To: CF-Talk Subject: RE: free sql tool I'll second that, were big fans of red gate too. Thanks Dave -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 10:54 AM To: CF-Talk Subject: RE: free sql tool Holy cow, that tool is awesome! Thanks for the heads up. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:32 AM To: CF-Talk Subject: free sql tool http://www.red-gate.com/products/SQL_Prompt/index.htm get it while its free This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Document Upload/Retrieval Security
Terry, thanks for the reply. The documents aren't really classified. The project involves job discrimination complaints and notes/docs associated with the investigations. So some of the docs might have sensitive personal info (ssn, name, address, etc.). I know how to provide for uploading of the docs and viewing them with SSL. I don't know if I should store them in the db or the file system. Typically, I would store them in the file system but I've been reading some about a security advantage if they're stored in the db - not really sure why it's considered an advantage. I also don't know how to display several documents at once. Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241936 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Document Upload/Retrieval Security
Peter, Your question 4 answers your question 2, if they want to search the text you would not be able to store the data as a image, you would have to use some form of text based storage. You would need to setup something to read the text from every file type you will allow to be uploaded, and possibly provide some ad-hoc text entered by the user in the event you cannot read from their document. Re. question 1, I don't think a more secure SSL certificate is any harder to implement, I would go for a more secure one. Its always better to error on the 'more secure' rather than less secure methods =) As far as storage goes, I run a document imaging system here using MS SQL to maintain meta information about each document, and a pointer to a ..tiff image on our network. I used www.alternatiff.com as a web based Tiff viewer (only works with tiffs unfortunately, but it's a great program and works with IE or FF). If I was going for security though, I think I would use some of the Coldfusion based encryption functions, and store all my documents in some form of text, or you could even (if you are really paranoid) read the image or document into memory using cffile, encode to a database writable format, and store that after encryption. I imagine that would be pretty slow to read, but it would be the most secure method. To address item 3, Alternatiff provides a JavaScript api you can use to pass in new images, so you could have a list of documents on a part of your page, and when they click on it the plugin opens the new image right inside your site (this is what I use now for document queuing and an online indexing module) Hope any of my rambling helps! Chris Peterson Gainey Corporation -Original Message- From: Peter Legg [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 12:20 PM To: CF-Talk Subject: Document Upload/Retrieval Security Hi, I've got a fed govt project where I need to allow for sensitive documents (pdf, doc, wpd, gif, tiff, xls, txt - anything really) to be uploaded via a secure (uname/pwd) CF app (6.1 currently) using SSL. I have a number of questions: 1) Is SSL (128-bit) secure enough for the upload/download/viewing of these documents? 2) Depending on #1, would you store the docs in the SQL Server 2000 database as image data type or on the file system with metadata and pointers to the files in a database table? Please explain your opinion. 3) The client would like to be able to view several documents in a browser at the same time, possibly all docs related to a case, so that he/she can scroll through everything w/o having to open one doc at a time. Is this possible? Are there COTS products out there that you recommend? 4) The client would also like to search the documents. I've assumed that any scanned documents would have to be converted to PDF using OCR in order to be searchable using Verity (using the file system approach). Is that correct? Is Adobe's OCR product worthwhile? Are there other COTS products that are better? TIA, Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241937 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
mySQLxCase statement: where value in range
I've got a table with around 4 records. There's a column called v_pop with a range of 2 - 1000. I'd like to color code some HTML but use the query to do that work. So check out the code below. It runs just fine, with no errors, BUT, it only returns white and pink as the class, even though I know for a fact that there are records with higher values. What am I doing wrong here? I'm running mySQL 4.1.17 SELECT v_player, CASE WHEN v_pop 49 THEN 'white' WHEN v_pop 50 99 THEN 'pink' WHEN v_pop 100 199 THEN 'salmon' WHEN v_pop 200 299 THEN 'yellow' WHEN v_pop 300 299 THEN 'orange' WHEN v_pop 400 399 THEN 'red' WHEN v_pop 500 499 THEN 'brick' END AS class FROM x_world !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241938 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: mySQLxCase statement: where value in range
In the orange, red, and brick cases, you have 300 299, 400 399, and 500499, which leaves no possibility for values. You need to bump up each of those less than values by 100. I'm sure it was just a typo on your part. -- Josh - Original Message - From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, June 01, 2006 11:05 AM Subject: mySQLxCase statement: where value in range I've got a table with around 4 records. There's a column called v_pop with a range of 2 - 1000. I'd like to color code some HTML but use the query to do that work. So check out the code below. It runs just fine, with no errors, BUT, it only returns white and pink as the class, even though I know for a fact that there are records with higher values. What am I doing wrong here? I'm running mySQL 4.1.17 SELECT v_player, CASE WHEN v_pop 49 THEN 'white' WHEN v_pop 50 99 THEN 'pink' WHEN v_pop 100 199 THEN 'salmon' WHEN v_pop 200 299 THEN 'yellow' WHEN v_pop 300 299 THEN 'orange' WHEN v_pop 400 399 THEN 'red' WHEN v_pop 500 499 THEN 'brick' END AS class FROM x_world !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241939 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can I use CF 6.1 and CF 7 on the same machine?
Well, it's a development environment only, but I have yet to experience any problems. All I need to do is change my IP address to test code under both versions of CF. I'm jumping into this thread late, but if you use Apache for your dev web server you can map both versions of CF to things like http://cf6/ and http://cf7/, and you don't need to change your IP address. I'm doing this for the various projects I maintain, I can go to http://cfquickdocs/ or http://blog/. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241940 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: mySQLxCase statement: where value in range
Also, 49 = white and 50 gets you pink, but 50 will get you nothing at all and the same goes for 100, 200... --Ferg Josh Nathanson wrote: In the orange, red, and brick cases, you have 300 299, 400 399, and 500499, which leaves no possibility for values. You need to bump up each of those less than values by 100. I'm sure it was just a typo on your part. -- Josh - Original Message - From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, June 01, 2006 11:05 AM Subject: mySQLxCase statement: where value in range I've got a table with around 4 records. There's a column called v_pop with a range of 2 - 1000. I'd like to color code some HTML but use the query to do that work. So check out the code below. It runs just fine, with no errors, BUT, it only returns white and pink as the class, even though I know for a fact that there are records with higher values. What am I doing wrong here? I'm running mySQL 4.1.17 SELECT v_player, CASE WHEN v_pop 49 THEN 'white' WHEN v_pop 50 99 THEN 'pink' WHEN v_pop 100 199 THEN 'salmon' WHEN v_pop 200 299 THEN 'yellow' WHEN v_pop 300 299 THEN 'orange' WHEN v_pop 400 399 THEN 'red' WHEN v_pop 500 499 THEN 'brick' END AS class FROM x_world !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241941 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: mySQLxCase statement: where value in range
Yep... That was ONE of the problems. The other was that I needed an AND v_pop before the final value. Here's the working result: CASE WHEN v_pop = 50 THEN 'white' WHEN v_pop = 50 AND v_pop = 99 THEN 'pink' WHEN v_pop = 100 AND v_pop = 199 THEN 'salmon' WHEN v_pop = 200 AND v_pop = 299 THEN 'yellow' WHEN v_pop = 300 AND v_pop = 399 THEN 'orange' WHEN v_pop = 400 AND v_pop = 499 THEN 'red' WHEN v_pop = 500 AND v_pop = 599 THEN 'brick' WHEN v_pop = 600 THEN 'purple' ELSE 'black' END AS class !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 1:11 PM To: CF-Talk Subject: Re: mySQLxCase statement: where value in range In the orange, red, and brick cases, you have 300 299, 400 399, and 500499, which leaves no possibility for values. You need to bump up each of those less than values by 100. I'm sure it was just a typo on your part. -- Josh - Original Message - From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, June 01, 2006 11:05 AM Subject: mySQLxCase statement: where value in range I've got a table with around 4 records. There's a column called v_pop with a range of 2 - 1000. I'd like to color code some HTML but use the query to do that work. So check out the code below. It runs just fine, with no errors, BUT, it only returns white and pink as the class, even though I know for a fact that there are records with higher values. What am I doing wrong here? I'm running mySQL 4.1.17 SELECT v_player, CASE WHEN v_pop 49 THEN 'white' WHEN v_pop 50 99 THEN 'pink' WHEN v_pop 100 199 THEN 'salmon' WHEN v_pop 200 299 THEN 'yellow' WHEN v_pop 300 299 THEN 'orange' WHEN v_pop 400 399 THEN 'red' WHEN v_pop 500 499 THEN 'brick' END AS class FROM x_world !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241942 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: mySQLxCase statement: where value in range
you've still got a problem with one of your round values. 50 satisfies 2 conditions. --Ferg Andy Matthews wrote: Yep... That was ONE of the problems. The other was that I needed an AND v_pop before the final value. Here's the working result: CASE WHEN v_pop = 50 THEN 'white' WHEN v_pop = 50 AND v_pop = 99 THEN 'pink' WHEN v_pop = 100 AND v_pop = 199 THEN 'salmon' WHEN v_pop = 200 AND v_pop = 299 THEN 'yellow' WHEN v_pop = 300 AND v_pop = 399 THEN 'orange' WHEN v_pop = 400 AND v_pop = 499 THEN 'red' WHEN v_pop = 500 AND v_pop = 599 THEN 'brick' WHEN v_pop = 600 THEN 'purple' ELSE 'black' END AS class !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 1:11 PM To: CF-Talk Subject: Re: mySQLxCase statement: where value in range In the orange, red, and brick cases, you have 300 299, 400 399, and 500499, which leaves no possibility for values. You need to bump up each of those less than values by 100. I'm sure it was just a typo on your part. -- Josh - Original Message - From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, June 01, 2006 11:05 AM Subject: mySQLxCase statement: where value in range I've got a table with around 4 records. There's a column called v_pop with a range of 2 - 1000. I'd like to color code some HTML but use the query to do that work. So check out the code below. It runs just fine, with no errors, BUT, it only returns white and pink as the class, even though I know for a fact that there are records with higher values. What am I doing wrong here? I'm running mySQL 4.1.17 SELECT v_player, CASE WHEN v_pop 49 THEN 'white' WHEN v_pop 50 99 THEN 'pink' WHEN v_pop 100 199 THEN 'salmon' WHEN v_pop 200 299 THEN 'yellow' WHEN v_pop 300 299 THEN 'orange' WHEN v_pop 400 399 THEN 'red' WHEN v_pop 500 499 THEN 'brick' END AS class FROM x_world !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241943 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Adding Verity
If one would want to install the Verity search functionality to a CF server that did not have it added during the initial installation, how would one do that? Can it be done without completely uninstalling and reinstalling ColdFusion server? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding Verity
I'm pretty sure thisis possible. You tried the cfusionmx7\verity\verity-install.bat file? On 6/1/06, Ian Skinner [EMAIL PROTECTED] wrote: If one would want to install the Verity search functionality to a CF server that did not have it added during the initial installation, how would one do that? Can it be done without completely uninstalling and reinstalling ColdFusion server? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241945 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
If one would want to install the Verity search functionality to a CF server that did not have it added during the initial installation, how would one do that? The easiest way would be to download the separate Verity installer from the Adobe site. Can it be done without completely uninstalling and reinstalling ColdFusion server? Yes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241946 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
quote src=CF Documentation - Configuring and Administering ColdFusion MX - Introduction Verity and Verity Tools - About the Verity utilities ColdFusion MX OEM restrictions ColdFusion MX includes a restricted version of the Verity Server, with restrictions in the following areas: The Verity Spider that is included with ColdFusion MX is licensed for local host indexing only. Contact Verity Sales for licensing options regarding the use of the Verity Spider for remote host indexing. /quote Does this line in the documentation mean that I will not be able to index a group of word documents on a file server accessed from a Cold Fusion template with UNC paths? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241947 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
I'm pretty sure this is possible. You tried the cfusionmx7\verity\verity-install.bat file? Nope, I had yet to find any hint in the documentation that this file existed. I'll go search for it now. Now where might that path be in my multi-home version since I don't think I have a cfusionmx7 directory, HMMM. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241948 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
The easiest way would be to download the separate Verity installer from the Adobe site. Is this different then Ray's suggestion? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241949 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: mySQLxCase statement: where value in range
Ah yes... That needs to be 49 then. Thanks Ken. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 1:48 PM To: CF-Talk Subject: Re: mySQLxCase statement: where value in range you've still got a problem with one of your round values. 50 satisfies 2 conditions. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: mySQLxCase statement: where value in range
Ah yes... That needs to be 49 then. Thanks Ken. Well actually it needs to be = 49 OR 50 otherwise the value 49 would never match a condition. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241951 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Document Upload/Retrieval Security
Chris, thanks. I've embedded some comments within yours below. Any feedback is appreciated. Peter Peter, Your question 4 answers your question 2, if they want to search the text you would not be able to store the data as a image, you would have to use some form of text based storage. You would need to setup something to read the text from every file type you will allow to be uploaded, and possibly provide some ad-hoc text entered by the user in the event you cannot read from their document. I was under the impression you could using full-text searching of documents stored in a SQL Server database. That would be the alternative to using Verity for the docs stored in the file system. Here's a link 9albeit somewhat biased I guess) that explains it - http://www.dbazine.com/sql/sql-articles/charran5 Re. question 1, I don't think a more secure SSL certificate is any harder to implement, I would go for a more secure one. Its always better to error on the 'more secure' rather than less secure methods =) As far as storage goes, I run a document imaging system here using MS SQL to maintain meta information about each document, and a pointer to a .tiff image on our network. I used www.alternatiff.com as a web based Tiff viewer (only works with tiffs unfortunately, but it's a great program and works with IE or FF). If I was going for security though, I think I would use some of the Coldfusion based encryption functions, and store all my documents in some form of text, or you could even (if you are really paranoid) read the image or document into memory using cffile, encode to a database writable format, and store that after encryption. I imagine that would be pretty slow to read, but it would be the most secure method. I personally don't think that any security other than SSL is required for this project. Some others involved think the files should be encrypted and stored in the database. Maybe I just don't understand the difference between the security provided by SSL and the additional security that encrypting the files and then storing them in the db will provide. I guess I just don't think it's worth the overhead that would be required to retrieve upwards of 50 documents, potentially, for a case and display them to a user in a browser. To address item 3, Alternatiff provides a JavaScript api you can use to pass in new images, so you could have a list of documents on a part of your page, and when they click on it the plugin opens the new image right inside your site (this is what I use now for document queuing and an online indexing module) So you're viewing one image of a document at a time. That's what I would normally use but the client is interesed in being able to view several at a time so that they can scroll through the case so to speak w/o having to open each document. Are you suggesting that I could use cffile to read several in at a time (to memory) and then display the group? Hope any of my rambling helps! Chris Peterson Gainey Corporation -Original Message- From: Peter Legg [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 12:20 PM To: CF-Talk Subject: Document Upload/Retrieval Security Hi, I've got a fed govt project where I need to allow for sensitive documents (pdf, doc, wpd, gif, tiff, xls, txt - anything really) to be uploaded via a secure (uname/pwd) CF app (6.1 currently) using SSL. I have a number of questions: 1) Is SSL (128-bit) secure enough for the upload/download/viewing of these documents? 2) Depending on #1, would you store the docs in the SQL Server 2000 database as image data type or on the file system with metadata and pointers to the files in a database table? Please explain your opinion. 3) The client would like to be able to view several documents in a browser at the same time, possibly all docs related to a case, so that he/she can scroll through everything w/o having to open one doc at a time. Is this possible? Are there COTS products out there that you recommend? 4) The client would also like to search the documents. I've assumed that any scanned documents would have to be converted to PDF using OCR in order to be searchable using Verity (using the file system approach). Is that correct? Is Adobe's OCR product worthwhile? Are there other COTS products that are better? TIA, Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241952 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Document Upload/Retrieval Security
Maybe I just don't understand the difference between the security provided by SSL and the additional security that encrypting the files and then storing them in the db will provide. SSL will only provide encryption of the data while it is in transit from your server to the client server. Encrypting the documents either on the file system or in a database may provide protection against other personal that may have access to the computer system(s) storing the documents. These two options provide protection at different points. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241953 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Problems with LEN
OK, I have this query: cfquery datasource=#Session.DSN# name=qSearchResults SELECT ContactID, FIrstName, LastName, DateModified FROM Contact WHERE 0=0 AND cfif LEN(Form.FirstName) GT 0 FirstName cfif Form.searchCriteria IS exactPhrase = '#Form.FirstName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.FirstName#%' /cfif /cfif cfif LEN(Form.LastName) GT 0 AND LastName cfif Form.searchCriteria IS exactPhrase = '#Form.LastName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.LastName#%' /cfif /cfif /cfquery I can dump the LEN of firstname and lastname. So if I do not enter anything in the lastname field and enter something in the firstname field, the len for firstname is X and the LEN for lastname is 0, so by allrights it should only do the AND FirstName = #Form.FirstName# if I select exactPhrase. The only way it works if I enter something in one field but not the other is if I select allWords, because it is using the LIKE operator. So why is it that if I use ExactPhrase it executes the following query: SELECT ContactID, FirstName, LastName, DateModified FROM Contact WHERE 0=0 AND FirstName = 'Bruce' AND LastName = ' ' LastName should not even be a part of the query if I do not enter anything into it. Thanks, Bruce Sorge ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241954 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
Bruce, Don't use quotes in your Len call : LEN( Form.FirstName ) NOT LEN(Form.FirstName) If you use quotes, that will always evaluate to true since the string Form.firstname has a length. ... Ben Nadel www.bennadel.com -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:43 PM To: CF-Talk Subject: Problems with LEN OK, I have this query: cfquery datasource=#Session.DSN# name=qSearchResults SELECT ContactID, FIrstName, LastName, DateModified FROM Contact WHERE 0=0 AND cfif LEN(Form.FirstName) GT 0 FirstName cfif Form.searchCriteria IS exactPhrase = '#Form.FirstName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.FirstName#%' /cfif /cfif cfif LEN(Form.LastName) GT 0 AND LastName cfif Form.searchCriteria IS exactPhrase = '#Form.LastName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.LastName#%' /cfif /cfif /cfquery I can dump the LEN of firstname and lastname. So if I do not enter anything in the lastname field and enter something in the firstname field, the len for firstname is X and the LEN for lastname is 0, so by allrights it should only do the AND FirstName = #Form.FirstName# if I select exactPhrase. The only way it works if I enter something in one field but not the other is if I select allWords, because it is using the LIKE operator. So why is it that if I use ExactPhrase it executes the following query: SELECT ContactID, FirstName, LastName, DateModified FROM Contact WHERE 0=0 AND FirstName = 'Bruce' AND LastName = ' ' LastName should not even be a part of the query if I do not enter anything into it. Thanks, Bruce Sorge ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241955 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
That worked. Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241956 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problems with LEN
cfif LEN(Form.FirstName) GT 0 You also do not need to do the GT 0, ColdFusion boolean operators use all non 0 values as TRUE. And you should also TRIM your values as someone may have entered a space into the field cfif LEN(TRIM(Form.FirstName)) =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241957 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
Len doesn't evaluate true or false. It returns a number relating to the number of characters in the string. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:54 PM To: CF-Talk Subject: RE: Problems with LEN Bruce, Don't use quotes in your Len call : LEN( Form.FirstName ) NOT LEN(Form.FirstName) If you use quotes, that will always evaluate to true since the string Form.firstname has a length. Ben Nadel www.bennadel.com -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:43 PM To: CF-Talk Subject: Problems with LEN OK, I have this query: cfquery datasource=#Session.DSN# name=qSearchResults SELECT ContactID, FIrstName, LastName, DateModified FROM Contact WHERE 0=0 AND cfif LEN(Form.FirstName) GT 0 FirstName cfif Form.searchCriteria IS exactPhrase = '#Form.FirstName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.FirstName#%' /cfif /cfif cfif LEN(Form.LastName) GT 0 AND LastName cfif Form.searchCriteria IS exactPhrase = '#Form.LastName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.LastName#%' /cfif /cfif /cfquery I can dump the LEN of firstname and lastname. So if I do not enter anything in the lastname field and enter something in the firstname field, the len for firstname is X and the LEN for lastname is 0, so by allrights it should only do the AND FirstName = #Form.FirstName# if I select exactPhrase. The only way it works if I enter something in one field but not the other is if I select allWords, because it is using the LIKE operator. So why is it that if I use ExactPhrase it executes the following query: SELECT ContactID, FirstName, LastName, DateModified FROM Contact WHERE 0=0 AND FirstName = 'Bruce' AND LastName = ' ' LastName should not even be a part of the query if I do not enter anything into it. Thanks, Bruce Sorge ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241958 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
Have you tried LEN(TRIM(Form.LastName)) ? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:43 PM To: CF-Talk Subject: Problems with LEN OK, I have this query: cfquery datasource=#Session.DSN# name=qSearchResults SELECT ContactID, FIrstName, LastName, DateModified FROM Contact WHERE 0=0 AND cfif LEN(Form.FirstName) GT 0 FirstName cfif Form.searchCriteria IS exactPhrase = '#Form.FirstName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.FirstName#%' /cfif /cfif cfif LEN(Form.LastName) GT 0 AND LastName cfif Form.searchCriteria IS exactPhrase = '#Form.LastName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.LastName#%' /cfif /cfif /cfquery I can dump the LEN of firstname and lastname. So if I do not enter anything in the lastname field and enter something in the firstname field, the len for firstname is X and the LEN for lastname is 0, so by allrights it should only do the AND FirstName = #Form.FirstName# if I select exactPhrase. The only way it works if I enter something in one field but not the other is if I select allWords, because it is using the LIKE operator. So why is it that if I use ExactPhrase it executes the following query: SELECT ContactID, FirstName, LastName, DateModified FROM Contact WHERE 0=0 AND FirstName = 'Bruce' AND LastName = ' ' LastName should not even be a part of the query if I do not enter anything into it. Thanks, Bruce Sorge ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241959 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
Thanks Alan for the advice. I always forget the TRIM function. -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:59 PM To: CF-Talk Subject: Re: Problems with LEN cfif LEN(Form.FirstName) GT 0 You also do not need to do the GT 0, ColdFusion boolean operators use all non 0 values as TRUE. And you should also TRIM your values as someone may have entered a space into the field cfif LEN(TRIM(Form.FirstName)) =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241960 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
I agree with Alan, I am a HUGE fan of not putting things like GT O or NEQ 0 for boolean evaluation. I find it easier to read without the comparison. ... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills. - Napoleon Dynamite -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:59 PM To: CF-Talk Subject: Re: Problems with LEN cfif LEN(Form.FirstName) GT 0 You also do not need to do the GT 0, ColdFusion boolean operators use all non 0 values as TRUE. And you should also TRIM your values as someone may have entered a space into the field cfif LEN(TRIM(Form.FirstName)) =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241961 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
Andy, This is true, it does return a length, however in this case he is using that Len() return to be essentially Zero or NOT Zero. He wants it to be cast to boolean, which CF will do automatically. ... Ben Nadel www.bennadel.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:59 PM To: CF-Talk Subject: RE: Problems with LEN Len doesn't evaluate true or false. It returns a number relating to the number of characters in the string. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:54 PM To: CF-Talk Subject: RE: Problems with LEN Bruce, Don't use quotes in your Len call : LEN( Form.FirstName ) NOT LEN(Form.FirstName) If you use quotes, that will always evaluate to true since the string Form.firstname has a length. . Ben Nadel www.bennadel.com -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:43 PM To: CF-Talk Subject: Problems with LEN OK, I have this query: cfquery datasource=#Session.DSN# name=qSearchResults SELECT ContactID, FIrstName, LastName, DateModified FROM Contact WHERE 0=0 AND cfif LEN(Form.FirstName) GT 0 FirstName cfif Form.searchCriteria IS exactPhrase = '#Form.FirstName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.FirstName#%' /cfif /cfif cfif LEN(Form.LastName) GT 0 AND LastName cfif Form.searchCriteria IS exactPhrase = '#Form.LastName#' cfelseif Form.searchCriteria IS allWords LIKE '%#Form.LastName#%' /cfif /cfif /cfquery I can dump the LEN of firstname and lastname. So if I do not enter anything in the lastname field and enter something in the firstname field, the len for firstname is X and the LEN for lastname is 0, so by allrights it should only do the AND FirstName = #Form.FirstName# if I select exactPhrase. The only way it works if I enter something in one field but not the other is if I select allWords, because it is using the LIKE operator. So why is it that if I use ExactPhrase it executes the following query: SELECT ContactID, FirstName, LastName, DateModified FROM Contact WHERE 0=0 AND FirstName = 'Bruce' AND LastName = ' ' LastName should not even be a part of the query if I do not enter anything into it. Thanks, Bruce Sorge ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241962 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
I'm pretty sure this is possible. You tried the cfusionmx7\verity\verity-install.bat file? Well, for me it was jrun\verity\verity-install.bat (multi-home configuration). But it worked like a charm. Took me all of 15 minutes to create a collection, index all 87 word documents that comprise our employee handbook and create a basic template that will allow searching of this information. Now why have I never had a need to do anything like this in the past eight years plus I have been using ColdFusion. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241963 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Document Upload/Retrieval Security
Ian, I do understand that if the files aren't encrypted that they could potentially be viewed/copied by those with access to the servers on which they reside, whether on the file system or in the db. What I don't have from the client, and I don't think I'll be able to get a definitivee answer, is the required level of security. I don't know whether or not they want these files to be unreadable by personnel administering the servers. I'll definitely ask that question. Essentially, I have to make a case for the approach I'm going to propose. I would rather not store the docs in a database, but if there aren't major performance issues with this approach then maybe I will do it that way. I would also rather not encrypt the docs and then decypt them while viewing. I will push the client for an answer to that. What's your take on the performance issues here? Do you think the increased overhead involved with decryption of documents when a user chooses to view potentially 50+ documents at one time in a browser (if that's possible) will seriously affect app performance? For this scenario, do you think the file system approach is better than the db approach? Thanks, Peter Maybe I just don't understand the difference between the security provided by SSL and the additional security that encrypting the files and then storing them in the db will provide. SSL will only provide encryption of the data while it is in transit from your server to the client server. Encrypting the documents either on the file system or in a database may provide protection against other personal that may have access to the computer system(s) storing the documents. These two options provide protection at different points. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241964 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
Does this line in the documentation mean that I will not be able to index a group of word documents on a file server accessed from a Cold Fusion template with UNC paths? The Verity spider is an HTTP crawler. I don't know if it even supports SMB/CIFS regardless of license restrictions. So, no, you probably won't be able to use vspider to index those documents. However, you can certainly do it using the CFINDEX tag. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241965 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
And you should also TRIM your values as someone may have entered a space into the field cfif LEN(TRIM(Form.FirstName)) I keep saying to myself that I should write the user defined function LenTrim(). Using this construct has become so ingrained with me that my fingers automatically type trim whenever I type len. But, for some reason, often forget to type the internal left parentheses. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241966 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
The easiest way would be to download the separate Verity installer from the Adobe site. Is this different then Ray's suggestion? The separate Verity installer can actually be used to install K2 on a machine other than your CF server. I don't think you'll have the Verity installer on your machine unless you originally chose to install it with CF, so I don't think Ray's suggestion will work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241967 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
I keep saying to myself that I should write the user defined function LenTrim(). Using this construct has become so ingrained with me that my fingers automatically type trim whenever I type len. But, for some reason, often forget to type the internal left parentheses. The main reason I have not bothered to do this is that it would probable be just as much trouble to remember to include the UDF file on every template that I might use a lenTrim function as it is to debug the error I get when I forget the internal parentheses. Is there someway to add a function to the CF system so that it is automatically available to all templates as the built in functions are? Is there a directory of functions or something similar to CF tags/custom tags? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241968 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
In my pre-page processing (application.cfm|cfc) I loop over the FORM collection and trim each value... Then you never have to worry about trimming anything ever again. I love it, never looked back. ... Ben Nadel www.bennadel.com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 4:16 PM To: CF-Talk Subject: RE: Problems with LEN I keep saying to myself that I should write the user defined function LenTrim(). Using this construct has become so ingrained with me that my fingers automatically type trim whenever I type len. But, for some reason, often forget to type the internal left parentheses. The main reason I have not bothered to do this is that it would probable be just as much trouble to remember to include the UDF file on every template that I might use a lenTrim function as it is to debug the error I get when I forget the internal parentheses. Is there someway to add a function to the CF system so that it is automatically available to all templates as the built in functions are? Is there a directory of functions or something similar to CF tags/custom tags? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241969 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
Is there someway to add a function to the CF system so that it is automatically available to all templates as the built in functions are? Is there a directory of functions or something similar to CF tags/custom tags? That would be very nice...I'm waiting to hear if anybody knows how to do this. --- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241970 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
I see... I do the same thing you do, using the return value as a boolean. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:04 PM To: CF-Talk Subject: RE: Problems with LEN Andy, This is true, it does return a length, however in this case he is using that Len() return to be essentially Zero or NOT Zero. He wants it to be cast to boolean, which CF will do automatically. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: if/switch cf:set/param
If you're doing a large comparison set, my understanding is that switch is better for performance. As for cfset vs cfparam, cfset sets the variable and overwrites and previous value that the variable held. Cfparam sets the variable if it doesn't already exist. Basically, cfparam ensures that the variable has a value when you try to use the variable, however, if the variable is set elsewhere prior to the cfparam, the cfparam is ignored. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:55 PM To: CF-Talk Subject: cf:if/switch cf:set/param ok. just looking at a bunch of code. most pages use a combo of if switch what are the reasons to use one over the other. also what is the difference between cfset cfparam. i know cfset sets the variable you want to be but dosnt cfparam also do this? also what should i know about variable pools? thanks -paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241976 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: if/switch cf:set/param
Paul, CFSwitch I believe is faster (slightly) , and I think easier to read. Also, the default case does not need to be the last case (as opposed to an ELSE statement). However, the tradeoff is that the case values have to be contstants. For IF statements, the benefits are the possibility of dynamic comparisons (ie. URL.x EQ URL.y ). Mostly though, it's a matter of personal preference I think. Cfset sets a value into a variable. Cfparam checks to see if a variable already exists. If it does not exist and a default was provided, it sets that value into the variable. If no default exists, it throws an error. I think there are a lot of different opinions on why/when it is appropriate to use CFParam vs setting a variable. I like to CFParam all my FORM variables and custom tag ATTRIBUTES (as an example). I like to know that a value exists, even if it isn't correct, because then I can validate afterwards. However, in Custom tags, I ususally don't have default values for all my attribute params so that CF will throw an error if the user does not provide the attribute. If by variable pools, you mean scopes (ex. APPLICATION, SESSION, REQUEST), they are fantastic! I scope (define within the context of a variable poo, ex. FORM.first_name) anything that is either submitted to a page or is available in more than one template. So for example, if I use an index variable that is for only one template, I might use intChild, but if I use a variable that is set in one template and used in another, I might use something like REQUEST.ChildIndex... It becomes a naming convention that I love because the structure of the variable helps explain what it is and where it was set/available. There is lots to know about the different scopes and how widely accessible they are. Check out the main ones in the live docs. ... Ben Nadel www.bennadel.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:55 PM To: CF-Talk Subject: cf:if/switch cf:set/param ok. just looking at a bunch of code. most pages use a combo of if switch what are the reasons to use one over the other. also what is the difference between cfset cfparam. i know cfset sets the variable you want to be but dosnt cfparam also do this? also what should i know about variable pools? thanks -paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241977 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Document Upload/Retrieval Security
Peter I've never stored documents in a DB so I can't give you much of a performance comparison. I've always just stored the documents in the file system and metadata in the database. But the few times I have needed to do this have been very small systems. One of the biggest differences between these methods is synchronization. When the file is stored on the file system and the metadata in the database it is much easier for disconnects to occur because at some point somebody adds|moves|renames|deletes a file outside of the document management system. Now there is a difference between the records in the database and the files on the file system. If one is to put the file itself into the database this kind of synchronization issue is much less problematic. But as with most programming problems, YMMV and one must decide on what is best for the problem at hand. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding Verity
The separate Verity installer can actually be used to install K2 on a machine other than your CF server. I don't think you'll have the Verity installer on your machine unless you originally chose to install it with CF, so I don't think Ray's suggestion will work. It was there. And I was able to index my word documents on the file server by using the UNC path in the administrator Verity collection configuration. I guess I did not understand that this was different then using the spider. I presumed it was just the CF way of setting the spider to its task. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - 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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241982 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: if/switch cf:set/param
A good example of the usage of cfparam involves when you're using input type=checkbox on a form. If the user doesn't check the checkbox, the form field is not posted at all, so an attempt to evaluate it using form.checkboxfield (example) results in field undefined in form error. Using cfparam name=form.checkboxfield default=0 on your form processing page alleviates that problem nicely. If the checkbox is checked (assuming the checked value is 1), form.checkboxfield evaluates to 1. If it's not checked, it evaluates to 0 because of the cfparam tag. Of course there are a million other uses for it, but I think the first time I ever used it was in that context. -- Josh - Original Message - From: Ben Nadel [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, June 01, 2006 2:01 PM Subject: RE: if/switch cf:set/param Paul, CFSwitch I believe is faster (slightly) , and I think easier to read. Also, the default case does not need to be the last case (as opposed to an ELSE statement). However, the tradeoff is that the case values have to be contstants. For IF statements, the benefits are the possibility of dynamic comparisons (ie. URL.x EQ URL.y ). Mostly though, it's a matter of personal preference I think. Cfset sets a value into a variable. Cfparam checks to see if a variable already exists. If it does not exist and a default was provided, it sets that value into the variable. If no default exists, it throws an error. I think there are a lot of different opinions on why/when it is appropriate to use CFParam vs setting a variable. I like to CFParam all my FORM variables and custom tag ATTRIBUTES (as an example). I like to know that a value exists, even if it isn't correct, because then I can validate afterwards. However, in Custom tags, I ususally don't have default values for all my attribute params so that CF will throw an error if the user does not provide the attribute. If by variable pools, you mean scopes (ex. APPLICATION, SESSION, REQUEST), they are fantastic! I scope (define within the context of a variable poo, ex. FORM.first_name) anything that is either submitted to a page or is available in more than one template. So for example, if I use an index variable that is for only one template, I might use intChild, but if I use a variable that is set in one template and used in another, I might use something like REQUEST.ChildIndex... It becomes a naming convention that I love because the structure of the variable helps explain what it is and where it was set/available. There is lots to know about the different scopes and how widely accessible they are. Check out the main ones in the live docs. ... Ben Nadel www.bennadel.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:55 PM To: CF-Talk Subject: cf:if/switch cf:set/param ok. just looking at a bunch of code. most pages use a combo of if switch what are the reasons to use one over the other. also what is the difference between cfset cfparam. i know cfset sets the variable you want to be but dosnt cfparam also do this? also what should i know about variable pools? thanks -paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Document Upload/Retrieval Security
Ian, I hear you. YMMV - hadn't seen that one before. Thanks for your thoughts - I appreciate it. Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: if/switch cf:set/param
One thing I haven't seen anybody else mention is that cfparam can be used for data validation, using the type attribute. For example, if you are expecting an email address from a form, you can do a cfparam with type=email and CF will throw an error if the data doesn't match (the email type is new to CF 7). -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 3:55 PM ok. just looking at a bunch of code. most pages use a combo of if switch what are the reasons to use one over the other. also what is the difference between cfset cfparam. i know cfset sets the variable you want to be but dosnt cfparam also do this? This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can I use CF 6.1 and CF 7 on the same machine?
Munson, Jacob wrote: I'm jumping into this thread late, but if you use Apache for your dev web server you can map both versions of CF to things like http://cf6/ and http://cf7/, and you don't need to change your IP address. I'm doing this for the various projects I maintain, I can go to http://cfquickdocs/ or http://blog/. That should even work without an external webserver. Change your hosts file to have: 127.0.0.6 cf6 127.0.0.7 cf7 Then tie the instance to the appropriate IP address. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241986 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Document Upload/Retrieval Security
For what it's worth, I second the notion of storing the files in a database. In addition to the sync problems you could have, with file systems, you can also easily transfer the DB to another server/platform, without having to also copy the files and update any file path pointers in the DB. M!ke -Original Message- From: Peter Legg [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 4:39 PM To: CF-Talk Subject: Re: Document Upload/Retrieval Security Ian, I hear you. YMMV - hadn't seen that one before. Thanks for your thoughts - I appreciate it. Peter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241987 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problems with LEN
Thanks for that, but I was saying that I would like to use a custom function the same way that we can use the built-in functions. In other words, using your example, if I could put the UnescapeFormValues function somewhere in the CF install directory, and then just call it from any application or page like cfset result = UnescapeFormValues(myForm). I know you can do this if you've got the function on your page, or if it's included somehow, but you can't just put it somewhere in ColdFusion's directories and call it anytime you need it. At least I don't think you can, but I'd be glad to find out I'm wrong. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 2:33 PM Jacob, Here is a version of this type of function: snip As you can see, it trims all values in the form, and replaces out certain values that I didn't want, like extended ascii values. -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 4:21 PM Is there someway to add a function to the CF system so that it is automatically available to all templates as the built in functions are? Is there a directory of functions or something similar to CF tags/custom tags? That would be very nice...I'm waiting to hear if anybody knows how to do this. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241988 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
more freeness
I actually forgot about this ria builder until I just got an email from them, can use cfm as the backend and now a free version. www.snappmx.com ~Dave the disruptor~ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241989 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: more freeness
I actually forgot about this ria builder until I just got an email from them, can use cfm as the backend and now a free version. www.snappmx.com ~Dave the disruptor~ We needta start callin you dave the distributor! lol The game! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241990 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Context Root and Web Root misbehaving (CFMX7)
I have configured a server for multiple JRun/ColdFusion MX 7 instances like the following: d:\servers\jrun01\cfusion-ear\cfusion-war d:\servers\jrun02\cfusion-ear\cfusion-war d:\servers\jrun03\cfusion-ear\cfusion-war Each JRun/ColdFusion instances is assigned to a dedicated website (using JRun4 Web Server JWS) like this: http://www.site1.com http://www.site2.com http://www.site3.com I have the context root for each JRun/ColdFusion-WAR instances configured in the respective application.xml files like the following: D:\servers\jrun01\cfusion-ear\META-INF\application.xml ?xml version=1.0 encoding=UTF-8? !DOCTYPE application PUBLIC -//Sun Microsystems, Inc.//DTD J2EE Application 1.2//EN http://java.sun.com/j2ee/dtds/application_1_2.dtd; application id=Application_ID display-nameMacromedia ColdFusion MX/display-name descriptionMacromedia ColdFusion MX/description module id=WebModule_1 web web-uricfusion-war/web-uri context-root//context-root /web /module /application So the context root for each JRun/Coldfusion server is the root of the JRun4 web server. I am using the JRun Web Server (JWS) that comes with JRun/ColdFusion. To configure virtual directories in the JWS, I edit the jrun-web.xml file located in each respective JRun/ColdFusion instances as follows: D:\servers\jrun01\cfusion-ear\cfusion-war\WEB-INF\jrun-web.xml virtual-mapping resource-path/*/resource-path system-pathd:/websites/site1/www/system-path /virtual-mapping When I restart the JRun/ColdFusion instance which uses JWS for the web server, I get the following error: - from the console: D:\servers\binc:\jrun4\bin\jrun -config d:\servers\bin\jvm_jrun01.config -start jrun01 Starting Macromedia JRun 4.0 (Build 92909), jrun01 server 05/17 17:57:07 info JRun Naming Service listening on *:2908 05/17 17:57:07 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 05/17 17:57:08 info JRunDataSource bound to JNDI under name esdevfarcry01 05/17 17:57:08 info JRun DataSourceService: Created JDBC XA Connection Pool named esdevfarcry01 05/17 17:57:08 info Bound a LinkRef from DefaultDataSource to the default DataSource esdevfarcry01 05/17 17:57:08 info JRun Web Server listening on *:8308 05/17 17:57:08 info Deploying enterprise application Macromedia ColdFusion MX from: file:/D:/servers/jrun01/cfusion-ea r/ 05/17 17:57:08 info Deploying web application Macromedia Coldfusion MX from: file:/D:/servers/jrun01/cfusion-ear/ 05/17 17:57:08 error Error loading class for Filter CFCacheFilter: Filter is disabled. java.lang.ClassNotFoundException: coldfusion.bootstrap.BootstrapFilter at jrunx.util.JRunURLClassLoader.findClass(JRunURLClassLoader.java:161) at java.lang.ClassLoader.loadClass(Unknown Source) at jrunx.util.JRunURLClassLoader.loadClass(JRunURLClassLoader.java:77) at jrunx.util.JRunURLClassLoader.loadClass(JRunURLClassLoader.java:69) at jrun.servlet.FilterManager.loadFilter(FilterManager.java:184) at jrun.servlet.FilterManager.init(FilterManager.java:155) at jrun.servlet.FilterManager.create(FilterManager.java:74) at jrun.servlet.WebApplicationService.start(WebApplicationService.java:223) at jrun.ea.EnterpriseApplication.start(EnterpriseApplication.java:194) at jrun.deployment.DeployerService.initModules(DeployerService.java:710) at jrun.deployment.DeployerService.createWatchedDeployment(DeployerService.java:242) at jrun.deployment.DeployerService.deploy(DeployerService.java:430) at jrun.deployment.DeployerService.checkWatchedDirectories(DeployerService.java:179) at jrun.deployment.DeployerService.run(DeployerService.java:891) at jrunx.scheduler.SchedulerService.invokeRunnable(SchedulerService.java:223) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) 05/17 17:57:08 user JSPServlet: init 05/17 17:57:09 info coldfusion.bootstrap.BootstrapServlet 05/17 17:57:09 error Could not pre-load servlet: CFMxmlServlet 05/17 17:57:09 info coldfusion.bootstrap.BootstrapServlet 05/17 17:57:09 error Could not pre-load servlet: ColdFusionStartUpServlet 05/17 17:57:09 info coldfusion.bootstrap.BootstrapServlet 05/17 17:57:09 error Could not pre-load servlet: CfmServlet 05/17 17:57:09 info coldfusion.bootstrap.BootstrapServlet 05/17 17:57:09 error Could not pre-load servlet: CFSwfServlet 05/17 17:57:09 info coldfusion.bootstrap.BootstrapServlet 05/17 17:57:09 error Could not pre-load servlet: CFCServlet 05/17 17:57:09 info coldfusion.bootstrap.BootstrapServlet 05/17 17:57:09 error Could not pre-load servlet: FlashGateway 05/17 17:57:09 info
Re: Context Root
Let me see if I understand this correctly. You get to your ColdFusion applications like this: http://www.site.com/cfusion/index.cfm Your images exist here: http://www.site.com/images/image.gif But when you go to here: http://www.site.com/cfusion/index.cfm The image http://www.site.com/images/image.gif does not show up in the index.cfm page. Is this correct? On 5/12/06, Botts, Tom [EMAIL PROTECTED] wrote: We are running ColdFusion under JRUN and this is working fine for 4 different IIS web sites. We have added another web site that is a content management system that is JAVA based. We created a JRUN instance for that application and deployed the war file and it is using a context root of /. We now have the need to run ColdFusion pages on that same web server. We deployed CF and have it setup under that same instance of JRUN and the context root is /cfusion. We used the web configuration tool and choose that IIS6 web server and choose the correct instance of JRUN and it will run CF pages fine but it does not serve the images. We can access the images via the url without the cfusion in the url without any problems. What could I have missed that is not allowing the images to be served? Thanks, ~~~ Tom Botts Programmer/Analyst Gilbarco Inc. 336-547-5911 phone 336-547-5163 fax [EMAIL PROTECTED] www.gilbarco.com file://www.gilbarco.com/ ~~~ This document contains confidential information of Gilbarco Inc. In consideration of the receipt of this document, the recipient agrees not to reproduce, copy, use or transmit this document and/or the information contained herein, in purpose except with written permission, first obtained, of GilbarcoInc. and further agrees to surrender the same to Gilbarco Inc. upon demand. This message (including any attachments) contains confidential and/or proprietary information intended only for the addressee. Any unauthorized disclosure, copying, distribution or reliance on the contents of this information is strictly prohibited and may constitute a violation of law. If you are not the intended recipient, please notify the sender immediately by responding to this e-mail, and delete the message from your system. If you have any questions about this e-mail please notify the sender immediately. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241992 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: more freeness
We needta start callin you dave the distributor! Hey now Will...I'm the one handing out Dave titles around here ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241993 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: more freeness
im alll about spreading the love.. ~Dave the disruptor~ From: Will Tomlinson [EMAIL PROTECTED] Sent: Thursday, June 01, 2006 7:06 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: more freeness I actually forgot about this ria builder until I just got an email from them, can use cfm as the backend and now a free version. www.snappmx.com ~Dave the disruptor~ We needta start callin you dave the distributor! lol The game! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241994 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: more freeness
Looks a lot like what Adobe's doing with Flex. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 4:23 PM I actually forgot about this ria builder until I just got an email from them, can use cfm as the backend and now a free version. www.snappmx.com This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241995 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Add Web Server Configuration Tool
In the Admin Server Configuration Tool there is a check box with the label Configure web server for ColdFusion MX applications What is this for? I understand the obvious, but does this having anything to do with how ColdFusion is installed (like stand-alone or multi-J2EE install)? Does this have any dependentcies to the J2EE context root? -- Thanks, Troy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Disappearing Single-Quote
Hi all, How do I keep CF from interpreting two single-quotes as escaped? I'm storing code snippets into a database and all occurences of '' are becoming ' (e.g., cfset value = '' becomes cfset value = '). For example: cfset Var = cfset value = '' cfquery name=Store_Var datasource=Test UPDATE Table SET Field = '#Var#' /cfquery When queried, the value of Field in Table is cfset value = ' Any advice is appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241997 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Disappearing Single-Quote
PreserveSingleQuotes() -- Jeff -Original Message- From: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 5:01 PM To: CF-Talk Subject: Disappearing Single-Quote Hi all, How do I keep CF from interpreting two single-quotes as escaped? I'm storing code snippets into a database and all occurences of '' are becoming ' (e.g., cfset value = '' becomes cfset value = '). For example: cfset Var = cfset value = '' cfquery name=Store_Var datasource=Test UPDATE Table SET Field = '#Var#' /cfquery When queried, the value of Field in Table is cfset value = ' Any advice is appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241998 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Disappearing Single-Quote
Nope. Already tried that. No change either way. PreserveSingleQuotes() -- Jeff -Original Message- From: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 5:01 PM To: CF-Talk Subject: Disappearing Single-Quote Hi all, How do I keep CF from interpreting two single-quotes as escaped? I'm storing code snippets into a database and all occurences of '' are becoming ' (e.g., cfset value = '' becomes cfset value = '). For example: cfset Var = cfset value = '' cfquery name=Store_Var datasource=Test UPDATE Table SET Field = '#Var#' /cfquery When queried, the value of Field in Table is cfset value = ' Any advice is appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Disappearing Single-Quote
Have you tried using the Chr() function and passing in the code for them? -Jeff David Delbridge wrote: Nope. Already tried that. No change either way. PreserveSingleQuotes() -- Jeff -Original Message- From: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 5:01 PM To: CF-Talk Subject: Disappearing Single-Quote Hi all, How do I keep CF from interpreting two single-quotes as escaped? I'm storing code snippets into a database and all occurences of '' are becoming ' (e.g., cfset value = '' becomes cfset value = '). For example: cfset Var = cfset value = '' cfquery name=Store_Var datasource=Test UPDATE Table SET Field = '#Var#' /cfquery When queried, the value of Field in Table is cfset value = ' Any advice is appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242000 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Intermittent Errors Strange
Hello List People, I'm having trouble figuring this one out and hope some one can point me in the right direction. We have a form processing script, that appears to generate some errors when under load - or rather when multiple forms are submitted within the same time frame. Basically we have a formHandler.cfm script that handles submission from multiple,different forms. The forms are processed based on description of the form looked up in the database (ie. fields, required, formatting etc). And the processing is done through a series of CFC's that are instantiated and stored in the application scope. Two problems occur. Occasionally, an error will be generated in the CFC that does the DB insert (insertFormSubmission.cfc), and the error indicates that the info about the form (that was retrieved when from the DB when the form was submitted via the formID in a hidden field), is for the wrong form! 99.5 times out of a 100 this does not happen, it can't be easily reproduced. But over the course of the day it will happen several times. I have gone through the CFC's and made sure all local vars are defined as local vars and that does not seem to have helped. Where is the collison occuring? The second error I get occasionally, and seems to be when under load, is regarding a UDF library (actually an individual function in that library) thats says it can't be defined twice. The UDF library is included from within a CFC in the application scope. Maybe thats bad practice? Too include a UDF lib in a CFC? The call to the include looks like this, with a test on the first method in the library to make sure it has not already been loaded: cfif not isdefined(LF_fieldType) cfinclude template=../blocks/udf/fieldtypelib.lf /cfif But it still occasionally generates this error: Routines cannot be declared more than once.. I know this is not the best way to include the UDF lib in each of my application scoped CFC's and I am looking at moving them to the request scope, its just alot of code to re-write and re-test. Why does it work 99% of the time and then fail with an error about the library already being loaded. The actual form submission process is identical. Is there some kind of overlapping threads happening here or something? Can anyone point me in the right direction? BrookD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242001 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Document Upload/Retrieval Security
We use Oracle for this kind of thing and it excels at indexing binary docs stored in BLOBS with full-text indexing, producing search context highlighted html versions of stored docs etc. It also means that we can keep multiple versions of docs as a revision history in the DB, without having a really messy metadata system to keep track of these versions on a filesystem. On 6/2/06, Dawson, Michael [EMAIL PROTECTED] wrote: For what it's worth, I second the notion of storing the files in a database. In addition to the sync problems you could have, with file systems, you can also easily transfer the DB to another server/platform, without having to also copy the files and update any file path pointers in the DB. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Add Web Server Configuration Tool
In the Admin Server Configuration Tool there is a check box with the label Configure web server for ColdFusion MX applications What is this for? I think it just ensures that the appropriate file extensions (.cfm, .cfc) are associated with CF. Keep in mind that the same tool is used for standard JRun installations, where you might not be using CF at all. I understand the obvious, but does this having anything to do with how ColdFusion is installed (like stand-alone or multi-J2EE install)? Not to my knowledge. Does this have any dependentcies to the J2EE context root? No, not to my knowledge. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54