Coldfusion 10: Scheduling Daily Task is Advanced?
Has anyone with a standard Coldfusion 10 installation been able to schedule a daily task? I have a standard license that was an upgrade from CF9. When I attempt to do so through the admin, I get the error below. Are daily scheduled tasks now advanced??? That seems wrong. Advance Scheduling support is not available in this edition of ColdFusion server. Thank you, Gabriel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 301 Redirects - showing as 302's
I am having the same issue, has anyone figured out a solution for this? I'm doing the following: cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=#SomeNewURL# It produces a 302 status code So I tried cfheader statuscode=301 statustext=Moved permanently#Chr(13)##Chr(10)#Location:#SomeNewURL# cfheader name=Location value=#SomeNewURL# Finally I tried cflocation url=#SomeNewURL# statuscode=301 addtoken=false ALL produced 302 status codes .. has anyone figured this out - did some searching without luck. Thanks in advance Paul Giesenhagen Quill Design http://www.quilldesign.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Converting regular date to a Spectra formatted database date?
Working with some legacy spectra data and I'm trying to do a sql search based on the spectra date. A. If I run the code below, I get 03/24/2011 08:58:48 AM cfset spectraData = 40626.374166700 cfdump var=#dateFormat(spectraData,MM/DD/)# cfdump var=#timeFormat(spectraData,HH:MM:SS TT)# B. How do I do this in reverse? In other words, how do I start with 03/24/2011 08:58:48 AM (or some form of it) and get 40626.374166700? Thank you, Gabriel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9.0.1 Updater - stuck updating stubs?
Hi, I'm running the CF9.0.1 updater and it seems to be taking a long time doing this: Installing... C:\Coldfusion9$$stubs Does anyone recall seeing this message for a long time? Does it eventually finish or is it stuck? Thank you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Anyone have experience with this CF9 hot fix?
I haven't seen many talking about this CF9 hotfix so I'm wondering if anyone has any experience with what it fixes? It seems like it's a particularly nasty bug that is fixed by it but the technotes are never that detailed so maybe others have thoughts or experiences they can share. http://kb2.adobe.com/cps/825/cpsid_82547.html Thank you, Gabriel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Regex Help - Can this be simplified?
You don't actually need a regex to put this into one easily read line:
replaceList(trim(finalDesription), 'br,p/p,p,/p', 'br /,br
/br /,br /br /,')
... Or some derivative there of.
Performance may differ slightly in favour of one way or another, but as much
as I love regexs and I use them frequently, they're rarely easy to descipher
at a glance.
Gabriel
-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com]
Sent: Friday, 14 August 2009 5:59 AM
To: cf-talk
Subject: Re: Regex Help - Can this be simplified?
You're better off using regex-replace(){rereplace()} over replace() for more
than one condition. The pipe is a way to cheat the replace function but for
future string searching or replacing functions, try regex and you can even
test it online here:
http://www.cftopper.com/contentfiles/tools/regularExpTester.cfm
There ya go. :) Just found out you can use the pipe | as well.
rereplace(string,(p)+(/p),br,all)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325447
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Detect data change in cfform
Nathan Wouldn't it make more sense to place a confirmation on the cancel button? Rather than checking all of the data against the original, then asking the user whether it was really what they wanted to do if it's different, then saving/discarding it based on their response? As an aside, if users are clicking cancel by mistake, you may also want to take a look at your UI - the controls should be clear enough that submit/cancel are distinct and difficult to confuse with one another. Gabriel. -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Saturday, 27 June 2009 5:28 AM To: cf-talk Subject: RE: Detect data change in cfform Maybe I wasn't clear. Sometimes users would make some changes and then click the cancel button by mistake and find out they lose the changes. I need a routine that detects if data have been altered. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, June 26, 2009 11:09 AM To: cf-talk Subject: Re: Detect data change in cfform I am building a form that allows users to edit data retrieved from multiple tables. There are many fields in the form. If the users don't change anything and hit the cancel button, then I don't need to do the update, otherwise several sql update statements will be executed. Is there an easy way to detect if users have made changes to the data in cfform rather than comparing each field to the original data? Not really, but why would your cancel button submit the form? Simply have it do something else, like redirect the user to the previous screen. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP inside a CFQuery
You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP inside a CFQuery
Ryan, You'll note that I said almost always and I never said never use it. There are times that I have had no choice but to use evaluate, but the scenarios involved were far more complex and generally involve dynamic cfc function calls. It's up to you whether you use it or not, but why make your (coding) life harder than it needs to be? I find the alternative far easier to write, read and maintain than the evaluate alternative. Cheers, Gabriel R -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 11:04 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery Interesting I've never seen any noticeable hit using evaluate but I have heard it should be avoided. (chose to ignore) I'll look into your suggestion though. I guess the question why even make evaluate available comes to mind if you should never use it? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOOP inside a CFQuery
Repost/Edit: apparently msoft forefront exchange server thinks I was being profane. You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOOP inside a CFQuery
Ryan, You can use #form['string'var]# anywhere, including form['string'var] = x. CfQueryParam is a separate issue relating purely to Will's SQL and it's vulnerability to SQL injection attack. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 11:11 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery @gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP inside a CFQuery
Will, Justin is right, just because your form is behind a username/password it by no means guarantees that the people accessing that form aren't malicious. As for whether there are scenarios where you shouldn't use queryparam? That's probably open for debate (it's certainly been debated before), however I've not come across a situation (except the caching issue as mentioned) where it's been of any benefit to NOT use queryparam. - Gabriel -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Wednesday, 10 June 2009 12:42 PM To: cf-talk Subject: RE: CFLOOP inside a CFQuery WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who is going to be hitting those queries. You never know when some nefarious person is going to break into an admin account and start probing around. Is there ever a reason not to use CFQUERYPARAM? Before ColdFusion 8 was released, you could not use CFQUERYPARAM in conjunction with a cached query. CF8 now allows that (yea!). -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How can I make this work with expandPath?
Rick,
#replace(stringVar, '\', '/', 'all')#
should give you the string as you need it, though I'd be more worried about
why the \'s are being deleted during whatever operation you're trying to
perform.
- Gabriel
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Wednesday, 10 June 2009 1:45 PM
To: cf-talk
Subject: How can I make this work with expandPath?
Hi, all...
I'm running a query that uses
load data infile
'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today#
/#name#'
The / have to be backwards to work in this case. If they are turned
around as \ in the path, they get deleted in the translation...haven't
figured that one out...
Anyway, I wanted to use:
load data infile
#expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#nam
e#')#
That works except for the fact that all the / get translated into \ by
expandPath and then are deleted from the resulting path, leaving it invalid.
How can I code this to make it work with expandPath?
Nothing I've tried causes a correct path to be translated by CF.
Thanks for any feedback...
Rick
*Ninety percent of the politicians give the other ten percent a bad
reputation.* Henry Kissinger
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323316
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I make this work with expandPath?
Rick,
Is it a mysql db? If so, see Barney's reply.
Cheers,
Gabriel
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Wednesday, 10 June 2009 2:34 PM
To: cf-talk
Subject: Re: How can I make this work with expandPath?
Thanks, Gabriel...I'll see if I can make that work.
To your question about why the \'s are being deleted...below the entire
query.
It's always run fine since I was using the hardcoded path. I have no idea
why the path would end up like dinetpubwebroot
eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1.
txt
Never seen that happen before...
cfquery name=load_data datasource=#application.dsn2#
load data infile
'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today#
/#name#'
cfif #name# contains ACR
*into* *table* smlc_acr_temp
cfelseif #name# contains COM
*into* *table* smlc_com_temp
cfelseif #name# contains LOT
*into* *table* smlc_lots_temp
cfelseif #name# contains MUL
*into* *table* smlc_mul_temp
cfelseif #name# contains OFF
*into* *table* smlc_off_temp
cfelseif #name# contains REN
*into* *table* smlc_ren_temp
cfelseif #name# contains RES
*into* *table* smlc_res_temp
/cfif
fields terminated *by* '|'
lines terminated *by* '\r\n'
/cfquery
On Wed, Jun 10, 2009 at 12:21 AM, Gabriel coldfus...@evolution7.com wrote:
Rick,
#replace(stringVar, '\', '/', 'all')#
should give you the string as you need it, though I'd be more worried
about why the \'s are being deleted during whatever operation you're
trying to perform.
- Gabriel
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Wednesday, 10 June 2009 1:45 PM
To: cf-talk
Subject: How can I make this work with expandPath?
Hi, all...
I'm running a query that uses
load data infile
'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#
today#
/#name#'
The / have to be backwards to work in this case. If they are turned
around as \ in the path, they get deleted in the
translation...haven't figured that one out...
Anyway, I wanted to use:
load data infile
#expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today
#/#nam
e#')#
That works except for the fact that all the / get translated into
\ by expandPath and then are deleted from the resulting path,
leaving it invalid.
How can I code this to make it work with expandPath?
Nothing I've tried causes a correct path to be translated by CF.
Thanks for any feedback...
Rick
--
--
*Ninety percent of the politicians give the other ten percent a bad
reputation.* Henry Kissinger
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323319
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I make this work with expandPath?
Rick,
As Barney says that mysql uses '\' as an escape char, you'd need to replace
'\' with '\\'.
Check the docs on the replace function, the syntax would be:
#replace(expandPath('\real_estate_data\smlc\daily_downloads\text_files\#toda
y#\#name#'),
\, \\, all)#
Replace(originalString, substringToReplace, stringReplacement, [scope])
- Gabriel
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Wednesday, 10 June 2009 2:41 PM
To: cf-talk
Subject: Re: How can I make this work with expandPath?
yes, mysql 5.1...
On Wed, Jun 10, 2009 at 12:37 AM, Gabriel coldfus...@evolution7.com wrote:
Rick,
Is it a mysql db? If so, see Barney's reply.
Cheers,
Gabriel
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Wednesday, 10 June 2009 2:34 PM
To: cf-talk
Subject: Re: How can I make this work with expandPath?
Thanks, Gabriel...I'll see if I can make that work.
To your question about why the \'s are being deleted...below the
entire query.
It's always run fine since I was using the hardcoded path. I have no
idea why the path would end up like dinetpubwebroot
eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1.
txt
Never seen that happen before...
cfquery name=load_data datasource=#application.dsn2#
load data infile
'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#
today#
/#name#'
cfif #name# contains ACR
*into* *table* smlc_acr_temp
cfelseif #name# contains COM
*into* *table* smlc_com_temp
cfelseif #name# contains LOT
*into* *table* smlc_lots_temp
cfelseif #name# contains MUL
*into* *table* smlc_mul_temp
cfelseif #name# contains OFF
*into* *table* smlc_off_temp
cfelseif #name# contains REN
*into* *table* smlc_ren_temp
cfelseif #name# contains RES
*into* *table* smlc_res_temp
/cfif
fields terminated *by* '|'
lines terminated *by* '\r\n'
/cfquery
On Wed, Jun 10, 2009 at 12:21 AM, Gabriel coldfus...@evolution7.com
wrote:
Rick,
#replace(stringVar, '\', '/', 'all')#
should give you the string as you need it, though I'd be more
worried about why the \'s are being deleted during whatever
operation you're trying to perform.
- Gabriel
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Wednesday, 10 June 2009 1:45 PM
To: cf-talk
Subject: How can I make this work with expandPath?
Hi, all...
I'm running a query that uses
load data infile
'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files
/#
today#
/#name#'
The / have to be backwards to work in this case. If they are
turned around as \ in the path, they get deleted in the
translation...haven't figured that one out...
Anyway, I wanted to use:
load data infile
#expandPath('/real_estate_data/smlc/daily_downloads/text_files/#tod
ay
#/#nam
e#')#
That works except for the fact that all the / get translated into
\ by expandPath and then are deleted from the resulting path,
leaving it invalid.
How can I code this to make it work with expandPath?
Nothing I've tried causes a correct path to be translated by CF.
Thanks for any feedback...
Rick
--
--
*Ninety percent of the politicians give the other ten percent a bad
reputation.* Henry Kissinger
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323322
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Online OO courses
Anyone aware of any GOOD online cf oo courses? Fiddling around with the various bits and pieces from 1001 blogs, guides and everything is great - but there isn't any way to find out if your end result is 'right' even if it works. Cheers is advance, Gabriel R ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Online OO courses
I'll start at the shallow end and get as deep as I can go. I THINK I have a reasonable handle on what's going on, but I'm not really content to sit on my laurels assuming that I'm doing the 'right' thing, would prefer to be put to the test as it were. -Original Message- From: Wil Genovese [mailto:jugg...@visi.com] Sent: Wednesday, 18 February 2009 9:09 AM To: cf-talk Subject: Re: Online OO courses How indepth are you looking to go? Lynda.com has some decent classes. $25/month to get access to ALL of their classes online. http://www.lynda.com/home/DisplayCourse.aspx?lpk2=432 Wil Genovese On Tue, Feb 17, 2009 at 3:22 PM, Gabriel Read g...@evolution7.com wrote: Anyone aware of any GOOD online cf oo courses? Fiddling around with the various bits and pieces from 1001 blogs, guides and everything is great - but there isn't any way to find out if your end result is 'right' even if it works. Cheers is advance, Gabriel R ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Online OO courses
Thanks for the links - I'll give Lynda a shot, look into the IBM one and just keep on the look out for additional resources/books. In the meantime, if anyone else has any thoughts... Thanks for the assistance. -Original Message- From: Brian Kotek [mailto:brian...@gmail.com] Sent: Wednesday, 18 February 2009 9:30 AM To: cf-talk Subject: Re: Online OO courses This might be an option, but when they won't tell you the pricing I tend to assume the worst, heh. http://www-01.ibm.com/software/in/rational/training/webbased_training/ooad.h tml On Tue, Feb 17, 2009 at 5:17 PM, Gabriel coldfus...@evolution7.com wrote: I'll start at the shallow end and get as deep as I can go. I THINK I have a reasonable handle on what's going on, but I'm not really content to sit on my laurels assuming that I'm doing the 'right' thing, would prefer to be put to the test as it were. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Online OO courses
I guess the reasons I am concered about the rightness of what I'm doing, is because there ARE wrong ways of doing things and I'd like to fall into bad practices, anaemic domain models for example. Making things easier for yourself is one thing, I see writing good, stable and scalable code as something else entirely? Understood regarding CF specific OO, even in the few hours since first post I've already figured that if I want more in depth knowledge I'm going to have to look more at the concept rather than specific application. --- Perhaps you shouldn't worry that much about rightness. OO, like any programming paradigm, is intended to make things easier for you. There isn't necessarily a single right way of solving many problems. Also, I wouldn't worry too much about looking for something that's CF-specific. The vast majority of good OO resources are not CF-specific - very often, they're not really specific to any language, although they may use Java or Python or C# or whatever to express concepts. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Online OO courses
I've yet to find a tutorial that will help you avoid poorly-designed models. Which is why I was after actual courses, with testing/marks/pass fail/etc rather than just tutorials. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Online OO courses
Aren't all Hal's courses real world? Bit of a trip from AU to the US for a OO course -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Wednesday, 18 February 2009 12:30 PM To: cf-talk Subject: Re: Online OO courses Which is why I was after actual courses, with testing/marks/pass fail/etc rather than just tutorials. Try Hal Helms classes then. Ben Nadel raved about his experience. http://www.halhelms.com/ On the other hand, the class I linked to before does just that except in Java. Same difference really. G! On Tue, Feb 17, 2009 at 8:13 PM, Gabriel coldfus...@evolution7.com wrote: I've yet to find a tutorial that will help you avoid poorly-designed models. Which is why I was after actual courses, with testing/marks/pass fail/etc rather than just tutorials. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... To Ben Forta
To anyone who happened to use the regex I posted earlier I have an updated
method to be used in place, effective immediately.
// Short list of db objects to protect
DBObj.short = 'database|function|procedure|role|table|trigger|user|view';
// Sql Threat Indicators
blackList = '@@|'
'(?:alter.*?(#DBObj.short#))|'
'cast.*?\(|'
'char.*?\([\w]{2}\)|'
'(?:create.*?(#DBObj.short#))|'
'(?:declare.*?@|cursor)|'
'delete.*?from.*?_|'
'(?:drop.*?(#DBObj.short#))|'
'exec.*?\(|'
'insert.*?values.*?\(+?|'
'schema[^\w]+?|'
'sysObjects|'
'truncate.*?table|'
'update.*?set+?|'
'[sx]p_[\w_]+?|'
'\''.*?-{2}|-{2}.*?\'''
'/\*.*?\*/';
// Build the java pattern matcher
rePattern = createObject('java', 'java.util.regex.Pattern');
rePattern = rePattern.compile(blackList);
reMatcher = rePattern.matcher('');
Then use reMatcher.reset(lcase(var_to_scan)).find() to scan the var.
This will fix a problem in which a long string containing too many back
references for non-word chars can cause a stack overflow. As much as I love
CF, I find the native regex implementation sadly lacking.
My apologies to anyone already using it, I guess this is what I get being
drawn into posting code I hadn't had a chance to fully test. If anyone has
problems with, or enhancements to the above, please let me know.
Also, thank you to Mary Jo for adding me to the credits. My surname is Read
FYI in case you still desire to include me.
Regards,
Gabriel Read
-Original Message-
From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
Sent: Saturday, 26 July 2008 5:40 AM
To: CF-Talk
Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... To Ben
Forta
What do you think about this solution for sites with 5000 files:
This looks similar to the solution I am providing to my customers (I have a
lot that run old releases that are not as well protected as my current one
and have little desire to either update their software *or* the code). I
used the RedEx that Gabriel posted (sorry, don't know your last name as I
read this list online, let me know and I'll add that to the credits!) and
made a URL/Form scanner that will abort the page if it finds anything
illegal. This looks quite a bit more sophisticated, so it depends on how
much you are getting hit, and how aggressive you want to get.
My simple tool is here, feel free to download and modify as you wish.
http://www.cfwebstore.com/index.cfm?fuseaction=page.downloaddownloadID=17
--- Mary Jo
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309775
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
With this latest spate of SQL attacks it has at least alerted CF (and non CF
coders hopefully) to the importance of sql injection and input sanitisation.
However I am noticing that almost all of the drop-in 'patches', almost all
of them seem to be straight list/array searches and there is almost no use
of regular expressions, meaning that these 'solutions' can barely even be
considered as suitable stop gaps until more appropriate measures can be
taken (cfqueryparam, sql permissions, etcetera) as they really can only stop
the most basic attempts and are likely to produce an inordinate number of
false positives (someone earlier noted that an admin was blacklisted for
using declare in a perfectly acceptable context).
It seems to me that such a knee jerk reaction and placing half thought out
measures in place almost does more harm than good in that it leaves people
with a false sense of security. Take the following code as case in point;
function IsSQLInject(input) {
var listSQLInject =
cast,exec,execute,sp_executeSQL,revoke,grant,select,insert,update,delete,dr
op,--,';
var arraySQLInject = ListToArray(listSQLInject);
var i = 1;
for(i=1; i lte arrayLen(arraySQLInject); i=i+1) {
if(findNoCase(arraySQLInject[i], input)) return true;
}
return false;
}
Running this function over any user input scope will flag every input that
contains one of the listed strings, i.e. 'Casting sugar', 'selectable
criteria', 'Name: Grant Thompson', so on and so forth...
But at least you're secure, right?
Dr/*foo*/op table orders;
The simplest obfuscation of the command using basic tools and the function
is rendered useless.
Conclusion? You're stopping legitimate use and still leaving a wide open
door to any hacker willing to put in 30 seconds effort. How long until
someone rewrites the current attack pattern and uses the above method to
bypass all of the shiny new keyword scanners? Dec/*can't see me*/lare @s =
That's all without even touching upon encoding.
I'm not claiming to have the ideal patch, I'm not even claiming to have been
the first to notice these things - posts are on many CF blogs detailing
these issues in a far more articulate manner, but I think that advocating
simple keyword scanners in this list is irresponsible, bad advice can be
worse than no advice at all. All 'senior' CF programmers either do, or
should know better.
Please note that I mean no offence to anyone on this list (or anywhere else
for that matter).
Regards,
Gabriel
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309560
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Mark,
The comment block obfuscation technique has been posted on blog articles
that I have read through the years, however
http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/ seems to be the
only one that I can pull up after a 30 second search. Needless to say I am
almost certain that I have seen working examples in the past, which has led
me to attempt to scan for them.
// Seperator chars
CS = '.|[^[:alnum:]]';
// Short list of db objects to protect
DBObj.short = 'database|function|procedure|role|table|trigger|user|view';
// Build the regex
blackList = '@@|'
'alter(#CS#)*?(#DBObj.short#)|'
'cast(#CS#)*?\(|'
'char(#CS#)*?\([[:alnum:]]{2}\)|'
'create(#CS#)*?(#DBObj.short#)|'
'declare(#CS#)*?(@|cursor)|'
'delete(#CS#)*?from(#CS#)*?_|'
'drop(#CS#)*?(#DBObj.short#)|'
'exec(#CS#)*?\(|'
'insert(#CS#)*?values(#CS#)*?\(+?|'
'sysObjects|'
'truncate(#CS#)*?table|'
'update(#CS#)*?set(#CS#)+?|'
'(s|x)p_[[:alnum:]_]+?|'
'(\''(#CS#)*?(--)+?)|'
'((--)+?(#CS#)*?\'')|'
'/\*(#CS#)*?\*/';
An incomplete, but reasonable regex that allows individual keywords to pass
assuming that there are no other characters|keywords which would indicate a
possible threat in the parsed string, also includes a scan for block quotes
(even if only for my own piece of mind - white space obfuscation and word
split). I would do better, however I am not generally granted free licence
to spend time posting to discussion lists while I am supposed to be working
- else I would have written/posted actual code earlier.
What was the point of my original post then?
To illustrate that the list/array check is not a good enough solution, even
as a stop gap and to get people to perhaps look at doing a little more
research on their 'patch' before they go away and dedicate the requisite
hours to find and repair all missing queryparams etc, leaving their sites
still vulnerable. Sites are still being hit - is it better to wait 12 hours+
to make the point, or get the idea into someone's head now?
Just a note: I don't think a single post qualifies as 'peppering', nor do I
believe that pointing out legitimate flaws qualifies as pedantic.
G
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309564
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sorting International Names Challenge!
Claude, I'd also be very interested in your ISO-8859-1 function. Internationalized applications are becoming far more prominent these days... Thanks, Gabriel -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, 11 July 2008 3:18 AM To: CF-Talk Subject: Re: Sorting International Names Challenge! I have not had a chance to work with international characters in the DB, so this sounds really interesting. I'm sending it by private eMail, I'm affraid that posting it here will make the message too large. It works works for strings in ISO, and may be used for databases in ISO, not UTF-8 -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating replicated sites with coldfusion
Hello everyone I have a bit of code and I am a little confused as to why, when i change the format attribute to =flash, the whole thing goes crazy. All the values in my text field are identical to the first row returned by the query. However, HTML format works quite well with expected output. Any input would be great. Code is bellow. I am working off Windows XP. CF8 Dev edition. cfoutput cfloop query=getLabels cfform format=html id=mod#theID# action=index.cfm?view=labels#session.URLToken# method=post skin=haloSilver width=310 cfformgroup type=horizontal cfinput type=hidden name=ID value=#theID# cfformitem width=25 type=html#theLabelID#/cfformitem cfinput width=170 type=text value=#theContent# name=label cfinput width=75 type=submit value=Update name=submit /cfformgroup /cfform /cfloop /CFOUTPUT ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFFORM Flash VS Html
On 10/16/07, Gabriel Robichaud [EMAIL PROTECTED] wrote: Hello everyone I have a bit of code and I am a little confused as to why, when i change the format attribute to =flash, the whole thing goes crazy. All the values in my text field are identical to the first row returned by the query. However, HTML format works quite well with expected output. Any input would be great. Code is bellow. I am working off Windows XP. CF8 Dev edition. cfoutput cfloop query=getLabels cfform format=html id=mod#theID# action=index.cfm?view=labels#session.URLToken# method=post skin=haloSilver width=310 cfformgroup type=horizontal cfinput type=hidden name=ID value=#theID# cfformitem width=25 type=html#theLabelID#/cfformitem cfinput width=170 type=text value=#theContent# name=label cfinput width=75 type=submit value=Update name=submit /cfformgroup /cfform /cfloop /CFOUTPUT ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: JVM memory settings
Anyone know if adobe has plans for JRUN and 64 bit. Info im seeing says right now its a no joy. So you would have to goto enterprise, and then use something like tomcat. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 4:43 AM To: CF-Talk Subject: Re: JVM memory settings As Snake says, using a 64bit OS will do away with this particular issue. If you are using Enterprise, then you also have the option of multiple instances, each of which can have it's own memory allocation so as to make better usage of your 4GB. On 12/09/06, Snake [EMAIL PROTECTED] wrote: If you want to use large amounts of RAM, then you need to be running a 64bit operating system. -Original Message- From: Charles Sheehan-Miles [mailto:[EMAIL PROTECTED] Sent: 12 September 2006 01:01 To: CF-Talk Subject: JVM memory settings All, Occasionally, when I have very heavy usage on my server, I get jrun memory errors and then the whole thing crashes. So, since my box has 4 gb ram, most of which is unused, I went to set the jvm memory settings in ColdFusion administrator to a higher value. Problem is, CF won¹t start if I set it over 1 Gb. This is 7.02. Any ideas? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute problem...
Of course if I stop the CF service I can delete the files mannually. Ok if I run mannually oracle) don't release the file handler. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute problem...
Ok if I run mannually What happens if you run this same command from the command line manually, outside of CF, does anything weird happen? .. Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Some people call me the space cowboy. Some people call me the gangster of love. -Original Message- From: Gabriel Bulfon [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 3:03 PM To: CF-Talk Subject: Re: cfexecute problem... I don't know why, but the cfexecute or a command that i run (exp, from oracle) don't release the file handler. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute problem...
Hi, i am trying to generate dos command to export a oracle database...the commnad was fine, but i have a problem with a process. When execute the cfexecute all works fine but i can delete de files. If I see the task manager I see a System Iddle Process hang. I appreciate any help. -gabriel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250743 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute problem...
I don't know why, but the cfexecute or a command that i run (exp, from oracle) don't release the file handler. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF IMail Server interaction
Hi, i am read the post at http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:38056 and I have the same problem right now. I use cfmail specifying server params. I try with telnet to my email server and nothing. I try to send an email to a server list account... I specified the failto params but nothing. I see the mail.log and is empty. I appreciate any help. -gabriel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF IMail Server interaction
There is not a connection problem. I test Connection Verification option suscesfully. The telnet to port 25 works fine too. First you need to see Connection Verification Successful. by activating Verify mail server connection in CF admin mail settings. If something wrong you get a msg like Connection Verification Failed! Is that level already ok? If not, there would be a connection issue because of a firewall etc. Oðuz Demirkapý -Original Message- From: Gabriel Bulfon [mailto:[EMAIL PROTECTED] Sent: Freitag, 18. August 2006 22:42 To: CF-Talk Subject: CF IMail Server interaction Hi, i am read the post at http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:38056 and I have the same problem right now. I use cfmail specifying server params. I try with telnet to my email server and nothing. I try to send an email to a server list account... I specified the failto params but nothing. I see the mail.log and is empty. I appreciate any help. -gabriel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
send console command from a custom tags
Hi, I am looking for a solution to send DOS (console) command directly from coldfusion tags. I appreciate any help. -gabriel ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248338 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Gzip content from a variable
Thanks dan this is just what I was looking for! gabe -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 10:41 AM To: CF-Talk Subject: RE: Gzip content from a variable Gabe, I have been using cf_gzip for a while but would like to improve performance. Right now it reads a file, then writes a gzip'd file. Then I have to read that file and dish back to user. I would like to just pass in the content as a variable, then get back a variable with the gzip'd data. Ignore all the file business. Anyone know of anything pre built or up for a challenge? I worked up a solution a few months ago: http://blog.pengoworks.com/blogger/index.cfm?action=blog:501 I was working on a Windows app where we were sending large XML packets to the server and decided we'd GZip the XML before sending. The UDF in my blog entry should take a GZipped string and unzip back to a string. I did not test this w/any binary data--only w/XML files. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238279 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
Gzip content from a variable
Hey all, I have been using cf_gzip for a while but would like to improve performance. Right now it reads a file, then writes a gzip'd file. Then I have to read that file and dish back to user. I would like to just pass in the content as a variable, then get back a variable with the gzip'd data. Ignore all the file business. Anyone know of anything pre built or up for a challenge? gabe ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238072 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
Cfform not updating all data
Anyone had an issue on 7.1 where cfform passes the data properly but the update grid tag wont update all the fields you edited? In fact it appears to update only 1 row and only a couple of the fields actually passed. I checked the data coming across and the structure contains all the updates. Thanks gabe ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237164 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: Monitoring JRun Memory Usage
cfset runtime = CreateObject(java,java.lang.Runtime).getRuntime() cfset freeMemory = runtime.freeMemory() / 1024 / 1024 cfset totalMemory = runtime.totalMemory() / 1024 / 1024 cfset maxMemory = runtime.maxMemory() / 1024 / 1024 cfoutput Free Allocated Memory: #Round(freeMemory)#mbbr Total Memory Allocated: #Round(totalMemory)#mbbr Max Memory Available to JVM: #Round(maxMemory)#mbbr /cfoutput From these numbers we can also determine the percent of free allocated memory available, and also the percent of avalaible memory allocated cfset percentFreeAllocated = Round((freeMemory / totalMemory) * 100) cfset percentAllocated = Round((totalMemory / maxMemory ) * 100) cfoutput % of Free Allocated Memory: #percentFreeAllocated#%br % of Available Memory Allocated: #percentAllocated#%br /cfoutput -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 12:01 PM To: CF-Talk Subject: Re: Monitoring JRun Memory Usage I'm sure if you look through the java docs there will be something in there to get the memory size. Though size of memory doesn't necesarily mean bad server. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230142 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: Fedex Shipping in realtime ( XML over https)
Could you please send me an example with fake values. I am still having trouble. Apprecciate it. gabriel Hua Wei [EMAIL PROTECTED] wrote: Gabriel, I implemented a few with no problem. Fedex service requires a few http header settings for the request: requestheader = structnew(); requestheader[Referer] = your company name; requestheader[Host] = Fedex gateway Host; requestheader[Accept] = image/gif, image/jpeg,image/pjpeg, text/plain, text/html, */*; requestheader[Content-Type] = image/gif; requestheader[Content-Length] = len(trim(tostring(requestXML))); Hua -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 27, 2005 9:50 AM To: CF-Talk Subject: Fedex Shipping in realtime ( XML over https) I am having trouble using fedex xml over http to connect to their API. Anybody had any luck? The code I am using is the following: xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=FDXSubscriptionRequest.xsd String 555 Gabriel transex Shipping 555 [EMAIL PROTECTED] 123 candle Houston TX 77754 US #CFHTTP.FileContent# xsi:noNamespaceSchemaLocation=FDXSubscriptionReply.xsd String 1234567 FedEx Express Shipping I am also having problems understanding how to get the XML response back from the fedex server. Thanks Gabriel [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228393 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
Expert at debugging stack traces?
Then you're my guy. Need to hire some to help me track down a hanging condition on cfmx 7.0 on win 2.3k. I have tried everything I can think of. I have installed fusion reactor and have some excellent sample stack traces but I'm just not that good with diagnosing it from this. If your interested just Email me at: [EMAIL PROTECTED] gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227716 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
Not enough storage is available to process this command
Hey all, anyone ever encounter this error? Basically box has tons of drive space, loads of ram, jrun was using 700 megs and heap is set to 1 gig. At some point it failed bad enough that it wouldn't event error catch and I just got a 500 server error Not enough storage is available to process this command. This is brand new hardware with 7.01 and win 2.3k Not enough storage is available to process this command The error occurred in: D:\www\com\ufc\product\product.cfc Thoughts? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227309 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
Mx 7.1 unable to stop stuck threads
I posted last week about a dieing mx server. After installing seefusion it appears at some point all the available threads stick. They just sit there for 15 minutes unable to complete. It appears that mx never completes the threads. Here is what vex's me beyond the fact I cannot figure why the heck they all stick all of a sudden. 1. I have mx set to kill anything over 15 seconds. 2. using seeFusion it has a kill thread command (Java's Thread.stop()) These threads won't respond to either of these, mx cannot time them out, and thread.stop() seems to have no effect. Anyone encounter this? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225902 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
Cfmx 7.1 on 2.3k locking up once a day
We just rolled out mx 7.1 on win 2.3k, Fusebox 4.1. It's a simple application, just content management with 150-200k views a day. Without fail that mx server hangs in under 24 hours. Here is the evidence we have found. I started app. Server at the command line: When I peep'd in while it was hung it was dumping out the following: java.lang.RuntimeException: Request timed out waiting for an available thread to run. You may want to consider increasing the number of active threads in the thread pool. This is repeated, again and again. NOTE: found some articles suggesting ideas on this, turn of debug (done), make sure db is responding (appears to be). Adjust some of the jrun.xml settings (appears to already be done in 7.1) Perf Mon. went back to before the crash, the only thing odd is the data seems to miss a beat nearing the crash and some data seems off the chart. But when we examine logs we see no burst of traffic. I exported the perf. Mon data and don't see any bursts. Did a stack dump while it was hung found a ton of these: jrpp-108 prio=5 tid=0x04430d60 nid=0x1b08 in Object.wait() [c4af000..c4afdb8] at java.lang.Object.wait(Native Method) - waiting on 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$Throttle.enter(ThreadPool.java:107) - locked 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:423 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Whole log: http://icc.getfused.com/out.txt We have tried moving app. To a 2nd 7.1 and win 2.3k server.. Same issue. We moved the db to another machine, same issue. No other sites using the db seem to be having any issues. Anyone have any thoughts? Im about to toss in the towel and call adobe and burn 500.00 clams. Any help would be apprecaited, if it saves me the 500.00 then a shopping spree at Amazon could be in your future. Thanks gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225477 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: Cfmx 7.1 on 2.3k locking up once a day
Thanks for the ideas rob couple thoughts on them, 1. Haven't tried seefusion, I will install and see what I can see. 2. queries are all short, we have 3 other cf server running db sites off the same db server so I don't think that's it 3. Max requests are set to 6, which is about standard for twin cpu, I could bump it for a test. 4. Long running pages, yes, but with fusebox it just tells you hey index.cfm took X seconds.. But I have it on anyway and no sign of long running pages except when fusebox reloads. -Original Message- From: Robert Munn [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 7:34 PM To: CF-Talk Subject: Re: Cfmx 7.1 on 2.3k locking up once a day could be lots of things. have you tried running seefusion to get more info on the application server? have you checked your database to see if there are long-running queries? i had a client that kept killing their site, and it turned out that the whole problem was a mis-behaving query that would take down the sql server and force timeouts on the cf server. have you tried increasing your max request count in cf admin? try that. start logging long-running requests if you are not yet, and see what comes back. you might have a runaway page somewhere. We just rolled out mx 7.1 on win 2.3k, Fusebox 4.1. It's a simple application, just content management with 150-200k views a day. Without fail that mx server hangs in under 24 hours. Here is the evidence we have found. I started app. Server at the command line: When I peep'd in while it was hung it was dumping out the following: java.lang.RuntimeException: Request timed out waiting for an available thread to run. You may want to consider increasing the number of active threads in the thread pool. This is repeated, again and again. NOTE: found some articles suggesting ideas on this, turn of debug (done), make sure db is responding (appears to be). Adjust some of the jrun.xml settings (appears to already be done in 7.1) Perf Mon. went back to before the crash, the only thing odd is the data seems to miss a beat nearing the crash and some data seems off the chart. But when we examine logs we see no burst of traffic. I exported the perf. Mon data and don't see any bursts. Did a stack dump while it was hung found a ton of these: jrpp-108 prio=5 tid=0x04430d60 nid=0x1b08 in Object.wait() [c4af000..c4afdb8] at java.lang.Object.wait(Native Method) - waiting on 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$Throttle.enter(ThreadPool.java:107) - locked 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.jav a:423 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.ja va:26 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Whole log: http://icc.getfused.com/out.txt We have tried moving app. To a 2nd 7.1 and win 2.3k server.. Same issue. We moved the db to another machine, same issue. No other sites using the db seem to be having any issues. Anyone have any thoughts? Im about to toss in the towel and call adobe and burn 500.00 clams. Any help would be apprecaited, if it saves me the 500.00 then a shopping spree at Amazon could be in your future. Thanks gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225482 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: Cfmx 7.1 on 2.3k locking up once a day
Min memory is set to 500, max to 1000, system seems to idle around 400 megs, up and down a little but perf. Mon shows no memory usages spikes. Client vars are disabled. Though sessions are turned on in the index.cfm file, very little use for them except for the content administrator login. Thought each page request does set three session vars by default. We have no checkout, or anything that is complex in session scope. gabe -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 8:52 PM To: CF-Talk Subject: Re: Cfmx 7.1 on 2.3k locking up once a day What's your memory like on the machine? What's the JVM set as? Are you using lots of session or client vars? We just rolled out mx 7.1 on win 2.3k, Fusebox 4.1. It's a simple application, just content management with 150-200k views a day. Without fail that mx server hangs in under 24 hours. Here is the evidence we have found. I started app. Server at the command line: When I peep'd in while it was hung it was dumping out the following: java.lang.RuntimeException: Request timed out waiting for an available thread to run. You may want to consider increasing the number of active threads in the thread pool. This is repeated, again and again. NOTE: found some articles suggesting ideas on this, turn of debug (done), make sure db is responding (appears to be). Adjust some of the jrun.xml settings (appears to already be done in 7.1) Perf Mon. went back to before the crash, the only thing odd is the data seems to miss a beat nearing the crash and some data seems off the chart. But when we examine logs we see no burst of traffic. I exported the perf. Mon data and don't see any bursts. Did a stack dump while it was hung found a ton of these: jrpp-108 prio=5 tid=0x04430d60 nid=0x1b08 in Object.wait() [c4af000..c4afdb8] at java.lang.Object.wait(Native Method) - waiting on 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$Throttle.enter(ThreadPool.java:107) - locked 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:423 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Whole log: http://icc.getfused.com/out.txt We have tried moving app. To a 2nd 7.1 and win 2.3k server.. Same issue. We moved the db to another machine, same issue. No other sites using the db seem to be having any issues. Anyone have any thoughts? Im about to toss in the towel and call adobe and burn 500.00 clams. Any help would be apprecaited, if it saves me the 500.00 then a shopping spree at Amazon could be in your future. Thanks gabe ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225486 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: Cfmx 7.1 on 2.3k locking up once a day
Yes on min and maxheap sizes. I have never seen the heap over 500megs. The trace logs show very steady memory levels. gabe -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 9:10 PM To: CF-Talk Subject: Re: Cfmx 7.1 on 2.3k locking up once a day min as in minheap and max as in maxheap? Does the jrun.exe current or virtual memory size ever exceed 1000? Min memory is set to 500, max to 1000, system seems to idle around 400 megs, up and down a little but perf. Mon shows no memory usages spikes. Client vars are disabled. Though sessions are turned on in the index.cfm file, very little use for them except for the content administrator login. Thought each page request does set three session vars by default. We have no checkout, or anything that is complex in session scope. gabe -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 8:52 PM To: CF-Talk Subject: Re: Cfmx 7.1 on 2.3k locking up once a day What's your memory like on the machine? What's the JVM set as? Are you using lots of session or client vars? We just rolled out mx 7.1 on win 2.3k, Fusebox 4.1. It's a simple application, just content management with 150-200k views a day. Without fail that mx server hangs in under 24 hours. Here is the evidence we have found. I started app. Server at the command line: When I peep'd in while it was hung it was dumping out the following: java.lang.RuntimeException: Request timed out waiting for an available thread to run. You may want to consider increasing the number of active threads in the thread pool. This is repeated, again and again. NOTE: found some articles suggesting ideas on this, turn of debug (done), make sure db is responding (appears to be). Adjust some of the jrun.xml settings (appears to already be done in 7.1) Perf Mon. went back to before the crash, the only thing odd is the data seems to miss a beat nearing the crash and some data seems off the chart. But when we examine logs we see no burst of traffic. I exported the perf. Mon data and don't see any bursts. Did a stack dump while it was hung found a ton of these: jrpp-108 prio=5 tid=0x04430d60 nid=0x1b08 in Object.wait() [c4af000..c4afdb8] at java.lang.Object.wait(Native Method) - waiting on 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$Throttle.enter(ThreadPool.java:107) - locked 0x172c0fa8 (a jrunx.scheduler.ThreadPool$Throttle) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:423 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Whole log: http://icc.getfused.com/out.txt We have tried moving app. To a 2nd 7.1 and win 2.3k server.. Same issue. We moved the db to another machine, same issue. No other sites using the db seem to be having any issues. Anyone have any thoughts? Im about to toss in the towel and call adobe and burn 500.00 clams. Any help would be apprecaited, if it saves me the 500.00 then a shopping spree at Amazon could be in your future. Thanks gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225492 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: JRun Deadlock - Big Problem / Bug
Neil, We have been experiencing something like this. Server becomes non-responsive for html and cf pages. Do you have any way to confirm that a server is experiencing this issue? gabe -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 5:03 PM To: CF-Talk Subject: JRun Deadlock - Big Problem / Bug OK, After months of reviewing - we have confirmed (with the help of Microsoft) that there is a problem with the JRun connector when in use with IIS. It would seem that in some cases under high load IIS will hang and it is down to JRun...hopefully someone from Macromedia can comment; it definitely looks like a bug (in fact it could be related to the ColdFusion 6.1 updater or indeed a known issue in relation to Bug 56991 in which MM state Improved deadlock avoidance when the same client variables are accessed by simultaneous pages, for example, when frames are used *** Note the use of improved and not resolved - it would seem its problem which there is no technote for). Not a good position to be in, I would post more detailed information and the crash logs but I cannot post long posts :-( Anyone else getting what seem like IIS hangs? N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224311 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: what do you use instead of cfx_openimage?
We are using imagecr3, very good, very stable. gabe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 10:55 AM To: CF-Talk Subject: Re: what do you use instead of cfx_openimage? Many people use our tag, cfx_imagecr3. Some hosts install it on all their servers. Efflare ImageCR 3 http://efflare.com/products/cfx_imagecr $75 personal license http://efflare.com/purchase?personal -- CrystalM is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223210 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
Xmlformat() ... well not formatting
Hey all, Im running into an issue with xml based service. Im sending the following out the door: SHIPTOCOMPANYCompañia de Seguros/SHIPTOCOMPANY The ñ is causing the receiving application to choke when it tries transform this into an xml object (asp page). I am running xmlformat on all the fields. The documentation tells me that xmlformat should replace this value ASCII 241 with its escape. But no joy. Documentation shows that it should escape ASCII stuff above 127 the XmlFormat function also escapes hi-ASCII characters (127 - 256). Anyone have this issue and figure something out? gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223001 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: Xmlformat() ... well not formatting
Yup, your right, it is, blast. Any ideas if something pre-built(function) that might be of use here? Thanks gabe -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 8:26 AM To: CF-Talk Subject: Re: Xmlformat() ... well not formatting On Thursday 03 November 2005 13:23, gabriel l smallman wrote: fields. The documentation tells me that xmlformat should replace this value ASCII 241 with its escape. But no joy. Documentation shows that it should Are you sure it isn't a unicode character ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223004 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: Xmlformat() ... well not formatting
Plot thickens, so I cdata the element and hit service with IE: An invalid character was found in text content. Error processing resource 'http://icc.getfused.com:8700/proshopwebservices/... BILLTOCOMPANYCompa Here is odd thing, I view source: SHIPTOCOMPANY![CDATA[Compa#xf1;ia de Seguros]]/SHIPTOCOMPANY Looks to me like it escaped it, but yet it still throws the error when IE tries to view the xml. Im guessing if IE tosses the error then the xml transform on the asp page will prob. Choke as well. gabe -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 8:30 AM To: CF-Talk Subject: RE: Xmlformat() ... well not formatting Have you tried... SHIPTOCOMPANY![CDATA[Compañia de Seguros]]/SHIPTOCOMPANY ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 8:24 AM To: CF-Talk Subject: Xmlformat() ... well not formatting Hey all, Im running into an issue with xml based service. Im sending the following out the door: SHIPTOCOMPANYCompañia de Seguros/SHIPTOCOMPANY The ñ is causing the receiving application to choke when it tries transform this into an xml object (asp page). I am running xmlformat on all the fields. The documentation tells me that xmlformat should replace this value ASCII 241 with its escape. But no joy. Documentation shows that it should escape ASCII stuff above 127 the XmlFormat function also escapes hi-ASCII characters (127 - 256). Anyone have this issue and figure something out? gabe ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223006 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: Xmlformat() ... well not formatting
Paul, when you mean getting it straight, what are you referring to exactly? Many thanks gabe -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:05 AM To: CF-Talk Subject: Re: Xmlformat() ... well not formatting Saturday (Stuart Kidd) wrote: It's really annoying as I can never be 100% sure the feed will always be error free as I don't control what club owners put into their details. you might just try getting the encoding straight. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223015 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: Xmlformat() ... well not formatting
No its attack of the nincompoops. I had another line that displays same data but wasen't cnamed. IE will now render the xml. I will test with the asp parser and post results. thanks -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:12 AM To: CF-Talk Subject: RE: Xmlformat() ... well not formatting Could it be the hash sign that's causing the error? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 7:52 AM To: CF-Talk Subject: RE: Xmlformat() ... well not formatting Plot thickens, so I cdata the element and hit service with IE: An invalid character was found in text content. Error processing resource 'http://icc.getfused.com:8700/proshopwebservices/... BILLTOCOMPANYCompa Here is odd thing, I view source: SHIPTOCOMPANY![CDATA[Compa#xf1;ia de Seguros]]/SHIPTOCOMPANY Looks to me like it escaped it, but yet it still throws the error when IE tries to view the xml. Im guessing if IE tosses the error then the xml transform on the asp page will prob. Choke as well. gabe -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 8:30 AM To: CF-Talk Subject: RE: Xmlformat() ... well not formatting Have you tried... SHIPTOCOMPANY![CDATA[Compañia de Seguros]]/SHIPTOCOMPANY .:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 8:24 AM To: CF-Talk Subject: Xmlformat() ... well not formatting Hey all, Im running into an issue with xml based service. Im sending the following out the door: SHIPTOCOMPANYCompañia de Seguros/SHIPTOCOMPANY The ñ is causing the receiving application to choke when it tries transform this into an xml object (asp page). I am running xmlformat on all the fields. The documentation tells me that xmlformat should replace this value ASCII 241 with its escape. But no joy. Documentation shows that it should escape ASCII stuff above 127 the XmlFormat function also escapes hi-ASCII characters (127 - 256). Anyone have this issue and figure something out? gabe ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223017 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: Xml parsing xmlns issue
Right you are, no idea what that uri is for, the language on the page is a little vague. You don't have any clever ideas how to access the variables contained in stuff like products:price? Seems to produce a structure but the refference to where the data is contained would be: rss.channel.item.products:show_name Which of course you cannot access directly, anyone have a simple method of getting the xml value of products.show_name? gabe -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 06, 2005 4:05 AM To: CF-Talk Subject: Re: Xml parsing xmlns issue Im not the familiar with namespace usage in xml. When trying to us mx 7 to parse this im getting this message: The prefix xmlns cannot be bound to any namespace explicitly; neither can the namespace for xmlns be bound to any prefix explicitly. Not sure what these means in plain English. Should the xmlna point to a dtd that defines the elements products ? Any help would be great, As far as I remember, the http://www.w3.org/2000/xmlns/ uri as a very special meaning (visit that url to learn more). So you can't use it. If you change the uri to something else (like http://www.myself.org/2000/xmlns/) it works. Hope it could help Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217424 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
Xml parsing xmlns issue
Im not the familiar with namespace usage in xml. When trying to us mx 7 to parse this im getting this message: The prefix xmlns cannot be bound to any namespace explicitly; neither can the namespace for xmlns be bound to any prefix explicitly. Not sure what these means in plain English. Should the xmlna point to a dtd that defines the elements products ? Any help would be great, Thanks gabe ?xml version=1.0 encoding=ISO-8859-1 ? rss version=2.0 xmlns:products=http://www.w3.org/2000/xmlns/; channel titlexxx Store Data Feed/title categoryxxx/category descriptionxxx data feed for product search results/description item pubDateFri, 2 Sep 2005 10:27:29 -0700/pubDate title![CDATA[UFC Embroidered Logo Sweatshirt]]/title linkhttp://test.test.com/detail.php?p=1933/link description![CDATA[Black hooded sweatshirt with xx logo embroidered on front and sleeve.]]/description guidhttp://test.test.com/detail.php?p=1933/guid products:id1933/products:id products:show_name![CDATA[UFC Store]]/products:show_name products:rank1/products:rank products:image_urlhttp://test.test.com/img/product/screens/1933-031815 ..jpg/products:image_url products:image_height85/products:image_height products:image_width85/products:image_width products:retail_price44.95/products:retail_price products:sale_price44.95/products:sale_price /item /channel /rss ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217405 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
Large recordsets turned into text file
Have an app. That needs to turn a query of about 150,000 records into a text file, zip it, send back to user. Using cf to loop and build the text file just wont work, it takes forever and often crashes. Someone mentioned a way todo it with php, by invoking a function that converts the record set in ram to a text file and then zips and send back. But we are stuck doing it on box with mx 6.0. Looked at having sql generate the file, but trying to avoid mapping drives to move it around. Anyone got an clever ideas? gabe ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216346 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: FCKeditor Fusebox4.1
I have, found it very easy to get rolling. The provide you with a very basic example of invoking it. Has anybody had any experience using FCKeditor, Fusebox4.1 and MVC using the CFC method of invoking the editor? Are there any examples available? In your opinion is FCKeditor easier to use than TinyMCE? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216345 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
Large recordsets turned into text file
Have an app. That needs to turn a query of about 150,000 records into a text file, zip it, send back to user. Using cf to loop and build the text file just wont work, it takes forever and often crashes. Someone mentioned a way todo it with php, by invoking a function that converts the record set in ram to a text file and then zips and send back. But we are stuck doing it on box with mx 6.0. Looked at having sql generate the file, but trying to avoid mapping drives to move it around. Anyone got an clever ideas? gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216362 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: OF-Test
?? Gabriel Bulfon Email:[EMAIL PROTECTED] -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 6:07 AM To: CF-Talk Subject: Re: OF-Test novato On 8/5/05, Rey Bango [EMAIL PROTECTED] wrote: Welcome back Gabriel. Que lo difrutas! Rey... Gabriel Bulfon wrote: Hi all guys. I am back with CF ! regards Gabriel Bulfon Email:[EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215324 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: CF-Talk: Digest every hour
Sorry, what is the meaning of buzzword ? Gabriel Bulfon Email:[EMAIL PROTECTED] -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 4:18 PM To: CF-Talk Subject: RE: CF-Talk: Digest every hour -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Well, AJAX is nothing more than a buzzword. People have been writing DHTML interfaces for years that do essentially the same thing. cfsetting mode=pedantic / DHTML is a buzzword and is nothing more than JS, CSS and DOM wrapped up together. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215323 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: CF-Talk: Digest every hour
Yes, thanks Gabriel Bulfon Email:[EMAIL PROTECTED] -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 6:44 PM To: CF-Talk Subject: Re: CF-Talk: Digest every hour Gabriel. It simply means that its a overused word to describe something. If we were talking cars, one of the buzzwords for cars today is Hybrid. If we were talking web communications technologies, a buzzword would be Webservices, and XML make sense? tony On 8/16/05, Gabriel Bulfon [EMAIL PROTECTED] wrote: Sorry, what is the meaning of buzzword ? Gabriel Bulfon Email:[EMAIL PROTECTED] -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 4:18 PM To: CF-Talk Subject: RE: CF-Talk: Digest every hour -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Well, AJAX is nothing more than a buzzword. People have been writing DHTML interfaces for years that do essentially the same thing. cfsetting mode=pedantic / DHTML is a buzzword and is nothing more than JS, CSS and DOM wrapped up together. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215368 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: consuming WS from XMLHttpRequest object
I have a confusion. Maybe some can light me.
Using XMLHttpRequest or Msxml2.XMLHTTP it very easy call a CFC web service.
The problem is that the caller call wsdl file ! I don't figure how connect
javascript with coldfusion.
If you try my code you receive the wsdl file. Of course, your are calling
wsdl file!.
script language=javascript
var req;
function GoTest()
{
req = false;
var ws_url = http://localhost/cf/XmlHttpRequest/Customers.cfc?wsdl;; //
your url
var ws_method = GET; // method here
// branch for native XmlHttpRequest object: Mozilla, Netscape, etc
if(window.XMLHttpRequest)
{
try
{
req = new XMLHttpRequest();
}
catch(e)
{
req = false;
}
}
// branch for IE
else if(window.ActiveXObject)
{
try
{
req = new ActiveXObject(Msxml2.XMLHTTP);
}
catch(e)
{
req = false;
}
}
if(req)
{
req.onreadystatechange = ProcessReqChange; /* Assign method to process
request */
req.open(ws_method,ws_url,true);
req.send(null);
}
}
function ProcessReqChange()
{
if (req.readyState == 4) /* complete */
{
if(req.status == 200)
{
// Clear textarea container
document.getElementById(ContainerTextArea).value = ;
document.getElementById(ContainerTextArea).value = req.responseText;
}
else
{
alert(There are a problem request Xml Data:\n + req.status + / +
req.statusText);
}
}
}
this code set ContainerTextArea Html element from html page.
any help ?
regards
On 8/14/05, wolf2k5 [EMAIL PROTECTED] wrote:
On 8/10/05, Thomas Chiverton [EMAIL PROTECTED] wrote:
Learn how to write SOAP XML requests, i.e. don't do that.
Isn't there any Javascript library to handle SOAP calls?
Why you recommend to don't do that? Performance reasons?
Thanks.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214952
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: CFEclipse 1.2
Congratulations ! I am very excited about cfeclipse. I am probing 1.2 right now. regards On 8/14/05, Damien McKenna [EMAIL PROTECTED] wrote: The CFEclipse crew is pleased to announce the immediate availability of CFEclipse 1.2. Congrats, I know a lot of people have been looking forward to this. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214953 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
problem displaying *.cfc?wsdl with internet explorer
Anybody have this problem? I tried to display web services wsdl file from ie. I don't see anything. I appreciate any help -- Gabriel Bulfon gbulfon[ARROBA]gmail[PUNTO]com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214362 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: problem displaying *.cfc?wsdl with internet explorer
it's a localhost url. http://localhost/cf/XmlHttpRequest/Customers.cfc?wsdl I can see wsdl with mozilla but not with IE regards On 8/10/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Can you provide the URL you are using? Dave -Original Message- From: Gabriel Bulfon [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 11:09 AM To: CF-Talk Subject: problem displaying *.cfc?wsdl with internet explorer Anybody have this problem? I tried to display web services wsdl file from ie. I don't see anything. I appreciate any help -- Gabriel Bulfon gbulfon[ARROBA]gmail[PUNTO]com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214369 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
consuming WS from XMLHttpRequest object
Hi all, how call ColdFusion Web Services directly from XMLHttpRequest instance ? Using open method (from XMLHttpRequest) to pass ws url. But, how call WS directly. In a cfinvoke you can specify method name trought cfinvoke's method parameter. But, how invoke method when only specify Url? TIA -gabriel -- Gabriel Bulfon gbulfon[ARROBA]gmail[PUNTO]com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214370 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: problem displaying *.cfc?wsdl with internet explorer
Thanks M!ke. I am sure the problem is caused by some component update or some similar. Any more have the problem? any solution ? regards On 8/10/05, Dawson, Michael [EMAIL PROTECTED] wrote: Recently, I have not been able to view *any* XML files in IE. I can't even view the source of an XML file. Something changed in IE that broke it. I can still view XML in Firefox, however. It certainly pisses me off. It may be your same problem. M!ke -Original Message- From: Gabriel Bulfon [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 10:09 AM To: CF-Talk Subject: problem displaying *.cfc?wsdl with internet explorer Anybody have this problem? I tried to display web services wsdl file from ie. I don't see anything. I appreciate any help -- Gabriel Bulfon gbulfon[ARROBA]gmail[PUNTO]com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214377 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: problem displaying *.cfc?wsdl with internet explorer
anything :( On 8/10/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 10 August 2005 16:08, Gabriel Bulfon wrote: Anybody have this problem? I tried to display web services wsdl file from ie. I don't see anything. Even if you view source ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214381 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: OF-Test
?? On 8/9/05, Dan O'Keefe [EMAIL PROTECTED] wrote: novato On 8/5/05, Rey Bango [EMAIL PROTECTED] wrote: Welcome back Gabriel. Que lo difrutas! Rey... Gabriel Bulfon wrote: Hi all guys. I am back with CF ! regards Gabriel Bulfon Email:[EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214242 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: Fck additional parameters
Cool that will work. -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 8:55 AM To: CF-Talk Subject: RE: Fck additional parameters fckconfig.js edit the default toolbar, or make your own one and tell fckeditor to use it... -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: 04 August 2005 13:33 To: CF-Talk Subject: Fck additional parameters Im trying to setup the fck editor and configure what buttons are displayed. I cannot find any documentation beyond the ... additional parameters ... I found something that ref. a default toolbar set, but cannot find any ref. to how to create your own or use another? Do you have to get medieval and go in and hack out the buttons you don't want? Thanks gabe fckEditor = createObject(component, fckEditorV2/fckeditor); fckEditor.instanceName=myEditor; fckEditor.basePath=/fckEditorV2/; fckEditor.value=This is my lt;stronggt;initiallt;/stronggt; html text.; fckEditor.width=100%; fckEditor.height=200; // ... additional parameters ... fckEditor.create(); // create instance now. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213919 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
OF-Test
Hi all guys. I am back with CF ! regards Gabriel Bulfon Email:[EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213955 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
Fck additional parameters
Im trying to setup the fck editor and configure what buttons are displayed. I cannot find any documentation beyond the ... additional parameters ... I found something that ref. a default toolbar set, but cannot find any ref. to how to create your own or use another? Do you have to get medieval and go in and hack out the buttons you don't want? Thanks gabe fckEditor = createObject(component, fckEditorV2/fckeditor); fckEditor.instanceName=myEditor; fckEditor.basePath=/fckEditorV2/; fckEditor.value=This is my lt;stronggt;initiallt;/stronggt; html text.; fckEditor.width=100%; fckEditor.height=200; // ... additional parameters ... fckEditor.create(); // create instance now. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213715 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
Invoking process on file upload
I thought I read some stuff about being able to invoke processes using the application.cfc file. Specifically im looking for something that will invoke a method on a file upload. Dug around in forta's books and online to no avail... Anyone got source of info? Thanks gab ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213238 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: Invoking process on file upload
Ack there goes that great idea Thanks man gabe -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 6:25 PM To: CF-Talk Subject: Re: Invoking process on file upload Event gateways are what you're looking for. CF7 Enterprise-only feature. cheers, barneyb On 7/28/05, gabriel l smallman [EMAIL PROTECTED] wrote: I thought I read some stuff about being able to invoke processes using the application.cfc file. Specifically im looking for something that will invoke a method on a file upload. Dug around in forta's books and online to no avail... Anyone got source of info? Thanks gab -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213241 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
To base64 and back again!
Hey all, trying to 1. take a string and base64(test) it 2. then need a way to bring it back to test I thought tostring would do the trick but no such luck. I know im missing something obvious. g ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211861 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: To base64 and back again!
Im a dumas: cfset v = This is a test cfset b = tobase64(v) Test string:#v#br Test string in base64: #b#br Test string from base64 to string: #tostring(tobinary(b))# Sorry not enough caffiniation before endeavoring gabe -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 10:45 AM To: CF-Talk Subject: To base64 and back again! Hey all, trying to 1. take a string and base64(test) it 2. then need a way to bring it back to test I thought tostring would do the trick but no such luck. I know im missing something obvious. g ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211862 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: Query of Query when date column may have a null (solution... Sort of)
Mx 7.0 solves it, seems to allow it to be a null and still select aok. -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Sunday, July 10, 2005 5:29 PM To: CF-Talk Subject: RE: Query of Query when date column may have a null Gabe, Great idea, works like a charm preventing the q in q error. I will just have to live with the display issue. If you had to end up using null date, you could always filter that date out in your when you display it--or better yet, filter it back out after you do your QoQ. -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211617 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
Query of Query when date column may have a null
Ran into an issue trying to perform a q in q on some data that contains nulls in a date field. It appears the field gets cast one way or the other and thus pops: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I need to pull the records even if they are null. Anyone run into this and come up with a workaround? Mx 6.1 gabe ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211508 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: Query of Query when date column may have a null
Great idea, works like a charm preventing the q in q error. I will just have to live with the display issue. Thanks dan gabe -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Sunday, July 10, 2005 2:52 PM To: CF-Talk Subject: RE: Query of Query when date column may have a null Gabe, Ran into an issue trying to perform a q in q on some data that contains nulls in a date field. It appears the field gets cast one way or the other and thus pops: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I need to pull the records even if they are null. Anyone run into this and come up with a workaround? Mx 6.1 If you're using MS SQL, you could use ISNULL() on the date fields to return an empty string instead of the null value. However, I suspect the problem is QoQ is choking trying to compare a date field to an empty string. If this is the case, you might have to try declaring some kind of null date (like 1/1/1900.) - Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211511 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: Query of Query when date column may have a null
Dan has a good work around, going to install cfmx 7.0 this week. Maybe if im lucky they will have solved it. gabe -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Sunday, July 10, 2005 3:28 PM To: CF-Talk Subject: RE: Query of Query when date column may have a null QofQ was and is a problem in CF. I run into a lot of problems with it myself and only experimentation helped resolve them - don't trust the online documentation as it is full of bugs. TK http://www.tomkitta.com -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Sunday, July 10, 2005 2:52 PM To: CF-Talk Subject: RE: Query of Query when date column may have a null Gabe, Ran into an issue trying to perform a q in q on some data that contains nulls in a date field. It appears the field gets cast one way or the other and thus pops: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I need to pull the records even if they are null. Anyone run into this and come up with a workaround? Mx 6.1 If you're using MS SQL, you could use ISNULL() on the date fields to return an empty string instead of the null value. However, I suspect the problem is QoQ is choking trying to compare a date field to an empty string. If this is the case, you might have to try declaring some kind of null date (like 1/1/1900.) - Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211512 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
Altering db causes error with perpaired statements
This has long irk'd me without a simple solution. When altering the db (add column) all the queries with prepared statements (aka cfqueryparam) that touch that table will toss an error about data types not right. Now that is expected, but purging them is the trick. As of right now the only way I can get the queries working again is: 1. alter the query in any way, like add a single white space 2. restart cf server 3. restart sql server Anyone got any tricks? I tried re-starting the odbc clients to no avail. Cf 6.2 Sql server 2k Win 2003 OS Thanks gabe ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211172 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: Altering db causes error with perpaired statements
Lol - boy that wasen't so bad Thanks isaac gabe -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 05, 2005 3:17 PM To: CF-Talk Subject: Re: Altering db causes error with perpaired statements This has long irk'd me without a simple solution. When altering the db (add column) all the queries with prepared statements (aka cfqueryparam) that touch that table will toss an error about data types not right. Hey Gabe... The simple solution (you'll love this) is to disable the statement pool on your datasource... This eliminates the issue completely and doesn't noticeably affect performance. CF Admin Data Sources [yourdsn] Advanced Settings Max Pooled Statements = 0 s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211178 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
cfencrypt
Anyone one know behind the scenes what type of encryption this performs? Just trying to see if its industry standard or a homegrown effort. Thanks gabe ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210695 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: cfencrypt
Thanks a ton -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 8:03 AM To: CF-Talk Subject: RE: cfencrypt Default Encryption Standard using Electronic Code Book type encryption. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 12:59 To: CF-Talk Subject: RE: cfencrypt What's that in plain English? -Original Message- From: Neculai Macarie [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 13:56 To: CF-Talk Subject: Re: cfencrypt Anyone one know behind the scenes what type of encryption this performs? Just trying to see if its industry standard or a homegrown effort. DES in ECB mode. -- mack / ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210750 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
Queryparam flush
I have an issue anytime I update my db structure. The queries im using with queryparams that reference the modified table toss data type mismatch errors. I assume this is because the prepared statement is no longer is in sync with the table. I have only been able to correct by restarting cf or the db. I have tried refresh the cf odbc services to no avail. Anyone know a sql command to purge all prepared statements? Gabe Ps. Using ms sql 2000 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207430 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
Fusebox dir structure so sensative stuff not web accessable
Im trying to figure out how in a production environment you would build your folder structure and choose a webroot so that the view and parsed etc. folders are not web accessible. So right now Controller Model View Parsed Plugins And I would think making the controller the web root. Only issue in in root fusebox.xml.cfm when im creating alias's are these figured from the web root? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204730 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: Fusebox dir structure so sensative stuff not web accessable
I'm down with the 2nd option, thanks Brian gabe -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 12:46 PM To: CF-Talk Subject: Re: Fusebox dir structure so sensative stuff not web accessable Well you can just set the model and view circuits to have access=internal and no external users can call anything in them. Or you can elect to move the entire application (controller, model, view, parsed and plugins) out of the web root and just have your index.cfm file in the web root. In your index.cfm file, where you include the core file, just use a relative path from your web-accessible directory to wherever your application code is, like this: cfinclude template=../mynonwebaccessibledir/fusebox4.runtime.cfmx.cfm If you keep the Fusebox XML file along with the rest of your application, the circuit mappings are the same (relative to the fusebox.xml file). On 4/27/05, gabriel l smallman [EMAIL PROTECTED] wrote: Im trying to figure out how in a production environment you would build your folder structure and choose a webroot so that the view and parsed etc. folders are not web accessible. So right now Controller Model View Parsed Plugins And I would think making the controller the web root. Only issue in in root fusebox.xml.cfm when im creating alias's are these figured from the web root? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204762 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: Fusebox dir structure so sensative stuff not web accessable
Issue with #2 fb_.application.fusebox.approotdirectory = fb_canonicalPath(fb_.application.fusebox.webrootdirectory fb_.appPath, fb_.osdelimiter); This is used to locate the fusebox.xml files and others, notice it starts with the web root, thus it looks like you must have all core files in your webroot I think. gabe -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 12:46 PM To: CF-Talk Subject: Re: Fusebox dir structure so sensative stuff not web accessable Well you can just set the model and view circuits to have access=internal and no external users can call anything in them. Or you can elect to move the entire application (controller, model, view, parsed and plugins) out of the web root and just have your index.cfm file in the web root. In your index.cfm file, where you include the core file, just use a relative path from your web-accessible directory to wherever your application code is, like this: cfinclude template=../mynonwebaccessibledir/fusebox4.runtime.cfmx.cfm If you keep the Fusebox XML file along with the rest of your application, the circuit mappings are the same (relative to the fusebox.xml file). On 4/27/05, gabriel l smallman [EMAIL PROTECTED] wrote: Im trying to figure out how in a production environment you would build your folder structure and choose a webroot so that the view and parsed etc. folders are not web accessible. So right now Controller Model View Parsed Plugins And I would think making the controller the web root. Only issue in in root fusebox.xml.cfm when im creating alias's are these figured from the web root? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204788 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
Tag defs for homesite+/studio for mx 7
Anyone know if MM published a set of tag updates? Thanks gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201296 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: Tag defs for homesite+/studio for mx 7
Many thanks gabe -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, April 03, 2005 11:51 AM To: CF-Talk Subject: RE: Tag defs for homesite+/studio for mx 7 From: gabriel l smallman [mailto:[EMAIL PROTECTED] Anyone know if MM published a set of tag updates? http://www.macromedia.com/software/coldfusion/downloads/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201298 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
another accent problem
0k... cfmx 7 running somewhere in cyberspace. I really hope someone has the answer to this issue. I am querying a mysql db. I cannot, for the life of me, get accents to display properly. see http://www.vertelligence.com/index.cfm?view=labels for proof. weird looking y carachters are directly in the cfm template. the word that should say Français but says something like it, comes from a mysql db. here is my encoding stuff from my Application.cfm cfapplication name=#appName# sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# cfprocessingdirective pageencoding=iso-8859-1 cfcontent type=text/html; charset=iso-8859-1 cfif not isDefined(cookie.langPref) cfcookie name=langPref value=1 /cfif cfscript setEncoding(form, iso-8859-1); snip other stuff /cfscript if anyone has any idea how to solve this i would really appreciate the help. TIA!! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199640 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: french character problem
is this a joke? Is this really how I solve this problem? I just saw this message. How on earth do i convert ALL my files? One by one? is there an easy way to do this? Can I do this in Dreamweaver? And why the hell did MM do something so F(*)ING STUPID. HELLO THE WORLD DOES NOT ONLY SPEAK ENGLISH. TIA Gabriel On Sun, 27 Feb 2005 18:09:51 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: I have a bunch of french characters, not even being read from a database, straight text, that will not display properly when thay are inside a .cfm template. Ah ah, j'ai eu ce problème-là moi aussi mon vieux ! I suppose you are under CFMX, or that you recently moved to CFMX? The problem is that CFMX is now forcing all text to be UTF-8. I know it is a real plus, but for us using only European languages for which ISO-8859-whatever was perfectly doing the job, it is a PITA. The solutions: 1º use an editor able to create files in UTF-8, and convert all your existing files in UTF-8 (This was suggested here by someone else, so please don't shoot me ;-) 2º add this in your Application.cfm: CFSET CFversion = listGetAt(server.coldfusion.productVersion, 1) CFIF CFversion GT 5 cfcontent type=text/html; charset=ISO-8859-1 cfset setEncoding(url,ISO-8859-1) cfset setEncoding(form,ISO-8859-1) /CFIF (the test for the version is not mandatory, especially if you have the same version on your development and production server.) I take the opportunity here first to thank the person who gave me the trick, secondly to express my anger at MM who didn't put this UTF-8 behavior as an option in the CF administrator, and designed it so the new version is not compatible with the previous by default. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199642 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: french character problem
ok.. thank you!!! I will give this a try. Will have to get the folks on the hosting side to cooperate on this one. Gabriel On Tue, 22 Mar 2005 12:42:41 +0700, Paul Hastings [EMAIL PROTECTED] wrote: Gabriel Robichaud wrote: is this a joke? Is this really how I solve this problem? it's one way. I just saw this message. How on earth do i convert ALL my files? One unifier, http://www.melody-soft.com/html/unifier.html, works a treat if you do a lot of i18n work is certainly worth $15 US. by one? is there an easy way to do this? Can I do this in Dreamweaver? you probably don't have to do it at all. if you're happy with iso-8859-1 (which you know doesn't contain the euro symbol): in application.cfm cfcontent type=text/html; charset=ISO-8859-1 cfset setEncoding(url,ISO-8859-1) cfset setEncoding(form,ISO-8859-1) on each cf page: cfprocessingdirective pageencoding=iso-8859-1 for that mysql dsn (advanced option, connection string): useUnicode=truecharacterEncoding=iso-8859-1 (not sure it could also be iso88591, check the mysql docs). or if you want the whole server to just deliver latin-1 changed the defaultCharset value in cf_root/lib/neo-runtime.xml file: var name='defaultCharset'stringUTF-8/string/var replace utf-8 with the charset you want. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199645 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
Simple way to get row before and after
Im trying to obtain the IDs of the rows before and after say ID 4. So if I have 4, I need to find 1 and 7 (note row ids will not be sequential) I would prefer not to pull entire list, and loop to find id 4 and grab the row # before and after. If db gets big this could get slow. ID CATID Title 1 8 hello moto 4 8 this is good 7 8 can you dig it 14 8 try again Anyone have an idea that might be more efficient? Thanks gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196784 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: Simple way to get row before and after
Perfect, just what I was looking for. Need more caffine maybe to find simple solutions, thanks ade gabe -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 11:15 AM To: CF-Talk Subject: RE: Simple way to get row before and after Of the top of my head... SELECT ID, (SELECT TOP 1 ID FROM YourTable WHERE ID 4) 'Before', (SELECT TOP 1 ID FROM YourTable WHERE ID 4) 'After' FROM YourTable WHERE ID = 4 Ade -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: 28 February 2005 16:10 To: CF-Talk Subject: Simple way to get row before and after Im trying to obtain the IDs of the rows before and after say ID 4. So if I have 4, I need to find 1 and 7 (note row ids will not be sequential) I would prefer not to pull entire list, and loop to find id 4 and grab the row # before and after. If db gets big this could get slow. ID CATID Title 1 8 hello moto 4 8 this is good 7 8 can you dig it 14 8 try again Anyone have an idea that might be more efficient? Thanks gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196799 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
french character problem
Hey everyone, I have a bunch of french characters, not even being read from a database, straight text, that will not display properly when thay are inside a .cfm template. The same characters inside a .html will display appropriately. I have tried using cfcontent, does not change anything, characters are displayed as garbage text. some weird upside down y. environment : linux, apache, cfmx 6.1 Any ideas? here is the cfml example. cfcontent type=text/html; charset = iso-8859-1 html head titleTest Page/title /head body testing old style html accents nbsp;Aacute;eacute;euml;br testing chars as they are typed Àéè /body /html you can see this in action at http://blog.gabrielrobichaud.com/testaccent.cfm TIA!! Gabriel ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196727 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: french character problem
I have solved this issue with the cfprocessingdirective woo hoo Hey everyone, I have a bunch of french characters, not even being read from a database, straight text, that will not display properly when thay are inside a .cfm template. The same characters inside a .html will display appropriately. I have tried using cfcontent, does not change anything, characters are displayed as garbage text. some weird upside down y. environment : linux, apache, cfmx 6.1 Any ideas? here is the cfml example. cfcontent type=text/html; charset = iso-8859-1 html head titleTest Page/title /head body testing old style html accents nbsp;Aacute;eacute;euml;br testing chars as they are typed Àéè /body /html you can see this in action at http://blog.gabrielrobichaud.com/testaccent.cfm TIA!! Gabriel ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196733 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: Gzip compression and caching system
Found a solution: http://www.markme.com/cantrell/archives/002658.cfm I have just tested it with gzip'd content from db using the proper headers Jochem suggested.. Whamo! ContentType=text/html Content-Encoding=gzip gabe For compression, don't use Content-Disposition and Content-Type, use Content-Encoding or possibly Transfer-Encoding. See RFC 2616. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195658 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
Gzip compression and caching system
Im working on a tag to wrap around content and then save it to a file, gzip it and serve it out. Expanding on the cf_GZipPage custom tag. But trying to take is a step further. I would like to save the gzip'd binary data in the db. Main reason is the expected amount of gzipped files could be well over 100k. I would prefer to not let the file system handle finding and reading the data. Issue is I cannot figure out how to read the binary data from the db and serve it back out so the browser recognizes the mime type and encoding. Right now the only way I can get it work is if I save the data to a file and: cfheader name=Content-Encoding value=gzip cfcontent file=#Attributes.Directory#\#Attributes.CacheKey#.gz type=text/html Anyone have an idea? Or am I stuck with reading it from a file? gabe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195542 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
